opentable($locale['c100']);
$c_rows = dbcount("(comment_id)", DB_COMMENTS, "comment_item_id='$cid' AND comment_type='$ctype'");
if (!isset($_GET['c_start']) || !isnum($_GET['c_start'])) { $_GET['c_start'] = 0; }
$result = dbquery(
"SELECT tcm.*,user_name, user_avatar, user_id, user_posts, user_joined, user_location, user_lastvisit FROM ".DB_COMMENTS." tcm
LEFT JOIN ".DB_USERS." tcu ON tcm.comment_name=tcu.user_id
WHERE comment_item_id='$cid' AND comment_type='$ctype'
ORDER BY comment_datestamp ASC LIMIT ".$_GET['c_start'].",10"
);
if (dbrows($result)) {
$i = 0;
if ($c_rows > 10) {
echo "".makecommentnav($_GET['c_start'], 10, $c_rows, 3, $clink."&")."
\n";
}
echo "\n";
while ($data = dbarray($result)) {
echo "\n| \n";
if ($current_row > 1) { echo " |
\n | \n
\n"; }
echo "\n| ".$data['user_name']." | \n";
echo "\n";
echo "\n";
if ((iADMIN && checkrights("C")) || (iMEMBER && $data['comment_name'] == $userdata['user_id'] && isset($data['user_name']))) {
echo " ![".$locale[](".THEME."forum/delete.gif) \n";
echo " ![".$locale[](".THEME."forum/edit.gif) \n";}
echo " | \n";
echo "
\n\n\n";
if ($data['user_avatar'] && file_exists(IMAGES."avatars/".$data['user_avatar'])) {
echo "\n";
echo "![".$locale[](".IMAGES."avatars/".$data[)
\n";
echo "\n";
} else {
echo "\n";
echo "![](".IMAGES."/imagenotfound.jpg)
\n";
echo "\n";
}
echo "";
echo "Posts: ".$data['user_posts']."
\n";
echo "Joined: ".showdate("%d.%m.%y", $data['user_joined'])."
\n";
echo "From: ".$data['user_location']."
\n";
echo "
| \n\n";
echo "".nl2br(parseubb(parsesmileys($data['comment_message'])))."\n";
$i++;
}
echo " |
\n";
if ($c_rows > 10) {
echo "".makecommentnav($_GET['c_start'], 10, $c_rows, 3, $clink."&")."
\n";
}
} else {
echo $locale['c101']."\n";
}
closetable();