Showing [Baned] like highscores

[Rodo]

Well, I have the following script on my layout.php but I want that if player is banned, the text [Banned] appear like the highscore section, can someone make this one? :thumbup:

   <?php
   $limitt = 5;
   $zap = $SQL->query('SELECT `name`, `level` FROM `players` WHERE `group_id` < '.$config['site']['players_group_id_block'].' AND `name` != "Account Manager" ORDER BY `level` DESC, `experience` DESC LIMIT 5;');
   $number_of_rows = 0;
   foreach($zap as $wynik)
   {
      $number_of_rows++;
      echo ' <a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" > <li class="light">'.$number_of_rows.'. '.$wynik['name'].'</b></a><font color=gray>Level: </font><font color=white> '.$wynik['level'].'</font></li>';
   }
   ?>

 

[Rodo]

bump

 

[Rodo]

bump

 

[hodleo]

i'm @ msn dude

if it's gesior can be done from here:

$ban = '';
if($account->isLoaded() && $account->isBanned())
$ban = '<span style="color:red"> [Banned]</span>';

nope, another query would be better, from 'bans' table

 

[QuaS]

<?php
   $limitt = 5;
   $zap = $SQL->query('SELECT players.`name` , players.`level` , bans.`active`
		FROM `players`
		LEFT JOIN bans ON bans.`value` = players.`id` OR bans.`value` = players.`account_id`
		WHERE players.`group_id` < '.$config['site']['players_group_id_block'].'
		AND players.`name` != "Account Manager"
		ORDER BY players.`level` DESC , players.`experience` DESC
		LIMIT '.$limitt);
   $number_of_rows = 0;
   foreach($zap as $wynik)
   {
      $number_of_rows++;
	  $msg = ' <a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" > ';
	  if($wynik['active'])
		$msg .= '<font color=red><b>[Banned]</b></font>';
      $msg.= '<li class="light">'.$number_of_rows.'. '.$wynik['name'].'</b></a><font color=gray>Level: </font><font color=white> '.$wynik['level'].'</font></li>';
      echo $msg;
   }
?>

 

[Rodo]

Amazing, I wanted by that way, but I have that problem.

 

[QuaS]

<?php
   $limitt = 5;
   $zap = $SQL->query('SELECT players.`name` , players.`level` , bans.`active`
		FROM `players`
		LEFT JOIN bans ON bans.`value` = players.`id` OR bans.`value` = players.`account_id`
		WHERE players.`group_id` < '.$config['site']['players_group_id_block'].'
		AND players.`name` != "Account Manager"
		ORDER BY players.`level` DESC , players.`experience` DESC
		LIMIT '.$limitt)->fetchAll();
   $number_of_rows = 0;
   foreach($zap as $wynik)
   {
      $number_of_rows++;
	  $msg = ' <a href="index.php?subtopic=characters&name='.urlencode($wynik['name']).'" > ';
	  if($wynik['active'])
		$msg .= '<font color=red><b>[Banned]</b></font>';
      $msg.= '<li class="light">'.$number_of_rows.'. '.$wynik['name'].'</b></a><font color=gray>Level: </font><font color=white> '.$wynik['level'].'</font></li>';
      echo $msg;
   }
?>

? xD

 

[Rodo]

haha

 

[QuaS]

sry, works for me.

Maybe because i am using my own aac, but i think it's no a reason.

 

[Rodo]

Can't you make it for Gesior AAC?

 

[QuaS]

SELECT players.`name` , players.`level` , bans.`active`
        FROM `players`
        LEFT JOIN bans ON bans.`value` = players.`id` OR bans.`value` = players.`account_id`
        WHERE players.`group_id` < 3
        AND players.`name` != "Account Manager"
        ORDER BY players.`level` DESC , players.`experience` DESC
        LIMIT 5

execute this query, and tell me an output. You can always msg me on msn.

 

[Rodo]

It select 4 times the same player


name level active
Coco Rapado 355 0
Coco Rapado 355 0
Coco Rapado 355 1
Coco Rapado 355 0

 

[QuaS]

then i don't know. IT looks like that for me:

name 	level 	active
Herio 	311 	1
Quase 	106 	0
Orce 	106 	1
Lolek 	56 	0
Laregin 33 	NULL

 

[Rodo]

Well, thanks anyway, I really appreciate it