View file wapus top english version/razdel.php

File size: 6.72Kb
<?php
//=============================
#Version WapuS_ToP_final
#Script By: Black1992
#Email: skyangel15@inbox.lv
#Icq: 414454754
#Url: http://WaPuS.pp.Ru
//=============================
include("config.php");
include("inc/config.inc.php");
include("inc/functions.inc.php");
//---------------------------------------------------------------
ini_set ('session.use_cookies', 0);
ini_set ('session.use_trans_sid', 1);
session_name('sid');
connect_to_db();
//---------------------------------------------------------------
$title=DEFAUL_PAGE_TITLE;
include_once 'head.php';

//РїСЂРѕРІРµСЂРєР°  РІРІРѕРґР° page
if (empty($_GET['p']))
{
 $page = 1;
}
elseif ($_GET['p']<1)
{
 $page = 1;
}
else
 $page=$_GET['p'];

//РїСЂРѕРІРµСЂРєР°  РІРІРѕРґР° razd
if (empty($_GET['id']))
{
 $razd = 1;
}
elseif ($_GET['id']<1)
{
 $razd = 1;
}
else
 $razd=$_GET['id'];

if (!preg_match("!^[0-9]+$!i",$razd))
{
echo "<div class=\"rek3\">\n";
echo "<b>Categories!</b>\n";
echo "</div>\n";

echo "
<div class=\"news\">
<a href=\"" . $rating_url. "index.php\">$rating_name</a>
<img src=\"/img/gt.gif\" alt=\"&gt;\" />TOP
</div>
";
include "foot_code.php";

}
// ------------------------------ РўРћРџ РІСЃРµС… СѓС‡Р°СЃС‚РЅРёРєРѕРІ -------------------------------
$today  = date("Ymd");
// РїРѕР»СѓС‡Р°РµРј РєРѕР» РІРѕ СѓС‡Р°СЃС‚РЅРёРєРѕРІ
$result = mysql_query("SELECT count(`uid`) FROM `weeks` WHERE `host` > 0 and `date`=$today and `razdel`=$razd");
$cntData = mysql_fetch_row($result);
$count_users = $cntData[0];
$max_page = ceil ($count_users / $count_top);
$page	= ($page > $max_page) ? (($max_page == 0)? $page : $max_page) : $page;
$start  = $count_top*($page-1);
$end	= $count_top;
// РїРѕР»СѓС‡Р°РµРј uid СѓС‡Р°СЃС‚РЅРёРєРѕРІ
$result=mysql_query("SELECT DISTINCT `uid`,`count`,`host`,`in`,`out` FROM weeks WHERE host > 0 and date=$today and razdel=$razd ORDER BY host DESC LIMIT $start,$end");
$count_users_on_page = mysql_num_rows($result);

$razdel_data = mysql_query("SELECT name FROM razdels WHERE id=$razd");
$razdel_data_row = mysql_fetch_array($razdel_data);
$razdel = htmlspecialchars(base64_decode($razdel_data_row['name']));
if ($razdel_data_row==0)
{
echo "<div class=\"rek3\">\n";
echo "<b>Categories!</b>\n";
echo "</div>\n";

echo "
<div class=\"news\">
<a href=\"" . $rating_url. "index.php\">$rating_name</a>
<img src=\"/img/gt.gif\" alt=\"&gt;\" />TOP
</div>
";
include "foot_code.php";

}
// Р·Р°РіРѕР»РѕРІРѕРє
echo "
<div class=\"main\">
<a href=\"razdels.php\">Categories</a> &raquo; $razdel
</div>
";

