administrator/components/com_typedcontent/admin.typedcontent.php

gehe zur Dokumentation dieser Datei

<?php
// no direct access
defined( '_VALID_MOS' ) or die( 'Restricted access' );

require_once( $mainframe->getPath( 'admin_html' ) );

$cid = josGetArrayInts( 'cid' );

switch ( $task ) {
        case 'cancel':
                cancel( $option );
                break;

        case 'new':
                edit( 0, $option );
                break;

        case 'edit':
                edit( $id, $option );
                break;

        case 'editA':
                edit( intval( $cid[0] ), $option );
                break;

        case 'go2menu':
        case 'go2menuitem':
        case 'resethits':
        case 'menulink':
        case 'save':
        case 'apply':
                save( $option, $task );
                break;

        case 'remove':
                trash( $cid, $option );
                break;

        case 'publish':
                changeState( $cid, 1, $option );
                break;

        case 'unpublish':
                changeState( $cid, 0, $option );
                break;

        case 'accesspublic':
                changeAccess( intval( $cid[0] ), 0, $option );
                break;

        case 'accessregistered':
                changeAccess( intval( $cid[0] ), 1, $option );
                break;

        case 'accessspecial':
                changeAccess( intval( $cid[0] ), 2, $option );
                break;

        case 'saveorder':
                saveOrder( $cid );
                break;

        default:
                view( $option );
                break;
}

