Site
Home / Forum / General Discussion / [Concept] Motorsport results
Home / Forum / General Discussion / [Concept] Motorsport results
[Concept] Motorsport results |
| Posted: 23 Nov 2019 16:43 | |||
ovokx Posts: 830 Joined: Jan 2017 | Hi Zag, While trying to update the first Formula E race event of the season and I thought that was time to redisign a little bit this page in order to avoid the "ugly" copy-pasting for result list (and not always useful) and arrived to this  Hope you like the idea! PS: This design is only displaying 3 positions just for time consuming, but if you like it, it could display the full result race | ||
 | |||
| Posted: 23 Nov 2019 21:49 | |||
zag Posts: 1,558 Joined: Oct 2016 | Stunning! Yes I like this a lot and think its a good candidate for special treatment. I will see what I can do. | ||
| |||
| Posted: 24 Nov 2019 03:49 | |||
sport123 Posts: 42 Joined: Nov 2019 | Great work! Will this be something that will carry across to other motorsports such as Motocross and Supercross assuming all the correct data is uploaded? | ||
| |||
| Posted: 24 Nov 2019 11:29 | |||
ovokx Posts: 830 Joined: Jan 2017 | Yes I like this a lot and think its a good candidate for special treatment. I will see what I can do. Thank you! I have updated all Formula E drivers including cutouts in order to be able to test it | ||
| |||
| Posted: 24 Nov 2019 18:36 | |||
zag Posts: 1,558 Joined: Oct 2016 | I couldn't help myself writing this feature as it looked so good, jumped to the top of the todo list Initial beta version here: https://www.thesportsdb.com/event/671289 | ||
| |||
| Posted: 24 Nov 2019 18:46 | |||
ovokx Posts: 830 Joined: Jan 2017 | Initial beta version here: https://www.thesportsdb.com/event/671289 Looking good mate! Just some remarks about the add form: - I think that adding the "team" field should be a must in order to always display the correct one on the event. Think on players which drives on different leagues/competitions or adding past results for drivers that have changed into a different team. - If you also add the "points" field, take into account that we will be able to create "League tables" | ||
| |||
| Posted: 25 Nov 2019 19:40 | |||
ovokx Posts: 830 Joined: Jan 2017 | Test it trying to add the 9th pos. @ "Diriyah E-Prix - Race 1" and I got this error: Fatal error: Uncaught Error: Call to undefined method ezSQL_mysqli::sql_return_on_error() in C:\inetpub\thesportsdb\forumnew\phpbb\session.php:1580 Stack trace: #0 C:\inetpub\thesportsdb\forumnew\includes\functions.php(4995): phpbb\session->update_session_infos() #1 C:\inetpub\thesportsdb\forumnew\includes\functions.php(4083): page_header('Information') #2 [internal function]: msg_handler(512, 'Incorrect integ...', 'C:\\inetpub\\thes...', 272, Array) #3 C:\inetpub\thesportsdb\includes\ez_sql_mysqli.php(272): trigger_error('Incorrect integ...', 512) #4 C:\inetpub\thesportsdb\event.php(212): ezSQL_mysqli->query('INSERT INTO res...') #5 {main} thrown in C:\inetpub\thesportsdb\forumnew\phpbb\session.php on line 1580 | ||
| |||
| Posted: 25 Nov 2019 21:35 | |||
zag Posts: 1,558 Joined: Oct 2016 | Ahh yes I forgot to check for empty fields. It shouldn't crash anymore on missing info. Make sure all 3 boxes have an input. | ||
| |||
| Posted: 26 Nov 2019 06:09 | |||
ovokx Posts: 830 Joined: Jan 2017 | Ahh yes I forgot to check for empty fields. It shouldn't crash anymore on missing info. Make sure all 3 boxes have an input. PS: Maybe it's caused due to the apostrophe on Jerome's surname ¿? | ||
| |||
| Posted: 26 Nov 2019 06:48 | |||
sport123 Posts: 42 Joined: Nov 2019 | Player list seems to be limited to players A - T only as well | ||
| |||
| Posted: 26 Nov 2019 07:05 | |||
sport123 Posts: 42 Joined: Nov 2019 | I think it is. Check out this page: https://www.thesportsdb.com/event/593943 As you can see, more than 9 results displaying correctly. | ||
| |||
| Posted: 26 Nov 2019 09:41 | |||
zag Posts: 1,558 Joined: Oct 2016 | I think it is. Check out this page: https://www.thesportsdb.com/event/593943 As you can see, more than 9 results displaying correctly. Thanks yes it was an apostrophe error! Should be fixed as well as the limited driver list. | ||
| |||
| Posted: 27 Nov 2019 06:17 | |||
sport123 Posts: 42 Joined: Nov 2019 | Zag is it possible to change the layout of the race results for Pro Motocross to have "Motos" instead of "Time"? The reason for this is final race results are based on a best of 2 races so the end result looks like this: At the moment I am not too worried about "Hometown". "Machine" might be a nice touch but more of a nice to have at this point. | ||
| |||
| Posted: 27 Nov 2019 10:01 | |||
zag Posts: 1,558 Joined: Oct 2016 | At the moment I am not too worried about "Hometown". "Machine" might be a nice touch but more of a nice to have at this point. Actually yes this already works. The 'time' field is actually called strResult in the database so use whatever string you wish | ||
| |||
| Posted: 28 Nov 2019 03:37 | |||
sport123 Posts: 42 Joined: Nov 2019 | Actually yes this already works. The 'time' field is actually called strResult in the database so use whatever string you wish Great news Zag! I'll get onto it. | ||
| |||
| Posted: 13 Dec 2019 18:31 | |||
ovokx Posts: 830 Joined: Jan 2017 | Hi Zag, I'm currently adding some result lists to Formula-E and I have a doubt on how we should enter the "Did Not Finish", "Disqualified", "Did Not Start" and "Excluded" excepcions: - On the "Race Time" field should be entered full name excepction for better understanding or acronym? - I see that the zero position on the "Race Position" field is missing. Could it be added without losing correct displaying (zero positions should be at the end of the list) or better to add a fictional position number? Thanks for clarifying! | ||
| |||
| Posted: 20 Dec 2019 09:50 | |||
zag Posts: 1,558 Joined: Oct 2016 | I'm currently adding some result lists to Formula-E and I have a doubt on how we should enter the "Did Not Finish", "Disqualified", "Did Not Start" and "Excluded" excepcions: - On the "Race Time" field should be entered full name excepction for better understanding or acronym? - I see that the zero position on the "Race Position" field is missing. Could it be added without losing correct displaying (zero positions should be at the end of the list) or better to add a fictional position number? Thanks for clarifying! Yeh use DNF for non finishers. I will take a look at the numbering but I think its better to show the end positions as some non finshers last longer than others and should be placed accordingly I think. | ||
| |||
| Posted: 20 Dec 2019 18:46 | |||
ovokx Posts: 830 Joined: Jan 2017 | Yeh use DNF for non finishers. I will take a look at the numbering but I think its better to show the end positions as some non finshers last longer than others and should be placed accordingly I think. OK, done! See first full race results added here https://www.thesportsdb.com/event/672211 | ||
|
Who is Online? In total there are 68 users online :: 3 registered, 0 hidden and 65 guests (based on users active over the past 5 minutes) Most users ever online was 424 on Fri Nov 10, 2017 9:02 pm | About Us Discussion forum for TheSportsDB.com site and related topics | Rules - Be Polite - Respect other users - Always post log files with issues - Try to be helpful - No Piracy discussion |