assign("output", "
" . $title . "
" . write_error($text));
$tpl->printToScreen();
dbclose();
exit();
}
if($nid) {
$output .= ""._NEWS."
";
if(isset($_POST['submit']) && isset($_POST['comment']) && is_string($_POST['comment']))
{
$comment = escapestring(format_story(replace_naughty(strip_tags($_POST['comment'], $allowed_tags))));
$ef_news_ok = (bool)dbrow(dbquery("SELECT nid FROM ".TABLEPREFIX."fanfiction_news WHERE nid = '$nid' LIMIT 1"));
if(!$cid && USERUID && $newscomments && $ef_news_ok && trim($comment) !== "") {
$insert = dbquery("INSERT INTO ".TABLEPREFIX."fanfiction_comments (nid, uid, comment, time) VALUES ('$nid', '".(int)USERUID."', '$comment', now())");
if($insert) dbquery("UPDATE ".TABLEPREFIX."fanfiction_news SET comments = comments + 1 WHERE nid = '$nid' LIMIT 1");
}
else if($cid && isADMIN && uLEVEL < 4) {
dbquery("UPDATE ".TABLEPREFIX."fanfiction_comments SET comment = '$comment' WHERE cid = '$cid' AND nid = '$nid'");
}
else accessDenied( );
unset($comment);
}
if(isset($_GET['del']) && isADMIN && uLEVEL < 4 && !empty($cid)) {
$insert = dbquery("DELETE FROM ".TABLEPREFIX."fanfiction_comments WHERE cid = '$cid'");
if($insert) dbquery("UPDATE ".TABLEPREFIX."fanfiction_news SET comments = comments - 1 WHERE nid = '$nid' LIMIT 1");
}
$newsquery = dbquery("SELECT n.*, n.time as date FROM ".TABLEPREFIX."fanfiction_news as n WHERE n.nid = '$nid' LIMIT 1");
$stories = dbassoc($newsquery);
if(file_exists("./$skindir/newsbox.tpl"))
$news = new TemplatePower( "./$skindir/newsbox.tpl" );
else $news = new TemplatePower( "./default_tpls/newsbox.tpl" );
if(!$stories) {
$current = "newserror";
// load our template files to set up the page.
if (file_exists("$skindir/default.tpl")) $tpl = new TemplatePower("$skindir/default.tpl");
else $tpl = new TemplatePower("default_tpls/default.tpl");
$title = "News entry was not found";
$text = "News entry with ID " . $nid . " is not in database";
include("includes/pagesetup.php");
$tpl->assign("output", "" . $title . "
" . write_error($text));
$tpl->printToScreen();
dbclose();
exit();
}
$news->prepare( );
//create a new number_row block
$news->newBlock("newsbox");
//assign values
$news->assign("newstitle" , stripslashes($stories['title']) );
$news->assign("newsstory" , format_story($stories['story']) );
$news->assign("newsauthor", stripslashes($stories['author']) );
$news->assign("newsid", $stories['nid']);
$news->assign("oddeven", "odd");
$news->assign("skindir", $skindir);
$news->assign("newsdate", date("$dateformat $timeformat", $stories['date']) );
if($newscomments)
$news->assign("newscomments", "".$stories['comments']." "._COMMENTS."");
if(isADMIN && uLEVEL < 4)
$news->assign("adminoptions", ""._EDIT." | "._DELETE."");
$output .= $news->getOutputContent( );
$cquery = dbquery("SELECT COUNT(cid) FROM ".TABLEPREFIX."fanfiction_comments WHERE nid = '$nid'");
list($ccount) = dbrow($cquery);
if($ccount) {
$query2 = dbquery("SELECT c.*, "._PENNAMEFIELD." as penname, c.time as date FROM ".TABLEPREFIX."fanfiction_comments as c LEFT JOIN "._AUTHORTABLE." ON c.uid = "._UIDFIELD." WHERE c.nid = '$nid' ORDER BY time LIMIT $offset, $itemsperpage");
$output .= "";
if(file_exists("$skindir/comments.tpl")) $c = new TemplatePower( "$skindir/comments.tpl" );
else $c = new TemplatePower( "default_tpls/comments.tpl" );
$c->prepare( );
$count = 0;
while($comments = dbassoc($query2)) {
$c->newBlock("commentbox");
$c->assign("comment", format_story($comments['comment']));
$c->assign("uname", $comments['penname']);
$c->assign("date", date("$dateformat $timeformat", $comments['date']));
if(isADMIN && uLEVEL < 4)
$c->assign("adminoptions", "");
$c->assign("oddeven", ($count % 2 ? "odd" : "even"));
$count++;
}
$output .= $c->getOutputContent( );
if($ccount > $itemsperpage) $output .= build_pagelinks("news.php?nid=$nid&", $ccount, $offset);
}
if(isMEMBER) {
$output .= "";
}
$tpl->assign("output", $output);
}
else {
$output .= ""._NEWS."
";
if(file_exists("./$skindir/newsbox.tpl"))
$news = new TemplatePower( "./$skindir/newsbox.tpl" );
else $news = new TemplatePower( "./default_tpls/newsbox.tpl" );
$news->prepare( );
$cquery = dbquery("SELECT count(nid) FROM ".TABLEPREFIX."fanfiction_news");
list($count) = dbrow($cquery);
$newsquery = dbquery("SELECT n.*, n.time as date FROM ".TABLEPREFIX."fanfiction_news as n ORDER BY n.time DESC LIMIT $offset, $itemsperpage");
$counter = 0;
while($stories = dbassoc($newsquery)) {
//create a new number_row block
$news->newBlock("newsbox");
//assign values
$news->assign("newstitle" , $stories['title']);
$news->assign("newsstory" , nl2br($stories['story']) );
$news->assign("newsauthor", $stories['author']);
$news->assign("newsdate", date("$dateformat $timeformat", $stories['date']) );
$news->assign("newsid", $stories['nid']);
$news->assign("skindir", $skindir);
if($newscomments)
$news->assign("newscomments", "".$stories['comments']." "._COMMENTS."");
if(isADMIN && uLEVEL < 4)
$news->assign("adminoptions", ""._EDIT." | "._DELETE."");
$news->assign("oddeven", ($counter % 2 ? "even" : "odd"));
$counter++;
}
$output .= $news->getOutputContent( );
if ($count > $itemsperpage) $output .= build_pagelinks("news.php?", $count, $offset);
$tpl->assign("output", $output);
}
$tpl->printToScreen();
dbclose( );
?>