It is currently 21. Aug 2018, 10:05  


 

RRRBanner

  User Information

User avatar




Facebook, Google Login
Registration

  Translater

Select:
Google
Babel Fish
Live

Current language: en


Post new topic Reply to topic  [ 104 posts ] Go to page  1, 2, 3, 4, 5 ... 11  Next
FollowersFollowers: 0
BookmarksBookmarks: 0
Views: 6087

 TTCOrial & TM 2 Data Tracker Questions 
AuthorMessage
Driver and Poster
Driver and Poster||
User avatar

Joined: 07.2011
Posts: 141
Cash on hand: 0.00 Goldcoins

Thanks: 7
Thanked: 76 times in 61 posts
Gender: Male
howyouplay: Keyboard
Start Number: 53
Man call him :: Nobody
Post TTCOrial & TM 2 Data Tracker Questions
Here you can put questions regarding that huge post I made a few minutes ago #blbl

_________________
TM2 Data Tracker
Here’s To The Crazy Ones ... The ones who see things differently... >YT Link<

Image


16. Jul 2012, 13:57
Profile
The following user would like to thank RR TTCO for this post
Roots Rock Admin
Roots Rock Admin||
User avatar

Joined: 06.2009
Posts: 180
Cash on hand: 0.00 Goldcoins

Location: Beckum
Thanks: 20
Thanked: 44 times in 37 posts
Gender: Male
Highscores: 42
howyouplay: Keyboard
Start Number: 93
Man call him :: Dome
Post Re: TTCOrial & TM 2 Data Tracker Questions
Well thats just insane. I really like your work, the design of your website is fine and all on website is so easy to watch. Very nice to see how the race was. Robbi drive like most of the best rounds, and I can learn a lot about my bad race. Thank you for that all. Thats really nice. Part I was also very nice :) I worked with SQL before but this combination is great done :)

_________________
Greetings from the Winner of:

GT Season I
GT Season II
KnockOut Season I
KnockOut Season II


16. Jul 2012, 14:19
Profile ICQ
The following user would like to thank RR Dome for this post
Roots Driver
Roots Driver||
User avatar

Joined: 05.2011
Posts: 86
Cash on hand: 0.00 Goldcoins

Location: Slavonski Brod
Thanks: 0
Thanked: 16 times in 16 posts
Gender: Male
howyouplay: Keyboard
Start Number: 0
Man call him :: Nobody
Post Re: TTCOrial & TM 2 Data Tracker Questions
No question, just big #respekt . This is crazy job. :fooli007:

_________________
Image
Image


16. Jul 2012, 17:34
Profile
The following user would like to thank RR Slaven for this post
Driver and Poster
Driver and Poster||
User avatar

Joined: 05.2011
Posts: 365
Cash on hand: 0.00 Goldcoins

Location: Split, CROATIA
Thanks: 32
Thanked: 172 times in 107 posts
Gender: Male
Highscores: 19
howyouplay: Keyboard
Start Number: 13
Man call him :: Newspaperman
Post Re: TTCOrial & TM 2 Data Tracker Questions
Although I already know about this, I just wanna publicly to say what a amazing work you done!! :fooli007: :fooli007:

I know this took you many days of work, but in the end, we got incredible 'application' with large amount of data and statistics!! :likebutton: :likebutton:

Once again, thank you for this, and can wait to fill this with large number of races, so that we have large statistic data all in one place!! And now, you helped Ombre with calculating all resutls too!! #great

_________________
Image


16. Jul 2012, 18:06
Profile
The following user would like to thank RR Cyrex for this post
Roots Rock Admin
Roots Rock Admin||
User avatar

Joined: 06.2009
Posts: 730
Cash on hand: 20.00 Goldcoins

Location: Löwenscheid
Thanks: 252
Thanked: 83 times in 70 posts
Gender: Male
Highscores: 2
howyouplay: Gamepad
Start Number: 74
Man call him :: Hombre Wan Kenobi
Post Re: TTCOrial & TM 2 Data Tracker Questions
Thank you TTCO #drueck

That is the biggest gift I ever received here in TrackMania except the Newspapers and the Man behind #staun
#megaphone run come all people !!!!! lets eat the whole statistics we can see from now #star
I will start first :cherrysmilies006:

