X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_cats.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=4f7df133f736da124e6f7bd02008b9093f736451;hp=fbede77ba6634ef80c967d32a478cf747b2c9772;hpb=6bcc8f1ebbd646d15c5905a5cec47d1c1e446238;p=mailer.git diff --git a/inc/modules/admin/what-config_cats.php b/inc/modules/admin/what-config_cats.php index fbede77ba6..f551ef47b7 100644 --- a/inc/modules/admin/what-config_cats.php +++ b/inc/modules/admin/what-config_cats.php @@ -1,207 +1,3 @@ ".CATEGORY_ALREADY_EXISTS.""; - } - - // Free memory - SQL_FREERESULT($result); - - // Display message - LOAD_TEMPLATE('admin_settings_saved', false, $content); -} elseif ((isFormSent()) && (REQUEST_ISSET_POST('id')) && (is_array(REQUEST_POST('id')))) { - // Change or delete categories... - $TEXT = ''; - foreach (REQUEST_POST('id') as $id => $cat) { - // Secure ID - $id = bigintval($id); - - // Is the entry set? - if (!empty($cat)) { - switch (REQUEST_GET('do')) - { - case 'edit': // Change categories - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_cats` SET cat='%s', `visible`='%s', sort=%s WHERE `id`=%s LIMIT 1", - array( - $cat, - REQUEST_POST('vis', $id), - REQUEST_POST('sort', $id), - $id - ), __FILE__, __LINE__); - $TEXT = CATEGORIES_SAVED; - break; - - case 'del': // Delete categories - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_cats` WHERE `id`=%s LIMIT 1", - array($id), __FILE__, __LINE__); - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_cats` WHERE cat_id=%s", - array($id), __FILE__, __LINE__); - $TEXT = CATEGORIES_DELETED; - break; - } - } else { - // Entry not saved - $TEXT .= sprintf(CATEGORY_NOT_SAVED, $id); - } - } - - if (isset($TEXT)) { - // Display message - LOAD_TEMPLATE('admin_settings_saved', false, $TEXT); - } -} elseif ((REQUEST_ISSET_POST('del')) && (countPostSelection() > 0)) { - // Delete categories - $OUT = ''; $SW = 2; - foreach (REQUEST_POST('sel') as $id => $value) { - // Load data of category - $result = SQL_QUERY_ESC("SELECT cat FROM `{!_MYSQL_PREFIX!}_cats` WHERE `id`=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($cat) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'cat' => $cat, - ); - - // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_del_cats_row", true, $content); - $SW = 3 - $SW; - } - define('__CAT_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_del_cats"); -} elseif ((REQUEST_ISSET_POST('edit')) && (countPostSelection() > 0)) { - // Edit categories - $OUT = ''; $SW = 2; - foreach (REQUEST_POST('sel') as $id => $value) - { - // Load data from the category - $result = SQL_QUERY_ESC("SELECT cat, visible, sort FROM `{!_MYSQL_PREFIX!}_cats` WHERE `id`=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - list($cat, $vis, $sort) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'cat' => $cat, - 'vis' => ADD_SELECTION('yn', $vis, "vis", $id), - 'sort' => $sort, - ); - - // Load row template and switch colors - $OUT .= LOAD_TEMPLATE("admin_edit_cats_row", true, $content); - $SW = 3 - $SW; - } - define('__CAT_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_edit_cats"); -} else { - // Init variable here - $CATS = ''; - - // Load all categories - $result = SQL_QUERY("SELECT id, cat, visible, sort FROM `{!_MYSQL_PREFIX!}_cats` ORDER BY `sort`", __FILE__, __LINE__); - if (SQL_NUMROWS($result) > 0) { - // Init variables - $OUT = ''; $SW = 2; - - // List already existing categories for editing - while ($content = SQL_FETCHARRAY($result)) { - // Prepare data for the row template - $content['sw'] = $SW; - $content['vis'] = translateYesNo($content['visible']); - - // Put cat descriptions into variable for the selection box - if (strlen($content['cat']) > 20) $content['cat'] = substr($content['cat'], 0, 17)."..."; - $CATS .= " \n"; - - // Load row template and switch color - $OUT .= LOAD_TEMPLATE("admin_config_cats_row", true, $content); - $SW = 3 - $SW; - } - - // Free memory - SQL_FREERESULT($result); - - // @TODO Rewrite this constant - define('__CAT_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_config_cats"); - } - - // @TODO Rewrite this constant - define('CATS', $CATS); - - // Form to add a new category - LOAD_TEMPLATE("admin_add_cat"); -} - -// +// @DEPRECATED ?>