| 101 |
} |
} |
| 102 |
|
|
| 103 |
// Query to get published menu item counts |
// Query to get published menu item counts |
| 104 |
|
// @RawSQLUse, trivial_implementation, SELECT |
| 105 |
$query = "SELECT a.menutype, count( a.menutype ) as num" |
$query = "SELECT a.menutype, count( a.menutype ) as num" |
| 106 |
. "\n FROM #__menu AS a" |
. "\n FROM #__menu AS a" |
| 107 |
. "\n WHERE a.published = 1" |
. "\n WHERE a.published = 1" |
| 112 |
$published = $database->loadObjectList(); |
$published = $database->loadObjectList(); |
| 113 |
|
|
| 114 |
// Query to get unpublished menu item counts |
// Query to get unpublished menu item counts |
| 115 |
|
// @RawSQLUse, trivial_implementation, SELECT |
| 116 |
$query = "SELECT a.menutype, count( a.menutype ) as num" |
$query = "SELECT a.menutype, count( a.menutype ) as num" |
| 117 |
. "\n FROM #__menu AS a" |
. "\n FROM #__menu AS a" |
| 118 |
. "\n WHERE a.published = 0" |
. "\n WHERE a.published = 0" |
| 124 |
if (!$unpublished) $unpublished = array(); |
if (!$unpublished) $unpublished = array(); |
| 125 |
|
|
| 126 |
// Query to get trash menu item counts |
// Query to get trash menu item counts |
| 127 |
|
// @RawSQLUse, trivial_implementation, SELECT |
| 128 |
$query = "SELECT a.menutype, count( a.menutype ) as num" |
$query = "SELECT a.menutype, count( a.menutype ) as num" |
| 129 |
. "\n FROM #__menu AS a" |
. "\n FROM #__menu AS a" |
| 130 |
. "\n WHERE a.published = -2" |
. "\n WHERE a.published = -2" |
| 216 |
} |
} |
| 217 |
|
|
| 218 |
// check for unique menutype for new menus |
// check for unique menutype for new menus |
| 219 |
|
// @RawSQLUse, trivial_implementation, SELECT |
| 220 |
$query = "SELECT params" |
$query = "SELECT params" |
| 221 |
. "\n FROM #__modules" |
. "\n FROM #__modules" |
| 222 |
. "\n WHERE module = 'mod_mainmenu'" |
. "\n WHERE module = 'mod_mainmenu'" |
| 255 |
|
|
| 256 |
// module assigned to show on All pages by default |
// module assigned to show on All pages by default |
| 257 |
// ToDO: Changed to become a mambo db-object |
// ToDO: Changed to become a mambo db-object |
| 258 |
|
// @RawSQLUse, trivial_implementation, INSERT |
| 259 |
$query = "INSERT INTO #__modules_menu VALUES ( $row->id, 0 )"; |
$query = "INSERT INTO #__modules_menu VALUES ( $row->id, 0 )"; |
| 260 |
$database->setQuery( $query ); |
$database->setQuery( $query ); |
| 261 |
if ( !$database->query() ) { |
if ( !$database->query() ) { |
| 312 |
|
|
| 313 |
// change menutype of all menuitems using old menutype |
// change menutype of all menuitems using old menutype |
| 314 |
if ( $menutype <> $old_menutype ) { |
if ( $menutype <> $old_menutype ) { |
| 315 |
|
// @RawSQLUse, trivial_implementation, UPDATE |
| 316 |
$query = "UPDATE #__menu SET menutype = '$menutype' WHERE menutype = '$old_menutype'"; |
$query = "UPDATE #__menu SET menutype = '$menutype' WHERE menutype = '$old_menutype'"; |
| 317 |
$database->setQuery( $query ); |
$database->setQuery( $query ); |
| 318 |
$database->query(); |
$database->query(); |
| 338 |
|
|
| 339 |
$menus = implode("','",$types); |
$menus = implode("','",$types); |
| 340 |
// list of menu items to delete |
// list of menu items to delete |
| 341 |
|
// @RawSQLUse, trivial_implementation, SELECT |
| 342 |
$query = "SELECT a.name, a.id" |
$query = "SELECT a.name, a.id" |
| 343 |
. "\n FROM #__menu AS a" |
. "\n FROM #__menu AS a" |
| 344 |
. "\n WHERE ( a.menutype IN ( '$menus' ) )" |
. "\n WHERE ( a.menutype IN ( '$menus' ) )" |
| 368 |
} |
} |
| 369 |
|
|
| 370 |
@$mids = implode( ',', $mid ); |
@$mids = implode( ',', $mid ); |
| 371 |
|
// @RawSQLUse, trivial_implementation, SELECT |
| 372 |
$query = "SELECT id, title" |
$query = "SELECT id, title" |
| 373 |
. "\n FROM #__modules" |
. "\n FROM #__modules" |
| 374 |
. "\n WHERE id IN ( $mids )" |
. "\n WHERE id IN ( $mids )" |
| 396 |
$mids = implode( ',', $mids ); |
$mids = implode( ',', $mids ); |
| 397 |
} |
} |
| 398 |
// delete menu items |
// delete menu items |
| 399 |
|
// @RawSQLUse, trivial_implementation, DELETE |
| 400 |
$query = "DELETE FROM #__menu" |
$query = "DELETE FROM #__menu" |
| 401 |
. "\n WHERE ( id IN ( $mids ) )" |
. "\n WHERE ( id IN ( $mids ) )" |
| 402 |
; |
; |
| 415 |
// checks whether any modules to delete |
// checks whether any modules to delete |
| 416 |
if ( $cids ) { |
if ( $cids ) { |
| 417 |
// delete modules |
// delete modules |
| 418 |
|
// @RawSQLUse, trivial_implementation, DELETE |
| 419 |
$database->setQuery( "DELETE FROM #__modules WHERE id IN ( $cids )" ); |
$database->setQuery( "DELETE FROM #__modules WHERE id IN ( $cids )" ); |
| 420 |
if ( !$database->query() ) { |
if ( !$database->query() ) { |
| 421 |
echo "<script> alert('". $database->getErrorMsg() ."'); window.history.go(-1); </script>\n"; |
echo "<script> alert('". $database->getErrorMsg() ."'); window.history.go(-1); </script>\n"; |
| 422 |
exit; |
exit; |
| 423 |
} |
} |
| 424 |
// delete all module entires in mos_modules_menu |
// delete all module entires in mos_modules_menu |
| 425 |
|
// @RawSQLUse, trivial_implementation, DELETE |
| 426 |
$database->setQuery( "DELETE FROM #__modules_menu WHERE moduleid IN ( ". $cids ." )" ); |
$database->setQuery( "DELETE FROM #__modules_menu WHERE moduleid IN ( ". $cids ." )" ); |
| 427 |
if ( !$database->query() ) { |
if ( !$database->query() ) { |
| 428 |
echo "<script> alert('". $database->getErrorMsg() ."');</script>\n"; |
echo "<script> alert('". $database->getErrorMsg() ."');</script>\n"; |
| 448 |
global $database; |
global $database; |
| 449 |
|
|
| 450 |
// Content Items query |
// Content Items query |
| 451 |
|
// @RawSQLUse, trivial_implementation, SELECT |
| 452 |
$query = "SELECT a.name, a.id" |
$query = "SELECT a.name, a.id" |
| 453 |
. "\n FROM #__menu AS a" |
. "\n FROM #__menu AS a" |
| 454 |
. "\n WHERE ( a.menutype IN ( '". $type ."' ) )" |
. "\n WHERE ( a.menutype IN ( '". $type ."' ) )" |
| 471 |
$module_name = mosGetParam( $_POST, 'module_name', 'New Module' ); |
$module_name = mosGetParam( $_POST, 'module_name', 'New Module' ); |
| 472 |
|
|
| 473 |
// check for unique menutype for new menu copy |
// check for unique menutype for new menu copy |
| 474 |
|
// @RawSQLUse, trivial_implementation, SELECT |
| 475 |
$query = "SELECT params" |
$query = "SELECT params" |
| 476 |
. "\n FROM #__modules" |
. "\n FROM #__modules" |
| 477 |
. "\n WHERE module = 'mod_mainmenu'" |
. "\n WHERE module = 'mod_mainmenu'" |
| 535 |
$row->updateOrder( "position='". $row->position ."'" ); |
$row->updateOrder( "position='". $row->position ."'" ); |
| 536 |
// module assigned to show on All pages by default |
// module assigned to show on All pages by default |
| 537 |
// ToDO: Changed to become a mambo db-object |
// ToDO: Changed to become a mambo db-object |
| 538 |
|
// @RawSQLUse, trivial_implementation, INSERT |
| 539 |
$query = "INSERT INTO #__modules_menu VALUES ( $row->id, 0 )"; |
$query = "INSERT INTO #__modules_menu VALUES ( $row->id, 0 )"; |
| 540 |
$database->setQuery( $query ); |
$database->setQuery( $query ); |
| 541 |
if ( !$database->query() ) { |
if ( !$database->query() ) { |
Parent Directory
| 
Revision Log
| 
Patch
