Site
Home / Forum / General Discussion / [Concept] Motorsport results

[Concept] Motorsport results


Posted: 23 Nov 2019 16:43

zag


Posts: 3,503
Joined: 2020

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: 3,503
Joined: 2020

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

zag


Posts: 3,503
Joined: 2020

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

zag


Posts: 3,503
Joined: 2020

Stunning!

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: 3,503
Joined: 2020

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

zag


Posts: 3,503
Joined: 2020

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


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

zag


Posts: 3,503
Joined: 2020

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: 3,503
Joined: 2020



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

zag


Posts: 3,503
Joined: 2020



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

zag


Posts: 3,503
Joined: 2020

Player list seems to be limited to players A - T only as well

Posted: 26 Nov 2019 07:05

zag


Posts: 3,503
Joined: 2020

PS: Maybe it's caused due to the apostrophe on Jerome's surname ¿?

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: 3,503
Joined: 2020



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

zag


Posts: 3,503
Joined: 2020

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: 3,503
Joined: 2020

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.


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

zag


Posts: 3,503
Joined: 2020



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

zag


Posts: 3,503
Joined: 2020

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: 3,503
Joined: 2020

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!


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

zag


Posts: 3,503
Joined: 2020



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

Showing 0 to 18 (Total: 18)