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

OOTP Baseball 20 - AVAILABLE NOW!

  

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-2009, 02:34 PM   #81
PotatoPeeler
Hall Of Famer
 
PotatoPeeler's Avatar
 
Join Date: Aug 2002
Location: Rapid City, SD
Posts: 3,639
Thanks: 112
Thanked 172x in 134 posts
Quote:
Originally Posted by fhomess View Post
No, in the utility, they have nothing to do with who's in the HOF. It's merely a calculation based on leaderboard appearances. That said, you do need to run the code to calculate them from the career metrics admin page. They'll also only show up on the pages of players who have appeared on the appropriate leaderboards. If you've run them and aren't seeing them, please shoot me a PM with details and I'll help you investigate.
I'm assuming you have to run all those scripts in the Carreer Metrics Admin page everytime you update the SQL, correct?
__________________
培傑西

I have never taken a lesson on how to talk on TV in my life.
- Tim McCarver

Guns have only two enemies; rust and liberals.

The world is a comedy to those that think; a tragedy to those that feel.
PotatoPeeler is offline   Reply With Quote
Old 08-03-2009, 02:50 PM   #82
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,456
Thanks: 165
Thanked 1,174x in 441 posts
Quote:
Originally Posted by PotatoPeeler View Post
I'm assuming you have to run all those scripts in the Carreer Metrics Admin page everytime you update the SQL, correct?
Yes and no. If you want the numbers to update, then you do need to run them every time. However, you don't have to. You could just update them at the end of the season if you want. For example, Black Ink and Gray Ink are based on leaderboard appearances, so they won't update until the end of the season anyway. Personally, I think running just the first three with each mid-season sim is plenty, then run the rest after the season is complete.
__________________
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-03-2009, 02:51 PM   #83
PotatoPeeler
Hall Of Famer
 
PotatoPeeler's Avatar
 
Join Date: Aug 2002
Location: Rapid City, SD
Posts: 3,639
Thanks: 112
Thanked 172x in 134 posts
Excellent. Thanks for the tip.
__________________
培傑西

I have never taken a lesson on how to talk on TV in my life.
- Tim McCarver

Guns have only two enemies; rust and liberals.

The world is a comedy to those that think; a tragedy to those that feel.
PotatoPeeler is offline   Reply With Quote
Old 08-03-2009, 04:05 PM   #84
satchel
Hall Of Famer
 
satchel's Avatar
 
Join Date: Apr 2002
Location: Ft Smith AR
Posts: 2,681
Thanks: 52
Thanked 50x in 27 posts
Quote:
Originally Posted by fhomess View Post
They'll also only show up on the pages of players who have appeared on the appropriate leaderboards.
Thanks for the extra info, I've now found some players with the scores.
satchel is offline   Reply With Quote
Old 08-04-2009, 10:45 AM   #85
Mr.Opinion
All Star Reserve
 
Mr.Opinion's Avatar
 
Join Date: May 2003
Location: SkiFree Lodge
Posts: 881
Thanks: 7
Thanked 28x in 17 posts
I would love to see, on the Upcoming Schedule, the record that your team has against a that particular team during the season. Thanks for doing this!
__________________
Mr.Opinion is offline   Reply With Quote
Old 08-04-2009, 10:50 AM   #86
PotatoPeeler
Hall Of Famer
 
PotatoPeeler's Avatar
 
Join Date: Aug 2002
Location: Rapid City, SD
Posts: 3,639
Thanks: 112
Thanked 172x in 134 posts
Quote:
Originally Posted by Mr.Opinion View Post
I would love to see, on the Upcoming Schedule, the record that your team has against a that particular team during the season. Thanks for doing this!
That's a great idea!
__________________
培傑西

I have never taken a lesson on how to talk on TV in my life.
- Tim McCarver

Guns have only two enemies; rust and liberals.

The world is a comedy to those that think; a tragedy to those that feel.
PotatoPeeler is offline   Reply With Quote
Old 08-07-2009, 06:08 PM   #87
jmantemp
Minors (Single A)
 
Join Date: Mar 2007
Posts: 57
Thanks: 3
Thanked 2x in 1 post
Thanks for creating these. I've got them implemented on my league's pages now and since we do most of the work online people are excited about them. I had two questions (they might be related):

1. I'm getting a dateDiff() error when I import the SQL files, but all the files appear to be importing and the functions are working. I was just curious why this is and if it would be affecting anything.

2. Also, when I run Black and Grey Ink the numbers aren't showing up. For instance I thought they'd show up at: Player Report for #54 Joel Blachford - StatsLab for OOTPX for him, but I can't find the numbers anywhere. Any idea what that is? We're still in Spring Training. Is that it?

