X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_links.php;h=731b4edc61f6fc60b5d75859b4f7a24d7399adab;hp=18848922d90c9bc32a64f4bc639ae786b32ca2a9;hb=9f6c30cc0e06098171d773d671292081ecee3d29;hpb=27f65d023a3388a8bd85be8ee5991f776f541847 diff --git a/inc/modules/admin/what-list_links.php b/inc/modules/admin/what-list_links.php index 18848922d9..731b4edc61 100644 --- a/inc/modules/admin/what-list_links.php +++ b/inc/modules/admin/what-list_links.php @@ -8,11 +8,16 @@ * -------------------------------------------------------------------- * * Short description : List unconfirmed mails of a member * * -------------------------------------------------------------------- * - * Kurzbeschreibung : Unbestaetigte Mails eines Mitgliedes auflisten * + * Kurzbeschreibung : Unbestätigte Mails eines Mitgliedes auflisten * * -------------------------------------------------------------------- * - * * + * $Revision:: $ * + * $Date:: $ * + * $Tag:: 0.2.1-FINAL $ * + * $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 * @@ -32,39 +37,31 @@ ************************************************************************/ // Some security stuff... -if ((!defined('__SECURITY')) || (!IS_ADMIN())) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; - require($INC); -} elseif (!EXT_IS_ACTIVE("mailid")) { - ADD_FATAL(sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "mailid")); - return; -} +if ((!defined('__SECURITY')) || (!isAdmin())) { + die(); +} // END - if // Add description as navigation point -ADD_DESCR("admin", __FILE__); +addMenuDescription('admin', __FILE__); -if (empty($_GET['del'])) $_GET['del'] = ""; +if (!isExtensionActive('mailid')) { + loadTemplate('admin_settings_saved', false, generateExtensionInactiveNotInstalledMessage('mailid')); + return; +} // END - if -if (!empty($_GET['u_id'])) { +if (isGetRequestElementSet('userid')) { // Check if the user already exists - $result = SQL_QUERY_ESC("SELECT surname, family, email FROM `"._MYSQL_PREFIX."_user_data` WHERE userid=%s LIMIT 1", - array(bigintval($_GET['u_id'])), __FILE__, __LINE__); - - // Is there an entry? - if (SQL_NUMROWS($result) == 1) { - // Loads surname, family's name and the email address - list($sname, $fname, $email) = SQL_FETCHROW($result); - SQL_FREERESULT($result); - + if (fetchUserData(getRequestElement('userid'))) { // Grab user's all unconfirmed mails - if (EXT_IS_ACTIVE("bonus")) { - // Load bonus ID - $result = SQL_QUERY_ESC("SELECT stats_id, bonus_id, link_type FROM "._MYSQL_PREFIX."_user_links WHERE userid=%s ORDER BY id", - array(bigintval($_GET['u_id'])), __FILE__, __LINE__); + // @TODO Try to rewrite this to a filter + if (isExtensionActive('bonus')) { + // Load bonus id + $result = SQL_QUERY_ESC("SELECT `stats_id`, `bonus_id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid`=%s ORDER BY `id`", + array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__); } else { - // Load stats ID (2nd will be ignored later! But it is needed for the same fetchrow command) - $result = SQL_QUERY_ESC("SELECT stats_id, stats_id, link_type FROM "._MYSQL_PREFIX."_user_links WHERE userid=%s ORDER BY id", - array(bigintval($_GET['u_id'])), __FILE__, __LINE__); + // Load stats id (2nd will be ignored later! But it is needed for the same fetchrow command) + $result = SQL_QUERY_ESC("SELECT `stats_id`, `stats_id`, `link_type` FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid`=%s ORDER BY `id` ASC", + array(bigintval(getRequestElement('userid'))), __FILE__, __LINE__); } // Get number of rows from the query @@ -72,106 +69,111 @@ if (!empty($_GET['u_id'])) { if ($nums > 0) { // Some unconfirmed mails left - if ($_GET['del'] == "all") { + if (getRequestElement('del') == "all") { // Delete all unconfirmed mails by this user - SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_user_links WHERE userid=%s LIMIT %s", - array(bigintval($_GET['u_id']), $nums), __FILE__, __LINE__); + SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_user_links` WHERE `userid`=%s LIMIT %s", + array(bigintval(getRequestElement('userid')), $nums), __FILE__, __LINE__); // Prepare mail and send it away - $msg = LOAD_EMAIL_TEMPLATE("admin-del_links", $nums, bigintval($_GET['u_id'])); - SEND_EMAIL($email, ADMIN_DEL_LINK_SUBJ, $msg); + $message = loadEmailTemplate('admin-del_links', $nums, bigintval(getRequestElement('userid'))); + sendEmail(getUserData('email'), getMessage('ADMIN_DEL_LINK_SUBJ'), $message); // Display message - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_LINKS_DELETED); + loadTemplate('admin_settings_saved', false, getMessage('ADMIN_LINKS_DELETED')); } else { + // Init variables + $OUT = ''; $SW = 2; + // List all unconfirmed mails - $SW = 2; $OUT = ""; + // @TODO Find a way to rewrite this. See some lines above for different queries while (list($id, $id2, $type) = SQL_FETCHROW($result)) { // Initializes some variables - $cat = ""; - $DATA = ""; - $PROBLEM = GENERAL_MAIL_PROBLEM; + $cat = ''; + $DATA = ''; + $PROBLEM = getMessage('GENERAL_MAIL_PROBLEM'); $result_data = false; // Closes Bug #58 // Load data from stats table... - switch ($type) - { - case "NORMAL": - $result_data = SQL_QUERY_ESC("SELECT subject, timestamp_ordered, cat_id FROM "._MYSQL_PREFIX."_user_stats WHERE id=%s LIMIT 1", - array(bigintval($id)), __FILE__, __LINE__); - $type = "mailid"; $DATA = $id; $PROBLEM = NORMAL_MAIL_PROBLEM; - $LINK = "".$id.""; - break; - - case "BONUS": - $result_data = SQL_QUERY_ESC("SELECT subject, timestamp, cat_id FROM "._MYSQL_PREFIX."_bonus WHERE id=%s LIMIT 1", - array(bigintval($id2)), __FILE__, __LINE__); - $type = "bonusid"; $DATA = $id2; $PROBLEM = BONUS_MAIL_PROBLEM; - $LINK = "".$id2.""; - break; - - default: // Problem in application detected! - // Log the error - DEBUG_LOG(__FILE__, __LINE__, sprintf("Invalid email type %s detected.", $type)); - break; - } + // @TODO Rewrite this to includes/filter + switch ($type) { + case 'NORMAL': + $result_data = SQL_QUERY_ESC("SELECT `subject`, `timestamp_ordered`, `cat_id` FROM `{?_MYSQL_PREFIX?}_user_stats` WHERE `id`=%s LIMIT 1", + array(bigintval($id)), __FILE__, __LINE__); + $type = 'mailid'; $DATA = $id; $PROBLEM = getMessage('NORMAL_MAIL_PROBLEM'); + $LINK = "".$id.""; + break; + + case 'BONUS': + $result_data = SQL_QUERY_ESC("SELECT `subject`, `timestamp`, `cat_id` FROM `{?_MYSQL_PREFIX?}_bonus` WHERE `id`=%s LIMIT 1", + array(bigintval($id2)), __FILE__, __LINE__); + $type = 'bonusid'; $DATA = $id2; $PROBLEM = getMessage('BONUS_MAIL_PROBLEM'); + $LINK = "".$id2.""; + break; + + default: // Problem in application detected! + // Log the error + logDebugMessage(__FILE__, __LINE__, sprintf("Invalid email type %s detected.", $type)); + break; + } // END - switch if (SQL_NUMROWS($result_data) == 1) { // Mail was found! list($subject, $timestamp, $cat) = SQL_FETCHROW($result_data); - SQL_FREERESULT($result_data); - if (empty($subject)) $subject = DEFAULT_SUBJECT_LINE; + if (empty($subject)) $subject = getMessage('DEFAULT_SUBJECT_LINE'); // Prepare data for the row template $content = array( - 'sw' => $SW, - 'link' => $LINK, - 'subj' => $subject, - 'stamp' => MAKE_DATETIME($timestamp, "0"), - 'cat' => GET_CATEGORY($cat), + 'sw' => $SW, + 'link' => $LINK, + 'subject' => $subject, + 'stamp' => generateDateTime($timestamp, 0), + 'cat' => getCategory($cat), ); // Load row template - $OUT .= LOAD_TEMPLATE("admin_list_links_row", true, $content); + $OUT .= loadTemplate('admin_list_links_row', true, $content); } else { // Load template for error - $OUT .= LOAD_TEMPLATE("admin_list_links_problem", - array( + $OUT .= loadTemplate('admin_list_links_problem', + array( 'sw' => $SW, 'problem' => $PROBLEM, 'data' => $DATA - ) + ) ); } + + // Switch color and free result $SW = 3 - $SW; - } + SQL_FREERESULT($result_data); + } // END - while // Free memory SQL_FREERESULT($result); // Remember list in constant for the template - define('__SNAME_VALUE', $sname); - define('__FNAME_VALUE', $fname); - define('__EMAIL_VALUE', "".$email.""); - define('__EMAIL_LIST' , $OUT); - define('__NUMS_VALUE' , $nums); - define('__UID' , bigintval($_GET['u_id'])); + $content['surname'] = getUserData('surname'); + $content['family'] = getUserData('family'); + $content['email'] = "".getUserData('email').""; + $content['rows'] = $OUT; + $content['nums'] = $nums; + $content['userid'] = bigintval(getRequestElement('userid')); // Load final template - LOAD_TEMPLATE("admin_list_links"); + loadTemplate('admin_list_links', false, $content); } } else { // No mails left to confirm - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_MEMBER_LINKS_1.$_GET['u_id'].ADMIN_MEMBER_LINKS_2); + loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_LINKS'), getRequestElement('userid'))); } } else { // User not found - LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_MEMBER_404_1.$_GET['u_id'].ADMIN_MEMBER_404_2); + loadTemplate('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_404'), getRequestElement('userid'))); } } else { // Output selection form with all confirmed user accounts listed - ADD_MEMBER_SELECTION_BOX(); + addMemberSelectionBox(); } -// +// [EOF] ?>