function view( $option ) {
        global $database, $mainframe, $mosConfig_list_limit;

        $filter_authorid        = intval( $mainframe->getUserStateFromRequest( "filter_authorid{$option}", 'filter_authorid', 0 ) );
        $order                          = $mainframe->getUserStateFromRequest( "zorder", 'zorder', 'c.ordering DESC' );
        $limit                          = intval( $mainframe->getUserStateFromRequest( "viewlistlimit", 'limit', $mosConfig_list_limit ) );
        $limitstart             = intval( $mainframe->getUserStateFromRequest( "view{$option}limitstart", 'limitstart', 0 ) );
        $search                         = $mainframe->getUserStateFromRequest( "search{$option}", 'search', '' );
        if (get_magic_quotes_gpc()) {
                $search                 = stripslashes( $search );
        }

        // used by filter
        if ( $search ) {
                $searchEscaped = $database->getEscaped( trim( strtolower( $search ) ) );
                $search_query = "\n AND ( LOWER( c.title ) LIKE '%$searchEscaped%' OR LOWER( c.title_alias ) LIKE '%$searchEscaped%' )";
        } else {
                $search_query = '';
        }

        $filter = '';
        if ( $filter_authorid > 0 ) {
                $filter = "\n AND c.created_by = " . (int) $filter_authorid;
        }

        $orderAllowed = array( 'c.ordering ASC', 'c.ordering DESC', 'c.id ASC', 'c.id DESC', 'c.title ASC', 'c.title DESC', 'c.created ASC', 'c.created DESC', 'z.name ASC', 'z.name DESC', 'c.state ASC', 'c.state DESC', 'c.access ASC', 'c.access DESC' );
        if (!in_array( $order, $orderAllowed )) {
                $order = 'c.ordering DESC';
        }

        // get the total number of records
        $query = "SELECT count(*)"
        . "\n FROM #__content AS c"
        . "\n WHERE c.sectionid = 0"
        . "\n AND c.catid = 0"
        . "\n AND c.state != -2"
        . $search_query
        . $filter
        ;
        $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, z.name AS creator"
        . "\n FROM #__content AS c"
        . "\n LEFT 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 z ON z.id = c.created_by"
        . "\n WHERE c.sectionid = 0"
        . "\n AND c.catid = 0"
        . "\n AND c.state != -2"
        . $search_query
        . $filter
        . "\n ORDER BY ". $order
        ;
        $database->setQuery( $query, $pageNav->limitstart, $pageNav->limit );
        $rows = $database->loadObjectList();

        if ($database->getErrorNum()) {
                echo $database->stderr();
                return false;
        }

        $count = count( $rows );
        for( $i = 0; $i < $count; $i++ ) {
                $query = "SELECT COUNT( id )"
                . "\n FROM #__menu"
                . "\n WHERE componentid = " . (int) $rows[$i]->id
                . "\n AND type = 'content_typed'"
                . "\n AND published != -2"
                ;
                $database->setQuery( $query );
                $rows[$i]->links = $database->loadResult();
        }

        $ordering[] = mosHTML::makeOption( 'c.ordering ASC', 'Ordering asc' );
        $ordering[] = mosHTML::makeOption( 'c.ordering DESC', 'Ordering desc' );
        $ordering[] = mosHTML::makeOption( 'c.id ASC', 'ID asc' );
        $ordering[] = mosHTML::makeOption( 'c.id DESC', 'ID desc' );
        $ordering[] = mosHTML::makeOption( 'c.title ASC', 'Title asc' );
        $ordering[] = mosHTML::makeOption( 'c.title DESC', 'Title desc' );
        $ordering[] = mosHTML::makeOption( 'c.created ASC', 'Date asc' );
        $ordering[] = mosHTML::makeOption( 'c.created DESC', 'Date desc' );
        $ordering[] = mosHTML::makeOption( 'z.name ASC', 'Author asc' );
        $ordering[] = mosHTML::makeOption( 'z.name DESC', 'Author desc' );
        $ordering[] = mosHTML::makeOption( 'c.state ASC', 'Published asc' );
        $ordering[] = mosHTML::makeOption( 'c.state DESC', 'Published desc' );
        $ordering[] = mosHTML::makeOption( 'c.access ASC', 'Access asc' );
        $ordering[] = mosHTML::makeOption( 'c.access DESC', 'Access desc' );
        $javascript = 'onchange="document.adminForm.submit();"';
        $lists['order'] = mosHTML::selectList( $ordering, 'zorder', 'class="inputbox" size="1"'. $javascript, 'value', 'text', $order );

        // get list of Authors for dropdown filter
        $query = "SELECT c.created_by AS value, u.name AS text"
        . "\n FROM #__content AS c"
        . "\n LEFT JOIN #__users AS u ON u.id = c.created_by"
        . "\n WHERE c.sectionid = 0"
        . "\n GROUP BY u.name"
        . "\n ORDER BY u.name"
        ;
        $authors[] = mosHTML::makeOption( '0', _SEL_AUTHOR );
        $database->setQuery( $query );
        $authors = array_merge( $authors, $database->loadObjectList() );
        $lists['authorid']      = mosHTML::selectList( $authors, 'filter_authorid', 'class="inputbox" size="1" onchange="document.adminForm.submit( );"', 'value', 'text', $filter_authorid );

        HTML_typedcontent::showContent( $rows, $pageNav, $option, $search, $lists );
}

