Файл: plugins/notes/index_notes.php
Строк: 29
<?
echo '<div class="menu_razd">Дневники</div>';
echo '<div class="main_menu">';
$k_post=mysql_result(mysql_query("SELECT COUNT(*) FROM `notes` "),0);
$q=mysql_query("SELECT * FROM `notes` ORDER BY `id` DESC LIMIT 3");
if ($k_post==0)
{
echo " <div class='mess'>n";
echo "Никто не создавал дневникn";
echo " </div>n";
}
while ($post = mysql_fetch_assoc($q))
{
if ($num==0)
{
$num=1;
}elseif ($num==1)
{
$num=0;}
$k_n= mysql_result(mysql_query("SELECT COUNT(*) FROM `notes` WHERE `id` = $post[id] AND `time` > '$ftime'",$db), 0);
$ank = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = $post[id_user] LIMIT 1"));
echo " <b><a href='info.php?id=" . $ank['id'] . "'> ".group($ank['id'])." " . $ank['nick'] . "</a></b> <a href='plugins/notes/list.php?id=$post[id]'>" . text($post['name']) . "</a> <div align='right'><sup> (".vremja($post['time']).") </sup></div>";
}
echo"<hr><div align='right'> <a href='plugins/notes/index.php?sort=t'>Читать все</a></div></div>";
?>