StatsLab SQL Utilities for OOTPX

[Cooleyvol]

the path to the widgets is public_html/utilities/widgets

<? include("utilities/widgets/lg_100_sl_0_div_0_standings.wgt"); ?>
Thats the code I use on my index.php site for League 1. Its located at public_html/index.php


I have a second statslab for League 2 of my world. That index page is at /public_html/pcl/index.php The above code doesnt work on the /pcl/index.php page.

[fhomess]

Originally Posted by Cooleyvol

the path to the widgets is public_html/utilities/widgets

<? include("utilities/widgets/lg_100_sl_0_div_0_standings.wgt"); ?>
Thats the code I use on my index.php site for League 1. Its located at public_html/index.php

I have a second statslab for League 2 of my world. That index page is at /public_html/pcl/index.php The above code doesnt work on the /pcl/index.php page.

Looks like you got this working. In general, it's best to include the full server path or a "./" at the start of any path to tell the code explicitly that you want a relative path.

[Stu]

Sorry for the dumb question but I don't have access to download the manual on the computer I'm on.

Can you run the metrics during the season or is it better to wait until after the playoffs are over? I'm talking about park factors, season metrics, career metrics ,etc.

[fhomess]

Originally Posted by Stu

Sorry for the dumb question but I don't have access to download the manual on the computer I'm on.

Can you run the metrics during the season or is it better to wait until after the playoffs are over? I'm talking about park factors, season metrics, career metrics ,etc.

You can run them prior to the end of the season. You cannot run park factors, season metrics, and win shares until the season has begun, however.

[Cooleyvol]

Originally Posted by fhomess

Looks like you got this working. In general, it's best to include the full server path or a "./" at the start of any path to tell the code explicitly that you want a relative path.

I got it working by putting the widgets for the second league on the same level as its 'pcl' directory.

[griffeyin98]

does statslab have a function to email a team overview when the files are updated?

[snnort]

I'm guessing this is semi difficult... but may as well ask...

When you have a number of fields (like on the team war room page of a draft or on a page of the all-star ballot)...

For instance... I had a person in my league ask if we could make the SP section of the all-star ballot sortable by clicking on the ERA column header or the whip column header. I know it's possible to do. I'm guessing it would take a bunch of additional php code that would tag a bunch of stuff on to the end of the URL so the newly refreshed page was given further instructions on which column to sort.

And though I know this would be handy... it's a minor feature that may take more work than what it's worth... BUT it could be a cool idea to adds polish to the best utility for OOTP, in my opinion.

[Recte44]

Is there a way to "reset" a draft easily?

[snnort]

There is no "button" or toggle that I know of... but if you have access to the MySQL database thru something like phpMyAdmin... you could export the database... change all the team ID field's to null and then unable and then reenable the draft in statslab and I would imagine that would do the trick.

