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

  

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 09-01-2009, 12:52 AM   #121
snnort
Minors (Triple A)
 
snnort's Avatar
 
Join Date: Apr 2004
Posts: 272
Thanks: 16
Thanked 15x in 15 posts
Quote:
Originally Posted by snnort View Post
Any thoughts on adding HOF voting? It's not that it's totally necessary, but since this has become the god of all OOTP Utilities and has nearly everything you could want to supplement the reporting, voting, drafting aspect of any online league... just thought it wouldn't hurt to ask.
Quote:
Originally Posted by fhomess View Post
I've thought about it. I have a partial design for it that I haven't gotten around to finishing yet. I've just not been happy with some of the considerations to this point, so I need to think on it some more.
Cool enough. I've set up StatsLab for the BCBL (a league I commish) as well as the SIMBL (a league I am in, but I help out with some behind the scenes stuff too). And owners in both leagues LOVE it.

The HOF voting would be just icing on an already very yummy cake.

Those divisional race graphs... they used to have those on ESPN's site for MLB and I used to create them using MS Excel for an OOTP league I helped with back in 2003. That was a lot of work entering the data by keyboard after every sim. Nice to see something like that implimented using data dumps.

OOTP has come a long way with the help of peeps like you writing utilities that become easier and easier to update.

Thank you.
snnort is offline   Reply With Quote
Old 09-01-2009, 02:09 AM   #122
BobDylanRH
Minors (Double A)
 
BobDylanRH's Avatar
 
Join Date: Jun 2009
Posts: 138
Thanks: 0
Thanked 1x in 1 post
With the patch installed, I'm getting some whacky player development. Kind of need to look at it yourself: Development Tracker - StatsLab for OOTPX

Also a string of errors running the win shares utilities:

Warning: Division by zero in /home/.../forum/statslab/ootpsqlou/winshares.php on line 1118
BobDylanRH is offline   Reply With Quote
Old 09-01-2009, 07:51 AM   #123
Stu
All Star Starter
 
Stu's Avatar
 
Join Date: Dec 2005
Posts: 1,255
Thanks: 18
Thanked 17x in 9 posts
Is there any way to retroactively run the season metrics (namely OPS+ and ERA+) if we have a backup of every end of season file. So if I restored year 1 ran the metrics, restored year 2 ran the metrics, would it work or screw stuff up?
__________________
Brewers League Baseball
Stu is offline   Reply With Quote
Old 09-01-2009, 08:07 AM   #124
Stu
All Star Starter
 
Stu's Avatar
 
Join Date: Dec 2005
Posts: 1,255
Thanks: 18
Thanked 17x in 9 posts
Also I'm still getting strange permission issues. All folders are currently set to 755 but anytime it needs to write a file I get an error. As an example, I get this when trying to view a players game logs:

Quote:
Warning: fopen(./cache/player_429_sim_stats_Season.html) [function.fopen]: failed to open stream: Permission denied in /home/.../blb/utilities/ootpsqlou/playerStats.php on line 995

Warning: fwrite(): supplied argument is not a valid stream resource in /home/.../blb/utilities/ootpsqlou/playerStats.php on line 996

Warning: fclose(): supplied argument is not a valid stream resource in /home/.../blb/utilities/ootpsqlou/playerStats.php on line 997
If I set the permissions to 777 it works but I obviously don't want to leave them at 777. Is there something wrong in my configuration that would be causing this?
__________________
Brewers League Baseball
Stu is offline   Reply With Quote
Old 09-01-2009, 11:41 AM   #125
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,178x in 443 posts
Quote:
Originally Posted by snnort View Post
OOTP has come a long way with the help of peeps like you writing utilities that become easier and easier to update.

Thank you.
You're welcome.

Quote:
Originally Posted by BobDylanRH View Post
With the patch installed, I'm getting some whacky player development. Kind of need to look at it yourself: Development Tracker - StatsLab for OOTPX

