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 08-03-2010, 09:38 AM   #21
DWK
All Star Reserve
 
DWK's Avatar
 
Join Date: Mar 2007
Location: Bluffton, South Carolina
Posts: 631
Thanks: 31
Thanked 21x in 18 posts
Still can't get the season ending awards button to show up I re-download the
statLab 11 and i have it check on the admin page

What version is the new StatLab? maybe I'm not on the right version
DWK is offline   Reply With Quote
Old 08-09-2010, 02:31 PM   #22
ootpFox07
All Star Starter
 
ootpFox07's Avatar
 
Join Date: Dec 2005
Posts: 1,632
Thanks: 1,217
Thanked 569x in 286 posts
Quote:
Originally Posted by Corsairs View Post
If you're the commissioner of an online league, you simply must put this amazing tool into play. StatsLab was already the preeminent utility suite for online OOTP leagues. With this new release, fhomess has (literally) turned it up to "11". It's never been easier to conduct a draft through StatsLab; every little touch (like user-customizable auto-refreshing of the Draft Results page) makes running things a breeze. Owners now have a plethora of new information at their fingertips. Old menus like the Projected Free Agents page have had new life breathed into them with little touches like the addition of current-year stats, making it easier to determine whom you'd like to target in the upcoming offseason. There's even fun little additions like tons of new Stats of the Day; you'll lose all kinds of time discovering all kinds of little factoids you never knew about your league.

Running an online league without StatsLab is something I could never dream of at this point. Simply put, it's an invaluable tool. Grab it, enjoy it, reap the praise from your owners. Your league will be a better place for it.
What he said! Online or offline, StatsLab is a MUST HAVE mod for OOTP leagues. I think Frank might be sick of the thank you emails and PMs I've sent him at this point.
__________________
Mods:
ootpFox07 is offline   Reply With Quote
Old 08-10-2010, 05:37 PM   #23
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,176x in 442 posts
Quote:
Originally Posted by DWK View Post
Still can't get the season ending awards button to show up I re-download the statLab 11 and i have it check on the admin page
Fixed.

Quote:
Originally Posted by DesertFox07 View Post
I think Frank might be sick of the thank you emails and PMs I've sent him at this point.
Not at all, these are much more enjoyable than all the bug reports I get.
__________________
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 08-15-2010, 01:34 AM   #24
GWUlery
Minors (Single A)
 
GWUlery's Avatar
 
Join Date: Dec 2009
Posts: 60
Thanks: 3
Thanked 0x in 0 posts
I'm working on setting this up for my league and have run into some troubles. When I click on the "Save" button on the admin page, it will save the Server Settings, Export Tracker Settings, and OOTP Settings, but will not save the selected Enabled Pages. I'm not able to access anything but the admin and SQL pages at this point (I can't even log out and access the login page unless it's the first thing I point my browser to).

Any suggestions?

Thanks!
__________________
Baseball Stars Association Commissioner - Check Us Out! http://www.thebaseballstars.org/BSA
GWUlery is offline   Reply With Quote
Old 08-17-2010, 11:51 AM   #25
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,624
Thanks: 254
Thanked 176x in 104 posts
Setup the new program with my old SQL directory and everything worked fine except......all the development history is not showing up.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 08-17-2010, 11:57 AM   #26
eMLBCommish
All Star Reserve
 
eMLBCommish's Avatar
 
Join Date: Mar 2003
Posts: 618
Thanks: 6
Thanked 17x in 11 posts
Silly question of the day:

Does it matter when I install StatsLab 11? I just transferred servers, so my old StatsLab is needing to be tweaked for the correct locations now, but I figure I can just install 11.

FYI: I'm on June 1st in my online league.

Thanks for your input!
__________________
Member of SimNation
eMLBCommish is offline   Reply With Quote
Old 08-17-2010, 03:34 PM   #27
udbacker58
All Star Starter
 
udbacker58's Avatar
 
Join Date: Apr 2007
Posts: 1,140
Thanks: 82
Thanked 115x in 73 posts
Quote:
Originally Posted by eMLBCommish View Post
Silly question of the day:

Does it matter when I install StatsLab 11? I just transferred servers, so my old StatsLab is needing to be tweaked for the correct locations now, but I figure I can just install 11.

FYI: I'm on June 1st in my online league.

