|
Server Error';
$endM = '
Please try again later. ';
$link = @mysqli_connect("$databaseserver", "$databaseuser", "$databasepasswd") or exit("$startM [1]$endM");
$errorcheck = @mysqli_select_db($link, "$databasename") or exit("$startM [2]$endM");
$query = "SELECT ranksShown FROM hofs WHERE ref = 'Rep3A21'";
$result = mysqli_query($link, $query) or exit("$startM [3]$endM");
$ranks1 = mysqli_fetch_array($result)[0];
$query = "SELECT ranksShown FROM hofs WHERE ref = 'Rep3A22'";
$result = mysqli_query($link, $query) or exit("$startM [4]$endM");
$ranks2 = mysqli_fetch_array($result)[0];
$query = "SELECT ranksShown FROM hofs WHERE ref = 'Rep3A23'";
$result = mysqli_query($link, $query) or exit("$startM [5]$endM");
$ranks3 = mysqli_fetch_array($result)[0];
$query = "SELECT ranksShown FROM hofs WHERE ref = 'Rep3A24'";
$result = mysqli_query($link, $query) or exit("$startM [6]$endM");
$ranks4 = mysqli_fetch_array($result)[0];
$query = "SELECT ranksShown FROM hofs WHERE ref = 'Rep3A25'";
$result = mysqli_query($link, $query) or exit("$startM [7]$endM");
$ranks5 = mysqli_fetch_array($result)[0];
$query = "SELECT * FROM h_Rep3A21";
$result = mysqli_query($link, $query) or exit("$startM [8]$endM");
$rows = @mysqli_num_rows($result);
if ($rows == 0)
$ranks1 = 0;
else {
if ($rows < $ranks1) $ranks1 = $rows;
$arrName1 = array();
$arrScore1 = array();
$arrNewEntry1 = array();
for ($index = 0; $index < $ranks1; $index++) {
mysqli_data_seek($result, $index);
$row = mysqli_fetch_array($result);
$arrName1[] = $row["name"];
$arrScore1[] = $row["score"];
$arrNewEntry1[] = $row["cTime"] > 0;
}
}
$query = "SELECT * FROM h_Rep3A22";
$result = mysqli_query($link, $query) or exit("$startM [9]$endM");
$rows = @mysqli_num_rows($result);
if ($rows == 0)
$ranks2 = 0;
else {
if ($rows < $ranks2) $ranks2 = $rows;
$arrName2 = array();
$arrScore2 = array();
$arrNewEntry2 = array();
for ($index = 0; $index < $ranks2; $index++) {
mysqli_data_seek($result, $index);
$row = mysqli_fetch_array($result);
$arrName2[] = $row["name"];
$arrScore2[] = $row["score"];
$arrNewEntry2[] = $row["cTime"] > 0;
}
}
$query = "SELECT * FROM h_Rep3A23";
$result = mysqli_query($link, $query) or exit("$startM [10]$endM");
$rows = @mysqli_num_rows($result);
if ($rows == 0)
$ranks3 = 0;
else {
if ($rows < $ranks3) $ranks3 = $rows;
$arrName3 = array();
$arrScore3 = array();
$arrNewEntry3 = array();
for ($index = 0; $index < $ranks3; $index++) {
mysqli_data_seek($result, $index);
$row = mysqli_fetch_array($result);
$arrName3[] = $row["name"];
$arrScore3[] = $row["score"];
$arrNewEntry3[] = $row["cTime"] > 0;
}
}
$query = "SELECT * FROM h_Rep3A24";
$result = mysqli_query($link, $query) or exit("$startM [11]$endM");
$rows = @mysqli_num_rows($result);
if ($rows == 0)
$ranks4 = 0;
else {
if ($rows < $ranks4) $ranks4 = $rows;
$arrName4 = array();
$arrScore4 = array();
$arrNewEntry4 = array();
for ($index = 0; $index < $ranks4; $index++) {
mysqli_data_seek($result, $index);
$row = mysqli_fetch_array($result);
$arrName4[] = $row["name"];
$arrScore4[] = $row["score"];
$arrNewEntry4[] = $row["cTime"] > 0;
}
}
$query = "SELECT * FROM h_Rep3A25";
$result = mysqli_query($link, $query) or exit("$startM [12]$endM");
$rows = @mysqli_num_rows($result);
if ($rows == 0)
$ranks5 = 0;
else {
if ($rows < $ranks5) $ranks5 = $rows;
$arrName5 = array();
$arrScore5 = array();
$arrNewEntry5 = array();
for ($index = 0; $index < $ranks5; $index++) {
mysqli_data_seek($result, $index);
$row = mysqli_fetch_array($result);
$arrName5[] = $row["name"];
$arrScore5[] = $row["score"];
$arrNewEntry5[] = $row["cTime"] > 0;
}
}
mysqli_close($link);
?>
 |
| |
