Home | Webstore
Latest News: OOTP 18.8.76 Update Available - OOTP 18 Available - FHM 4 Available - MLB Manager 2017 Available Now

Franchise Hockey Manager 4 Available

  

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

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

Reply
 
Thread Tools
Old 07-12-2011, 01:42 PM   #1
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,443
Thanks: 162
Thanked 1,151x in 435 posts
StatsLab12

It has been a couple of weeks so it's time to have an updated version of StatsLab that will work with OOTP12. I haven't made any enhancements or improvements yet, and I haven't tested every page thoroughly. The read me is not updated either. Hence, this is officially version 0.0.1. When 1.0.0 comes out, there will be some enhancements and improvements.

NOTE: Links and web styles require that you use the full reports. I haven't done anything with the SQL reports upload yet.

In the meantime, this should work: StatsLab12.zip

One thing to note, the SQL configuration in OOTP12 has some additional options. The following should be checked:
  • Insert DROP TABLE command
  • Insert CREATE TABLE command
  • Insert single quotes if empty
  • Insert NULL if empty
The following SHOULD NOT be checked:
  • Include field names in inserts
The following are optional:
  • Replace accents - If you're having problems with accents, check this. Otherwise, leave it unchecked.
  • Dump only cities in use - StatsLab doesn't currently use the cities table
  • Dump only nations in use - StatsLab doesn't currently use the nations table


I'll update this post and thread when I've got more for all of you.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.

Last edited by fhomess; 07-14-2011 at 12:05 PM.
fhomess is offline   Reply With Quote
5 thanks for this post:
cody8200 (07-17-2011), goosedennis (12-01-2011), Killebrew (04-28-2012), mcarlisle21 (07-30-2011), soadeathdealer (09-28-2011)
Old 07-12-2011, 02:02 PM   #2
Cooleyvol
Hall Of Famer
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,120
Thanks: 59
Thanked 573x in 339 posts
First in. Thanks, Frank!
Cooleyvol is offline   Reply With Quote
Old 07-17-2011, 03:57 PM   #3
patriotcoach
Minors (Double A)
 
Join Date: Apr 2002
Posts: 183
Thanks: 10
Thanked 4x in 4 posts
Anybody got this set up for an OOTP12 league yet?

Any problems so to speak?
patriotcoach is offline   Reply With Quote
Old 07-18-2011, 08:52 PM   #4
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,315
Thanks: 1,741
Thanked 1,068x in 451 posts
So far, so good. Working like a champ. Thanks for this Frank. You are awesome!
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 07-19-2011, 02:27 PM   #5
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 3x in 3 posts
Same install instructions that were used in 11? Is there anything different from an install perspective with regards to 12?

Thanks for any help I can get.

Soon to be new OOTP commish.

Almo
almo is offline   Reply With Quote
Old 07-19-2011, 04:04 PM   #6
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,315
Thanks: 1,741
Thanked 1,068x in 451 posts
The same instructions work just fine. At least they did for me. Good luck commish.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 07-20-2011, 01:56 PM   #7
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,315
Thanks: 1,741
Thanked 1,068x in 451 posts
Frank,

It seems the finance stuff is currently not working. I'm seeing this on the finance sheet.

Projected Payroll - StatsLab for OOTP12
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb

Last edited by cody8200; 07-20-2011 at 03:10 PM.
cody8200 is offline   Reply With Quote
Old 07-20-2011, 08:56 PM   #8
MikeyB
Minors (Double A)
 
MikeyB's Avatar
 
Join Date: Jun 2010
Location: Calgary, AB
Posts: 118
Thanks: 21
Thanked 8x in 7 posts
I'm getting the following errors after installing, when logging in. Can anyone help?

Quote:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbml/public_html/StatsLab/login.php on line 151
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/ootpbml/public_html/StatsLab/login.php on line 168
__________________
BML Commish
www.ootp-bml.com
MikeyB is offline   Reply With Quote
Old 07-21-2011, 12:28 AM   #9
hank9481
Major Leagues
 
hank9481's Avatar
 
