Farm Siege Leaderboard

[insert_php]

$servername = “localhost”;
$username = “rogue-operatives”;
$password = “sim720MYSQL”;
$dbname = “rogue_operatives_co_uk”;
// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die(“Connection failed: ” . $conn->connect_error);
}

echo “

“;
echo “Deaths:    “;
echo ““;
echo “
“;
echo “
“;

$deathfilter = $_POST[‘deathfilter’];
$sql = “SELECT * FROM siegeleaderboard WHERE map= ‘Farm Siege’ AND deathvalue= ‘$deathfilter’ ORDER BY killsvalue DESC LIMIT 100”;
$result = $conn->query($sql) or die($conn->error.__LINE__);
$sqlelse = “SELECT * FROM siegeleaderboard WHERE map= ‘Farm Siege’ ORDER BY killsvalue DESC LIMIT 100”;
$resultelse = $conn->query($sqlelse) or die($conn->error.__LINE__);
$counter = 1;

if ($result->num_rows > 0) {

echo “SHOW ALL SCORES“;
echo “

“;

while($row = $result->fetch_assoc()) {
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

$counter++;

}

echo “

# Username Map Total Kills Total Deaths Time Survived
” . $counter . “ ” . $row[‘playernamevalue’] . “ ” . $row[‘map’] . “ ” . $row[‘killsvalue’] . “ ” . $row[‘deathvalue’] . “ ” . $row[‘timeingame’] . “

“;
} elseif ($resultelse->num_rows > 0) {

echo “

“;

while($row = $resultelse->fetch_assoc()) {
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;
echo “

“;

$counter++;
}
echo “

# Username Map Total Kills Total Deaths Time Survived
” . $counter . “ ” . $row[‘playernamevalue’] . “ ” . $row[‘map’] . “ ” . $row[‘killsvalue’] . “ ” . $row[‘deathvalue’] . “ ” . $row[‘timeingame’] . “

“;
} else {
echo “0 Results”;
}
$conn->close();
[/insert_php]