Beyler benim sorunum sıralamada 3 ismi göstermemek.
metin2 online oyun kurdum sıralama bölümünde 3 ismin görükmesini istemiyorum nasıl yapabilirim yardım edin lütfen :) o üç isim yöneticiler yani biz örn [GA]Nara
<html>
<head>
<META http-equiv=Content-Type content=text/html; charset=iso-8859-9>
<META http-equiv=content-type content=text/html;charset=windows-1254>
<META http-equiv=content-type content=text/html;charset=x-mac-turkish>
<style type="text/css">
<!--
.style1 {
font-size:1em;
font-weight: bold;
}
.style2 {
color: #006600;
font-weight: bold;
font-size:1em;
}
.style5 {font-size:1.1em; font-weight: bold; color: #FF0000; }
body {
background-image: url(img/BG.PNG);
}
.style6 {
color: #3300FF;
font-weight: bold;
}
.style8 {
font-size:1em;
font-weight: bold;
color: #6699FF;
}
.style10 {
font-size:1em;
font-weight: bold;
color: #99CCCC;
}
.style11 {
color: #999999;
font-weight: bold;
}
.style12 {color: #FF0000;
font-weight: bold;
}
.style7 {color: #666666;
font-weight: bold;
}
.style9 {font-family: Arial, Helvetica, sans-serif}
body,td,th {
color: #00FF00;
}
-->
</style>
</head>
<body background="img/BG.PNG"><font color="#FFFFFF">
<?php
echo "<center>";
include('Ayar.php'); // Connect to DB
mysql_select_db('player'); // Select DB 'player'
$test = "SELECT * from player";
$testquery = mysql_query($test);
$num2 = mysql_num_rows($testquery);
if($_GET['max']) {
$get = $_GET['max'];
} else {
$get = '0';
$max = $get + 100;
$max2 = $get - 100;
if($get > $num2) {
echo "<a href=\"rank.php?max=$max2\">Önceki Sayfa</a>"; }
elseif($get >= 100 && $get < $num2) { echo "<a href=\"rank.php?max=$max2\">Önceki Sayfa</a> <a href=\"rank.php?max=$max\">Sonraki Sayfa</a>"; }
elseif ($num2 <= 100) { echo ""; }
else { echo "<a href=\"rank.php?max=$max2\">Sonraki Sayfa</a>"; }
echo "</center><br>";
?>
<center><table border="0">
<tr>
<th width="150"><font color="#006600">Sıra</font></th>
<th width="150"><font color="#006600">isim</font></th>
<th width="150"><font color="#006600">Level</font></th>
<th width="150"><font color="#006600">EXP</font></th>
<th width="150"><font color="#006600">Krallık</font></th>
</tr>
</table>
</center>
<?php
include('Ayar.php'); // Connect to DB
mysql_select_db('player'); // Select DB 'player'
// Select player etc from db //
$rank = "SELECT * from player order by level desc limit $get,9999";
$query = mysql_query($rank);
echo "<center><table border=\"0\">"; // Open table
$i = 0;
while($array = mysql_fetch_array($query)) {
$i = $i + 1;
echo "
<tr>
<th width=\"150\"><font color=\"green\">" . $i . "</font></th>
<th width=\"150\"><font color=\"green\">" . $array["name"] . "</font></th>
<th width=\"150\"><font color=\"green\">" . $array["level"] . "</font></th>
<th width=\"150\"><font color=\"green\">" . $array["exp"] . "</font></th>";
$reich = "SELECT empire from player_index where id = " . $array[account_id] . "";
$query2 = mysql_query($reich);
$array2 = mysql_fetch_array($query2);
if($array2["empire"] == 1) {
echo "<th width=\"150\"><img src=\"img/Kirmizi.PNG\"></th></tr>";
} elseif($array2["empire"] == 2) {
echo "<th width=\"150\"><img src=\"img/Sari.PNG\"></th></tr>";
} else {
echo "<th width=\"150\"><img src=\"img/Mavi.PNG\"></th></tr>";
}
}
echo "</table></center><br>"; // close table
}
?>
</font>
</body>
</html>
kodlar bunlar
beyler anlayan yoqmu :(
oyun mu kurdun ?
yoq gardashim yanlish gelmishin buras1 web sahifesi yapim1 sitesi
evt kurdum ama sıralama scripti war onda 3 ismin gözükmemesi lazım sitede
phpmyadmin ile yönetici olanlara özel bir sütun eklemen gerekli:
daha sonra şu değişecek:
$test = "SELECT * from player";
yerine bu:
$test = "SELECT * from player WHERE yonetici=0 ";
teşekkürler sorun çözüldü
