private PlayerStatistics GetPlayerStatistics(string playerContent) { PlayerStatistics player = new PlayerStatistics(); player.accurate_back_zone_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_BACK_ZONE_PASS)); player.accurate_chipped_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_CHIPPED_PASS)); player.accurate_corners_intobox = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_CORNERS_INTOBOX)); player.accurate_cross = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_CROSS)); player.accurate_cross_nocorner = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_CROSS_NOCORNER)); player.accurate_flick_on = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_FLICK_ON)); player.accurate_freekick_cross = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_FREEKICK_CROSS)); player.accurate_fwd_zone_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_FWD_ZONE_PASS)); player.accurate_goal_kicks = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_GOAL_KICKS)); player.accurate_keeper_sweeper = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_KEEPER_SWEEPER)); player.accurate_keeper_throws = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_KEEPER_THROWS)); player.accurate_launches = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_LAUNCHES)); player.accurate_layoffs = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_LAYOFFS)); player.accurate_long_balls = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_LONG_BALLS)); player.accurate_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_PASS)); player.accurate_through_ball = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_THROUGH_BALL)); player.accurate_throws = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ACCURATE_THROWS)); player.aerial_lost = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.AERIAL_LOST)); player.aerial_won = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.AERIAL_WON)); player.assist_penalty_won = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ASSIST_PENALTY_WON)); player.att_assist_openplay = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_ASSIST_OPENPLAY)); player.att_assist_setplay = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_ASSIST_SETPLAY)); player.att_bx_centre = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_BX_CENTRE)); player.att_bx_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_BX_LEFT)); player.att_bx_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_BX_RIGHT)); player.att_cmiss_high = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_CMISS_HIGH)); player.att_cmiss_high_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_CMISS_HIGH_RIGHT)); player.att_cmiss_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_CMISS_LEFT)); player.att_cmiss_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_CMISS_RIGHT)); player.att_fastbreak = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_FASTBREAK)); player.att_freekick_goal = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_FREEKICK_GOAL)); player.att_freekick_miss = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_FREEKICK_MISS)); player.att_freekick_post = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_FREEKICK_POST)); player.att_freekick_target = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_FREEKICK_TARGET)); player.att_freekick_total = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_FREEKICK_TOTAL)); player.att_goal_high_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_GOAL_HIGH_LEFT)); player.att_goal_high_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_GOAL_HIGH_RIGHT)); player.att_goal_low_centre = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_GOAL_LOW_CENTRE)); player.att_goal_low_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_GOAL_LOW_LEFT)); player.att_goal_low_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_GOAL_LOW_RIGHT)); player.att_hd_goal = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_HD_GOAL)); player.att_hd_miss = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_HD_MISS)); player.att_hd_post = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_HD_POST)); player.att_hd_target = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_HD_TARGET)); player.att_hd_total = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_HD_TOTAL)); player.att_ibox_blocked = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_IBOX_BLOCKED)); player.att_ibox_goal = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_IBOX_GOAL)); player.att_ibox_miss = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_IBOX_MISS)); player.att_ibox_post = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_IBOX_POST)); player.att_ibox_target = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_IBOX_TARGET)); player.att_lf_goal = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_LF_GOAL)); player.att_lf_target = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_LF_TARGET)); player.att_lf_total = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_LF_TOTAL)); player.att_lg_centre = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_LG_CENTRE)); player.att_miss_high = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_MISS_HIGH)); player.att_miss_high_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_MISS_HIGH_LEFT)); player.att_miss_high_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_MISS_HIGH_RIGHT)); player.att_miss_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_MISS_LEFT)); player.att_miss_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_MISS_RIGHT)); player.att_obox_blocked = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_OBOX_BLOCKED)); player.att_obox_goal = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_OBOX_GOAL)); player.att_obox_miss = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_OBOX_MISS)); player.att_obox_post = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_OBOX_POST)); player.att_obox_target = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_OBOX_TARGET)); player.att_obx_centre = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_OBX_CENTRE)); player.att_obx_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_OBX_LEFT)); player.att_obxd_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_OBXD_RIGHT)); player.att_one_on_one = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_ONE_ON_ONE)); player.att_openplay = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_OPENPLAY)); player.att_pen_goal = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_PEN_GOAL)); player.att_pen_target = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_PEN_TARGET)); player.att_post_high = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_POST_HIGH)); player.att_post_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_POST_RIGHT)); player.att_rf_goal = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_RF_GOAL)); player.att_rf_target = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_RF_TARGET)); player.att_rf_total = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_RF_TOTAL)); player.att_setpiece = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_SETPIECE)); player.att_sv_high_centre = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_SV_HIGH_CENTRE)); player.att_sv_high_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_SV_HIGH_LEFT)); player.att_sv_high_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_SV_HIGH_RIGHT)); player.att_sv_low_centre = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_SV_LOW_CENTRE)); player.att_sv_low_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_SV_LOW_LEFT)); player.att_sv_low_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATT_SV_LOW_RIGHT)); player.attempted_tackle_foul = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATTEMPTED_TACKLE_FOUL)); player.attempts_conceded_ibox = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATTEMPTS_CONCEDED_IBOX)); player.attempts_conceded_obox = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ATTEMPTS_CONCEDED_OBOX)); player.backward_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.BACKWARD_PASS)); player.ball_recovery = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.BALL_RECOVERY)); player.big_chance_created = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.BIG_CHANCE_CREATED)); player.big_chance_missed = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.BIG_CHANCE_MISSED)); player.big_chance_scored = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.BIG_CHANCE_SCORED)); player.blocked_cross = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.BLOCKED_CROSS)); player.blocked_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.BLOCKED_PASS)); player.blocked_scoring_att = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.BLOCKED_SCORING_ATT)); player.challenge_lost = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CHALLENGE_LOST)); player.clean_sheet_amc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_AMC)); player.clean_sheet_amr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_AMR)); player.clean_sheet_dc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_DC)); player.clean_sheet_dl = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_DL)); player.clean_sheet_dmc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_DMC)); player.clean_sheet_dml = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_DML)); player.clean_sheet_dmr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_DMR)); player.clean_sheet_dr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_DR)); player.clean_sheet_fw = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_FW)); player.clean_sheet_gk = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEAN_SHEET_GK)); player.clearance_off_line = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CLEARANCE_OFF_LINE)); player.corner_taken = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CORNER_TAKEN)); player.cross_inaccurate = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CROSS_INACCURATE)); player.crosses_18yard = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CROSSES_18YARD)); player.crosses_18yardplus = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.CROSSES_18YARDPLUS)); player.dangerous_play = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DANGEROUS_PLAY)); player.dispossessed = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DISPOSSESSED)); player.dive_catch = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DIVE_CATCH)); player.dive_save = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DIVE_SAVE)); player.diving_save = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DIVING_SAVE)); player.dribble_lost = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DRIBBLE_LOST)); player.duel_ground_lost = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DUEL_GROUND_LOST)); player.duel_ground_won = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DUEL_GROUND_WON)); player.duel_lost = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DUEL_LOST)); player.duel_won = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.DUEL_WON)); player.effective_blocked_cross = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.EFFECTIVE_BLOCKED_CROSS)); player.effective_clearance = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.EFFECTIVE_CLEARANCE)); player.effective_head_clearance = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.EFFECTIVE_HEAD_CLEARANCE)); player.error_lead_to_goal = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ERROR_LEAD_TO_GOAL)); player.error_lead_to_shot = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ERROR_LEAD_TO_SHOT)); player.failed_to_block = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.FAILED_TO_BLOCK)); player.fifty_fifty = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.FIFTY_FIFTY)); player.final_third_entries = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.FINAL_THIRD_ENTRIES)); player.formation_place = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.FORMATION_PLACE)); player.fouled_final_third = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.FOULED_FINAL_THIRD)); player.fouls = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.FOULS)); player.freekick_cross = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.FREEKICK_CROSS)); player.fwd_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.FWD_PASS)); player.game_started = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GAME_STARTED)); player.gk_smother = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GK_SMOTHER)); player.goal_assist = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_ASSIST)); player.goal_assist_intentional = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_ASSIST_INTENTIONAL)); player.goal_assist_openplay = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_ASSIST_OPENPLAY)); player.goal_assist_setplay = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_ASSIST_SETPLAY)); player.goal_fastbreak = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_FASTBREAK)); player.goal_kicks = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_KICKS)); player.goal_normal = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_NORMAL)); player.goal_scored_by_team_amc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_AMC)); player.goal_scored_by_team_aml = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_AML)); player.goal_scored_by_team_amr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_AMR)); player.goal_scored_by_team_dc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_DC)); player.goal_scored_by_team_dl = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_DL)); player.goal_scored_by_team_dmc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_DMC)); player.goal_scored_by_team_dml = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_DML)); player.goal_scored_by_team_dmr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_DMR)); player.goal_scored_by_team_dr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_DR)); player.goal_scored_by_team_fw = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_FW)); player.goal_scored_by_team_fwl = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_FWL)); player.goal_scored_by_team_fwr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_FWR)); player.goal_scored_by_team_gk = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_GK)); player.goal_scored_by_team_mc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_MC)); player.goal_scored_by_team_ml = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_ML)); player.goal_scored_by_team_mr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_MR)); player.goal_scored_by_team_sub = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOAL_SCORED_BY_TEAM_SUB)); player.goals = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS)); player.goals_conceded_amc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_AMC)); player.goals_conceded_aml = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_AML)); player.goals_conceded_amr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_AMR)); player.goals_conceded_dc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_DC)); player.goals_conceded_dl = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_DL)); player.goals_conceded_dmc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_DMC)); player.goals_conceded_dr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_DR)); player.goals_conceded_fw = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_FW)); player.goals_conceded_fwl = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_FWL)); player.goals_conceded_fwr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_FWR)); player.goals_conceded_gk = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_GK)); player.goals_conceded_ibox = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_IBOX)); player.goals_conceded_mc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_MC)); player.goals_conceded_ml = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_ML)); player.goals_conceded_mr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_MR)); player.goals_conceded_obox_amc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_AMC)); player.goals_conceded_obox_aml = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_AML)); player.goals_conceded_obox_amr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_AMR)); player.goals_conceded_obox_dc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_DC)); player.goals_conceded_obox_dl = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_DL)); player.goals_conceded_obox_dmc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_DMC)); player.goals_conceded_obox_dr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_DR)); player.goals_conceded_obox_fw = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_FW)); player.goals_conceded_obox_gk = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_GK)); player.goals_conceded_obox_mc = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_MC)); player.goals_conceded_obox_ml = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_ML)); player.goals_conceded_obox_mr = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_MR)); player.goals_conceded_obox_sub = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_OBOX_SUB)); player.goals_conceded_sub = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_CONCEDED_SUB)); player.goals_openplay = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOALS_OPENPLAY)); player.good_high_claim = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.GOOD_HIGH_CLAIM)); player.hand_ball = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.HAND_BALL)); player.head_clearance = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.HEAD_CLEARANCE)); player.head_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.HEAD_PASS)); player.hit_woodwork = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.HIT_WOODWORK)); player.interception = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.INTERCEPTION)); player.interception_won = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.INTERCEPTION_WON)); player.interceptions_in_box = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.INTERCEPTIONS_IN_BOX)); player.keeper_claim_high_lost = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.KEEPER_CLAIM_HIGH_LOST)); player.keeper_claim_lost = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.KEEPER_CLAIM_LOST)); player.keeper_pick_up = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.KEEPER_PICK_UP)); player.keeper_sweeper_lost = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.KEEPER_SWEEPER_LOST)); player.keeper_throws = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.KEEPER_THROWS)); player.last_man_tackle = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.LAST_MAN_TACKLE)); player.leftside_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.LEFTSIDE_PASS)); player.long_pass_own_to_opp = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.LONG_PASS_OWN_TO_OPP)); player.long_pass_own_to_opp_success = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.LONG_PASS_OWN_TO_OPP_SUCCESS)); player.lost_corners = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.LOST_CORNERS)); player.man_of_the_match = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.MAN_OF_THE_MATCH)); player.mins_played = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.MINS_PLAYED)); player.offside_provoked = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.OFFSIDE_PROVOKED)); player.offtarget_att_assist = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.OFFTARGET_ATT_ASSIST)); player.ontarget_att_assist = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ONTARGET_ATT_ASSIST)); player.ontarget_scoring_att = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.ONTARGET_SCORING_ATT)); player.open_play_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.OPEN_PLAY_PASS)); player.outfielder_block = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.OUTFIELDER_BLOCK)); player.overrun = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.OVERRUN)); player.pass_backzone_inaccurate = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PASS_BACKZONE_INACCURATE)); player.pass_forwardzone_inaccurate = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PASS_FORWARDZONE_INACCURATE)); player.pass_inaccurate = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PASS_INACCURATE)); player.pass_longball_inaccurate = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PASS_LONGBALL_INACCURATE)); player.pass_throughball_inacurate = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PASS_THROUGHBALL_INACURATE)); player.passes_left = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PASSES_LEFT)); player.passes_right = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PASSES_RIGHT)); player.pen_area_entries = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PEN_AREA_ENTRIES)); player.pen_goals_conceded = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PEN_GOALS_CONCEDED)); player.penalty_conceded = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_CONCEDED)); player.penalty_faced = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_FACED)); player.penalty_missed = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_MISSED)); player.penalty_save = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_SAVE)); player.penalty_shootout_conceded_gk = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_SHOOTOUT_CONCEDED_GK)); player.penalty_shootout_missed_off_target = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_SHOOTOUT_MISSED_OFF_TARGET)); player.penalty_shootout_saved = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_SHOOTOUT_SAVED)); player.penalty_shootout_saved_gk = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_SHOOTOUT_SAVED_GK)); player.penalty_shootout_scored = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_SHOOTOUT_SCORED)); player.penalty_won = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PENALTY_WON)); player.position = GetStatistics(playerContent, PlayerStatisticsFilter.POSITION).Replace("'", ""); player.poss_lost_all = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.POSS_LOST_ALL)); player.poss_lost_ctrl = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.POSS_LOST_CTRL)); player.poss_won_att_3rd = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.POSS_WON_ATT_3RD)); player.poss_won_def_3rd = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.POSS_WON_DEF_3RD)); player.poss_won_mid_3rd = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.POSS_WON_MID_3RD)); player.post_scoring_att = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.POST_SCORING_ATT)); player.punches = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PUNCHES)); player.put_through = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.PUT_THROUGH)); player.rating = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.RATING)); player.rating_defensive = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.RATING_DEFENSIVE)); player.rating_defensive_points = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.RATING_DEFENSIVE_POINTS)); player.rating_offensive = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.RATING_OFFENSIVE)); player.rating_offensive_points = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.RATING_OFFENSIVE_POINTS)); player.rating_points = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.RATING_POINTS)); player.red_card = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.RED_CARD)); player.rightside_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.RIGHTSIDE_PASS)); player.saved_ibox = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SAVED_IBOX)); player.saved_obox = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SAVED_OBOX)); player.saves = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SAVES)); player.second_goal_assist = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SECOND_GOAL_ASSIST)); player.second_yellow = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SECOND_YELLOW)); player.shield_ball_oop = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SHIELD_BALL_OOP)); player.shot_fastbreak = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SHOT_FASTBREAK)); player.shot_off_target = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SHOT_OFF_TARGET)); player.six_yard_block = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SIX_YARD_BLOCK)); player.stand_catch = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.STAND_CATCH)); player.successful_fifty_fifty = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SUCCESSFUL_FIFTY_FIFTY)); player.successful_final_third_passes = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SUCCESSFUL_FINAL_THIRD_PASSES)); player.successful_open_play_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SUCCESSFUL_OPEN_PLAY_PASS)); player.successful_put_through = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.SUCCESSFUL_PUT_THROUGH)); player.tackle_lost = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TACKLE_LOST)); player.total_att_assist = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_ATT_ASSIST)); player.total_back_zone_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_BACK_ZONE_PASS)); player.total_chipped_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_CHIPPED_PASS)); player.total_clearance = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_CLEARANCE)); player.total_contest = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_CONTEST)); player.total_corners_intobox = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_CORNERS_INTOBOX)); player.total_cross = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_CROSS)); player.total_cross_nocorner = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_CROSS_NOCORNER)); player.total_fastbreak = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_FASTBREAK)); player.total_final_third_passes = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_FINAL_THIRD_PASSES)); player.total_flick_on = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_FLICK_ON)); player.total_fwd_zone_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_FWD_ZONE_PASS)); player.total_high_claim = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_HIGH_CLAIM)); player.total_keeper_sweeper = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_KEEPER_SWEEPER)); player.total_launches = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_LAUNCHES)); player.total_layoffs = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_LAYOFFS)); player.total_long_balls = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_LONG_BALLS)); player.total_offside = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_OFFSIDE)); player.total_pass = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_PASS)); player.total_pull_back = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_PULL_BACK)); player.total_scoring_att = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_SCORING_ATT)); player.total_sub_off = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_SUB_OFF)); player.total_sub_on = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_SUB_ON)); player.total_tackle = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_TACKLE)); player.total_through_ball = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_THROUGH_BALL)); player.total_throws = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOTAL_THROWS)); player.touches = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TOUCHES)); player.turnover = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.TURNOVER)); player.unsuccessful_touch = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.UNSUCCESSFUL_TOUCH)); player.was_fouled = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.WAS_FOULED)); player.won_contest = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.WON_CONTEST)); player.won_corners = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.WON_CORNERS)); player.won_tackle = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.WON_TACKLE)); player.yellow_card = float.Parse(GetStatistics(playerContent, PlayerStatisticsFilter.YELLOW_CARD)); return player; }
private static void InsertPlayerStatistics(PlayerStatistics player, int teamID, string teamName, string league, int matchID, bool home) { string playerStatisticsSQL = @"INSERT INTO PlayerStatistics (player_id, player_name, team_id, team_name, league, match_id, home, accurate_back_zone_pass, accurate_chipped_pass, accurate_corners_intobox, accurate_cross, accurate_cross_nocorner, accurate_flick_on, accurate_freekick_cross, accurate_fwd_zone_pass, accurate_goal_kicks, accurate_keeper_sweeper, accurate_keeper_throws, accurate_launches, accurate_layoffs, accurate_long_balls, accurate_pass, accurate_through_ball, accurate_throws, aerial_lost, aerial_won, assist_penalty_won, att_assist_openplay, att_assist_setplay, att_bx_centre, att_bx_left, att_bx_right, att_cmiss_high, att_cmiss_high_right, att_cmiss_left, att_cmiss_right, att_fastbreak, att_freekick_goal, att_freekick_miss, att_freekick_post, att_freekick_target, att_freekick_total, att_goal_high_left, att_goal_high_right, att_goal_low_centre, att_goal_low_left, att_goal_low_right, att_hd_goal, att_hd_miss, att_hd_post, att_hd_target, att_hd_total, att_ibox_blocked, att_ibox_goal, att_ibox_miss, att_ibox_post, att_ibox_target, att_lf_goal, att_lf_target, att_lf_total, att_lg_centre, att_miss_high, att_miss_high_left, att_miss_high_right, att_miss_left, att_miss_right, att_obox_blocked, att_obox_goal, att_obox_miss, att_obox_post, att_obox_target, att_obx_centre, att_obx_left, att_obxd_right, att_one_on_one, att_openplay, att_pen_goal, att_pen_target, att_post_high, att_post_right, att_rf_goal, att_rf_target, att_rf_total, att_setpiece, att_sv_high_centre, att_sv_high_left, att_sv_high_right, att_sv_low_centre, att_sv_low_left, att_sv_low_right, attempted_tackle_foul, attempts_conceded_ibox, attempts_conceded_obox, backward_pass, ball_recovery, big_chance_created, big_chance_missed, big_chance_scored, blocked_cross, blocked_pass, blocked_scoring_att, challenge_lost, clean_sheet_amc, clean_sheet_amr, clean_sheet_dc, clean_sheet_dl, clean_sheet_dmc, clean_sheet_dml, clean_sheet_dmr, clean_sheet_dr, clean_sheet_fw, clean_sheet_gk, clearance_off_line, corner_taken, cross_inaccurate, crosses_18yard, crosses_18yardplus, dangerous_play, dispossessed, dive_catch, dive_save, diving_save, dribble_lost, duel_ground_lost, duel_ground_won, duel_lost, duel_won, effective_blocked_cross, effective_clearance, effective_head_clearance, error_lead_to_goal, error_lead_to_shot, failed_to_block, fifty_fifty, final_third_entries, formation_place, fouled_final_third, fouls, freekick_cross, fwd_pass, game_started, gk_smother, goal_assist, goal_assist_intentional, goal_assist_openplay, goal_assist_setplay, goal_fastbreak, goal_kicks, goal_normal, goal_scored_by_team_amc, goal_scored_by_team_aml, goal_scored_by_team_amr, goal_scored_by_team_dc, goal_scored_by_team_dl, goal_scored_by_team_dmc, goal_scored_by_team_dml, goal_scored_by_team_dmr, goal_scored_by_team_dr, goal_scored_by_team_fw, goal_scored_by_team_fwl, goal_scored_by_team_fwr, goal_scored_by_team_gk, goal_scored_by_team_mc, goal_scored_by_team_ml, goal_scored_by_team_mr, goal_scored_by_team_sub, goals, goals_conceded_amc, goals_conceded_aml, goals_conceded_amr, goals_conceded_dc, goals_conceded_dl, goals_conceded_dmc, goals_conceded_dr, goals_conceded_fw, goals_conceded_fwl, goals_conceded_fwr, goals_conceded_gk, goals_conceded_ibox, goals_conceded_mc, goals_conceded_ml, goals_conceded_mr, goals_conceded_obox_amc, goals_conceded_obox_aml, goals_conceded_obox_amr, goals_conceded_obox_dc, goals_conceded_obox_dl, goals_conceded_obox_dmc, goals_conceded_obox_dr, goals_conceded_obox_fw, goals_conceded_obox_gk, goals_conceded_obox_mc, goals_conceded_obox_ml, goals_conceded_obox_mr, goals_conceded_obox_sub, goals_conceded_sub, goals_openplay, good_high_claim, hand_ball, head_clearance, head_pass, hit_woodwork, interception, interception_won, interceptions_in_box, keeper_claim_high_lost, keeper_claim_lost, keeper_pick_up, keeper_sweeper_lost, keeper_throws, last_man_tackle, leftside_pass, long_pass_own_to_opp, long_pass_own_to_opp_success, lost_corners, man_of_the_match, mins_played, offside_provoked, offtarget_att_assist, ontarget_att_assist, ontarget_scoring_att, open_play_pass, outfielder_block, overrun, pass_backzone_inaccurate, pass_forwardzone_inaccurate, pass_inaccurate, pass_longball_inaccurate, pass_throughball_inacurate, passes_left, passes_right, pen_area_entries, pen_goals_conceded, penalty_conceded, penalty_faced, penalty_missed, penalty_save, penalty_shootout_conceded_gk, penalty_shootout_missed_off_target, penalty_shootout_saved, penalty_shootout_saved_gk, penalty_shootout_scored, penalty_won, position, poss_lost_all, poss_lost_ctrl, poss_won_att_3rd, poss_won_def_3rd, poss_won_mid_3rd, post_scoring_att, punches, put_through, rating, rating_defensive, rating_defensive_points, rating_offensive, rating_offensive_points, rating_points, red_card, rightside_pass, saved_ibox, saved_obox, saves, second_goal_assist, second_yellow, shield_ball_oop, shot_fastbreak, shot_off_target, six_yard_block, stand_catch, successful_fifty_fifty, successful_final_third_passes, successful_open_play_pass, successful_put_through, tackle_lost, total_att_assist, total_back_zone_pass, total_chipped_pass, total_clearance, total_contest, total_corners_intobox, total_cross, total_cross_nocorner, total_fastbreak, total_final_third_passes, total_flick_on, total_fwd_zone_pass, total_high_claim, total_keeper_sweeper, total_launches, total_layoffs, total_long_balls, total_offside, total_pass, total_pull_back, total_scoring_att, total_sub_off, total_sub_on, total_tackle, total_through_ball, total_throws, touches, turnover, unsuccessful_touch, was_fouled, won_contest, won_corners, won_tackle, yellow_card) VALUES (" + player.id + ", '" + player.name + "', " + teamID + ", '" + teamName + "', '" + league + "', " + matchID + ", " + home + ", " + player.accurate_back_zone_pass + ", " + player.accurate_chipped_pass + ", " + player.accurate_corners_intobox + ", " + player.accurate_cross + ", " + player.accurate_cross_nocorner + ", " + player.accurate_flick_on + ", " + player.accurate_freekick_cross + ", " + player.accurate_fwd_zone_pass + ", " + player.accurate_goal_kicks + ", " + player.accurate_keeper_sweeper + ", " + player.accurate_keeper_throws + ", " + player.accurate_launches + ", " + player.accurate_layoffs + ", " + player.accurate_long_balls + ", " + player.accurate_pass + ", " + player.accurate_through_ball + ", " + player.accurate_throws + ", " + player.aerial_lost + ", " + player.aerial_won + ", " + player.assist_penalty_won + ", " + player.att_assist_openplay + ", " + player.att_assist_setplay + ", " + player.att_bx_centre + ", " + player.att_bx_left + ", " + player.att_bx_right + ", " + player.att_cmiss_high + ", " + player.att_cmiss_high_right + ", " + player.att_cmiss_left + ", " + player.att_cmiss_right + ", " + player.att_fastbreak + ", " + player.att_freekick_goal + ", " + player.att_freekick_miss + ", " + player.att_freekick_post + ", " + player.att_freekick_target + ", " + player.att_freekick_total + ", " + player.att_goal_high_left + ", " + player.att_goal_high_right + ", " + player.att_goal_low_centre + ", " + player.att_goal_low_left + ", " + player.att_goal_low_right + ", " + player.att_hd_goal + ", " + player.att_hd_miss + ", " + player.att_hd_post + ", " + player.att_hd_target + ", " + player.att_hd_total + ", " + player.att_ibox_blocked + ", " + player.att_ibox_goal + ", " + player.att_ibox_miss + ", " + player.att_ibox_post + ", " + player.att_ibox_target + ", " + player.att_lf_goal + ", " + player.att_lf_target + ", " + player.att_lf_total + ", " + player.att_lg_centre + ", " + player.att_miss_high + ", " + player.att_miss_high_left + ", " + player.att_miss_high_right + ", " + player.att_miss_left + ", " + player.att_miss_right + ", " + player.att_obox_blocked + ", " + player.att_obox_goal + ", " + player.att_obox_miss + ", " + player.att_obox_post + ", " + player.att_obox_target + ", " + player.att_obx_centre + ", " + player.att_obx_left + ", " + player.att_obxd_right + ", " + player.att_one_on_one + ", " + player.att_openplay + ", " + player.att_pen_goal + ", " + player.att_pen_target + ", " + player.att_post_high + ", " + player.att_post_right + ", " + player.att_rf_goal + ", " + player.att_rf_target + ", " + player.att_rf_total + ", " + player.att_setpiece + ", " + player.att_sv_high_centre + ", " + player.att_sv_high_left + ", " + player.att_sv_high_right + ", " + player.att_sv_low_centre + ", " + player.att_sv_low_left + ", " + player.att_sv_low_right + ", " + player.attempted_tackle_foul + ", " + player.attempts_conceded_ibox + ", " + player.attempts_conceded_obox + ", " + player.backward_pass + ", " + player.ball_recovery + ", " + player.big_chance_created + ", " + player.big_chance_missed + ", " + player.big_chance_scored + ", " + player.blocked_cross + ", " + player.blocked_pass + ", " + player.blocked_scoring_att + ", " + player.challenge_lost + ", " + player.clean_sheet_amc + ", " + player.clean_sheet_amr + ", " + player.clean_sheet_dc + ", " + player.clean_sheet_dl + ", " + player.clean_sheet_dmc + ", " + player.clean_sheet_dml + ", " + player.clean_sheet_dmr + ", " + player.clean_sheet_dr + ", " + player.clean_sheet_fw + ", " + player.clean_sheet_gk + ", " + player.clearance_off_line + ", " + player.corner_taken + ", " + player.cross_inaccurate + ", " + player.crosses_18yard + ", " + player.crosses_18yardplus + ", " + player.dangerous_play + ", " + player.dispossessed + ", " + player.dive_catch + ", " + player.dive_save + ", " + player.diving_save + ", " + player.dribble_lost + ", " + player.duel_ground_lost + ", " + player.duel_ground_won + ", " + player.duel_lost + ", " + player.duel_won + ", " + player.effective_blocked_cross + ", " + player.effective_clearance + ", " + player.effective_head_clearance + ", " + player.error_lead_to_goal + ", " + player.error_lead_to_shot + ", " + player.failed_to_block + ", " + player.fifty_fifty + ", " + player.final_third_entries + ", " + player.formation_place + ", " + player.fouled_final_third + ", " + player.fouls + ", " + player.freekick_cross + ", " + player.fwd_pass + ", " + player.game_started + ", " + player.gk_smother + ", " + player.goal_assist + ", " + player.goal_assist_intentional + ", " + player.goal_assist_openplay + ", " + player.goal_assist_setplay + ", " + player.goal_fastbreak + ", " + player.goal_kicks + ", " + player.goal_normal + ", " + player.goal_scored_by_team_amc + ", " + player.goal_scored_by_team_aml + ", " + player.goal_scored_by_team_amr + ", " + player.goal_scored_by_team_dc + ", " + player.goal_scored_by_team_dl + ", " + player.goal_scored_by_team_dmc + ", " + player.goal_scored_by_team_dml + ", " + player.goal_scored_by_team_dmr + ", " + player.goal_scored_by_team_dr + ", " + player.goal_scored_by_team_fw + ", " + player.goal_scored_by_team_fwl + ", " + player.goal_scored_by_team_fwr + ", " + player.goal_scored_by_team_gk + ", " + player.goal_scored_by_team_mc + ", " + player.goal_scored_by_team_ml + ", " + player.goal_scored_by_team_mr + ", " + player.goal_scored_by_team_sub + ", " + player.goals + ", " + player.goals_conceded_amc + ", " + player.goals_conceded_aml + ", " + player.goals_conceded_amr + ", " + player.goals_conceded_dc + ", " + player.goals_conceded_dl + ", " + player.goals_conceded_dmc + ", " + player.goals_conceded_dr + ", " + player.goals_conceded_fw + ", " + player.goals_conceded_fwl + ", " + player.goals_conceded_fwr + ", " + player.goals_conceded_gk + ", " + player.goals_conceded_ibox + ", " + player.goals_conceded_mc + ", " + player.goals_conceded_ml + ", " + player.goals_conceded_mr + ", " + player.goals_conceded_obox_amc + ", " + player.goals_conceded_obox_aml + ", " + player.goals_conceded_obox_amr + ", " + player.goals_conceded_obox_dc + ", " + player.goals_conceded_obox_dl + ", " + player.goals_conceded_obox_dmc + ", " + player.goals_conceded_obox_dr + ", " + player.goals_conceded_obox_fw + ", " + player.goals_conceded_obox_gk + ", " + player.goals_conceded_obox_mc + ", " + player.goals_conceded_obox_ml + ", " + player.goals_conceded_obox_mr + ", " + player.goals_conceded_obox_sub + ", " + player.goals_conceded_sub + ", " + player.goals_openplay + ", " + player.good_high_claim + ", " + player.hand_ball + ", " + player.head_clearance + ", " + player.head_pass + ", " + player.hit_woodwork + ", " + player.interception + ", " + player.interception_won + ", " + player.interceptions_in_box + ", " + player.keeper_claim_high_lost + ", " + player.keeper_claim_lost + ", " + player.keeper_pick_up + ", " + player.keeper_sweeper_lost + ", " + player.keeper_throws + ", " + player.last_man_tackle + ", " + player.leftside_pass + ", " + player.long_pass_own_to_opp + ", " + player.long_pass_own_to_opp_success + ", " + player.lost_corners + ", " + player.man_of_the_match + ", " + player.mins_played + ", " + player.offside_provoked + ", " + player.offtarget_att_assist + ", " + player.ontarget_att_assist + ", " + player.ontarget_scoring_att + ", " + player.open_play_pass + ", " + player.outfielder_block + ", " + player.overrun + ", " + player.pass_backzone_inaccurate + ", " + player.pass_forwardzone_inaccurate + ", " + player.pass_inaccurate + ", " + player.pass_longball_inaccurate + ", " + player.pass_throughball_inacurate + ", " + player.passes_left + ", " + player.passes_right + ", " + player.pen_area_entries + ", " + player.pen_goals_conceded + ", " + player.penalty_conceded + ", " + player.penalty_faced + ", " + player.penalty_missed + ", " + player.penalty_save + ", " + player.penalty_shootout_conceded_gk + ", " + player.penalty_shootout_missed_off_target + ", " + player.penalty_shootout_saved + ", " + player.penalty_shootout_saved_gk + ", " + player.penalty_shootout_scored + ", " + player.penalty_won + ", '" + player.position + "', " + player.poss_lost_all + ", " + player.poss_lost_ctrl + ", " + player.poss_won_att_3rd + ", " + player.poss_won_def_3rd + ", " + player.poss_won_mid_3rd + ", " + player.post_scoring_att + ", " + player.punches + ", " + player.put_through + ", " + player.rating + ", " + player.rating_defensive + ", " + player.rating_defensive_points + ", " + player.rating_offensive + ", " + player.rating_offensive_points + ", " + player.rating_points + ", " + player.red_card + ", " + player.rightside_pass + ", " + player.saved_ibox + ", " + player.saved_obox + ", " + player.saves + ", " + player.second_goal_assist + ", " + player.second_yellow + ", " + player.shield_ball_oop + ", " + player.shot_fastbreak + ", " + player.shot_off_target + ", " + player.six_yard_block + ", " + player.stand_catch + ", " + player.successful_fifty_fifty + ", " + player.successful_final_third_passes + ", " + player.successful_open_play_pass + ", " + player.successful_put_through + ", " + player.tackle_lost + ", " + player.total_att_assist + ", " + player.total_back_zone_pass + ", " + player.total_chipped_pass + ", " + player.total_clearance + ", " + player.total_contest + ", " + player.total_corners_intobox + ", " + player.total_cross + ", " + player.total_cross_nocorner + ", " + player.total_fastbreak + ", " + player.total_final_third_passes + ", " + player.total_flick_on + ", " + player.total_fwd_zone_pass + ", " + player.total_high_claim + ", " + player.total_keeper_sweeper + ", " + player.total_launches + ", " + player.total_layoffs + ", " + player.total_long_balls + ", " + player.total_offside + ", " + player.total_pass + ", " + player.total_pull_back + ", " + player.total_scoring_att + ", " + player.total_sub_off + ", " + player.total_sub_on + ", " + player.total_tackle + ", " + player.total_through_ball + ", " + player.total_throws + ", " + player.touches + ", " + player.turnover + ", " + player.unsuccessful_touch + ", " + player.was_fouled + ", " + player.won_contest + ", " + player.won_corners + ", " + player.won_tackle + ", " + player.yellow_card + ")"; int ret = MySqlHelper.ExecuteNonQuery(MySqlHelper.Conn, CommandType.Text, playerStatisticsSQL, null); }