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 03-29-2007, 04:57 PM   #61 (permalink)
Global Moderator
 
CommishJoe's Avatar
 
Join Date: Feb 2002
Location: Minneapolis, MN
Posts: 5,001
Thanks: 30
Thanked 69x in 40 posts
Quote:
Originally Posted by Getch View Post
Upgraded for 2007:

http://www.ootpdevelopments.com/boar...35#post2114335

It'll still work off of the 2006 utility, so you don't have to lose your development history upgrading!
Nice to see someone picked this up for 2007. Nice work Getch!!
__________________
Joe

Question to fiance -- How much do you love me?

Answer -- So much that we can get our legs tied together, walking 3 legged for the rest of our lives and I'd love it.
CommishJoe is offline   Reply With Quote
Old 05-14-2007, 01:40 PM   #62 (permalink)
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
Thanks: 0
Thanked 0x in 0 posts
on the draft utility, how come it only shows 1 page worth of players? any way to add more for better lists and draft decisions?
__________________
Phil Zuber

Beyond the Ivy - Commish, Twins GM
Stars and Stripes Baseball League - Cubs GM
Bricks and Ivy - Orioles GM

Sim Coalition - co-founder

Zubes is offline   Reply With Quote
Old 05-14-2007, 01:43 PM   #63 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
LOL, already coded, about to release it. We're running the draft in our league and just want to make sure issues don't crop up before I release. Call it a beta test.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 05-15-2007, 05:41 PM   #64 (permalink)
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
Thanks: 0
Thanked 0x in 0 posts
apparently we are having an issue where all the available players arent showing up as available either.
__________________
Phil Zuber

Beyond the Ivy - Commish, Twins GM
Stars and Stripes Baseball League - Cubs GM
Bricks and Ivy - Orioles GM

Sim Coalition - co-founder

Zubes is offline   Reply With Quote
Old 05-18-2007, 12:17 PM   #65 (permalink)
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
Thanks: 0
Thanked 0x in 0 posts
any word on when the new release for the utility will be released? i need to restart my league's draft because of the feeder league situation, and would like to have this available if possible..
__________________
Phil Zuber

Beyond the Ivy - Commish, Twins GM
Stars and Stripes Baseball League - Cubs GM
Bricks and Ivy - Orioles GM

Sim Coalition - co-founder

Zubes is offline   Reply With Quote
Old 06-29-2007, 02:28 PM   #66 (permalink)
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
Thanks: 0
Thanked 0x in 0 posts
hey Getch, question for ya...

i got the development utilty all working, but when i try to run the script, my site gets the following error:

<TABLE width="100%" align=center bgColor=#ffffff border=0 link="#0000ee" vlink="#0000ee" text="#000000"><TBODY><TR class=cellheader><TD bgColor=#788298><CENTER>This Account Has Exceeded Its CPU Quota </CENTER></TD></TR></TBODY></TABLE>
Please contact this site's webmaster.
Wait a few minutes and use your browser's "Back" button or click here to try again.


<HR>If you are the webmaster, your account may have exceeded for one or more of the following reasons:
  • <LI class=style2>Your site has used more than 20% of the cpu. <LI class=style2>Your account has too many processes running at the same time.
  • Your site was consuming too many resources. This happens on occassion to very busy sites that have inefficient scripts running.
Any idea if i can get around this, or am i stuck?
__________________
Phil Zuber

Beyond the Ivy - Commish, Twins GM
Stars and Stripes Baseball League - Cubs GM
Bricks and Ivy - Orioles GM

Sim Coalition - co-founder

Zubes is offline   Reply With Quote
Old 07-03-2007, 12:21 PM   #67 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
Sorry I missed all these posts.

The "missing players" happens due to feeder leagues... the .csv dumps don't mark them as rookies. Markus gave me the code to determine if the players are really draft eligible, but I promptly forgot all about it until you just reminded me now.

The new version of the draft was released a while back. Get it from ootpmodsquad.

The CPU issue... that's a problem. The process probably chews up a ton of CPU as it is parsing and calculating a bunch (although I would think most of it would be I/O, and not CPU). You might be hosed, but you could try copying all the data (development dir, csv files, prevRatings.txt) to a different server, and running it there, and copying the data back when complete.

I'm sure there is command in Linux to run genDev from the server in such a way that it takes longer and spreads out the CPU use, but I don't know offhand. You could put sleep commands in the middle of the code to put the thread to sleep every few seconds to spread out the CPU as well.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 07-03-2007, 12:57 PM   #68 (permalink)
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
Thanks: 0
Thanked 0x in 0 posts
yeah i figured i was out of luck for the development utility, but i will try your suggestion and see if it works.

and just so that i am clear on the draft utility, the new version does in fact mark feeder league players? or did you forget about it in the new release?
__________________
Phil Zuber

Beyond the Ivy - Commish, Twins GM
Stars and Stripes Baseball League - Cubs GM
Bricks and Ivy - Orioles GM

Sim Coalition - co-founder

Zubes is offline   Reply With Quote
Old 07-03-2007, 02:25 PM   #69 (permalink)
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 631
Thanks: 0
Thanked 41x in 22 posts
It does not handle feeder leagues.
__________________
Get my OOTP Online Utilities for online leagues! One utility, ELEVEN tools:

1. All Star Voting Utility
2. End of Season Awards Utility
3. Development Tracker
4. Draft Utility
5. Export Tracker
6. Gamecast (new)
7. Hall of Fame Voting Utility
8. Last Sim Utility
9. Live Sim Utility (new)
10. Manager's Page
11. Ratings Reports

OOTPOU for OOTP 11/12
Latest OOTPOU Patch for OOTP 11/12
Readme
Getch is offline   Reply With Quote
Old 07-03-2007, 02:26 PM   #70 (permalink)
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
Thanks: 0
Thanked 0x in 0 posts
thanks for the response Getch. I worked around it last time, so i will just continue to handle it the same way i did last time.

Thank you again for all your help!
__________________
Phil Zuber

Beyond the Ivy - Commish, Twins GM
Stars and Stripes Baseball League - Cubs GM
Bricks and Ivy - Orioles GM

Sim Coalition - co-founder

Zubes 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 03:14 PM.


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