function verifySession() { global $connect; global $mysql_db; global $inc_header; global $inc_footer; if (!isset($_COOKIE[lqc_scores_session])) { notifyBox("notifyError", "Your session was not found", 0, 0); include $inc_footer; exit; } else { $user_array = unserialize(stripslashes($_COOKIE[lqc_scores_session])); $user_email = $user_array[user_email]; $user_password = $user_array[user_password]; $user_lastip = $_SERVER['REMOTE_ADDR']; $secure_check = mysql_query("SELECT * FROM `web_admin` WHERE user_email='{$user_email}' AND user_password='******' AND user_lastip='{$user_lastip}'"); if (mysql_num_rows($secure_check) == "0") { notifyBox("notifyError", "Your session has expired. Please relogin.", "3", "./login.php?do=logout"); include $inc_footer; exit; } } }
$fetchIndiv = mysql_query("SELECT `rank_player` FROM `rank_indiv` WHERE `rank_event` = '{$getEvent}' AND `rank_game_type` = '{$getType}' ORDER BY `rank_avg_twr_rank` ASC"); if (mysql_num_rows($fetchIndiv) == "0") { notifyBox("notifyError", "You must first run individual ranks before running this script.", 5, "./schedule.php?getEvent={$getEvent}&getType={$getType}"); } $i = 1; while ($indivRow = mysql_fetch_assoc($fetchIndiv)) { $rankArray[$i] = $indivRow[rank_player]; $i++; } $inArray = count($rankArray); if ($inArray > 0) { $deleteQuery = mysql_query("DELETE FROM `rank_ptile` WHERE `ptile_event` = '{$getEvent}' AND `ptile_game_type` = '{$getType}'"); foreach ($rankArray as $rank => $player) { $numBelow = $inArray - $rank; $percentileRaw = $numBelow / $inArray * 100; $percentile = round($percentileRaw, 2); $insertQuery = mysql_query("INSERT INTO `rank_ptile` (`ptile_player`, `ptile_event`, `ptile_game_type`, `ptile_percentile`) VALUES ('{$player}', '{$getEvent}', '{$getType}', '{$percentile}')"); if (!$insertQuery) { $errorArray[] = 1; } } if (count($errorArray) > 0) { notifyBox("notifyError", "There was one or more errors with your request, it may or may not have been completed.", 5, "./schedule.php?getEvent={$getEvent}&getType={$getType}"); } else { notifyBox("notifySuccess", "Your request was completed.", 5, "./schedule.php?getEvent={$getEvent}&getType={$getType}"); } } } else { notifyBox("notifyError", "You do not have access to this page", 0, 0); } include $inc_footer;
<?php require "conf.php"; require "func.php"; $scriptFilename = $_SERVER["PHP_SELF"]; $pageAnalytics = 0; $pageTitle = "Percentile Ranks"; include $inc_header; if ($_GET["getType"] != "") { $getType = $_GET["getType"]; $fetchData = mysql_query("SELECT `web_players`.`player_codename` , `rank_ptile` . *, `web_centers`.`center_title` FROM `web_players` , `rank_ptile`, `web_centers` WHERE `web_players`.`player_id` = `rank_ptile`.`ptile_player` AND `web_players`.`player_center` = `web_centers`.`center_number` AND `rank_ptile`.`ptile_game_type` = '{$getType}'"); if (mysql_num_rows($fetchData) == "0") { notifyBox("notifyError", "There is no data available", 0, 0); } while ($dataRow = mysql_fetch_assoc($fetchData)) { foreach ($dataRow as $key => $value) { ${$key} = $value; } $playerData[$ptile_player][] = $ptile_percentile; $playerInfo[$ptile_player][center] = $center_title; $playerInfo[$ptile_player][name] = $player_codename; } $dataCount = count($playerData); if ($dataCount != "0") { foreach ($playerData as $playerId => $playerArray) { $average = round(array_sum($playerArray) / count($playerArray), 2); $dataCount = count($playerData[$playerId]); if ($dataCount > 2) { $averageArray[$playerId] = $average; } }