View file 4at2/ch/statistik.php

<?
header("Cache-Control: no-cache");
header("Content-type:text/vnd.wap.wml");  
$ref=rand(10000,1000000);
require("inc.php");

$link = @mysql_connect ($MySQL_Hostname, $MySQL_Username, $MySQL_Password)
                or die ("<wml><card id=\"error\" title=\"error\">
<do type=\"prev\" label=\"Back\"><prev/></do><p align=\"center\"><small>Can not connect to MySQL</small></p>
</card></wml>");
     
     @mysql_select_db($MySQLDatabasename) or die ("<wml><card id=\"error\" title=\"error\">
<do type=\"prev\" label=\"Back\"><prev/></do><p align=\"center\"><small>error select the database...</small></p>
</card></wml>");

$result = @mysql_query ("Select fsize from users where id='".$id."' LIMIT 1;");
$row = @mysql_fetch_array ($result);

if($row['fsize'] == "small") { $fsize1 = "<small>"; $fsize2 = "</small>"; }
elseif($row['fsize'] == "big") { $fsize1 = "<big>"; $fsize2 = "</big>"; }
else { $fsize1 = ""; $fsize2 = ""; }


$m0=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room0"));
$m1=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room1"));
$m2=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room2"));
$m3=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room3"));
$m4=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room4"));
$m5=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room5"));
$m6=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room6"));
$m7=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room7"));
$m8=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room8"));
$m9=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room9"));
$m10=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM room10"));


$summa=$m0[0]+$m1[0]+$m2[0]+$m3[0]+$m4[0]+$m5[0]+$m6[0]+$m7[0]+$m8[0]+$m9[0]+$m10[0]-21;

echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>\n";
echo "<!DOCTYPE wml PUBLIC \"-//WAPFORUM//DTD WML 1.2//EN\" \"http://www.wapforum.org/DTD/wml12.dtd\">\n";
echo "<wml>\n";
echo "<card id=\"statistik\" title=\"Статистика\">\n";
echo "<do type=\"options\" name=\"out\" label=\"Прихожая\"><go href=\"enter.php?id=$id&amp;ps=$ps&amp;ref=$ref\"/></do>\n";
echo "<p align=\"center\">\n";
echo $fsize1;
switch($mod) {

case '10ym':
echo "<b>Самые умные</b><br/>\n";
echo "---<br/>";
$resu = @mysql_query ("Select user,credits,credits from users order by credits desc limit 0,10;");
$i = 1;
while ($a2 = mysql_fetch_array($resu))
{
echo ($i++).") ".$a2["user"]." (".$a2["credits"]." ответов)<br/>\n";
}
break;

case 'gallery':
echo "<b>Самые красивые чатовцы</b><br/>\n";
echo "---<br/>";
$resu = @mysql_query ("Select id,user,votefoto from users where img!='' order by votefoto desc limit 0,10;");
$i = 1;
while ($a2 = mysql_fetch_array($resu))
{
echo ($i++).") ".$a2["user"]."  <a href=\"photos/".$a2['id'].".gif\">[Фото]</a> (".$a2['votefoto']." голосов)<br/>";
}
break;

case '10az':
echo "<b>Самые азартные</b><br/>\n";
echo "---<br/>";
$resu = @mysql_query ("Select user,gposts from users order by gposts desc limit 0,10;");
$i = 1;
while ($a2 = mysql_fetch_array($resu))
{
echo ($i++).") ".$a2["user"]." (".$a2["gposts"]." постов)<br/>\n";
}
break;


case '10post':
echo "<b>Самые разговорчивые</b><br/>\n";
echo "---<br/>";
$r = @mysql_query ("SELECT user,posts FROM users WHERE id != '2' ORDER BY posts desc LIMIT 0,10;");
$i = 1;
while ($a = mysql_fetch_array($r))
{
echo ($i++).") ".$a["user"]." - ".$a["posts"]."<br/>\n";
}
break;


case '10maf':
echo "<b>Криминальные авторитеты</b><br/>\n";
echo "---<br/>";
$r2 = @mysql_query ("SELECT user,mafcredits FROM users ORDER BY mafcredits  desc LIMIT 0,10;");
$i = 1;
while ($a3 = mysql_fetch_array($r2))
{
echo ($i++).") ".$a3["user"]." - ".$a3["mafcredits"]."<br/>\n";
}
break;

case 'newtoday':
$curdate=date("d-m-Y");
$r = mysql_query("SELECT id, user,posts FROM users WHERE date = '$curdate'");
echo "<b>Новички сегодня</b><br/>---<br/>\n";
if (mysql_affected_rows() == 0) {
echo "Сегодня нет новичков<br/>\n";
} else {
$a = mysql_fetch_array($r);
$i=0;
while ($a !== false){
$i++;
$nk = $a[0];
$nick = $a[1];
$posts = $a[2];
echo "$i) <a href=\"inside.php?id=$id&amp;ps=$ps&amp;nk=$nk&amp;ref=$ref\">$nick</a> (&#x043F;&#x043E;&#x0441;&#x0442;&#x043E;&#x0432;:<b> $posts</b>)<br/>\n";
$a = mysql_fetch_array($r);
}   
}
break;

case 'birthday':
$d=date("d-m-");
$y=date("Y");
$select = mysql_query ("Select id,user,birth from users where birth LIKE '%$d%'");
echo "<b>Р&#65533;мениннники сегодня</b><br/>---<br/>\n";
if (mysql_affected_rows() == 0) {
echo "Сегодня нет именинников<br/>\n";
} else { 
$i = 1;
while ($inf = @mysql_fetch_array ($select)){
$us=$inf["user"];
$usid=$inf["id"];
$birth=$inf["birth"];
$d1=substr($birth,0,2);
$m1=substr($birth,4,2);
$y1=substr($birth,6,4);
if ($y>$y1) $age=$y-$y1; else $age="(Не известно)";
if ((!$age)||($age==0)||($age=="")||($age>$y)) $age="(Не известно)"; else $age="(лет <b>".$age."</b> )\n";
echo ($i++).") <a href=\"inside.php?id=$id&amp;ps=$ps&amp;nk=$usid&amp;ref=$ref\">".$us."</a> ".$age."<br/>\n";
}
}
break;

case 'banned':
echo "<b>Забаненные</b><br/>\n";
echo "---<br/>";
$r = mysql_query("SELECT ip,soft,user FROM bannlist");
if (mysql_affected_rows() == 0) {
echo "Список банна пуст<br/>\n";
} else {
$a = mysql_fetch_array($r);
while ($a !== false){
$ip=$a["ip"];
$soft=$a["soft"];
$bannik=$a["user"];
$brauz=strtok($soft,'/');
echo "<b>РќРёРє:</b> ".$bannik." <b>IP:</b> ".$ip." /<b> SOFT: </b>".$brauz."<br/>\n";
$a = mysql_fetch_array($r);
}
}
break;

case 'admins':
echo "<b>Всеми любимые Админы</b><br/>---<br/>\n";
$r = mysql_query("SELECT id,user,posts FROM users WHERE level >= '7' and id != '100'");
if (mysql_affected_rows() == 0) {
echo "Админов нет (:<br/>\n";
} else {
$a = mysql_fetch_array($r);
while ($a !== false){
$nk = $a["id"];
$nick = $a["user"];
$posts = $a["posts"];
echo "<a href=\"inside.php?id=$id&amp;ps=$ps&amp;nk=$nk&amp;ref=$ref\">".$nick."</a> (постов: <b>".$posts."</b>)<br/>\n";
$a = mysql_fetch_array($r);
}
}
break;

case 'sysadmin':
echo "<b>Всеми любимый Супер Админ</b><br/>---<br/>\n";
$r = mysql_query("SELECT id,user,posts FROM users WHERE id = '100'");
$a = mysql_fetch_array($r);
//$nk = $a["id"];
$nick = $a["user"];
$posts = $a["posts"];
echo "<a href=\"inside.php?id=$id&amp;ps=$ps&amp;nk=100&amp;ref=$ref\">".$nick."</a> (постов: <b>".$posts."</b>)<br/>\n";
break;

case 'smoders':
echo "<b>Старшие Модеры</b><br/>---<br/>\n";
$r = mysql_query("SELECT id,user,posts FROM users WHERE level = '6'");
if (mysql_affected_rows() == 0) {
echo "Вакансия свободна<br/>\n";
} else {
$a = mysql_fetch_array($r);
while ($a !== false){
$nk = $a["id"];
$nick = $a["user"];
$posts = $a["posts"];
echo "<a href=\"inside.php?id=$id&amp;ps=$ps&amp;nk=$nk&amp;ref=$ref\">".$nick."</a> (постов: <b>".$posts."</b>)<br/>\n";
$a = mysql_fetch_array($r);
}
}
break;

case 'moders':
echo "<b>Киллеры</b><br/>---<br/>\n";
$r = mysql_query("SELECT id,user,posts FROM users WHERE level = '5'");
if (mysql_affected_rows() == 0) {
echo "Вакансия свободна<br/>\n";
} else {
$a = mysql_fetch_array($r);
while ($a !== false){
$nk = $a["id"];
$nick = $a["user"];
$posts = $a["posts"];
echo "<a href=\"inside.php?id=$id&amp;ps=$ps&amp;nk=$nk&amp;ref=$ref\">".$nick."</a> (постов: <b>".$posts."</b>)<br/>\n";
$a = mysql_fetch_array($r);
}
}
break;

case 'vips':
echo "<b>VIPo&#x432;</b><br/>---<br/>\n";
$r = mysql_query("SELECT id,user,posts FROM users WHERE level = '4'");
if (mysql_affected_rows() == 0) {
echo "Baka&#x43D;cu&#x44F; c&#x432;o&#x431;o&#x434;&#x43D;a =)<br/>\n";
} else {
$a = mysql_fetch_array($r);
while ($a !== false){
$nk = $a["id"];
$nick = $a["user"];
$posts = $a["posts"];
echo "<a href=\"inside.php?id=$id&amp;ps=$ps&amp;nk=$nk&amp;ref=$ref\">".$nick."</a> (&#x41F;oc&#x442;o&#x432;: <b>".$posts."</b>)<br/>\n";
$a = mysql_fetch_array($r);
}
}
break;

default:
echo "<b>C&#x442;a&#x442;uc&#x442;uka &#x447;a&#x442;a</b><br/>\n";
echo "---<br/>\n";
$users=mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM users"));
$usersm=mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM users where sex='Рњ'"));
$usersj=mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM users where sex='Р–'"));
echo "Bce&#x433;o &#x44E;&#x437;epo&#x432;: <b>".$users[0]."</b><br/>\n";
echo "&#x41F;ap&#x43D;e&#x439;: <b>".$usersm[0]."</b><br/>\n";
echo "&#x414;e&#x432;y&#x448;ek: <b>".$usersj[0]."</b><br/>\n";
echo "---<br/>";
$curdate=date("d-m-Y");
$newtoday=mysql_fetch_array(mysql_query("SELECT COUNT(id) from users WHERE date = '".$curdate."'"));
echo "Ho&#x432;e&#x43D;&#x44C;kue ce&#x433;o&#x434;&#x43D;&#x44F;: <a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=newtoday&amp;ref=$ref\">".$newtoday[0]."</a><br/>\n"; 
$d=date("d-m-");
$birth = mysql_fetch_array(mysql_query ("Select count(id) from users where birth LIKE '%$d%'"));
echo "&#x418;&#x43C;e&#x43D;u&#x43D;&#x43D;uku ce&#x433;o&#x434;&#x43D;&#x44F;: <a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=birthday&amp;ref=$ref\">".$birth[0]."</a><br/>\n";
$banned=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM bannlist"));
echo "&#x417;a&#x431;a&#x43D;e&#x43D;&#x44B;e IP+SOFT: <a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=banned&amp;ref=$ref\">".$banned[0]."</a><br/>\n"; 
echo "---<br/>";
$admins=mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM users where level>'6' and id != '100'"));
echo "A&#x434;&#x43C;u&#x43D;o&#x432;: <a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=admins&amp;ref=$ref\">".$admins[0]."</a><br/>\n"; 
$smods=mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM users where level='6' "));
echo "C&#x442;.&#x43C;o&#x434;epo&#x432;: <a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=smoders&amp;ref=$ref\">".$smods[0]."</a><br/>\n"; 
$mods=mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM users where level='5' "));
echo "Ku&#x43B;&#x43B;epo&#x432;: <a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=moders&amp;ref=$ref\">".$mods[0]."</a><br/>\n"; 
$vips=mysql_fetch_array(mysql_query("SELECT COUNT(id) FROM users where level='4' "));
echo "VIPo&#x432;: <a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=vips&amp;ref=$ref\">".$vips[0]."</a><br/>\n"; 
echo "---<br/>";
echo "<a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=10post&amp;ref=$ref\">Ca&#x43C;&#x44B;e &#x431;o&#x43B;&#x442;&#x43B;u&#x432;&#x44B;e &#x447;a&#x442;o&#x432;&#x446;&#x44B;</a><br/>\n"; 
echo "<a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=gallery&amp;ref=$ref\">Ca&#x43C;&#x44B;e kpacu&#x432;&#x44B;e &#x447;a&#x442;o&#x432;&#x446;&#x44B;</a><br/>\n"; 
echo "<a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=10az&amp;ref=$ref\">Ca&#x43C;&#x44B;e a&#x437;ap&#x442;&#x43D;&#x44B;e &#x447;a&#x442;o&#x432;&#x446;&#x44B;</a><br/>\n"; 
echo "<a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=10ym&amp;ref=$ref\">Ca&#x43C;&#x44B;e y&#x43C;&#x43D;&#x44B;e &#x447;a&#x442;o&#x432;&#x446;&#x44B;</a><br/>\n"; 
echo "<a href=\"statistik.php?id=$id&amp;ps=$ps&amp;mod=10maf&amp;ref=$ref\">&#x42D;&#x43B;u&#x442;a &#x43F;pec&#x442;y&#x43F;&#x43D;o&#x433;o &#x43C;upa</a><br/>\n"; 
echo "---<br/>\n";
echo "Coo&#x431;&#x449;e&#x43D;u&#x439; &#x432; &#x431;a&#x437;e: <b>".$summa."</b><br/>\n";
$letters=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM zapiski "));
echo "&#x417;a&#x43F;ucok &#x432; &#x431;a&#x437;e: <b>".$letters[0]."</b><br/>\n";
$vopros=mysql_fetch_array(mysql_query("SELECT COUNT(number) FROM bots "));
echo "Bo&#x43F;poco&#x432; &#x432; &#x431;a&#x437;e: <b>".$vopros[0]."</b><br/>\n";
$anekdots=mysql_fetch_array(mysql_query("SELECT COUNT(klu4) FROM anekdot "));
echo "&#x428;y&#x442;ok &#x432; &#x431;a&#x437;e: <b>".$anekdots[0]."</b><br/>\n";
break;
}
echo "---<br/>\n";
if ((isset($rm))&&($rm!="")&&(!isset($pwd))) echo "<a href=\"chat.php?id=$id&amp;ps=$ps&amp;rm=$rm&amp;ref=$ref\">B &#x447;a&#x442;</a><br/>\n";
if($mod) {
echo "<a href=\"statistik.php?id=$id&amp;ps=$ps&amp;ref=$ref\">C&#x442;a&#x442;uc&#x442;uka</a><br/>\n";
}
echo "<a href=\"enter.php?id=$id&amp;ps=$ps&amp;ref=$ref\">&#x41F;puxo&#x436;a&#x44F;</a><br/>\n";
echo $fsize2;
echo "</p></card></wml>";
mysql_close ($link);

?>