Just make sure you know what you are doing in the SQL editing software first... or back EVERYTHING up first, before you try (I can't stress this enough).

[fhomess]

Originally Posted by griffeyin98

does statslab have a function to email a team overview when the files are updated?

Nope.

Originally Posted by snnort

I'm guessing this is semi difficult... but may as well ask...

When you have a number of fields (like on the team war room page of a draft or on a page of the all-star ballot)...

For instance... I had a person in my league ask if we could make the SP section of the all-star ballot sortable by clicking on the ERA column header or the whip column header. I know it's possible to do. I'm guessing it would take a bunch of additional php code that would tag a bunch of stuff on to the end of the URL so the newly refreshed page was given further instructions on which column to sort.

And though I know this would be handy... it's a minor feature that may take more work than what it's worth... BUT it could be a cool idea to adds polish to the best utility for OOTP, in my opinion.

Just tell your GM's to click on the column headers. If they've got Javascript enabled, that should work on most tables in StatsLab (there are some that it's not enabled for).

Depending on browser, this does sometime prevent players from getting added to the draft list or the EOS Awards voting tables. In that case, sort the players, figure out who you want to vote for, then refresh the page and vote without sorting.

Originally Posted by Recte44

Is there a way to "reset" a draft easily?

If you want to clear all the picks, but keep your draft order: If you're logged in as the commish, you can rollback the draft to any pick by clicking on the "Rollback" link on the draft board.
If you want to clear all the picks and the draft order: On the draft admin page, set the draft for 0 rounds and save. Then set it for your number of rounds and save again. Then fix the draft order.

Originally Posted by snnort

There is no "button" or toggle that I know of... but if you have access to the MySQL database thru something like phpMyAdmin... you could export the database... change all the team ID field's to null and then unable and then reenable the draft in statslab and I would imagine that would do the trick.

Just make sure you know what you are doing in the SQL editing software first... or back EVERYTHING up first, before you try (I can't stress this enough).

Not really necessary.

[rutri01]

How do I set up the email settings to sent out notification to the teams?

What do I put in those 2 email setting sections?

email list and reply to list

[snnort]

I would be interested to know more about how email has worked for others too, as I've never used it, but would like to for this coming Ammy Draft.

[fhomess]

Patch 3 download has been updated with the following:
1. Fixed issue with HTML links on draft board in some installs.
2. Fixed Last Sim module to correctly include games for the current league date. This was only an issue if you simmed games without progressing to the next day.
3. Added an option to the All-Star admin page to include pitchers with a minimum number of saves even if they don't meet the minimum innings requirements.
4. Fixed issue where the All-Star ballot wouldn't always regenerate immediately following a new data load.


That final note brings up a recently reported issue and I'm looking for suggestions on how people would like to see it addressed. If a player has been on the All-Star ballot and then traded from one league to the other (e.g. NL to AL), and he already has votes for his previous league, how should the votes be displayed? Adding all the votes together would essentially create invalid ballot entries where a GM had voted for one too few players in one league and one too many in the other. Not adding them together means that whoever's looking at the ballot has to know the player's history and determine how they'd like to use that information. A similar situation would occur with a player who meets the defensive innings requirement for a fielding position late in the balloting and gets moved from DH to an actual position. So, how would you folks like to see StatsLab handle this?

[snnort]

Originally Posted by fhomess

That final note brings up a recently reported issue and I'm looking for suggestions on how people would like to see it addressed. If a player has been on the All-Star ballot and then traded from one league to the other (e.g. NL to AL), and he already has votes for his previous league, how should the votes be displayed? Adding all the votes together would essentially create invalid ballot entries where a GM had voted for one too few players in one league and one too many in the other. Not adding them together means that whoever's looking at the ballot has to know the player's history and determine how they'd like to use that information. A similar situation would occur with a player who meets the defensive innings requirement for a fielding position late in the balloting and gets moved from DH to an actual position. So, how would you folks like to see StatsLab handle this?

I would say... leave the player on their original spot on the ballot. In essence what you are "saying" by this is that... the ballots have already been printed and sent of to the 30 major league ballparks. IF a player is traded to a different league during the voting, he stays in his original ballot spot. AND then the league can determine what all-star role he makes on a case-by-case basis.

[fhomess]

Two more minor fixes for the Patch 3 Download:
1. Fixed the trade block so that players who are traded are removed from the block.
2. Fixed an issue with 3-or-more-way ties in the Playoff Odds report, which would result in too few wild cards being assigned and teams with greater than 100% playoff odds.

Also updated version to 3.1 for the fixes to date.
Download StatsLab Patch 3.1 for OOTPX

[snake1399]

i sent a PM to Frank but wondering if anyone else has run into these 2 issues when running a draft and if there's a solution for it:

1. When clicking "Add to List" in the Team War room, nothing happens

2. When owners go to select a player, they get a notification that "player has already been drafted" when he hasn't

It's kind of hampered our draft a bit, so wondering if anyone else has seen this

thanks!
Snake

[snnort]

I have never seen that issue in either of the two leagues that I have used OR had admin privilages for a draft using StatsLab... so commenting on it with specifics I can't. BUT it sounds like a file permissions issue to me. ANYONE else seen this or think they have a better answer than my fairly weak attempt?

[rutri01]

We just installed stats labs and used it for our recent ammy draft. i used the email function and worked well to email each person which team is up and the upcoming list. It worked well and we will use it going forward.

[ootpFox07]

@fhomess, this is such a great tool, and as Endgame said, not only for online league but solo leagues too. I will certainly utilize this offline in the future. Awesome job!

But of course, I have one question/feature request.

I've actually been looking to generate something like your playoffs screen for historical post-seasons for my 100 seasons solo league (dynamically to save the time to have to go back and create 90+ of them). Is there anyway that you could see to be able to tap into past season playoffs as well? So say add an option for playoffs and a drop down to be able to choose past playoffs and get the same playoff breakdown and reports per round? Major PITA or somewhat realistic. If I can scrounge up some time I might attempt it myself but wanted to ask.

[fhomess]

Originally Posted by snake1399

i sent a PM to Frank but wondering if anyone else has run into these 2 issues when running a draft and if there's a solution for it:

1. When clicking "Add to List" in the Team War room, nothing happens

I'll just respond here so everyone can see. The Add to List button won't work if Javascript isn't enabled. You also need to have your settings directory as writeable, as that's where they get saved. However, this is probably not an issue if you've been able to configure the draft in the first place.

Originally Posted by snake1399

2. When owners go to select a player, they get a notification that "player has already been drafted" when he hasn't

It's kind of hampered our draft a bit, so wondering if anyone else has seen this

This one can be kind of hard to troubleshoot, but if the util already has a player ID as being used in the DB (amateur_draft SQL table), then it won't let you redraft that player. I saw some issues with this in the past, but thought I had fixed those. StatsLab could get confused if you're using the same SQL database for two different leagues (completely different OOTP games). As long as the player pool is unique to the database, it shouldn't be an issue. As always, I'm happy to look at things if you give me commish access to StatsLab (via PM).

Originally Posted by DesertFox07

@fhomess, this is such a great tool, and as Endgame said, not only for online league but solo leagues too. I will certainly utilize this offline in the future. Awesome job!

But of course, I have one question/feature request.

I've actually been looking to generate something like your playoffs screen for historical post-seasons for my 100 seasons solo league (dynamically to save the time to have to go back and create 90+ of them). Is there anyway that you could see to be able to tap into past season playoffs as well? So say add an option for playoffs and a drop down to be able to choose past playoffs and get the same playoff breakdown and reports per round? Major PITA or somewhat realistic. If I can scrounge up some time I might attempt it myself but wanted to ask.

The SQL data dump doesn't give you the level of detail you'd need to get this page generated for past seasons. You can get the batter and pitcher stats, but not the box scores.