PHP Scripters LOOK AT THIS!

[Zonet]

Here's my script, it shows the VIP stats how many onlines total VIP etc.. VIP = premium

here is it.. i need it to work with ALPHA! HELP!

<?php 
$vipPlayers = 0; 
$vipOnlinePlayers = 0; 
$players = new OTS_Players_List(); 
echo '<table border="0" cellspacing="1" cellpadding="4" width="100%">'; 
echo '<tr bgcolor="'.$config['site']['vdarkborder'].'"><td width="70%"><b><font color="white">Name</font></b></td><td width="10%"><b><font color="white">Level</font></b></td><td width="20%"><b><font color="white">Vocation</font></b></td></tr>'; 
foreach($players as $index => $player) 
{ 
    $account = $player->getAccount(); 
    if($account->getCustomField('premdays') > 0) 
    { 
        $vipPlayers++; 
        if($player->getCustomField('online') > 0) 
        { 
            $vipOnlinePlayers++; 
            $bgcolor = ($vipOnlinePlayers % 2) ? $config['site']['darkborder'] : $config['site']['lightborder']; 
            echo '<tr bgcolor="'.$bgcolor.'"><td><a href=index.php?subtopic=characters&name='.$player->getName().'">'.$player->getName().'</a></td><td>'.$player['level'].'</TD><TD WIDTH=20%>'.$vocation_name[$player['promotion']][$player['vocation']].'</TD></TR>';
        } 
    } 
} 
echo '</table'; 

echo '<br/>'; 

echo '<table border="0" cellspacing="1" cellpadding="4" width="100%">'; 
    echo '<tr bgcolor="'.$config['site']['vdarkborder'].'"><td><b><font color="white">Stats</font></b></td></tr>'; 
    echo '<tr bgcolor="'.$config['site']['lightborder'].'"><td>There are'.$vipPlayers.'</td>VIP player on my servername</tr>'; 
    echo '<tr bgcolor="'.$config['site']['darkborder'].'"><td>Currently<b>'.$vipOnlinePlayers.'</b>VIP players online</td></tr>'; 
echo '</table'; 
?>

 

[Kofels]

Next true Gesior fan? :< I quote Elf words: "Do you have problems with your ego?"

 

[Dekon]

$players = new OTS_Players_List(); 
foreach($players as $index => $player) 
{ 
    $account = $player->getAccount();

With 20,000 players in database it will load....

$accounts = OTS_Account_List();
foreach($accounts as $account)
   echo $account->getId();

13,000 accounts in database, 2x2.53GHz, 2 GB ram, load time: 3.5 seconds
If you load OTS_Players_List() [12.500 players in db] and then use $player->getAccount() for every player.. 12.500 queries to mysql?
---------------
Razor script...
Players: 12.500, Accounts: 12.000
Load time: 13.8933 seconds, 14.0543 seconds, 13.4786 seconds (2x2.33GHz, 2 gb ram)
---------------
My script from last post:
Load time: 4.7375 seconds
--------------
New script (stats are above vip players list):

<?php
$vipPlayers = 0;
$vipOnlinePlayers = 0;
$players = $SQL->query('SELECT `players`.`name`,`players`.`online`,`players`.`level`,`players`.`vocation`,`players`.`promotion`,`accounts`.`premdays`,`accounts`.`lastday` FROM `accounts`, `players` WHERE `players`.`account_id` = `accounts`.`id` AND `players`.`deleted` = 0 AND `accounts`.`premdays` > 0 ORDER BY `name`');
foreach($players as $player)
    if(isPremium($player['premdays'], $player['lastday'])) //check 'is it really premium account'
    {
        $vipPlayers++; 
        if($player['online'] > 0)
        {
            $vipOnlinePlayers++; 
            $bgcolor = ($vipOnlinePlayers % 2) ? $config['site']['darkborder'] : $config['site']['lightborder']; 
            $players_list .= '<tr bgcolor="'.$bgcolor.'"><td><a href=index.php?subtopic=characters&name='.urlencode($player['name']).'">'.$player['name'].'</a></td><td>'.$player['level'].'</TD><TD WIDTH=20%>'.$vocation_name[$player['promotion']][$player['vocation']].'</TD></TR>';
        }
    }
$main_content .= '<table border="0" cellspacing="1" cellpadding="4" width="100%">
<tr bgcolor="'.$config['site']['vdarkborder'].'"><td><b><font color="white">Stats</font></b></td></tr>
<tr bgcolor="'.$config['site']['lightborder'].'"><td>There are <b>'.$vipPlayers.'</b> VIP player(s) on my servername.</td></tr>
<tr bgcolor="'.$config['site']['darkborder'].'"><td>Currently <b>'.$vipOnlinePlayers.'</b> VIP player(s) online.</td></tr>
</table><br /><table border="0" cellspacing="1" cellpadding="4" width="100%"><tr bgcolor="'.$config['site']['vdarkborder'].'"><td width="70%"><b><font color="white">Name</font></b></td><td width="10%"><b><font color="white">Level</font></b></td><td width="20%"><b><font color="white">Vocation</font></b></td></tr>'.$players_list .'</table><br/>';
?>

Load time: 0.0583 seconds

Decide what you need

how to inplant it in ur new acc maker ?
/Danne

 

[Dekon]

i need halp to get it working the the acc maker !
i need to see all my vips!

 

[Zonet]

But that gesior made is working with unnamed acc. maker