X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-categories.php;h=32859bbd3fdf1eb22cb8357c8691a7d012ed388a;hp=df72cb5d3ddbb9a8ec5d902eebd8984353547311;hb=cf3765c38cf0a76f396aca291f71858936e92956;hpb=9afd6ec5878544a7982c50ed9c0dd7de37606d5b diff --git a/inc/modules/member/what-categories.php b/inc/modules/member/what-categories.php index df72cb5d3d..32859bbd3f 100644 --- a/inc/modules/member/what-categories.php +++ b/inc/modules/member/what-categories.php @@ -1,7 +1,7 @@ 0) { $LEAST = false; if (isFormSent()) { $cnt = '0'; - foreach (postRequestElement('cat') as $cat => $joined) { + foreach (postRequestParameter('cat') as $cat => $joined) { if ($joined != 'Y') $cnt++; } // END - foreach if (($cats - $cnt) < getConfig('least_cats')) { - unsetPostRequestElement('ok'); + unsetPostRequestParameter('ok'); $LEAST = true; } // END - if } // END - if @@ -73,7 +73,7 @@ if ($cats > 0) { $cnt = '0'; // Go through all entries - foreach (postRequestElement('cat') as $cat => $joined) { + foreach (postRequestParameter('cat') as $cat => $joined) { // Ini sql here $sql = ''; @@ -81,9 +81,9 @@ if ($cats > 0) { 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($UID, bigintval($cat)), __FILE__, __LINE__); + array(getMemberId(), bigintval($cat)), __FILE__, __LINE__); - if (SQL_NUMROWS($result_user) == '0') { + if (!SQL_HASZERONUMS($result_user)) { $sql = "INSERT INTO `{?_MYSQL_PREFIX?}_user_cats` (userid, cat_id) VALUES ('%s','%s')"; } // END - if @@ -98,7 +98,7 @@ if ($cats > 0) { if (!empty($sql)) { // Run SQL command - SQL_QUERY_ESC(trim($sql), array($UID, bigintval($cat)), __FILE__, __LINE__); + SQL_QUERY_ESC(trim($sql), array(getMemberId(), bigintval($cat)), __FILE__, __LINE__); // Count this row $cnt += SQL_AFFECTEDROWS(); @@ -108,15 +108,15 @@ if ($cats > 0) { // Categories saved? if ($cnt > 0) { // Output message - loadTemplate('admin_settings_saved', false, getMessage('MEMBER_CATS_SAVED')); + loadTemplate('admin_settings_saved', false, '{--MEMBER_CATEGORIES_SAVED--}'); } else { // None save - loadTemplate('admin_settings_saved', false, getMessage('MEMBER_CATS_NOT_SAVED')); + loadTemplate('admin_settings_saved', false, '{--MEMBER_CATEGORIES_NOT_SAVED--}'); } } else { - if ($LEAST) { + if ($LEAST === true) { // Also here we have to secure it... :( - loadTemplate('admin_settings_saved', false, sprintf(getMessage('CATS_LEAST'), getConfig('least_cats'))); + loadTemplate('admin_settings_saved', false, '{--CATS_LEAST--}'); } // END - if // Put some data into constants for the template @@ -127,45 +127,41 @@ if ($cats > 0) { // Start switching colors and load all visible categories // @TODO Rewrite this to use $OUT .= ... - $OUT = ''; $SW = 2; + $OUT = ''; while ($content = SQL_FETCHARRAY($result)) { // Default he has not joined $content['jn'] = ' checked="checked"'; $content['jy'] = ''; // When we found an entry don't read it, just change the jx elements - if (isPostRequestElementSet(('cat'))) { + if (isPostRequestParameterSet(('cat'))) { // Form sent? - if (postRequestElement('cat', $content['id']) =='Y') { + if (postRequestParameter('cat', $content['id']) =='Y') { $content['jy'] = ' checked="checked"'; $content['jn'] = ''; } } else { // Check if he has an entry - if (countSumTotalData($UID, 'user_cats', 'id', 'userid', true, sprintf(" AND `cat_id`=%s", bigintval($content['id']))) == 1) { + if (countSumTotalData(getMemberId(), 'user_cats', 'id', 'userid', true, sprintf(" AND `cat_id`=%s", bigintval($content['id']))) == 1) { $content['jn'] = ''; $content['jy'] = ' checked="checked"'; } } - // Add some more - $content['sw'] = $SW; - // Load row template and switch colors loadTemplate('member_cat_row', false, $content); - $SW = 3 - $SW; - } + } // END - while // Load footer template loadTemplate('member_cats_footer'); } } else { // No cateogries are defined yet - loadTemplate('admin_settings_saved', true, getMessage('MEMBER_NO_CATS')); + loadTemplate('admin_settings_saved', false, '{--MEMBER_NO_CATEGORIES--}'); } // Free result SQL_FREERESULT($result); -// +// [EOF] ?>