X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-categories.php;h=d1ddf06e1feeea0cb8cfed22275d33a37f0765c7;hp=796eb90adfe55d29cadcf5fec4c087120576d203;hb=49acdb7a7adbcf25a8e8683b5581bfcec72b23bd;hpb=f9a9c09e1ae257449bfd98f8854e321efba1dc3c diff --git a/inc/modules/member/what-categories.php b/inc/modules/member/what-categories.php index 796eb90adf..d1ddf06e1f 100644 --- a/inc/modules/member/what-categories.php +++ b/inc/modules/member/what-categories.php @@ -1,7 +1,7 @@ 0) -{ - $LEAST = false; - if (isset($_POST['ok'])) - { - $cnt = 0; - foreach ($_POST['cat'] as $cat => $joined) - { - if ($joined == "N") $cnt++; - } - if (($cats - $cnt) < getConfig('least_cats')) - { - unset($_POST['ok']); - $LEAST = true; - } - } - if (isset($_POST['ok'])) - { - foreach ($_POST['cat'] as $cat => $joined) - { - 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); - } +addYouAreHereLink('member', __FILE__); + +$whereStatement = " WHERE `visible`='Y'"; +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': + // 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"; + case 'N': + 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, MEMBER_CATS_SAVED); - } - else - { - if ($LEAST) - { + } else { + if ($LEAST === TRUE) { // Also here we have to secure it... :( - LOAD_TEMPLATE("admin_settings_saved", true, 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 - $SW = 2; - while (list($id, $cat) = SQL_FETCHROW($result)) - { - // Default he has not joined - $JOINED_N = " checked=\"checked\""; $JOINED_Y = ""; - - // Check category selection - $result_user = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_cats WHERE userid=%s AND cat_id=%s LIMIT 1", - array($UID, bigintval($id)), __FILE__, __LINE__); - - // When we found an entry don't read it, just change the JOINED_x variables - if (isset($_POST['cat'])) - { - if ($_POST['cat'][$id] =='Y') { $JOINED_Y = " checked=\"checked\""; $JOINED_N = ""; } - } - else - { - if (SQL_NUMROWS($result_user) == 1) - { - $JOINED_Y = " checked=\"checked\""; $JOINED_N = ""; - } - - // Free memory - SQL_FREERESULT($result_user); + 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 ((isFormSent()) && (isPostRequestElementSet('cat'))) { + // Form sent? + if (postRequestElement('cat', $content['id']) =='Y') { + $content['jy'] = ' checked="checked"'; + $content['jn'] = ''; + } // END - if + } else { + // Check if he has an entry + if (countSumTotalData(getMemberId(), 'user_cats', 'id', 'userid', TRUE, sprintf(' AND `cat_id`=%s', bigintval($content['id']))) == 1) { + $content['jn'] = ''; + $content['jy'] = ' checked="checked"'; + } // END - if } - // Prepare data for the template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'cat' => $cat, - 'jy' => $JOINED_Y, - 'jn' => $JOINED_N, - ); - - // Load row template and switch colors - LOAD_TEMPLATE("member_cat_row", false, $content); - $SW = 3 - $SW; - } + // Load row template + $OUT .= loadTemplate('member_cats_row', TRUE, $content); + } // END - while + + // Free result + sqlFreeResult($result); // Load footer template - LOAD_TEMPLATE("member_cats_footer"); + loadTemplate('member_cats', FALSE, $OUT); } -} - else -{ +} else { // No cateogries are defined yet - LOAD_TEMPLATE("admin_settings_saved", true, MEMBER_NO_CATS); + displayMessage('{--MEMBER_NO_CATEGORIES--}'); } -SQL_FREERESULT($result); +// Free result +sqlFreeResult($result); -// +// [EOF] ?>