But one wrong think I saw ....... but this was my fault, because I had forgotten to tell you who in which team #schaem
Bozz drove as the third driver for Tesa Racing so he is not in the Driver Table, only his points was for the Team Table.
Is it much work to change that?

But thank you thank you thank you, TTCO #drueck

_________________
Me on Facebook
#rasta


16. Jul 2012, 18:09
Profile Visit website
Driver and Poster
Driver and Poster||
User avatar

Joined: 05.2011
Posts: 365
Cash on hand: 0.00 Goldcoins

Location: Split, CROATIA
Thanks: 32
Thanked: 172 times in 107 posts
Gender: Male
Highscores: 19
howyouplay: Keyboard
Start Number: 13
Man call him :: Newspaperman
Post Re: TTCOrial & TM 2 Data Tracker Questions
How about BooZ join some team where there is only one driver in team, so that he can be in Driver Championship? Just an idea.. #zuzwinker

Btw, TTCO, you mke 4 choices, of displaying count of list (10,25,50,100), but can you make it when I select 25, that site remember that, so that is always selceted..

_________________
Image


16. Jul 2012, 18:18
Profile
The following user would like to thank RR Cyrex for this post
Roots Rock Admin
Roots Rock Admin||
User avatar

Joined: 06.2009
Posts: 730
Cash on hand: 20.00 Goldcoins

Location: Löwenscheid
Thanks: 252
Thanked: 83 times in 70 posts
Gender: Male
Highscores: 2
howyouplay: Gamepad
Start Number: 74
Man call him :: Hombre Wan Kenobi
Post Re: TTCOrial & TM 2 Data Tracker Questions
I talk about your Idea with him before, but he told that he cant participate often. and that is why he rather be third Tesa Driver #nixweiss

_________________
Me on Facebook
#rasta


16. Jul 2012, 18:26
Profile Visit website
Driver and Poster
Driver and Poster||
User avatar

Joined: 05.2011
Posts: 365
Cash on hand: 0.00 Goldcoins

Location: Split, CROATIA
Thanks: 32
Thanked: 172 times in 107 posts
Gender: Male
Highscores: 19
howyouplay: Keyboard
Start Number: 13
Man call him :: Newspaperman
Post Re: TTCOrial & TM 2 Data Tracker Questions
Also, TTCO, it will be a nice thing, if you can put Gap Time between each drvier and winner of the race!
Like Ombre did in last race result! races-f274/1st-race-desert-8th-july-t1049.html

_________________
Image


16. Jul 2012, 19:20
Profile
The following user would like to thank RR Cyrex for this post
Roots Rock Admin
Roots Rock Admin||
User avatar

Joined: 06.2009
Posts: 730
Cash on hand: 20.00 Goldcoins

Location: Löwenscheid
Thanks: 252
Thanked: 83 times in 70 posts
Gender: Male
Highscores: 2
howyouplay: Gamepad
Start Number: 74
Man call him :: Hombre Wan Kenobi
Post Re: TTCOrial & TM 2 Data Tracker Questions
look at Portal Page, so you can reach the TM2 Data Tracker from there too #opa

_________________
Me on Facebook
#rasta


16. Jul 2012, 19:28
Profile Visit website
Driver and Poster
Driver and Poster||
User avatar

Joined: 07.2011
Posts: 141
Cash on hand: 0.00 Goldcoins

Thanks: 7
Thanked: 76 times in 61 posts
Gender: Male
howyouplay: Keyboard
Start Number: 53
Man call him :: Nobody
Post Re: TTCOrial & TM 2 Data Tracker Questions
Thank you all for nice comments #star
And I'm very glad there are already responses and questions for improvement #zuzwinker

To answer some questions...
RR Cyrex wrote:
Btw, TTCO, you mke 4 choices, of displaying count of list (10,25,50,100), but can you make it when I select 25, that site remember that, so that is always selceted..

