| 4 |
4 |
* @category modules
|
| 5 |
5 |
* @package menu_link
|
| 6 |
6 |
* @author WebsiteBaker Project
|
| 7 |
|
* @copyright 2009-2011, Website Baker Org. e.V.
|
| 8 |
|
* @link http://www.websitebaker2.org/
|
|
7 |
* @copyright 2009-2013, WebsiteBaker Org. e.V.
|
|
8 |
* @link http://www.websitebaker.org/
|
| 9 |
9 |
* @license http://www.gnu.org/licenses/gpl.html
|
| 10 |
|
* @platform WebsiteBaker 2.8.x
|
|
10 |
* @platform WebsiteBaker 2.8.4
|
| 11 |
11 |
* @requirements PHP 5.2.2 and higher
|
| 12 |
12 |
* @version $Id$
|
| 13 |
|
* @filesource $HeadURL$
|
|
13 |
* @filesource $HeadURL$
|
| 14 |
14 |
* @lastmodified $Date$
|
| 15 |
15 |
*
|
| 16 |
16 |
*/
|
| ... | ... | |
| 32 |
32 |
|
| 33 |
33 |
// Update id, anchor and target
|
| 34 |
34 |
if(isset($_POST['menu_link'])) {
|
| 35 |
|
$foreign_page_id = $admin->add_slashes($_POST['menu_link']);
|
| 36 |
|
$page_target = $admin->add_slashes($_POST['page_target']);
|
| 37 |
|
$url_target = $admin->add_slashes($_POST['target']);
|
| 38 |
|
$r_type = $admin->add_slashes($_POST['r_type']);
|
|
35 |
$foreign_page_id = intval($_POST['menu_link']);
|
|
36 |
$url_target = $admin->StripCodeFromText($_POST['target']);
|
|
37 |
$r_type = intval($_POST['r_type']);
|
|
38 |
$page_target = $admin->StripCodeFromText($_POST['page_target']);
|
| 39 |
39 |
if(isset($_POST['extern']))
|
| 40 |
|
$extern = $admin->add_slashes($_POST['extern']);
|
|
40 |
$extern = $admin->StripCodeFromText($_POST['extern']);
|
| 41 |
41 |
else
|
| 42 |
42 |
$extern='';
|
| 43 |
43 |
|
| 44 |
44 |
$table_pages = TABLE_PREFIX.'pages';
|
| 45 |
45 |
$table_mod = TABLE_PREFIX.'mod_menu_link';
|
| 46 |
46 |
$database->query("UPDATE `$table_pages` SET `target` = '$url_target' WHERE `page_id` = '$page_id'");
|
| 47 |
|
$database->query("UPDATE `$table_mod` SET `target_page_id` = '$foreign_page_id', `anchor` = '$page_target', `extern` = '$extern', `redirect_type` = '$r_type' WHERE `page_id` = '$page_id'");
|
|
47 |
// $database->query("UPDATE `$table_mod` SET `target_page_id` = '$foreign_page_id', `anchor` = '$page_target', `extern` = '$extern', `redirect_type` = '$r_type' WHERE `page_id` = '$page_id'");
|
|
48 |
|
|
49 |
// Check that it doesn't already exist
|
|
50 |
$sqlwhere = 'WHERE `page_id`='.$page_id.'';
|
|
51 |
$sqlOne = 'SELECT COUNT(*) FROM `'.TABLE_PREFIX.'mod_menu_link` '.$sqlwhere;
|
|
52 |
if( $database->get_one($sqlOne) ) {
|
|
53 |
$sql = 'UPDATE `'.TABLE_PREFIX.'mod_menu_link` SET';
|
|
54 |
}else{
|
|
55 |
// Load into DB
|
|
56 |
$sql = 'INSERT INTO `'.TABLE_PREFIX.'mod_menu_link` SET ';
|
|
57 |
$sqlwhere = '';
|
|
58 |
$sql .= '`section_id`='.$section_id.', '
|
|
59 |
. '`page_id`='.$page_id.', ';
|
|
60 |
}
|
|
61 |
$sql .= '`target_page_id` = \''.$foreign_page_id.'\', '
|
|
62 |
. '`anchor` = \''.$database->escapeString($page_target).'\', '
|
|
63 |
. '`extern` = \''.$database->escapeString($extern).'\', '
|
|
64 |
. '`redirect_type` = \''.$r_type.'\' '
|
|
65 |
. $sqlwhere;
|
| 48 |
66 |
}
|
| 49 |
67 |
|
| 50 |
68 |
// Check if there is a database error, otherwise say successful
|
| 51 |
|
if($database->is_error()) {
|
|
69 |
if($database->query($sql)) {
|
|
70 |
$admin->print_success($MESSAGE['PAGES_SAVED'],$backlink );
|
|
71 |
} else {
|
| 52 |
72 |
$admin->print_error($database->get_error(), $js_back);
|
| 53 |
|
} else {
|
| 54 |
|
$admin->print_success($MESSAGE['PAGES']['SAVED'],$backlink );
|
| 55 |
73 |
}
|
| 56 |
74 |
|
| 57 |
75 |
// Print admin footer
|
! modules/menu_link/save.php coding new sql logic to replace adding an empty table row in add.php