I really like the Last Sim utility. It's been very helpful already. Thanks again.
jmantemp is offline   Reply With Quote
Old 08-07-2009, 07:22 PM   #88
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,456
Thanks: 165
Thanked 1,174x in 441 posts
Quote:
Originally Posted by jmantemp View Post
Thanks for creating these. I've got them implemented on my league's pages now and since we do most of the work online people are excited about them. I had two questions (they might be related):

1. I'm getting a dateDiff() error when I import the SQL files, but all the files appear to be importing and the functions are working. I was just curious why this is and if it would be affecting anything.
Make sure you've got the latest download of the utils. That error was fixed, but the fix doesn't appear to be in your install.

Quote:
Originally Posted by jmantemp View Post
2. Also, when I run Black and Grey Ink the numbers aren't showing up. For instance I thought they'd show up at: Player Report for #54 Joel Blachford - StatsLab for OOTPX for him, but I can't find the numbers anywhere. Any idea what that is? We're still in Spring Training. Is that it?
No, it shouldn't have anything to do with Spring Training. A quick glance didn't reveal anything obvious, so I'll send you a PM on this.

Quote:
Originally Posted by jmantemp View Post
I really like the Last Sim utility. It's been very helpful already. Thanks again.
I've got a few cool new features coming for this in the near future. Stay tuned.
__________________
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:
satchel (08-07-2009)
Old 08-07-2009, 08:32 PM   #89
satchel
Hall Of Famer
 
satchel's Avatar
 
Join Date: Apr 2002
Location: Ft Smith AR
Posts: 2,681
Thanks: 52
Thanked 50x in 27 posts
The Jamaica League is really enjoying StatsLab, thanks for all your work.

Quote:
Originally Posted by fhomess View Post
I've got a few cool new features coming for this in the near future.
Great to hear it.
satchel is offline   Reply With Quote
Old 08-11-2009, 12:47 AM   #90
satchel
Hall Of Famer
 
satchel's Avatar
 
Join Date: Apr 2002
Location: Ft Smith AR
Posts: 2,681
Thanks: 52
Thanked 50x in 27 posts
Quote:
Originally Posted by fhomess View Post
Some folks have had issues with the load script timing out if the file is too big and their PHP install isn't configured to accept the script's request for additional time.
I'm having this problem with my players_game_batting.mysql.sql file. I'm loading all of the .sql files manually, and this one keeps timing out. It's 7.9 MB, so it's a big file.

Anything I can do about this? I'm on Dreamhost.
satchel is offline   Reply With Quote
Old 08-11-2009, 01:01 PM   #91
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,456
Thanks: 165
Thanked 1,174x in 441 posts
Satch, I've sent you PM with a link to some enhanced tools for managing very large files that time out via the individual SQL file load page. Please give them a whirl, and if everything looks good, I'll release them to the community.
__________________
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-11-2009, 04:25 PM   #92
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Quote:
Originally Posted by satchel View Post
I'm having this problem with my players_game_batting.mysql.sql file. I'm loading all of the .sql files manually, and this one keeps timing out. It's 7.9 MB, so it's a big file.

Anything I can do about this? I'm on Dreamhost.
Really? Only 7.9 meg and it's timing out? Mine is 42 megs and it's running fine on Dreamhost. I wondering what the difference is...
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 08-13-2009, 12:03 AM   #93
satchel
Hall Of Famer
 
satchel's Avatar
 
Join Date: Apr 2002
Location: Ft Smith AR
Posts: 2,681
Thanks: 52
Thanked 50x in 27 posts
Quote:
Originally Posted by fhomess View Post
Satch, I've sent you PM with a link to some enhanced tools for managing very large files that time out via the individual SQL file load page. Please give them a whirl, and if everything looks good, I'll release them to the community.
The files you sent me are working great, and have solved my problem.

Quote:
Originally Posted by dangarion View Post
Really? Only 7.9 meg and it's timing out? Mine is 42 megs and it's running fine on Dreamhost. I wondering what the difference is...
That is strange. I wish I knew what the difference is. It seems as if it could be some setting.
satchel is offline   Reply With Quote
Old 08-13-2009, 09:16 AM   #94
MrWorkrate
All Star Starter
 
MrWorkrate's Avatar
 
Join Date: Mar 2002
Location: Raleigh, NC
Posts: 1,262
Thanks: 13
Thanked 14x in 9 posts
I'm going through the offseason right now (free agency), and I've already run all the career metrics stuff. Is there any reason I should still be running the SQL tools at this point, and if so which ones can I avoid? I don't mind uploading them each sim, but compiling them (especially the dreaded players_game_batting.mysql.sql and games_score.mysql.sql) is the killer.
__________________
I used to come here a lot. Now, not so much.
MrWorkrate is offline   Reply With Quote
Old 08-13-2009, 01:03 PM   #95
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,456
Thanks: 165
Thanked 1,174x in 441 posts
Quote:
Originally Posted by MrWorkrate View Post
I'm going through the offseason right now (free agency), and I've already run all the career metrics stuff. Is there any reason I should still be running the SQL tools at this point, and if so which ones can I avoid? I don't mind uploading them each sim, but compiling them (especially the dreaded players_game_batting.mysql.sql and games_score.mysql.sql) is the killer.
The only thing you might care to update is development. The rest isn't going to change in the offseason. If you don't need the development over the offseason, there's no need to update 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 08-20-2009, 11:51 AM   #96
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,611
Thanks: 242
Thanked 171x in 101 posts
I'm using the settings you suggest for All Star Voting and I'm still getting blank ballots. Any ideas?
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 08-20-2009, 09:25 PM   #97
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,456
Thanks: 165
Thanked 1,174x in 441 posts
Quote:
Originally Posted by Recte44 View Post
I'm using the settings you suggest for All Star Voting and I'm still getting blank ballots. Any ideas?
Make sure your ootpsqlou/cache directory is clearing out the *as_ballot* files when you save your All-Star admin settings. It looks as if it tried to create that ballot before you entered your settings. If the directory is not being cleared, there may be a permissions issue with the cache directory.

It also looks as though you don't have the latest version with some fixes for date functions in there. Try reinstalling those as well.
__________________
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-20-2009, 10:24 PM   #98
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,611
Thanks: 242
Thanked 171x in 101 posts
If you still have the info I sent you, think you could take a looksie for me?
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 08-23-2009, 07:38 AM   #99
beorn
All Star Starter
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,259
Thanks: 36
Thanked 130x in 71 posts
Quote:
Originally Posted by fhomess View Post
The issues people are seeing with ratings are due to the fact that the game now combines several internal ratings to determine the displayed ratings. I wasn't aware of this when I converted the OOTP9 version of these utils to OOTPX. If you review the threads in this forum for neags' dev tracker and Getch's OOTP OU, you'll see that they have the same problems.
Whatever the reason may be, the effect in the draft utility is alarming.

Looking at the a few of the top pitchers in the current Federal Baseball League draft:
Peyton Moore:
Game says potential of 9 stuff, 6 movement, 8 control
Utility says potential of 9 stuff, 8 movement, 4 control

Travis Carroll:
Games says 6-4-8
Utility says 6-8-2

Tom Larson:
Games says 4-7-5
Utility says 4-5-6

1) The numbers are far enough off that I am almost suspecting the columns are mislabeled in the utility. (In game, movement is 2nd; in the utility control is 2nd. Is that just a labeling error?)

2) Assuming for a moment that that is the case, this still makes discrepancies in movement odd. Travis Carroll has only a 45% gb%. So if the data dump is giving you his movement, setting aside a bonus for his gb%, this makes no sense. No way that 45% gb% is a bonus of 2 to movement. Thus, I am suspecting a problem with the game.

Ever since X came out, I have had a sense that when it came to pitcher ratings, what you see is not what you get. Given that Markus is not sharing his formulas, it would be the kind of bug that could go unnoticed for quite a while.

In my mind, it is suggestive of a problem in movement ratings that stuff ratings are coming through fine in the utility, even though they are supposedly the more complex rating, including both velocity and a bunch of pitch ratings. (Relievers do have a discrepancy in their stuff ratings, but it is consistent -- rated lower, so what you see in the utility is every pitcher including the relievers being rated as starters.)
__________________
Commish of Dog Days Baseball
Commish Pennant Chase Baseball League (PCBL)
Commish and Blue Jays GM Extra Innings Baseball

Last edited by beorn; 08-23-2009 at 07:46 AM.
beorn is offline   Reply With Quote
Old 08-23-2009, 01:20 PM   #100
Nyro44
Bat Boy
 
Join Date: Apr 2005
Posts: 3
Thanks: 0
Thanked 0x in 0 posts
help

Notice: Undefined index: league_id in C:\wamp\www\ootpsqlou\
Notice: Undefined variable: lgid in

Any idea?

Thx a lot
Nyro44 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 06:37 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