ich habe das HP-Script von Werdernator...
aber ich habe ein problem, undzwar bei diesem script gibt es ja die rangliste, und eine top5 die man immer sieht...
den GM habe ich schon aus der rangliste raus bekommen, jedoch is der immernoch in der top5, wie bekomme ich den daraus?
(falls es eine rolle spielt, der GM-char heißt "[EM]eRRoR")
hier ist die top5.php-Datei
und die ranking.php-Datei falls man die auch brauch (aber da habe ich den GM schon raus, wie gesagt)
bitte richtig machen und uploaden, danke!
Top5.php
<?php
echo "<table border=\"0\" width=\"230\">
<tr>
<td width=\"10\"><b><center>Rang</center></b></td>
<td width=\"150\"><b><center>Name</center></b></td>
<td width=\"30\"><b><center>Level</center></b></td>
</tr>";
include 'inc/dbsettings.php';
$db = "player";
mysql_connect($dbhost, $dbuser, $dbpw) OR
die("ERROR: Connection failed. ".mysql_error());
mysql_select_db($db) OR
die("ERROR: DB allready open. ".mysql_error());
$sql = "SELECT * FROM player WHERE name NOT LIKE '[GM]%' AND name NOT LIKE '[GA]%' 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 0,5";
$i = "0" ;
$ergebnis = mysql_query($sql);
while($row = mysql_fetch_object($ergebnis))
{
$i = $i + 1 ;
echo "
<tr>
<th width=\"10\">$i</th>
<th width=\"187\"><a href=\"index.php?page=player&char=$row->name\"> $row->name</a></th>
<th width=\"30\">$row->level</th>
</tr>";
}
echo "</table>";
?>
ranking.php
<center> « <a href="index.php?page=ranking" title="Rangliste"><b>Spieler-Rangliste</b></a> «» <a href="index.php?page=guildranking" title="Gildenrangliste">Gildenrangliste</a> »</center><br>
<div class="contentBoxTop"></div>
<div class="contentBox">
<?php
include './inc/dbsettings.php';
$db = "player";
mysql_connect($dbhost, $dbuser, $dbpw) OR
die("ERROR: Connection failed. ".mysql_error());
mysql_select_db($db) OR
die("ERROR: DB allready open. ".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=\"index.php?page=ranking&max=$max2\">« Vorherige Seite</a></center>"; }
elseif($get >= 20 && $get < $num2) { echo "<center><a href=\"index.php?page=ranking&max=$max2\">« Vorherige Seite</a> <a href=\"index.php?page=ranking&max=$max\">Nächste Seite »</a></center>"; }
elseif ($num2 <= 20) { echo ""; }
else { echo "<center><a href=\"index.php?page=ranking&max=$max\">Nächste Seite »</a></center>"; }
echo "</center><br></center>";
?>
<center><table border="0">
<tr>
<th width="150">Platz</th>
<th width="150">Name</th>
<th width="150">Level</th>
<th width="150">Exp</th>
<th width="150">Reich</th>
</tr>
</table></center>
<?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 '%[%]%' order by level desc, exp desc, name asc limit $get,20";
$query = mysql_query($rank);
echo "<center><table border=\"0\">"; // Open table
$i = 0 + $get;
while($array = mysql_fetch_array($query)) {
$i = $i + 1;
echo "
<tr>
<th width=\"150\"><font color=\"black\">" . $i . "</font></th>
<th width=\"150\"><font color=\"black\"><a href=\"index.php?page=player&char=",$array["name"],"\">",$array["name"],"</a></font></th>
<th width=\"150\"><font color=\"black\">" . $array["level"] . "</font></th>
<th width=\"150\"><font color=\"black\">" . $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=\"images/icons/shinsoo.jpg\"></th></tr>";
} elseif($array2["empire"] == 2) {
echo "<th width=\"150\"><img src=\"images/icons/chunjo.jpg\"></th></tr>";
} else {
echo "<th width=\"150\"><img src=\"images/icons/jinno.png\"></th></tr>";
}
}
echo "</table></center><br>"; // close table
?>
</div>
<div class="contentBoxBottom"></div>
