CheckPermission('Modify Site Preferences')) return; $order = 1; $fdid = $params['fdid']; #Grab necessary info for fixing the item_order $order = $db->GetOne("SELECT item_order FROM ".cms_db_prefix()."module_news_fielddefs WHERE id = ?", array($fdid)); $time = $db->DBTimeStamp(time()); if ($params['dir'] == "down") { $query = 'UPDATE '.cms_db_prefix().'module_news_fielddefs SET item_order = (item_order - 1), modified_date = '.$time.' WHERE item_order = ?'; $db->Execute($query, array($order + 1)); $query = 'UPDATE '.cms_db_prefix().'module_news_fielddefs SET item_order = (item_order + 1), modified_date = '.$time.' WHERE id = ?'; $db->Execute($query, array($fdid)); } else if ($params['dir'] == "up") { $query = 'UPDATE '.cms_db_prefix().'module_news_fielddefs SET item_order = (item_order + 1), modified_date = '.$time.' WHERE item_order = ?'; $db->Execute($query, array($order - 1)); $query = 'UPDATE '.cms_db_prefix().'module_news_fielddefs SET item_order = (item_order - 1), modified_date = '.$time.' WHERE id = ?'; $db->Execute($query, array($fdid)); } $params = array('active_tab' => 'customfields'); $this->Redirect($id, 'defaultadmin', '', $params); ?>