Player Created Tournaments

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Progress report

Pretty much all my coding time is going into this and I am slowly but surely finding bugs and fixing them.

I recently had to completely re-design the database that holds the data from the submitted reports and this resulted in having to re-work all the serverside scripts that access it. Most of that is now done. During this I found some errors in my logic for parsing the XML that meant all the data stored on casualties for both sides of the battle were wrong - I'm now pretty sure I've got that sorted and will be pushing that change out very shortly.

A side effect of working on that was I also realised that a battle where the attacker lost no troops would crash the system. The cause of this is that things like the Kill Ratio are:

 Defenders killed
Attackers killed
Looks inoccuous but computers really don't like trying to divide by 0. A simple solution would be to replace 0 attackers lost with 1 attackers killed when storing the report but that would destroy the integrity of the stored data so that option was discarded. I also didn't like the fact that this approach would show no difference in the ratio if the attacker lost 0 troops or 1 troop so I decided to go for 0.9 instead of 1 as the divisor.
The way the system works is that all the calculations are done by the database so that meant I had to go do a load of reading on how I could incorporate all of that into the database query. Again, pretty sure I've now got that worked out.

I've added a 'Terms Explanation' button that hopefully will explain what I mean by things like MDQ and how they affect the results. If there are any parts/terms that you're still not clear on please ask.

I'm now working on double checking and tweaking the Tournament Management part of the system. I need to make sure that this part of the system is as foolproof as possible so that those without great computer skills can also create and run tournaments.

In summary, I'm not there yet but certainly getting closer 

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
Tensmoor Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1579	Post Options Post Reply Quote Tensmoor Report Post Thanks(0) Quote Reply Topic: Player Created Tournaments Posted: 25 Jan 2020 at 07:59
	Progress report Pretty much all my coding time is going into this and I am slowly but surely finding bugs and fixing them. I recently had to completely re-design the database that holds the data from the submitted reports and this resulted in having to re-work all the serverside scripts that access it. Most of that is now done. During this I found some errors in my logic for parsing the XML that meant all the data stored on casualties for both sides of the battle were wrong - I'm now pretty sure I've got that sorted and will be pushing that change out very shortly. A side effect of working on that was I also realised that a battle where the attacker lost no troops would crash the system. The cause of this is that things like the Kill Ratio are: Defenders killed Attackers killed Looks inoccuous but computers really don't like trying to divide by 0. A simple solution would be to replace 0 attackers lost with 1 attackers killed when storing the report but that would destroy the integrity of the stored data so that option was discarded. I also didn't like the fact that this approach would show no difference in the ratio if the attacker lost 0 troops or 1 troop so I decided to go for 0.9 instead of 1 as the divisor. The way the system works is that all the calculations are done by the database so that meant I had to go do a load of reading on how I could incorporate all of that into the database query. Again, pretty sure I've now got that worked out. I've added a 'Terms Explanation' button that hopefully will explain what I mean by things like MDQ and how they affect the results. If there are any parts/terms that you're still not clear on please ask. I'm now working on double checking and tweaking the Tournament Management part of the system. I need to make sure that this part of the system is as foolproof as possible so that those without great computer skills can also create and run tournaments. In summary, I'm not there yet but certainly getting closer

eowan the short Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster Joined: 03 Jan 2016 Location: UK Status: Offline Points: 937	Post Options Post Reply Quote eowan the short Report Post Thanks(0) Quote Reply Posted: 21 Jan 2020 at 20:36
	Looks great! ⠀
	This is the thread that never ends, yes it goes on and on my friend. Some person started it, not knowing what it was, and we'll continue posting on it forever just because...

Tensmoor Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1579	Post Options Post Reply Quote Tensmoor Report Post Thanks(0) Quote Reply Posted: 21 Jan 2020 at 17:47
	Suppose a link to it would be handy... https://illystuff.uk/tourneyMaker/

