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

Collection Missions for Perfect Team Released!

  

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 07-26-2012, 03:01 PM   #81
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Mr.Opinion View Post
I don't know what to say, but a list of email addresses is working in my league. Just as an FYI.
OK, that could be. I probably pass the email address you enter in the admin to sendmail, and sendmail probably can handle a list. Never tested it, but that makes sense.
__________________
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-26-2012, 03:54 PM   #82
Recte44
Global Moderator
 
Recte44's Avatar
 
Join Date: Dec 2001
Location: Oconomowoc, WI
Posts: 2,621
Thanks: 244
Thanked 173x in 103 posts
Sent from my DROIDX using QWQEE68!9qequ8wsawwawwweszdra4a™e2qqt34 2
__________________
Matt Rectenwald
Commissioner, GM: Las Vegas Hustlers, The Brewster Baseball Association- fictional league (JOIN NOW)
Recte44 is offline   Reply With Quote
Old 07-26-2012, 11:34 PM   #83
Zarberg
Minors (Single A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 96
Thanks: 8
Thanked 12x in 9 posts
Love the OU, thank you so much for working hard on them (and yes, I donated).

I'm having an interesting little issue on my draft page, not at all game-breaking, but curious. The tiny little icon images for the draft list (move up, move down, remove) are not appearing. There's a broken image box that displays the correct associated text, but no arrows/remove icon.

Rookie Draft Report

When I do a "view image info" in firefox, I get the following:

http://$self->{info}->{site}/OOTPOU/images/up.png
__________________
The BIG Baseball League - by the GMs, for the GMs.

http://www.danielwheeler.org
Zarberg is offline   Reply With Quote
Old 07-27-2012, 06:17 PM   #84
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Zarberg View Post
The tiny little icon images for the draft list (move up, move down, remove) are not appearing.
Yeah, I know about it. It'll be fixed in the next version. The buttons still work, the icons are just bad.
__________________
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 08-01-2012, 09:04 PM   #85
pallison14
Major Leagues
 
pallison14's Avatar
 
Join Date: Mar 2002
Posts: 452
Thanks: 33
Thanked 23x in 11 posts
Does OOTPOU support widgets?

We were a heavy Statslab user, and one of the features we used for our home page (United Baseball League (UBL)) were the Statslab widgets. I know it's probably not a huge feature, but something we'll miss with StatsLab no longer being supported.
__________________
Commissioner, NGBL - Putting the FUNK in defunct.

New York (AL), UBL
pallison14 is offline   Reply With Quote
Old 08-08-2012, 01:53 AM   #86
Isryion
Major Leagues
 
Join Date: Oct 2011
Posts: 318
Thanks: 16
Thanked 52x in 37 posts
Can anyone help me with what to do once I've finished a draft and then click "create import?" I can't figure out where the file is that it creates (and have looked in my server folders, etc...

Thanks.
Isryion is offline   Reply With Quote
Old 08-08-2012, 10:39 AM   #87
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Quote:
Originally Posted by Isryion View Post
Can anyone help me with what to do once I've finished a draft and then click "create import?" I can't figure out where the file is that it creates (and have looked in my server folders, etc...

Thanks.
It's not implemented . I actually have a working version of it internally, but there's a problem with OOTP that Markus might have to fix in the next patch.

For now, you still have to manually enter the draft in-game.

Quote:
Does OOTPOU support widgets?
It does not, but I am getting a lot of requests so I will look into it.
__________________
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
Thank you for this post:
pallison14 (08-11-2012)
Old 08-08-2012, 11:54 AM   #88
Mr.Opinion
All Star Reserve
 
Mr.Opinion's Avatar
 
Join Date: May 2003
Location: SkiFree Lodge
Posts: 881
Thanks: 7
Thanked 28x in 17 posts
Quote:
Originally Posted by Getch View Post
It's not implemented . I actually have a working version of it internally, but there's a problem with OOTP that Markus might have to fix in the next patch.

For now, you still have to manually enter the draft in-game.



It does not, but I am getting a lot of requests so I will look into it.
I'm going to put out a request to add into the hall of fame voting a flag that will keep a player off of the ballot if they didn't recieve a vote / % of votes. Either would be wonderful.
__________________
Mr.Opinion is offline   Reply With Quote
Old 08-09-2012, 03:20 PM   #89
Snoblitz
Minors (Rookie Ball)
 
Join Date: Feb 2012
Posts: 34
Blog Entries: 2
Thanks: 24
Thanked 6x in 4 posts
Hey Getch! Thanks for getting this awesome utility out to the community! It really adds to the online experience.

Got a question for you. I noticed that the draft utility doesn't seem to be honoring the "players shown" number in the admin panel. I can't get it to render any more than 30 players at once. It does however, honor anything below 30.

Any idea what I am doing wrong, or is this a bug?
Snoblitz is offline   Reply With Quote
Old 08-10-2012, 11:46 AM   #90
EKomrska15
All Star Starter
 
Join Date: Mar 2007
Posts: 1,200
Thanks: 102
Thanked 117x in 82 posts
Quote:
Originally Posted by Mr.Opinion View Post
I'm going to put out a request to add into the hall of fame voting a flag that will keep a player off of the ballot if they didn't recieve a vote / % of votes. Either would be wonderful.
Ha! I was just going to ask for the same thing....That would make it so much easier for future HOF voting years

Again thank you so much for the utility it is beautiful!
EKomrska15 is offline   Reply With Quote
Old 08-11-2012, 01:17 PM   #91
pallison14
Major Leagues
 
pallison14's Avatar
 
Join Date: Mar 2002
Posts: 452
Thanks: 33
Thanked 23x in 11 posts
Quote:
Originally Posted by Getch View Post
It does not, but I am getting a lot of requests so I will look into it.
Thanks for looking into adding widgets. I'm going to try and hack out a screen scraper for the HTML this weekend in Ruby orj Query. I just wish the OOTP HTML was easier to parse. Yuck!
__________________
Commissioner, NGBL - Putting the FUNK in defunct.

New York (AL), UBL

Last edited by pallison14; 08-11-2012 at 01:21 PM.
pallison14 is offline   Reply With Quote
Old 08-12-2012, 09:21 PM   #92
Zarberg
Minors (Single A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 96
Thanks: 8
Thanked 12x in 9 posts
Quote:
Originally Posted by Getch View Post
It's not implemented . I actually have a working version of it internally, but there's a problem with OOTP that Markus might have to fix in the next patch.

For now, you still have to manually enter the draft in-game.



It does not, but I am getting a lot of requests so I will look into it.
I think I figured it out. I had a job for a few years where I was basically an excel/CSV/text file guru/data massager.

And I noticed the bug you were talking about, luckily I had made a backup copy and knew how to avoid it the first time.
__________________
The BIG Baseball League - by the GMs, for the GMs.

http://www.danielwheeler.org
Zarberg is offline   Reply With Quote
Old 08-12-2012, 10:55 PM   #93
DenverZeppo
Minors (Rookie Ball)
 
Join Date: Mar 2009
Location: Denver, CO.
Posts: 34
Thanks: 2
Thanked 0x in 0 posts
Hi Getch!

I am one of those GUBA people who is always looking for new ways to break your program, but since this is a feature question rather than a broken file question, I thought I'd bring it here.

Previously I've played in several StatsLab leagues, and the GUBA used to be one as well, and there are things from StatsLab that I miss mightily. In the following order I would love to see these things brought into Getch if you ever feel like it.

Last Sim Player Stats (I'd love the option to get all stats from one conference or the other, or the entire league, rather than just one team at a time)
Last Sim Team Stats (Same thing, I'd love to be able to look at just one conference or the other at a time)
Milestone Watch - One of my favorite StatsLab functions was the list of upcoming milestones, would rock to have this back again.
Upcoming Sim Preview Page - Mostly it was really cool that it tracked team and player streaks; hitting, pitching, etc., and wins and losses for team.

I'd love to see any and all of these things if you happen to be looking for new things to add.
__________________
"Every team is going to win 54 games, and every team is going to lose 54 games. It's what you do with the other 54 games that counts." - Sam Seaborn

GM of Denver Bears - GUBA Reboot - 2012 to Present - GUBA Forums
DenverZeppo is offline   Reply With Quote
Old 08-27-2012, 03:11 PM   #94
OGBL Commish
Bat Boy
 
Join Date: Jul 2012
Posts: 14
Thanks: 0
Thanked 1x in 1 post
the Draft section of the readme is broken. will this be fixed?
OGBL Commish is offline   Reply With Quote
Old 08-29-2012, 01:57 PM   #95
pallison14
Major Leagues
 
pallison14's Avatar
 
Join Date: Mar 2002
Posts: 452
Thanks: 33
Thanked 23x in 11 posts
Quote:
Originally Posted by Getch View Post
It's not implemented . I actually have a working version of it internally, but there's a problem with OOTP that Markus might have to fix in the next patch.

For now, you still have to manually enter the draft in-game.



It does not, but I am getting a lot of requests so I will look into it.
Looking forward to this! Also, using the utility does not show players who have not been "released" from their HS/College teams yet. They're in the ingame tool, and are actually in the CSV file. I'm wondering, do they not show up in OOTPOU because they still may be assigned to other (amateur) teams?
__________________
Commissioner, NGBL - Putting the FUNK in defunct.

New York (AL), UBL
pallison14 is offline   Reply With Quote
Old 08-30-2012, 11:26 AM   #96
Zarberg
Minors (Single A)
 
Join Date: Oct 2011
Location: NC, USA
Posts: 96
Thanks: 8
Thanked 12x in 9 posts
I actually ended up getting the draft to work with the OU draft tool, but I had to open the csv file presented by the game and copy/past the player ID numbers into the correct spots, checking each cycle that they matched up.

The only thing is, OotP seemed to want to start the draft over again when it was finished, so instead of clicking "cancel" I just clicked the close box in the upper right corner to quit the game, and when I re-started things were fine.

For safety's sake, though, I made 2 backups of my league before I tried this.
__________________
The BIG Baseball League - by the GMs, for the GMs.

http://www.danielwheeler.org
Zarberg is offline   Reply With Quote
Old 09-04-2012, 07:03 PM   #97
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
this may be a dumb question...if so...I am sorry.

Can an expansion draft be set up in OOTPOU? My league is expanding so we would like to hold the draft for the 4 expansion teams if at all possible!

Does the set up work the same way as the Ammy draft?

Thanks
almo is offline   Reply With Quote
Old 09-08-2012, 08:25 PM   #98
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 866
Thanks: 1
Thanked 115x in 67 posts
Sorry guys, been busy of late. Catching up on the posts here:

Quote:
Originally Posted by pallison14 View Post
Looking forward to this! Also, using the utility does not show players who have not been "released" from their HS/College teams yet. They're in the ingame tool, and are actually in the CSV file. I'm wondering, do they not show up in OOTPOU because they still may be assigned to other (amateur) teams?
Have you set up the age limits of the feeder leagues in the Admin screen? I believe you need to set them as one year higher than in-game. MY league has feeder leagues and the draft utility shows all the players well prior to the ammy draft, regardless of whether they have been released or not.

Quote:
this may be a dumb question...if so...I am sorry.

Can an expansion draft be set up in OOTPOU? My league is expanding so we would like to hold the draft for the 4 expansion teams if at all possible!

Does the set up work the same way as the Ammy draft?
Well, it depends on how OOTP does it. I noticed for inaugural drafts, it'll actually set the player's "draft eligible" flag to true, so inaugural drafts actually work in OU (side note: the next release of OU will actually fully support inaugural drafts, inclugin auto-picking). If OOTP treats expansion drafts the same well, then you can use OU, although I would strongly oppose auto-picking, since OU thinks it's an ammy draft and only consider talent.
__________________
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 09-13-2012, 12:06 AM   #99
Killebrew
Hall Of Famer
 
Killebrew's Avatar
 
Join Date: Dec 2001
Posts: 3,326
Thanks: 120
Thanked 50x in 25 posts
Quote:
Originally Posted by ogbl commish View Post
the draft section of the readme is broken. Will this be fixed?
+2
Killebrew is offline   Reply With Quote
Old 09-13-2012, 12:14 AM   #100
Killebrew
Hall Of Famer
 
Killebrew's Avatar
 
Join Date: Dec 2001
Posts: 3,326
Thanks: 120
Thanked 50x in 25 posts
The draft list is not saving selections for me - any idea of what might cause something like that? TIA

Details:
- Some draft list selections are not saved at all.
- It seems like only 1 draft list name at a time is saved.
- Returning to the draft page will sometimes show a different draft list selection than you last picked.
Killebrew 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 01:02 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