View file kod.php

<?
include_once '../sys/inc/start.php';
include_once '../sys/inc/compress.php';
include_once '../sys/inc/sess.php';
include_once '../sys/inc/home.php';
include_once '../sys/inc/settings.php';
include_once '../sys/inc/db_connect.php';
include_once '../sys/inc/ipua.php';
include_once '../sys/inc/fnc.php';
include_once '../sys/inc/user.php';
$set['title']='Коды';
include_once '../sys/inc/thead.php';
title();
aut(); // форма авторизации


$top = my_esc($_GET['top']);
switch ($top) {
    case 'like':
{
echo ' <div class="main"><font color="black"> Топ по: </font><a href="kod.php?top=views">просмотрам</a><font color="black"> | рейтингу</font></div>';
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `codes`"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];

$q=mysql_query("SELECT * FROM `codes` ORDER BY `rating` DESC  LIMIT $start, $set[p_str]");
if (mysql_num_rows($q)==0) {
echo "   <tr>\n";
echo "  <td class='p_t'>\n";
echo "Кодов нет<br />";
echo "  </td>\n";
echo "   </tr>\n";
}
echo "<table class='post'>\n";
while ($res= mysql_fetch_array($q)){

$us=get_user($res['id_user']);

echo '<div class="main_menu">';

echo '<img src="img/user.png"><a href="/info.php?id='.$res['id_user'].'"><font color="black"> <b>'.$us['nick'].'</b></font> <a/>: <a href="code.php?id='.$res['id'].'"> '.$res['name'].'</a> [<font color="green"><b>'.$res['rating'].'</b></font>]<br/>';
echo '</div>';
}
}
break;
    case 'views':
{
echo ' <div class="main"><font color="black"> Топ по: просмотрам |</font><a href="kod.php?top=like"> рейтингу</a></div>';
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `codes`"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];

$q=mysql_query("SELECT * FROM `codes` ORDER BY `views` DESC  LIMIT $start, $set[p_str]");
if (mysql_num_rows($q)==0) {
echo "   <tr>\n";
echo "  <td class='p_t'>\n";
echo "Кодов нет<br />";
echo "  </td>\n";
echo "   </tr>\n";
}
echo "<table class='post'>\n";
while ($res= mysql_fetch_array($q)){

$us=get_user($res['id_user']);

echo '<div class="main_menu">';

echo '<img src="img/user.png"><a href="/info.php?id='.$res['id_user'].'"><font color="black"> <b>'.$us['nick'].'</b></font> <a/>: <a href="code.php?id='.$res['id'].'"> '.$res['name'].'</a> [<font color="green"><b>'.$res['views'].'</b></font>]<br/>';
echo '</div>';
}
}
break;




default:



$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `codes`"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];

$q=mysql_query("SELECT * FROM `codes` ORDER BY `time` DESC  LIMIT $start, $set[p_str]");
if (mysql_num_rows($q)==0) {
echo "   <tr>\n";
echo "  <td class='p_t'>\n";
echo "Кодов нет<br />";
echo "  </td>\n";
echo "   </tr>\n";
}
echo "<table class='post'>\n";
while ($res= mysql_fetch_array($q)){

$us=get_user($res['id_user']);

echo '<div class="main_menu">';
$like = mysql_result(mysql_query("SELECT COUNT(*) FROM `codes_like` WHERE `id_codes` = '".$res['id']."'  LIMIT 1"),0);

echo '<img src="img/user.png"><a href="/info.php?id='.$res['id_user'].'"><font color="black"> <b>'.$us['nick'].'</b></font> <a/>: <a href="code.php?id='.$res['id'].'"> '.$res['name'].'</a> [<font color="green"><b>'.$like.'</b></font>]<br/>';
 
   
   
   
   echo '</div>';




}
}
echo "</table>\n";

if ($k_page>1)str("?",$k_page,$page); // Вывод страниц

echo '<div class="foot"><img src="/style/icons/str2.gif"> <a href="index.php?">Назад</a></div>';

include_once '../sys/inc/tfoot.php';
?>