Quote:
Originally Posted by endgame
If it's not too lengthy and not too much trouble, would you mind laying out the steps to set it up for the solo user? It'd be a great addition and a way to expand the experience to a wider audience.
Thanks, Alan.
and thanks, fhomess, for the contribution!
|
Well, there are three sections of things that you upload for online leagues that Statslab seems to tie into. The SQL export, the HTML reports and the League file (league.tar.gz).
Some parts of the Statslab utility I am not sure that a single player would really care about (export status, online draft, end of season award voting and all star award voting), since most of those are available within game when just caring about yourself. Everything else I could see being interesting for single user play as well. So you can enable or disable the parts that you do not care about.
Now to get the info out of OOTP for a single play user, most of it is pretty similar to how you would do it for online league play:
SQL exports: 1) Go to Game Setup and on the Major League Setup page, simply click on the Import/Export button and choose "Create SQL dump for MySQL. This will end up putting a ton of *.mysql.sql files in your saved_games/league.lg/import_export folder. These files need to simply be moved to the directory you want to use for your SQL upload that you configued in the statslab utility. (or you probably can just use this directory if you are doing the entire thing from this system).
HTML reports: Go to Global setup -> Online Options. You do not have to enable online league mode to create the HTML reports. You can simply just click on the create/upload reports button there.
League File: I am not sure you really need this, I don't know if statslab would choke on not having a league file there in your directory. You could likely just zip up your league.lg folder into a league.tar.gz format and then put it into a directory and never update it again. I might be wrong on that.
So that is all you need for the statslab to get the info it needs from OOTP. The only other catch you will have is for it to work properly, you will need some form of Mysql database running on your computer. There are various free ones around that you could likely use but since this application is designed to use mysql, you have to leave the database running for the application to function properly. You also need some form of http server running on the system that can handle PHP as well. I do not believe that it will work just like clicking on a .html file on your computer.
So for single player, you probably are better off at still uploading everything to a webserver instead, but you don't have to if you don't want to.