Home | Webstore
Latest News: OOTP Update 20.5.52 - OOTP 20 Available - FHM 5 Available

MLB All-Star Game Special: Save 50% on OOTP 20!

  

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

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

Reply
 
Thread Tools
Old 01-04-2011, 07:12 PM   #161
jdettbarn
All Star Reserve
 
jdettbarn's Avatar
 
Join Date: Mar 2002
Location: Buffalo, NY
Posts: 635
Thanks: 19
Thanked 3x in 2 posts
Frank -- no matter what settings I use my ammy draft keeps auto picking the entire thing. Anything I should check out to fix?

We got through 8 picks fine... then for #9 there was a day or two delay. The utility auto'd the pick and the rest of the draft. Now no matter what I do, the utility autos the draft after a few minutes of making any change.

For the record, I had the following checked:

Enable Draft
Pause Auto Picks
Set Team to Auto After Auto Pick

That's it... past seasons we used the timer (didn't this year due to holidays) so some of the timer fields are still filled in. None of the checkboxes in that section are checked though, so I figured it would ignore them.

Thanks for the help!

UPDATE: cleared out the timer fields and saved. will report back...
UPDATE #2: yeah think that may have worked. had an owner make a pick and no auto'd picks after. will report back if it happens again.
UPDATE #3: yeah it didn't work. It auto'd the entire draft like a minute after I updated this post. Frustrating!
__________________

NPBL Idaho Spuds GM
Former Federal Baseball League and JOBL Commish (2002 - 2011)

Last edited by jdettbarn; 01-04-2011 at 07:31 PM.
jdettbarn is offline   Reply With Quote
Old 01-04-2011, 08:05 PM   #162
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
that setting isnt 'pause auto picks'. Its 'parse'................

Have you tried turning that off?
Cooleyvol is offline   Reply With Quote
Old 01-04-2011, 08:42 PM   #163
jdettbarn
All Star Reserve
 
jdettbarn's Avatar
 
Join Date: Mar 2002
Location: Buffalo, NY
Posts: 635
Thanks: 19
Thanked 3x in 2 posts
Says "Pause Auto Picks (manual only):" in mine...

I can try it I guess, nothing else has worked.
__________________

NPBL Idaho Spuds GM
Former Federal Baseball League and JOBL Commish (2002 - 2011)
jdettbarn is offline   Reply With Quote
Old 01-04-2011, 08:47 PM   #164
jdettbarn
All Star Reserve
 
jdettbarn's Avatar
 
Join Date: Mar 2002
Location: Buffalo, NY
Posts: 635
Thanks: 19
Thanked 3x in 2 posts
Wow, it just auto'd everything and I didn't even have the draft enabled.
__________________

NPBL Idaho Spuds GM
Former Federal Baseball League and JOBL Commish (2002 - 2011)
jdettbarn is offline   Reply With Quote
Old 01-05-2011, 08:39 PM   #165
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,176x in 442 posts
Jason, have you installed this draft fix?
Draft fix
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 01-05-2011, 09:04 PM   #166
jdettbarn
All Star Reserve
 
jdettbarn's Avatar
 
Join Date: Mar 2002
Location: Buffalo, NY
Posts: 635
Thanks: 19
Thanked 3x in 2 posts
Quote:
Originally Posted by fhomess View Post
Jason, have you installed this draft fix?
Draft fix
Nope. Missed that one... will test it out now. thanks!
__________________

NPBL Idaho Spuds GM
Former Federal Baseball League and JOBL Commish (2002 - 2011)
jdettbarn is offline   Reply With Quote
Old 01-07-2011, 01:32 AM   #167
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,176x in 442 posts
Patch 2.1.0 (beta)

I haven't finished documenting this officially, but I think the code is ready to be released to a wider audience. Here's what to expect:

Patch 2.1.0

