Просмотр файла love/users.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();
$sort='id';

$por='DESC';

if (isset($_GET['ASC']))$por='ASC'; // прямой порядок
if (isset($_GET['DESC']))$por='DESC'; // обратный порядок


switch (@$_GET['sort']) {
	case 'balls':$sql_sort='`user`.`balls`';$sort='balls'; // баллы
 	break;
	case 'level':$sql_sort='`user_group`.`level`';$sort='level'; // уровень
 	break;
	case 'rating':$sql_sort='`user`.`rating`';$sort='rating'; // рейтинг
 	break;
	case 'pol':$sql_sort='`user`.`pol`';$sort='pol'; // пол
 	break;
 	default:$sql_sort='`user`.`id`';$sort='id'; // ID
 	break;
}


$usearch=NULL;
if (isset($_SESSION['usearch']))$usearch=$_SESSION['usearch'];
if (isset($_POST['usearch']))$usearch=$_POST['usearch'];

if ($usearch==NULL)
unset($_SESSION['usearch']);
else
$_SESSION['usearch']=$usearch;



if (isset($_GET['go']) && $usearch)
{
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `user` WHERE `nick` like '%".mysql_escape_string($usearch)."%' OR `id` = '".intval($usearch)."'"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];


$smarty = new Smarty_conf();
$menu=array();
$menu[]=array("?go&amp;sort=balls&amp;DESC&amp;page=$page",'баллы',$sort=='balls');
$menu[]=array("?go&amp;sort=level&amp;DESC&amp;page=$page",'статус',$sort=='level');
$menu[]=array("?go&amp;sort=rating&amp;DESC&amp;page=$page",'рейтинг',$sort=='rating');
$menu[]=array("?go&amp;sort=id&amp;ASC&amp;page=$page",'ID',($sort=='id' && isset($_GET['ASC'])));
$menu[]=array("?go&amp;sort=pol&amp;ASC&amp;page=$page",'пол',$sort=='pol');
$menu[]=array("?go&amp;sort=id&amp;DESC&amp;page=$page",'новые',($sort=='id' && isset($_GET['DESC'])));
$smarty->assign('menu',$menu);
$smarty->assign('menu_title','Сорт');
$smarty->display('links.select.tpl');


$listing = new Smarty_conf();
$posts=array();
$q=mysql_query("SELECT `id` FROM `user` WHERE `nick` like '%".my_esc($usearch)."%' OR `id` = '".intval($usearch)."' ORDER BY `$sort` $por LIMIT $start, $set[p_str]");
while ($ank = mysql_fetch_assoc($q))
{
$ank=get_user($ank['id']);
$title_post="<a href='/info.php?id=$ank[id]'>$ank[nick]</a>".online($ank['id']);
$post_post=false;
if ($ank['level'])$post_post.=$ank['group_name']."<br />\n";
if ($sort=='rating')$post_post.='Рейтинг: '.$ank['rating']."<br />\n";
if ($sort=='balls')$post_post.='Баллы: '.$ank['balls']."<br />\n";
if ($sort=='pol')$post_post.='Пол: '.($ank['pol']?'мужской':'женский')."<br />\n";
if ($sort=='id')$post_post.='Регистрация: '.vremja($ank['date_reg'])."<br />\n";
$post_post.='Посл. посещение: '.vremja($ank['date_last'])."<br />\n";
if (user_access('user_prof_edit') && $user['level']>$ank['level'])
$post_post.="<a href='/adm_panel/user.php?id=$ank[id]'>Редактировать профиль</a><br />\n";
$posts[]=array('icon'=> array('size'=>'small','src'=> ICONS_USER.'pol_'.$ank['pol'].'.png'),
'title'=> $title_post,
'post' => $post_post,
'link_block' => "/info.php?id=$ank[id]"

);
}
if (!$posts)$posts[]=array('title' => 'Поиск завершился неудачей');
$listing->assign('post',$posts);
$listing->display('body.conlentlist.tpl');
if ($k_page>1)str("users.php?go&amp;sort=$sort&amp;$por&amp;",$k_page,$page); // Вывод страниц
}
else
{

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



$smarty = new Smarty_conf();
$menu=array();
$menu[]=array("?sort=balls&amp;DESC&amp;page=$page",'баллы',$sort=='balls');
$menu[]=array("?sort=level&amp;DESC&amp;page=$page",'статус',$sort=='level');
$menu[]=array("?sort=rating&amp;DESC&amp;page=$page",'рейтинг',$sort=='rating');
$menu[]=array("?sort=id&amp;ASC&amp;page=$page",'ID',($sort=='id' && isset($_GET['ASC'])));
$menu[]=array("?sort=pol&amp;ASC&amp;page=$page",'пол',$sort=='pol');
$menu[]=array("?sort=id&amp;DESC&amp;page=$page",'новые',($sort=='id' && isset($_GET['DESC'])));
$smarty->assign('menu',$menu);
$smarty->assign('menu_title','Сорт');
$smarty->display('links.select.tpl');


$listing = new Smarty_conf();
$posts=array();


$q=mysql_query("SELECT `user`.`id` FROM `user` LEFT JOIN `user_group` ON `user`.`group_access` = `user_group`.`id` ORDER BY $sql_sort $por LIMIT $start, $set[p_str]");
while ($ank = mysql_fetch_assoc($q))
{
$ank=get_user($ank['id']);
$title_post="<a href='/info.php?id=$ank[id]'>$ank[nick]</a>".online($ank['id']);
$post_post=false;
if ($ank['group_access'])$post_post.=$ank['group_name']."<br />\n";
if ($sort=='rating')$post_post.='Рейтинг: '.$ank['rating']."<br />\n";
if ($sort=='balls')$post_post.='Баллы: '.$ank['balls']."<br />\n";
if ($sort=='pol')$post_post.='Пол: '.($ank['pol']?'мужской':'женский')."<br />\n";
if ($sort=='id')$post_post.='Регистрация: '.vremja($ank['date_reg'])."<br />\n";
$post_post.='Посл. посещение: '.vremja($ank['date_last'])."<br />\n";
if (user_access('user_prof_edit') && $user['level']>$ank['level'])
$post_post.="<a href='/adm_panel/user.php?id=$ank[id]'>Редактировать профиль</a><br />\n";
$posts[]=array('icon'=> array('size'=>'small','src'=> ICONS_USER.'pol_'.$ank['pol'].'.png'),
'title'=> $title_post,
'post' => $post_post,
'link_block' => "/info.php?id=$ank[id]");
}
if (!$posts)$posts[]=array('title' => 'Пользователи отсутствуют');
$listing->assign('post',$posts);
$listing->display('body.conlentlist.tpl');
if ($k_page>1)str("users.php?sort=$sort&amp;$por&amp;",$k_page,$page); // Вывод страниц

}





$smarty = new Smarty_conf();
$smarty->assign('form_title','Поиск пользователя');
$smarty->assign('method','POST');
$smarty->assign('cancel',"?$passgen");
$smarty->assign('action',"?go&amp;sort=$sort&amp;$por");
$elements=array();
$elements[]=array('type'=>'input_text', 'title' => 'ID или НИК', 'br'=>1, 'info'=>array('name' => 'usearch','value'=>$usearch));
$elements[]=array('type'=>'submit', 'br'=>0, 'info'=>array('value'=>'Начать поиск')); // кнопка
$smarty->assign('el',$elements);
$smarty->display('input.form.tpl');

echo '<hr color="DeepSkyBlue1" hr noshade size="1"></font>';
echo "&laquo;<a href='/love/index.php'>В знакомства</a><br/>\n";
include_once '../sys/inc/tfoot.php';
?>