Home | Webstore
Latest News: OOTP 13 THIRD Update Available: Version 13.3.9! - OOTP 13 Released! Download Now! - iOOTP 2012 Available NOW on the AppStore - Title Bout Championship Boxing 2.5 released!

Download OOTP 13 Now! | Download iOOTP 2012 from the AppStore

Go Back   OOTP Developments Forums > Out of the Park Baseball 13 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
LinkBack Thread Tools Display Modes
Old 07-06-2011, 11:26 AM   #341 (permalink)
All Star Reserve
 
mad0die's Avatar
 
Join Date: Feb 2002
Location: TX
Posts: 847
Thanks: 8
Thanked 9x in 7 posts
Quote:
Originally Posted by snnort View Post
I have seen this issue before after manually changing a pick after it's happened and the fix I have had was to actually change the start of the draft entire draft using the time you want the next pick to be due again. It's a crude work around, but it works.

I would imagine that the reason you have a weird time (1006) is because you hit the "save" button on the draft admin page AFTER the draft had started already and picks have been made.
Having same problem with 2.2 BETA trying to get the draft clock to recognize that 180 minutes is *not* 6 hours. Seems to be a bug in there.
__________________
Commish GUBA
mad0die is offline   Reply With Quote
Old 07-06-2011, 01:17 PM   #342 (permalink)
Minors (Double A)
 
Join Date: Jan 2002
Posts: 146
Thanks: 27
Thanked 2x in 2 posts
Quote:
Originally Posted by fhomess View Post
Open the offending file in a text editor. Do a search and replace operation with "nan" as the search and "0" as the replace (that's the number zero). Reupload and import.
Thanks. Will I have to do this after every sim, or is this table one that doesn't have to be uploaded after every sim?
__________________

Wall of Fame: SP Mark Smolen /// C Steve Chastain /// OF Mohammed "Jihad" Amann /// OF Tony "HYPE" Ehmann
-----------------------------------------------
Hollywood Media Whores THREE-TIME FOBL CHAMPIONS 2007 2020 2035
sjshaw is offline   Reply With Quote
Old 07-07-2011, 05:06 PM   #343 (permalink)
Major Leagues
 
avwjase's Avatar
 
Join Date: Mar 2002
Location: Lexington, KY
Posts: 497
Thanks: 2
Thanked 2x in 1 post
Is there any plan to add AwardShares to Statslab? Or, is it there and I have just missed it?
__________________
Jase
St. Louis Cardinals - MLBRewind
Florida Marlins - eMLB

Last edited by avwjase; 07-07-2011 at 06:05 PM.
avwjase is offline   Reply With Quote
Old 07-11-2011, 10:31 AM   #344 (permalink)
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 585
Thanks: 3
Thanked 0x in 0 posts
Quote:
Originally Posted by sjshaw View Post
Thanks. Will I have to do this after every sim, or is this table one that doesn't have to be uploaded after every sim?
You'd have to do it each time.
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 07-11-2011, 11:35 AM   #345 (permalink)
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 2,749
Thanks: 15
Thanked 275x in 125 posts
Quote:
Originally Posted by BleedingCubbyBlue View Post
Quote:
Originally Posted by sjshaw View Post
Thanks. Will I have to do this after every sim, or is this table one that doesn't have to be uploaded after every sim?
You'd have to do it each time.
Actually, the history tables are only updated once a year, so you don't HAVE to load this one after every sim. Update it when your league hits the offseason, and you should be ok.

Quote:
Originally Posted by avwjase View Post
Is there any plan to add AwardShares to Statslab? Or, is it there and I have just missed it?
Not at this point.
__________________
StatsLab11 - PHP/MySQL based utilities for Online Leagues
Other Mods:
19th Century: Schedules, FaceGen
BBCards: 1887 Allen & Ginter, 1934 Goudey, 1988 Score, 1996 fhomess, 2005 fhomess
FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds

PEBA - Connecticut Nutmeggers

Last edited by fhomess; 07-11-2011 at 11:45 AM.
fhomess is offline   Reply With Quote
Old 07-12-2011, 01:09 PM   #346 (permalink)
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 2,749
Thanks: 15
Thanked 275x in 125 posts
For those of you subscribed to this thread, I've released the first basic StatsLab12. See the thread here: StatsLab12
__________________
StatsLab11 - PHP/MySQL based utilities for Online Leagues
Other Mods:
19th Century: Schedules, FaceGen
BBCards: 1887 Allen & Ginter, 1934 Goudey, 1988 Score, 1996 fhomess, 2005 fhomess
FaceGen: 1960-Pres MLB, 32 Colleges, Backgrounds

PEBA - Connecticut Nutmeggers
fhomess is offline   Reply With Quote
Old 07-18-2011, 12:43 AM   #347 (permalink)
Minors (Double A)
 
Ramzavail's Avatar
 
Join Date: Apr 2002
Location: NY
Posts: 187
Thanks: 4
Thanked 1x in 1 post
check out my standings page on statslab.

Regular Season Standings - StatsLab for OOTP11

the southern conference should have a division called the "City Division" like on the OOTP standings reports.

why would this happen?
__________________
OOTP solo league - www.nybaleague.com
Ramzavail is offline   Reply With Quote
Old 07-21-2011, 10:41 AM   #348 (permalink)
Minors (Double A)
 
snake1399's Avatar
 
Join Date: Feb 2009
Location: Detroit
Posts: 157
Thanks: 2
Thanked 0x in 0 posts
I've had an issue just over the past few days in the USBL. I run 3 different Leagues there and haven't had any issues at all with the Utils, but suddenly in all 3 the SQL's are not loading properly and giving me error messages. I've got the dump down to 41 necessary files and still getting an error message. Anyone seen this or know of a solution? My host has reloaded the software but that hasn't solved anything.

thanks!
Snake

Error message starts like this and goes downward:

ERROR in divisions:
insert into `divisions` VALUES (100, 0, 0, "", 0); -> Duplicate entry '100-0-0' for key 1
ERROR in divisions:
insert into `divisions` VALUES (100, 1, 0, "", 0); -> Duplicate entry '100-1-0' for key 1
ERROR in divisions:
insert into `divisions` VALUES (101, 0, 1, "", 0); -> Duplicate entry '101-0-1' for key 1
ERROR in divisions:
__________________
USBL/USLBM/NBL/WBL Commissioner
snake1399 is offline   Reply With Quote
Old 07-23-2011, 12:17 PM   #349 (permalink)
Hall Of Famer
 
molarmite's Avatar
 
Join Date: Jul 2005
Location: Minnesota
Posts: 4,790
Blog Entries: 1
Thanks: 42
Thanked 81x in 53 posts
Is there a way to make the draft utility work with leagues with scouting and each team see their scouts rating only?
__________________
From the wise mind of Davey Eckstein[/SIZE]

"Now all you need is a signature. A quote or initial, perhaps."


molarmite is offline   Reply With Quote
Old 07-23-2011, 03:47 PM   #350 (permalink)
All Star Reserve
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 953
Thanks: 18
Thanked 39x in 26 posts
Quote:
Originally Posted by molarmite View Post
Is there a way to make the draft utility work with leagues with scouting and each team see their scouts rating only?
No, that is not possible. Actually, in a league with scouting, you pretty much have to hide ratings altogether in StatsLab, or else everyone will be able to see the true ratings totally negating scouting reports.
beorn is offline   Reply With Quote
Old 08-07-2011, 07:33 AM   #351 (permalink)
All Star Reserve
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 953
Thanks: 18
Thanked 39x in 26 posts
Dog Days is moving to 12 this week. Someone somewhere mentioned in passing that Stats Lab will work with the current patch of 12, but I had thought it does not at this point.

Anyone know for sure?
beorn is offline   Reply With Quote
Old 11-28-2011, 11:57 AM   #352 (permalink)
Minors (Double A)
 
Join Date: Aug 2002
Location: Wisconsin
Posts: 147
Thanks: 1
Thanked 0x in 0 posts
So...anyone know how to get Statslab to recognize 4 expansion teams for the amateur draft? It sees them for standings, owners info, exports, etc. It even lists them in the draft admin and runs through our now 28 teams. however, the draft order only runs through 24 teams and I cannot figure out how to change this to 28. Any ideas?
thickman1 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 02:34 PM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments