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
Register Blogs FAQ Calendar Today's Posts Search

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

Reply
 
Thread Tools
Old 03-31-2010, 05:29 PM   #341
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,585
Quote:
Originally Posted by BaltimoreFan80 View Post
I have my league files and statlab on one server and I have my leaguefile and export files another because my main webhosting company when to a seure ftp which means ootp game can't acess the server. My question is this I have Statlab set up at www.rickhampton.org/ootpleague/ootpsqlou/index.html However I want my export file and leaguefile at www.rickhemler.site90.net/Exports
When I go to set up statlab the in the leaguefile path i put rickhemler.site90.net/Exports however when i go to export page i get this error

ERROR: No League File Found at: "http://www.rickhemler.site90.net/Exports/NMLB.lg.tar.gz"
/home/rickhamp/public_html/ootpleague/Dump/ootpsqlSettings.txt

Please Help
StatsLab's export tracker isn't currently designed to check files on other servers.
__________________
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 04-15-2010, 09:11 AM   #342
eMLBCommish
All Star Reserve
 
eMLBCommish's Avatar
 
Join Date: Mar 2003
Posts: 667
A bump to get a status check on StatsLab compatibility with OOTP 11. Any word?
__________________
The Fluffy Kitty Ninjas Show - Home of the eMLB Universe!
www.twitch.tv/FKNCommishLB

The Man Behind eMLB - https://atl-02.statsplus.net/emlb/re..._150_home.html

Proud OOTP Affiliate Streamer
Proud Twitch Partner (Partnered 3/15/22)
eMLBCommish is offline   Reply With Quote
Old 04-19-2010, 05:47 PM   #343
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,754
Quote:
Originally Posted by eMLBCommish View Post
A bump to get a status check on StatsLab compatibility with OOTP 11. Any word?
James, I have run it and find it to be 100% functional and compatible.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 04-20-2010, 04:14 PM   #344
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,131
Will this work ok in a game using scouts? I don't want anything real to be revealed. Can this be hidden?

I basically am looking at the draft utility and the upload tracker.

We are using OOTP 11.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 04-22-2010, 12:55 PM   #345
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,585
Quote:
Originally Posted by eMLBCommish View Post
A bump to get a status check on StatsLab compatibility with OOTP 11. Any word?
I haven't had any time to work on an OOTP11 version, but was under the impression the OOTPX version was compatible with 11. Thanks for confirming that, Matt.

Quote:
Originally Posted by Mike Lowe View Post
Will this work ok in a game using scouts? I don't want anything real to be revealed. Can this be hidden?

I basically am looking at the draft utility and the upload tracker.

We are using OOTP 11.
Scouted ratings are not included in the SQL dump, so the recommendation for these leagues would be to turn the ratings off in StatsLab (the admin screen lets you decide how/if to display ratings). You can still draft players using the util, but if you don't have feeder league stats, GM's will need to determine who they want using OOTP in conjunction with the util.
__________________
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 04-23-2010, 01:29 AM   #346
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,131
So do I need the download file plus ALL of the patches or just the most recent?

Also, the tutorial video shows some sort of web based software which I neither recognize nor know where to get.

I'm really confused on how to set this up but would like to support it because it looks good.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 04-26-2010, 09:57 AM   #347
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,754
Quote:
Originally Posted by fhomess View Post
I haven't had any time to work on an OOTP11 version, but was under the impression the OOTPX version was compatible with 11. Thanks for confirming that, Matt.


Scouted ratings are not included in the SQL dump, so the recommendation for these leagues would be to turn the ratings off in StatsLab (the admin screen lets you decide how/if to display ratings). You can still draft players using the util, but if you don't have feeder league stats, GM's will need to determine who they want using OOTP in conjunction with the util.
Actually, there are a couple things not working in OOTP11. For example, last sim isn't working correctly. You can see an example here:

http://baseballretrospective.com/MBBA/statslab/

Let me know what you find out.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 04-28-2010, 11:36 AM   #348
eMLBCommish
All Star Reserve
 
eMLBCommish's Avatar
 
Join Date: Mar 2003
Posts: 667
Here's my problem. I must be missing a step, despite following Fidel's video closely. Says I don't have settings configured properly. Any advice?

__________________
The Fluffy Kitty Ninjas Show - Home of the eMLB Universe!
www.twitch.tv/FKNCommishLB

The Man Behind eMLB - https://atl-02.statsplus.net/emlb/re..._150_home.html

Proud OOTP Affiliate Streamer
Proud Twitch Partner (Partnered 3/15/22)
eMLBCommish is offline   Reply With Quote
Old 04-28-2010, 02:11 PM   #349
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,754
disregard this post.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)

Last edited by Recte44; 04-28-2010 at 08:32 PM.
Recte44 is offline   Reply With Quote
Old 04-30-2010, 03:15 PM   #350
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,585
Quote:
Originally Posted by Recte44 View Post
Actually, there are a couple things not working in OOTP11. For example, last sim isn't working correctly. You can see an example here:

