db_Select("polls", "poll_title", "`poll_id` = {$id} AND `poll_comment` = 1")) {
header("location: ".e_BASE."index.php");
exit;
}
} else if($table == "news") {
if (!$sql->db_Select("news", "news_allow_comments", "`news_id` = {$id} AND `news_allow_comments` = 0")) {
header("location: ".e_BASE."index.php");
exit;
}
}
$pid = (isset($_POST['pid']) ? $_POST['pid'] : 0);
$pid = intval($pid);
$editpid = intval((isset($_POST['editpid']) ? $_POST['editpid'] : false));
$clean_authorname = $_POST['author_name'];
$clean_comment = $_POST['comment'];
$clean_subject = $_POST['subject'];
$cobj->enter_comment($clean_authorname, $clean_comment, $table, $id, $pid, $clean_subject);
if ($table == "news") {
$e107cache->clear("news");
} else {
$e107cache->clear("comment.php?{$table}.{$id}");
}
if($editpid) {
$redir = preg_replace("#\.edit.*#si", "", e_QUERY);
header("Location: ".e_SELF."?{$redir}");
exit;
}
}
if (isset($_POST['replysubmit']))
{
if ($table == "news" && !$sql->db_Select("news", "news_allow_comments", "news_id='{$nid}' ")) {
header("location:".e_BASE."index.php");
exit;
} else {
$row = $sql->db_Fetch();
if (!$row['news_id']) {
$pid = (isset($_POST['pid']) ? $_POST['pid'] : 0);
$pid = intval($pid);
$clean_authorname = $_POST['author_name'];
$clean_comment = $_POST['comment'];
$clean_subject = $_POST['subject'];
$cobj->enter_comment($clean_authorname, $clean_comment, $table, $nid, $pid, $clean_subject);
$e107cache->clear("comment.php?{$table}.{$id}");
}
$plugin_redir = false;
$handle = opendir(e_PLUGIN);
while (false !== ($file = readdir($handle))) {
if ($file != "." && $file != ".." && is_dir(e_PLUGIN.$file)) {
$plugin_handle = opendir(e_PLUGIN.$file."/");
while (false !== ($file2 = readdir($plugin_handle))) {
if ($file2 == "e_comment.php") {
require_once(e_PLUGIN.$file."/".$file2);
if ($table == $e_plug_table) {
$plugin_redir = TRUE;
break 2;
}
}
}
}
}
if ($plugin_redir)
{
echo "\n";
exit;
} elseif ($table == "news" || $table == "poll")
{
echo "\n";
exit;
} elseif($table == "bugtrack")
{
echo "\n";
exit;
} elseif($table == "faq")
{
echo "\n";
exit;
} elseif ($table == "content")
{
echo "\n";
exit;
} elseif ($table == "download")
{
echo "\n";
exit;
} elseif ($table == "page")
{
echo "\n";
exit;
}
}
}
if ($action == "reply") {
if (!$pref['nested_comments']) {
header("Location: ".e_BASE."comment.php?comment.{$table}.{$nid}");
exit;
}
$query = "`comment_id` = '{$id}' LIMIT 0,1";
if ($sql->db_Select("comments", "comment_subject", "`comment_id` = '{$id}'")) {
list($comments['comment_subject']) = $sql->db_Fetch();
$not_parsed_subject = $comments['comment_subject'];
$subject = $tp->toHTML($comments['comment_subject']);
}
if ($subject == "") {
if ($table == "news") {
if (!$sql->db_Select("news", "news_title", "news_id='{$nid}' ")) {
header("location: ".e_BASE."index.php");
exit;
} else {
list($news['news_title']) = $sql->db_Fetch();
$subject = $news['news_title'];
$title = LAN_100;
}
} elseif ($table == "poll") {
if (!$sql->db_Select("polls", "poll_title", "poll_id='{$nid}' ")) {
header("location:".e_BASE."index.php");
exit;
} else {
list($poll['poll_title']) = $sql->db_Fetch();
$subject = $poll['poll_title'];
$title = LAN_101;
}
} elseif ($table == "content") {
$sql->db_Select("content", "content_heading", "content_id='{$nid}'");
$subject = $content['content_heading'];
} elseif ($table == "bugtracker") {
$sql->db_Select("bugtrack", "bugtrack_summary", "bugtrack_id='{$nid}'");
$subject = $content['content_heading'];
}
}
if ($table == "content") {
$sql->db_Select("content", "content_type", "content_id='{$nid}'");
list($content['content_type']) = $sql->db_Fetch();
if ($content['content_type'] == "0") {
$content_type = "article";
$title = LAN_103;
} elseif ($content['content_type'] == "3") {
$content_type = "review";
$title = LAN_104;
} elseif ($content['content_type'] == "1") {
$content_type = "content";
$title = LAN_105;
}
}
define('e_PAGETITLE', $title." / ".LAN_99." / ".LAN_102.$subject."");
require_once(HEADERF);
} else {
if ($cache = $e107cache->retrieve("comment.php?{$table}.{$id}")) {
require_once(HEADERF);
echo $cache;
require_once(FOOTERF);
exit;
} else {
if ($table == "news") {
/*
changes by jalist 19/01/05:
updated db query removed one call
*/
if(isset($pref['trackbackEnabled']) && $pref['trackbackEnabled']) {
$query = "SELECT COUNT(tb.trackback_pid) AS tb_count, n.*, u.user_id, u.user_name, u.user_customtitle, nc.category_name, nc.category_icon FROM #news AS n
LEFT JOIN #user AS u ON n.news_author = u.user_id
LEFT JOIN #news_category AS nc ON n.news_category = nc.category_id
LEFT JOIN #trackback AS tb ON tb.trackback_pid = n.news_id
WHERE n.news_class IN (".USERCLASS_LIST.")
AND n.news_id={$id}
AND n.news_allow_comments=0
GROUP by n.news_id";
} else {
$query = "SELECT n.*, u.user_id, u.user_name, u.user_customtitle, nc.category_name, nc.category_icon FROM #news AS n
LEFT JOIN #user AS u ON n.news_author = u.user_id
LEFT JOIN #news_category AS nc ON n.news_category = nc.category_id
WHERE n.news_class IN (".USERCLASS_LIST.")
AND n.news_id={$id}
AND n.news_allow_comments=0";
}
if (!$sql->db_Select_gen($query)) {
header("location:".e_BASE."index.php");
exit;
} else {
$news = $sql->db_Fetch();
$subject = $tp->toForm($news['news_title']);
define("e_PAGETITLE", LAN_100." / ".LAN_99." / {$subject}");
require_once(HEADERF);
ob_start();
$ix = new news;
$ix->render_newsitem($news, "default");
$field = $news['news_id'];
$comtype = 0;
}
}
else if($table == "poll") {
if (!$sql->db_Select("polls", "*", "poll_id='{$id}'")) {
header("location:".e_BASE."index.php");
exit;
} else {
$row = $sql->db_Fetch();
$comments_poll = $row['poll_comment'];
$subject = $row['poll_title'];
define("e_PAGETITLE", LAN_101." / ".LAN_99." / ".$subject."");
require_once(HEADERF);
require(e_PLUGIN."poll/poll_menu.php");
$field = $row['poll_id'];
$comtype = 4;
if(!$comments_poll)
{
require_once(FOOTERF);
exit;
}
}
}
require_once(HEADERF);
}
}
if(isset($pref['trackbackEnabled']) && $pref['trackbackEnabled'] && $table == "news"){
echo "".$pref['trackbackString']." ".$e107->http_path.e_PLUGIN."trackback/trackback.php?pid={$id}";
}
$field = ($field ? $field : ($id ? $id : ""));
$width = (isset($width) && $width ? $width : "");
$cobj->compose_comment($table, $action, $field, $width, $subject, $rate=FALSE);
if (!strstr(e_QUERY, "poll")) {
$cache = ob_get_contents();
$e107cache->set("comment.php?{$table}.{$field}", $cache);
}
ob_end_flush(); // dump the buffer we started
if(isset($pref['trackbackEnabled']) && $pref['trackbackEnabled'] && $table == "news"){
if($sql->db_Select("trackback", "*", "trackback_pid={$id}"))
{
$tbArray = $sql -> db_getList();
if (file_exists(THEME."trackback_template.php")) {
require_once(THEME."trackback_template.php");
} else {
require_once(e_THEME."templates/trackback_template.php");
}
$text = "";
foreach($tbArray as $trackback)
{
extract($trackback);
$TITLE = $trackback_title;
$EXCERPT = $trackback_excerpt;
$BLOGNAME = "{$trackback_blogname}";
$text .= preg_replace("/\{(.*?)\}/e", '$\1', $TRACKBACK);
}
if($TRACKBACK_RENDER_METHOD)
{
$ns->tablerender("".LAN_315, $text);
}
else
{
echo "".$text;
}
}
else
{
echo "".LAN_316;
}
if (ADMIN && getperms("B")) {
echo "
";
}
}
require_once(FOOTERF);
?>