• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

[MODERNACC]Needing help with website

khang123321

New Member
Joined
Jan 3, 2011
Messages
25
Reaction score
2
I'm trying to make a top 5 rebirth list but so far i only have it showing the players id :T like this..
Code:
1. 
Rebirths: 800
2. 
Rebirths: 400
3. 
Rebirths: 22
4. 
Rebirths: 20
5. 
Rebirths: 10

the script is
PHP:
<?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 `player_id`, `value` FROM `player_storage` WHERE `key` = 85987 ORDER BY `value` DESC LIMIT 5')->fetchAll(); 
                                        foreach($money_list as $money_chr){ 
                                        echo '<center>'; 
                                            echo $i.'. <a href="'.WEBSITE.'/index.php/character/view/'.$money_chr['player_id'].'">'; 
        $player = $ots->createObject('Player'); 
        $player->find($money_chr['player_id']);  
                        echo '<font color="'; 
                        echo ($player->isOnline()) ? 'green' : 'red'; 
                        echo '">';     
                        echo '<b>'.$money_chr['player_id'].'</b></a></font>'; 
                        echo  '<br>Rebirths: <B>'.$money_chr['value'].'</B><br>'; 
                                            $i++; 
                                        } 
                                        for( $i; $i <= 5; $i++ ){ 
                                            echo $i.'. <br><i>Empty</i><br /><br />'; 
                                        } 
                                        echo '</center>'; 
                                         
?>
help please ! i am bad at websites
 
Back
Top