function edit( $uid, $option ) {
        global $database, $my, $mainframe;
        global $mosConfig_absolute_path, $mosConfig_live_site, $mosConfig_offset;

        $row = new mosContent( $database );
        $row->load( (int)$uid );

        $lists          = array();
        $nullDate       = $database->getNullDate();

        if ($uid) {
                // fail if checked out not by 'me'
                if ($row->isCheckedOut( $my->id )) {
                        mosErrorAlert( "The module ".$row->title." is currently being edited by another administrator" );
                }

                $row->checkout( $my->id );

                if (trim( $row->images )) {
                        $row->images = explode( "\n", $row->images );
                } else {
                        $row->images = array();
                }

                $row->created           = mosFormatDate( $row->created, _CURRENT_SERVER_TIME_FORMAT );
                $row->modified          = $row->modified == $nullDate ? '' : mosFormatDate( $row->modified, _CURRENT_SERVER_TIME_FORMAT );
                $row->publish_up        = mosFormatDate( $row->publish_up, _CURRENT_SERVER_TIME_FORMAT );

                if (trim( $row->publish_down ) == $nullDate || trim( $row->publish_down ) == '' || trim( $row->publish_down ) == '-' ) {
                        $row->publish_down = 'Never';
                }
                $row->publish_down      = mosFormatDate( $row->publish_down, _CURRENT_SERVER_TIME_FORMAT );

                $query = "SELECT name"
                . "\n FROM #__users"
                . "\n WHERE id = " . (int) $row->created_by
                ;
                $database->setQuery( $query );
                $row->creator = $database->loadResult();

                // test to reduce unneeded query
                if ( $row->created_by == $row->modified_by ) {
                        $row->modifier = $row->creator;
                } else {
                        $query = "SELECT name"
                        . "\n FROM #__users"
                        . "\n WHERE id = " . (int) $row->modified_by
                        ;
                        $database->setQuery( $query );
                        $row->modifier = $database->loadResult();
                }

                // get list of links to this item
                $and    = "\n AND componentid = " . (int) $row->id;
                $menus  = mosAdminMenus::Links2Menu( 'content_typed', $and );
        } else {
                // initialise values for a new item
                $row->version           = 0;
                $row->state             = 1;
                $row->images            = array();
                $row->publish_up        = date( 'Y-m-d H:i:s', time() + ( $mosConfig_offset * 60 * 60 ) );
                $row->publish_down      = 'Never';
                $row->sectionid         = 0;
                $row->catid             = 0;
                $row->creator           = '';
                $row->modified          = $nullDate;
                $row->modifier          = '';
                $row->ordering          = 0;
                $menus = array();
        }

        // calls function to read image from directory
        $pathA          = $mosConfig_absolute_path .'/images/stories';
        $pathL          = $mosConfig_live_site .'/images/stories';
        $images         = array();
        $folders        = array();
        $folders[]      = mosHTML::makeOption( '/' );
        mosAdminMenus::ReadImages( $pathA, '/', $folders, $images );
        // list of folders in images/stories/
        $lists['folders']               = mosAdminMenus::GetImageFolders( $folders, $pathL );
        // list of images in specfic folder in images/stories/
        $lists['imagefiles']    = mosAdminMenus::GetImages( $images, $pathL );
        // list of saved images
        $lists['imagelist']     = mosAdminMenus::GetSavedImages( $row, $pathL );

        // build list of users
        $active = ( intval( $row->created_by ) ? intval( $row->created_by ) : $my->id );
        $lists['created_by']    = mosAdminMenus::UserSelect( 'created_by', $active );
        // build the html select list for the group access
        $lists['access']                = mosAdminMenus::Access( $row );
        // build the html select list for menu selection
        $lists['menuselect']    = mosAdminMenus::MenuSelect( );
        // build the select list for the image positions
        $lists['_align']                = mosAdminMenus::Positions( '_align' );
        // build the select list for the image caption alignment
        $lists['_caption_align']        = mosAdminMenus::Positions( '_caption_align' );
        // build the select list for the image caption position
        $pos[] = mosHTML::makeOption( 'bottom', _CMN_BOTTOM );
        $pos[] = mosHTML::makeOption( 'top', _CMN_TOP );
        $lists['_caption_position'] = mosHTML::selectList( $pos, '_caption_position', 'class="inputbox" size="1"', 'value', 'text' );

        // get params definitions
        $params = new mosParameters( $row->attribs, $mainframe->getPath( 'com_xml', 'com_typedcontent' ), 'component' );

        HTML_typedcontent::edit( $row, $images, $lists, $params, $option, $menus );
}

