StatsLab SQL Utilities for OOTPX

[fhomess]

Originally Posted by udbacker58

I want past GMs and GMs on the waiting list to be able to vote on the All-Star ballots so I checked the 'Allow Non-GM's To Login' box and have uploaded new SQL files. When I look at the admin page for the voting, I see the guys who don't have a team, but when I try to log in, they do not show up on the drop down. Anyone know why this is?

Not off the top of my head. Just ran a test in my install, and it worked fine. THe SQL queries are almost identical. Shoot me a PM with commish access to your StatsLab install and I'll take a look to see what I'm missing.

[rutri01]

Hi I created widgets for my website for the standings and leaders. Works great when using IE but not mozilla-firefox. Is it not compatible with firefox or do I need to do something else?

[snnort]

Originally Posted by rutri01

Hi I created widgets for my website for the standings and leaders. Works great when using IE but not mozilla-firefox. Is it not compatible with firefox or do I need to do something else?

Looking at your website (AHIBA3) I don't see any widgets at all in firefox OR IE.

BUT I do see that your website uses joomla which is notorious for having incompatibilities with IE. Because of that there are separate CSS files for a few versions of IE.

[rutri01]

we are now AHIBA3. I moved to simnation. I gotta change my signature. It seems to work fine with IE and google chrome but not safari and mozzilla. Could be a joomla problem.

[BleedingCubbyBlue]

I recently installed this for the OTBA. I'm getting some errors I can't figure out. I have all patches installed. Hopefully someone can help me. Thanks in advance!

First, on the Managers screen I see this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/3/d90035788/htdocs/otba/OTBA/ootpsqlou/managers.php on line 85

I see a similar error on the Exports screen: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/3/d90035788/htdocs/otba/OTBA/ootpsqlou/exports.php on line 107

Last Sim Box Scores - StatsLab for OOTPX

[fhomess]

Originally Posted by BleedingCubbyBlue

I recently installed this for the OTBA. I'm getting some errors I can't figure out. I have all patches installed. Hopefully someone can help me. Thanks in advance!

First, on the Managers screen I see this error: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/3/d90035788/htdocs/otba/OTBA/ootpsqlou/managers.php on line 85

I see a similar error on the Exports screen: Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /homepages/3/d90035788/htdocs/otba/OTBA/ootpsqlou/exports.php on line 107

Last Sim Box Scores - StatsLab for OOTPX

You're missing one or more of the following tables:
team_relations
divisions
sub_leagues

[BleedingCubbyBlue]

It was team_relations. I'll get that one loaded and try again. Thanks!

[BleedingCubbyBlue]

That did it. Thanks for the quick reply!

[Jaxxvain]

Is there anything I should do differently at the end of the season as far as Statslab is concerned?

Also, am I supposed to hit each button after every sim? (ex: player dev, win shares, career position or whatever, etc.)

[fhomess]

Originally Posted by Jaxxvain

Is there anything I should do differently at the end of the season as far as Statslab is concerned?

Also, am I supposed to hit each button after every sim? (ex: player dev, win shares, career position or whatever, etc.)

Definitely hit player dev after every sim.

You should hit all of the buttons at the end of the season. During the season, you don't need to bother with Career Metrics or Similarity scores if you don't care to have them updated with every sim. If you want updated Win Shares and/or Park Factors during the year, then you'll want to hit all the other buttons.

Career Position, Park Factors, Season Metrics, and Win Shares are what I'd recommend during the year, with Career Metrics and Similarity Scores only at the end of the year, but it doesn't hurt anything to hit them after each sim. Always click them in the order they appear on the screen. Also make sure you update them before the season rolls over to the next year - which happens at the end of the postseason. There's no postseason data included in any of these buttons, so you can click them as soon as the regular season is over even if you haven't crowned your champion yet. At this time, there's nothing else needs to happen at the end of each year.

[Jaxxvain]

Thanks for the reply.

My league is only 22 team, and not much history yet, so I have just been doing each button after every sim.

