<html>
<head>
<meta http-equiv="Content-Style-Type" content="text/css">
<style type="text/css">
html,
body {
background-color: transparent;
}
</style>
</head>
<?php
include './inc/dbsettings.php';
$db = "player";
mysql_connect($dbhost, $dbuser, $dbpw) OR
die("HATA: DB bağlanamadı. ".mysql_error());
mysql_select_db($db) OR
die("HATA: DB zaten bağlı. ".mysql_error());
$test = "SELECT * from player";
$testquery = mysql_query($test);
$num2 = mysql_num_rows($testquery);
if($_GET['max']) {
$get = $_GET['max'];
} else {
$get = '0';
}
$max = $get + 20;
$max2 = $get - 20;
if($get > $num2) {
echo "<center><a href=\"squit.php?page=ranking&max=$max2\">« Ileri</a></center>"; }
elseif($get >= 20 && $get < $num2) { echo "<center><a href=\"squit.php?page=ranking&max=$max2\">« Geri</a> <a href=\"squit.php?page=ranking&max=$max\">Ileri »</a></center>"; }
elseif ($num2 <= 20) { echo ""; }
else { echo "<center><a href=\"squit.php?page=ranking&max=$max\">Ileri »</a></center>"; }
echo "</center><br></center>";
?>
<table width=400 style="font-size:11px; font-family:verdana; color:#000000;" cellspacing="0" cellpadding="0" align=center>
<tr>
<td width=100% height=34 colspan=3 align=center class="content" style="font-size:12px; font-family:verdana; color:#000000;"><b></b>
</td>
</tr>
<tr>
<td style="font-size:12px; border:1px #000000 solid;"><center><b>Sira</b></center></td>
<td style="font-size:12px; border:1px #000000 solid;"><center><b>Nick</b></center></td>
<td style="font-size:12px; border:1px #000000 solid;"><center><b>Level</b></center></td>
</tr>
<tr>
<?php
include('./inc/dbsettings.php'); // Connect to DB
mysql_select_db('player'); // Select DB 'player'
// Select player etc from db //
$rank = "SELECT * from player WHERE name NOT LIKE '[%]%' AND name NOT LIKE 'Squit' AND name NOT LIKE '[%]%' AND name NOT LIKE '[%]%' AND job NOT LIKE '0' AND job NOT LIKE '1' AND job NOT LIKE '2' AND job NOT LIKE '4' AND job NOT LIKE '5' AND job NOT LIKE '6' AND name NOT LIKE '[WD]%' AND name NOT LIKE '[TL]%' AND name NOT LIKE '[CM]%' AND name NOT LIKE '[CoMa]%' AND name NOT LIKE '[SA]%' AND name NOT LIKE '[MoD]%' AND name NOT LIKE '[EV]%' AND name NOT LIKE '[TGM]%' order by level desc, exp desc, name asc limit $get,20";
$query = mysql_query($rank);
$i = 0 + $get;
while($array = mysql_fetch_array($query)) {
$i = $i + 1;
echo "
<tr>
<td style=\"font-size:10px; font-family:verdana; color:#000000;\" class=content align=center>" . $i . "</td>
<td style=\"font-size:10px; font-family:verdana; color:#000000;\" class=content align=center>",$array["name"],"</td>
<td style=\"font-size:10px; font-family:verdana; color:#000000;\" class=content align=center>" . $array["level"] . "</td>
</tr>";
}
echo "</tr>"; // close table
?>
</body>
</html>hocam bu benim kendi sayfalama sistemim üstünde düzenleme yaparak yapabilirsin
