TOURNAMENT -- SHINE A LIGHT ON NF.

Here is what i will do. I am going to post what the other database currently looks like as far but keep in mind it is still running started running 2016.030.22 09:37:30: Starting update. and it currently has scan though 5038 out of 7407 and the last time it was updated was "" Last database update was at: 20.05.2016 17:27:08""   and that scan started at 2016.029.20 17:27:29: and finshed scanning at 2016.033.21 20:31:33:  Top occupying alliances:

Rank:	Alliance:	Duration:
1	Valiant Crows	54 days, 13 hours, 19 minutes, 4 seconds
2	Holy Storm Company	37 days, 11 hours, 20 minutes, 4 seconds
3	Slaves to Armok	26 days, 16 hours, 5 minutes, 33 seconds
4	The Colonist Empire	26 days, 8 hours, 29 minutes, 52 seconds
5	Wheel of Time	18 days, 21 hours, 10 minutes, 48 seconds
6	EAGLES EYRIE	18 days, 5 hours, 18 minutes, 59 seconds
7	Order of the Orc	17 days, 16 hours, 50 minutes, 50 seconds
8	Eight Hand Crow	16 days, 18 hours, 26 minutes, 6 seconds
9	Murder of Crows	16 days, 5 hours, 29 minutes, 39 seconds
10	Illyria Fairy Nation	15 days, 14 hours, 43 minutes, 52 seconds
11	Shrapnel's FDU	14 days, 9 hours, 4 minutes, 13 seconds
12	Crow's Nest	12 days, 6 hours, 41 minutes, 27 seconds
13	Roman Empire	11 days, 19 hours, 33 minutes, 48 seconds
14	Harmless?	8 days, 19 hours, 10 minutes, 6 seconds
15	The Fellowship	7 days, 21 hours, 40 minutes, 54 seconds
16	Love And Freedom	6 days, 20 hours, 16 minutes, 46 seconds
17	The Gateway	6 days, 10 hours, 51 minutes, 55 seconds
18	Æsir	6 days, 7 hours, 51 minutes, 52 seconds
19	Fairy Road Authority	6 days, 0 hours, 51 minutes, 28 seconds
20	Achaean's League	5 days, 23 hours, 18 minutes, 51 seconds
21	Skeleton Boar	5 days, 23 hours, 4 minutes, 21 seconds
22	Southland Sentinels	5 days, 4 hours, 30 minutes, 52 seconds
23	Dwarven Druids	3 days, 14 hours, 37 minutes, 18 seconds
24	The Cave	3 days, 3 hours, 41 minutes, 8 seconds
25	Dwarven Lords	1 days, 19 hours, 52 minutes, 16 seconds
26	The Pirate Republic	0 days, 22 hours, 59 minutes, 37 seconds
27	PRAEVALEO	0 days, 16 hours, 7 minutes, 56 seconds
28	Chaos	0 days, 12 hours, 17 minutes, 54 seconds
29	Republic of F.Cities	0 days, 7 hours, 15 minutes, 46 seconds
30	Dwarven in-law	0 days, 2 hours, 8 minutes, 43 seconds
31	Hogwarts at Illyriad	0 days, 2 hours, 3 minutes, 57 seconds
32	Toothless?	0 days, 0 hours, 3 minutes, 36 seconds

Count Rupert wrote: I guess I'm puzzled why if we're through the initial batch of combat reports, why it hasn't been fixed since this occurred quite early in the tournament.  Wouldn't the error have occurred somewhere in those 14124 combat reports?  It shouldn't even be in the 14 hours unless the error is still occurring on battles in Windlost.

I understand that adding features can be difficult to implement during the tournament.   However, is it possible to locate a list of all players on the statistic page whom have submitted valid api keys in order to participate?

The reason I ask is that there has been some concern about some player attacks showing up from alliances that do not appear to be holding squares and are therefore not listed on the tournament page.  Since not occupying is a valid strategy and even the use of alts with valid api keys to “support” other alliances isn’t out of bounds it still raises questions of player integrity and perhaps even tournament transparency when it is regularly occurring during the event.

Whist there may not currently be any solution or technical means to prevent such activities, it would be helpful to know whether or such players are simply being spoilers and distruptive to the spirit and intent of an event.

Perhaps the devs could someday provide for a paid lockout period for tourney squares preventing non-registered event participants from landing on them but in the meantime the only way for the rest of the playerbase to fully understand a players’ intent is to know whether or not they are participating honestly.

Thank you again for all the hard work and effort in organizing and running this event.  Is there any chance you would make your tools available in the future should other players want to organize similar activities?

Best Regards,
Baltek

Good enough for me Koda.  Thank you for taking the time to reply!  

My general idea was to create a tournament system that is open to other players as well.
The system is written to support multiple tournaments running at the same time.
Right now it doesn't have any admin interface, though. Since both Koda and me are able to use phpMyAdmin to manage the database that was neccessary and left me time to work on other things.

But yes, writing an admin-interface so that everyone can run tournaments is on my todo-list.
In the future I'm also thinking of moving from MySQL to a PostgreSQL database. This should provide better performance. Right now that's not really possible because I'm focussing on keeping the tournament running and also because I'm using some MySQL features that PostgreSQL doesn't have built-in. So that requires further development time.