Need a custom Wordpress plugin modified in a few ways.
Currently uses too many queries so it times out more frequently as the database gets bigger. So... I need someone to set up new database tables to store weekly scores in 3 sessions per year and then a yearly over all then have the system templates/shortcodes draw from those tables rather than the weekly scores individual scores in both the front and back end.
Also... I need filters added to division and team lists in admin so current session divisions are at the top of the list rather than the bottom and so teams can be sorted by division.
This should be pretty straight forward for .
There will be many tweaks and modifications needed to be done as time goes on like page caching etc.
This plugin has already been built and is working great aside from the page load speed. You are not creating a new plugin. This is modification work to simply reduce the number of queries needed.
Once a session is finished there is no need to store individual scores. These scores combined into session totals.
This is how it currently works.
Add players to, activate players or deactivate players on teams
Add teams to Divisions
Create schedule for each division (17 weeks each)
Enter scores for individual players
Short codes placed on team and division pages showing schedule, weekly team points and widgets for the division team standings.
Player profile shows current session stats for each team the player is on and lifetime stats as an overall
Player stats by skill level pages. (Basically just shows how many wins and losses a player has in the current session/season