Файл: users/diary/inc/all.php
Строк: 82
<?
if(isset($_GET['sort']) && $_GET['sort']==1)$rating=1;
$search=NULL;
if(isset($_POST['search']) && $_POST['search']!=NULL){
header("Location:/users/diary/search/".my_esc($_POST['search'])."");
exit;
}
$null = 1;
if (isset($_SESSION['search']))$search=$_SESSION['search'];
echo "<div class='d1'><span>Поиск:</span><form action='' method='POST'><input type='text' name='search' value='".output_title(stripcslashes(htmlspecialchars($search)))."' placeholder='Введите пару слов для поиска...' style='width: 60%' /> <input type='submit' value='Поиск' /></form></div>n";
$where=NULL;
if(!isset($umodd))
{
$q=mysql_query("SELECT * FROM `diary` WHERE `sk` = '0' ORDER BY `".(isset($rating)?'rating` DESC, `time':'time')."` DESC");
while ($post = mysql_fetch_assoc($q))
{
if($post['access']=='all' || $post['access']=='friends' && mysql_result(mysql_query("SELECT COUNT(*) FROM `frends` WHERE (`user` = '$user[id]' AND `frend` = '$ank[id]') OR (`user` = '$ank[id]' AND `frend` = '$user[id]')"),0)!=0 || $post['access']=='auth' && isset($user))$where=$where." ".($where==NULL?"AND (":"OR ")."`id` = '$post[id]'";
}
if($where!=NULL)$where=$where.")";
}
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `diary` WHERE `sk` = '0'$where"),0);
$k_page=k_page($k_post,$set['p_str']);
$page=page($k_page);
$start=$set['p_str']*$page-$set['p_str'];
echo '<div class="busi_switcher">';
echo '<table width="100%">';
echo '<tr>';
echo '<td>';
echo (!isset($rating)?"<span class='active_item brd_l'>":"<a href='?p=blogs/all&sort=0' class='brd_l'>")."Новые".(!isset($rating)?"</span>":"</a>");
echo '</td>';
echo '<td>';
echo (isset($rating)?"<span class='active_item brd_r'>":"<a href='?p=blogs/all&sort=1' class='brd_r'>")."Популярные".(isset($rating)?"</span>":"</a>");
echo '</td>';
echo '</tr>';
echo '</table>';
echo '</div>';
if ($k_post==0)
{
echo "<div class='hide'>Нет записей</div>n";
}
if($k_post>0)
//echo "<div class='d2'>n";
$lq=mysql_fetch_array(mysql_query("SELECT * FROM `diary` WHERE `sk` = '0'$where ORDER BY `".(isset($rating)?'rating` ASC, `time':'time')."` ASC LIMIT $start, 1"));
$q=mysql_query("SELECT * FROM `diary` WHERE `sk` = '0'$where ORDER BY `".(isset($rating)?'rating` DESC, `time':'time')."` DESC LIMIT $start, $set[p_str]");
$num = 0;
while ($post = mysql_fetch_assoc($q))
{
if($num==1){
echo " <div class='d1'>";
$num=0;
}else{
echo "<div class='d2'>";
$num=1;}
$ank=get_user($post['id_user']);
$count_komms=mysql_result(mysql_query("SELECT COUNT(*) FROM `diary_komm` WHERE `id_diary` = '$post[id]'"),0);
echo "<img src='/users/diary/diary/".($post['poll']==1?'poll_1':'z').".png'/> <a href='/users/diary/$post[id]/read'>".($post['name']!=NULL?output_title($post['name']):text_cutter($post['text'],30)."".(text_cutter($post['text'],30)!=$post['text']?'...':null)."")."</a>n";
echo "<span style='float:right;color:grey'>".(isset($rating)?"<img src='/users/diary/diary/rating.png'/> $post[rating]":"(".vremja($post['time']).")")."</span><br/>n";
echo "<a href='/mysite/?name=$ank[nick]'><b><span style='color:#79358c'>$ank[nick]</span></b></a>".online($ank['id'])."n";
echo "<br/>n";
echo "".output_title(text_cutter($post['text'],100))."".(text_cutter($post['text'],100)!=$post['text']?"... <a href='/users/diary/$post[id]/read?p'>подробнее →</a>":null)."<br/>n";
echo "<a href='/users/diary/$post[id]/read#komms'>Обсудить".($count_komms!=0?" ($count_komms)":null)."</a><br/>n";
if($post['id']!=$lq['id'])echo "</div>n";
}
if($k_post>0)echo "</div></div></div>n";
if ($k_page>1){str("?".(isset($rating)?'rating&':null)."",$k_page,$page);} // Вывод страниц
if(isset($user))echo "<div class='d1'><img src='/users/diary/diary/add.png'/> <a href='/users/diary/create'>Создать запись</a><br/></div>n";
if(isset($umodd))echo "<div class='d1'>n<img src='/users/diary/diary/key.png'/> <a href='/users/diary/sk'>Заблокированные записи (".mysql_result(mysql_query("SELECT COUNT(*) FROM `diary` WHERE `sk` = '1'"),0).")</a>n<br/>n</div>n";
require_once ("../../core/cuctema/foot.php");
exit;
?>