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

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

Reply
 
Thread Tools
Old 02-14-2021, 01:27 PM   #1
jturner421
Bat Boy
 
Join Date: Aug 2016
Posts: 7
SQL Query to Identify Draft Pool

Using OOTP 20. I'm working on creating a web application to replace my Excel spreadsheet that I've used in the past for generating custom rankings for an amatuer draft. Copying, pasting, and parsing HTML generated reports gets old and with access to a MySQL db dump, direct queries seems to be a better way to go.

However, I'm having trouble replicating the results of draftees generated directly by OOTP vs SQL. The OOTP draft pool shows 1550 eligible players. My first attempt:

SELECT Count(*) from players
where draft_eligible=1

This results in 3,879 players. Adding experience = 0 to the query drops the count to 1,533.

I then started cross-referencing names from the OOTP generated list against the query list. Some players in my query results were not showing up on the OOTP list. Isolating them in their own query, I can't find any difference in the player table that would suggest why one appears in my results versus the OOTP list. I'm thinking that I might need to join the player_roster_status table although only two fields (pro_service_days, and pro_service_years) makes sense in this context.

For those who have experience generating draft lists, what am I missing?
jturner421 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 05:02 AM.

 

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