| 1 | <?php
 | 
  
    | 2 | 
 | 
  
    | 3 | // $Id: delete_post.php 286 2006-01-23 21:15:10Z stefan $
 | 
  
    | 4 | 
 | 
  
    | 5 | /*
 | 
  
    | 6 | 
 | 
  
    | 7 |  Website Baker Project <http://www.websitebaker.org/>
 | 
  
    | 8 |  Copyright (C) 2004-2005, Ryan Djurovich
 | 
  
    | 9 | 
 | 
  
    | 10 |  Website Baker is free software; you can redistribute it and/or modify
 | 
  
    | 11 |  it under the terms of the GNU General Public License as published by
 | 
  
    | 12 |  the Free Software Foundation; either version 2 of the License, or
 | 
  
    | 13 |  (at your option) any later version.
 | 
  
    | 14 | 
 | 
  
    | 15 |  Website Baker is distributed in the hope that it will be useful,
 | 
  
    | 16 |  but WITHOUT ANY WARRANTY; without even the implied warranty of
 | 
  
    | 17 |  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 | 
  
    | 18 |  GNU General Public License for more details.
 | 
  
    | 19 | 
 | 
  
    | 20 |  You should have received a copy of the GNU General Public License
 | 
  
    | 21 |  along with Website Baker; if not, write to the Free Software
 | 
  
    | 22 |  Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 | 
  
    | 23 | 
 | 
  
    | 24 | */
 | 
  
    | 25 | 
 | 
  
    | 26 | require('../../config.php');
 | 
  
    | 27 | 
 | 
  
    | 28 | // Get id
 | 
  
    | 29 | if(!isset($_GET['post_id']) OR !is_numeric($_GET['post_id'])) {
 | 
  
    | 30 | 	header("Location: ".ADMIN_URL."/pages/index.php");
 | 
  
    | 31 | 	exit(0);
 | 
  
    | 32 | } else {
 | 
  
    | 33 | 	$post_id = $_GET['post_id'];
 | 
  
    | 34 | }
 | 
  
    | 35 | 
 | 
  
    | 36 | // Include WB admin wrapper script
 | 
  
    | 37 | $update_when_modified = true; // Tells script to update when this page was last updated
 | 
  
    | 38 | require(WB_PATH.'/modules/admin.php');
 | 
  
    | 39 | 
 | 
  
    | 40 | // Get post details
 | 
  
    | 41 | $query_details = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE post_id = '$post_id'");
 | 
  
    | 42 | if($query_details->numRows() > 0) {
 | 
  
    | 43 | 	$get_details = $query_details->fetchRow();
 | 
  
    | 44 | } else {
 | 
  
    | 45 | 	$admin->print_error($TEXT['NOT_FOUND'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id);
 | 
  
    | 46 | }
 | 
  
    | 47 | 
 | 
  
    | 48 | // Unlink post access file
 | 
  
    | 49 | if(is_writable(WB_PATH.$get_details['link'].'.php')) {
 | 
  
    | 50 | 	unlink(WB_PATH.$get_details['link'].'.php');
 | 
  
    | 51 | }
 | 
  
    | 52 | 
 | 
  
    | 53 | // Delete post
 | 
  
    | 54 | $database->query("DELETE FROM ".TABLE_PREFIX."mod_news_posts WHERE post_id = '$post_id' LIMIT 1");
 | 
  
    | 55 | 
 | 
  
    | 56 | // Clean up ordering
 | 
  
    | 57 | require(WB_PATH.'/framework/class.order.php');
 | 
  
    | 58 | $order = new order(TABLE_PREFIX.'mod_news_posts', 'position', 'post_id', 'section_id');
 | 
  
    | 59 | $order->clean($section_id); 
 | 
  
    | 60 | 
 | 
  
    | 61 | // Check if there is a db error, otherwise say successful
 | 
  
    | 62 | if($database->is_error()) {
 | 
  
    | 63 | 	$admin->print_error($database->get_error(), WB_URL.'/modules/modify_post.php?page_id='.$page_id.'&post_id='.$post_id);
 | 
  
    | 64 | } else {
 | 
  
    | 65 | 	$admin->print_success($TEXT['SUCCESS'], ADMIN_URL.'/pages/modify.php?page_id='.$page_id);
 | 
  
    | 66 | }
 | 
  
    | 67 | 
 | 
  
    | 68 | // Print admin footer
 | 
  
    | 69 | $admin->print_footer();
 | 
  
    | 70 | 
 | 
  
    | 71 | ?>
 |