StatsLab SQL Utilities for OOTPX

[jsweber]

I have been trying to figure out why I'm still getting 2 different issues when I load my dumps...

First off I have tried to troubleshoot and even wipe the db and start over but for whatever reason I get the following 2 errors on loading the dump files:

insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 87032, 77965, 20783, 15309, 0, 0, 4131, 388, 2560, 1541, 542, 0, 10938, 7694, 0, 725, 0, 648, 0, 0, 2270, 0, 7079, 0, 0.2666, 0.3355, 0.4280, 11961.8121, 5.5329, 0.1614, 1.#INF, 0.7635, 73.9798, 0.0000, 0.0000);
 -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
   insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 98393, 87884, 22741, 18282, 0, 0, 4606, 561, 2482, 1429, 591, 0, 11481, 8926, 0, 865, 0, 718, 0, 0, 2590, 0, 7649, 0, 0.2588, 0.3306, 0.4087, 12755.6118, 5.1827, 0.1499, 1.#INF, 0.7393, 70.7426, 0.0000, 0.0000);
 -> You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

I might be missing something in setup I'm not really sure. And the second issue is non of the all star nominees are showing up to vote on. I have tried searching the forums with no luck.. Any advice?

EDIT: Ok after checking some things out I really don't need these anyways so I guess I'm down to my only issue of the all stars voting not working.. thanks

[Recte44]

Any progress on modifications for OOTP11???

I'd love the Draft Utility to be able to handle compensation picks much easier than currently; also a big addition would be the ability to view batting and pitching stats/ratings for position players and pitchers; as well as adding a filter to the Development page for pitching, batting and fielding development events.

[Recte44]

Has anyone heard from fhomess??? I really, really need his help.

[js155306]

I'm having a major problem with the draft utility in the OOTP9 version.

My league expanded from eight to ten teams this off-season, which the utility has apparently recognized since they are able to log-in. However, when I went to set up the amateur draft, even though there are slots for ten picks on the admin page, the actual draft page is still only generating eight picks per round.

Does anyone know what has to be done to fix this?

[fhomess]

http://www.ootpdevelopments.com/boar...tatslab11.html released.

[Cowtippers]

Have a question. Didn't see it answered in any of the post above but I may have missed it. I've got statslab uploaded and working. All the sql files are in the correct folder and show up loaded. I can't get any of the links to show up when the managers log in to statslab. I go into the admin portion of statslab and tell it to have the last sim, exporter, etc. loaded but when I click the check box and hit save it does nothing. I'm at a loss on what to do. I've even deleted the /admin part and tried to get that screen to work by setting the sim length but that still does nothing. I know its probably something I'm doing wrong but I just can't figure it out.

Thanks!

[EKomrska15]

I have a question about the HOF....How can I get players to show up to vote on? Is there somethign special I need to do to have players show up that retired 5 years ago?

[fhomess]

This thread can be unstickied.

[thickman1]

So our league expanded by 4 teams this past off-season (24 - 28). I went in to the draft tool in statslab and while it shows 28 teams in the admin section - and lets me put them in any order - it only saves the first 24 teams. When looking at the draft board it only shows 24 picks.

Can someone tell me how to fix that?

[jpeters1734]

Any ideas why my username dropdown is blank on the login screen?

StatsLab Login - StatsLab for OOTP15

[jpeters1734]

I imported a draft eligible list an I get this message when I go to the war room:

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/thebaseballclass/public_html/StatsLab/draftWarroom.php on line 1025

[Mike Lowe]

Will this work with OOTP 16?

Thanks!

[Deron]

Followed all instructions I could find, but cannot get a draft to start. It keeps telling me "Draft not scheduled". Any ideas on where to start with this?

[Mike Lowe]

The links appear dead?

[McLite]

Love the utility...league wouldn't the same without it.

Just a quick question. In OOTP '15 the game now marks 1st, 2nd, and 3rd place winners for Awards. It seems though that StatsLab can't differentiate and in the utility player screen counts a 2nd or 3rd place finish as a win.

Any way to get around this? Just prepping for the confusion down the road when we manually vote for HoF players.

Thanks!

[byzeil]

Having trouble getting StatsLab to send out update emails and draft emails.

I'm running OOTP16 with the latest version of StatsLab on an allsimbaseball.com site.

Anyone that has email working for this setup able to point me in the right direction?

[jpeters1734]

Originally Posted by byzeil

Having trouble getting StatsLab to send out update emails and draft emails.

I'm running OOTP16 with the latest version of StatsLab on an allsimbaseball.com site.

Anyone that has email working for this setup able to point me in the right direction?

I'm having the same issues. Fidel says that's it's possibly a bug

[kopuz]

Originally Posted by Deron

Followed all instructions I could find, but cannot get a draft to start. It keeps telling me "Draft not scheduled". Any ideas on where to start with this?

Having this same issue.

[McLite]

Originally Posted by MattG

Love the utility...league wouldn't the same without it.

Just a quick question. In OOTP '15 the game now marks 1st, 2nd, and 3rd place winners for Awards. It seems though that StatsLab can't differentiate and in the utility player screen counts a 2nd or 3rd place finish as a win.

Any way to get around this? Just prepping for the confusion down the road when we manually vote for HoF players.

Thanks!

Anyone else seeing this? Every season it lists multiple winners for the awards now that the game keeps track of 1st, 2nd, 3rd.

[fhomess]

Originally Posted by MattG

Anyone else seeing this? Every season it lists multiple winners for the awards now that the game keeps track of 1st, 2nd, 3rd.

The game doesn't export the order of finish in the table that StatsLab is reading for most pages. There is another way to get the info but I haven't coded it in. Until OOTP fixes the table or I change the code, the only workaround is to manually enter award winners and only enter the 1st place finisher.