$res_post_read = sql_query('SELECT last_post_read FROM read_posts WHERE user_id=' . $CURUSER['id'] . ' AND topic_id=' . $arr_unread['topic_id']);
$arr_post_read = mysql_fetch_row($res_post_read);
$did_i_post_here = sql_query('SELECT user_id FROM posts WHERE user_id=' . $CURUSER['id'] . ' AND topic_id=' . $arr_unread['topic_id']);
$posted = mysql_num_rows($did_i_post_here) > 0 ? 1 : 0;
if ($arr_post_read[0] < $arr_unread['last_post'] && $posted) {
//=== change colors
$colour = ++$colour % 2;
$class = $colour == 0 ? 'one' : 'two';
$locked = $arr_unread['locked'] == 'yes';
$sticky = $arr_unread['sticky'] == 'yes';
$topic_poll = $arr_unread['poll_id'] > 0;
$first_unread_poster = sql_query('SELECT added FROM posts WHERE status = \'ok\' AND topic_id=' . $arr_unread['topic_id'] . ' ORDER BY id ASC LIMIT 1');
$first_unread_poster_arr = mysql_fetch_row($first_unread_poster);
$thread_starter = ($arr_unread['username'] !== '' ? print_user_stuff($arr_unread) : 'Lost [' . $arr_unread['id'] . ']') . '<br />' . get_date($first_unread_poster_arr[0], '');
$topicpic = $arr_unread['post_count'] < 30 ? $locked ? 'lockednew' : 'topicnew' : ($locked ? 'lockednew' : 'hot_topic_new');
$rpic = $arr_unread['num_ratings'] != 0 ? ratingpic_forums(ROUND($arr_unread['rating_sum'] / $arr_unread['num_ratings'], 1)) : '';
$sub = sql_query('SELECT user_id FROM subscriptions WHERE user_id=' . $CURUSER['id'] . ' AND topic_id=' . $arr_unread['topic_id']);
$subscriptions = mysql_num_rows($sub) > 0 ? 1 : 0;
$icon = $arr_unread['icon'] == '' ? '<img src="pic/forums/topic_normal.gif" alt="Topic" title="Topic" />' : '<img src="pic/smilies/' . htmlspecialchars($arr_unread['icon']) . '.gif" alt="' . htmlspecialchars($arr_unread['icon']) . '" title="' . htmlspecialchars($arr_unread['icon']) . '" />';
$first_post_text = tool_tip(' <img src="pic/forums/mg.gif" height="14" alt="Preview" title="Preview" />', format_comment($arr_unread['body']), 'Last Post Preview');
$topic_name = ($sticky ? '<img src="pic/forums/pinned.gif" alt="Pinned" title="Pinned" /> ' : ' ') . ($topicpoll ? '<img src="pic/forums/poll.gif" alt="Poll" title="Poll" /> ' : ' ') . '
<a class="altlink" href="?action=view_topic&topic_id=' . $arr_unread['topic_id'] . '" title="First post in thread">' . htmlentities($arr_unread['topic_name'], ENT_QUOTES) . '</a>
<a class="altlink" href="forums.php?action=view_topic&topic_id=' . $arr_unread['topic_id'] . '&page=0#' . $arr_post_read[0] . '" title="First unread post in this thread"><img src="pic/forums/last_post.gif" alt="First unread post" title="First unread post" /></a>
' . ($posted ? '<img src="pic/forums/posted.gif" alt="Posted" title="Posted" /> ' : ' ') . ($subscriptions ? '<img src="pic/forums/subscriptions.gif" alt="subscribed" title="subscribed" /> ' : ' ') . ' <img src="pic/forums/new.gif" alt="New post in topic!" title="New post in topic!" />';
//=== print here
$HTMLOUT .= '<tr>
<td class="' . $class . '" align="center"><img src="pic/forums/' . $topicpic . '.gif" alt="topic" title="topic" /></td>
<td class="' . $class . '" align="center">' . $icon . '</td>
<td align="left" valign="middle" class="' . $class . '">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
break;
case $total_pages < 11:
$multi_pages = ' <span style="font-size: xx-small;"> <img src="' . $INSTALLER09['pic_base_url'] . 'forums/multipage.gif" alt="+" title="+" />';
for ($i = 1; $i < $total_pages; ++$i) {
$multi_pages .= ' <a class="altlink" href="' . $INSTALLER09['baseurl'] . '/forums.php?action=view_topic&topic_id=' . $topic_id . '&page=' . $i . '">' . $i . '</a>';
}
$multi_pages .= '</span>';
break;
}
$new = $arr_post_stuff['added'] > TIME_NOW - $readpost_expiry ? !$last_unread_post_res || $last_post_id > $last_unread_post_id : 0;
$topic_pic = $posts < 30 ? $locked ? $new ? 'lockednew' : 'locked' : ($new ? 'topicnew' : 'topic') : ($locked ? $new ? 'lockednew' : 'locked' : ($new ? 'hot_topic_new' : 'hot_topic'));
$topic_name = ($sticky ? '<img src="' . $INSTALLER09['pic_base_url'] . 'forums/pinned.gif" alt="Pinned" title="Pinned" /> ' : ' ') . ($topic_poll ? '<img src="' . $INSTALLER09['pic_base_url'] . 'forums/poll.gif" alt="Poll:" title="Poll" /> ' : ' ') . ' <a class="altlink" href="?action=view_topic&topic_id=' . $topic_id . '">' . htmlsafechars($topic_arr['topic_name'], ENT_QUOTES) . '</a> ' . ($posted ? '<img src="' . $INSTALLER09['pic_base_url'] . 'forums/posted.gif" alt="Posted" title="Posted" /> ' : ' ') . ($subscriptions ? '<img src="' . $INSTALLER09['pic_base_url'] . 'forums/subscriptions.gif" alt="subscribed" title="Subcribed" /> ' : ' ') . ($new ? ' <img src="' . $INSTALLER09['pic_base_url'] . 'forums/new.gif" alt="New post in topic!" title="New post in topic!" />' : '') . $multi_pages;
//=== change colors
$colour = ++$colour % 2;
$class = $colour == 0 ? 'one' : 'two';
$rpic = $topic_arr['num_ratings'] != 0 ? ratingpic_forums(ROUND($topic_arr['rating_sum'] / $topic_arr['num_ratings'], 1)) : '';
//=== delete thread //= .$delete_me
if ($CURUSER['class'] == UC_MAX && $forum_id === 2) {
$delete_me = ' <span style="font-size: x-small;">[ <a class="altlink" href="' . $INSTALLER09['baseurl'] . '/forums.php?action=delete_topic&topic_id=' . $topic_id . '&sure=1&send_me_back=666">Delete</a> ]</span>';
}
$content .= '<tr>
<td class="' . $class . '" align="center"><img src="' . $INSTALLER09['pic_base_url'] . 'forums/' . $topic_pic . '.gif" alt="topic" title="Topic" /></td>
<td class="' . $class . '" align="center">' . $icon . '</td>
<td align="left" valign="middle" class="' . $class . '">
<table border="0" cellspacing="0" cellpadding="0">
<tr>
<td class="' . $class . '" align="left">' . $topic_name . $first_post_text . $topic_status_image . '</td>
<td class="' . $class . '" align="right">' . $rpic . '</td>
</tr>
</table>
' . ($topic_arr['topic_desc'] !== '' ? '► <span style="font-size: x-small;">' . htmlsafechars($topic_arr['topic_desc'], ENT_QUOTES) . '</span>' : '') . '</td>
