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 02-23-2012, 02:44 PM   #121
Zarberg
Minors (Double A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 100
Quote:
Originally Posted by Getch View Post
Does the file:

OOTPOU/Utils.pm

exist? Maybe you extracted all of the files into the same directory?
It does exist. When I extracted it I copied the .zip file to my cgi-bin directory and did an "extract here" option from gnome in Ubuntu. I even tried copying all the files in that folder into a few other locations listed in the error message. I've also made sure to chmod those files as well.

EDIT:

Ok, HOOOOLD everything, just reinstalled Apache and IT WORKS.

Thank you, thank you, thank you!

Last edited by Zarberg; 02-23-2012 at 02:52 PM.
Zarberg is offline   Reply With Quote
Old 02-23-2012, 09:56 PM   #122
Zarberg
Minors (Double A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 100
Ok, getting another problem but I think this one can be overcome easily. I get the main page when I go to ootpou.pl, but after putting in my Server URL, League HTML reports folder, and CGI folder I click "save" and nothing - doesn't look like it's pulling from the .css file.

When I check out the files on the server I don't see any modified recently, should I be seeing that?

I've attached an output of the web page source (right-click, view page source) after I clicked save, and I noticed about a dozen lines down that "styles.css" does not have any domain info, and there are also references to a js/json folder that was not created/doesn't exist on my server. Could this be a permissions issue where my server is not letting ootpou.pl create files?

Again, thanks for all your hard work. If I can get this up and running on my site I'll definitely be making a donation!
Attached Files
File Type: txt ootpou.pl.output.txt (15.4 KB, 136 views)
Zarberg is offline   Reply With Quote
Old 02-23-2012, 11:01 PM   #123
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Sounds like OU is unable to write to the file OOTPOU/setup.txt

I would check the permissions of the OOTPOU directory, and also OOTPOU/setup.txt and see if changing them allows OU to write to the file.

May also be worth creating a simple Perl script that writes to a file to see if maybe it is a server setup issue where cgi scripts do not have permission to write to the server.
__________________
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 02-23-2012, 11:47 PM   #124
Zarberg
Minors (Double A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 100
Quote:
Originally Posted by Getch View Post
Sounds like OU is unable to write to the file OOTPOU/setup.txt

I would check the permissions of the OOTPOU directory, and also OOTPOU/setup.txt and see if changing them allows OU to write to the file.

May also be worth creating a simple Perl script that writes to a file to see if maybe it is a server setup issue where cgi scripts do not have permission to write to the server.
Bingo. Setup.txt had gotten an executable tag on it, as soon as I turned it off everything came on. I suppose I could have figured that out myself eventually after hours of anguish and going through your .pl files.

Brilliant work, man.
Zarberg is offline   Reply With Quote
Old 03-03-2012, 10:01 PM   #125
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
OU version 4.1.1 Released!

I managed to squeeze out enough time between raising my second daughter to finish off the next version, which mainly consists of the Draft History utility. I originally thought this would be a somewhat straightforward utility to write, but it became a large project on its own. It includes:

- Viewing the history by year, by pick, or by team. So you can compare the 2010 draft, or you can compare all third overall picks, or you can compare all your team's picks in the first round, for instance.
- Filtering any of the results. So you can filter the results to display only players with over 1000 IP or over 3000 AB's from the 2010 draft.
- An Analysis tool that will give you the best picks and best team's picks (if viewing by year) of whatever draft info you are viewing.
- Support for viewing draft history from the beginning even for OOTP 6 leagues. OOTP didn't start tracking draft position in the csv files until OOTP 2007, so any league from before that will be missing those draft's history. I actually managed to reverse engineer that draft history. In addition, if you used CATO and still have that history lying around, I can pull even more draft history from there.

And some minor other changes elsewhere in OU:

- Added a Career Stats panel to the player details panels
- Fixed an issue where manager profile info was not being updated properly
- Minor fixes to the Gamecast utility. One change of note is that it now displays the handedness of the current pitcher and batter.


To see a demo of the draft history, here's a link to the utility for one league that existed since OOTP 6:

Rookie Draft History


To Install: If you already have OU on your site, use the OOTPOUPatch.zip link in my sig. Fresh installs should use the OOTPOU.zip link.
- Copy the zip to the cgi-bin directory
- Go to the main Admin tab and click "Generate UI Files".
- Go to the Last Sim Admin tab and click "Clear Game Logs".
- People will need to refresh their browser cache since some of the .js files have changed. If you get odd behavior in the Gamecast, most likely they need to clear their cache
- If you have CATO, you also need to enter the location of the CATO HTML files in the main Admin tab. The location is relative to OU in the cgi-bin. So if OU is installed in www/cgi-bin, and CATO HTML exists in www/cato, the value for "CATO directory" should be ../cato. If you don't have CATO files, just leave this blank.

Draft History
- To generate the draft history, go to the Draft Admin page and click Generate in the new History section (scroll down the page to find it).
- Once you generate history for a draft year, it cannot be regenerated through the OU UI. You need to go to OOTPOU/draft/history/<league> and delete the y<year>.txt file. Just know that you may lose history if you regenerate the history later on, since players that retired without never making it to the majors will no longer be listed.
- History needs to be generated once per year, to update with the prior year's draft. The best time to update is the preseason, but it doesn't really matter. Note that this only builds who was drafted when, the player's stats are all updated dynamically and up-to-date.
- The history is generated from looking at the csv files, HTML files, old draft files, and (optionally) CATO. Note that leagues that store their HTML in the MySQL Database will lose a lot of the logic used to reconstruct the history. I would suggest briefly loading the HTML files locally on the server when generating the draft history (once it is generated you can delete the HTML files).

Note that generating the history turned out to be incredibly complex, since I found that there is often missing data and bad data in the csv files and the HTML files. For instance, a pick in the supplemental round is listed as the first round in the csv files, so you have duplicate first round picks. So the algorithm had to look at the various sources of data and do its best guess as to what was correct or not.

Long story short, please keep your eye out for incorrect history. I tested it on two leagues, one being an OOTP 6 league, one a league with pick compensation, and it all looked ok, but every league is different.


Lastly, this will probably be the last major update to OU before OOTP 13 is released, and all future updates will be against OOTP 13. Obviously, I'll supply a fix if any bad bugs are found, of course.

Let me know how the utility turns out. Hope you enjoy it; I have to say I've spent a lot of time looking over the old drafts. If you do like it, I'll direct you to the Donate link at the bottom of every OU page. So far the new version of OU has garnered $15 in donations (thank you to those who did donate).
__________________
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 03-12-2012, 04:45 AM   #126
BobDylanRH
Minors (Double A)
 
Join Date: Jun 2009
Posts: 149
Thanks Getch, I love it!

I can't get it to read my exports though. As far as I can tell, the path is correct in the admin settings.
BobDylanRH is offline   Reply With Quote
Old 03-12-2012, 08:42 AM   #127
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by BobDylanRH View Post
Thanks Getch, I love it!

I can't get it to read my exports though. As far as I can tell, the path is correct in the admin settings.
PM me the connection info (URL and commish user and pwd) and I can take a look.

In general, issues related to filling in the setup fields in the Admin screen is best to just PM me. I'm trying to simplify it all in the next version too.
__________________
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 03-25-2012, 03:13 PM   #128
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
i am having some trouble, i know it is me but am stuck anyway

most things seem to work except the draft. the images for select, remove, ect. don't show up, but the buttons work so no real big deal. but the apply button doesn't work, we can change the view to anything & the ratings sorter chooser changes but when we hit apply nothing happens to the listed players, we can't even look a pitchers.

i hope that makes sense. any isead on what i should look for?

oh and everytime i run a sim update i get

Error Occurred!
Illegal division by zero at OOTPOU/LSAdmin.pm line 1905.
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball

Last edited by jazzrack; 03-25-2012 at 03:16 PM.
jazzrack is offline   Reply With Quote
Old 03-26-2012, 12:31 AM   #129
kq76
Global Moderator
 
kq76's Avatar
 
Join Date: Nov 2002
Posts: 11,741
jazz, I wonder if the CBL and CLB's problems are related since they're sharing the same space. When trying to update the CBL's last sim report we get, "Error Occurred!
Can't use string ("12") as an ARRAY ref while "strict refs" in use at OOTPOU/LSAdmin.pm line 597.".
kq76 is offline   Reply With Quote
Old 03-26-2012, 03:02 AM   #130
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
i dunno, this is my third try at installing this and i have yet to get the draft to work right. (first time i just screwed it up, second time i got it right, even the graphincs showed up right, but i installed it after a draft class had been started so the draft didn't work, and now this)

but i think your problem happened after the server upgrade

Quote:
This upgrade includes newer software packages (including Python, Perl and gcc), as well as all the security and performance benefits that come along with CentOS 6. In addition to this, the server will be redeployed with a different file system type simultaneously, further increasing performance.

Although a bulk of the upgrades to your server are being done with it online and functional, in order to safely finalize these changes our Administrators will need to temporarily take your server offline in the early morning hours. Barring any extenuating circumstances this outage should only last about 2 hours.

Please note that while we do not anticipate your software having problems post-update, it may be required to re-compile any module(s) you are using to take advantage of the newer included libraries. We suggest reviewing your site afterward to verify that it is functioning as it should.
we have been sharing space for a month or so but the last sim problem just showed up this week.

speaking of the website. i need to pay that bill
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball

Last edited by jazzrack; 03-26-2012 at 03:08 AM.
jazzrack is offline   Reply With Quote
Old 03-26-2012, 06:02 PM   #131
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by jazzrack View Post
most things seem to work except the draft. the images for select, remove, ect. don't show up, but the buttons work so no real big deal. but the apply button doesn't work, we can change the view to anything & the ratings sorter chooser changes but when we hit apply nothing happens to the listed players, we can't even look a pitchers.
This is one of two things. You either didn't run "Generate UI Files" in the Admin screen, or else your root HTML directory is incorrect. If generating the UI files doesn't fix it, easiest way to debug is to right-click one of the broken images and look at what URL it is referring to. It should be http://<server>/OOTPOU/images/<image>. It is derived from the values set in the Admin screen, so ideally it should be apparent what is wrong. Fix them and rerun Generate UI Files. PM if you need more help, this is an easy fix.

Quote:
oh and everytime i run a sim update i get

Error Occurred!
Illegal division by zero at OOTPOU/LSAdmin.pm line 1905.
Make sure you fill in the Pyth. exponent (use 1.83) and the seasons to simulate in the Last Sim Admin screen. Save the value before running it too.


Note that in the next version I am making it much more obvious if one of these parameters is wrong.
__________________
Get the OOTP Online Utilities for online leagues!
Includes Gamecast, Development, Live Sims, Voting and more.
Check here for more details

Last edited by Getch; 03-26-2012 at 06:41 PM.
Getch is offline   Reply With Quote
Old 04-01-2012, 03:21 PM   #132
jazzrack
Hall Of Famer
 
jazzrack's Avatar
 
Join Date: Oct 2003
Location: still kicking
Posts: 3,229
and officer and a getleman i say

thank you sir!!
__________________
.
"Never confuse composure for ease"

Was once Head Cheese of Corporate League Baseball
jazzrack is offline   Reply With Quote
Old 04-03-2012, 02:14 AM   #133
Zarberg
Minors (Double A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 100
Can the Draft utility handle Supplemental picks for draftees not signed the previous year? For example, my league's first 4 rounds of picks go as follows:

Code:
R1
TEX
MON
MIN
MIL
MIA
TOR
TOR
PHI
BOS
DET
LA
SEA
LA
CHI
R2
TEX
MON
MIN
MIL
BOS
MIA
TOR
PHI
BOS
DET
LA
SEA
LA
CHI
R3
TEX
MON
MIN
MIL
BOS
MIA
MIA
TOR
SEA
PHI
LA
BOS
DET
SEA
LA
CHI
R4
TEX
MON
MIN
MIL
MIA
TOR
PHI
BOS
DET
SEA
LA
CHI
Notice in Round 1 Toronto and LA both have 2 picks. In round 2 Boston and LA both have 2 picks, etc, etc.
__________________
The BIG Baseball League - by the GMs, for the GMs.

https://www.big-baseball.org/
Zarberg is offline   Reply With Quote
Old 04-03-2012, 09:53 AM   #134
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Yes. There is an "Insert Pick" button on every pick in the Draft Admin screen. Just insert additional picks where needed.
__________________
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-04-2012, 12:41 AM   #135
Zarberg
Minors (Double A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 100
Quote:
Originally Posted by Getch View Post
Yes. There is an "Insert Pick" button on every pick in the Draft Admin screen. Just insert additional picks where needed.
Excellent, thank you. I also poked around in .pm files and noticed you used sendmail, so I'm setting up my server to bounce sendmail requests through Gmail using my account since I'm behind a port-forwarded, NAT'ed firewall.

Appreciate all your help and hard work.
__________________
The BIG Baseball League - by the GMs, for the GMs.

https://www.big-baseball.org/
Zarberg is offline   Reply With Quote
Old 04-05-2012, 12:48 PM   #136
Zarberg
Minors (Double A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 100
There's a new bit of a quirk happening in my league (and one of my GMs claims it's happening in another OOTP:OU enabled league as well) in the draft. Essentially, the move up and move down buttons for teams working their list are not working as intended: it will work once, but if you go to move that same player up or down the list again nothing will happen. If you then try to move that player via the player above or below them they just go back to the original order.

You can check out my league draft here:

Rookie Draft Selection Report

most of the GMs haven't changed the password from the default

If you can't check it out yourself I can try to get a screen video cap later of what's going on.
__________________
The BIG Baseball League - by the GMs, for the GMs.

https://www.big-baseball.org/
Zarberg is offline   Reply With Quote
Old 04-05-2012, 12:51 PM   #137
thomamon
Global Moderator
 
thomamon's Avatar
 
Join Date: Sep 2003
Location: NJ
Posts: 5,274
Quote:
Originally Posted by Zarberg View Post
There's a new bit of a quirk happening in my league (and one of my GMs claims it's happening in another OOTP:OU enabled league as well) in the draft. Essentially, the move up and move down buttons for teams working their list are not working as intended: it will work once, but if you go to move that same player up or down the list again nothing will happen. If you then try to move that player via the player above or below them they just go back to the original order.

You can check out my league draft here:

Rookie Draft Selection Report

most of the GMs haven't changed the password from the default

If you can't check it out yourself I can try to get a screen video cap later of what's going on.
I just tried and had no problem moving players up and down multiple times...
__________________
Thomas A. Montalto
Please check out my Stupid Little Blog - http://www.stupidlittleblog.com
thomamon is offline   Reply With Quote
Old 04-05-2012, 12:57 PM   #138
Zarberg
Minors (Double A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 100
Quote:
Originally Posted by thomamon View Post
I just tried and had no problem moving players up and down multiple times...
In my league, using the link I provided? Hmmm ... I wonder if it's a browser issue then.
__________________
The BIG Baseball League - by the GMs, for the GMs.

https://www.big-baseball.org/
Zarberg is offline   Reply With Quote
Old 04-05-2012, 12:59 PM   #139
bigfatcat
Minors (Double A)
 
bigfatcat's Avatar
 
Join Date: Mar 2006
Posts: 158
Quote:
Originally Posted by thomamon View Post
I just tried and had no problem moving players up and down multiple times...
the 'glich' is described perfectly above. it is happening in two of my leagues, but in neither league is it happening to everyone. for some people it works fine...for others it's really hard to set a list.
the only way i can do it is to start with a blank list, and put the players in in the order i want them to be in...but if i try to make any changes in the order the utility just kind of does what it wants to do...reverts to an old order...adds back in players that had been previously deleted...puts in some players but leaves out others...
bigfatcat is offline   Reply With Quote
Old 04-05-2012, 07:02 PM   #140
Zarberg
Minors (Double A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 100
Quote:
Originally Posted by Zarberg View Post
In my league, using the link I provided? Hmmm ... I wonder if it's a browser issue then.
Looks like it is a browser issue ... Firefox works no problems.
__________________
The BIG Baseball League - by the GMs, for the GMs.

https://www.big-baseball.org/
Zarberg 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 06:04 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