function save( $option, $task ) {
        global $database, $my, $mosConfig_offset;
        
        josSpoofCheck();

        $nullDate       = $database->getNullDate();
        $menu           = strval( mosGetParam( $_POST, 'menu', 'mainmenu' ) );
        $menuid         = intval( mosGetParam( $_POST, 'menuid', 0 ) );

        $row = new mosContent( $database );
        if (!$row->bind( $_POST )) {
                echo "<script> alert('".$row->getError()."'); window.history.go(-1); </script>\n";
                exit();
        }

        if ($row->id) {
                $row->modified          = date( 'Y-m-d H:i:s' );
                $row->modified_by       = $my->id;
        }

        $row->created_by        = $row->created_by ? $row->created_by : $my->id;

        if ($row->created && strlen(trim( $row->created )) <= 10) {
                $row->created   .= ' 00:00:00';
        }
        $row->created           = $row->created ? mosFormatDate( $row->created, _CURRENT_SERVER_TIME_FORMAT, -$mosConfig_offset ) : date( 'Y-m-d H:i:s' );

        if (strlen(trim( $row->publish_up )) <= 10) {
                $row->publish_up .= ' 00:00:00';
        }
        $row->publish_up = mosFormatDate($row->publish_up, _CURRENT_SERVER_TIME_FORMAT, -$mosConfig_offset );

        if (trim( $row->publish_down ) == 'Never' || trim( $row->publish_down ) == '') {
                $row->publish_down = $nullDate;
        } else {
                if (strlen(trim( $row->publish_down )) <= 10) {
                        $row->publish_down .= ' 00:00:00';
                }
                $row->publish_down = mosFormatDate( $row->publish_down, _CURRENT_SERVER_TIME_FORMAT, -$mosConfig_offset );
        }

        $row->state = intval( mosGetParam( $_REQUEST, 'published', 0 ) );

        // Save Parameters
        $params = mosGetParam( $_POST, 'params', '' );
        if (is_array( $params )) {
                $txt = array();
                foreach ( $params as $k=>$v) {
                        $txt[] = "$k=$v";
                }
                $row->attribs = implode( "\n", $txt );
        }

        // code cleaner for xhtml transitional compliance
        $row->introtext = str_replace( '<br>', '<br />', $row->introtext );

        $row->title = ampReplace( $row->title );

        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();

        // clean any existing cache files
        mosCache::cleanCache( 'com_content' );

        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( $option, $row->id );
                        break;

                case 'resethits':
                        resethits( $option, $row->id );
                        break;

                case 'save':
                        $msg = 'Typed Content Item saved';
                        mosRedirect( 'index2.php?option='. $option, $msg );
                        break;

                case 'apply':
                default:
                        $msg = 'Changes to Typed Content Item saved';
                        mosRedirect( 'index2.php?option='. $option .'&task=edit&hidemainmenu=1&id='. $row->id, $msg );
                        break;
        }
}

function trash( &$cid, $option ) {
        global $database;
        
        josSpoofCheck();

        $total = count( $cid );
        if ( $total < 1) {
                echo "<script> alert('Select an item to delete'); window.history.go(-1);</script>\n";
                exit;
        }

        $state = '-2';
        $ordering = '0';
        //seperate contentids
        mosArrayToInts( $cid );
        $cids = 'id=' . implode( ' OR id=', $cid );
        $query = "UPDATE #__content"
        . "\n SET state = " . (int) $state . ", ordering = " . (int) $ordering
        . "\n WHERE ( $cids )"
        ;
        $database->setQuery( $query );
        if ( !$database->query() ) {
                echo "<script> alert('".$database->getErrorMsg()."'); window.history.go(-1); </script>\n";
                exit();
        }

        // clean any existing cache files
        mosCache::cleanCache( 'com_content' );

        $msg = $total ." Item(s) sent to the Trash";
        mosRedirect( 'index2.php?option='. $option, $msg );
}

function changeState( $cid=null, $state=0, $option ) {
        global $database, $my;
        
        josSpoofCheck();

        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;
        }

        mosArrayToInts( $cid );
        $total  = count ( $cid );
        $cids   = 'id=' . implode( ' OR id=', $cid );

        $query = "UPDATE #__content"
        . "\n SET state = " . (int) $state
        . "\n WHERE ( $cids )"
        . "\n AND ( checked_out = 0 OR ( checked_out = " . (int) $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] );
        }

        // clean any existing cache files
        mosCache::cleanCache( 'com_content' );

        if ( $state == "1" ) {
                $msg = $total ." Item(s) successfully Published";
        } else if ( $state == "0" ) {
                $msg = $total ." Item(s) successfully Unpublished";
        }
        mosRedirect( 'index2.php?option='. $option .'&msg='. $msg );
}

