/** * 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')); } }
/** * 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'); }