StatsLab SQL Utilities for OOTPX - Page 17

fhomess · 03-08-2010, 03:38 PM

Quote:

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 · 03-15-2010, 02:21 PM

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 · 03-15-2010, 04:06 PM

Quote:

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 · 03-15-2010, 07:25 PM

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 · 03-19-2010, 09:26 AM

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 · 03-19-2010, 11:20 AM

Quote:

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 · 03-19-2010, 11:34 AM

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

BleedingCubbyBlue · 03-19-2010, 11:37 AM

That did it. Thanks for the quick reply!

Jaxxvain · 03-19-2010, 02:13 PM

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 · 03-19-2010, 02:22 PM

Quote:

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 · 03-19-2010, 02:57 PM

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 · 03-25-2010, 11:47 PM

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 · 03-26-2010, 12:26 AM

Quote:

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 · 03-26-2010, 12:31 AM

Quote:

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 · 03-26-2010, 02:09 AM

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 · 03-26-2010, 09:15 AM

Quote:

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 · 03-26-2010, 01:16 PM

Quote:

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 · 03-26-2010, 04:49 PM

Quote:

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 · 03-26-2010, 05:15 PM

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

BaltimoreFan80 · 03-31-2010, 01:14 PM

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

03-15-2010, 02:21 PM	#322
rutri01 All Star Reserve Join Date: Dec 2007 Posts: 515	widgets 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?

03-15-2010, 07:25 PM	#324
rutri01 All Star Reserve Join Date: Dec 2007 Posts: 515	we moved 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.

03-19-2010, 09:26 AM	#325
BleedingCubbyBlue All Star Reserve Join Date: Jun 2003 Location: Gurnee, IL Posts: 601	Getting some errors... 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 __________________ http://www.otbaonline.com Last edited by BleedingCubbyBlue; 03-19-2010 at 10:16 AM.

03-19-2010, 11:34 AM	#327
BleedingCubbyBlue All Star Reserve Join Date: Jun 2003 Location: Gurnee, IL Posts: 601	It was team_relations. I'll get that one loaded and try again. Thanks! __________________ http://www.otbaonline.com

03-19-2010, 11:37 AM	#328
BleedingCubbyBlue All Star Reserve Join Date: Jun 2003 Location: Gurnee, IL Posts: 601	That did it. Thanks for the quick reply! __________________ http://www.otbaonline.com

03-19-2010, 02:13 PM	#329
Jaxxvain All Star Reserve Join Date: May 2006 Posts: 531	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.) __________________ Jaxxvain aka Molson ~~~~~

03-19-2010, 02:57 PM	#331
Jaxxvain All Star Reserve Join Date: May 2006 Posts: 531	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" __________________ Jaxxvain aka Molson ~~~~~

03-25-2010, 11:47 PM	#332
BleedingCubbyBlue All Star Reserve Join Date: Jun 2003 Location: Gurnee, IL Posts: 601	MySQL amateurs don't match in-game amateurs 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. __________________ http://www.otbaonline.com

03-26-2010, 02:09 AM	#335
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	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. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

03-26-2010, 05:15 PM	#339
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	N/m I guess it would actually help to see which players were actually drafted already. Looks like we're good to go. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti." Last edited by Operation Shutdown; 03-26-2010 at 05:23 PM.

03-31-2010, 01:14 PM	#340
BaltimoreFan80 Bat Boy Join Date: Nov 2008 Location: Somewhere in the Northeast Posts: 5	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 __________________ BSOL Baltimore Orioles 2009- 2009: 72-90 Last edited by BaltimoreFan80; 03-31-2010 at 01:17 PM.