query("DELETE FROM bgb_posts WHERE postid = '$postid'"); $db->query("DELETE FROM bgb_fields WHERE postid = '$postid'"); } if($action=="writecomment" && $postid) { if($preview) $action="addcomment"; else { $comment=trim($message); if($parseurl==1) $message=parseurl($message); $db->query("UPDATE bgb_posts SET comment = '".addslashes($message)."', commenttime = '".time()."', comment_nosmilies = '$nosmilies' WHERE postid = '$postid'"); } } if(!isset($page) || $page=="" || $page==0) $page=1; $result=$db->query_first("SELECT COUNT(postid) FROM bgb_posts"); $totalposts=$result[0]; $pages=ceil($totalposts/$perpage); if($page>$pages) $page=$pages; $count=0; $result=$db->query("SELECT fieldid, title FROM bgb_fieldsettings ORDER BY displayorder ASC"); while($row=$db->fetch_array($result)) { $fieldids[$count]=$row[fieldid]; $fieldtitles[$count]=$row[title]; $count++; } $db->free_result($result); $result=$db->query("SELECT postid FROM bgb_posts ORDER BY posttime ".ifelse($displayorder,"ASC","DESC")." LIMIT ".($page-1)*$perpage.",".$perpage); while($row=$db->fetch_array($result)) $postids.=",".$row[postid]; $db->free_result($result); $posts=$db->query(" SELECT bgb_posts.*, bgb_fields.*, bgb_icons.* FROM bgb_posts LEFT JOIN bgb_fields ON (bgb_fields.postid=bgb_posts.postid) LEFT JOIN bgb_icons ON (bgb_icons.iconid=bgb_posts.iconid) WHERE bgb_posts.postid IN (0".$postids.") ORDER BY posttime ".ifelse($displayorder,"ASC","DESC")); $count = ifelse($displayorder,($page-1)*$perpage,$totalposts +1 - ($page-1)*$perpage); while($post=$db->fetch_array($posts)) { unset($icons); unset($fields); unset($suffix); unset($comment); if($displayorder==1) $count++; else $count--; if($count % 2) $tableid="tablea"; else $tableid="tableb"; for($i=0;$iget("index_fields")."\";"); } $posttime = formatdate($timeformat,$post[posttime]); if($post[iconid] && $allowicons) $icon=makeimgtag("images/icons/icon-".$post[iconid].".".$post[iconextension],$post[icontitle])."
"; else $icon=""; $post[message]=parse($post[message],$post[nosmilies]); if($post[comment]) { $comment = $post[comment]; $post[comment]=parse($post[comment],$post[comment_nosmilies]); $commenttime = formatdate($timeformat,$post[commenttime]); eval ("\$commentrow = \"".$template->get("index_commentrow")."\";"); } else $commentrow = ""; if($post[email] && $allowemail==1) eval ("\$icons .= \"".$template->get("index_iconsemail")."\";"); if($post[homepage] && $allowhomepage==1) eval ("\$icons .= \"".$template->get("index_iconshomepage")."\";"); if($post[icq] && $allowicq==1) eval ("\$icons .= \"".$template->get("index_iconsicq")."\";"); if($post[aim] && $allowaim==1) eval ("\$icons .= \"".$template->get("index_iconsaim")."\";"); if($post[yim] && $allowyim==1) eval ("\$icons .= \"".$template->get("index_iconsyim")."\";"); if($post[msn] && $allowmsn==1) eval ("\$icons .= \"".$template->get("index_iconsmsn")."\";"); if($postid==$post[postid]) { if($action=="delete") $suffix="_del"; if($action=="addcomment") { if($ch_parseurl==1) $checkbox[0]=" CHECKED"; if($ch_nosmilies==1 || $post[comment_nosmilies]==1) $checkbox[1]=" CHECKED"; if($preview) { if($nosmilies==1) $checkbox[1]=" CHECKED"; else $checkbox[1]=""; if($parseurl==1) $checkbox[0]=" CHECKED"; else $checkbox[0]=""; $message=trim($message); if(!$message) $commentrow=""; else { $comment = $message; $post[comment]=parse($message,$nosmilies); $commenttime = formatdate($timeformat,time()); eval ("\$commentrow = \"".$template->get("index_commentrow")."\";"); } } $suffix="_comment"; if($allowbbcode==1 || $allowsmilies==1) { if($allowbbcode==1) { eval ("\$bbcode_sizebits = \"".$template->get("bbcode_sizebits")."\";"); eval ("\$bbcode_fontbits = \"".$template->get("bbcode_fontbits")."\";"); eval ("\$bbcode_colorbits = \"".$template->get("bbcode_colorbits")."\";"); eval ("\$addentry_bbcodes = \"".$template->get("addentry_bbcodes")."\";"); } if($allowsmilies==1) { $result = $db->query("SELECT * FROM bgb_smilies"); $totalSmilies = $db->num_rows($result); if ($smilie_view == -1 || $smilie_view >= $totalSmilies) $smilie_view = $totalSmilies; elseif ($smilie_view < $totalSmilies) eval ("\$addentry_smilies_getmore = \"".$template->get("addentry_smilies_getmore")."\";"); $i=0; while($row = $db->fetch_array($result)) { eval ("\$smilieArray[\"".$i."\"] = \"".$template->get("addentry_smiliebit")."\";"); $i++; } $tableRows = ceil($smilie_view/$smilie_view_cols); $countx = 0; for ($i=0; $i<$tableRows; $i++) { $smiliebits .= "\t\n"; for ($j=0; $j<$smilie_view_cols; $j++) { $smiliebits .= "\t".$smilieArray[$countx]." \n"; $countx++; } $smiliebits .= "\t\n"; } eval ("\$addentry_smilies = \"".$template->get("addentry_smilies")."\";"); } eval ("\$codes = \"".$template->get("addentry_codes")."\";"); } } } eval ("\$postbit .= \"".$template->get("view_postbit".$suffix)."\";"); } $db->free_result($result); if($pages>1) { if($page>1) { $prior=$page-1; eval ("\$priorpage = \"".$template->get("view_priorpage")."\";"); } $pagelink = makepagelink("view.php",$page,$pages); if($page<$pages) { $next=$page+1; eval ("\$nextpage = \"".$template->get("view_nextpage")."\";"); } } eval("\$template->output(\"".$template->get("view")."\",2);"); ?>