<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN">
<html>
<head>
<title>Normal Ranking</title>
<meta http-equiv="content-type" content="text/html; charset=iso-8859-1">
<meta name="description" content="KalOnline Ranking">
<meta name="author" content="Rekat">
<meta name="keywords" content="Ranking, KalOnline">
<meta name="language" content="en">
<meta name="robots" content="index, follow">
<link rel="stylesheet" type="text/css" href="ranking.css">
</head>
<body>
<center>
<?php
$config = array(
'db_username' => 'sa', // database username
'db_password' => ' i know i need to up my PW in here', // database password
'db_dsn' => 'kal_db', // system DSN to the database
'debug' => false, // show SQL errors if true
);
$conn = odbc_connect($config['db_dsn'],
$config['db_username'],
$config['db_password']);
$pknight = "SELECT TOP 1 * FROM [Player] WHERE [Class] = 0 AND [Admin] = 0 And Reborn Is NULL OR Class = 0 AND Admin = 0 And Reborn = 0 ORDER BY [Level] Desc, [Exp] Desc";
$ppknight = odbc_exec($conn,$pknight);
while($knight = odbc_fetch_array($ppknight)){
$knight_1 = '<b>'.$knight['Name'].'</b>';
};
$parcher = $parcher = "SELECT TOP 1 * FROM [Player] WHERE [Class] = 2 AND [Admin] = 0 AND Reborn Is NULL OR Class = 2 AND Admin = 0 And Reborn = 0 ORDER BY [Level] Desc, [Exp] Desc";
$pparcher = odbc_exec($conn,$parcher);
while($archer = odbc_fetch_array($pparcher)){
$archer_1 = ' <b>'.$archer['Name'].'</b>';
};
$pmage = $pmage = "SELECT TOP 1 * FROM [Player] WHERE [Class] = 1 AND [Admin] = 0 And Reborn Is NULL OR Class = 1 AND Admin = 0 And Reborn = 0 ORDER BY [Level] Desc, [Exp] Desc";
$ppmage = odbc_exec($conn,$pmage);
while($mage = odbc_fetch_array($ppmage)){
$mage_1 = '<b>'.$mage['Name'].'</b>';
};
echo '<div id="box_bg">';
echo '<div id="top3_archer">';
echo '<div id="top3_archer_title"><div id="top3_archer_text">Archer: </div></div>';
echo '<div id="top3_archer_form"><div id="top3_archer_form_text">'.$archer_1.'</div></div></div>';
echo '<div id="top3_mage">';
echo '<div id="top3_mage_title"><div id="top3_mage_text">Mage: </div></div>';
echo '<div id="top3_mage_form"><div id="top3_mage_form_text">'.$mage_1.'</div></div></div>';
echo '<div id="top3_knight">';
echo '<div id="top3_knight_title"><div id="top3_knight_text">Knight: </div></div>';
echo '<div id="top3_knight_form"><div id="top3_knight_form_text">'.$knight_1.'</div></div></div>';
?>
</center>
</body>