Also a string of errors running the win shares utilities:

Warning: Division by zero in /home/.../forum/statslab/ootpsqlou/winshares.php on line 1118
Nothing's changed in the patch with the Win Shares utility. I'll look into this some more.

As for development, it looks like you didn't run the conversion after installing the patch. There was another problem with the development getting GB% and Knucklecurve Talent confused. I've fixed that and now re-uploaded the patch. The conversion will need to be rerun.

Quote:
Originally Posted by Stu View Post
Is there any way to retroactively run the season metrics (namely OPS+ and ERA+) if we have a backup of every end of season file. So if I restored year 1 ran the metrics, restored year 2 ran the metrics, would it work or screw stuff up?
Yeah, actually you could do that. Upload the end of season SQL files, then run the season metrics for each season. Rinse and repeat for each year. This'll work as long as those backups still spit out all the necessary data.

Quote:
Originally Posted by Stu View Post
Also I'm still getting strange permission issues. All folders are currently set to 755 but anytime it needs to write a file I get an error. As an example, I get this when trying to view a players game logs:

If I set the permissions to 777 it works but I obviously don't want to leave them at 777. Is there something wrong in my configuration that would be causing this?
Not in your StatsLab config, that's just installing files on your server and setting up information so it knows how to access the data. However, it has been my experience that not all server configurations are as flexible as others. It may be that on your server, you need to give 757 or 777 permissions to get it to write those files in the cache folder.
__________________
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 09-01-2009, 01:47 PM   #126
BobDylanRH
Minors (Double A)
 
BobDylanRH's Avatar
 
Join Date: Jun 2009
Posts: 138
Thanks: 0
Thanked 1x in 1 post
Quote:
Originally Posted by fhomess View Post
As for development, it looks like you didn't run the conversion after installing the patch. There was another problem with the development getting GB% and Knucklecurve Talent confused. I've fixed that and now re-uploaded the patch. The conversion will need to be rerun.
I ran it a few times. The conversion tool says the tables were removed and to run player development again. But it doesn't seem to fix my whacky reports.
BobDylanRH is offline   Reply With Quote
Old 09-02-2009, 12:01 AM   #127
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,178x in 443 posts
Quote:
Originally Posted by BobDylanRH View Post
I ran it a few times. The conversion tool says the tables were removed and to run player development again. But it doesn't seem to fix my whacky reports.
FYI to everyone else, we got this fixed via PM. If you're running into the same problem, it could be because you ran development without running the conversion after installing the patch.
__________________
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 09-02-2009, 12:03 PM   #128
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 would have PMed this but I figured this was good info for others.

If you're in the offseason and just updating development, which SQL files should you upload?
__________________
I used to come here a lot. Now, not so much.
MrWorkrate is offline   Reply With Quote
Old 09-02-2009, 12:34 PM   #129
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,178x in 443 posts
Quote:
Originally Posted by MrWorkrate View Post
I would have PMed this but I figured this was good info for others.

If you're in the offseason and just updating development, which SQL files should you upload?
The ReadMe has a handy table in the appendix that tells you which SQL tables are needed for each utility. For development, you'll see that the following is checked:
leagues
teams
players
players_batting
players_fielding
players_pitching
__________________
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 09-02-2009, 04:36 PM   #130
BobDylanRH
Minors (Double A)
 
BobDylanRH's Avatar
 
Join Date: Jun 2009
Posts: 138
Thanks: 0
Thanked 1x in 1 post
Small issue here...

The last sim tool doesn't show the inning by inning tallies. And it doesn't pull up any stats for pitchers in any of the last sim statistic pages.

Not a big deal, so throw this on the bottom of your support list, fhomess.
BobDylanRH is offline   Reply With Quote
Old 09-02-2009, 04:49 PM   #131
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,178x in 443 posts
Quote:
Originally Posted by BobDylanRH View Post
Small issue here...

The last sim tool doesn't show the inning by inning tallies. And it doesn't pull up any stats for pitchers in any of the last sim statistic pages.

Not a big deal, so throw this on the bottom of your support list, fhomess.
Make sure you've loaded the latest games_score and players_game_pitching_stats SQL files for your league. You can verify the load date of all your SQL files on the SQL File Load page accessible from the admin page of StatsLab.
__________________
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 09-02-2009, 05:36 PM   #132
Stu
All Star Starter
 
Stu's Avatar
 
Join Date: Dec 2005
Posts: 1,255
Thanks: 18
Thanked 17x in 9 posts
Quote:
Originally Posted by Stu View Post
Is there any way to retroactively run the season metrics (namely OPS+ and ERA+) if we have a backup of every end of season file. So if I restored year 1 ran the metrics, restored year 2 ran the metrics, would it work or screw stuff up?
For anybody who is interested I was able to run the season metrics for all but the first 3 years of my league. I had all my old backups so just imported the backup from before the World Series of each year as if it was an OOTP 9 league. This worked for league files from OOTP 2007, 8 and 9.

I wasn't able to import the first 3 seasons because I can't find the backups.
__________________
Brewers League Baseball
Stu is offline   Reply With Quote
Old 09-04-2009, 12:56 PM   #133
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
In the Jamaica League, our season just ended, and I put up Awards ballots, and for the Outstanding Batter awards candidates, several of the batters' statistics are doubled. They have two times the number of all of their statistics: games, at-bats, RBI, everything. This is only the case for about half of the batters on the ballot, and the half who are doubled are the ones who had the highest totals, going in (that is, before the doubling).

This doubling has taken place in both sub-leagues. The doubling has not occurred in any other awards categories.

Last edited by satchel; 09-04-2009 at 12:58 PM.
satchel is offline   Reply With Quote
Old 09-04-2009, 01:09 PM   #134
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,178x in 443 posts
Quote:
Originally Posted by satchel View Post
In the Jamaica League, our season just ended, and I put up Awards ballots, and for the Outstanding Batter awards candidates, several of the batters' statistics are doubled. They have two times the number of all of their statistics: games, at-bats, RBI, everything. This is only the case for about half of the batters on the ballot, and the half who are doubled are the ones who had the highest totals, going in (that is, before the doubling).

This doubling has taken place in both sub-leagues. The doubling has not occurred in any other awards categories.
PM Sent.

EDIT: If you split your SQL files before loading them, do be careful you don't load any of the split files more than once. The SQL dump doesn't prevent duplicate rows from being created in some tables since there are no primary keys defined in the table definition.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.

Last edited by fhomess; 09-04-2009 at 04:19 PM.
fhomess is offline   Reply With Quote
Old 09-10-2009, 01:03 PM   #135
snnort
Minors (Triple A)
 
snnort's Avatar
 
Join Date: Apr 2004
Posts: 272
Thanks: 16
Thanked 15x in 15 posts
Sandwich picks (between rounds 1 and 2)

How should this be handled in league that use the new FA Compensation option in OOTP X... using the StatsLab Draft Utility?

My thought was to treat the "sandwich" round as round 2 and move each round after that down one (so round 3 in the utility would actually be round 2 in the OOTP X game... and so on).

In the case of the league I commish... we have less sandwich picks total, than we have teams... so all the sandwich picks fit into one round. The extra picks at the end of the round will just be drafting the worst players of the draft as fillers so that we can move to the next round.

Fhomess, is this the best way to handle this kind of situation AND do you (or anyone else in this thread) see any possible hang ups?

In a possible future patch.... it would be cool if you could have the option when assigning picks to each round, of choosing to not list a team and then move it to the next round. OR even better would be if you could simply choose a toggle for the sandwich pick round to be active or not (between round 1 and 2) and then choose how many picks, exactly, to have in that round.
snnort is offline   Reply With Quote
Old 09-10-2009, 02:54 PM   #136
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,178x in 443 posts
Quote:
Originally Posted by snnort View Post
How should this be handled in league that use the new FA Compensation option in OOTP X... using the StatsLab Draft Utility?

