X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-config_cats.php;h=7132bfe2392049b2038fe82ec513d68d013a46d6;hb=5071030af40e69ca4284642f44758964e18f5be8;hp=7d8f4a3b8abf72d30a5dc5bcb5c2f355e0f604f7;hpb=7b0f17cd637e388049d2167811e4332cec1e979b;p=mailer.git diff --git a/inc/modules/admin/what-config_cats.php b/inc/modules/admin/what-config_cats.php index 7d8f4a3b8a..7132bfe239 100644 --- a/inc/modules/admin/what-config_cats.php +++ b/inc/modules/admin/what-config_cats.php @@ -52,11 +52,11 @@ $CATS = ''; if (REQUEST_ISSET_POST(('add'))) { // Add a new category $result = SQL_QUERY_ESC("SELECT `id` FROM `{!_MYSQL_PREFIX!}_cats` WHERE cat='%s' LIMIT 1", - array(REQUEST_POST('catname')), __FILE__, __LINE__); + array(REQUEST_POST('catname')), __FILE__, __LINE__); if (SQL_NUMROWS($result) == 0) { // Category does not exists, we simply add it... SQL_QUERY_ESC("INSERT INTO `{!_MYSQL_PREFIX!}_cats` (cat, visible, sort) VALUES ('%s','%s','%s')", - array(REQUEST_POST('catname'), REQUEST_POST('visible'), bigintval(REQUEST_POST('parent') + 1)), __FILE__, __LINE__); + array(REQUEST_POST('catname'), REQUEST_POST('visible'), bigintval(REQUEST_POST('parent') + 1)), __FILE__, __LINE__); $content = CATEGORY_ADDED; } else { // Category does already exists @@ -79,24 +79,24 @@ if (REQUEST_ISSET_POST(('add'))) { 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", + 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 + $cat, + REQUEST_POST('vis', $id), + REQUEST_POST('sort', $id), + $id ), __FILE__, __LINE__); - $TEXT = CATEGORIES_SAVED; - break; + $TEXT = CATEGORIES_SAVED; + break; - case 'del': // Delete categories - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_cats` WHERE `id`=%s LIMIT 1", + 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", + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_cats` WHERE cat_id=%s", array($id), __FILE__, __LINE__); - $TEXT = CATEGORIES_DELETED; - break; + $TEXT = CATEGORIES_DELETED; + break; } } else { // Entry not saved @@ -114,7 +114,7 @@ if (REQUEST_ISSET_POST(('add'))) { 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__); + array(bigintval($id)), __FILE__, __LINE__); list($cat) = SQL_FETCHROW($result); SQL_FREERESULT($result); @@ -140,7 +140,7 @@ if (REQUEST_ISSET_POST(('add'))) { { // 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__); + array(bigintval($id)), __FILE__, __LINE__); list($cat, $vis, $sort) = SQL_FETCHROW($result); SQL_FREERESULT($result);