Tensmoor Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1579	Post Options Post Reply Quote Tensmoor Report Post Thanks(0) Quote Reply Posted: 21 Jan 2020 at 17:40
	New Version ready for testing The revised database and code is now ready for testing/evaluation. I've created 4 tournaments for folks to look at and evaluate. Unfortunately all the previously submitted reports were not compatable with the new version of the database and software. I've also added a bunch of battle reports from my main account to each of them so you can have a look at how they currently work. If you want to you can also add your own battle reports to any of them (I hope you do). Restrictions on battle reports: The battle must have taken place during the period of the tournament. It must be a battle where you attack an NPC. For the purpose of this factions are not counted as NPCs. To include a report in more than one tournament you have to add it to each separately. The management of tournaments is currently disabled. I'm currently working on a help file that will explain the various terms used and how the calculations are done. All feedback/suggestions (good, bad or indiferent) are more than welcome.

DeliciousJosh Members Profile Send Private Message Find Members Posts Add to Buddy List Forum Warrior Joined: 14 Jun 2012 Location: Denmark Status: Offline Points: 417	Post Options Post Reply Quote DeliciousJosh Report Post Thanks(0) Quote Reply Posted: 13 Jan 2020 at 05:55
	Great Tens, Ill get testing and send some reports! Also, does the calculation MDQ mean that the fewer units we send to kill those larger NPC,the more points it gives? Say I send 300 kights equipped in elite division armies to kill a legion of rats. Would that give me more points than if I sent 1000 knights?
	PublicRelations HumanResources

Tensmoor Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1579	Post Options Post Reply Quote Tensmoor Report Post Thanks(0) Quote Reply Posted: 12 Jan 2020 at 23:45
	Below is a screenshot summarizing the calculations done by the system at present. Edited by Tensmoor - 12 Jan 2020 at 23:48

Tensmoor Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1579	Post Options Post Reply Quote Tensmoor Report Post Thanks(0) Quote Reply Posted: 12 Jan 2020 at 17:23
	Request for help testing and developing Hi folks. I've created a tournament that I will use to help me create the code to produce results sets for tournament creators. To do this I need as many different players of all sizes to submit hunting reports to it. Just follow the link below then having read the instructions on the right side of the page, click Tournaments and then select the Initial Test Tournament to submit your reports. There will not be any prizes for this tourney but everyone who submits reports will have my thanks. https://illystuff.uk/tourneyMaker/index.html Tens

Tensmoor Members Profile Send Private Message Find Members Posts Add to Buddy List Postmaster General Joined: 07 Apr 2015 Location: Scotland Status: Offline Points: 1579	Post Options Post Reply Quote Tensmoor Report Post Thanks(0) Quote Reply Posted: 12 Jan 2020 at 09:35
	All the comments are much appreciated folks. Been working on the Tourney management side of things and have got the parts done to create and edit a tourney. Still got some way to go on the editing side though. If the restrictions of a tournament (regions or alliances) are changed that may affect any reports already submitted for it so I need to write some code to handle that - probably going to be a nightmare as usual After that I need to create a method for the tourney creator to be able to download the details of all reports submitted to their tournaments. Same query as for showing the tournament standings coupled with the same code that I used for the download in the price grabber tool. Few other things bubbling away in the braincell but a bit early to say if any of them will work or not. Tens

OssianII Members Profile Send Private Message Find Members Posts Add to Buddy List Forum Warrior Joined: 05 Sep 2017 Location: Penarth Status: Offline Points: 302	Post Options Post Reply Quote OssianII Report Post Thanks(0) Quote Reply Posted: 12 Jan 2020 at 09:14
	Guid mornin ye auld skinflint. This half eaten haggis of a tool might have it's uses. Mark my words - I only said might, mind ye.
	“If anyone was to ask for my opinion, which I note they’re not, I’d say we were taking the long way around.” Gimli son of Gloin.

GM Stormcrow Members Profile Send Private Message Find Members Posts Add to Buddy List Moderator Group GM Joined: 23 Feb 2010 Location: Illyria Status: Offline Points: 3820	Post Options Post Reply Quote GM Stormcrow Report Post Thanks(1) Quote Reply Posted: 11 Jan 2020 at 19:10
	This is pretty darn fantastic, Tens - and I hope the system gets used extensively! Really, really amazing stuff. /me showers plaudits SC