aston217
12-17-2013, 02:56 PM
This is a .zip containing a PHP-backed frontend for converting the .csv leaguedata generated by FOF7 into a database, to do with as you like.
Installation
You'll need a local webserver with PHP and MySQL. It's possible you could do this online, too, but I really haven't checked.
MySQL connection details will need to be entered into res/config.php.
Usage
1) Upload leaguedata .csvs into the import/ folder
2) Select a database name
3) Press the 'Complete!' button
For those with existing frontends for their leagues operating on DBU, you can either rewrite the frontend from scratch (more work) or attempt to stuff the new data to the old DBU-generated database structure. That should allow you to leave the rest of the frontend code intact. In other words:
New CSV data » New database structure » Old database structure
This is the first leg of that 2-step process.
For those looking at designing new frontends you can use this as a basic starting point as well.
Known Issues
Currently player_records isn't successfully loaded into the DB.
Make sure you are able to run PHP scripts for a long time.
Installation
You'll need a local webserver with PHP and MySQL. It's possible you could do this online, too, but I really haven't checked.
MySQL connection details will need to be entered into res/config.php.
Usage
1) Upload leaguedata .csvs into the import/ folder
2) Select a database name
3) Press the 'Complete!' button
For those with existing frontends for their leagues operating on DBU, you can either rewrite the frontend from scratch (more work) or attempt to stuff the new data to the old DBU-generated database structure. That should allow you to leave the rest of the frontend code intact. In other words:
New CSV data » New database structure » Old database structure
This is the first leg of that 2-step process.
For those looking at designing new frontends you can use this as a basic starting point as well.
Known Issues
Currently player_records isn't successfully loaded into the DB.
Make sure you are able to run PHP scripts for a long time.