Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

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

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

Reply
 
Thread Tools
Old 04-06-2012, 02:15 AM   #141
JDevil
All Star Reserve
 
JDevil's Avatar
 
Join Date: Apr 2010
Posts: 594
Will this need to be altered significantly for v13?
__________________
BLHL Commissioner - GM - Atlanta Firerbirds
JDevil is offline   Reply With Quote
Old 04-06-2012, 10:43 AM   #142
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by Zarberg View Post
Looks like it is a browser issue ... Firefox works no problems.
Is it only happening on IE? I feel like I remember there being an IE-only issue, because, well, IE sucks. But make sure you are on the latest version since I did fix issues like these in those minor patches I did. Also, whenever any behavior like this happens, check the error console for errors; something usually shows up there.

Quote:
Will this need to be altered significantly for v13?
Unfortunately, yes. I'm in the process, but there's a lot of changes. The big changes is that all of the HTML reports have been redone in OOTP, and as you know, OU tries to use the same look-and-feel as OOTP for consistency. So I need to rework all of the pages in the new look.

There's also a few enhancements that Markus may do in the first or second patch that OU can take advantage of. If he does end up doing them, I'd wait to release OU until they are implemented so that we don't have version mismatch issues.

It'll all come in time. I'm assuming (banking on) most online leagues will wait a little bit before converting for OOTP to shake out some of the bugs.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 04-10-2012, 03:34 PM   #143
Zarberg
Minors (Double A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 100
Quote:
Originally Posted by Getch View Post
Is it only happening on IE? I feel like I remember there being an IE-only issue, because, well, IE sucks. But make sure you are on the latest version since I did fix issues like these in those minor patches I did. Also, whenever any behavior like this happens, check the error console for errors; something usually shows up there.
Will do. I only used IE because it's all I'm given at work, at home I almost exclusively use Firefox and occaisionally Safari, because yeah, IE is a PoS.

Quote:
Unfortunately, yes. I'm in the process, but there's a lot of changes. The big changes is that all of the HTML reports have been redone in OOTP, and as you know, OU tries to use the same look-and-feel as OOTP for consistency. So I need to rework all of the pages in the new look.

There's also a few enhancements that Markus may do in the first or second patch that OU can take advantage of. If he does end up doing them, I'd wait to release OU until they are implemented so that we don't have version mismatch issues.

It'll all come in time. I'm assuming (banking on) most online leagues will wait a little bit before converting for OOTP to shake out some of the bugs.
I'm happy to offer any kind of beta-testing services as I have my own Linux server at home and have a little bit of Perl experience.
__________________
The BIG Baseball League - by the GMs, for the GMs.

https://www.big-baseball.org/
Zarberg is offline   Reply With Quote
Old 04-10-2012, 11:15 PM   #144
JDevil
All Star Reserve
 
JDevil's Avatar
 
Join Date: Apr 2010
Posts: 594
Thanks Getch. I'm starting a new league right now. We will be rolling after tomorrows patch, but I am fictional, so I dont think there will be problems....I hope.
__________________
BLHL Commissioner - GM - Atlanta Firerbirds
JDevil is offline   Reply With Quote
Old 04-18-2012, 12:01 PM   #145
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,805
Any chance we could have a "Reliever of the Year" and "Manager of the Year" added to Awards Voting?

Also, could we add VORP and WAR to player stats on Awards and All-Star Voting?

Could there also be a way to "add" someone to the ballots?
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)

Last edited by Recte44; 04-18-2012 at 12:02 PM.
Recte44 is offline   Reply With Quote
Old 04-20-2012, 10:40 AM   #146
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by Recte44 View Post
Any chance we could have a "Reliever of the Year" and "Manager of the Year" added to Awards Voting?

Also, could we add VORP and WAR to player stats on Awards and All-Star Voting?
There are a bunch of things like these that I wanted to do for the initial 13 release. I still hope to do them, just a matter of energy and motivation. My online league will be converting in about 2 weeks so that is the target date for the initial 13 version. It's looking good so far.

Do note that WAR is not exposed in the export files, and we're pushing Markus to get them included with some other stuff in the next patch. This is one of the "few enhancements" that I mentioned before that I wanted to wait on before releasing. We'll see if they get in.