New Features:
- New Sim Preview page available in Last Sim module, including the following:
- - Noteworthy upcoming matchups
- - Active team win/loss streaks
- - Active player streaks (pitcher wins, batter hits, etc)
- - Hot/Cold lists
- - Listing of players on DL who are expected back in the next sim
- - Triple crown contenders (after 1/3 of the season is complete)
- - Players with chance to hit .400 (after 1/3 of the season is complete)
- Team stats page in Last Sim module will now has game splits section to display inning-by-inning scoring and record when winning, losing, or tied after X innings.
- Team stats page in Last Sim module now has Starter and Reliever splits under pitching stats.
- Player stats page in Last Sim module now has ability to display stats accrued versus a single opponent
- Player stats page will now display strength of opposition for pitchers
- Ground balls, fly balls, and ground ball percentage added to player leaderboards
- The Draft admin page now lets you define draft rounds as supplemental rounds (just a display change, and you'll need to schedule an additional round)
- When the draft timer is on, a floating sidebar will now display the time remaining till the next pick is due, and will scroll with your screen
- The draft war room can now be filtered depending on if a player is on your team's draft list or not.
- New widget that can be used to display the last X and/or next X picks in your draft
- - Format is "widget.php?show=draftList&league_id=100&lastX=3&n extX=5"
- Various other miscellaneous enhancements

Fixes:
- Several draft fixes, notably one where the entire draft would uncontrollably auto draft itself even if told not to.
- Fixed issue with pitcher innings in team history pitching records
- Fixed team stats page to show only regular season games when "Season" option is selected
- Various other miscellaneous fixes

Download it here: StatsLab_patch210.zip

Installation:
1. Backup your existing StatsLab code
2. Unzip this into your StatsLab directory on your server
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.

Last edited by fhomess; 01-07-2011 at 01:33 AM.
fhomess is offline   Reply With Quote
Old 01-07-2011, 04:46 AM   #168
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
That's a hefty set of enhancements, Frank! Love the draft widget. Hope my idea spawned that.
Cooleyvol is offline   Reply With Quote
Old 01-07-2011, 11:12 AM   #169
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,176x in 442 posts
Quote:
Originally Posted by Cooleyvol View Post
That's a hefty set of enhancements, Frank! Love the draft widget. Hope my idea spawned that.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 01-07-2011, 01:02 PM   #170
BleedingCubbyBlue
All Star Reserve
 
BleedingCubbyBlue's Avatar
 
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
Thanks: 5
Thanked 1x in 1 post
Very nice. Thanks!
__________________

BleedingCubbyBlue is offline   Reply With Quote
Old 01-16-2011, 12:21 PM   #171
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
Formatting Widgets:

Try as I may, I can't get them to format using css.

I found this post but I'm unsure as to where to put that code in my css file. I'm using a php include call to get the widgets to show up. That's working, but formatting is not.
Cooleyvol is offline   Reply With Quote
Old 01-16-2011, 12:24 PM   #172
Cooleyvol
Hall Of Famer
 
Cooleyvol's Avatar
 
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,309
Thanks: 67
Thanked 632x in 375 posts
Nevermind. Figured it out.
Cooleyvol is offline   Reply With Quote
Old 01-18-2011, 01:25 PM   #173
mikev
Hall Of Famer
 
mikev's Avatar
 
Join Date: Dec 2004
Location: Bay Area, CA
Posts: 4,014
Thanks: 0
Thanked 29x in 23 posts
If I wanted to start using Statslab when our league has quite a few seasons using the Getch utility, is there a way to import the data currently in the Getch stuff, like development?
__________________
Global Unified Baseball Association - Vice Commish and Oakland Oaks GM
mikev is offline   Reply With Quote
Old 01-18-2011, 02:46 PM   #174
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,176x in 442 posts
Quote:
Originally Posted by mikev View Post
If I wanted to start using Statslab when our league has quite a few seasons using the Getch utility, is there a way to import the data currently in the Getch stuff, like development?
You can import development from OOTPOU, yes (at least, this worked in OOTPX, I never tested it with OOTP11).
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 01-20-2011, 07:07 AM   #175
f.montoya
Hall Of Famer
 
f.montoya's Avatar
 
Join Date: Nov 2004
Posts: 6,044
Thanks: 299
Thanked 287x in 138 posts
Revised installation video for StatsLab 11 here...

http://www.ootpdevelopments.com/boar...sion-11-a.html

StatLab is incredibly popular! Being there are changes in the installation process, I keep getting bugged with emails that my video(for StatsLab 10) doesn't show this or doesn't show that, so I made a new one today. It was harder this time around but I managed to install it after 2 tries.
__________________
Fidel Montoya

Asahi2 Baseball ex-Commissioner(Historical League Since 2004)
www.allsimbaseball.com (OOTP web hosting - Customized sites for online leagues - Sign up, Connect OOTP and Play!)
Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required)
f.montoya is offline   Reply With Quote
Thank you for this post:
fhomess (01-20-2011)
Old 01-20-2011, 08:09 AM   #176
DWK
All Star Reserve
 
DWK's Avatar
 
Join Date: Mar 2007
Location: Bluffton, South Carolina
Posts: 631
Thanks: 31
Thanked 21x in 18 posts
Quote:
Originally Posted by f.montoya View Post
Revised installation video for StatsLab 11 here...

http://www.ootpdevelopments.com/boar...sion-11-a.html

StatLab is incredibly popular! Being there are changes in the installation process, I keep getting bugged with emails that my video(for StatsLab 10) doesn't show this or doesn't show that, so I made a new one today. It was harder this time around but I managed to install it after 2 tries.
Fidel you should sticky this
DWK is offline   Reply With Quote
Old 01-20-2011, 09:53 AM   #177
f.montoya
Hall Of Famer
 
f.montoya's Avatar
 
Join Date: Nov 2004
Posts: 6,044
Thanks: 299
Thanked 287x in 138 posts
Quote:
Originally Posted by DWK View Post
Fidel you should sticky this
Would if I could, but can't so I won't.
__________________
Fidel Montoya

Asahi2 Baseball ex-Commissioner(Historical League Since 2004)
www.allsimbaseball.com (OOTP web hosting - Customized sites for online leagues - Sign up, Connect OOTP and Play!)
Share Your Mods - Free, unlimited and easy to upload to share your Mods instantly(free site registration required)
f.montoya is offline   Reply With Quote
Old 01-20-2011, 12:08 PM   #178
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,176x in 442 posts
Thanks, Fidel! I've updated the link in the first post of this thread.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 01-22-2011, 09:10 AM   #179
beorn
All Star Starter
 
beorn's Avatar
 
Join Date: Dec 2001
Location: near Rochester, NY
Posts: 1,263
Thanks: 36
Thanked 130x in 71 posts
It seems that "Last sim" information covers 10 days, when we sim 7 days at a time. Yet I see no place to set that information. As best as I can see, Stats Lab simply determines the length of sims automatically, and on the Admin page it says the sim is 7 days.

Any way to set this so that "Last sim" actually covers just the 7 days?
__________________
Commish of Dog Days Baseball
Commish Pennant Chase Baseball League (PCBL)
Commish and Blue Jays GM Extra Innings Baseball
beorn is offline   Reply With Quote
Old 01-22-2011, 09:52 AM   #180
DWK
All Star Reserve
 
DWK's Avatar
 
Join Date: Mar 2007
Location: Bluffton, South Carolina
Posts: 631
Thanks: 31
Thanked 21x in 18 posts
Quote:
Originally Posted by f.montoya View Post
Would if I could, but can't so I won't.
Nice!
DWK is offline   Reply With Quote
Reply

Bookmarks

Thread Tools

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:36 AM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

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 © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments