show with a picture when there are new post on a thread.

Started by xxx, January 07, 2006, 02:49:14 PM

Previous topic - Next topic

xxx

I have a favorite thread and a want to show with a banner when there is a reply on it.
This gives a database error.
Quote
echo '

<div class="tborder"><table border="0" width="100%" cellspacing="1" cellpadding="4"> ';
echo '
<div class="tborder"><table border="0" width="100%" cellspacing="1" cellpadding="6">
<tr><td class="windowbg2" width="100%" align="center">
<a href="http://www.xxxforum.be/index.php?topic=2263.0">';
   $result = db_query("
      SELECT
         b.ID_BOARD, b.name, b.description, b.numTopics, b.numPosts,
         m.posterName, m.posterTime, m.subject, m.ID_MSG, m.ID_TOPIC,
         IFNULL(mem.realName, m.posterName) AS realName, " . (!$user_info['is_guest'] ? "
         (IFNULL(lb.logTime, 0) >= b.lastUpdated) AS isRead," : "1 AS isRead,") . "
         IFNULL(mem.ID_MEMBER, 0) AS ID_MEMBER, IFNULL(mem2.ID_MEMBER, 0) AS ID_MODERATOR,
         mem2.realName AS modRealName
      FROM {$db_prefix}boards AS b
         LEFT JOIN {$db_prefix}messages AS m ON (m.ID_MSG = b.ID_LAST_MSG)
         LEFT JOIN {$db_prefix}members AS mem ON (mem.ID_MEMBER = m.ID_MEMBER)" . (!$user_info['is_guest'] ? "
         LEFT JOIN {$db_prefix}log_boards AS lb ON (lb.ID_BOARD = b.ID_BOARD AND lb.ID_MEMBER = $ID_MEMBER)" : '') . "
         LEFT JOIN {$db_prefix}moderators AS mods ON (mods.ID_BOARD = b.ID_BOARD)
         LEFT JOIN {$db_prefix}members AS mem2 ON (mem2.ID_MEMBER = mods.ID_MEMBER)
      WHERE m.ID_TOPIC = 2263.0
AND $user_info[query_see_board]", __FILE__, __LINE__);

while ($row_board = mysql_fetch_assoc($result))
{
$new = empty($row_board['isRead']) && $row_board['posterName'] != '';
}
mysql_free_result($result);
if ($new)
{
echo '<img src="<http://www.mijnforum.be/kroeg1.jpg>" border="0" alt="Kg"/>';
}
else
{
echo '<img src="<http://www.mijnforum.be/kroeg.jpg>" border="0" alt="Kroeg"/>';
}
echo '</a></td>
</tr></div>';
     
echo '
</table></div>';


Anyone who can fix it??????
http://www.xxxforum.be: 18+ forum!!!

Advertisement: