Minors (Double A)
Join Date: Sep 2012
Posts: 187
|
Invalid SQL/CSV export for league_history_pitching/batting_stats in MLB Quick Start
Created an MLB Quick Start for 2020 in the latest OOTP21 patch release. Dump the CSV file league_history_pitching_stats and/or league_history_batting_stats, and before any games are played in 2019, all of the entries for the first 6 columns including the league_id and year are filled with 0's.
Example:
year,team_id,game_id,league_id,level_id,split_id,a b,ip,bf,tb,ha,k,rs,bb,r,er,gb,fb,pi,ipf,g,gs,w,l,s ,sa,da,sh,sf,ta,hra,bk,ci,iw,wp,hp,gf,dp,qs,svo,bs ,ra,ir,irs,cg,sho,sb,cs,hld,r9,avg,obp,slg,ops,h9, k9,kp,bbp,kbbp,hr9,bb9,cgp,fip,qsp,winp,rsg,svp,bs vp,irsp,gfp,era,pig,ws,whip,gbfbp,kbb,babip,wpa,ra 9war
0,0,0,0,0,0,4596,1061,4789,1479,1413,86,0,193,1213 ,499,0,0,0,0,128,0,0,0,3,0,0,0,0,0,22,0,0,0,0,0,0, 0,0,0,0,0,0,0,104,1,0,0,0,13.6230,0.3074,0.3354,0. 3218,0.6572,11.9859,0.7295,1.7958,4.0301,NULL,0.18 66,1.6371,0.0000,0.0000,0.0000,0.0000,0.0000,1.000 0,0.0000,0.0000,0.0000,4.2328,0.0000,NULL,1.5137,0 .0000,0.4456,0.3099,0.0000,NULL
0,0,0,0,0,0,5255,1189,5455,1763,1688,89,0,200,1446 ,556,0,0,0,0,160,0,0,0,1,0,0,0,0,0,25,0,0,0,0,0,0, 0,0,0,0,0,0,0,127,3,0,0,0,14.2910,0.3212,0.3461,0. 3355,0.6816,12.7771,0.6737,1.6315,3.6664,NULL,0.18 92,1.5139,0.0000,0.0000,0.0000,0.0000,0.0000,1.000 0,0.0000,0.0000,0.0000,4.2086,0.0000,NULL,1.5879,0 .0000,0.4450,0.3235,0.0000,NULL
0,0,0,0,0,0,6048,1386,6154,1935,1890,0,0,106,1392, 557,0,0,0,0,300,0,0,0,1,0,0,0,0,0,15,0,0,0,0,0,0,0 ,0,0,0,0,0,0,140,4,0,0,0,12.9610,0.3125,0.3243,0.3 199,0.6443,12.2727,0.0000,0.0000,1.7225,NULL,0.097 4,0.6883,0.0000,0.0000,0.0000,0.0000,0.0000,1.0000 ,0.0000,0.0000,0.0000,3.6169,0.0000,NULL,1.4401,0. 0000,0.0000,0.3108,0.0000,NULL
league_history_fielding_stats looks ok, it has proper data in the year and league_id column.
It was also broken in the previous patch release, tested before upgrading to 21.4.63. Not sure if it's been broken on all OOTP21 releases or not.
The same bad data is dumped for both CSV and SQL.
__________________
StatsPlus - Desktop tool for OOTP real-time sim integration with Slack (Windows, Mac, and Linux)
USBA - OOTP online promotion/relegation league
|