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;
}
}
