Thank you all for nice comments
And I'm very glad there are already responses and questions for improvement
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
(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
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
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
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
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
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:
- No more confusion like this
- 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?
After you confirm I'll make the necesary adjustments 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
Like the page sizes, I thought about this at some point but completely forgot about it, so thanks for the reminder