Home | Webstore
Latest News: OOTP 26 Available - FHM 11 Available - OOTP Go! Available

Out of the Park Baseball 26 Buy Now!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 26 > 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 04-10-2016, 04:18 PM   #481
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,053
Quote:
Originally Posted by Mike Lowe View Post
I'm the commish, but your reply has me thinking that the issue might be that I did NOT update the reports today in-game and up to our website.

I did, however, already reinstall the entire OOTPU, only to see the same guys appearing in the draft list.

What's odd is that I can also still search for these original draftees, even though they were all deleted in-game.
Also probably a good Idea to go to the admin section of the draft area in OOTPOU and click "Start over"
__________________
“As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth
“Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker
My Dynasties
The Beantown Bambino
Painmantle is offline   Reply With Quote
Old 04-10-2016, 05:03 PM   #482
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by soadeathdealer View Post
Getch having an issue. my friends draft just stopped working , like the draft arrows are gone and it wont auto pick and u have to manually pick for the gms by entering the ids . whats the fix?
Check the picks.txt file in the OOTPOU/draft/<league>/<year> directory. It may have a row that is just a hyphen -, or some bad row in there. Delete the bad row, should fix 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
Old 04-10-2016, 05:04 PM   #483
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by Mike Lowe View Post
I'm the commish, but your reply has me thinking that the issue might be that I did NOT update the reports today in-game and up to our website.

I did, however, already reinstall the entire OOTPU, only to see the same guys appearing in the draft list.

What's odd is that I can also still search for these original draftees, even though they were all deleted in-game.
Yeah, sounds like you never re-uploaded the CSV's
__________________
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 04-10-2016, 05:07 PM   #484
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by Mike Lowe View Post
So question 1 is should the server be set to 'www.simsportsglobal.com' or 'baseball.simsportsglobal.com'? I have the csv and OOTU files all housed in the subdirectory.

Question 2 is what should I put in the second row to remove that error?
Question 1: baseball.simsportsglobal.com

Question2: It shouldn't have the domain name in there (www.simsportsglobal.com), so it is either ssgbaseball/reports/news/html or reports/news/html, you'll have to play around with 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
Old 04-10-2016, 05:09 PM   #485
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by Marsupilami View Post
still not working. i am in a league still using 16 and a new 1 using 17. neither is working
Weird, I checked both a OOTP 16 and 17 league and saw it working in both places.
__________________
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 04-10-2016, 05:12 PM   #486
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,163
Quote:
Originally Posted by Getch View Post
Yeah, sounds like you never re-uploaded the CSV's
Thank you! I guess it just needed a second go at it, because it seems to be working now!
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 04-10-2016, 05:14 PM   #487
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,163
Quote:
Originally Posted by Mike Lowe View Post
Thank you! I guess it just needed a second go at it, because it seems to be working now!
Oh, nevermind. It's still the same old draftees for some silly reason.

Rookie Draft Report

That Troop guy you see listed first, he was deleted. So were all of the others.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 04-10-2016, 05:45 PM   #488
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,053
Quote:
Originally Posted by Mike Lowe View Post
Oh, nevermind. It's still the same old draftees for some silly reason.

Rookie Draft Report

That Troop guy you see listed first, he was deleted. So were all of the others.

did you start the draft over from the Draft admin page, operations section?
__________________
“As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth
“Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker
My Dynasties
The Beantown Bambino
Painmantle is offline   Reply With Quote
Old 04-10-2016, 08:37 PM   #489
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,163
Quote:
Originally Posted by Painmantle View Post
did you start the draft over from the Draft admin page, operations section?
Yes, and every single time it's the same players appearing that I deleted. It's driving me a bit crazy.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 04-10-2016, 08:39 PM   #490
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,163
What's also weird is that when I go to display on SS, the entire draft disappears.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 04-10-2016, 09:05 PM   #491
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,163
I re-export all of the CSV files in-game and upload to the /cgi-bin/csv folder
I re-export the draft.csv from the draft pool page and upload to the /cgi-bin/OOTPOU/draft/2016/144 folder
I reset the draft
I start the draft over
I clear my cache
I refresh my browser

The same damn players keep appearing as if they are ghosts. Even when I try and just do an auto-pick, it picks a player that isn't even in the draft pool in-game.

I've also tried in a different browser.

How on earth isn't this catching? it makes zero sense, and while I'm certain it's something wrong I'm doing, I'm sure I've followed the README to a T.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 04-10-2016, 10:24 PM   #492
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
Quote:
Originally Posted by Getch View Post
Check the picks.txt file in the OOTPOU/draft/<league>/<year> directory. It may have a row that is just a hyphen -, or some bad row in there. Delete the bad row, should fix it.
thanks i think i had to do that before but its so far in between like yrs i forget the fix lol


>Also side note My client who I host his league and help him setup everything wanted to suggest a timer on the draft selection page for gms to see sort of like they see on statslab
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues

OOTP

POTD: Vermont/Co-Commish
MTBL: League Closed
The Show: Jacksonville Bombers
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed

DDSPF

WWPF- Miami

CSFL- Tampa

USFL: New Orleans

DDSCF

SNCFL: Florida/ JMU

Last edited by soadeathdealer; 04-10-2016 at 10:26 PM.
soadeathdealer is offline   Reply With Quote
Old 04-11-2016, 09:19 PM   #493
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by Mike Lowe View Post
I re-export all of the CSV files in-game and upload to the /cgi-bin/csv folder
I re-export the draft.csv from the draft pool page and upload to the /cgi-bin/OOTPOU/draft/2016/144 folder
I reset the draft
I start the draft over
I clear my cache
I refresh my browser

The same damn players keep appearing as if they are ghosts. Even when I try and just do an auto-pick, it picks a player that isn't even in the draft pool in-game.

I've also tried in a different browser.

How on earth isn't this catching? it makes zero sense, and while I'm certain it's something wrong I'm doing, I'm sure I've followed the README to a T.
I replied via PM, but in case anyone is interested. Almost everything you see in OU is directly from the CSV files. I don't cache anything or store anything, everything is read from the CSV's. So if you see players that are wrong, or ratings, etc., most likely that's coming from the CSV files.

So, the first step is to look at the CSV files in the cgi-bin/csv directory and see if that has the right data. In this case, I'd look at players.csv and see if the old and new draftees are showing up in there. In this case, the old draftee's pretty much have to be (OU doesn't cache anything, so what it displays is what's in the CSV files), so you need to figure out why the CSV is wrong. Did you copy to the wrong directory? Did you copy FROM the wrong directory? etc.
__________________
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 04-12-2016, 09:23 AM   #494
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,163
Quote:
Originally Posted by Getch View Post
I replied via PM, but in case anyone is interested. Almost everything you see in OU is directly from the CSV files. I don't cache anything or store anything, everything is read from the CSV's. So if you see players that are wrong, or ratings, etc., most likely that's coming from the CSV files.

So, the first step is to look at the CSV files in the cgi-bin/csv directory and see if that has the right data. In this case, I'd look at players.csv and see if the old and new draftees are showing up in there. In this case, the old draftee's pretty much have to be (OU doesn't cache anything, so what it displays is what's in the CSV files), so you need to figure out why the CSV is wrong. Did you copy to the wrong directory? Did you copy FROM the wrong directory? etc.
Thank you. I do see those old ones in the players.csv, and what I'm thinking I need to do is delete these guys who are listed as "league 0" as they are deleted from the draft pool, but still floating around like ghosts.

I'll give this a try.
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord

Last edited by Mike Lowe; 04-12-2016 at 09:24 AM. Reason: Nevermind, that would delete a bunch of other guys too :/
Mike Lowe is offline   Reply With Quote
Old 04-12-2016, 09:38 AM   #495
Mike Lowe
Hall Of Famer
 
Mike Lowe's Avatar
 
Join Date: Dec 2001
Location: San Diego, CA
Posts: 2,163
Quote:
Originally Posted by Mike Lowe View Post
Thank you. I do see those old ones in the players.csv, and what I'm thinking I need to do is delete these guys who are listed as "league 0" as they are deleted from the draft pool, but still floating around like ghosts.

I'll give this a try.
This might be impossible to fix. There seems to be no way to stop these deleted guys from appearing in the csv file, and there's no way that I can see to differentiate between a guy deleted from the draft and is still showing, to a newly generated draftee.

