Home | Webstore
Latest News: FHM 5 Available - OOTP 19 Available! - MLB Manager 2018 Available Now

Perfect Team is LIVE!

  

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

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

Reply
 
Thread Tools
Old 01-23-2013, 09:25 PM   #41
MogulChamp
All Star Reserve
 
MogulChamp's Avatar
 
Join Date: Aug 2004
Posts: 656
Thanks: 11
Thanked 9x in 4 posts
Is there a way to remove commish access in statslab only?
MogulChamp is offline   Reply With Quote
Old 01-23-2013, 10:06 PM   #42
sdodd
Major Leagues
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 332
Thanks: 54
Thanked 67x in 31 posts
Is there any way to get the widget "button" put back in the utilities? I just can't seem to get them to work on my own. Or maybe someone can code a couple of them for me??
sdodd is offline   Reply With Quote
Old 01-24-2013, 02:37 AM   #43
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 sdodd View Post
Is there any way to get the widget "button" put back in the utilities? I just can't seem to get them to work on my own. Or maybe someone can code a couple of them for me??
What are you trying to add them to? You should be able to add them as iframes.
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 01-24-2013, 02:38 AM   #44
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Is there a way I can add WAR and/or WinShares to the award voting screen?
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 01-24-2013, 12:11 PM   #45
MogulChamp
All Star Reserve
 
MogulChamp's Avatar
 
Join Date: Aug 2004
Posts: 656
Thanks: 11
Thanked 9x in 4 posts
Also... how do I get splits to load in statslab?
MogulChamp is offline   Reply With Quote
Old 01-24-2013, 05:48 PM   #46
sdodd
Major Leagues
 
sdodd's Avatar
 
Join Date: Jan 2011
Posts: 332
Thanks: 54
Thanked 67x in 31 posts
Quote:
Originally Posted by dangarion View Post
What are you trying to add them to? You should be able to add them as iframes.
I want to add them to the front page of my vbulletin suite. Major League All Sim Baseball - The Front Page
sdodd is offline   Reply With Quote
Old 01-24-2013, 07:18 PM   #47
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,449
Thanks: 165
Thanked 1,155x in 437 posts
Quote:
Originally Posted by MogulChamp View Post
Is there a way to remove commish access in statslab only?
No, you can only add commish access at the moment.

Quote:
Originally Posted by dangarion View Post
Is there a way I can add WAR and/or WinShares to the award voting screen?
The stats displayed are not currently customizeable.

WAR is unfortunately not part of the SQL dump (neither is ZR or some of the other new metrics added in the last few versions).

Quote:
Originally Posted by MogulChamp View Post
Also... how do I get splits to load in statslab?
Two possible answers:
Do you mean statistics splits like vs. LHP, vs. RHP, in day/night games? If so, then there is a player stats page you can access during the season which has some of this. However OOTP doesn't export splits beyond regular and postseason stats, so StatsLab can't display them.

If you mean, how do you split a SQL file and load it piecemeal, then the way to do that is on the SQL File Load page accessible from the admin menu. Just make sure you load splits in order.

Quote:
Originally Posted by sdodd View Post
I want to add them to the front page of my vbulletin suite. Major League All Sim Baseball - The Front Page
As Dan said, iframes are the easiest way to pull in a widget. I'm not familiar with vbulletin's ability to utilize iFrames in your site, but I would expect that others have done it in the past.
__________________
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:
MogulChamp (01-24-2013)
Old 01-24-2013, 10:17 PM   #48
MogulChamp
All Star Reserve
 
MogulChamp's Avatar
 
Join Date: Aug 2004
Posts: 656
Thanks: 11
Thanked 9x in 4 posts
Quote:
Originally Posted by fhomess View Post
Do you mean statistics splits like vs. LHP, vs. RHP, in day/night games? If so, then there is a player stats page you can access during the season which has some of this. However OOTP doesn't export splits beyond regular and postseason stats, so StatsLab can't display them.
This is what I wanted to know. Appreciate the reply.

Another question... I cannot for the life of me figure out why my export tracker is not working. I am getting no errors at all. But under the exports tab, all teams have no exports.
MogulChamp is offline   Reply With Quote
Old 01-25-2013, 07:53 PM   #49
MogulChamp
All Star Reserve
 
MogulChamp's Avatar
 
Join Date: Aug 2004
Posts: 656
Thanks: 11
Thanked 9x in 4 posts
Another question...

Our league uses ratings 20-80, potentials in the Draft War Room are displaying incorrectly. Could this be a configuration issue?
MogulChamp is offline   Reply With Quote
Old 01-26-2013, 01:25 AM   #50
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,449
Thanks: 165
Thanked 1,155x in 437 posts
Quote:
Originally Posted by MogulChamp View Post
Another question... I cannot for the life of me figure out why my export tracker is not working. I am getting no errors at all. But under the exports tab, all teams have no exports.
Usually that means that you've got the export file location incorrect.

