[ModernAAC] Top 5

[president vankk]

Script by Kavvson is in error.

Script:

  <?PHP
//** Connection to the database **//
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = POT::getInstance()->getDBHandle();

//** Top Players + online status By Kavvson **//
                                $money_list = $SQL->query('SELECT name,level,experience FROM players ORDER BY experience DESC LIMIT 5')->fetchAll();
                                        $i = 1;
                                        foreach($money_list as $money_chr){
                                            echo $i.'. <a href="?subtopic=characters&name='.urlencode($money_chr['name']).'">';
        $player = $ots->createObject('Player');
        $player->find($money_chr['name']); 
                        echo '<font color="';
                        echo ($player->isOnline()) ? 'green' : 'red';
                        echo '">';    
                        echo '<b>'.$money_chr['name'].'</b></a></font>';
                        echo  '<br>Level: <B>'.$money_chr['level'].'</B><br>';
                                            $i++;
                                        }
                                        for( $i; $i <= 5; $i++ ){
                                            echo $i.'. <br><i>Empty</i><br /><br />';
                                        }
                                        
?>

Error:

 

[Paxton]

The links are wrong, just look at them. :|

 

[president vankk]

I tried to get over not going to the link

plx fixed

 

[Paxton]

 <?PHP
//** Connection to the database **//
$ots = POT::getInstance();
$ots->connect(POT::DB_MYSQL, connection());
$SQL = POT::getInstance()->getDBHandle();

//** Top Players + online status By Kavvson **//
                                $money_list = $SQL->query('SELECT name,level,experience FROM players ORDER BY experience DESC LIMIT 5')->fetchAll();
                                        $i = 1;
                                        foreach($money_list as $money_chr){
                                            echo $i.'. <a href="'.WEBSITE.'/index.php/character/view/'.$money_chr['name'].'">';
        $player = $ots->createObject('Player');
        $player->find($money_chr['name']); 
                        echo '<font color="';
                        echo ($player->isOnline()) ? 'green' : 'red';
                        echo '">';    
                        echo '<b>'.$money_chr['name'].'</b></a></font>';
                        echo  '<br>Level: <B>'.$money_chr['level'].'</B><br>';
                                            $i++;
                                        }
                                        for( $i; $i <= 5; $i++ ){
                                            echo $i.'. <br><i>Empty</i><br /><br />';
                                        }
                                        
?>