/** * saves a changed or a new category * * @param integer $cid, if null -> new category */ function Joom_User_SaveUserCat(&$cid) { $config = Joom_getConfig(); $mainframe =& JFactory::getApplication('site'); $database =& JFactory::getDBO(); $user =& JFactory::getUser(); jimport('joomla.filesystem.file'); $row = new mosCatgs($database); if ($cid == 0) { $database->setQuery(" SELECT \n COUNT(cid)\n FROM \n #__joomgallery_catg\n WHERE \n owner=" . $user->get('id') . " \n "); $countcat = $database->loadResult(); if ($countcat >= $config->jg_maxusercat) { $mainframe->redirect('index.php?option=com_joomgallery&func=showusercats' . _JOOM_ITEMID, false); } $newcat = true; } else { $newcat = false; //load an existing category $row->load($cid); //get old parent category $parentold = $row->parent; //get old category name $catnameold = $row->name; } //get new values if (!$row->bind($_POST)) { echo "<script> alert('" . $row->getError() . "'); window.history.go(-1); </script>\n"; exit; } if (get_magic_quotes_gpc()) { $row->name = stripslashes($row->name); $row->description = stripslashes($row->description); } if (!$newcat) { if ($catnameold != $row->name) { // Macht den neuen Kategorienamen sicher, wenn geaendert JFilterOutput::objectHTMLSafe($row->name); // Joom_FixCatname; Umlaute werden umgewandelt und alle Sonderzeichen bis auf // den Unterstrich entfernt, gilt nur fuer den catpath $catname = Joom_FixCatname($row->name); $catnamemodif = true; } else { $catname = $catnameold; $catnamemodif = false; } //Kategorieordner verschieben, wenn die Parentzuordnung oder der Kategoriename //geaendert wurde if ($parentold != $row->parent || $catnamemodif == true) { //alten Pfad sichern $catpathold = $row->catpath; //Kategoriepfad der Parent-Kategorie lesen, nur noetig wenn parent != 0 if ($row->parent != 0) { $row_parent = new mosCatgs($database); $row_parent->load($row->parent); $catpathnew = $row_parent->catpath . '/' . $catname . '_' . $row->cid; } else { $catpathnew = $catname . '_' . $row->cid; } //Kategoriepfad in DB aktualisieren $row->catpath = $catpathnew; $cat_originalpathold = JPath::clean(JPATH_ROOT . DS . $config->jg_pathoriginalimages . $catpathold); $cat_picturepathold = JPath::clean(JPATH_ROOT . DS . $config->jg_pathimages . $catpathold); $cat_thumbnailpathold = JPath::clean(JPATH_ROOT . DS . $config->jg_paththumbs . $catpathold); $cat_originalpathnew = JPath::clean(JPATH_ROOT . DS . $config->jg_pathoriginalimages . $catpathnew); $cat_picturepathnew = JPath::clean(JPATH_ROOT . DS . $config->jg_pathimages . $catpathnew); $cat_thumbnailpathnew = JPath::clean(JPATH_ROOT . DS . $config->jg_paththumbs . $catpathnew); //Ordner verschieben //TODO Fehlermeldungen JFolder::move($cat_originalpathold, $cat_originalpathnew); JFolder::move($cat_picturepathold, $cat_picturepathnew); JFolder::move($cat_thumbnailpathold, $cat_thumbnailpathnew); //wenn Parentkategorie geaendert wurde, den Catpath aller Unterkategorien //in DB anpassen $rowid = $row->cid; Joom_UpdateNewCatpath($rowid, $catpathold, $catpathnew); } if (!$row->store()) { echo "<script> alert('" . $row->getError() . "'); window.history.go(-1); </script>\n"; exit; } } else { //Neue Kategorie //Kategorienamen absichern JFilterOutput::objectHTMLSafe($row->name); // Joom_FixCatname; Umlaute werden umgewandelt und alle Sonderzeichen bis auf // den Unterstrich entfernt, gilt nur fuer den catpath $catname = Joom_FixCatname($row->name); $row->img_position = 0; $row->catimage = null; //access von der Elternkategorie erben, wenn nicht Admin/SuperAdmin if (!$this->adminlogged) { $row->owner = $user->get('id'); $rowparent = new mosCatgs($database); $rowparent->load($row->parent); $row->access = $rowparent->access; } else { $row->owner = null; } //Anlegen des DB Eintrages if (!$row->store()) { echo "<script> alert('" . $row->getError() . "'); window.history.go(-1); </script>\n"; exit; } //catpath mit vergebener cid aufbauen $parentpathnew = Joom_GetCatPath($row->parent); $catpathnew = $parentpathnew . $catname . '_' . $row->cid; $row->catpath = $catpathnew; $row->store(); //Kategorieverzeichnisse anlegen Joom_MakeDirectory(JPATH_ROOT . DS . $config->jg_pathoriginalimages . $catpathnew); Joom_MakeDirectory(JPATH_ROOT . DS . $config->jg_pathimages . $catpathnew); Joom_MakeDirectory(JPATH_ROOT . DS . $config->jg_paththumbs . $catpathnew); } // Redirect zur Kategorieuebersicht $mainframe->redirect(JRoute::_('index.php?option=com_joomgallery&func=showusercats&uid=' . $user->get('id') . _JOOM_ITEMID, false)); }
/** * save a edited category * * @param int $cid id of category */ function Joom_SaveEditCategory(&$cid) { $config = Joom_getConfig(); $mainframe =& JFactory::getApplication('administrator'); $database =& JFactory::getDBO(); jimport('joomla.filesystem.folder'); $row = new mosCatgs($database); //read category from DB $row->load($cid); //read old parent assignment $parentold = $row->parent; //read old title $catnameold = $row->name; //get new values if (!$row->bind($_POST)) { echo "<script> alert('" . $row->getError() . "'); window.history.go(-1); </script>\n"; exit; } if (get_magic_quotes_gpc()) { $row->name = stripslashes($row->name); $row->description = stripslashes($row->description); } if (intval($row->owner) == 0) { $row->owner = null; } //make the new category title safe if ($catnameold != $row->name) { JFilterOutput::objectHTMLSafe($row->name); $catname = $row->name; $catnamemodif = true; } else { $catname = $catnameold; $catnamemodif = false; } //move the category folder, if parent assignment or category name changed if ($parentold != $row->parent || $catnamemodif == true) { //save old path $catpathold = $row->catpath; $parentpathnew = Joom_GetCatPath($row->parent); //Joom_FixFilename() convert/remove special chars except the underscore //affects only catpath $catname = Joom_FixFilename($catname); $catpathnew = $parentpathnew . $catname . '_' . $row->cid; $cat_originalpathold = JPath::clean(JPATH_ROOT . DS . $config->jg_pathoriginalimages . $catpathold); $cat_picturepathold = JPath::clean(JPATH_ROOT . DS . $config->jg_pathimages . $catpathold); $cat_thumbnailpathold = JPath::clean(JPATH_ROOT . DS . $config->jg_paththumbs . $catpathold); $cat_originalpathnew = JPath::clean(JPATH_ROOT . DS . $config->jg_pathoriginalimages . $catpathnew); $cat_picturepathnew = JPath::clean(JPATH_ROOT . DS . $config->jg_pathimages . $catpathnew); $cat_thumbnailpathnew = JPath::clean(JPATH_ROOT . DS . $config->jg_paththumbs . $catpathnew); //move folders //actualize catpath in DB $row->catpath = $catpathnew; //TODO error messages JFolder::move($cat_originalpathold, $cat_originalpathnew); JFolder::move($cat_picturepathold, $cat_picturepathnew); JFolder::move($cat_thumbnailpathold, $cat_thumbnailpathnew); //if parent category changes, modify catpath of all subcategories in DB $rowid = $row->cid; Joom_UpdateNewCatpath($rowid, $catpathold, $catpathnew); } if (!$row->store(true)) { echo "<script> alert('" . $row->getError() . "'); window.history.go(-1); </script>\n"; exit; } // redirect to category manager //TODO aha: message $mainframe->redirect('index.php?option=' . _JOOM_OPTION . '&act=categories'); }
/** * Update of category path in DB for subcategories if a parent category has * been moved or the name changed * recursive call to each count of depth * * @param integer $catids_values: ID(s) of the modifie category * @param string $oldpath: former rel. category path * @param string $newpath: actual rel. category path * */ function Joom_UpdateNewCatpath($catids_values, &$oldpath, &$newpath) { $database =& JFactory::getDBO(); //query for subcategories with parent in $catids_values $database->setQuery("SELECT cid\n FROM #__joomgallery_catg\n WHERE parent in ({$catids_values}) "); $subcatids = $database->loadResultArray(); if ($database->getErrorNum()) { echo $database->stderr(true); } // nothing found, return if (count($subcatids) == 0) { return; } $row = new mosCatgs($database); foreach ($subcatids as $subcatid) { $row->load($subcatid); $catpath = $row->catpath; //replace former category path with actual one $catpath = str_replace($oldpath . '/', $newpath . '/', $catpath); //and save it $row->catpath = $catpath; if (!$row->store()) { echo "<script> alert('" . $row->getError() . "'); window.history.go(-1); </script>\n"; exit; } } //split the array in comme seperated string $catids_values = implode(",", $subcatids); //call again with subcategories as parent Joom_UpdateNewCatpath($catids_values, $oldpath, $newpath); }