Home | Webstore
Latest News: OOTP 25 Available - FHM 10 Available - OOTP Go! Available

Out of the Park Baseball 25 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 25 > OOTP Mods > OOTP Mods - Database Tools
Register Blogs FAQ Calendar Today's Posts Search

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

Reply
 
Thread Tools
Old 03-29-2007, 03:57 PM   #61
CommishJoe
Global Moderator
 
CommishJoe's Avatar
 
Join Date: Feb 2002
Location: Minneapolis, MN
Posts: 5,238
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

Success isn’t owned. It’s leased. And rent is due every day.
CommishJoe is offline   Reply With Quote
Old 05-14-2007, 12:40 PM   #62
Zubes
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
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, 12:43 PM   #63
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
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 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 05-15-2007, 04:41 PM   #64
Zubes
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
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, 11:17 AM   #65
Zubes
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
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, 01:28 PM   #66
Zubes
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
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, 11:21 AM   #67
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
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 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 07-03-2007, 11:57 AM   #68
Zubes
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
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, 01:25 PM   #69
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
It does not handle feeder leagues.
__________________
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 07-03-2007, 01:26 PM   #70
Zubes
Major Leagues
 
Zubes's Avatar
 
Join Date: Sep 2005
Location: Chicago, IL
Posts: 361
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


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 09:59 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 - 2024, vBulletin Solutions, Inc.
Copyright © 2020 Out of the Park Developments