function checkDB(){ loadIntClass('sql_query'); $sql = new Sql_query('templates'); $num = $sql->numRows('name', $this->_templateName); if($num === 1 && file_exists($this->_path.$this->_filename)){ $sql->simpleQuery('UPDATE `templates` SET `rep`=\'1\' WHERE `name`=\''.$this->_templateName.'\''); if($this->copyFile($_FILES['Filedata']['tmp_name'], $this->_path.$this->_templateName.'.temp.php')){ die('REPLACE/'.$this->_templateName); } else{ die('The file exists already, and the server was unable to temporarily save the file to assess if you wanted to replace. Please try uploading again.'); } } else if($this->copyFile($_FILES['Filedata']['tmp_name'], $this->_path.$this->_filename)){ $sql->simpleQuery('INSERT INTO `templates` (name, css, rep, date) VALUES ( \''.$this->_templateName.'\', \'0\', \'0\', \''.time().'\')'); $sql->disconnect(); $this->getCSS(); } else{ die('The file was not successfully saved. Please try uploading again.'); } }
function unpublish(){ loadIntClass('sql_query'); $posts = new Sql_query('posts'); $num = $posts->numRows('slug',$this->_uri); if($num != 0){ if(file_exists(ROOT.DS.MAIN.DS.'reflex'.DS.'documents'.DS.$this->_loc.'.php') || file_exists(ROOT.DS.MAIN.DS.'reflex'.DS.'documents'.DS.'_categories_'.DS.$this->_loc.'.php')){ $post_arr = $posts->selectWhere('slug',$this->_uri); $post_arr = $post_arr['Post']; if($post_arr['category'] == 'none'){ if(unlink(ROOT.DS.MAIN.DS.'reflex'.DS.'documents'.DS.$this->_loc.'.php')){ $posts->simpleQuery('UPDATE `posts` SET `publish`=\'0\' WHERE `slug`=\''.$this->_uri.'\''); die('yes'); } else{ die('The server failed to delete the post you selected.'); } } else{ if(unlink(ROOT.DS.MAIN.DS.'reflex'.DS.'documents'.DS.'_categories_'.DS.$this->_loc.'.php')){ $posts->simpleQuery('UPDATE `posts` SET `publish`=\'0\' WHERE `slug`=\''.$this->_uri.'\''); die('yes'); } else{ die('The server failed to delete the post you selected.'); } } } else{ $post_arr = $posts->selectWhere('slug',$this->_uri); $post_arr = $post_arr['Post']; if($post_arr['publish'] == 0){ die('yes'); } else{ $posts->simpleQuery('UPDATE `posts` SET `publish`=\'0\' WHERE `slug`=\''.$this->_uri.'\''); die('yes'); } } } else{ die('The server could not find the post that you selected.'); } }
function republish() { loadIntClass('sql_query'); $posts = new Sql_query('posts'); $num = $posts->numRows('slug',$this->_uri); if($num !== 0){ $post_arr = $posts->selectWhere('slug',$this->_uri); $post_arr = $post_arr['Post']; $this->_post = $post_arr['post']; $this->_title = $post_arr['title']; $this->_slug = $post_arr['slug']; $this->_description = $post_arr['description']; $this->_template = $post_arr['template']; $this->_category = $post_arr['category']; $this->_author = $post_arr['author']; $this->_commentbool = $post_arr['commentbool']; $this->_pingbacks = $post_arr['pingbacks']; $this->_pingbool = $post_arr['pingbool']; $this->_publish = $post_arr['publish']; $this->_cachepub = $post_arr['cachepub']; ob_start(); require(ROOT.DS.MAIN.DS.'reflex'.DS.'templates'.DS.$this->_template.'.php'); $html_string = ob_get_clean(); $html_string = str_replace('<php>','<?php ',$html_string); $html_string = str_replace('</php>',' ?>',$html_string); if($this->_category == 'none'){ $fileloc = fopen(ROOT.DS.MAIN.DS.'reflex'.DS.'documents'.DS.$this->_slug.'.php', 'w'); fwrite($fileloc,$html_string); fclose($fileloc); } else{ $fileloc = fopen(ROOT.DS.MAIN.DS.'reflex'.DS.'documents'.DS.'_categories_'.$this->_category.DS.$this->_slug.'.php', 'w'); fwrite($fileloc,$html_string); fclose($fileloc); } $posts->simpleQuery('UPDATE `posts` SET `publish`=\'1\' WHERE `slug`=\''.$this->_slug.'\''); die('yes'); } else{ die('The server could not find the post that you selected.'); } }
function delete(){ loadIntClass('sql_query'); $posts = new Sql_query('posts'); $num = $posts->numRows('slug',$this->_uri); if($num !== 0){ $post_arr = $posts->selectWhere('slug',$this->_uri); $post_arr = $post_arr['Post']; if($post_arr['category'] == 'none'){ @unlink(ROOT.DS.MAIN.DS.'reflex'.DS.'documents'.DS.$this->_uri.'.php'); $posts->simpleQuery('DELETE FROM `posts` WHERE `slug`=\''.$this->_uri.'\''); die('yes'); } else{ @unlink(ROOT.DS.MAIN.DS.'reflex'.DS.'documents'.DS.'_categories_'.DS.$this->_uri.'.php'); $posts->simpleQuery('DELETE FROM `posts` WHERE `slug`=\''.$this->_uri.'\''); die('yes'); } } else{ die('The server could not find the post that you selected.'); } }
function db_create($directory) { $commentbool = $this->_commentbool ? 1 : 0; $publish = $this->_publish ? 1 : 0; $pingbool = $this->_pingbool ? 1 : 0; $cachepub = $this->_cachepub ? 1 : 0; $time = time(); $posts = new Sql_query('posts'); $num = $posts->numRows('slug',$this->_slug); if($num !== 0){ $posts->simpleQuery('UPDATE `posts` SET `title`=\''.$this->_title.'\', `description`=\''.$this->_description.'\, `template`=\''.$this->_template.'\', `category`=\''.$this->_category.'\', `author`=\''.$this->_author.'\', `commentbool`=\''.$commentbool.'\', `publish`=\''.$publish.'\', `post`=\''.$this->_post.'\', `pingbool`=\''.$pingbool.'\', `publishdate`=\''.$time.'\', `cachepub`=\''.$cachepub.'\, `comments_off`=\''.$this->_commentsdate.'\' WHERE `slug`=\''.$this->_slug.'\''); $posts->disconnect(); } else{ $posts->simpleQuery('INSERT INTO `posts` (title, slug, description, template, category, author, commentbool, publish, post, pingbool, publishdate, cachepub, comments_off) VALUES ( \''.$this->_title.'\', \''.$this->_slug.'\', \''.$this->_description.'\', \''.$this->_template.'\', \''.$this->_category.'\', \''.$this->_author.'\', \''.$commentbool.'\', \''.$publish.'\', \''.$this->_post.'\', \''.$pingbool.'\', \''.$time.'\', \''.$cachepub.'\', \''.$this->_commentsdate.'\')'); $posts->disconnect(); } $string_url = 'http://'.THIS_DOMAIN.'/'; $string_url .= $this->_category === 'none' ? ($this->_slug ==='_index_' ? '' : $this->_slug) : $this->_category.'/'.$this->_slug; if($this->_publish=='true'){ $this->publish($directory,$string_url); } die('Your new post has been saved. Simply go to Posts, when you\'re ready to publish it. When it is published its url will be "'.$string_url.'".'); }
<?php $postKey = $this->_postName === '' ? 'index' : $this->_postName; $docArray = array( 'index' => array('title' => 'Create a New Post', 'css' => 'newpost'), 'posts' => array('title'=>'Browse Your Posts','css'=>'posts'), 'templates' => array('title'=>'Browse your Templates','css'=>'templates'), 'upload-files' => array('title'=>'Upload/Browse Your Files','css'=>'media'), 'comments' => array('title'=>'Browse Your Comments','css'=>'comments'), 'settings' => array('title'=>'Adjust Your Settings','css'=>'settings'), ); loadIntClass('sql_query'); $header_posts = new Sql_query('posts'); $unpublished_i = $header_posts->numRows('publish','0'); $comments = new Sql_query('comments'); $unapproved_i = $comments->numRows('approved','pending'); ?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>Reflexion - <? echo $docArray[$postKey]['title']?></title> <base href="<? echo 'http://'.THIS_DOMAIN.'/';?>" /> <link rel="stylesheet" href="css/admin/reset.css" /> <link rel="stylesheet" href="css/admin/<? echo $docArray[$postKey]['css']?>.css" /> </head> <body> <div id="header"> <div id="logo"></div> <p class="alternate"> <? if($postKey !== 'comments'){