X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-categories.php;h=26b06a457fda46bd9e83401ab26b845dd12cc2f1;hb=8202991f32bfb2056e94a11746c0b5308fe4a273;hp=be91ee3a2cd0366d7c476e9712816a95f549442c;hpb=db1f357f01e1ebb16a31fdcd3e432a1d19b54ae3;p=mailer.git diff --git a/inc/modules/member/what-categories.php b/inc/modules/member/what-categories.php index be91ee3a2c..26b06a457f 100644 --- a/inc/modules/member/what-categories.php +++ b/inc/modules/member/what-categories.php @@ -16,8 +16,8 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * - * For more information visit: http://www.mxchange.org * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * + * For more information visit: http://mxchange.org * * * * This program is free software; you can redistribute it and/or modify * * it under the terms of the GNU General Public License as published by * @@ -49,19 +49,19 @@ $whereStatement = " WHERE `visible`='Y'"; if (isAdmin()) $whereStatement = ''; // Get all categories -$result = SQL_QUERY("SELECT `id`, `cat` FROM `{?_MYSQL_PREFIX?}_cats`".$whereStatement." ORDER BY `sort` ASC", __FILE__, __LINE__); +$result = SQL_QUERY("SELECT `id`,`cat` FROM `{?_MYSQL_PREFIX?}_cats`".$whereStatement." ORDER BY `sort` ASC", __FILE__, __LINE__); // Do we have entries? if (!SQL_HASZERONUMS($result)) { $LEAST = false; if (isFormSent()) { $count = '0'; - foreach (postRequestParameter('cat') as $cat => $joined) { + foreach (postRequestElement('cat') as $categoryId => $joined) { if ($joined != 'Y') $count++; } // END - foreach if ((SQL_NUMROWS($result) - $count) < getLeastCats()) { - unsetPostRequestParameter('ok'); + unsetPostRequestElement('ok'); $LEAST = true; } // END - if } // END - if @@ -72,7 +72,7 @@ if (!SQL_HASZERONUMS($result)) { $count = '0'; // Go through all entries - foreach (postRequestParameter('cat') as $cat => $joined) { + foreach (postRequestElement('cat') as $categoryId => $joined) { // Ini sql here $sql = ''; @@ -80,13 +80,13 @@ if (!SQL_HASZERONUMS($result)) { switch ($joined) { case 'Y': $result_user = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE `userid`=%s AND `cat_id`=%s LIMIT 1", - array(getMemberId(), bigintval($cat)), __FILE__, __LINE__); + array(getMemberId(), bigintval($categoryId)), __FILE__, __LINE__); // Debug message - //* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'cat='.$cat.',joined='.$joined.',getMemberId()='.getMemberId().',SQL_HASZERONUMS()='.intval(SQL_HASZERONUMS($result_user))); + //* DEBUG: */ logDebugMessage(__FILE__, __LINE__, 'categoryId='.$categoryId.',joined='.$joined.',getMemberId()='.getMemberId().',SQL_HASZERONUMS()='.intval(SQL_HASZERONUMS($result_user))); if (SQL_HASZERONUMS($result_user)) { - $sql = "INSERT INTO `{?_MYSQL_PREFIX?}_user_cats` (`userid`, `cat_id`) VALUES (%s,%s)"; + $sql = "INSERT INTO `{?_MYSQL_PREFIX?}_user_cats` (`userid`,`cat_id`) VALUES (%s,%s)"; } // END - if // Free memory @@ -100,7 +100,7 @@ if (!SQL_HASZERONUMS($result)) { if (!empty($sql)) { // Run SQL command - SQL_QUERY_ESC(trim($sql), array(getMemberId(), bigintval($cat)), __FILE__, __LINE__); + SQL_QUERY_ESC(trim($sql), array(getMemberId(), bigintval($categoryId)), __FILE__, __LINE__); // Count this row $count += SQL_AFFECTEDROWS(); @@ -110,15 +110,15 @@ if (!SQL_HASZERONUMS($result)) { // Categories saved? if ($count > 0) { // Output message - loadTemplate('admin_settings_saved', false, '{--MEMBER_CATEGORIES_SAVED--}'); + displayMessage('{--MEMBER_CATEGORIES_SAVED--}'); } else { // None save - loadTemplate('admin_settings_saved', false, '{--MEMBER_CATEGORIES_NOT_SAVED--}'); + displayMessage('{--MEMBER_CATEGORIES_NOT_SAVED--}'); } } else { if ($LEAST === true) { // Also here we have to secure it... :( - loadTemplate('admin_settings_saved', false, '{--CHOOSE_MORE_CATEGORIES--}'); + displayMessage('{--CHOOSE_MORE_CATEGORIES--}'); } // END - if // Put some data into constants for the template @@ -136,9 +136,9 @@ if (!SQL_HASZERONUMS($result)) { $content['jy'] = ''; // When we found an entry don't read it, just change the jx elements - if ((isFormSent()) && (isPostRequestParameterSet('cat'))) { + if ((isFormSent()) && (isPostRequestElementSet('cat'))) { // Form sent? - if (postRequestParameter('cat', $content['id']) =='Y') { + if (postRequestElement('cat', $content['id']) =='Y') { $content['jy'] = ' checked="checked"'; $content['jn'] = ''; } // END - if @@ -159,7 +159,7 @@ if (!SQL_HASZERONUMS($result)) { } } else { // No cateogries are defined yet - loadTemplate('admin_settings_saved', false, '{--MEMBER_NO_CATEGORIES--}'); + displayMessage('{--MEMBER_NO_CATEGORIES--}'); } // Free result