File size: 1.59Kb
<div class="widgets-group"> <div class="b-title b-title_first"> <a class="b-title__link" href="/plugins/notes/"> Недавние публикации <span class="b-title__all">Все <span class="ico ico_arrow"></span></span> </a> </div>
<?
$q=mysql_query("SELECT * FROM `notes` ORDER BY `time` DESC LIMIT 3");
if(mysql_num_rows($q)==0){
?><div class="list-link blog-item_short">Записей нет</div>
<div class="cl"></div> </div> <div class="cl"></div> </div> </div> <div class="cl"></div> </a>
<?php
}else{
while($post=mysql_fetch_assoc($q)){
echo '<a href="/plugins/notes/list.php?id='.$post['id'].'" class="list-link blog-item_short"> <div class="oh"> <span class="right"> <span class="blog-item__time">'.vremja($post['time']).'</span> </span> <div class="blog-item__author no-break">
<img class="online_status_ico">
'.group($user['id']).' </img>
' . $user['nick'] . '
</div>
<div class="blog-item__title">'.text($post['name']).'</div> </div> <div> <div> <div class="blog-item__subject"> <div> '.$note_text =$post['msg'].' </div> </div> <div class="blog-item__attaches"> <div> </div>
<div class="blog-toolbar">
<span class=" left"> <span>Комментарии:</span> </span> <span class="right"> <span class="ico ico_com"></span> <span class="m">'. $count_comm =mysql_result(mysql_query("SELECT COUNT(`id`) FROM `notes_komm` WHERE `id_notes`='".$post['id']."'"),0).'</span> </span> </div>
<div class="cl"></div> </div>
<div class="cl"></div> </div>
</div> <div class="cl"></div></a> ';
?>
<?
}
?></div><?
}
?>