Quote:
Could there also be a way to "add" someone to the ballots?
That'll be tough. I've noticed some rare oddities with the ballots sometimes, so I plan on revisiting the code to see if I can figure out why on occasion some people are left off. Hopefully that will fix any issues with people being left off, and you won't need this functionality.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 04-25-2012, 04:21 AM   #147
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Posts: 11,724
Getch, any idea on the error we get when trying to generate our Last Sim report:

"Error Occurred! Can't use string ("13") as an ARRAY ref while "strict refs" in use at OOTPOU/LSAdmin.pm line 597.".

I looked at the file and that line says, " $game = ${@{$teams{$team}->{GAMES}}}[$gCount];"

My guess is it has to do with a server upgrade of some sort with it saying "strict refs". Any idea what we should try?
kq76 is offline   Reply With Quote
Old 04-25-2012, 10:09 AM   #148
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by kq76 View Post
Getch, any idea on the error we get when trying to generate our Last Sim report:

"Error Occurred! Can't use string ("13") as an ARRAY ref while "strict refs" in use at OOTPOU/LSAdmin.pm line 597.".

I looked at the file and that line says, " $game = ${@{$teams{$team}->{GAMES}}}[$gCount];"

My guess is it has to do with a server upgrade of some sort with it saying "strict refs". Any idea what we should try?
Do you have the latest version of OU? I fixed a bug in Last Sim in a recent version (4.1.0e to be exact) that, although I can't remember exactly, I thought was this issue. If you have that version or later, zip up your csv files, PM me where to pick them up, and I can take a look.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 04-25-2012, 01:21 PM   #149
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Posts: 11,724
That fixed it! Thank you.
kq76 is offline   Reply With Quote
Old 04-26-2012, 10:54 AM   #150
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Is 4.1.1 the most current version?
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 04-26-2012, 12:52 PM   #151
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by BleedingCubbyBlue View Post
Is 4.1.1 the most current version?
Yes.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 09-07-2012, 12:30 PM   #152
GMGOD
Minors (Triple A)
 
GMGOD's Avatar
 
Join Date: Oct 2005
Posts: 218
Infractions: 0/1 (1)
OOTOU Export Tracker

Hey Guys and Getch,

Getch helped us alot with his OOTPOU for the SIMBL and we all love it. Great work Getch again.

One question when I emailed Getch. Our export tracker doesn't show red or black for old and new exports as I see when other leagues have used it.

Getch told me it may be a game setting that keeps the old exports different from the new export in colors:

Quote:
For the time on exports, it's set to the server time and as of now you can't change it, but that's a good idea for something to add to the utility.

For the exports being blue/red, I think you need to set up OOTP to keep old exports or something for it to work; it only does that if you use the correct setting, but I forget which one it is in-game.

I know about widgets and stats and stuff, I've heard it from others. Some day soon, life is busy at the moment. -Getch
Anybody know about this setting and where to find it as Getch suggested?

Thanks guys.
__________________
The SIMBL "An Online League Specifically FOR the GM and BY the GM."

www.simbaseballleague.com

A Premier Online League Always Seeking Quality Owners- Join The SIMBL!

Last edited by GMGOD; 09-07-2012 at 12:33 PM.
GMGOD is offline   Reply With Quote
Old 09-11-2012, 10:52 AM   #153
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
From my old readme, there should be options in the Online League setup screen or Commish Portal.

Delete on Import: If this method is used, new exports will have a date and time associated with it, and teams with old exports will have “No Export” next to them.

Don’t Delete, but Do Not Backup on Import: If this option is used, there will be a data and time associated with any team that has exported in the past.

Backup Exports after Import: If this option is used, there will be a data and time associated with any team that has exported in the past. Additionally, all old exports will be colored red, and new exports will be colored blue.


Looks like you want the last option
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 09-14-2012, 11:26 AM   #154
gollum65
All Star Reserve
 
Join Date: Feb 2007
Posts: 925
Hi Getch,

I've been running your great utility for years but now I've encountered a problem. I'm running the utility for OOTP 12 and it's worked flawlessly since I upgraded to 12 when that version of the game first came out. Now all of a sudden I can't login to the utility and I'm the only one who would have admin rights. I do have two "users" in the game, one unemployed and the other a team manager (my main account) but it's been this way forever and hasn't caused a problem.

I've tried to login both through Firefox & IE9 and I keep having the same problem. I can login to my team account but when I click on any link I'm logged back out.

Any help would be appreciated.
__________________
OOTP X Beta Team
gollum65 is offline   Reply With Quote
Old 09-14-2012, 08:37 PM   #155
sjshaw
Minors (Triple A)
 
Join Date: Jan 2002
Posts: 236
We're having the same problem in FOBL (for OOTP v13), and the same problem just started happening. I can log in, but when I click on the "dev" link, I get kicked out. Any help would be incredibly appreciated.

Quote:
Originally Posted by gollum65 View Post
Hi Getch,

I've been running your great utility for years but now I've encountered a problem. I'm running the utility for OOTP 12 and it's worked flawlessly since I upgraded to 12 when that version of the game first came out. Now all of a sudden I can't login to the utility and I'm the only one who would have admin rights. I do have two "users" in the game, one unemployed and the other a team manager (my main account) but it's been this way forever and hasn't caused a problem.

I've tried to login both through Firefox & IE9 and I keep having the same problem. I can login to my team account but when I click on any link I'm logged back out.

Any help would be appreciated.

Last edited by sjshaw; 09-14-2012 at 08:39 PM.
sjshaw is offline   Reply With Quote
Old 09-15-2012, 06:15 AM   #156
gollum65
All Star Reserve
 
Join Date: Feb 2007
Posts: 925
@sjshaw: If I don't hear back from Getch this weekend my next idea is to try to create a new, unemployed GM in the game and set him as an admin. Then when I update the GMs in the utility I should be able to login using the default password as an admin and fix everything else....I hope.

If that doesn't work I have no idea what to do.
__________________
OOTP X Beta Team
gollum65 is offline   Reply With Quote
Old 09-15-2012, 03:58 PM   #157
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Do you guys have the latest code? Open up the file OOTPOU/Utils.pm, and search for setCookie. The expiration date should be:

$expire = 'Thu, 2 Aug 2020 00:00:00 UTC';

The old code had it set to expire:

$expire = 'Sun, 09-09-2012 00:00:00 GMT';

I guess when I first wrote OU I never thought we'd still be here 6 years later . God help me if I have to fix the 2020 expiration date.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details
Getch is offline   Reply With Quote
Old 09-16-2012, 03:20 AM   #158
gollum65
All Star Reserve
 
Join Date: Feb 2007
Posts: 925
Quote:
Originally Posted by Getch View Post
Do you guys have the latest code? Open up the file OOTPOU/Utils.pm, and search for setCookie. The expiration date should be:

$expire = 'Thu, 2 Aug 2020 00:00:00 UTC';

The old code had it set to expire:

$expire = 'Sun, 09-09-2012 00:00:00 GMT';

I guess when I first wrote OU I never thought we'd still be here 6 years later . God help me if I have to fix the 2020 expiration date.
LOL, yup, that fixed it. Thanks Getch. I never updated to the latest code because until this happened I never needed to. That's how good your util works.
__________________
OOTP X Beta Team
gollum65 is offline   Reply With Quote
Old 09-17-2012, 01:49 AM   #159
sjshaw
Minors (Triple A)
 
Join Date: Jan 2002
Posts: 236
We'll give it a shot... thanks!

Quote:
Originally Posted by Getch View Post
Do you guys have the latest code? Open up the file OOTPOU/Utils.pm, and search for setCookie. The expiration date should be:

$expire = 'Thu, 2 Aug 2020 00:00:00 UTC';

The old code had it set to expire:

$expire = 'Sun, 09-09-2012 00:00:00 GMT';

I guess when I first wrote OU I never thought we'd still be here 6 years later . God help me if I have to fix the 2020 expiration date.
sjshaw is offline   Reply With Quote
Old 09-17-2012, 02:00 AM   #160
sjshaw
Minors (Triple A)
 
Join Date: Jan 2002
Posts: 236
That worked, thanks so much!
sjshaw 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 12:41 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 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments