X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-categories.php;h=d1ddf06e1feeea0cb8cfed22275d33a37f0765c7;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hp=93da79f9ab9e70e162492ae3eff8148b0d96ed87;hpb=7b0f17cd637e388049d2167811e4332cec1e979b;p=mailer.git diff --git a/inc/modules/member/what-categories.php b/inc/modules/member/what-categories.php index 93da79f9ab..d1ddf06e1f 100644 --- a/inc/modules/member/what-categories.php +++ b/inc/modules/member/what-categories.php @@ -1,7 +1,7 @@ 0) { - $LEAST = false; - if (IS_FORM_SENT()) { - $cnt = 0; - foreach (REQUEST_POST('cat') as $cat => $joined) { - if ($joined == 'N') $cnt++; - } - - if (($cats - $cnt) < getConfig('least_cats')) { - REQUEST_UNSET_POST('ok'); - $LEAST = true; - } - } - - if (IS_FORM_SENT()) { - foreach (REQUEST_POST('cat') as $cat => $joined) { +if (isAdmin()) $whereStatement = ''; + +// Get all categories +$result = sqlQuery('SELECT + `id`, + `cat` +FROM + `{?_MYSQL_PREFIX?}_cats` +' . $whereStatement . ' +ORDER BY + `sort` ASC', __FILE__, __LINE__); + +// Are there entries? +if (!ifSqlHasZeroNumRows($result)) { + $LEAST = FALSE; + if (isFormSent()) { + $count = '0'; + foreach (postRequestElement('cat') as $categoryId => $joined) { + if ($joined != 'Y') $count++; + } // END - foreach + + if ((sqlNumRows($result) - $count) < getLeastCats()) { + unsetPostRequestElement('ok'); + $LEAST = TRUE; + } // END - if + } // END - if + + // Is the form sent? + if (isFormSent()) { + // Start counting all + $count = '0'; + + // Ini SQLs here + initSqls(); + + // Go through all entries + foreach (postRequestElement('cat') as $categoryId => $joined) { + // Has the user joined on this category? switch ($joined) { case 'Y': - $sql = ''; - $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__); - - if (SQL_NUMROWS($result_user) == 0) { - $sql = "INSERT INTO `{!_MYSQL_PREFIX!}_user_cats` (userid, cat_id) VALUES ('%s','%s')"; - } else { - // Free memory - SQL_FREERESULT($result_user); - } + // Check if this category has an entry + if (countSumTotalData(getMemberId(), 'user_cats', 'id', 'userid', TRUE, sprintf(' AND `cat_id`=%s', bigintval($categoryId))) == 0) { + // No, so add it + addSql(sprintf('INSERT INTO `{?_MYSQL_PREFIX?}_user_cats` (`userid`, `cat_id`) VALUES (%s,%s)', getMemberId(), bigintval($categoryId))); + } // END - if break; case 'N': - $sql = "DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_cats` WHERE userid=%s AND cat_id=%s LIMIT 1"; + addSql(sprintf('DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE `userid`=%s AND `cat_id`=%s LIMIT 1', getMemberId(), bigintval($categoryId))); break; - } - - if (!empty($sql)) { - // Run SQL command - $result = SQL_QUERY_ESC(trim($sql), array($UID, bigintval($cat)), __FILE__, __LINE__); - } + } // END - switch + } // END - foreach + + // Are there entries? + if (countSqls() > 0) { + // Run SQL commands + $count = runFilterChain('run_sqls'); + } // END - if + + // Categories saved? + if ($count > 0) { + // Output message + displayMessage('{--MEMBER_CATEGORIES_SAVED--}'); + } else { + // None save + displayMessage('{--MEMBER_CATEGORIES_NOT_SAVED--}'); } - - // Categories saved... - LOAD_TEMPLATE('admin_settings_saved', true, getMessage('MEMBER_CATS_SAVED')); } else { - if ($LEAST) { + if ($LEAST === TRUE) { // Also here we have to secure it... :( - LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('CATS_LEAST'), getConfig('least_cats'))); - } - // Put some data into constants for the template - define('__ROWS', ($cats*2+4)); - - // Load header template - LOAD_TEMPLATE("member_cats_header"); - - // Start switching colors and load all visible categories - // @TODO Rewrite this to use $OUT .= ... - $OUT = ''; $SW = 2; - while ($content = SQL_FETCHARRAY($result)) { - // Default he has not joined - $content['jn'] = ' chkecked="checked"'; + displayMessage('{--CHOOSE_MORE_CATEGORIES--}'); + } // END - if + + // Load all categories of this member + $OUT = ''; + while ($content = sqlFetchArray($result)) { + // Default he has not joined, add color switch + $content['jn'] = ' checked="checked"'; $content['jy'] = ''; // When we found an entry don't read it, just change the jx elements - if (REQUEST_ISSET_POST(('cat'))) { + if ((isFormSent()) && (isPostRequestElementSet('cat'))) { // Form sent? - if (REQUEST_POST('cat', $content['id']) =='Y') { - $content['jy'] = ' chkecked="checked"'; + if (postRequestElement('cat', $content['id']) =='Y') { + $content['jy'] = ' checked="checked"'; $content['jn'] = ''; - } + } // END - if } else { // Check if he has an entry - if (GET_TOTAL_DATA($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'] = ' chkecked="checked"'; - } + $content['jy'] = ' checked="checked"'; + } // END - if } - // Add some more - $content['sw'] = $SW; + // Load row template + $OUT .= loadTemplate('member_cats_row', TRUE, $content); + } // END - while - // Load row template and switch colors - LOAD_TEMPLATE("member_cat_row", false, $content); - $SW = 3 - $SW; - } + // Free result + sqlFreeResult($result); // Load footer template - LOAD_TEMPLATE("member_cats_footer"); + loadTemplate('member_cats', FALSE, $OUT); } } else { // No cateogries are defined yet - LOAD_TEMPLATE('admin_settings_saved', true, getMessage('MEMBER_NO_CATS')); + displayMessage('{--MEMBER_NO_CATEGORIES--}'); } // Free result -SQL_FREERESULT($result); +sqlFreeResult($result); -// +// [EOF] ?>