@php $script_name = 'gotcpowerratings'; $loop_name = 'DAILY'; $time_start = date('Y-m-d h:i:s.u'); $team_id = 1; $game_id = 1; $game_abv = 'GOTC'; $owner_name = 'Conanthor'; echo ""; //$get_contests = pg_query($db,"SELECT * FROM \"CONTESTS\" WHERE \"CONTEST_ID\" = '94447' ORDER BY \"START_DATE\" DESC") or die(pg_result_error()); //$get_contests = pg_query($db,"SELECT * FROM \"CONTESTS\" WHERE \"START_DATE\" > '2018-04-28' ORDER BY \"START_DATE\" DESC") or die(pg_result_error()); $get_roster = pg_query($db_iadg,"SELECT * FROM \"rosters\" WHERE \"game_abv\" = '$game_abv'") or die(pg_result_error()); //$get_roster = pg_query($db_iadg,"SELECT * FROM \"rosters\" WHERE \"rosters\"") or die(pg_result_error()); $roster = pg_fetch_all($get_roster); echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; //echo 'ROSTERS: '; //print_r($roster); //echo '
'; foreach ($roster as $roster_info) { //echo 'ROSTER INFO: '; //print_r($roster_info); //echo '
'; $roster_id = $roster_info['id']; $dragon_level = $roster_info['dragon_level']; $march_att_sop = $roster_info['march_att_sop']; $march_def_sop = $roster_info['march_def_sop']; $march_hlth_sop = $roster_info['march_hlth_sop']; $att_at_sop = $roster_info['att_at_sop']; $def_at_sop = $roster_info['def_at_sop']; $hlth_at_sop = $roster_info['hlth_at_sop']; $troop_tier = $roster_info['troop_tier']; switch ($troop_tier){ case 11: $troop_pts = 3; break; case 10: $troop_pts = 2; break; case 9: $troop_pts = 1.5; break; case 8: $troop_pts = 1; break; default: $troop_pts = 0.5; break; } $off_power_rating = 0; $def_power_rating = 0; $tot_power_rating = 0; $off_power_rating = round((($march_att_sop/100) + ($march_def_sop/100) + ($march_hlth_sop/100))*$troop_pts,2); $def_power_rating = round((($att_at_sop/100) + ($def_at_sop/100) + ($hlth_at_sop/100))*$troop_pts,2); $tot_power_rating = round($off_power_rating + $def_power_rating,2); // echo 'OFF POWER RATING: '.$off_power_rating.'
'; $fix_roster .= "UPDATE \"rosters\" SET \"tot_power_rating\"='$tot_power_rating' WHERE (\"id\" = '$roster_id');"; $fix_roster .= "UPDATE \"rosters\" SET \"off_power_rating\"='$off_power_rating' WHERE (\"id\" = '$roster_id');"; $fix_roster .= "UPDATE \"rosters\" SET \"def_power_rating\"='$def_power_rating' WHERE (\"id\" = '$roster_id');"; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; echo ""; unset($tot_power_rating); unset($def_power_rating); unset($off_power_rating); } if ($fix_roster){ //echo $fix_roster $fix_rosters = pg_query($db_iadg,$fix_roster) or die(pg_error()); } echo "

FIXING CONTEST REGS

PLAYER INFO

NAME

TROOP TIER

MARCH ATT

MARCH DEF

MARCH HLTH

TOT POWER

OFF POWER

DEF POWER

".$roster_info['id']."

".$roster_info['player_name']."

".$troop_tier."

".$march_att_sop."

".$march_def_sop."

".$march_hlth_sop."

".$tot_power_rating."

".$off_power_rating."

".$def_power_rating."

"; $time_end = date('Y-m-d h:i:s.u'); $duration = $time_end - $time_start; echo 'DUARTION: '.$duration.'
'; $script_info = "INSERT INTO \"SCRIPTS_RAN\" (\"SCRIPT_NAME\",\"TIME_START\",\"TIME_END\",\"DURATION\") VALUES ('".$script_name."','".$time_start."','".$time_end."','".$duration."')"; $insert_script = pg_query($db,$script_info); @endphp