Ah... I thougth about something similar (more info below the geeky stuff) at least 10 times during the development but never actually implemented it...
To answer your question, well, technically, yes.
<geeky_stuff>
But for that I would have to make one of two things: Cookies or Login system (with registration and stuff). Cookies is less complicated but I haven't worked with them so far (programming-wise). Login system lets you do many cool stuff (regarding user customisation), but that requires even more work. If enough people use this and there is need for such a thing I could make it, but that won't happen anytime soon (not that I don't want to, just don't have so much free time now).
Regarding pagination, you have to make a compromise between small sizes (which request smaller amounts of data from the server) and bigger sizes (which require less queries, i.e. you don't have to change pages so often). Also, bear in mind that every table operation (such as initially loading the data, or every sorting, changing pages or changing page size) makes a new query to the server...
</geeky_stuff>
By far the easiest thing to do here is to set the default option to be 25 (or something else completely). Actually, I can change the whole list, for example, I could make the page sizes (20, 40, 80, 100)... Or just leave it at (10,25,50,100). In fact, I can set different default & list values for each table individually!
I'll tell you what. Go to the page now and you'll see a new and improved paging system. Pay attention to the change on "Race results" query #zuzwinker (and also notice that this option would be "dangerous" on a table which size could be large, or very large (like laps and cps table)...
If, by any chance, you don't see any changes, try clearing your cache or reload the page without cache (Ctrl+F5 for Opera I think)...

RR TheDome2010 wrote:
When you not would be here TTCO I would buy this script. Its so nice :)

Thats nice but I don't think you would benefit much from it because I would have to write a handbook on how to operate it #blbl Not because I'm "so smart" and am the only one who knows this technology, but because I made many crazy mumbo-jumbo tweaks and weird coding stuff, its gotten so complicated... TBH, I'd have no idea how all this works if I didn't made it #blbl

RR Jahombre wrote:
But one wrong think I saw ....... but this was my fault, because I had forgotten to tell you who in which team #schaem
Bozz drove as the third driver for Tesa Racing so he is not in the Driver Table, only his points was for the Team Table.
Is it much work to change that?

I left your question for last because I'd like to, just shortly, explain how the driver-team-race stuff works behind the scenes. The core of this system (at least the database part) is something similar to this, although I have a lot more tables and rows but this part is important (source: stackoverflow)
Image
So, for a race - the result isn't directly tied to a driver, but to a driver-team "combination". First of all, that means that no driver can be without a team, it must at least be an "empty", no-name team... (that's also why I had to make a fair number of changes to the web page after the indy event - there are no teams there and the database is too "deep" in the core of the system to change that...) Second, it means that, while it takes some work, I can mix driver-team combos for each race as I like, but then I end up with a bunch of driver-team combinations. Actually that is just hypothetical, as I didn't actually test the system with crazy driver-team mixings #lol
To get to the point, the most important thing is: Best solution would be if there was one and unique place (maybe - a first post of a "driver-team" topic) where all driver-team combinations would always be up to date. And for any changes you could update that first post and notify me (just put a new post in the same topic with the changes written down), so I can update my info.
That would be (IMO) great for two reasons:
  1. No more confusion like this #blbl
  2. It would help a lot if I put all the correct data in my "Deserialization PHP file", so I don't have to manually change the data in the database after I already upload it. Not that I don't want to, but it takes quite a lot longer, and more importantly, it's much easier to make a mistake that way and mess something up.
Soooo... Bozz is in Tesa for race #2 (with Drive and HanddoeK), and all else is correct for now or did I misunderstand something again? #lol
After you confirm I'll make the necesary adjustments #zuzwinker


EDIT:
one more question when I was writing the above...
RR Cyrex wrote:
Also, TTCO, it will be a nice thing, if you can put Gap Time between each drvier and winner of the race!

Yes, that immediately caught my eye when I saw it in Jahombre's tables, but it is not feasible if the paging is enabled for that table. For example, if page size is 10 and you load results 11-20, you have no info for driver #1 and can't substract the time... BUT, since these race results are not very large (doubt it will often go >30 rows, let alone 50), I could just disable the paging for that table alltogether and calculate the gap! In fact, I'll put that on my to-do list #zuzwinker
Like the page sizes, I thought about this at some point but completely forgot about it, so thanks for the reminder #klatsch

_________________
TM2 Data Tracker
Here’s To The Crazy Ones ... The ones who see things differently... >YT Link<

Image


16. Jul 2012, 20:25
Profile
The following user would like to thank RR TTCO for this post
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 104 posts ] Go to page  1, 2, 3, 4, 5 ... 11  Next


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
© phpBB® Forum Software | designed by Vjacheslav Trushkin for Free Forums 3 & Free Forums/DivisionCore.
phpBB3 free Forum by UserBoard.org | All Rights Reserved.