ClanTop.php
Code:
<?php include "Config.php";?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title><?=$servername?></title>
<link href="style.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.style1 {
color: #FFFFFF;
font-weight: bold;
}
.style53 {color: #CEAA7B;
font-size: 13px;
font-weight: bold;
}
.style10 {color: #FFFFFF}
.style11 {color: #FF0000}
.bottom {font-family: Verdana, Tahoma, Arial, sans-serif; font-size: 10px; color: #FEFEFE;}
-->
<div align="center"><?php include "Config.php";
?>
<link rel="stylesheet" type="text/css" href="style.css">
<?php
$query = mssql_query("SELECT TOP 9999 * FROM Clan order by Wins desc");
$result= mssql_fetch_row($query);
?>
<style type="text/css">
<!--
.style28 {font-size: 10px}
.style29 {color: #FFFFFF; font-weight: bold; font-size: 10px; }
-->
</style>
<table width="442" border="1">
<tr >
<th colspan="8" scope="row"><span class="style28">Top 100 Player List </span></th>
</tr>
<tr>
<th width="19" scope="row"><span class="style28"><strong>Bil</strong></span></th>
<td width="36"><span class="style28"><strong>Name</strong></span></td>
<td width="32"><span class="style28"><strong>Wins</strong></span></td>
<td width="63"><span class="style28"><strong>Losses</strong></span></td>
</tr>
<?php
for($i=0;$i < mssql_num_rows($query);++$i)
{
$row = mssql_fetch_row($query);
$rank = $i+1;
?>
<tr>
<th scope="row"><span class="style28"><strong><?php echo "$rank";?></strong></span></th>
<td><span class="style28"><?php echo "$row[2]" ;?></span></td>
<td><span class="style28"><?php echo "$row[7]";?></span></td>
<td><span class="style29"><?php echo "$row[8]";?></span></td>
</tr>
<?php }?>
</table></div>
</div>
</div>
</body>
</html>
config.php
Code:
<?php
$srvip = "YOUR GUNZ HOMEPAGE";
$srvport = "6000";
$mssql_user = "USER";
$mssql_pass = "PASS";
$mssql_database = "GunzDB";
$mssql_host = "HOST";
$forumlink= "http://estoniagunz.portbb.com/";
$conn = mssql_connect($mssql_host, $mssql_user, $mssql_pass);
mssql_select_db($mssql_database);
?>
Reply With Quote