|
||||
|
07-24-2011, 02:57 PM | #21 |
Minors (Single A)
Join Date: Apr 2010
Posts: 71
|
anyone having much luck? I can't even get my images to show correctly or my export
|
07-24-2011, 03:43 PM | #22 | ||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,584
|
Quote:
Quote:
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
||
07-24-2011, 03:54 PM | #23 | |||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,584
|
Quote:
Quote:
Quote:
1. Log in as one of your GM's. 2. Go to the team's draft warroom, and add a player to their draft list. 3. Save the draft list. 4. Remove the player from the draft list, and save again. 5. Go to the draft admin page, and click the generate auto draft list button. 6. Try drafting the players manually.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
|||
07-24-2011, 07:19 PM | #24 |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
Contract Extensions and Game Batting tables are not loading.
Giving: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 |
07-25-2011, 01:28 AM | #25 |
Minors (Single A)
Join Date: Apr 2011
Posts: 73
|
Thanks fhomess. The steps to get the player drafted worked. Question.....what do I put in the Email List in the Email Settings for the draft ultity. It doesn't look like I can put in everyone's email.
|
07-25-2011, 01:20 PM | #26 |
Hall Of Famer
Join Date: Jan 2003
Location: Indianapolis
Posts: 2,431
|
Thanks. Have we reported this yet to Andreas on the Project manager? if not, I can.
__________________
Web Design and Digital Marketing Agency - Sharp Guys Web Design - Twitter: @sharpguysweb Last edited by cody8200; 07-27-2011 at 06:31 PM. |
07-25-2011, 02:42 PM | #27 | ||
Hall Of Famer
Join Date: Nov 2002
Posts: 3,584
|
Quote:
Quote:
I haven't as I have been fairly busy with life stuff lately. Please go ahead and submit it.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
||
07-25-2011, 06:00 PM | #28 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
The way I got around this was to edit the database settings for that particular field type to be 500 characters rather than 255. Do you have phpMyAdmin set up?
|
07-25-2011, 07:15 PM | #29 | |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
Quote:
Players Game Batting: Code:
DROP TABLE IF EXISTS `players_game_batting`; CREATE TABLE IF NOT EXISTS `players_game_batting` (`player_id` INT, `year` SMALLINT, `team_id` INT, `game_id` INT, `league_id` INT, `level_id` SMALLINT, `split_id` SMALLINT, `position` SMALLINT, `ab` SMALLINT, `h` SMALLINT, `k` SMALLINT, `pa` SMALLINT, `pitches_seen` SMALLINT, `g` SMALLINT, `gs` SMALLINT, `d` SMALLINT, `t` SMALLINT, `hr` SMALLINT, `r` SMALLINT, `rbi` SMALLINT, `sb` SMALLINT, `cs` SMALLINT, `bb` SMALLINT, `ibb` SMALLINT, `gdp` SMALLINT, `sh` SMALLINT, `sf` SMALLINT, `hp` SMALLINT, `ci` SMALLINT, `vorp` DOUBLE); insert into `players_game_batting` VALUES (13, 2011, 32, 2433, 10, 2, 0, 2, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0000); insert into `players_game_batting` VALUES (13, 2011, 32, 2489, 10, 2, 0, 2, 3, 0, 1, 3, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0.0000); Player Contract Extensions: Code:
DROP TABLE IF EXISTS `players_contract_extension`; CREATE TABLE IF NOT EXISTS `players_contract_extension` (`player_id` INT, `team_id` INT, `league_id` INT, `is_major` TINYINT, `no_trade` TINYINT, `last_year_team_option` TINYINT, `last_year_player_option` TINYINT, `contract_team_id` INT, `contract_league_id` INT, `season_year` INT, `salary0` INT, `salary1` INT, `salary2` INT, `salary3` INT, `salary4` INT, `salary5` INT, `salary6` INT, `salary7` INT, `salary8` INT, `salary9` INT, `years` SMALLINT, `current_year` SMALLINT, `minimum_pa` SMALLINT, `minimum_pa_bonus` INT, `minimum_ip` SMALLINT, `minimum_ip_bonus` INT, `mvp_bonus` INT, `cyyoung_bonus` INT, PRIMARY KEY (`player_id`)); insert into `players_contract_extension` VALUES (1, 0, 0, 1, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); insert into `players_contract_extension` VALUES (2, 0, 0, 1, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0); |
|
07-25-2011, 09:39 PM | #30 |
Major Leagues
|
How big are your files? I'm dealing with some significant issues with huge file sizes I think and getting a lot of server timeouts so I'm curious if something about my league is causing this.
My player_career files are around 20MB each. My game files as big as 35MB. The rest are smaller, but many still into the MB. Has anyone else experienced similar issues? |
07-26-2011, 05:27 AM | #31 |
Administrator
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,992
|
The inf, ind and nan codes are exception codes:
IEEE floating point exceptions: NaNs, 1.#INF, 1.#IND, etc I hope I got rid of them now. Please let me know it future builds of OOTP still produce these codes. Thanks! |
07-26-2011, 08:23 AM | #32 | |
Hall Of Famer
Join Date: Dec 2001
Location: Union City, TN
Posts: 6,383
|
Quote:
|
|
07-26-2011, 08:49 AM | #33 |
Administrator
Join Date: Jun 2002
Location: Hollern/Stade/Germany
Posts: 8,992
|
You could use a text editor and let it replace all findings with zero. For example replace "1.#INF" with "0".
|
07-26-2011, 11:26 AM | #34 |
Minors (Single A)
Join Date: Apr 2010
Posts: 71
|
had to reboot league and now managers are all switched around under different profiles. Im commish, but have to login in as a different manager and no admin powers. Any way to reset?
|
07-26-2011, 01:20 PM | #35 | |
Hall Of Famer
Join Date: Nov 2002
Posts: 3,584
|
Quote:
At the moment, I can't figure out why your two tables aren't loading properly. The code you posted works fine for me when I try to execute those SQL statements in my DB. PM sent.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues Baseball Cards - Full list of known templates and documentation on card development. |
|
07-26-2011, 05:09 PM | #36 | |
Major Leagues
Join Date: Jan 2011
Posts: 332
|
While updating the player development, I get this error
Quote:
|
|
07-27-2011, 11:59 AM | #37 |
All Star Reserve
Join Date: Jun 2003
Location: Gurnee, IL
Posts: 601
|
Are you trying to update all player development at once or league by league? If you're not doing league by league, go to Dev>Admin and then click the individual leagues. I always get a timeout of FAs, but everything else updates.
|
07-27-2011, 01:00 PM | #38 |
Major Leagues
Join Date: Jan 2011
Posts: 332
|
I'll give it a shot, thanks
|
07-27-2011, 11:09 PM | #39 |
Major Leagues
Join Date: Jan 2011
Posts: 332
|
No didn't work
|
07-28-2011, 01:45 AM | #40 |
Minors (Rookie Ball)
Join Date: Jul 2011
Posts: 27
|
|
Bookmarks |
Thread Tools | |
|
|