Latest News: OOTP 13 Announced with Screenshots & Feature List! Pre-Order Now! - OOTP Baseball 12 Available! - iOOTP Baseball 2011 Available! - Title Bout Championship Boxing 2.5 released! - Inside the Park Baseball Patch 1.03 released, DEMO now available

Pre-Order OOTP 13, Save & Win! | OOTP 12 Off-Season Special, just $19.99!

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

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

Reply
 
LinkBack Thread Tools Display Modes
Old 01-04-2007, 02:40 PM   #21 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
One more thing. I took a peek at your waiver report. You have two guys with 3 days left:

<TABLE class=lpo style="MARGIN-BOTTOM: 12px" cellSpacing=0 cellPadding=1 width="100%"><TBODY><TR><TD class=s1_l>: P Fernando Campos - Revocable (3 days left)</TD></TR><TR><TD class=s2_l>: CF Abelardo Pedraza - Revocable (3 days left)</TD></TR></TBODY></TABLE>
Our league ran into this as well. We had a few guys in the game that were on waivers, but on no teams and in some sort of limbo state... I think it was a function of the roster set we used, not sure. Anyway, I believe the commish just went in and deleted them. You may have to do the same.
Getch is offline   Reply With Quote
Old 01-04-2007, 02:54 PM   #22 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
Quote:
Originally Posted by Getch View Post
Right, what I am saying is that the latest version at:

http://www.diamondleaguebaseball.com/utils/utils.zip

Has the code changes so that it supports any league ID. In that version, there is a LEAGUEID parameter in setup.txt. You should take that version and set 100 for your league ID.

The hardcoded DLB at the top of the page is also fixed in that version.
Okay so I just downloaded that zip, set the LEAGUEID parameter to 100, uploaded it, ran the script, and it's not working. Here's the link: http://www.sixfivepony.com/cgi-bin/development.html
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM

Last edited by mikev; 01-04-2007 at 03:00 PM.
mikev is offline   Reply With Quote
Old 01-04-2007, 03:24 PM   #23 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Yeah, looks like I packaged up the old version. I'll get it fixed tonight when I get home.
Getch is offline   Reply With Quote
Old 01-04-2007, 03:32 PM   #24 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
Cool, sounds good.

Thanks for all the work, too.
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Old 01-04-2007, 08:47 PM   #25 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Packaged the right files this time. Let me know how it works.
Getch is offline   Reply With Quote
Old 01-04-2007, 11:26 PM   #26 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
Quote:
Originally Posted by Getch View Post
Packaged the right files this time. Let me know how it works.
Seems to be working okay now, thanks.

It didn't automatically forward me to the development.html page after it ran, but that's no biggie.

One last thing, though... I don't suppose that it would be possible to have the development html page created in the same place as the waivers page, in the <LEAGUE>/news/html directory would it? That would totally totally rule (and keep pesky users out of my cgi-bin as well!)

Thanks again for the awesomeness.
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Old 01-05-2007, 12:00 AM   #27 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
development.html is also a script, it's not a flat html page like the waiver wire is. I'm sure there is a way to set up other directories to be "executable" like cgi-bin, but I don't know offhand.
Getch is offline   Reply With Quote
Old 01-05-2007, 01:51 AM   #28 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
Quote:
Originally Posted by Getch View Post
development.html is also a script, it's not a flat html page like the waiver wire is. I'm sure there is a way to set up other directories to be "executable" like cgi-bin, but I don't know offhand.
Oh, good point.

Nevermind then.
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Old 01-25-2007, 12:50 PM   #29 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
Quote:
Originally Posted by Getch View Post
development.html is also a script, it's not a flat html page like the waiver wire is. I'm sure there is a way to set up other directories to be "executable" like cgi-bin, but I don't know offhand.
ping: Getch

I had a request from one of our league owners that actually made a lot of sense.

You think it would be possible to code the development.html page so that decreases in ratings would show up in red text and then increases in ratings would show up in green text, and changes to Talents could stay bold whether they increase or decrease.

That would be pretty awesome.
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Old 01-26-2007, 12:40 PM   #30 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Sure thing, I'll let you know when it's done. I need to do a few other tweaks as well.
Getch is offline   Reply With Quote
Old 01-26-2007, 12:59 PM   #31 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
Awesome, thanks!
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Old 01-26-2007, 01:26 PM   #32 (permalink)
All Star Starter
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Greendale, WI
Posts: 1,921
Thanks: 24
Thanked 29x in 8 posts
BTW, this fricking rocks, Getch. I'm going to send you a PM regarding this.
Recte44 is offline   Reply With Quote
Old 01-26-2007, 02:03 PM   #33 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
ping: Getch

The genDev.html script seems to be erroring out when I try to run it today. The last sim in our league was Feb 1 - March 2, but the development.html page only shows development through Feb 1.

When I try to run the genDev.html script, it seems to time out and it doesn't automatically forward me to the development.html page. Is there a log generated anywhere that I can look at to try and see what might be happening?
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Old 01-28-2007, 02:32 PM   #34 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
There is no log... I would try telnet/SSH to the server and run it from there. There would likely be output from there that might tell you what is wrong
Getch is offline   Reply With Quote
Old 01-29-2007, 01:41 AM   #35 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
Quote:
Originally Posted by Getch View Post
There is no log... I would try telnet/SSH to the server and run it from there. There would likely be output from there that might tell you what is wrong
Okay, cool.

Also, any ideas on why the development report seems to be 1 sim behind the league? I.e. we just did our first regular season sim, so it's 4/12/1996 in our league. I got the newest file, exported to CSV, ran the script, and only see development for 4/2/1996, which was the previous sim that ran up to opening day.
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Old 01-29-2007, 11:55 AM   #36 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by mikev View Post
Okay, cool.

Also, any ideas on why the development report seems to be 1 sim behind the league? I.e. we just did our first regular season sim, so it's 4/12/1996 in our league. I got the newest file, exported to CSV, ran the script, and only see development for 4/2/1996, which was the previous sim that ran up to opening day.
It gets the league date from the HTML files. If you run the Dev report before the latest HTML files are uploaded, it will have the wrong date. Make sure to load the HTML files first.

Looking at your site, you are indeed loading the HTML pages after running the dev reports. A second feature of the dev report is providing the development of a particular player, and it being linked to the player's HTML page. For instance, see here, look at the link under "Contract Extension". If you load HTML after you run the dev report, you'll lose this link. LOL, you've only been using half of my utility this whole time!

Lastly, you'll notice I colored the dev reports as you requested. I also separated the team dev reports by year. You can grab these changes in the usual location.

Last edited by Getch; 01-29-2007 at 11:57 AM.
Getch is offline   Reply With Quote
Old 01-29-2007, 01:14 PM   #37 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
Quote:
Originally Posted by Getch View Post
It gets the league date from the HTML files. If you run the Dev report before the latest HTML files are uploaded, it will have the wrong date. Make sure to load the HTML files first.

Looking at your site, you are indeed loading the HTML pages after running the dev reports. A second feature of the dev report is providing the development of a particular player, and it being linked to the player's HTML page. For instance, see here, look at the link under "Contract Extension". If you load HTML after you run the dev report, you'll lose this link. LOL, you've only been using half of my utility this whole time!

Lastly, you'll notice I colored the dev reports as you requested. I also separated the team dev reports by year. You can grab these changes in the usual location.
That is absolutely awesome. Thanks Getch.

(ping Markus: For the love of god pay Getch a few bucks and include this in 2007!)
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Old 01-29-2007, 01:38 PM   #38 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
OK, HTML is updated, and I downloaded, setup, and ran the new version of the utility.

The colors are showing up properly, but the date is still showing April 01 and not April 11.
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Old 01-29-2007, 02:14 PM   #39 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Quote:
Originally Posted by mikev View Post
OK, HTML is updated, and I downloaded, setup, and ran the new version of the utility.

The colors are showing up properly, but the date is still showing April 01 and not April 11.
Did you run a new sim? The dates are stuck as they are once you run genDev.html... it's only going forward will new development changes be fixed to have the correct date.
Getch is offline   Reply With Quote
Old 01-29-2007, 02:33 PM   #40 (permalink)
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 3,984
Thanks: 0
Thanked 21x in 16 posts
Quote:
Originally Posted by Getch View Post
Did you run a new sim? The dates are stuck as they are once you run genDev.html... it's only going forward will new development changes be fixed to have the correct date.
I'm confused then. I thought if I re-ran genDev.html, it would regenerate the development.html page, and it would read the correct date since the HTML is current and shows 4/11/1996 as the date.

You're saying I have to wait until next sim, which will put the league to 4/21/1996, and then upload the HTML reports before I run genDev.html again. Then it should read correctly and show 4/21/1996 on the development.html page?
__________________
70% of the earth's surface is covered by water. The other 30% is taken care of by Patrick Willis.


Global Unified Baseball Association - Vice Commish and California Crusaders GM
mikev is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

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
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT -4. The time now is 05:49 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2012, vBulletin Solutions, Inc.
Search Engine Friendly URLs by vBSEO 3.6.0
Copyright © 2009 Out of the Park Developments