Build a Racing Scoreboard

  • Hi guys.

    Im trying to port/recreate something in WordPress since I love it so much and I like experiments. Here it is…

    I develop a simple “Scoreboard” WebApp for a racing competition that write and display time and speed laps with PHP and MySQL. The front-end display a table sort it view of categories with the best times of the top 10of each and another one with all the categories. Im picking the best time of each driver and displaying just the best overall. That way I could create a top 10 right.

    The backend let me choose from a dropdown the driver and add a new time and speed, I also can edit info like name picture , etc. How the db work now is, admin submit a new record, if the record is better than the one on the db, then replace time and speed. But I was ask to improve it so I can have a way of displaying all the log times for every runner but in a separate page and still get the best of alls.

    Here the WebApp: https://prexotic.com/scoreboard/

    Now I’m trying to port/recreate this idea to WordPress. Ive been researching plugins to develop this faster or easier instead from doing everything from scratch (which i don’t mind).

    So I was thinking maybe I should use custom post types and use them as entries and terms for the drivers and custom meta for the times and speed. Then sort the query.

    Im here to submit my idea in case anyone know something similar or can suggest me something. Since is a very specific thing to do i know could be a lot of work. Im not sure if this is the right forum but since I cant duplicate posts, I guess “how-to” fit somehow. If this should be somewhere else please let me know to move it.

    Please, any idea or suggestion is very welcome!!!! ??

    thnx in advance.

Viewing 3 replies - 1 through 3 (of 3 total)

  • Just use custom post types with a couple of custom fields.

    Get https://www.advancedcustomfields.com/
    The pro version is well worth it. They put no constraints on it, except that the pro code must not be distributed in free products, so you must be charging for the plugin/theme (can’t just be handing it out).

    Then simply create a custom page template and query the custom post types in a particular order (I assume you know queries) and echo all of that inside a table.

    Good luck! ??

    Thread Starter sugartoys

    (@sugartoys)

    Yeah! that sound like the right direction. I’m gonna check that one right now. ?? i let you know.

    Many thnx Daniel.

    Any time ??

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Build a Racing Scoreboard’ is closed to new replies.