Perhaps we could get a one button that binds them all?

"One Ring to rule them all, One Ring to find them,
One Ring to bring them all and in the darkness bind them"

[BleedingCubbyBlue]

I'm at a loss on this one, though I'm sure it's something simple. We started our ammy draft today but found that there are players who came out of the MySQL as ammy's who are not in the game as ammy's. I'm stumped.

[fhomess]

Originally Posted by BleedingCubbyBlue

I'm at a loss on this one, though I'm sure it's something simple. We started our ammy draft today but found that there are players who came out of the MySQL as ammy's who are not in the game as ammy's. I'm stumped.

This can happen if they're feeder league players who are set to reach the graduation age by the time your draft occurs. OOTP doesn't add players to the draft pool from feeder leagues until they actually hit that age. If that doesn't appear to be it, shoot me a link with an example.

[BleedingCubbyBlue]

Originally Posted by fhomess

This can happen if they're feeder league players who are set to reach the graduation age by the time your draft occurs. OOTP doesn't add players to the draft pool from feeder leagues until they actually hit that age. If that doesn't appear to be it, shoot me a link with an example.

This is the player that brought the issue to my attention: Player Report for #16 Francis 'Duck' Gadarn He's already 18. Our league has HS age limit set to 15 and college age limit set to 18, both HS and college are feeder leagues.

[Operation Shutdown]

Trying to help BCB out here a bit, but the league has 18 set as the maximum age for high schoolers and there are a mix of 18 and 19 year olds currently in the draft pool. However, all of the 18 year olds will turn 19 before the actual start of the draft. Will the utility still pick up these 18 years olds even if we set the high school age to 19? We basically want to get started on the draft using the utility before the actual draft date.

[BleedingCubbyBlue]

Originally Posted by Operation Shutdown

Trying to help BCB out here a bit, but the league has 18 set as the maximum age for high schoolers and there are a mix of 18 and 19 year olds currently in the draft pool. However, all of the 18 year olds will turn 19 before the actual start of the draft. Will the utility still pick up these 18 years olds even if we set the high school age to 19? We basically want to get started on the draft using the utility before the actual draft date.

I changed age limits to 19 for both HS and college in the utility. The guy referenced above no longer appears in the utility, which is fine if he's not available in-game. Need to have someone in the league check the file v. the utility.

[fhomess]

Originally Posted by Operation Shutdown

Trying to help BCB out here a bit, but the league has 18 set as the maximum age for high schoolers and there are a mix of 18 and 19 year olds currently in the draft pool. However, all of the 18 year olds will turn 19 before the actual start of the draft. Will the utility still pick up these 18 years olds even if we set the high school age to 19? We basically want to get started on the draft using the utility before the actual draft date.

Yes. The utility checks the player age as of the draft date rather then player age as of the current league date.

[Operation Shutdown]

Originally Posted by fhomess

Yes. The utility checks the player age as of the draft date rather then player age as of the current league date.

Thanks for the help. It looks like we got things set up correctly now, however, when I was comparing the StatsLab draft pool with the in-game draft pool there was one big issue I found. A player that was injured on his college team and eligible for the draft does not show up in the StatsLab draft pool but does in the OOTP draft pool. Has anyone else experienced this?

[Operation Shutdown]

N/m I guess it would actually help to see which players were actually drafted already. Looks like we're good to go.

[BaltimoreFan80]

I have my league files and statlab on one server and I have my leaguefile and export files another because my main webhosting company when to a seure ftp which means ootp game can't acess the server. My question is this I have Statlab set up at www.rickhampton.org/ootpleague/ootpsqlou/index.html However I want my export file and leaguefile at www.rickhemler.site90.net/Exports
When I go to set up statlab the in the leaguefile path i put rickhemler.site90.net/Exports however when i go to export page i get this error

ERROR: No League File Found at: "http://www.rickhemler.site90.net/Exports/NMLB.lg.tar.gz"
/home/rickhamp/public_html/ootpleague/Dump/ootpsqlSettings.txt

Please Help