Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Managing results/championship table: offering help :)
#21
So, finally something to "show" ;D

This version allows to create a championship, manage the results (by importing rf2 .xml-File) and automatically creates and maintains the championship-table.

Creating the Championship:
One can add all the drivers at the time one creates the championship or don't add any driver at all. By the time one imports a result, drivers which aren't already in the database (db) will be added automatically. Drivers who are in the db but don't take part in the respective championship will be added to the championship. A messagebox will tell which drivers have been added after one imported the .xml-File.
This is probably the better way than adding all drivers by hand, as typos and/or not correct names (e.g. Gorka Santisteban instead of Gorka Santisteban[SR4L]) would lead to "duplicate" entries. This akso means that if a new driver joins the server he will be added automatically. The automatically added drivers must then be assigend to their teams manually but this feature isn't implemented yet.

At the moment one has to add all teams and tracks by the time he creates the championship but in the end one will be able to add/modify/remove teams and tracks at a later stage too, its just not implemented yet.

Known Issues and Todos:
- possibility to add/modify/remove drivers, teams and tracks at later stage
- team championship table
- the driver champioship table looks sometimes a bit strange, a change to the teams-tab and back to the drivers-tab fixes this for the moment
- its not extensively tested, input of bad data could (but must not) lead to strange results
- possible layout issues (some texts are cropped for example)
- cross-check if <Pitstops></Pitstops> value is right, by comparing to <Lap></Lap> (see below)
- more feedback for users
- a user-manual (maybe ...)
- some others I can't think of right now: me = tired ^_^

If someone wants to try it out, the program is attached as a zip-File. To run it, unpack it und just start the rf2_Championshiptool.exe. One might have to install .Net Framework 4.5 to be able to run it. One can get it here: http://www.microsoft.com/en-us/download/...x?id=30653

There is already one championship in the db. Its the one I created using the result-files of the two Brianza races. Apart from a one point difference, which most probably is down to me using a different points-system and Nikos having less points because he doesn't make 80% of laps in first race (16, he would have needed 17) in my program, it shows the same championship standing as the one posted by Tim (the one he made by hand).

The program should be pretty straight-forward to use, if you have questions just ask Smile

