X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_cats.php;h=f551ef47b7591c74e7b59193e56a1fa6505a87ab;hb=4f7df133f736da124e6f7bd02008b9093f736451;hp=301fc13c5afd912919532370d0639f317359151c;hpb=89c00e43d2ce1dd1afe11c2c8485307342805f97;p=mailer.git diff --git a/inc/modules/admin/what-config_cats.php b/inc/modules/admin/what-config_cats.php index 301fc13c5a..f551ef47b7 100644 --- a/inc/modules/admin/what-config_cats.php +++ b/inc/modules/admin/what-config_cats.php @@ -1,198 +1,3 @@ ".CATEGORY_ADDED.""; - } else { - // Category does already exists - $content = "".CATEGORY_ALREADY_EXISTS.""; - } - - // Free memory - SQL_FREERESULT($result); - - // Display message - LOAD_TEMPLATE("admin_settings_saved", false, $content); -} elseif ((isset($_POST['ok'])) && (isset($_POST['id'])) && (is_array($_POST['id']))) { - // Change or delete categories... - $TEXT = ""; - foreach ($_POST['id'] as $id => $cat) { - // Secure ID - $id = bigintval($id); - - // Is the entry set? - if (!empty($cat)) { - switch ($_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, $_POST['vis'][$id], $_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 ((isset($_POST['del'])) && ((SELECTION_COUNT($_POST['sel']) > 0) || (isset($_POST['sel'][0])))) { - // Delete categories - $SW = 2; $OUT = ""; - foreach ($_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 ((isset($_POST['edit'])) && ((SELECTION_COUNT($_POST['sel']) > 0) || (isset($_POST['sel'][0])))) { - // Edit categories - $SW = 2; $OUT = ""; - foreach ($_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 -{ - // 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) - { - // List already existing categories for editing - $SW = 2; $OUT = ""; $CATS = ""; - while (list($id, $cat, $visible, $sort) = SQL_FETCHROW($result)) - { - // Prepare data for the row template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'cat' => $cat, - 'vis' => TRANSLATE_YESNO($visible), - 'sort' => $sort, - ); - - // Put cat descriptions into variable for the selection box - if (strlen($cat) > 20) $cat = substr($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); - define('__CAT_ROWS', $OUT); - - // Load main template - LOAD_TEMPLATE("admin_config_cats"); - } - - define('CATS', $CATS); - - // Form to add a new category - LOAD_TEMPLATE("admin_add_cat"); -} - -// +// @DEPRECATED ?>