[color=red][b]opentable[/b][/color]($locale['c100']); $result = dbquery( "SELECT tcm.*,user_name FROM ".DB_PREFIX."comments tcm LEFT JOIN ".DB_PREFIX."users tcu ON tcm.comment_name=tcu.user_id WHERE comment_item_id='$cid' AND comment_type='$ctype' ORDER BY comment_datestamp ASC" ); if (dbrows($result) != 0) { $i = 0; echo "[color=red][/color]\n"; while ($data = dbarray($result)) { echo "\n[color=red]\n\n"; $i++; } if (checkrights("C")) echo "\n\n\n"; echo "
\n"; if ($data['user_name']) { echo "".$data['user_name'].""; } else { echo $data['comment_name']; } if ($data['comment_smileys'] == "1") { $comment_message = parsesmileys($data['comment_message']); } else { $comment_message = $data['comment_message']; } $comment_message = nl2br(parseubb($comment_message)); echo "\n".$locale['041'].showdate("longdate", $data['comment_datestamp'])."
\n"; echo $comment_message."
".$locale['c106']."
\n"; } else { echo $locale['c101']."\n"; } [color=red][b]closetable();[/b][/color]