Aug
16
BF2 DB Updates
Filed Under BF2 Stats, Web Programming
Finished the SQL create table scripts.
After debugging, I’ve found I can actually reduce the size of the tables in the database by about a third each. It appears I am caching some null/unused information. No point in doing that. I also found that the main page was starting to get pretty cluttered. Today I started breaking down sections into simple functions based on the information being displayed, then moving those functions to individual header files. Today’s code additions take up 1/10 of the space and are perfectly readable as to what they are doing.
Also, Dan’s added a simple anchor for showing the time until you can update next. I’ll be migrating this into the next code dump after I’m finished with some more of the awards layout.
Things to do:
- Finish combining the badge/medal/ribbon query and sort
- Remove extra fields from tables and SQL script
- Continue grouping code into readable functions
- Implement time to update into current version