Seeking a few utilities

[Chris Jones]

Getting tired of looking at the same old html reports the game creates. I've seen some league pages with awesome looking stat databases. Curious if those are available to the public?

I do have database support on my server. Just trying to find something easier to read.

Thanks in advance,
Chris

[gstelmack]

You can use the Interrogator utility in my UtilitySuite to get CSV data for much of the game, then import those into a database to run whatever reports / queries you want to. That's how many of the leagues are doing it (others are parsing the in-game HTML, log scores, box scores, and other bits to generate their databases).

[cuervo72]

That's what FOFL uses, exports from Interrogator. There are a few other tables that I maintain in addition to those -- one for team history that captures past franchises, owners and team colors, an extra position sort table, and tables to use VPI's draft utility, expanded to include combine data.

I've been toying with the idea of posting the code for some of the php scripts for folks to adapt (the thought of helping out WOOF as a sort of thanks for Interrogator in the first place spurred this, though I've heard Greg and LS were thinking of using something other than php). At the same time, I don't want to have to deal with providing any sort of support (not as patient as Greg :) ).

[Subby]

Just a few of the goodies cuervo has crafted for the Front Office Football League (http://www.thefofl.com).

Leaders: Team Stats (http://www.thefofl.com/league/teamleaders.php?y=2016) : Passing (http://www.thefofl.com/league/seasonleaders.php) : Rushing (http://www.thefofl.com/league/seasonleaders.php?y=2016&set=1) : Receiving (http://www.thefofl.com/league/seasonleaders.php?y=2016&set=2) : Defense (http://www.thefofl.com/league/seasonleaders.php?y=2016&set=3) : More (http://www.thefofl.com/league/seasonleaders.php?y=2016&set=5)
Hierarchy: Teams (http://www.thefofl.com/league/standings.php) : Owners (http://www.thefofl.com/owners.php) : Coaches (http://www.thefofl.com/league/coachindex.php) : Scouts (http://www.thefofl.com/league/scoutindex.php) : Players (http://www.thefofl.com/players/current.php) : Forbidden Love (http://www.thefofl.com/league/chemistry-search.php)
History: Records (http://www.thefofl.com/league/careerleaders.php) : Awards (http://www.thefofl.com/league/awards.php) : Drafts (http://www.thefofl.com/league/draft.php) : Champions (http://www.thefofl.com/champs.php) : Injuries (http://www.thefofl.com/league/injuries.php)

[Gallifrey]

Just a few of the goodies cuervo has crafted for the Front Office Football League (http://www.thefofl.com).

Leaders: Team Stats (http://www.thefofl.com/league/teamleaders.php?y=2016) : Passing (http://www.thefofl.com/league/seasonleaders.php) : Rushing (http://www.thefofl.com/league/seasonleaders.php?y=2016&set=1) : Receiving (http://www.thefofl.com/league/seasonleaders.php?y=2016&set=2) : Defense (http://www.thefofl.com/league/seasonleaders.php?y=2016&set=3) : More (http://www.thefofl.com/league/seasonleaders.php?y=2016&set=5)
Hierarchy: Teams (http://www.thefofl.com/league/standings.php) : Owners (http://www.thefofl.com/owners.php) : Coaches (http://www.thefofl.com/league/coachindex.php) : Scouts (http://www.thefofl.com/league/scoutindex.php) : Players (http://www.thefofl.com/players/current.php) : Forbidden Love (http://www.thefofl.com/league/chemistry-search.php)
History: Records (http://www.thefofl.com/league/careerleaders.php) : Awards (http://www.thefofl.com/league/awards.php) : Drafts (http://www.thefofl.com/league/draft.php) : Champions (http://www.thefofl.com/champs.php) : Injuries (http://www.thefofl.com/league/injuries.php)

I really like this site. Very nice.

[camulos]

I've been toying with the idea of posting the code for some of the php scripts for folks to adapt (the thought of helping out WOOF as a sort of thanks for Interrogator in the first place spurred this, though I've heard Greg and LS were thinking of using something other than php). At the same time, I don't want to have to deal with providing any sort of support (not as patient as Greg :) ).

I would very much appreciate that! I've gotten a lot of the pages done for the OSFL but am still struggling with things like Transactions and Injuries so it would be nice to be able to look at somebody elses code. I would also promise to never ask for support. :)

[cuervo72]

Hmm...for transactions I actually use another perl script to customize the tx for my needs. I started putting the transactions in under 2k4, and the output there was different than 2k7. So I wrote a perl script that will rearrange the columns. At the same time, it swaps in the "absolute" player id's rather than the ones Greg has in there (gs_index). I don't actually have a transactions script for the league or the teams yet, though I do have them on player pages. The problem with the transactions is that there is so much info in there, and different values appear in the same fields (one can be team2 for a trade, or position for a position change, etc).

Coach tx are in there too, but w/o a way currently to get to coach id's, you can't really use those lines.