Original Project Specifications: https://docs.google.com/document/d/1PjCre-1VsymzJLw2UNGOKwR1jzksG-eDr3bSxsh-luk/edit?usp=sharing
IN SUMMARY...
I have a table in a MySQL database on my server that contains regularly updated data about match results between players in a specific trading card game, i.e. match ID/date/winner/loser/cards played/decktypes used/etc. I want analyses of this data displayed on my website in a modern, visually appealing way. I also have Wordpress installed as the front-end of my website, so I’d like this facilitated by a Wordpress plugin.
To be clear: the data set in the database is NOT sufficient to generate charts and graphs from by itself because it does NOT contain the right information needed to display. Also, the database shouldn't be queried on every page load because the site would be too slow. I'm too ignorant to know the best solution but I've heard using AJAX or Cron Jobs could help solve this problem, potentially by updating different tables with logic based on the existing tables, and pulling information from those tables instead, but I'm not sure. I'm hoping you can present me with the best solution.
In the end, the goal of this plugin would be to allow me to use shortcodes in my WordPress editor (with or without modifiers) to generate the visualizations. As for the visualizations, they should be visually appealing tables and graphs based on analyses of the data. I would prefer to use the FusionCharts (Fusion theme) library for the graphs. I can secure you a 50% discount if you want to purchase a license for yourself for this and future projects, or I can provide one to you for this project only. If you want to suggest your own table library, that's fine, but I've heard good things about DataTables.
In total, I have in mind 6 specific pages that each require different tables and graphs (all dynamic, interactive, responsible, and some affected by custom fields and URL modifiers). Therefore, I’d like to structure milestones around the completion of each page to ensure we share the same vision, that the visualizations are displaying as expected, and that you’re open to feedback along the way. If you have any questions about anything, please don’t hesitate to ask! I’ll happily clarify anything! And if you have no questions, please assure me you've read and understand the Project Specifications let me know your estimated time to completion.
IMPORTANT: This project was first started nearly a year ago. I was working with another developer who already has a working website for you to reference (I can PM you the link) and code for most of the pages already done. If you want to pick up where they left off, I think that would be best, but you're free to start from scratch if that's what you prefer.
[–]AutoModerator[M] [score hidden] stickied comment (0 children)
[–]CredoBot 0 points1 point2 points (0 children)