opentable($locale['c100']);
echo "";
$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 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 = $_GET['c_start']+1;
if ($c_rows > 10) {
echo "
".makecommentnav($_GET['c_start'], 10, $c_rows, 3, $clink."&")."
\n";
}
while ($data = dbarray($result)) {
echo "\n";
if ((iADMIN && checkrights("C")) || (iMEMBER && $data['comment_name'] == $userdata['user_id'] && isset($data['user_name']))) {
echo "\n";
}
echo "
#".$i." | ";
if ($data['user_name']) {
echo "\n";
} else {
echo "\n";
}
echo "
".$locale['global_071'].showdate("longdate", $data['comment_datestamp'])."\n";
echo "
\n\n";
$i++;
}
if (iADMIN && checkrights("C")) {
echo "\n";
}
if ($c_rows > 10) {
echo "".makecommentnav($_GET['c_start'], 10, $c_rows, 3, $clink."&")."
\n";
}
} else {
echo $locale['c101']."\n";
}
closetable();
opentable($locale['c102']);
if (iMEMBER && (isset($_GET['c_action']) && $_GET['c_action'] == "edit") && (isset($_GET['comment_id']) && isnum($_GET['comment_id']))) {
$eresult = dbquery(
"SELECT tcm.*,user_name FROM ".DB_COMMENTS." tcm
LEFT JOIN ".DB_USERS." tcu ON tcm.comment_name=tcu.user_id
WHERE comment_id='".$_GET['comment_id']."' AND comment_item_id='".$cid."' AND comment_type='".$ctype."'"
);
if (dbrows($eresult)) {
$edata = dbarray($eresult);
if ((iADMIN && checkrights("C")) || (iMEMBER && $edata['comment_name'] == $userdata['user_id'] && isset($edata['user_name']))) {
$clink .= "&c_action=edit&comment_id=".$edata['comment_id'];
$comment_message = $edata['comment_message'];
}
} else {
$comment_message = "";
}
} else {
$comment_message = "";
}
if (iMEMBER || $settings['guestposts'] == "1") {
require_once INCLUDES."bbcode_include.php";
echo "\n";
echo "\n";
} else {
echo $locale['c105']."\n";
}
closetable();