Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

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

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

Reply
 
Thread Tools
Old 12-21-2010, 03:16 PM   #141
WillieMaysHayes
Minors (Double A)
 
WillieMaysHayes's Avatar
 
Join Date: Jul 2010
Location: Denver, CO
Posts: 143
Thanks: 14
Thanked 13x in 9 posts
Quote:
Originally Posted by Cooleyvol View Post
There's a character limit. Set up a forwarding email that will forward to the owner email list.
Hey Cooley do you have any suggestions on an email service that will do this? I tried gmail but it won't allow me without sending out approvals to everyone I forward to.

I need to run an OOTP idea by you as well that I'm curious to see what you'll think of...but I'll PM ya maybe this weekend!
WillieMaysHayes is offline   Reply With Quote
Old 12-21-2010, 03:25 PM   #142
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
If your webspace has cpanel, go in and create an email address. Then create forwarders from that address to the addresses of all your owners.


In statslab, input the address you created in your cpanel. Every email sent to that address forwards to all your owners.
Cooleyvol is offline   Reply With Quote
Old 12-26-2010, 08:46 PM   #143
WillieMaysHayes
Minors (Double A)
 
WillieMaysHayes's Avatar
 
Join Date: Jul 2010
Location: Denver, CO
Posts: 143
Thanks: 14
Thanked 13x in 9 posts
Quote:
Originally Posted by Cooleyvol View Post
When the timer is set for example, 2 hours and turns off for the night halfway through that two hours, why does it give the team a fresh timer starting when it turns back on in the morning?


EXAMPLE:

2 hour timer. Off at 10pm; on at 8am.
Pick made at 9pm. Next pick is due at 10am the next morning when it should be 9am the next morning.

I'm having this issue as well and no matter how many times I have reset the times etc it still gives the person the full draft allotted time for the next day.
WillieMaysHayes is offline   Reply With Quote
Old 12-30-2010, 07:16 AM   #144
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Thanks: 5
Thanked 1x in 1 post
Quote:
Originally Posted by Cooleyvol View Post
When the timer is set for example, 2 hours and turns off for the night halfway through that two hours, why does it give the team a fresh timer starting when it turns back on in the morning?


EXAMPLE:

2 hour timer. Off at 10pm; on at 8am.
Pick made at 9pm. Next pick is due at 10am the next morning when it should be 9am the next morning.
Having this problem too. Also, pausing the draft on weekends doesn't seem to be working.
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 12-31-2010, 05:37 PM   #145
beorn
All Star Starter
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,263
Thanks: 36
Thanked 130x in 71 posts
Quote:
Originally Posted by sporr View Post
In my case, it was because in the config file I was using the absolute server path:

/ootpu for example. fhomess fixed it by using:

../../ootpu instead.
Thanks for posting this. In a million years I would not have gotten this going without this info.
__________________
Commish of Dog Days Baseball
Commish Pennant Chase Baseball League (PCBL)
Commish and Blue Jays GM Extra Innings Baseball
beorn is offline   Reply With Quote
Old 12-31-2010, 10:49 PM   #146
Dbobola22
Minors (Triple A)
 
Join Date: Jun 2003
Posts: 226
Thanks: 2
Thanked 9x in 9 posts
How do I update StatsLab after each sim? I am new to this (obviously!) and last time I tried I re-installed entire thing and of course lost all my settings..
__________________
Commissioner:
Paramount Baseball League (running7-years real time)
American Baseball Legion (a new OOTP18 Startup)
Dbobola22 is offline   Reply With Quote
Old 12-31-2010, 11:35 PM   #147
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
Quote:
Originally Posted by Dbobola22 View Post
How do I update StatsLab after each sim? I am new to this (obviously!) and last time I tried I re-installed entire thing and of course lost all my settings..
Reupload the required .sql files after you create them in the game. Then load them from inside statslab.
Cooleyvol is offline   Reply With Quote
Old 01-01-2011, 07:54 AM   #148
Dbobola22
Minors (Triple A)
 
Join Date: Jun 2003
Posts: 226
Thanks: 2
Thanked 9x in 9 posts
"Reupload the required .sql files after you create them in the game. Then load them from inside statslab."

So I would go in game to Database, then Tools.
1) then hit configure SQL dump for MySQL
2) then hit create SQL dump for My SQL
3) go into StatsLab and hit Load SQL files?

I do not need to go into any FTP, etc?


Thanks for the help!
__________________
Commissioner:
Paramount Baseball League (running7-years real time)
American Baseball Legion (a new OOTP18 Startup)
Dbobola22 is offline   Reply With Quote
Old 01-01-2011, 08:29 AM   #149
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
Yes, you'll have to upload them via ftp before you can load them via statslab. You only have to 'configure SQL dump' in the game one time. The savings stick. You should create the 35 files required by statslab.
Cooleyvol is offline   Reply With Quote
Old 01-01-2011, 09:22 AM   #150
beorn
All Star Starter
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,263
Thanks: 36
Thanked 130x in 71 posts
My first time using StatsLab and when I go into the export checker I get this error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/561/6939/html/pcbl/StatsLab/exports.php on line 106

