function delete(){ loadIntClass('sql_query'); $sql = new Sql_query('comments'); $array = $sql->query('SELECT * FROM `comments` WHERE `id`=\''.$this->_id.'\''); $sql->simpleQuery('DELETE FROM `comments` WHERE `id`=\''.$this->_id.'\''); $this->republish($array[0]['Comment']['post_slug']); die('SUCCESS'); }
function cron_set(){ loadIntClass('cron_job'); if(!$this->_publish && $this->_postdate > time()){ $arr1 = array('time'=>$this->_postdate,'command'=>'republish_post','parameters'=>array($this->_slug)); $cron1 = new Cron_job($arr1); } $cache = new Sql_query('posts'); $cacheNum = $cache->query('SELECT * FROM `posts` WHERE `cachepub`=\'1\''); for($i = 0; $i < count($cacheNum); ++$i){ $arr2 = array('time'=>time(),'command'=>'republish_post','parameters'=>array($cacheNum[$i]['Post']['slug'])); $cron2 = new Cron_job($arr2); } }
function writeRSS(){ $rsshead = '<?xml version="1.0" encoding="UTF-8" ?> <rss version="2.0"> <channel> <title>'.RSS_TITLE.'</title> <description>'.RSS_DESCRIPTION.'</description> <language>en-us</language> <copyright>Copyright (C) '.date('Y').' '.THIS_DOMAIN.'</copyright> <link>http://'.THIS_DOMAIN.'/'.RSS_URI.'</link> <lastBuildDate>'.date('D, d M Y H:i:s T').'</lastBuildDate>'; loadIntClass('sql_query'); $sql = new Sql_query('posts'); $postArr = $sql->query('SELECT * FROM `posts` WHERE `publish`=\'1\''); $count = count($postArr); if($count === 0){ die('There are no posts'); } reset($postArr); $latest =$postArr[0]['Post']['publishdate']; $rssbody=''; for($i = 0; $i < $count;++$i){ $p = $postArr[$i]['Post']; if($p['slug'] === '_index_') $p['slug'] =''; $link = 'http://'.THIS_DOMAIN.'/'.($p['category'] !=='none'?$p['category'].'/':'').$p['slug']; $rssbody .= ' <item> <title>'.$p['title'].'</title> <description>'.$p['description'].'</description> <link>'.$link.'</link> <guid isPermaLink="true">'.$link.'</guid> <pubDate>'.date('D, d M Y H:i:s T',intval($p['publishdate'])).'</pubDate> </item> '; if(intval($latest)<intval($p['publishdate'])){ $latest = $p['publishdate']; } } $rsshead.=' <pubDate>'.date('D, d M Y H:i:s T',intval($latest)).'</pubDate>'; $rssbody.='</channel> </rss>'; header("Content-Type: application/rss+xml"); echo $rsshead,$rssbody; exit; }
'; switch($comments[$i]['approved']){ case 'approved': $approved+=1; break; case 'pending': $pending+=1; break; case 'spam': $spam+=1; break; } } $all = $pending + $approved + $spam; $sql2 = new Sql_query('posts'); $posts = $sql2->query('SELECT * FROM `posts` WHERE `commentbool`=\'1\' OR `pingbool`=\'1\''); ?> <p id="para" class="in_main">You may not view all comments. You may view all the comments for a particular posts, or all pending, or spam comments from your entire site.</p> <form class="in_main"> <select id="posts_select"> <? if(array_key_exists('post',$_GET)){ echo '<option value="',$_GET['post'],'">',$_GET['post'],'</option> <option value="AP">All Pending and Spam</option>'; for($i = 0; $i < count($posts); ++$i){ if($posts[$i]['Post']['slug'] !== $_GET['post']){ echo '<option value="',str_replace('/','_',$posts[$i]['Post']['slug']),'">',$posts[$i]['Post']['slug'],'</option> '; } } }