// РІС‹РІРѕРґ РёРЅС„С‹
if ($count_users==0)
{
 echo "<div class=\"rek3\">Categories</div>";
}
else
{
 for($i = 0;$i < $count_users_on_page;$i++)
 {
  $row = mysql_fetch_array($result);
  $uid = $row['uid'];
  $hits = $row['count'];
  $hosts = $row['host'];
  // РґР°РЅРЅС‹Рµ СѓС‡Р°СЃС‚РЅРёРєР°
		$user_data = mysql_query("SELECT site_name,link,info FROM users WHERE uid=$uid");
		$user_data_row = mysql_fetch_array($user_data);
		$site_name = htmlspecialchars($user_data_row['site_name']);
		$link = htmlspecialchars($user_data_row['link']);
		$info = htmlspecialchars($user_data_row['info']);

		//Р’СЃРµРіРѕ
		$res_count = mysql_query("SELECT sum(count),sum(host) FROM months WHERE uid=$uid");
		$count_row=mysql_fetch_row($res_count);
		$all_hits = (int)$count_row[0];
		$all_hosts = (int)$count_row[1];

		
		//РїРѕРґСЃС‡РёС‚С‹РІР°РµРј РѕРЅР»Р°Р№РЅ РїРѕСЃРµС‚РёС‚РµР»РµР№
		$res_count = mysql_query("SELECT count(ip) FROM online_ip WHERE uid=$uid");
		$count_row=mysql_fetch_row($res_count);
		$online=(int)$count_row[0];
		
        //РѕС†РµРЅРєР°
        $q=@mysql_query("SELECT * FROM `rat` WHERE `uid`='$uid'");
        if($r=@mysql_fetch_assoc($q)){
        $rat=round($r['rt'],1);
        $allrat=$r['allrt'];
        }else{
        $rat=0;
        $allrat=0;}
                    
		//РєРѕРјРјРµРЅС‚Р°СЂРёРё
        $komms=@mysql_query("SELECT `komm` FROM `komms` WHERE `uid`=$uid");
        $user_komms =(int)@mysql_num_rows($komms);
		
		//РџСЂРёС€Р»Рѕ\РЈС€Р»Рѕ
		$in_count = (int)$row['in'];
		$out_count = (int)$row['out'];

		
		//РћРїСЂРµРґРµР»СЏРµРј РґР°С‚Сѓ СЂРµРіРёСЃС‚СЂР°С†РёРё Рё РєР°С‚РµРіРѕСЂРёСЋ
		$mod_data = mysql_query("SELECT registration,razdel FROM users WHERE uid=$uid");
		$mod_row=mysql_fetch_array($mod_data);
		$registration = $mod_row['registration'];
		$kategory = $mod_row['razdel'];
		$reg_date = date("d.m.y", $registration);
		$kategory_mass = array(
						1=>entertainmentЃ, 2=>hobbies, 3=>Р—РЅР°РєРѕРјСЃС‚РІР°, 4=>Р”Р»СЏ_РІР·СЂРѕСЃР»С‹С…, 5=>РҐР°Р»СЏРІР°,
						6=>РњР°РіР°Р·РёРЅС‹_СѓСЃР»СѓРіРё, 7=>РњСѓР·С‹РєР°, 8=>РћР±С‰РµРЅРёРµ, 9=>Р Р°Р·РІР»РµС‡РµРЅРёСЏ, 10=>РЎРњР?_Рё_РїРѕР»РёС‚РёРєР°,
						11=>РЎРїРѕСЂС‚, 12=>РџСЂРѕС‡РёРµ);
		$kategory = $kategory_mass[$kategory];
	

		//Р’С‹РІРѕРґРёРј Р°РєС‚РёРІРЅС‹Рµ СЃР°Р№С‚С‹
		
		 echo "<div class=main>".(($i+1)+($count_top*($page-1))).". <b><a class=bb href=\"outtop.php?uid=$uid\">$site_name</a> </b><a href=\"stat.php?uid=$uid\"> ($hosts/$hits) </a>$b1[$c]<br/>";	
		 echo "$info  <br/>";                                                                                                                                                             									
		 //echo "В» Host/Hits: <b>($hosts/$hits)</b><br/>";
		 //echo "В» In top/Out top: <b>($in_count/$out_count)</b><br/>";
		 //echo "<b>All: </b>&nbsp;All hosts: $all_hosts | All hits: $all_hits<br />";
		 echo "В» <b>CategoryЏ:</b> $kategory <br/>";	
		 echo "В» Online: "; 
		 echo "<a href=\"online_tel.php?uid=$uid\">$online</a> <br/>";
		 echo "В» Rating: <a href=\"rating.php?uid=$uid\">($rat/$allrat)</a><br/>";
         echo "В» User comments: <a href=\"komms.php?uid=$uid\">($user_komms)</a><br/>";
					
					echo "</div>";
 }
}

// РїРѕСЃС‚СЂР°РЅРёС‡РЅР°СЏ РЅР°РІРёРіР°С†РёСЏ
echo "<div class=\"rek3\" align=\"center\"\n>";
if ($page>1)
 echo "<img src=\"img/back.gif\" alt=\"-\" /> <a href=\"razdel.php?id=$razd&amp;p=".($page-1)."\">Categories</a> | ";
echo "СЃС‚СЂ.<b>$page</b> РёР· ".$max_page;
if ($max_page-$page>0)
 echo " | <a href=\"razdel.php?id=$razd&amp;p=".($page+1)."\">Categories</a> <img src=\"img/next.gif\" alt=\"-\" />";
echo "<br>\n";

$in=-3;
$out=3;
if ($page!=1)
{
 echo "<a href=\"razdel.php?id=$razd&amp;p=1\">1</a>";
}
else
{
 echo "<b>1</b>";
}
for ($ot=$in; $ot<=$out; $ot++)
{
$t_str=$page+$ot;
if ($t_str>1 && $t_str<$max_page)
{
if ($in==$ot && $t_str>2)
{
echo " ... ";
}
if ($ot!=0)
{
echo " <a href=\"razdel.php?id=$razd&amp;p=$t_str\">$t_str</a>";
}
else
{
echo " <b>$t_str</b>";
}
if ($ot==$out && $t_str<$max_page-1)
{
echo " ... ";
}
}
}
if ($page!=$max_page)
{
echo " <a href=\"razdel.php?id=$razd&amp;p=$max_page\">$max_page</a>";
}
elseif ($max_page>1)
{
echo " <b>$max_page</b>";
}

echo "</div>\n";


echo "
<div class=\"news\">
<a href=\"" . $rating_url. "index.php\">$rating_name</a>
<img src=\"/img/gt.gif\" alt=\"&gt;\" />TOP
</div>
";
include "foot_code.php";

?>