コード例 #1
0
/**
 * The following function was taken from admin.frontpage.php Joomla 1.0
 * @copyright Copyright (C) 2005 Open Source Matters. All rights reserved.
 * modification aHa - additional saveorder for categories
 * @see admin.joomgallery.php // only backend
 * @param int $cid
 * @param unknown_type $catg
 */
function Joom_SaveOrder(&$cid, &$catg)
{
    $mainframe =& JFactory::getApplication('administrator');
    $database =& JFactory::getDBO();
    $returntask = Joom_mosGetParam('returntask', null);
    if ($returntask == 'pictures') {
        $total = count($cid);
        $order = Joom_mosGetParam('order', array(0), 'post');
        for ($i = 0; $i < $total; $i++) {
            //get catid
            $database->setQuery("SELECT catid\n          FROM #__joomgallery\n          WHERE id={$cid[$i]}");
            $piccatid = $database->loadResult();
            $query = "UPDATE #__joomgallery\n          SET ordering = {$order[$i]}\n          WHERE id = {$cid[$i]}";
            $database->setQuery($query);
            if (!$database->query()) {
                echo "<script> alert('" . $database->getErrorMsg() . "');\n              window.history.go(-1); </script>\n";
                exit;
            }
            // update ordering
            $row = new mosjoomgallery($database);
            $row->load($cid[$i]);
            $row->reorder('catid=' . $piccatid);
        }
        $mainframe->redirect('index.php?option=' . _JOOM_OPTION . '&act=pictures', JText::_('JG_NEW_ORDERING_SAVED'));
    } else {
        $total = count($catg);
        $order = Joom_mosGetParam('order', array(0), 'post');
        for ($i = 0; $i < $total; $i++) {
            $query = "UPDATE #__joomgallery_catg\n          SET ordering = {$order[$i]}\n          WHERE cid = {$catg[$i]}";
            $database->setQuery($query);
            if (!$database->query()) {
                echo "<script> alert('" . $database->getErrorMsg() . "');\n              window.history.go(-1); </script>\n";
                exit;
            }
            // update ordering
            $row = new mosjoomgallery($database);
            $row->load($catg[$i]);
            $row->reorder('');
        }
        $mainframe->redirect('index.php?option=' . _JOOM_OPTION . '&act=categories', JText::_('JG_NEW_ORDERING_SAVED'));
    }
}
コード例 #2
0
 /**
  * provide functionality to set ordering with arrow symbols
  *
  * @param int $uid: id from picture e.g. 10
  * @param int $inc: control varaible up oder down, 1 or -1
  */
 function Joom_OrderPictures($uid, $inc)
 {
     $mainframe =& JFactory::getApplication('administrator');
     $database =& JFactory::getDBO();
     //get catid
     $database->setQuery("SELECT catid\n        FROM #__joomgallery\n        WHERE id={$uid}");
     $piccatid = $database->loadResult();
     $fp = new mosjoomgallery($database);
     $fp->load($uid);
     $fp->move($inc, 'catid=' . $piccatid);
     $fp->reorder('catid=' . $piccatid);
     $mainframe->redirect('index.php?option=' . _JOOM_OPTION . '&act=pictures');
 }