Revision 1289
Added by kweitzel almost 15 years ago
delete.php | ||
---|---|---|
1 |
<?php |
|
2 |
|
|
3 |
// $Id$ |
|
4 |
|
|
5 |
/* |
|
6 |
|
|
7 |
Website Baker Project <http://www.websitebaker.org/> |
|
8 |
Copyright (C) 2004-2009, 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 |
// Must include code to stop this file being access directly |
|
27 |
if(defined('WB_PATH') == false) { exit("Cannot access this file directly"); } |
|
28 |
|
|
29 |
//get and remove all php files created for the news section |
|
30 |
$query_details = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id'"); |
|
31 |
if($query_details->numRows() > 0) { |
|
32 |
while($link = $query_details->fetchRow()) { |
|
33 |
if(is_writable(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION)) { |
|
34 |
unlink(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION); |
|
35 |
} |
|
36 |
} |
|
37 |
} |
|
38 |
//check to see if any other sections are part of the news page, if only 1 news is there delete it |
|
39 |
$query_details = $database->query("SELECT * FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id'"); |
|
40 |
if($query_details->numRows() == 1) { |
|
41 |
$query_details2 = $database->query("SELECT * FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'"); |
|
42 |
$link = $query_details2->fetchRow(); |
|
43 |
if(is_writable(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION)) { |
|
44 |
unlink(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION); |
|
45 |
} |
|
46 |
} |
|
47 |
|
|
48 |
$database->query("DELETE FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id'"); |
|
49 |
$database->query("DELETE FROM ".TABLE_PREFIX."mod_news_groups WHERE section_id = '$section_id'"); |
|
50 |
$database->query("DELETE FROM ".TABLE_PREFIX."mod_news_comments WHERE section_id = '$section_id'"); |
|
51 |
$database->query("DELETE FROM ".TABLE_PREFIX."mod_news_settings WHERE section_id = '$section_id'"); |
|
52 |
|
|
1 |
<?php |
|
2 |
/** |
|
3 |
* |
|
4 |
* @category modules |
|
5 |
* @package news |
|
6 |
* @author WebsiteBaker Project |
|
7 |
* @copyright 2004-2009, Ryan Djurovich |
|
8 |
* @copyright 2009-2010, Website Baker Org. e.V. |
|
9 |
* @link http://www.websitebaker2.org/ |
|
10 |
* @license http://www.gnu.org/licenses/gpl.html |
|
11 |
* @platform WebsiteBaker 2.8.x |
|
12 |
* @requirements PHP 4.3.4 and higher |
|
13 |
* @version $Id$ |
|
14 |
* @filesource $HeadURL$ |
|
15 |
* @lastmodified $Date$ |
|
16 |
* |
|
17 |
*/ |
|
18 |
|
|
19 |
// Must include code to stop this file being access directly |
|
20 |
if(defined('WB_PATH') == false) |
|
21 |
{ |
|
22 |
exit("Cannot access this file directly"); |
|
23 |
} |
|
24 |
|
|
25 |
//get and remove all php files created for the news section |
|
26 |
$query_details = $database->query("SELECT * FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id'"); |
|
27 |
if($query_details->numRows() > 0) { |
|
28 |
while($link = $query_details->fetchRow()) { |
|
29 |
if(is_writable(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION)) { |
|
30 |
unlink(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION); |
|
31 |
} |
|
32 |
} |
|
33 |
} |
|
34 |
//check to see if any other sections are part of the news page, if only 1 news is there delete it |
|
35 |
$query_details = $database->query("SELECT * FROM ".TABLE_PREFIX."sections WHERE page_id = '$page_id'"); |
|
36 |
if($query_details->numRows() == 1) { |
|
37 |
$query_details2 = $database->query("SELECT * FROM ".TABLE_PREFIX."pages WHERE page_id = '$page_id'"); |
|
38 |
$link = $query_details2->fetchRow(); |
|
39 |
if(is_writable(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION)) { |
|
40 |
unlink(WB_PATH.PAGES_DIRECTORY.$link['link'].PAGE_EXTENSION); |
|
41 |
} |
|
42 |
} |
|
43 |
|
|
44 |
$database->query("DELETE FROM ".TABLE_PREFIX."mod_news_posts WHERE section_id = '$section_id'"); |
|
45 |
$database->query("DELETE FROM ".TABLE_PREFIX."mod_news_groups WHERE section_id = '$section_id'"); |
|
46 |
$database->query("DELETE FROM ".TABLE_PREFIX."mod_news_comments WHERE section_id = '$section_id'"); |
|
47 |
$database->query("DELETE FROM ".TABLE_PREFIX."mod_news_settings WHERE section_id = '$section_id'"); |
|
48 |
|
|
53 | 49 |
?> |
54 | 50 |
Also available in: Unified diff
Branch 2.8.1 merged back into Trunk