Thanks for your input!
LB, I installed StatsLab 11 for the USBA during the playoffs....while we were still on OOTP X, with no problems.
__________________
Heartland Baseball League Commissioner
Fictional - Stats Only - 30 years of History!
HBL HOME PAGE | HBL REPORTS HOME | HBL UTILITIES HOME
udbacker58 is offline   Reply With Quote
Old 08-17-2010, 05:00 PM   #28
sporr
Global Moderator
 
sporr's Avatar
 
Join Date: Dec 2001
Location: Muscatine, IA
Posts: 8,277
Thanks: 2
Thanked 41x in 2 posts
Does this happen to work with inaugural drafts?

Last edited by sporr; 08-17-2010 at 09:55 PM.
sporr is offline   Reply With Quote
Old 08-18-2010, 10:40 AM   #29
Corsairs
Hall Of Famer
 
Corsairs's Avatar
 
Join Date: Aug 2007
Posts: 2,357
Thanks: 2,571
Thanked 878x in 393 posts
Quote:
Originally Posted by fhomess View Post
Quote:
Originally Posted by DesertFox07 View Post
I think Frank might be sick of the thank you emails and PMs I've sent him at this point.
Not at all, these are much more enjoyable than all the bug reports I get.
Yeah, who keeps nagging fhomess with bug reports? I say we string that guy up by his toes! What's that? It's me? Oh...
__________________
Founder of the Planetary Extreme Baseball Alliance (PEBA)
Premiere OOTP fictional league where creativity counts and imagination is your only limitation
Check for openings - contact us today!
Corsairs is offline   Reply With Quote
Old 08-18-2010, 12:38 PM   #30
GWUlery
Minors (Single A)
 
GWUlery's Avatar
 
Join Date: Dec 2009
Posts: 60
Thanks: 3
Thanked 0x in 0 posts
I'm still having quite a few issues getting this set up. Are there any gurus available that might be able to help a fellow commissioner out?

Thanks!
__________________
Baseball Stars Association Commissioner - Check Us Out! http://www.thebaseballstars.org/BSA
GWUlery is offline   Reply With Quote
Old 08-18-2010, 04:29 PM   #31
udbacker58
All Star Starter
 
udbacker58's Avatar
 
Join Date: Apr 2007
Posts: 1,140
Thanks: 82
Thanked 115x in 73 posts
Quote:
Originally Posted by Corsairs View Post
Yeah, who keeps nagging fhomess with bug reports? I say we string that guy up by his toes! What's that? It's me? Oh...
lol and me
__________________
Heartland Baseball League Commissioner
Fictional - Stats Only - 30 years of History!
HBL HOME PAGE | HBL REPORTS HOME | HBL UTILITIES HOME
udbacker58 is offline   Reply With Quote
Old 08-18-2010, 05:03 PM   #32
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,379
Thanks: 1,837
Thanked 1,147x in 474 posts
Is there anyway to run this on a local machine -solo league?

Do you really have to upload 250 megs of HTML data everytime you run a sim or am I missing something?

I'm trying to set this up for a solo league and I'm uploading it the same way I would if I was running a multiplayer league. I'm sure it would be a much quicker process to be able to run it on my own local machine if its possible. Does anyone know?
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 08-19-2010, 11:51 AM   #33
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,176x in 442 posts
Quote:
Originally Posted by Recte44 View Post
Setup the new program with my old SQL directory and everything worked fine except......all the development history is not showing up.
Can you PM me a link to your new install and commish access? I'll take a look.

Quote:
Originally Posted by sporr View Post
Does this happen to work with inaugural drafts?
The short answer is yes. The longer answer is that the draft module doesn't work very well when you get beyond about 500-600 players in the draft pool. So if you've got a very large inaugural draft pool, then it may not work for you. I do know that some leagues have successfully run inaugural drafts with StatsLab, though.

Quote:
Originally Posted by cody8200 View Post
Do you really have to upload 250 megs of HTML data everytime you run a sim or am I missing something?

I'm trying to set this up for a solo league and I'm uploading it the same way I would if I was running a multiplayer league. I'm sure it would be a much quicker process to be able to run it on my own local machine if its possible. Does anyone know?
You can actually install MySQL and PHP hosts on your local machine and run it that way if you are up for the effort.
__________________
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 08-19-2010, 02:45 PM   #34
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,379
Thanks: 1,837
Thanked 1,147x in 474 posts
Thanks for your answer. i decided to just run it online but i keep getting stuck. I keep getting the rro message
ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)