Quote:
Originally Posted by MogulChamp View Post
Another question...

Our league uses ratings 20-80, potentials in the Draft War Room are displaying incorrectly. Could this be a configuration issue?
If you've recently changed the rating scale, are using StatsLab scout, and haven't rerun scouting, that might do it. Otherwise, I'm not really sure why you might be seeing that.
__________________
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 01-26-2013, 11:17 AM   #51
MogulChamp
All Star Reserve
 
MogulChamp's Avatar
 
Join Date: Aug 2004
Posts: 656
Thanks: 11
Thanked 9x in 4 posts
Quote:
Originally Posted by fhomess View Post
If you've recently changed the rating scale, are using StatsLab scout, and haven't rerun scouting, that might do it. Otherwise, I'm not really sure why you might be seeing that.
What is also interesting is that there are players missing from the pool and the exported OOTP draft order is incorrect in the comp rounds.

Could it have something to do with the timing? We are picking as soon as the pool is available. Do you have to wait until draft day in OOTP to do it in statslab?

Last edited by MogulChamp; 01-26-2013 at 11:38 AM.
MogulChamp is offline   Reply With Quote
Old 01-29-2013, 05:37 PM   #52
Kaaosaste
Minors (Double A)
 
Join Date: Apr 2010
Posts: 118
Thanks: 49
Thanked 33x in 23 posts
I'm experiencing a small issue with the History feature.

When I pull up the "League Index," I set the subleague to the American League, and it displays correctly, but when I change the subleague to the National League and click "go", the subleague drop box reverts back to the American League, and it still displays the American League report (the page blips as if it's loading a new report, but the same data shows up).

The same thing happens with the "Draft History" page. All other history reports function properly.

edit: I've installed statslab for two of my leagues and the same issue happens in both.

Last edited by Kaaosaste; 01-29-2013 at 05:38 PM.
Kaaosaste is offline   Reply With Quote
Old 01-29-2013, 05:50 PM   #53
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,449
Thanks: 165
Thanked 1,155x in 437 posts
Quote:
Originally Posted by MogulChamp View Post
What is also interesting is that there are players missing from the pool and the exported OOTP draft order is incorrect in the comp rounds.

Could it have something to do with the timing? We are picking as soon as the pool is available. Do you have to wait until draft day in OOTP to do it in statslab?
It shouldn't have anything to do with timing. StatsLab can handle the draft pool just fine as long as the players exist in OOTP already.

Quote:
Originally Posted by Kaaosaste View Post
I'm experiencing a small issue with the History feature.

When I pull up the "League Index," I set the subleague to the American League, and it displays correctly, but when I change the subleague to the National League and click "go", the subleague drop box reverts back to the American League, and it still displays the American League report (the page blips as if it's loading a new report, but the same data shows up).

The same thing happens with the "Draft History" page. All other history reports function properly.

edit: I've installed statslab for two of my leagues and the same issue happens in both.
There's only one league index and draft history page. Those pages show data for both sub leagues. The sub league drop down is for some of the other pages that split the views out.
__________________
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 01-29-2013, 08:05 PM   #54
Kaaosaste
Minors (Double A)
 
Join Date: Apr 2010
Posts: 118
Thanks: 49
Thanked 33x in 23 posts
Quote:
Originally Posted by fhomess View Post
There's only one league index and draft history page. Those pages show data for both sub leagues. The sub league drop down is for some of the other pages that split the views out.
Ah, I see it now. I didn't know the report split it into position players and pitchers. I saw missing picks in the draft register and thought it was only displaying the picks from one league. You'd think that the big "Batters" heading would have been a tip off...
Kaaosaste is offline   Reply With Quote
Old 02-08-2013, 12:12 PM   #55
Buane
Minors (Double A)
 
Join Date: Mar 2006
Posts: 161
Thanks: 28
Thanked 106x in 34 posts
I'm not sure if this has been true from when I first installed StatsLab13, or only since I updated to 13.0.2, but every single one of my users is flagged as Commissioner/Admin.

I verified the human_managers sql file contains the correct commissioner flags, it does not seem to have any effect. I can even "give" them Commissioner access via the admin and then "remove" it, but again, no effect. They're all stuck flagged as admins.
__________________
Commissioner - Rising Star League
Congratulations to the 2054 Champion New York Titans!
Buane is offline   Reply With Quote
Old 02-27-2013, 12:10 PM   #56
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
I decided to start using the PHP script to load the PHP but there seems like there is a little error with it.


-> Query was empty
-> team_rosterERROR in team_roster:

-> Query was empty
-> team_roster_staffERROR in team_roster_staff:

-> Query was empty
-> teamsERROR in teams:

-> Query was empty
LOAD STATUS: 34 files loaded in 85 seconds
Processing users
... processed 10 users
Sim lasted 0 days from 2017-07-24 to 2017-07-24

But at the end it appears it loaded the information...?
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 02-27-2013, 12:57 PM   #57
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,449
Thanks: 165
Thanked 1,155x in 437 posts
Quote:
Originally Posted by Buane View Post
I'm not sure if this has been true from when I first installed StatsLab13, or only since I updated to 13.0.2, but every single one of my users is flagged as Commissioner/Admin.

I verified the human_managers sql file contains the correct commissioner flags, it does not seem to have any effect. I can even "give" them Commissioner access via the admin and then "remove" it, but again, no effect. They're all stuck flagged as admins.
That sounds fun. I've not had any reports of this before, so shoot me a link to your StatsLab install and see if I can find anything.

Quote:
Originally Posted by dangarion View Post
I decided to start using the PHP script to load the PHP but there seems like there is a little error with it.


-> Query was empty
-> team_rosterERROR in team_roster:

-> Query was empty
-> team_roster_staffERROR in team_roster_staff:

-> Query was empty
-> teamsERROR in teams:

-> Query was empty
LOAD STATUS: 34 files loaded in 85 seconds
Processing users
... processed 10 users
Sim lasted 0 days from 2017-07-24 to 2017-07-24

But at the end it appears it loaded the information...?
Can you send me those three files?
__________________
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 02-27-2013, 08:01 PM   #58
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 fhomess View Post
That sounds fun. I've not had any reports of this before, so shoot me a link to your StatsLab install and see if I can find anything.


Can you send me those three files?
It's actually saying that error with every file. So I'm assuming it might be something in the DB? Would you like me to send you any specific file?
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!
dangarion is offline   Reply With Quote
Old 03-13-2013, 12:33 AM   #59
dangarion
All Star Reserve
 
dangarion's Avatar
 
Join Date: Feb 2003
Location: Orange, CA
Posts: 569
Thanks: 16
Thanked 5x in 5 posts
Soooooo. Any word?

Loading tables:
-> divisionsERROR in divisions:

-> Query was empty
-> games..ERROR in games:

-> Query was empty
-> games_score.....ERROR in games_score:

-> Query was empty
-> human_managersERROR in human_managers:

-> Query was empty
-> league_playoffsERROR in league_playoffs:

-> Query was empty
-> leaguesERROR in leagues:

-> Query was empty
-> parksERROR in parks:

-> Query was empty
-> players_awardsERROR in players_awards:

-> Query was empty
-> players_batting.....ERROR in players_batting:

-> Query was empty
-> players_contract...ERROR in players_contract:

-> Query was empty
-> players_contract_extension...ERROR in players_contract_extension:

-> Query was empty
-> players_fielding....ERROR in players_fielding:

-> Query was empty
-> players_individual_batting_stats......ERROR in players_individual_batting_stats:

-> Query was empty
-> players_league_leaderERROR in players_league_leader:

-> Query was empty
-> players_pitching.........ERROR in players_pitching:

-> Query was empty
-> players_roster_status.....ERROR in players_roster_status:

-> Query was empty
-> players_streak......ERROR in players_streak:

-> Query was empty
-> sub_leaguesERROR in sub_leagues:

-> Query was empty
-> team_batting_statsERROR in team_batting_stats:

-> Query was empty
-> team_fielding_stats_statsERROR in team_fielding_stats_stats:

-> Query was empty
-> team_financialsERROR in team_financials:

-> Query was empty
-> team_historyERROR in team_history:

-> Query was empty
-> team_history_batting_stats.ERROR in team_history_batting_stats:

-> Query was empty
-> team_history_fielding_stats_statsERROR in team_history_fielding_stats_stats:

-> Query was empty
-> team_history_financialsERROR in team_history_financials:

-> Query was empty
-> team_history_pitching_stats.ERROR in team_history_pitching_stats:

-> Query was empty
-> team_history_recordERROR in team_history_record:

-> Query was empty
-> team_pitching_statsERROR in team_pitching_stats:

-> Query was empty
-> team_recordERROR in team_record:

-> Query was empty
-> team_relationsERROR in team_relations:

-> Query was empty
-> team_rosterERROR in team_roster:

-> Query was empty
-> team_roster_staffERROR in team_roster_staff:

-> Query was empty
-> teamsERROR in teams:

-> Query was empty
LOAD STATUS: 33 files loaded in 48 seconds
Processing users
... processed 10 users
Sim lasted 74 days from 2017-07-24 to 2017-10-06
__________________
DanGarion
GM - Los Angeles Dodgers The Peanuts and Cracker Jack Baseball League
PCJBL!

Last edited by dangarion; 03-13-2013 at 12:51 AM.
dangarion is offline   Reply With Quote
Old 03-13-2013, 11:41 AM   #60
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Thanks: 5
Thanked 1x in 1 post
I get the same thing. It seems like the files did load, however they don't show as loaded in StatsLab interface.
__________________

BleedingCubbyBlue 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 04:21 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