X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-categories.php;h=032400dab4e8d9f508baa8cec11b9a41754938da;hp=659673b732168c680ff1932c6d3b784e5254372c;hb=414570c5081d337bb6c28dcf521bd8bca02f69e7;hpb=e1653405d28923c78b2e292125306ccf61138f24 diff --git a/inc/modules/member/what-categories.php b/inc/modules/member/what-categories.php index 659673b732..032400dab4 100644 --- a/inc/modules/member/what-categories.php +++ b/inc/modules/member/what-categories.php @@ -10,7 +10,12 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Kategorien ab- bzw. anwaehlen * * -------------------------------------------------------------------- * - * * + * $Revision:: 856 $ * + * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 2009) $ * + * $Tag:: 0.2.1-FINAL $ * + * $Author:: stelzi $ * + * Needs to be in all Files and every File needs "svn propset * + * svn:keywords Date Revision" (autoprobset!) at least!!!!!! * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2008 by Roland Haeder * * For more information visit: http://www.mxchange.org * @@ -32,83 +37,70 @@ ************************************************************************/ // Some security stuff... -if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) -{ +if (!defined('__SECURITY')) { $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; require($INC); -} - elseif (!IS_LOGGED_IN()) -{ - LOAD_URL(URL."/modules.php[13~?module=index"); +} elseif (!IS_MEMBER()) { + LOAD_URL("modules.php[13~?module=index"); } // Add description as navigation point -ADD_DESCR("member", basename(__FILE__)); +ADD_DESCR("member", __FILE__); $UID = $GLOBALS['userid']; -$WHERE = " WHERE visible='Y'"; -if (IS_ADMIN()) $WHERE = ""; +$whereStatement = " WHERE `visible`='Y'"; +if (IS_ADMIN()) $whereStatement = ""; -$result = SQL_QUERY("SELECT id, cat FROM "._MYSQL_PREFIX."_cats".$WHERE." ORDER BY sort", __FILE__, __LINE__); +$result = SQL_QUERY("SELECT id, cat FROM `{!_MYSQL_PREFIX!}_cats`".$whereStatement." ORDER BY `sort`", __FILE__, __LINE__); $cats = SQL_NUMROWS($result); -if ($cats > 0) -{ +if ($cats > 0) { $LEAST = false; - if (isset($_POST['ok'])) - { + if (IS_FORM_SENT()) { $cnt = 0; - foreach ($_POST['cat'] as $cat=>$joined) - { - if ($joined == 'N') $cnt++; + foreach (REQUEST_POST('cat') as $cat => $joined) { + if ($joined == "N") $cnt++; } - if (($cats - $cnt) < $CONFIG['least_cats']) - { - unset($_POST['ok']); + + if (($cats - $cnt) < getConfig('least_cats')) { + REQUEST_UNSET_POST('ok'); $LEAST = true; } } - if (isset($_POST['ok'])) - { - foreach ($_POST['cat'] as $cat=>$joined) - { - switch ($joined) - { - case 'Y': + + if (IS_FORM_SENT()) { + foreach (REQUEST_POST('cat') as $cat => $joined) { + switch ($joined) { + case "Y": $sql = ""; - $result_user = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_cats WHERE userid=%d AND cat_id=%d LIMIT 1", + $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 - { + 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); } break; - case 'N': - $sql = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_cats WHERE userid=%d AND cat_id=%d LIMIT 1"; + case "N": + $sql = "DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_cats` WHERE userid=%s AND cat_id=%s LIMIT 1"; break; } - if (!empty($sql)) - { + + if (!empty($sql)) { // Run SQL command $result = SQL_QUERY_ESC(trim($sql), array($UID, bigintval($cat)), __FILE__, __LINE__); } } + // Categories saved... - LOAD_TEMPLATE("admin_settings_saved", true, MEMBER_CATS_SAVED); - } - else - { - if ($LEAST) - { + LOAD_TEMPLATE("admin_settings_saved", true, getMessage('MEMBER_CATS_SAVED')); + } else { + if ($LEAST) { // Also here we have to secure it... :( - LOAD_TEMPLATE("admin_settings_saved", true, CATS_LEAST.": ".$CONFIG['least_cats']); + 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)); @@ -117,40 +109,30 @@ if ($cats > 0) LOAD_TEMPLATE("member_cats_header"); // Start switching colors and load all visible categories - $SW = 2; - while (list($id, $cat) = SQL_FETCHROW($result)) - { + // @TODO Rewrite this to use $OUT .= ... + $OUT = ""; $SW = 2; + while ($content = SQL_FETCHARRAY($result)) { // Default he has not joined - $JOINED_N = " checked"; $JOINED_Y = ""; - - // Check category selection - $result_user = SQL_QUERY_ESC("SELECT id FROM "._MYSQL_PREFIX."_user_cats WHERE userid=%d AND cat_id=%d 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"; $JOINED_N = ""; } - } - else - { - if (SQL_NUMROWS($result_user) == 1) - { - $JOINED_Y = " checked"; $JOINED_N = ""; + $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'))) { + // Form sent? + if (REQUEST_POST('cat', $content['id']) =='Y') { + $content['jy'] = " checked=\"checked\""; + $content['jn'] = ""; + } + } 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) { + $content['jn'] = ""; + $content['jy'] = " checked=\"checked\""; } - - // Free memory - SQL_FREERESULT($result_user); } - // Prepare data for the template - $content = array( - 'sw' => $SW, - 'id' => $id, - 'cat' => $cat, - 'jy' => $JOINED_Y, - 'jn' => $JOINED_N, - ); + // Add some more + $content['sw'] = $SW; // Load row template and switch colors LOAD_TEMPLATE("member_cat_row", false, $content); @@ -160,13 +142,12 @@ if ($cats > 0) // Load footer template LOAD_TEMPLATE("member_cats_footer"); } -} - else -{ +} else { // No cateogries are defined yet - LOAD_TEMPLATE("admin_settings_saved", true, MEMBER_NO_CATS); + LOAD_TEMPLATE("admin_settings_saved", true, getMessage('MEMBER_NO_CATS')); } +// Free result SQL_FREERESULT($result); //