What might this be referring to?
__________________
Commish of Dog Days Baseball
Commish Pennant Chase Baseball League (PCBL)
Commish and Blue Jays GM Extra Innings Baseball
beorn is offline   Reply With Quote
Old 01-01-2011, 09:25 AM   #151
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
Are your exports housed in that folder inside the statslab app? Its looking for your export folder. Check the settings in the admin tab.
Cooleyvol is offline   Reply With Quote
Old 01-01-2011, 09:38 AM   #152
beorn
All Star Starter
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,263
Thanks: 36
Thanked 130x in 71 posts
Quote:
Originally Posted by Cooleyvol View Post
Are your exports housed in that folder inside the statslab app? Its looking for your export folder. Check the settings in the admin tab.
They are actually in: /pcbl/exports

On the admin page I have the export file path as ../../pcbl/exports (I have also tried ../pcbl/exports and /pcbl/exports -- but the none of these affect the error message in any way
__________________
Commish of Dog Days Baseball
Commish Pennant Chase Baseball League (PCBL)
Commish and Blue Jays GM Extra Innings Baseball
beorn is offline   Reply With Quote
Old 01-01-2011, 09:45 AM   #153
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
Open the exports.php file up in an editor that shows the line numbers. Go to line 106 and post that line. Therein lies the problem.
Cooleyvol is offline   Reply With Quote
Old 01-01-2011, 09:56 AM   #154
beorn
All Star Starter
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,263
Thanks: 36
Thanked 130x in 71 posts
Quote:
Originally Posted by Cooleyvol View Post
Open the exports.php file up in an editor that shows the line numbers. Go to line 106 and post that line. Therein lies the problem.
Line 106: while ($row=mysql_fetch_array($result))
__________________
Commish of Dog Days Baseball
Commish Pennant Chase Baseball League (PCBL)
Commish and Blue Jays GM Extra Innings Baseball
beorn is offline   Reply With Quote
Old 01-01-2011, 10:35 AM   #155
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
Quote:
Originally Posted by beorn View Post
Line 106: while ($row=mysql_fetch_array($result))
Above my head and never seen this error in multiple installs. I'll yield to fhomess on this one.
Cooleyvol is offline   Reply With Quote
Old 01-01-2011, 11:29 AM   #156
Dbobola22
Minors (Triple A)
 
Join Date: Jun 2003
Posts: 226
Thanks: 2
Thanked 9x in 9 posts
Quote:
Originally Posted by Cooleyvol View Post
Yes, you'll have to upload them via ftp before you can load them via statslab. You only have to 'configure SQL dump' in the game one time. The savings stick. You should create the 35 files required by statslab.

Okay so once I hit "SQL dump" I then go into file import_export and zip them up again (only the sql files) then go into FTP and extract them?

Would that be under /sqldump folder in FTP or /public_html/ootpsqlou ?

then I assume once thats done, just go into Statsload and hit load, I should be good to go?
__________________
Commissioner:
Paramount Baseball League (running7-years real time)
American Baseball Legion (a new OOTP18 Startup)
Dbobola22 is offline   Reply With Quote
Old 01-01-2011, 12:04 PM   #157
Dbobola22
Minors (Triple A)
 
Join Date: Jun 2003
Posts: 226
Thanks: 2
Thanked 9x in 9 posts
Hope you don't mind if I post a few more questions:

1) Under SQL Files, there is a list of file names with the options 'load/split' should these be loaded to fully utilize statslab?

2) When I did HOF voting I got this error message (below), what does it mean:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/paramoun/public_html/ootpsqlou/hall_of_fame.php on line 84

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/paramoun/public_html/ootpsqlou/hall_of_fame.php on line 213


3) How do I import and what files do I grab from in order to show a development tracker for player skills, HOF, etc.

thank you guys so much, I am a really dedicated OOTP commissioner who has no knowledge of anything MySQL etc but I am really trying my hardest here.
__________________
Commissioner:
Paramount Baseball League (running7-years real time)
American Baseball Legion (a new OOTP18 Startup)
Dbobola22 is offline   Reply With Quote
Old 01-01-2011, 01:52 PM   #158
beorn
All Star Starter
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,263
Thanks: 36
Thanked 130x in 71 posts
Quote:
Originally Posted by beorn View Post
They are actually in: /pcbl/exports

On the admin page I have the export file path as ../../pcbl/exports (I have also tried ../pcbl/exports and /pcbl/exports -- but the none of these affect the error message in any way
Solved. This is apparently the message you get if you are missing the Team relations file. I checked the wrong box.
__________________
Commish of Dog Days Baseball
Commish Pennant Chase Baseball League (PCBL)
Commish and Blue Jays GM Extra Innings Baseball
beorn is offline   Reply With Quote
Old 01-01-2011, 02:30 PM   #159
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
Quote:
Originally Posted by Dbobola22 View Post
Okay so once I hit "SQL dump" I then go into file import_export and zip them up again (only the sql files) then go into FTP and extract them?

Would that be under /sqldump folder in FTP or /public_html/ootpsqlou ?

then I assume once thats done, just go into Statsload and hit load, I should be good to go?
I don't zip them. I just upload them to the correct folder, then load them from statslab.
Cooleyvol is offline   Reply With Quote
Old 01-01-2011, 02:30 PM   #160
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
Quote:
Originally Posted by beorn View Post
Solved. This is apparently the message you get if you are missing the Team relations file. I checked the wrong box.
Glad you got it working.
Cooleyvol 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 04:42 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 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments