- md5
- d847b73cc3b02e2338f091dd4863c473
- sha1
- 20875126888a8cfb608097f9f6bd27d4c9477afd
- sha256
- 350c36e0457be2b878d1b6998ad083640e2a9e4523cdf140d48d9a074b9d1f65
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731
<?php
/**
* @version $Id: admin.sections.php 2301 2006-02-12 10:46:38Z stingrey $
* @package Joomla
* @subpackage Sections
* @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
* @license http://www.gnu.org/copyleft/gpl.html GNU/GPL, see LICENSE.php
* Joomla! is free software. This version may have been modified pursuant
* to the GNU General Public License, and as distributed it includes or
* is derivative of works licensed under the GNU General Public License or
* other free or open source software licenses.
* See COPYRIGHT.php for copyright notices and details.
*/
// no direct access
defined( '_VALID_MOS' ) or die( 'Restricted access' );
require_once( $mainframe->getPath( 'admin_html' ) );
// get parameters from the URL or submitted form
$scope = mosGetParam( $_REQUEST, 'scope', '' );
$cid = mosGetParam( $_REQUEST, 'cid', array(0) );
$section = mosGetParam( $_REQUEST, 'scope', '' );
if (!is_array( $cid )) {
$cid = array(0);
}
switch ($task) {
case 'new':
editSection( 0, $scope, $option );
break;
case 'edit':
editSection( intval( $cid[0] ), '', $option );
break;
case 'editA':
editSection( $id, '', $option );
break;
case 'go2menu':
case 'go2menuitem':
case 'menulink':
case 'save':
case 'apply':
saveSection( $option, $scope, $task );
break;
case 'remove':
removeSections( $cid, $scope, $option );
break;
case 'copyselect':
copySectionSelect( $option, $cid, $section );
break;
case 'copysave':
copySectionSave( $cid );
break;
case 'publish':
publishSections( $scope, $cid, 1, $option );
break;
case 'unpublish':
publishSections( $scope, $cid, 0, $option );
break;
case 'cancel':
cancelSection( $option, $scope );
break;
case 'orderup':
orderSection( intval( $cid[0] ), -1, $option, $scope );
break;
case 'orderdown':
orderSection( intval( $cid[0] ), 1, $option, $scope );
break;
case 'accesspublic':
accessMenu( intval( $cid[0] ), 0, $option );
break;
case 'accessregistered':
accessMenu( intval( $cid[0] ), 1, $option );
break;
case 'accessspecial':
accessMenu( intval( $cid[0] ), 2, $option );
break;
case 'saveorder':
saveOrder( $cid );
break;
default:
showSections( $scope, $option );
break;
}
/**
* Compiles a list of categories for a section
* @param database A database connector object
* @param string The name of the category section
* @param string The name of the current user
*/
function showSections( $scope, $option ) {
global $database, $my, $mainframe, $mosConfig_list_limit;
$limit = intval( $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit ) );
$limitstart = intval( $mainframe->getUserStateFromRequest( "view{$option}limitstart", 'limitstart', 0 ) );
// get the total number of records
$query = "SELECT COUNT(*)"
. "\n FROM #__sections"
. "\n WHERE scope = '$scope'"
;
$database->setQuery( $query );
$total = $database->loadResult();
require_once( $GLOBALS['mosConfig_absolute_path'] . '/administrator/includes/pageNavigation.php' );
$pageNav = new mosPageNav( $total, $limitstart, $limit );
$query = "SELECT c.*, g.name AS groupname, u.name AS editor"
. "\n FROM #__sections AS c"
. "\n LEFT JOIN #__content AS cc ON c.id = cc.sectionid"
. "\n LEFT JOIN #__users AS u ON u.id = c.checked_out"
. "\n LEFT JOIN #__groups AS g ON g.id = c.access"
. "\n WHERE scope = '$scope'"
. "\n GROUP BY c.id"
. "\n ORDER BY c.ordering, c.name"
. "\n LIMIT $pageNav->limitstart, $pageNav->limit"
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
$count = count( $rows );
// number of Active Items
for ( $i = 0; $i < $count; $i++ ) {
$query = "SELECT COUNT( a.id )"
. "\n FROM #__categories AS a"
. "\n WHERE a.section = '". $rows[$i]->id ."'"
. "\n AND a.published != -2"
;
$database->setQuery( $query );
$active = $database->loadResult();
$rows[$i]->categories = $active;
}
// number of Active Items
for ( $i = 0; $i < $count; $i++ ) {
$query = "SELECT COUNT( a.id )"
. "\n FROM #__content AS a"
. "\n WHERE a.sectionid = '". $rows[$i]->id ."'"
. "\n AND a.state != -2"
;
$database->setQuery( $query );
$active = $database->loadResult();
$rows[$i]->active = $active;
}
// number of Trashed Items
for ( $i = 0; $i < $count; $i++ ) {
$query = "SELECT COUNT( a.id )"
. "\n FROM #__content AS a"
. "\n WHERE a.sectionid = '". $rows[$i]->id ."'"
. "\n AND a.state = -2"
;
$database->setQuery( $query );
$trash = $database->loadResult();
$rows[$i]->trash = $trash;
}
sections_html::show( $rows, $scope, $my->id, $pageNav, $option );
}
/**
* Compiles information to add or edit a section
* @param database A database connector object
* @param string The name of the category section
* @param integer The unique id of the category to edit (0 if new)
* @param string The name of the current user
*/
function editSection( $uid=0, $scope='', $option ) {
global $database, $my;
$row = new mosSection( $database );
// load the row from the db table
$row->load( $uid );
// fail if checked out not by 'me'
if ($row->isCheckedOut( $my->id )) {
$msg = 'The section '. $row->title .' is currently being edited by another administrator';
mosRedirect( 'index2.php?option='. $option .'&scope='. $row->scope .'&mosmsg='. $msg );
}
if ( $uid ) {
$row->checkout( $my->id );
if ( $row->id > 0 ) {
$query = "SELECT *"
. "\n FROM #__menu"
. "\n WHERE componentid = '". $row->id ."'"
. "\n AND ( type = 'content_archive_section' OR type = 'content_blog_section' OR type = 'content_section' )"
;
$database->setQuery( $query );
$menus = $database->loadObjectList();
$count = count( $menus );
for( $i = 0; $i < $count; $i++ ) {
switch ( $menus[$i]->type ) {
case 'content_section':
$menus[$i]->type = 'Section Table';
break;
case 'content_blog_section':
$menus[$i]->type = 'Section Blog';
break;
case 'content_archive_section':
$menus[$i]->type = 'Section Blog Archive';
break;
}
}
} else {
$menus = array();
}
} else {
$row->scope = $scope;
$row->published = 1;
$menus = array();
}
// build the html select list for section types
$types[] = mosHTML::makeOption( '', 'Select Type' );
$types[] = mosHTML::makeOption( 'content_section', 'Section List' );
$types[] = mosHTML::makeOption( 'content_blog_section', 'Section Blog' );
$types[] = mosHTML::makeOption( 'content_archive_section', 'Section Archive Blog' );
$lists['link_type'] = mosHTML::selectList( $types, 'link_type', 'class="inputbox" size="1"', 'value', 'text' );;
// build the html select list for ordering
$query = "SELECT ordering AS value, title AS text"
. "\n FROM #__sections"
. "\n WHERE scope='$row->scope' ORDER BY ordering"
;
$lists['ordering'] = mosAdminMenus::SpecificOrdering( $row, $uid, $query );
// build the select list for the image positions
$active = ( $row->image_position ? $row->image_position : 'left' );
$lists['image_position'] = mosAdminMenus::Positions( 'image_position', $active, NULL, 0 );
// build the html select list for images
$lists['image'] = mosAdminMenus::Images( 'image', $row->image );
// build the html select list for the group access
$lists['access'] = mosAdminMenus::Access( $row );
// build the html radio buttons for published
$lists['published'] = mosHTML::yesnoRadioList( 'published', 'class="inputbox"', $row->published );
// build the html select list for menu selection
$lists['menuselect'] = mosAdminMenus::MenuSelect( );
sections_html::edit( $row, $option, $lists, $menus );
}
/**
* Saves the catefory after an edit form submit
* @param database A database connector object
* @param string The name of the category section
*/
function saveSection( $option, $scope, $task ) {
global $database;
$menu = mosGetParam( $_POST, 'menu', 'mainmenu' );
$menuid = mosGetParam( $_POST, 'menuid', 0 );
$oldtitle = mosGetParam( $_POST, 'oldtitle', null );
$row = new mosSection( $database );
if (!$row->bind( $_POST )) {
echo "<script> alert('".$row->getError()."'); document.location.href='index2.php?option=$option&scope=$scope&task=new'; </script>\n";
exit();
}
if (!$row->check()) {
echo "<script> alert('".$row->getError()."'); document.location.href='index2.php?option=$option&scope=$scope&task=new'; </script>\n";
exit();
}
if ( $oldtitle ) {
if ( $oldtitle != $row->title ) {
$query = "UPDATE #__menu"
. "\n SET name = '$row->title'"
. "\n WHERE name = '$oldtitle'"
. "\n AND type = 'content_section'"
;
$database->setQuery( $query );
$database->query();
}
}
if (!$row->store()) {
echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
exit();
}
$row->checkin();
$row->updateOrder( "scope='$row->scope'" );
switch ( $task ) {
case 'go2menu':
mosRedirect( 'index2.php?option=com_menus&menutype='. $menu );
break;
case 'go2menuitem':
mosRedirect( 'index2.php?option=com_menus&menutype='. $menu .'&task=edit&hidemainmenu=1&id='. $menuid );
break;
case 'menulink':
menuLink( $row->id );
break;
case 'apply':
$msg = 'Changes to Section saved';
mosRedirect( 'index2.php?option='. $option .'&scope='. $scope .'&task=editA&hidemainmenu=1&id='. $row->id, $msg );
break;
case 'save':
default:
$msg = 'Section saved';
mosRedirect( 'index2.php?option='. $option .'&scope='. $scope, $msg );
break;
}
}
/**
* Deletes one or more categories from the categories table
* @param database A database connector object
* @param string The name of the category section
* @param array An array of unique category id numbers
*/
function removeSections( $cid, $scope, $option ) {
global $database;
if (count( $cid ) < 1) {
echo "<script> alert('Select a section to delete'); window.history.go(-1);</script>\n";
exit;
}
$cids = implode( ',', $cid );
$query = "SELECT s.id, s.name, COUNT(c.id) AS numcat"
. "\n FROM #__sections AS s"
. "\n LEFT JOIN #__categories AS c ON c.section=s.id"
. "\n WHERE s.id IN ( $cids )"
. "\n GROUP BY s.id"
;
$database->setQuery( $query );
if (!($rows = $database->loadObjectList())) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
}
$err = array();
$cid = array();
foreach ($rows as $row) {
if ($row->numcat == 0) {
$cid[] = $row->id;
$name[] = $row->name;
} else {
$err[] = $row->name;
}
}
if (count( $cid )) {
$cids = implode( ',', $cid );
$query = "DELETE FROM #__sections"
. "\n WHERE id IN ( $cids )"
;
$database->setQuery( $query );
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
}
}
if (count( $err )) {
$cids = implode( ', ', $err );
$msg = 'Sections(s): '. $cids .' cannot be removed as they contain categories';
mosRedirect( 'index2.php?option='. $option .'&scope='. $scope, $msg );
}
$names = implode( ', ', $name );
$msg = 'Section(s): '. $names .' successfully deleted';
mosRedirect( 'index2.php?option='. $option .'&scope='. $scope, $msg );
}
/**
* Publishes or Unpublishes one or more categories
* @param database A database connector object
* @param string The name of the category section
* @param integer A unique category id (passed from an edit form)
* @param array An array of unique category id numbers
* @param integer 0 if unpublishing, 1 if publishing
* @param string The name of the current user
*/
function publishSections( $scope, $cid=null, $publish=1, $option ) {
global $database, $my;
if ( !is_array( $cid ) || count( $cid ) < 1 ) {
$action = $publish ? 'publish' : 'unpublish';
echo "<script> alert('Select a section to $action'); window.history.go(-1);</script>\n";
exit;
}
$cids = implode( ',', $cid );
$count = count( $cid );
if ( $publish ) {
if ( !$count ){
echo "<script> alert('Cannot Publish an Empty Section $count'); window.history.go(-1);</script>\n";
return;
}
}
$query = "UPDATE #__sections"
. "\n SET published = " . intval( $publish )
. "\n WHERE id IN ( $cids )"
. "\n AND ( checked_out = 0 OR ( checked_out = $my->id ) )"
;
$database->setQuery( $query );
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
exit();
}
if ( $count == 1 ) {
$row = new mosSection( $database );
$row->checkin( $cid[0] );
}
// check if section linked to menu items if unpublishing
if ( $publish == 0 ) {
$query = "SELECT id"
. "\n FROM #__menu"
. "\n WHERE type = 'content_section'"
. "\n AND componentid IN ( $cids )"
;
$database->setQuery( $query );
$menus = $database->loadObjectList();
if ($menus) {
foreach ($menus as $menu) {
$query = "UPDATE #__menu"
. "\n SET published = " . intval( $publish )
. "\n WHERE id = $menu->id"
;
$database->setQuery( $query );
$database->query();
}
}
}
mosRedirect( 'index2.php?option='. $option .'&scope='. $scope );
}
/**
* Cancels an edit operation
* @param database A database connector object
* @param string The name of the category section
* @param integer A unique category id
*/
function cancelSection( $option, $scope ) {
global $database;
$row = new mosSection( $database );
$row->bind( $_POST );
$row->checkin();
mosRedirect( 'index2.php?option='. $option .'&scope='. $scope );
}
/**
* Moves the order of a record
* @param integer The increment to reorder by
*/
function orderSection( $uid, $inc, $option, $scope ) {
global $database;
$row = new mosSection( $database );
$row->load( $uid );
$row->move( $inc, "scope = '$row->scope'" );
mosRedirect( 'index2.php?option='. $option .'&scope='. $scope );
}
/**
* Form for copying item(s) to a specific menu
*/
function copySectionSelect( $option, $cid, $section ) {
global $database;
if (!is_array( $cid ) || count( $cid ) < 1) {
echo "<script> alert('Select an item to move'); window.history.go(-1);</script>\n";
exit;
}
## query to list selected categories
$cids = implode( ',', $cid );
$query = "SELECT a.name, a.id"
. "\n FROM #__categories AS a"
. "\n WHERE a.section IN ( $cids )"
;
$database->setQuery( $query );
$categories = $database->loadObjectList();
## query to list items from categories
$query = "SELECT a.title, a.id"
. "\n FROM #__content AS a"
. "\n WHERE a.sectionid IN ( $cids )"
. "\n ORDER BY a.sectionid, a.catid, a.title"
;
$database->setQuery( $query );
$contents = $database->loadObjectList();
sections_html::copySectionSelect( $option, $cid, $categories, $contents, $section );
}
/**
* Save the item(s) to the menu selected
*/
function copySectionSave( $sectionid ) {
global $database;
$title = mosGetParam( $_REQUEST, 'title', '' );
$contentid = mosGetParam( $_REQUEST, 'content', '' );
$categoryid = mosGetParam( $_REQUEST, 'category', '' );
// copy section
$section = new mosSection ( $database );
foreach( $sectionid as $id ) {
$section->load( $id );
$section->id = NULL;
$section->title = $title;
$section->name = $title;
if ( !$section->check() ) {
echo "<script> alert('".$section->getError()."'); window.history.go(-1); </script>\n";
exit();
}
if ( !$section->store() ) {
echo "<script> alert('".$section->getError()."'); window.history.go(-1); </script>\n";
exit();
}
$section->checkin();
$section->updateOrder( "section = '$section->id'" );
// stores original catid
$newsectids[]["old"] = $id;
// pulls new catid
$newsectids[]["new"] = $section->id;
}
$sectionMove = $section->id;
// copy categories
$category = new mosCategory ( $database );
foreach( $categoryid as $id ) {
$category->load( $id );
$category->id = NULL;
$category->section = $sectionMove;
foreach( $newsectids as $newsectid ) {
if ( $category->section == $newsectid["old"] ) {
$category->section = $newsectid["new"];
}
}
if (!$category->check()) {
echo "<script> alert('".$category->getError()."'); window.history.go(-1); </script>\n";
exit();
}
if (!$category->store()) {
echo "<script> alert('".$category->getError()."'); window.history.go(-1); </script>\n";
exit();
}
$category->checkin();
$category->updateOrder( "section = '$category->section'" );
// stores original catid
$newcatids[]["old"] = $id;
// pulls new catid
$newcatids[]["new"] = $category->id;
}
$content = new mosContent ( $database );
foreach( $contentid as $id) {
$content->load( $id );
$content->id = NULL;
$content->hits = 0;
foreach( $newsectids as $newsectid ) {
if ( $content->sectionid == $newsectid["old"] ) {
$content->sectionid = $newsectid["new"];
}
}
foreach( $newcatids as $newcatid ) {
if ( $content->catid == $newcatid["old"] ) {
$content->catid = $newcatid["new"];
}
}
if (!$content->check()) {
echo "<script> alert('".$content->getError()."'); window.history.go(-1); </script>\n";
exit();
}
if (!$content->store()) {
echo "<script> alert('".$content->getError()."'); window.history.go(-1); </script>\n";
exit();
}
$content->checkin();
}
$sectionOld = new mosSection ( $database );
$sectionOld->load( $sectionMove );
$msg = 'Section '. $sectionOld-> name .' and all its Categories and Items have been copied as '. $title;
mosRedirect( 'index2.php?option=com_sections&scope=content&mosmsg='. $msg );
}
/**
* changes the access level of a record
* @param integer The increment to reorder by
*/
function accessMenu( $uid, $access, $option ) {
global $database;
$row = new mosSection( $database );
$row->load( $uid );
$row->access = $access;
if ( !$row->check() ) {
return $row->getError();
}
if ( !$row->store() ) {
return $row->getError();
}
mosRedirect( 'index2.php?option='. $option .'&scope='. $row->scope );
}
function menuLink( $id ) {
global $database;
$section = new mosSection( $database );
$section->bind( $_POST );
$section->checkin();
$menu = mosGetParam( $_POST, 'menuselect', '' );
$name = mosGetParam( $_POST, 'link_name', '' );
$type = mosGetParam( $_POST, 'link_type', '' );
switch ( $type ) {
case 'content_section':
$link = 'index.php?option=com_content&task=section&id='. $id;
$menutype = 'Section Table';
break;
case 'content_blog_section':
$link = 'index.php?option=com_content&task=blogsection&id='. $id;
$menutype = 'Section Blog';
break;
case 'content_archive_section':
$link = 'index.php?option=com_content&task=archivesection&id='. $id;
$menutype = 'Section Blog Archive';
break;
}
$row = new mosMenu( $database );
$row->menutype = $menu;
$row->name = $name;
$row->type = $type;
$row->published = 1;
$row->componentid = $id;
$row->link = $link;
$row->ordering = 9999;
if ( $type == 'content_blog_section' ) {
$row->params = 'sectionid='. $id;
}
if (!$row->check()) {
echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
exit();
}
if (!$row->store()) {
echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
exit();
}
$row->checkin();
$row->updateOrder( "menutype = '$menu'" );
$msg = $name .' ( '. $menutype .' ) in menu: '. $menu .' successfully created';
mosRedirect( 'index2.php?option=com_sections&scope=content&task=editA&hidemainmenu=1&id='. $id, $msg );
}
function saveOrder( &$cid ) {
global $database;
$total = count( $cid );
$order = mosGetParam( $_POST, 'order', array(0) );
$row = new mosSection( $database );
$conditions = array();
// update ordering values
for( $i=0; $i < $total; $i++ ) {
$row->load( $cid[$i] );
if ($row->ordering != $order[$i]) {
$row->ordering = $order[$i];
if (!$row->store()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
exit();
} // if
// remember to updateOrder this group
$condition = "scope = '$row->scope'";
$found = false;
foreach ( $conditions as $cond )
if ($cond[1]==$condition) {
$found = true;
break;
} // if
if (!$found) $conditions[] = array($row->id, $condition);
} // if
} // for
// execute updateOrder for each group
foreach ( $conditions as $cond ) {
$row->load( $cond[0] );
$row->updateOrder( $cond[1] );
} // foreach
$msg = 'New ordering saved';
mosRedirect( 'index2.php?option=com_sections&scope=content', $msg );
} // saveOrder
?>
No other release has this exact content. See every version of this file.