invinfo.php

<?php
include config.php
include functions.php

echo "<table border = 1>
<tr><td>Аккаунт:</td><td>Количество активных подписчиков:</td>
</tr>";

mysql_connect($host, $user, $pass);
mysql_select_db($auth);
$result = mysql_query("SELECT `id` FROM `account_invited` GROUP BY `id`");
while ($act_result = mysql_fetch_array($result))
   {
       $plr_count = recent_players_count($act_result['id']);
       if ($plr_count >= 1)
       {
           mysql_select_db($auth);
           $sel_acc = mysql_query("SELECT `username` FROM `account` WHERE `id`='".$act_result['id']."'");
           $account = mysql_fetch_array($sel_acc);
           echo "<tr><td>";
           echo $account['username'];
           echo "</td><td>";
           echo $plr_count;
           echo "</td></tr>";
       }
   }
echo "</table>";
?>