Join Date: Jun 2002
Posts: 388
Blog Entries: 1
Thanks: 0
Thanked 9x in 9 posts
Quote:
Originally Posted by fhomess View Post

One thing to note, the SQL configuration in OOTP12 has some additional options. The following should be checked:
  • Insert DROP TABLE command
  • Insert CREATE TABLE command
  • Insert single quotes if empty
  • Insert NULL if empty
The following SHOULD NOT be checked:
  • Include field names in inserts
I can't explain why, but my version of OOTP 12 doesn't have these options available. Has anyone else encountered this?

EDIT: I now see why. It's a bug. I converted from OOTP X to OOTP 12. Obviously will need to be fixed.
__________________
HH
www.mblsim.com

Last edited by hank9481; 07-21-2011 at 12:30 AM.
hank9481 is offline   Reply With Quote
Old 07-21-2011, 09:49 AM   #10
sdodd
Major Leagues
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 330
Thanks: 53
Thanked 67x in 31 posts
I too am getting these errors when logging in

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mlob/public_html/StatsLab/login.php on line 151

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mlob/public_html/StatsLab/login.php on line 168

Also, it will not save any of my contact information.. Just resets to blank boxes

Last edited by sdodd; 07-21-2011 at 09:50 AM.
sdodd is offline   Reply With Quote
Old 07-21-2011, 09:49 PM   #11
sdodd
Major Leagues
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 330
Thanks: 53
Thanked 67x in 31 posts
Quote:
Originally Posted by sdodd35@yahoo.com View Post
I too am getting these errors when logging in

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mlob/public_html/StatsLab/login.php on line 151

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/mlob/public_html/StatsLab/login.php on line 168

Also, it will not save any of my contact information.. Just resets to blank boxes
Ok, I figured out a solution to the above errors... first create a backup of your current login.php that is currently on your server. Then replace it with the attached file. I have been testing it and it seems to be working correctly
Attached Files
File Type: zip login.zip (2.8 KB, 35 views)
sdodd is offline   Reply With Quote
Old 07-21-2011, 10:10 PM   #12
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,315
Thanks: 1,741
Thanked 1,068x in 451 posts
Quote:
Originally Posted by hank9481 View Post
I can't explain why, but my version of OOTP 12 doesn't have these options available. Has anyone else encountered this?

EDIT: I now see why. It's a bug. I converted from OOTP X to OOTP 12. Obviously will need to be fixed.
I had this issue as well. It's because you ootp 11 import saves the sql config. files. The new options in 12 weren't on the old config files. Simply delete that config file and it will give you all of the options. I would tell you where that location is but I'm not on my home PC right now. Sorry.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 07-21-2011, 11:32 PM   #13
OpeningDay85
Minors (Single A)
 
Join Date: Apr 2011
Posts: 72
Thanks: 8
Thanked 14x in 8 posts
Thank you Sdodd! First time user here and excited about it
OpeningDay85 is offline   Reply With Quote
Old 07-22-2011, 02:29 AM   #14
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,443
Thanks: 162
Thanked 1,151x in 435 posts
File updated with some minor fixes:
1. Login page will no longer cause errors and user info will save properly.
2. Coded around issues with #INF errors in SQL load.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Thank you for this post:
sdodd (07-23-2011)
Old 07-22-2011, 11:27 AM   #15
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,315
Thanks: 1,741
Thanked 1,068x in 451 posts
I'm still getting the following message on the contract/finance screens

Contract screen:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 102

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 103

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 178

Payroll (front office screen)

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 513

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 514

Warning: arsort() expects parameter 1 to be array, null given in /home/ootpbeli/public_html/StatsLab/payroll.php on line 623
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 07-22-2011, 11:53 AM   #16
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,443
Thanks: 162
Thanked 1,151x in 435 posts
Quote:
Originally Posted by cody8200 View Post
Contract screen:

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 102

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 103

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 178

Payroll (front office screen)