One issue I encountered with the .xml-File was that it showed
<Pitstops>0</Pitstops>
for one player (can't remember which one) while he had pitted, which could be seen by the
<Lap num="9" ... pit="1">120.5623</Lap> line. I then just changed the value in the .xml-File from 0 to 1 and re-imported the file.

Other than that I didn't encounter a issue with the xml-File, apart from the ones discussed in earlier posts (= <Pos></Pos> values wrong).

[Image: the_art_of_happy_programming.png]
makes me chuckle every single time ;D ;D


Attached Files
.zip   Release.zip (Size: 573.81 KB / Downloads: 3)
Reply
#22
I will be playing with it tomorrow thanks so much
Reply
#23
looks good if you fix some things, cant add enough drivers, cant edit anything after create championship, points from race results page does not plug into championship page, cant enter team names on teams page. love the set up, love how results page loads n looks. very easy to use, where is championship stored if I want to delete a championship?
Reply
#24
cant add enough drivers: you should be able to. just tested it, the layout isn't good but there appears a scroll-bar on the right side after adding a specific number of drivers

cant edit anything after create championship: yep, will add this feature soon

points from race results page does not plug into championship page: hm strange, this does work for me

cant enter team names on teams page: teams page will show the teams chapmionship table eventually, not implemented yet

where is championship stored if I want to delete a championship: everything is stored in a database. I will add a function to delete an existing championship
Reply
#25
I will try adding names again to see if I missed something
see attachment about points transfer did I miss a step?


Attached Files
.docx   Document1.docx (Size: 583.43 KB / Downloads: 1)
Reply
#26
Thanks for the screenshots, there seems to be an issue :-[ will fix this ;D

The table should update automatically, so you didn't miss a step. It worked for me because I only had one championship, so there was no conflict.
Reply
#27
ok the enter drivers page does work ok my error
its going to be awesome to work with
Reply
#28
activities report:
- (hopefully)fixed the bug Tim encountered
- added Roundnumber to table RaceResult. This allows rearranging of events if a new one is adeed or one event gets postponed
- added functionality to delete a championship
- some small layout adjustments

will at least add the following feature before I upload a new new version:
- possibility to add/modify/remove drivers, teams and tracks at later stage

This will hopefully be done by tomorrow evening at the latest Smile
Reply
#29
SWEET
Reply
#30
c.pucher Wrote:will at least add the following feature before I upload a new new version:
- possibility to add/modify/remove drivers, teams and tracks at later stage
This will hopefully be done by tomorrow evening at the latest Smile

Implementation of this is more or less done but needs some more testing from my side, not sure I'm going to make it tonight. Now off to football/soccer, will see later Smile
Reply
#31
New Version attached, changes:
- (hopefully)fixed the bug Tim encountered
- added Roundnumber to table RaceResult. This allows rearranging of events if a new one is adeed or one event gets postponed
- added functionality to delete a championship
- some small layout adjustments
- possibility to add/modify/remove drivers, teams and tracks at later stage
- check if right file (rf2, race-result xml-file) gets imported

Known bugs and some information
- the driver champioship table looks sometimes a bit strange, a change to the teams-tab and back to the drivers-tab fixes this for the moment
- after importing a xml-file the result won't show at some occasions (don't know why), re-importing the xml-file did fix this for me all the time
- drivers/teams already added to the database can't be deleted. This is by design. Have to make my mind up about this and maybe will add the option to do so in the future.
- if one changes the championship-rules (pontssystem, extra points for poleposition/fastest lap and so on ...) after some results have already been added the changes won't affect these results. One will have to open and re-import the specific xml-file again for the changes to take part (so one should keep the xml-files)

Missing features
- strike results don't work at the moment
- team-championshiptable doesn't work at the moment
- user-manual
- cross-check if <Pitstops></Pitstops> value is right, by comparing to <Lap></Lap> (see below)
- more feedback for users

Sorry, took me a bit longer than I thought Smile Hope this version works as it should, last testing went well and I didn't encounter any bug hope there is none.
Won't add new features in the next two weeks or so as I will be busy with learning for exams. Will do bug fixes though Wink


Attached Files
.zip   Release.zip (Size: 583.5 KB / Downloads: 2)
Reply
#32
its a beautiful thing everything seems to work great so far. I do have a problem tho. The xml file does not show all that started race and I don't know how we can change that I will ask Paul. It would be nice if I could edit the points in the championship to give everyone their points. I tried and the box highlights but wont change. Can we fix that or no?
It really is awesome Chris thank you for your efforts good luck with studie.

oh I also tried to put a number like .1 in the % box but it didn't help
Reply
#33
Great work you two, much appreciated by all of us !
[Image: p8xN8ZK.png]
Reply
#34
Chris did all the work I am just the happy recipient.
Reply
#35
bullwinkle Wrote:The xml file does not show all that started race and I don't know how we can change that I will ask Paul.
oh I also tried to put a number like .1 in the % box but it didn't help
I asked Paul for the server xml-file and he said he will send it to me. I will check if this file is more complete Smile
Who is missing in yours for instance?

bullwinkle Wrote:It would be nice if I could edit the points in the championship to give everyone their points. I tried and the box highlights but wont change. Can we fix that or no?
I'm not sure I understand this correctly. Points should be calculated correctly I guess? Would you like to edit points for a single race/event or the totalpoints?

bullwinkle Wrote:oh I also tried to put a number like .1 in the % box but it didn't help
0 should work
ah, at the moment I check if driver "Finished Normally" and only award points if he did so. So "DNF" won't give you points, which is wrong of course. If I change that I think it should work like you want? Will upload a new version if you can confirm this Smile

Attached is a picture which shows two championshiptables, one where drivers have 0% laps to be completed and the other with 70%.

Another feature I will add:
- possibility to easily copy the championshiptable to a forum


Attached Files Thumbnail(s)
   
Reply
#36
here is my race result with 0 laps.
in race 2 I know Ed and Jerry raced but they are not on xml
if I would edit single race would it transfer to total points?
yes it need to consider all starters including dnf


Attached Files
.docx   Document.docx (Size: 178.38 KB / Downloads: 1)
Reply
#37
in case you couldn't read the last one
[url][Image: Document-page-001_zps25picndt.jpg][/url]
Reply
#38
Yes it would transform to totalpoints as totalpoints get calculated from the points of each race. So would you need the possibility to edit the points just in case a driver is missing or is this a feature you generally want?

Regarding missing drivers, I hope the server file got this right. If so there is no need to change anything and we would have to ask Paul to send/upload the server xml file after each race. If you feel comfortable in doing so you can always edit the xml-file on your own, and add the missing drivers although thats not a nice solution. In case the server xml file is also wrong I will have to think about something Smile

New version attached, this one comes without a db so just copy/paste it into your directory and overwrite all the files. This will keep your db.


Attached Files
.zip   Release.zip (Size: 581.72 KB / Downloads: 2)
Reply
#39
looks good now we need Paul to have xml include all drivers
you are good at this
Reply
#40
Thanks Tim and thanks Nikos for the kind words Smile

Really enjoyed/enjoying this ;D
Reply


Forum Jump:


Users browsing this thread: 3 Guest(s)