- md5
- 432c264a697a2ae4c47ea4a453d542b0
- sha1
- 5e90515007fe7b44fd6d3c5886d05d8bfe3bb37d
- sha256
- ecc3a0648ffd2d7cacd116d0244ba28a2738cb55610d8565e372031c8a1a846e
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304
<?php
/**
* @version $Id: admin.frontpage.php 393 2005-10-08 13:37:52Z akede $
* @package Joomla
* @subpackage Content
* @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' );
// ensure user has access to this function
if (!($acl->acl_check( 'administration', 'edit', 'users', $my->usertype, 'components', 'all' )
| $acl->acl_check( 'administration', 'edit', 'users', $my->usertype, 'components', 'com_frontpage' ))) {
mosRedirect( 'index2.php', _NOT_AUTH );
}
// call
require_once( $mainframe->getPath( 'admin_html' ) );
require_once( $mainframe->getPath( 'class' ) );
$task = mosGetParam( $_REQUEST, 'task', array(0) );
$cid = mosGetParam( $_POST, 'cid', array(0) );
if (!is_array( $cid )) {
$cid = array(0);
}
switch ($task) {
case 'publish':
changeFrontPage( $cid, 1, $option );
break;
case 'unpublish':
changeFrontPage( $cid, 0, $option );
break;
case 'archive':
changeFrontPage( $cid, -1, $option );
break;
case 'remove':
removeFrontPage( $cid, $option );
break;
case 'orderup':
orderFrontPage( $cid[0], -1, $option );
break;
case 'orderdown':
orderFrontPage( $cid[0], 1, $option );
break;
case 'saveorder':
saveOrder( $cid );
break;
case 'accesspublic':
accessMenu( $cid[0], 0 );
break;
case 'accessregistered':
accessMenu( $cid[0], 1 );
break;
case 'accessspecial':
accessMenu( $cid[0], 2 );
break;
default:
viewFrontPage( $option );
break;
}
/**
* Compiles a list of frontpage items
*/
function viewFrontPage( $option ) {
global $database, $mainframe, $mosConfig_list_limit;
$catid = $mainframe->getUserStateFromRequest( "catid{$option}", 'catid', 0 );
$filter_authorid = $mainframe->getUserStateFromRequest( "filter_authorid{$option}", 'filter_authorid', 0 );
$filter_sectionid = $mainframe->getUserStateFromRequest( "filter_sectionid{$option}", 'filter_sectionid', 0 );
$limit = $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit );
$limitstart = $mainframe->getUserStateFromRequest( "view{$option}limitstart", 'limitstart', 0 );
$search = $mainframe->getUserStateFromRequest( "search{$option}", 'search', '' );
$search = $database->getEscaped( trim( strtolower( $search ) ) );
$where = array(
"c.state >= 0"
);
// used by filter
if ( $filter_sectionid > 0 ) {
$where[] = "c.sectionid = '$filter_sectionid'";
}
if ( $catid > 0 ) {
$where[] = "c.catid = '$catid'";
}
if ( $filter_authorid > 0 ) {
$where[] = "c.created_by = $filter_authorid";
}
if ($search) {
$where[] = "LOWER( c.title ) LIKE '%$search%'";
}
// get the total number of records
$query = "SELECT count(*)"
. "\n FROM #__content AS c"
. "\n INNER JOIN #__categories AS cc ON cc.id = c.catid"
. "\n INNER JOIN #__sections AS s ON s.id = cc.section AND s.scope='content'"
. "\n INNER JOIN #__content_frontpage AS f ON f.content_id = c.id"
. (count( $where ) ? "\n WHERE " . implode( ' AND ', $where ) : '' )
;
$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, cc.name, s.name AS sect_name, u.name AS editor, f.ordering AS fpordering, v.name AS author"
. "\n FROM #__content AS c"
. "\n INNER JOIN #__categories AS cc ON cc.id = c.catid"
. "\n INNER JOIN #__sections AS s ON s.id = cc.section AND s.scope='content'"
. "\n INNER JOIN #__content_frontpage AS f ON f.content_id = c.id"
. "\n INNER JOIN #__groups AS g ON g.id = c.access"
. "\n LEFT JOIN #__users AS u ON u.id = c.checked_out"
. "\n LEFT JOIN #__users AS v ON v.id = c.created_by"
. (count( $where ) ? "\nWHERE " . implode( ' AND ', $where ) : "")
. "\n ORDER BY f.ordering"
. "\n LIMIT $pageNav->limitstart,$pageNav->limit"
;
$database->setQuery( $query );
$rows = $database->loadObjectList();
if ($database->getErrorNum()) {
echo $database->stderr();
return false;
}
// get list of categories for dropdown filter
$query = "SELECT cc.id AS value, cc.title AS text, section"
. "\n FROM #__categories AS cc"
. "\n INNER JOIN #__sections AS s ON s.id = cc.section "
. "\n ORDER BY s.ordering, cc.ordering"
;
$categories[] = mosHTML::makeOption( '0', _SEL_CATEGORY );
$database->setQuery( $query );
$categories = array_merge( $categories, $database->loadObjectList() );
$lists['catid'] = mosHTML::selectList( $categories, 'catid', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', $catid );
// get list of sections for dropdown filter
$javascript = 'onchange="document.adminForm.submit();"';
$lists['sectionid'] = mosAdminMenus::SelectSection( 'filter_sectionid', $filter_sectionid, $javascript );
// get list of Authors for dropdown filter
$query = "SELECT c.created_by, u.name"
. "\n FROM #__content AS c"
. "\n INNER JOIN #__sections AS s ON s.id = c.sectionid"
. "\n LEFT JOIN #__users AS u ON u.id = c.created_by"
. "\n WHERE c.state != -1"
. "\n AND c.state != -2"
. "\n GROUP BY u.name"
. "\n ORDER BY u.name"
;
$authors[] = mosHTML::makeOption( '0', _SEL_AUTHOR, 'created_by', 'name' );
$database->setQuery( $query );
$authors = array_merge( $authors, $database->loadObjectList() );
$lists['authorid'] = mosHTML::selectList( $authors, 'filter_authorid', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'created_by', 'name', $filter_authorid );
HTML_content::showList( $rows, $search, $pageNav, $option, $lists );
}
/**
* Changes the state of one or more content pages
* @param array An array of unique category id numbers
* @param integer 0 if unpublishing, 1 if publishing
*/
function changeFrontPage( $cid=null, $state=0, $option ) {
global $database, $my;
if (count( $cid ) < 1) {
$action = $state == 1 ? 'publish' : ($state == -1 ? 'archive' : 'unpublish');
echo "<script> alert('Select an item to $action'); window.history.go(-1);</script>\n";
exit;
}
$cids = implode( ',', $cid );
$query = "UPDATE #__content"
. "\n SET state = $state"
. "\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( $cid ) == 1) {
$row = new mosContent( $database );
$row->checkin( $cid[0] );
}
mosRedirect( "index2.php?option=$option" );
}
function removeFrontPage( &$cid, $option ) {
global $database;
if (!is_array( $cid ) || count( $cid ) < 1) {
echo "<script> alert('Select an item to delete'); window.history.go(-1);</script>\n";
exit;
}
$fp = new mosFrontPage( $database );
foreach ($cid as $id) {
if (!$fp->delete( $id )) {
echo "<script> alert('".$fp->getError()."'); </script>\n";
exit();
}
$obj = new mosContent( $database );
$obj->load( $id );
$obj->mask = 0;
if (!$obj->store()) {
echo "<script> alert('".$fp->getError()."'); </script>\n";
exit();
}
}
$fp->updateOrder();
mosRedirect( "index2.php?option=$option" );
}
/**
* Moves the order of a record
* @param integer The increment to reorder by
*/
function orderFrontPage( $uid, $inc, $option ) {
global $database;
$fp = new mosFrontPage( $database );
$fp->load( $uid );
$fp->move( $inc );
mosRedirect( "index2.php?option=$option" );
}
/**
* @param integer The id of the content item
* @param integer The new access level
* @param string The URL option
*/
function accessMenu( $uid, $access ) {
global $database;
$row = new mosContent( $database );
$row->load( $uid );
$row->access = $access;
if ( !$row->check() ) {
return $row->getError();
}
if ( !$row->store() ) {
return $row->getError();
}
mosRedirect( 'index2.php?option=com_frontpage' );
}
function saveOrder( &$cid ) {
global $database;
$total = count( $cid );
$order = mosGetParam( $_POST, 'order', array(0) );
for( $i=0; $i < $total; $i++ ) {
$query = "UPDATE #__content_frontpage"
. "\n SET ordering = $order[$i]"
. "\n WHERE content_id = $cid[$i]";
$database->setQuery( $query );
if (!$database->query()) {
echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
exit();
}
// update ordering
$row = new mosFrontPage( $database );
$row->load( $cid[$i] );
$row->updateOrder();
}
$msg = 'New ordering saved';
mosRedirect( 'index2.php?option=com_frontpage', $msg );
}
?>
The same content is in 3 releases, Joomla 1.0.3 to 1.0.7. See them all, or every version of this file.