$query = 'UPDATE ' . cms_db_prefix() . 'module_news_categories SET news_category_name = ?, parent_id = ?, modified_date = ' . $db->DBTimeStamp(time()) . ' WHERE news_category_id = ?'; $parms = array($name, $parentid); $parms[] = $catid; $db->Execute($query, $parms); news_admin_ops::UpdateHierarchyPositions(); @$this->SendEvent('NewsCategoryEdited', array('category_id' => $catid, 'name' => $name, 'origname' => $origname)); $params = array('tab_message' => 'categoryupdated', 'active_tab' => 'categories'); $this->Redirect($id, 'defaultadmin', $returnid, $params); } } else { echo $this->ShowErrors($this->Lang('nonamegiven')); } } else { $query = 'SELECT * FROM ' . cms_db_prefix() . 'module_news_categories WHERE news_category_id = ?'; $row = $db->GetRow($query, array($catid)); if ($row) { $name = $row['news_category_name']; $parentid = (int) $row['parent_id']; } } #Display template $smarty->assign('startform', $this->CreateFormStart($id, 'editcategory', $returnid)); $smarty->assign('endform', $this->CreateFormEnd()); $smarty->assign('nametext', $this->Lang('name')); $smarty->assign('inputname', $this->CreateInputText($id, 'name', $name, 20, 255)); $smarty->assign('parentdropdown', news_admin_ops::CreateParentDropdown($id, $catid, $parentid)); $smarty->assign('hidden', $this->CreateInputHidden($id, 'catid', $catid) . $this->CreateInputHidden($id, 'origname', $name)); $smarty->assign('submit', $this->CreateInputSubmit($id, 'submit', lang('submit'))); $smarty->assign('cancel', $this->CreateInputSubmit($id, 'cancel', lang('cancel'))); $smarty->assign('parenttext', lang('parent')); echo $this->ProcessTemplate('editcategory.tpl');
if ($name != '') { $query = 'SELECT news_category_id FROM ' . cms_db_prefix() . 'module_news_categories WHERE parent_id = ? AND news_category_name = ?'; $tmp = $db->GetOne($query, array($parent, $name)); if ($tmp) { echo $this->ShowErrors($this->Lang('error_duplicatename')); } else { $catid = $db->GenID(cms_db_prefix() . "module_news_categories_seq"); $time = $db->DBTimeStamp(time()); $query = 'INSERT INTO ' . cms_db_prefix() . 'module_news_categories (news_category_id, news_category_name, parent_id, create_date, modified_date) VALUES (?,?,?,' . $time . ',' . $time . ')'; $parms = array($catid, $name, $parent); $db->Execute($query, $parms); news_admin_ops::UpdateHierarchyPositions(); @$this->SendEvent('NewsCategoryAdded', array('category_id' => $catid, 'name' => $name)); $params = array('tab_message' => 'categoryadded', 'active_tab' => 'categories'); $this->Redirect($id, 'defaultadmin', $returnid, $params); } } else { echo $this->ShowErrors($this->Lang('nonamegiven')); } } #Display template $smarty->assign('startform', $this->CreateFormStart($id, 'addcategory', $returnid)); $smarty->assign('endform', $this->CreateFormEnd()); $smarty->assign('nametext', $this->Lang('name')); $smarty->assign('inputname', $this->CreateInputText($id, 'name', $name, 20, 255)); $smarty->assign('parentdropdown', news_admin_ops::CreateParentDropdown($id, -1, -1)); $smarty->assign('hidden', ''); $smarty->assign('submit', $this->CreateInputSubmit($id, 'submit', lang('submit'))); $smarty->assign('cancel', $this->CreateInputSubmit($id, 'cancel', lang('cancel'))); $smarty->assign('parenttext', lang('parent')); echo $this->ProcessTemplate('editcategory.tpl');