Файл: user/us_stat.php
Строк: 48
<?
echo '<div class="menu">Статистика:</div>';
echo '<div class="podmenu">';
$p_forum=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_post` WHERE `us` = '$ank[id]'"),0);
echo "<span class="ank_n">» Постов в форуме:</span> <span class="ank_d">$p_forum</span><br />n";
$t_forum=mysql_result(mysql_query("SELECT COUNT(*) FROM `forum_tema` WHERE `us` = '$ank[id]'"),0);
echo "<span class="ank_n">» Тем в форуме:</span> <span class="ank_d">$t_forum</span><br />n";
$f_load=mysql_result(mysql_query("SELECT COUNT(*) FROM `load_file` WHERE `avtor` = '$ank[id]'"),0);
echo "<span class="ank_n">» Файлов:</span> <span class="ank_d">$f_load</span><br />n";
$p_guest=mysql_result(mysql_query("SELECT COUNT(*) FROM `guest` WHERE `avtor` = '$ank[id]'"),0);
echo "<span class="ank_n">» Постов в гостевой:</span> <span class="ank_d">$p_guest</span><br />n";
$blog=mysql_result(mysql_query("SELECT COUNT(*) FROM `blog_stat` WHERE `avtor` = '$ank[id]'"),0);
echo "<span class="ank_n">» Статей:</span> <span class="ank_d">$blog</span><br />n";
echo '</div>';
?>