Файл: inc/microblog/all.php
Строк: 37
<?
if (!isset($_GET['id']) || !is_numeric($_GET['id']))
{
header("Location: /");
}
$id=intval($_GET['id']);
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_user` WHERE `id` = '$id' LIMIT 1"));
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `microblog` WHERE `uid` = '$id'"),0);
$k_page=k_page($k_post,$set['p_str3']);
$page=page($k_page);
$start=$set['p_str3']*$page-$set['p_str3'];
echo "<div class='event'><center>";
echo "".on_k($ank['id'])." ";
echo "<a href='?user=$id'>";
echo "$ank[nick]";
echo "</a>";
echo "</center></div>";
echo "<div class='block'>";
echo '<img src="images/img/act.edit.png" alt="" /> Всего '.$k_post.' микроблогов';
echo "</div>";
if ($k_post==0)echo'<div class="event"><center>Нет микроблогов</center></div>';
$q=mysql_query("SELECT * FROM `microblog` WHERE `uid` = '$id' ORDER BY `id` DESC LIMIT $start, $set[p_str3]");
while ($post = mysql_fetch_array($q))
{
$ank=mysql_fetch_array(mysql_query("SELECT * FROM `kolhoz_user` WHERE `id` = '$post[uid]' LIMIT 1"));
echo "<a href='?microblog&id=$post[id]'><div class='block'>";
echo "".(output_text(htmlspecialchars($post['text'])))."</div></a>";
$komms=mysql_result(mysql_query("SELECT COUNT(*) FROM `microblog_komm` WHERE `id_blog` = '$post[id]'"),0);
$superall=mysql_result(mysql_query("SELECT COUNT(*) FROM `microblog_klass` WHERE `id_blog` = '$post[id]'"),0);
$superyou=mysql_result(mysql_query("SELECT COUNT(*) FROM `microblog_klass` WHERE `id_blog` = '$post[id]' AND `uid` = '$ku[id]'"),0);
$see=mysql_result(mysql_query("SELECT COUNT(*) FROM `microblog_see` WHERE `id_blog` = '$post[id]'"),0);
$superother=$superall-$superyou;
echo "<div class='event'><img src='images/img/bubl.png' alt='' /> $komms • ";
if ($superyou!=0)
{
echo "<img src='images/img/cls.png' alt='' /> Вы <span style='text-decoration:underline'>и ещё <a href='?klasslist&id=$post[id]'>$superother чел.</a></span>";
}
if ($superyou==0)
{
echo "<img src='images/img/cls.png' alt='' /> <a href='?klass&id=$post[id]'>Kласс!</a> <span style='text-decoration:underline'><a href='?klasslist&id=$post[id]'>$superother чел.</a></span>";
}
echo " • <span style='color:red'>".vremja($post['time'])."</span>";
echo " • <img src='images/img/eye.png' alt='' /> <a href='?see&id=$post[id]'>$see</a>";
echo "</div>";
if (isset($ku) && $ku['id']==$post['uid'])
{
echo "<div class='block'><img src='images/img/deletemail.gif' alt='' /> <a href='?delete_mcrbl&id=$post[id]'>Удалить микроблог</a></div>";
}
}
echo'<div class="block">'; if ($k_page>1)str("?als&id=$id&",$k_page,$page); // Вывод страниц echo'</div>';
if ($ku['id']==$id)
{
echo "<div class='block'><a href='?create'>Создать микроблог</a></div>";
}
echo "<div class='block'><a href='?user=$id'>На личную страничку</a></div></div>";
include_once 'inc/foot.php';
?>