http://baseballretrospective.com/MBBA/statslab/

Let me know what you find out.
Sorry for the slow response. Various things have kept me from getting around to starting up OOTP11 until yesterday. That said, I haven't been able to reproduce this in my own install. My initial thought would be to verify that you've got all the SQL files from OOTP11 loaded and that you don't have an old OOTPX one in there. Otherwise, I'd be happy to look more closely if you PM me with commish access.

As for an "official" OOTP11 version of StatsLab... I have some things I'm working on in that regard, but I don't expect it to be completed quickly as I'd like to rework some of the underlying structure.
__________________
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 05-05-2010, 01:01 PM   #351
jmantemp
Minors (Single A)
 
Join Date: Mar 2007
Posts: 61
PHP Headers ?

Love StatsLab and have been using it for a while now. Recently - since the last update I believe - I've been getting this: "Warning: Cannot modify header information - headers already sent by (output started at /home/mu290nb7/ootpsql/dbopen.php:4) in /home/mu290nb7/public_html/ootpsqlou/asProcess.php on line 102."

It hasn't impacted anything while loading files, but it appears to have made voting for the All-Star Game, Post Season Awards, etc. difficult. Is there an easy fix for this? Thanks!
jmantemp is offline   Reply With Quote
Old 05-05-2010, 07:10 PM   #352
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,131
Is there a setting via admin to allow the ".lg" extension to not be listed when the utility is trying to link to the league file? I don't use this extension and it's searching for my league file, which is name sbmnetwork.tar.gz, here:

/sbmnetwork.lg.tar.gz

Is there a way to have it look for my file exactly?
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 05-05-2010, 09:45 PM   #353
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,131
Also, any idea as to why when I put a team in at pick 30 in the 1st round, after I save Arizona appears in spot 30 and all other teams in round two are bumped down and the Yankees are now at pick 1 in round 2?

This happens with any round BTW.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 05-06-2010, 01:14 PM   #354
jmantemp
Minors (Single A)
 
Join Date: Mar 2007
Posts: 61
Quote:
Originally Posted by jmantemp View Post
Love StatsLab and have been using it for a while now. Recently - since the last update I believe - I've been getting this: "Warning: Cannot modify header information - headers already sent by (output started at /home/mu290nb7/ootpsql/dbopen.php:4) in /home/mu290nb7/public_html/ootpsqlou/asProcess.php on line 102."

It hasn't impacted anything while loading files, but it appears to have made voting for the All-Star Game, Post Season Awards, etc. difficult. Is there an easy fix for this? Thanks!
I fixed this error. Apparently some Javascript got put into my dbopen file which certainly didn't need to be there.
jmantemp is offline   Reply With Quote
Old 05-06-2010, 11:51 PM   #355
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,131
Quote:
Originally Posted by Mike Lowe View Post
Also, any idea as to why when I put a team in at pick 30 in the 1st round, after I save Arizona appears in spot 30 and all other teams in round two are bumped down and the Yankees are now at pick 1 in round 2?

This happens with any round BTW.
Anyone? Take a look at the problem here:
Amateur Draft Report - StatsLab for OOTPX

There are only 29 teams drafting each round instead of 30.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 05-07-2010, 12:27 AM   #356
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,585
Quote:
Originally Posted by Mike Lowe View Post
Anyone? Take a look at the problem here:
Amateur Draft Report - StatsLab for OOTPX

There are only 29 teams drafting each round instead of 30.
That's certainly odd. I'm not sure why it'd be doing that, but if you'd be willing to PM me with commish credentials for StatsLab (just change your password temporarily), then I'll log in as you and take a look and see if I can't figure out what's going on. I've not seen this behavior before.
__________________
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 05-07-2010, 12:29 AM   #357
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,585
Quote:
Originally Posted by Mike Lowe View Post
Is there a setting via admin to allow the ".lg" extension to not be listed when the utility is trying to link to the league file? I don't use this extension and it's searching for my league file, which is name sbmnetwork.tar.gz, here:

/sbmnetwork.lg.tar.gz

Is there a way to have it look for my file exactly?
Try entering the filename and extension (e.g. sbmnetwork.tar.gz) into the league name field on your admin page.
__________________
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 05-07-2010, 06:39 PM   #358
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,754
Suggestions/Requests for OOTP11 Version

1) Batters pitching potential and pitchers batting potential needed to be viewed (especially for draft)
2) Draft Signing Bonus info (demand $, signability, etc)

I'll add more as I think of them.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 05-07-2010, 07:02 PM   #359
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,131
PM sent.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 05-09-2010, 06:16 PM   #360
bayken37
Minors (Single A)
 
Join Date: Apr 2005
Location: Paris, France
Posts: 76
I apologize if this has already been answered, but I was wondering if there is a way to add in the sandwich picks when using the Draft Utility on this mod?
__________________
Commissioner, Vis-à-Vis Baseball, VaV Hoops, & VaV Ice
bayken37 is offline   Reply With Quote
Reply

Bookmarks


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:12 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