Файл: modules/forum/_widget.php
Строк: 15
<?php
$topic_r = $db->query("SELECT * FROM `forum_t` WHERE `time_last_post` > '". (time()-60*60*24) ."'")->rowCount();
if($topic_r !=0)
{
$topic_q = $db->query("SELECT * FROM `forum_t` WHERE `time_last_post` > '". (time()-60*60*24) ."' ORDER BY time_last_post DESC LIMIT 0, 6");
while($topic = $topic_q->fetch())
{
echo '<div class="post">';
if ($topic['closed'] == 1 && $topic['attach'] == 1) echo img('pin-closed.png');
else if ($topic['attach'] == 1) echo img('pin.png');
else if ($topic['closed'] == 1) echo img('topic_closed.png');
else echo img('topic.png');
if ($db->query("SELECT * FROM `forum_vote` WHERE `topic_id` = '". $topic['id'] ."' AND `type` = '1'")->rowCount() > 0) echo img('rating.png');
$topic_a = $db->query("SELECT * FROM `forum_pt` WHERE `topic_id` = '". $topic['id']."' ORDER BY time DESC LIMIT 1")->fetch();
echo '<a href="/forum/topic/'. $topic['id'] .'">'. $topic['name'] .'</a> ('. $db->query("SELECT id FROM `forum_pt` WHERE `topic_id` = '". $topic['id'] ."'")->rowCount().')<a href="/forum/topic/'. $topic['id'] .'?page=end">»</a> <br/> [<small class="gray">'. tnick($topic_a['user_id']).' / '. rtime($topic_a['time']).'</small>]
</div>';
}
}