X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fmember%2Fwhat-categories.php;h=c6674511b9ebb259c71f5de9deac71333594a4ef;hp=032400dab4e8d9f508baa8cec11b9a41754938da;hb=4a0707e942a96b80ecea6bb83d0bf1acf4fe1e59;hpb=414570c5081d337bb6c28dcf521bd8bca02f69e7 diff --git a/inc/modules/member/what-categories.php b/inc/modules/member/what-categories.php index 032400dab4..c6674511b9 100644 --- a/inc/modules/member/what-categories.php +++ b/inc/modules/member/what-categories.php @@ -10,14 +10,14 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Kategorien ab- bzw. anwaehlen * * -------------------------------------------------------------------- * - * $Revision:: 856 $ * - * $Date:: 2009-03-06 20:24:32 +0100 (Fr, 06. Mär 2009) $ * + * $Revision:: $ * + * $Date:: $ * * $Tag:: 0.2.1-FINAL $ * - * $Author:: stelzi $ * + * $Author:: $ * * 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 * + * Copyright (c) 2003 - 2009 by Roland Haeder * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -38,96 +38,113 @@ // Some security stuff... if (!defined('__SECURITY')) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; - require($INC); -} elseif (!IS_MEMBER()) { - LOAD_URL("modules.php[13~?module=index"); + die(); +} elseif (!isMember()) { + redirectToIndexMemberOnlyModule(); } // Add description as navigation point -ADD_DESCR("member", __FILE__); +addMenuDescription('member', __FILE__); -$UID = $GLOBALS['userid']; +$UID = getUserId(); $whereStatement = " WHERE `visible`='Y'"; -if (IS_ADMIN()) $whereStatement = ""; +if (isAdmin()) $whereStatement = ''; -$result = SQL_QUERY("SELECT id, cat FROM `{!_MYSQL_PREFIX!}_cats`".$whereStatement." 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) { $LEAST = false; - if (IS_FORM_SENT()) { + if (isFormSent()) { $cnt = 0; - foreach (REQUEST_POST('cat') as $cat => $joined) { - if ($joined == "N") $cnt++; - } + foreach (postRequestElement('cat') as $cat => $joined) { + if ($joined != 'Y') $cnt++; + } // END - foreach if (($cats - $cnt) < getConfig('least_cats')) { - REQUEST_UNSET_POST('ok'); + unsetPostRequestElement('ok'); $LEAST = true; - } - } + } // END - if + } // END - if + + // Is the form sent? + if (isFormSent()) { + // Start counting all + $cnt = 0; + + // Go through all entries + foreach (postRequestElement('cat') as $cat => $joined) { + // Ini sql here + $sql = ''; - if (IS_FORM_SENT()) { - foreach (REQUEST_POST('cat') as $cat => $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__); + 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__); 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); - } + $sql = "INSERT INTO `{?_MYSQL_PREFIX?}_user_cats` (userid, cat_id) VALUES ('%s','%s')"; + } // END - if + + // Free memory + SQL_FREERESULT($result_user); break; - case "N": - $sql = "DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_user_cats` WHERE userid=%s AND cat_id=%s LIMIT 1"; + case 'N': + $sql = "DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_cats` WHERE `userid`=%s AND `cat_id`=%s LIMIT 1"; break; - } + } // END - switch if (!empty($sql)) { // Run SQL command - $result = SQL_QUERY_ESC(trim($sql), array($UID, bigintval($cat)), __FILE__, __LINE__); - } + SQL_QUERY_ESC(trim($sql), array($UID, bigintval($cat)), __FILE__, __LINE__); + + // Count this row + $cnt += SQL_AFFECTEDROWS(); + } // END - if + } // END - foreach + + // Categories saved? + if ($cnt > 0) { + // Output message + loadTemplate('admin_settings_saved', false, getMessage('MEMBER_CATS_SAVED')); + } else { + // None save + loadTemplate('admin_settings_saved', false, getMessage('MEMBER_CATS_NOT_SAVED')); } - - // Categories saved... - 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", false, sprintf(getMessage('CATS_LEAST'), getConfig('least_cats'))); - } + loadTemplate('admin_settings_saved', false, sprintf(getMessage('CATS_LEAST'), getConfig('least_cats'))); + } // END - if + // Put some data into constants for the template - define('__ROWS', ($cats*2+4)); + $content['rows'] = ($cats*2+4); // Load header template - LOAD_TEMPLATE("member_cats_header"); + loadTemplate('member_cats_header', false, $content); // Start switching colors and load all visible categories // @TODO Rewrite this to use $OUT .= ... - $OUT = ""; $SW = 2; + $OUT = ''; $SW = 2; while ($content = SQL_FETCHARRAY($result)) { // Default he has not joined - $content['jn'] = " checked=\"checked\""; - $content['jy'] = ""; + $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 (isPostRequestElementSet(('cat'))) { // Form sent? - if (REQUEST_POST('cat', $content['id']) =='Y') { - $content['jy'] = " checked=\"checked\""; - $content['jn'] = ""; + if (postRequestElement('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\""; + if (countSumTotalData($UID, 'user_cats', 'id', 'userid', true, sprintf(" AND `cat_id`=%s", bigintval($content['id']))) == 1) { + $content['jn'] = ''; + $content['jy'] = ' checked="checked"'; } } @@ -135,16 +152,16 @@ if ($cats > 0) { $content['sw'] = $SW; // Load row template and switch colors - LOAD_TEMPLATE("member_cat_row", false, $content); + loadTemplate('member_cat_row', false, $content); $SW = 3 - $SW; } // Load footer template - LOAD_TEMPLATE("member_cats_footer"); + loadTemplate('member_cats_footer'); } } else { // No cateogries are defined yet - LOAD_TEMPLATE("admin_settings_saved", true, getMessage('MEMBER_NO_CATS')); + loadTemplate('admin_settings_saved', true, getMessage('MEMBER_NO_CATS')); } // Free result