PHP код:
$aSql = mysql_num_rows(mysql_query("SELECT `id` FROM `account`", $sMySql));
Ого какой оптимальный код )
"SELECT count(`id`) FROM `account`
как-бы так правильнее )
и дальше тоже через count
PHP код:
$aSql = mysql_num_rows(mysql_query("SELECT `guid` FROM `characters` WHERE `online` IN ( 1 )", $sMySql));
$nCurrenOnline = $aSql;;
$aSql = mysql_num_rows(mysql_query("SELECT `guid` FROM `characters` WHERE `online` IN ( 1 ) and `race` IN (6, 10, 5, 2, 8)", $sMySql));
$OnlineHorde = $aSql;
$aSql = mysql_num_rows(mysql_query("SELECT `guid` FROM `characters` WHERE `online` IN ( 1 ) and `race` IN ( 1, 4, 11, 3, 7 )", $sMySql));
$OnlineAlliance = $aSql;
Дальше function conventNormTime($nSec)
а чем вас не устроила стандартная PHP функция
date ( string $format [, int $timestamp ] )