I can't find a table called ootp_sql_admin.

What am i doing wrong?
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 08-19-2010, 09:27 PM   #35
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,379
Thanks: 1,837
Thanked 1,147x in 474 posts
Quote:
Originally Posted by cody8200 View Post
Thanks for your answer. i decided to just run it online but i keep getting stuck. I keep getting the rro message
ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)

I can't find a table called ootp_sql_admin.

What am i doing wrong?
Problem fixed.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 08-20-2010, 10:02 AM   #36
cody8200
Hall Of Famer
 
cody8200's Avatar
 
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,379
Thanks: 1,837
Thanked 1,147x in 474 posts
Everything seems to be working now but one thing. After the initial import of the data, upon the second import my login and password is no longer treated as a commissioner. I don't have the ability to administrate or update the files. Any idea why this could occur and how to fix it?
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design -
Twitter: @sharpguysweb
cody8200 is offline   Reply With Quote
Old 08-20-2010, 11:33 PM   #37
GWUlery
Minors (Single A)
 
GWUlery's Avatar
 
Join Date: Dec 2009
Posts: 60
Thanks: 3
Thanked 0x in 0 posts
Windows Server

Has anyone set up StatsLab on a Windows server? I'm wondering if that's what's causing my difficulties.
__________________
Baseball Stars Association Commissioner - Check Us Out! http://www.thebaseballstars.org/BSA
GWUlery is offline   Reply With Quote
Old 08-26-2010, 08:01 PM   #38
Cowtippers
Bat Boy
 
Join Date: Aug 2010
Posts: 4
Thanks: 1
Thanked 0x in 0 posts
I'm in the same boat with you GWUlery. I can't get any of the buttons I click to save either. Any help would be greatly appreciated on the matter.
Cowtippers is offline   Reply With Quote
Old 08-27-2010, 03:58 AM   #39
Goody
Hall Of Famer
 
Goody's Avatar
 
Join Date: Mar 2002
Location: South Korea
Posts: 3,450
Blog Entries: 2
Thanks: 455
Thanked 211x in 152 posts
Up and running with the upgrade and everything seems good to go. Thanks!!
__________________
Sent from my desktop computer using a web browser.
Goody is offline   Reply With Quote
Old 08-27-2010, 10:46 AM   #40
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,176x in 442 posts
Quote:
Originally Posted by cody8200 View Post
Everything seems to be working now but one thing. After the initial import of the data, upon the second import my login and password is no longer treated as a commissioner. I don't have the ability to administrate or update the files. Any idea why this could occur and how to fix it?
Before your first load, there is no login to log in against. Did you try logging in with the default password after the first SQL load and have that work for you? The only thing in the SQL load that affects your ability to login is the setting that says whether or not you are a commissioner. The passwords in StatsLab aren't affected by the SQL load at all. However, it is possible that passwords can no longer work if your host has changed the encryption algorithm in your SQL install.

Quote:
Originally Posted by GWUlery View Post
Has anyone set up StatsLab on a Windows server? I'm wondering if that's what's causing my difficulties.
Unfortunately, I don't have access to a windows server on which I'd be able to test StatsLab and possibly troubleshoot any issues that'd be specific to that platform. I know I didn't code anything specifically to accomodate windows, so it could very well be the source of your issues.

Quote:
Originally Posted by Cowtippers View Post
I'm in the same boat with you GWUlery. I can't get any of the buttons I click to save either. Any help would be greatly appreciated on the matter.
Are you getting any error messages? A couple of things to verify would be that you're on version 2.0.2 and that the SQL user account has permission to create tables in the database.

In all cases where people need support on stuff like this, remember that the fastest way to get a response from me is to PM me on these boards with a link to your StatsLab install and (if you're that far already) a working commish login to it. It's really hard to know with any specificity what the problem is unless I can see your install first hand. I have been able to diagnose the problem just by looking at the install on several occasions. I'm generally willing to even log on to your web based admin tools if necessary to help you get it up and running, as long as you're willing to give me access to it. Usually, it's not needed for me to go that deep, but sometimes it has helped.
__________________
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
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 10:38 AM.

 

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