TOURNAMENT -- SHINE A LIGHT ON NF.

Hello everyone. We are aware that sqs are now showing up as no one on them even though people are on them. We are looking into why this is and are working into fixing this

Do you know of any battles that have happen in between the the time you posted to 27.05.2016 06:30:27 (server time). (if you do please send me the battle reports so I can check what the issue is (code issue or missing API key issue)) Here is what i know that happen. At 27.05.2016 06:30:27 REX_GAMBIT (Crow's Nest)'s army clear the sq of eCrow troops and the army was set to just attack and then at 27.05.2016 07:57:24 The Colonist Empire  landed on the sq and didnt see any battles until 27.05.2016 13:15:13.

Edited by kodabear - 27 May 2016 at 16:03

Indeed. :)
We've got a table for general reports, one for armies and one for divisions. The division table has the actual troop numbers. Getting that number means doing a join between the general report and the army table and then again with the division table. And that's taking way too long for the amount of data we have.
So I just added the troop and attacker/defender data to the general reports as well. Problem solved. :)
The army & division tables are still filled because with these we can provide more detailed statistics in case we want them.

Some little database optimisations can work wonders sometimes. :)
In some cases it might be better to NOT rely on the 3rd normal form of databases because that involves a lot of joining between different tables to get the data you want.

Currently I have a list of 56+ people of players that have taken part in battles and I dont have an API key for. after much debating with my self I decide that I wont be posting a list of players who I dont have API keys from but have taken part in battle. main reasoning for this is that doing complete database updates take a lot of time and i feel its on the alliance/player to make sure they have submitted there API key. and last reason i have is because some players dont care to much.  I will still take API keys from players who still want to submit ( if you do submit an API key please send me your current one so i am able to record all your combats unfortunately if you havent create an API key or created a new one your combats/occupation times (if you were by your self) will be missed and i still plan doing a complete database update at the end so you have until then to submit API key. If you dont know if you have or havent submit an API key you are welcome to send me an IGM to find out.

Edited by kodabear - 25 May 2016 at 19:15