Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 10-09-2011, 11:39 PM   #1
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Statslab upload procedure question

Checking to see if any experienced statslab admins can help me out:

When i create the SQL dump in the game...its goes into a certain folder. I take those files and FTP the files to the SQL dump folder on my webserver....which is will load via the admin screen.

I am on the second time ever on FTPing files to the SQL dump folder...and I started to wonder...do the files that are already in that folder from the 1st dump need to be deleted 1st..or do the files overwrite when you ftp them the second time? The question is based on how big that Statslab SQL Dump folder can actually get.

Sorry if i am being confusing....though im a bit confuesed myself.
almo is offline   Reply With Quote
Old 10-10-2011, 09:12 AM   #2
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
No. Just overwrite them.
Cooleyvol is offline   Reply With Quote
Old 10-10-2011, 09:51 AM   #3
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
Good question almo. I deleted them the first 50 or so times I did it and finally wondered the same. As Cooley suggested, overwriting works just fine. I'm glad you figured it out faster than I did
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 10-10-2011, 11:53 AM   #4
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thank you boys!! Thats very good to know. I am sweating the small stuff obviously .

I actually have 2 secondary questions related to the statslab upload process:

1. When i look at the export tab I get a SQL error:

ERROR: No League File Found at: "game/lgfile/Fanatic Baseball League.lg.tar.gz"

My league file zipped is called

"game/lgfile/Fanatic Baseball League.tar.gz"

all of my gms have been able to access and export...and i am able to see it in the game...but...I am not sure how to get the ".lg" into that line (other than physically changing the file name structure of the league file on my webserver.

2a. When i look at the draft page...i get this sql error (but it still lists the order of the draft and all:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/fanatic/public_html/StatsLab/draftReport.php on line 189

Not sure what this is

2b. I am having an inagural draft to kick off the league...unfortunatley...the draft will be 125 rounds long (though i expect gms to click on auto pick somewhere after the 25th round).....the one thing i am seeing is that somewhere in the 46th round (after 45 rounds of serpentine)...it moves in another order. I mean I can call it after the 45th round if need be and just perform the auto pick in the actual game (or i can set it up for a 45 round draft and such..and do the rest in the game)...but wondering if there is a limit to how many rounds can be held in serpantine fashion...or if i am doing something wrong.

Again..sorry for the questions...but i am learning this all from the ground up. Maybe one day i can be a statslab resource (i feel like statslab is like a college course ..... and technically, i asked 3 questions. Any help i get is much appreciated!!! :P

Last edited by almo; 10-10-2011 at 12:02 PM.
almo is offline   Reply With Quote
Old 10-10-2011, 07:35 PM   #5
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
1. Fix the name of your league file in the Admin page.

2. I can't help ya out.
Cooleyvol is offline   Reply With Quote
Old 10-10-2011, 10:03 PM   #6
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
No matter what I change those setting to in the admin page..it still comes up with the same error. Actually in Fidel's video...he gets the same error when he goes on the export link.
almo is offline   Reply With Quote
Old 10-11-2011, 07:39 AM   #7
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,140
Quote:
Originally Posted by almo View Post
No matter what I change those setting to in the admin page..it still comes up with the same error. Actually in Fidel's video...he gets the same error when he goes on the export link.

try the below and the "X" are just marking out my path

1. Export Tracker Settings League Name: Fanatic Baseball League.tar.gz
League File Path: /home/fanatic/public_html/game/lgfile
Export File Path: /home/fanatic/public_html/xxx/xxx


2A. id need to see ur admin page

2B. i dont suggest doing that many rds in statslab i suggest maybe 10-20 then have them submit in game draft list thu the game for the remainder of the draft .
statslab i dont think can handle 125 rds i may be wrong on that but i wouldnt do it
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues

OOTP

POTD: Vermont/Co-Commish
MTBL: League Closed
The Show: Jacksonville Bombers
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed

DDSPF

WWPF- Miami

CSFL- Tampa

USFL: New Orleans

DDSCF

SNCFL: Florida/ JMU
soadeathdealer is offline   Reply With Quote
Old 10-11-2011, 12:30 PM   #8
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Quote:
Originally Posted by soadeathdealer View Post
try the below and the "X" are just marking out my path

1. Export Tracker Settings League Name: Fanatic Baseball League.tar.gz
League File Path: /home/fanatic/public_html/game/lgfile
Export File Path: /home/fanatic/public_html/xxx/xxx


2A. id need to see ur admin page

2B. i dont suggest doing that many rds in statslab i suggest maybe 10-20 then have them submit in game draft list thu the game for the remainder of the draft .
statslab i dont think can handle 125 rds i may be wrong on that but i wouldnt do it
You my friend are brilliant!! The export setting work now....and the SQL issue on the draft screen are no more!

I think we are going to do a 20 round draft in SL and then do autopick for the rest of the draft...something that is up for discussion in my league.

Again...thank you all!!!!
almo is offline   Reply With Quote
Old 10-11-2011, 12:36 PM   #9
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,140
Quote:
Originally Posted by almo View Post
You my friend are brilliant!! The export setting work now....and the SQL issue on the draft screen are no more!

I think we are going to do a 20 round draft in SL and then do autopick for the rest of the draft...something that is up for discussion in my league.

Again...thank you all!!!!

thank you im here to help the best i can , enjoy your league
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues

OOTP

POTD: Vermont/Co-Commish
MTBL: League Closed
The Show: Jacksonville Bombers
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed

DDSPF

WWPF- Miami

CSFL- Tampa

USFL: New Orleans

DDSCF

SNCFL: Florida/ JMU
soadeathdealer is offline   Reply With Quote
Old 11-10-2011, 02:14 PM   #10
CT-Sox-Fan
Minors (Double A)
 
Join Date: Sep 2006
Posts: 128
The files have the same names so your ftp application should ask if you want to overwrite the existing files. Filezilla does so.

Using filezilla as an example you would check the box to say overwrite and apply this to every file in this upload. The upload should then continue file by file, replacing the previous ones.

Hope that helps.

Dave
__________________
---------------------------------
Dave A.

MLBD- Toronto Blue Jays GM,
FCBL- Baltimore Orioles GM,
EIB- Texas Rangers GM
CT-Sox-Fan 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 09:15 PM.

 

Major League and Minor League Baseball trademarks and copyrights are used with permission of Major League Baseball. Visit MLB.com and MiLB.com.

Officially Licensed Product – MLB Players, Inc.

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 © 2023 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

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