Warning: mysql_num_fields(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 513

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/ootpbeli/public_html/StatsLab/payroll.php on line 514

Warning: arsort() expects parameter 1 to be array, null given in /home/ootpbeli/public_html/StatsLab/payroll.php on line 623
Hmm... these are all related to the fact that the SQL dump no longer contains fields for whether or not the last year of a player contract is a team or player option. The contract extensions table does have these fields.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 07-22-2011, 12:03 PM   #17
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,315
Thanks: 1,741
Thanked 1,068x in 451 posts
Weird. The contract extension sql file is def. loaded. I just went back to the file load list to make sure.
Attached Images
Image 
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb

Last edited by cody8200; 07-22-2011 at 12:05 PM.
cody8200 is offline   Reply With Quote
Old 07-23-2011, 12:14 PM   #18
Tony M
Global Moderator
 
Tony M's Avatar
 
Join Date: Feb 2006
Location: Here
Posts: 6,150
Blog Entries: 3
Thanks: 41
Thanked 326x in 188 posts
A quick question Frank. I have a universe with four major leagues - is there a way of not having StatsLab defaulting to one particular league.
__________________
This signature is intentionally blank
Tony M is offline   Reply With Quote
Old 07-23-2011, 12:27 PM   #19
Cooleyvol
Hall Of Famer
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,120
Thanks: 59
Thanked 573x in 339 posts
Quote:
Originally Posted by Tony M View Post
A quick question Frank. I have a universe with four major leagues - is there a way of not having StatsLab defaulting to one particular league.
None that I know of.

I have three and installed three statslab apps with each set to default to its league.
Cooleyvol is offline   Reply With Quote
Old 07-23-2011, 08:29 PM   #20
OpeningDay85
Minors (Single A)
 
Join Date: Apr 2011
Posts: 72
Thanks: 8
Thanked 14x in 8 posts
2 Things....

1. When I try to load all the SQL Files through StatsLab I am able to load everything except the league_history_batting_stats.mysql.sql and players.mysql.sql files.

I get the following errors....


league_history_batting_stats.mysql.sql
Loading league_history_batting_stats.mysql.sql
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
insert into `league_history_batting_stats` VALUES (0, 0, 0, 0, 0, 0, 86187, 77467, 20131, 15214, 0, 0, 4016, 368, 2209, 1505, 540, 0, 10097, 7367, 0, 727, 0, 626, 0, 0, 2268, 0, 6593, 0, 0.2599, 0.3275, 0.4068, 11040.9813, 5.0957, 0.1469, 1.#INF, 0.7342, 73.5941, 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, 97794, 87886, 22423, 19092, 0, 0, 4470, 498, 2404, 1454, 589, 0, 11211, 8411, 0, 822, 0, 675, 0, 0, 2592, 0, 7372, 0, 0.2551, 0.3237, 0.3994, 12168.1925, 4.9237, 0.1443, 1.#INF, 0.7231, 71.1698, 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
... 282 queries executed

players.mysql.sql
... 42000 queries executed
insert into `players` VALUES (31388, 0, 0, "Lloyd", "Shunick\", "", 18, "1992-10-2", 81480, 206, 0, 220, 201, 0, 1, 100, 0, 0, 0, 0, -1, 23, 0, 0, 1, 1, 166, 104, 37, 29, 118, 72, "", "", 0, 0, 0, 0, 0, 0, 0, 0, 52, 51, 42, 63, 0, 0, 0, 0, 0, 0, 0, 0, 16, 1, 1, 3, 0, 0, 0, 0, 0, 1, 0, 100, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 6, 0); -> 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 '1992-10-2", 81480, 206, 0, 220, 201, 0, 1, 100, 0, 0, 0, 0, -1, 23, 0, 0, 1, 1, ' at line 1
... 42587 queries executed

2. I am trying to set up the draft ultity to no avil. We have already started the draft on our forums and so right now I need to manually enter our first 2 rounds through statslab. When selected manual pick, I am then needed to enter a player ID. When I do that, I get the following error

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/primetim/public_html/StatsLab/draftProcess.php on line 383
player not draft eligible



Any help or direction would be greatly appreciated. Thanks!
OpeningDay85 is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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

Forum Jump


All times are GMT -4. The time now is 07:59 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
Copyright © 2015 Out of the Park Developments