My thought was to treat the "sandwich" round as round 2 and move each round after that down one (so round 3 in the utility would actually be round 2 in the OOTP X game... and so on).

In the case of the league I commish... we have less sandwich picks total, than we have teams... so all the sandwich picks fit into one round. The extra picks at the end of the round will just be drafting the worst players of the draft as fillers so that we can move to the next round.

Fhomess, is this the best way to handle this kind of situation AND do you (or anyone else in this thread) see any possible hang ups?

In a possible future patch.... it would be cool if you could have the option when assigning picks to each round, of choosing to not list a team and then move it to the next round. OR even better would be if you could simply choose a toggle for the sandwich pick round to be active or not (between round 1 and 2) and then choose how many picks, exactly, to have in that round.
I think your proposed plan of adding a round and picking scrubs for the teams that don't have sandwich picks is the best plan in the current version.

I have a second patch in the works which includes the ability to mark picks to skip over. This lets you have the flexibility to create a sandwich pick round with less picks than the number of teams in your league, but also allows you to impose sanctions on teams by skipping any pick in any round. You could even create additional sandwich pick rounds later in the same draft if your league has custom FA compensation rules. If you're interested in beta testing this patch, I'll send you a link where you can download it. Just shoot me a PM.

The patch will also contain the ability to display fielding stats, career metrics, and season metrics on the leaderboards pages.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.

Last edited by fhomess; 09-10-2009 at 02:59 PM.
fhomess is offline   Reply With Quote
Old 09-10-2009, 03:35 PM   #137
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,625
Thanks: 255
Thanked 176x in 104 posts
I just loaded all my SQL files, and the date at the top left of the page is the current game date, but on "Last Sim" it shows the boxscores for the sim before this current one.

Any ideas?
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 09-10-2009, 04:25 PM   #138
snnort
Minors (Triple A)
 
snnort's Avatar
 
Join Date: Apr 2004
Posts: 272
Thanks: 16
Thanked 15x in 15 posts
Quote:
Originally Posted by Recte44 View Post
I just loaded all my SQL files, and the date at the top left of the page is the current game date, but on "Last Sim" it shows the boxscores for the sim before this current one.

Any ideas?
First place I would check is the link "SQL Files" from the Admin section... and make sure that all the files are up-to-date...meaning... they should all basically have the time/date stamp within a few minutes of one another... OR at least the important ones for the "last sim" utility... which is basically any SQL file that has the word "game" in it.

For you the link to see those files listed is here:
http://mbwba.whsites.net/ootpsqlou/sql_file_load.php

Being that I don't have admin access to your StatsLab... I can't view that page.

Last edited by snnort; 09-10-2009 at 04:30 PM.
snnort is offline   Reply With Quote
Old 09-10-2009, 04:46 PM   #139
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,625
Thanks: 255
Thanked 176x in 104 posts
They are all current files.

I imported once, then I imported each individually. No change.
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 09-10-2009, 06:28 PM   #140
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,178x in 443 posts
Quote:
Originally Posted by Recte44 View Post
They are all current files.

I imported once, then I imported each individually. No change.
The utility stores these pages in the cache folder so they can be accessed again without hitting the database or taking the time to recreate a large page. If the page exists already in the cache, then the util checks the date/timestamp and compares it to the last SQL file load. If it's older than the file load, it should create the page anew. The utility is also supposed to clear out the cache folder of these pages when a file load is performed or the last sim settings are saved from the last sim admin page. If it's not getting cleared out, then there are permissions that aren't configured to allow it. I'm not sure why it wouldn't still create the new page, though, if the SQL load has happened recently.
__________________
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 09:33 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