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 logout(){
$pName = hash("sha512",$_COOKIE['username']);
loadIntClass('sql_query');
$class = new Sql_query('users');
$userDb = $class->selectWhere('user',$pName);
$userDb = $userDb['User'];
if($pName === $userDb['user']) {
$class->simpleQuery("UPDATE `users` SET `loggedin`='0', `logtime`='0'' WHERE `user`='".$pName."'");
$class->disconnect();
return true;
}
else{
return false;
}
}
function template(){
loadIntClass('sql_query');
$posts = new Sql_query('posts');
$num = $posts->selectWhere('slug',$this->_uri);
if($num != 0){
if(file_exists(ROOT.DS.MAIN.DS.'reflex'.DS.'templates'.DS.$this->_template.'.php')){
$posts->simpleQuery('UPDATE `posts` SET `template`=\''.$this->_template.'\' WHERE `slug`=\''.$this->_uri.'\'');
die('yes');
}
else{
die('It seems that the template does not exist anymore.');
}
}
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.');
}
}
<?php require(ROOT.DS.MAIN.DS.'reflex'.DS.'admin'.DS.'documents'.DS.'headnavfoot'.DS.'header.php');
require(ROOT.DS.MAIN.DS.'config'.DS.'posts.php');
$sql1 = new Sql_query('templates');
$template_arr = $sql1->selectAll();
$sql2 = new Sql_query('categories');
$cat_arr = $sql2->selectAll();
$sql3 = new Sql_query('authors');
$aut_arr = $sql3->selectAll();
if(array_key_exists('edit',$_GET)){
$slug = $_GET['edit'] !== '_index_' ? str_replace('_','/',$_GET['edit']) : $_GET['edit'];
if($slug !== ''){
$sql4 = new Sql_query('posts');
$post_arr = $sql4->selectWhere('slug',$slug);
$post_arr = $post_arr['Post'];
}
}
$post = isset($post_arr) ? true : false;
$cat = '';
if(isset($post_arr) && $post_arr['category'] !== 'none'){
$slug = explode('/',$slug);
$cat = $slug[0];
array_shift($slug);
$slug = $slug[0];
}
$template_table = '';
$category_table = '';
$author_table = '';
if($post){
$template_table = '
<option value="'.$post_arr['template'].'">'.$post_arr['template'].'</option>
';
