[Metin2 Heaven-Homepage Top5 Rangliste fehler!

12/03/2014 14:58 -Taishou-#1

Topic.

Habe folgenden fehler :

[Only registered and activated users can see links. Click Here To Register...]

Die Entsprechende .php :

Spoiler

<?
mysql_select_db('player');
$selranks = mysql_query("SELECT player.name,player.level,player_index.empire FROM player
LEFT JOIN player_index ON player_index.id = player.account_id
LEFT JOIN account.account ON account.id = player.account_id
WHERE player.name NOT LIKE '[%]%' AND account.status != 'BLOCK'
ORDER BY player.level DESC, player.exp DESC LIMIT 5");
echo '<table><tr><th>Platz</th><th>Name</th><th>Level</th></tr>';
$place = 1;
while($ranks = mysql_fetch_object($selranks)) {
echo '<tr><td>'.$place.'</td><td><a href="#'.$ranks->name.'#">'.$ranks->name.'</a></td><td>'.$ranks->level.'</td></tr>';
$place = $place + 1;
}
echo '</table>';
?>

-

Bitte einfach die verbesserte top5.php in nen Spoiler packen damit ichs kopieren & ersetzen kann! Also den text inhalt.

Oder notfalls auch ne komplett neue top5 rangliste :p

12/03/2014 15:58 Gl0bal#2

Auf deinem Webserver sind die php-short-tags nicht aktiviert �nder den Code einfach in:

PHP Code:


			
<?php    

mysql_select_db('player');

$selranks = mysql_query("SELECT player.name,player.level,player_index.empire FROM player

LEFT JOIN player_index ON player_index.id = player.account_id

LEFT JOIN account.account ON account.id = player.account_id

WHERE player.name NOT LIKE '[%]%' AND account.status != 'BLOCK'

ORDER BY player.level DESC, player.exp DESC LIMIT 5");

echo '<table><tr><th>Platz</th><th>Name</th><th>Level</th></tr>';

$place = 1;

while($ranks = mysql_fetch_object($selranks)) {

echo '<tr><td>'.$place.'</td><td><a href="#'.$ranks->name.'#">'.$ranks->name.'</a></td><td>'.$ranks->level.'</td></tr>';

$place = $place + 1;

}

echo '</table>';

?>

12/03/2014 16:50 -Taishou-#3

Danke :)