function changeAccess( $id, $access, $option  ) {
        global $database;
        
        josSpoofCheck();

        $row = new mosContent( $database );
        $row->load( (int)$id );
        $row->access = $access;

        if ( !$row->check() ) {
                return $row->getError();
        }
        if ( !$row->store() ) {
                return $row->getError();
        }

        // clean any existing cache files
        mosCache::cleanCache( 'com_content' );

        mosRedirect( 'index2.php?option='. $option );
}


function resethits( $option, $id ) {
        global $database;
        
        josSpoofCheck();

        $row = new mosContent($database);
        $row->Load( (int)$id );
        $row->hits = "0";
        $row->store();
        $row->checkin();

        $msg = 'Successfully Reset Hit';
        mosRedirect( 'index2.php?option='. $option .'&task=edit&hidemainmenu=1&id='. $row->id, $msg );
}

function cancel( $option ) {
        global $database;
        
        josSpoofCheck();

        $row = new mosContent( $database );
        $row->bind( $_POST );
        $row->checkin();
        mosRedirect( 'index2.php?option='. $option );
}

function menuLink( $option, $id ) {
        global $database;
        
        josSpoofCheck();

        $menu   = strval( mosGetParam( $_POST, 'menuselect', '' ) );
        $link   = strval( mosGetParam( $_POST, 'link_name', '' ) );

        $link   = stripslashes( ampReplace($link) );

        $row                            = new mosMenu( $database );
        $row->menutype          = $menu;
        $row->name                      = $link;
        $row->type                      = 'content_typed';
        $row->published         = 1;
        $row->componentid       = $id;
        $row->link                      = 'index.php?option=com_content&task=view&id='. $id;
        $row->ordering          = 9999;

        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=" . $database->Quote( $row->menutype ) . " AND parent=" . (int) $row->parent );

        // clean any existing cache files
        mosCache::cleanCache( 'com_content' );

        $msg = $link .' (Link - Static Content) in menu: '. $menu .' successfully created';
        mosRedirect( 'index2.php?option='. $option .'&task=edit&hidemainmenu=1&id='. $id, $msg );
}

function go2menu() {
        global $database;
        
        josSpoofCheck();

        // checkin content
        $row = new mosContent( $database );
        $row->bind( $_POST );
        $row->checkin();

        $menu = strval( mosGetParam( $_POST, 'menu', 'mainmenu' ) );

        mosRedirect( 'index2.php?option=com_menus&menutype='. $menu );
}

function go2menuitem() {
        global $database;
        
        josSpoofCheck();

        // checkin content
        $row = new mosContent( $database );
        $row->bind( $_POST );
        $row->checkin();

        $menu   = strval( mosGetParam( $_POST, 'menu', 'mainmenu' ) );
        $id             = intval( mosGetParam( $_POST, 'menuid', 0 ) );

        mosRedirect( 'index2.php?option=com_menus&menutype='. $menu .'&task=edit&hidemainmenu=1&id='. $id );
}

function saveOrder( &$cid ) {
        global $database;
        
        josSpoofCheck();

        $total          = count( $cid );
        $order          = josGetArrayInts( 'order' );

        $row            = new mosContent( $database );
        $conditions = array();

        // update ordering values
        for ( $i=0; $i < $total; $i++ ) {
                $row->load( (int) $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 = "catid=" . (int) $row->catid . " AND state >= 0";
                        $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

        // clean any existing cache files
        mosCache::cleanCache( 'com_content' );

        $msg    = 'New ordering saved';
        mosRedirect( 'index2.php?option=com_typedcontent', $msg );
} // saveOrder
?>

Erstellt mit Doxygen
www.joomla-tipps.net