X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-list_links.php;h=aa10df751a7c18ab0ec1d80597fa449c074cef1e;hp=1a175ac9b1492594d37c004feb73ac0c42f4f3ef;hb=3f51c40f4fede87228216f9285b745a339e3891d;hpb=414570c5081d337bb6c28dcf521bd8bca02f69e7 diff --git a/inc/modules/admin/what-list_links.php b/inc/modules/admin/what-list_links.php index 1a175ac9b1..aa10df751a 100644 --- a/inc/modules/admin/what-list_links.php +++ b/inc/modules/admin/what-list_links.php @@ -10,10 +10,10 @@ * -------------------------------------------------------------------- * * Kurzbeschreibung : Unbestaetigte Mails eines Mitgliedes auflisten * * -------------------------------------------------------------------- * - * $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!!!!!! * * -------------------------------------------------------------------- * @@ -38,38 +38,38 @@ // Some security stuff... if ((!defined('__SECURITY')) || (!IS_ADMIN())) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php"; + $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; require($INC); -} elseif (!EXT_IS_ACTIVE("mailid")) { - addFatalMessage(__FILE__, __LINE__, getMessage('EXTENSION_PROBLEM_EXT_INACTIVE'), "mailid"); +} elseif (!EXT_IS_ACTIVE('mailid')) { + addFatalMessage(__FILE__, __LINE__, generateExtensionInactiveNotInstalledMessage('mailid')); return; } // Add description as navigation point -ADD_DESCR("admin", __FILE__); +ADD_DESCR('admin', __FILE__); -if (!REQUEST_ISSET_GET('del')) REQUEST_SET_GET('del', ""); +if (!REQUEST_ISSET_GET('del')) REQUEST_SET_GET('del', ''); -if (REQUEST_ISSET_GET(('uid'))) { +if (REQUEST_ISSET_GET('uid')) { // 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(REQUEST_GET('uid'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); - // Is there an entry? + // 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); // Grab user's all unconfirmed mails - if (EXT_IS_ACTIVE("bonus")) { + 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(REQUEST_GET('uid'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('uid'))), __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(REQUEST_GET('uid'))), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('uid'))), __FILE__, __LINE__); } // Get number of rows from the query @@ -80,48 +80,48 @@ if (REQUEST_ISSET_GET(('uid'))) { if (REQUEST_GET('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(REQUEST_GET('uid')), $nums), __FILE__, __LINE__); + array(bigintval(REQUEST_GET('uid')), $nums), __FILE__, __LINE__); // Prepare mail and send it away $msg = LOAD_EMAIL_TEMPLATE("admin-del_links", $nums, bigintval(REQUEST_GET('uid'))); - SEND_EMAIL($email, getMessage('ADMIN_DEL_LINK_SUBJ'), $msg); + sendEmail($email, getMessage('ADMIN_DEL_LINK_SUBJ'), $msg); // Display message - LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_LINKS_DELETED')); + LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_LINKS_DELETED')); } else { // Init variables - $OUT = ""; $SW = 2; + $OUT = ''; $SW = 2; // List all unconfirmed mails // @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 = ""; + $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", + // @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; + $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", + 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 - DEBUG_LOG(__FILE__, __LINE__, sprintf("Invalid email type %s detected.", $type)); - break; + $type = 'bonusid'; $DATA = $id2; $PROBLEM = getMessage('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; } if (SQL_NUMROWS($result_data) == 1) { @@ -135,20 +135,20 @@ if (REQUEST_ISSET_GET(('uid'))) { 'sw' => $SW, 'link' => $LINK, 'subj' => $subject, - 'stamp' => MAKE_DATETIME($timestamp, "0"), - 'cat' => GET_CATEGORY($cat), + 'stamp' => generateDateTime($timestamp, '0'), + 'cat' => getCategory($cat), ); // Load row template - $OUT .= LOAD_TEMPLATE("admin_list_links_row", true, $content); + $OUT .= LOAD_TEMPLATE('admin_list_links_row', true, $content); } else { // Load template for error - $OUT .= LOAD_TEMPLATE("admin_list_links_problem", - array( + $OUT .= LOAD_TEMPLATE('admin_list_links_problem', + array( 'sw' => $SW, 'problem' => $PROBLEM, 'data' => $DATA - ) + ) ); } $SW = 3 - $SW; @@ -160,21 +160,21 @@ if (REQUEST_ISSET_GET(('uid'))) { // Remember list in constant for the template define('__SNAME_VALUE', $sname); define('__FNAME_VALUE', $fname); - define('__EMAIL_VALUE', "".$email.""); + define('__EMAIL_VALUE', "".$email.""); define('__EMAIL_LIST' , $OUT); define('__NUMS_VALUE' , $nums); define('__UID' , bigintval(REQUEST_GET('uid'))); // Load final template - LOAD_TEMPLATE("admin_list_links"); + LOAD_TEMPLATE('admin_list_links'); } } else { // No mails left to confirm - LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_MEMBER_LINKS'), REQUEST_GET('uid'))); + LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_LINKS'), REQUEST_GET('uid'))); } } else { // User not found - LOAD_TEMPLATE("admin_settings_saved", false, sprintf(getMessage('ADMIN_MEMBER_404'), REQUEST_GET('uid'))); + LOAD_TEMPLATE('admin_settings_saved', false, sprintf(getMessage('ADMIN_MEMBER_404'), REQUEST_GET('uid'))); } } else { // Output selection form with all confirmed user accounts listed