I had thought by sorting by league ID 144 and then deleting the guys who appear to be showing something different (such as 'deleted' or something like that) would work, but there's no way to differentiate between the two draft classes.

Not sure why OOTP is still reading guys I manually deleted (all 1400+ of them).
__________________
Franchise. Sliders.
@MikeLowe47 | YouTube | Discord
Mike Lowe is offline   Reply With Quote
Old 04-24-2016, 09:59 AM   #496
Getch
All Star Reserve
 
Getch's Avatar
 
Join Date: Jan 2006
Posts: 868
Quote:
Originally Posted by Mike Lowe View Post
Not sure why OOTP is still reading guys I manually deleted (all 1400+ of them).
This might be an OOTP 17 bug? Deleted players should be deleted, and removed from CSV files.
__________________
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-04-2016, 09:57 PM   #497
soadeathdealer
Hall Of Famer
 
soadeathdealer's Avatar
 
Join Date: Nov 2009
Location: VA
Posts: 2,144
@Getch

for scouting league using 20-80 ratings what ratings csv is to be uploaded ? I have a client that im helping out . on his draft page it doesnt show any ratings for his players at all .

thanks in advance
__________________
Jerseys and caps/logos and more
http://s39.photobucket.com/albums/e1...%20and%20caps/


Leagues

OOTP

POTD: Vermont/Co-Commish
MTBL: League Closed
The Show: Jacksonville Bombers
RFTP : Braves/co-commish: League Closed
HRBL: Commish: League Closed

DDSPF

WWPF- Miami

CSFL- Tampa

USFL: New Orleans

DDSCF

SNCFL: Florida/ JMU
soadeathdealer is offline   Reply With Quote
Old 05-05-2016, 11:52 AM   #498
hjrrockies
Minors (Single A)
 
hjrrockies's Avatar
 
Join Date: Mar 2016
Posts: 73
Question about draft-eligibility: Running a modern MLB game, the OOTP:OU draft list includes players that are not listed as draft-eligible in-game. Is there a way to fix this? Should the commissioner use the draft_eligible_players.csv file rather than the draft.csv?
hjrrockies is offline   Reply With Quote
Old 05-05-2016, 02:20 PM   #499
Painmantle
Hall Of Famer
 
Painmantle's Avatar
 
Join Date: Apr 2006
Location: Greenfield ,IN
Posts: 3,053
Quote:
Originally Posted by hjrrockies View Post
Question about draft-eligibility: Running a modern MLB game, the OOTP:OU draft list includes players that are not listed as draft-eligible in-game. Is there a way to fix this? Should the commissioner use the draft_eligible_players.csv file rather than the draft.csv?
Draft.csv is nothing more than the order and picks, it contains no information about players. Did you upload new reports/files and upload new .csv files after getting to the draft? The draft_eligible_players.csv should contain the correct players, but the utilities should pick all the players up on it's own if you have properly updated all the files on the server
__________________
“As soon as I got out there I felt a strange relationship with the pitcher's mound. It was as if I'd been born out there. Pitching just felt like the most natural thing in the world. Striking out batters was easy.” -Babe Ruth
“Ruth made a grave mistake when he gave up pitching. Working once a week, he might have lasted a long time and become a great star.”-Tris Speaker
My Dynasties
The Beantown Bambino

Last edited by Painmantle; 05-05-2016 at 02:21 PM.
Painmantle is offline   Reply With Quote
Old 05-05-2016, 04:58 PM   #500
hjrrockies
Minors (Single A)
 
hjrrockies's Avatar
 
Join Date: Mar 2016
Posts: 73
Quote:
Originally Posted by Painmantle View Post
Draft.csv is nothing more than the order and picks, it contains no information about players. Did you upload new reports/files and upload new .csv files after getting to the draft? The draft_eligible_players.csv should contain the correct players, but the utilities should pick all the players up on it's own if you have properly updated all the files on the server
I am not the commish of the league, just trying to do some research to help him out. Not sure if he did all those things. I'll forward this to him though.

Thanks!
hjrrockies 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 08:19 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 - 2025, vBulletin Solutions, Inc.
Copyright © 2024 Out of the Park Developments