X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-lock_sponsor.php;h=152cb1a39735ad4762ff6ae0e3152684160696ea;hb=996586caead345147b60216d2f4325b5f57a9874;hp=fcda54a4f562458d60e748dc41565af4707ee5ca;hpb=b8aa17b98b99c27eafbdca0fa090bae63527da9a;p=mailer.git diff --git a/inc/modules/admin/what-lock_sponsor.php b/inc/modules/admin/what-lock_sponsor.php index fcda54a4f5..152cb1a397 100644 --- a/inc/modules/admin/what-lock_sponsor.php +++ b/inc/modules/admin/what-lock_sponsor.php @@ -17,7 +17,7 @@ * 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 * @@ -37,73 +37,71 @@ ************************************************************************/ // Some security stuff... -if ((!defined('__SECURITY')) || (!IS_ADMIN())) { - $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), '/inc') + 4) . '/security.php'; - require($INC); +if ((!defined('__SECURITY')) || (!isAdmin())) { + die(); } // END - if // Add description as navigation point -ADD_DESCR('admin', __FILE__); +addMenuDescription('admin', __FILE__); $message = ''; -if (REQUEST_ISSET_GET('id')) { +if (isGetRequestElementSet('id')) { // Check for selected sponsor - $result_sponsor = SQL_QUERY_ESC("SELECT `gender`, `surname`, `family`, `email`, `status` FROM `{!_MYSQL_PREFIX!}_sponsor_data` WHERE `id`='%s' LIMIT 1", - array(bigintval(REQUEST_GET('id'))), __FILE__, __LINE__); + $result_sponsor = SQL_QUERY_ESC("SELECT `gender`, `surname`, `family`, `email`, `status` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`='%s' LIMIT 1", + array(bigintval(getRequestElement('id'))), __FILE__, __LINE__); if (SQL_NUMROWS($result_sponsor) == 1) { // Get sponsor's current status and let only confirmed and locked status pass - $DATA = SQL_FETCHARRAY($result_sponsor); + $content = SQL_FETCHARRAY($result_sponsor); - if (($DATA['status'] == 'CONFIRMED') || ($DATA['status'] == 'LOCKED')) { + if (($content['status'] == 'CONFIRMED') || ($content['status'] == 'LOCKED')) { // Transfer data to constants - define('__GENDER' , translateGender($DATA['gender'])); - define('__SURNAME', $DATA['surname']); - define('__FAMILY' , $DATA['family']); - define('__ID' , bigintval(REQUEST_GET('id'))); + $content['gender'] = translateGender($content['gender']); + $content['id'] = bigintval(getRequestElement('id')); + $content['reason'] = secureString(postRequestElement('reason')); if (isFormSent()) { // Create messages - if ($DATA['status'] == 'CONFIRMED') { + if ($content['status'] == 'CONFIRMED') { // Message when sponsor's account got lock - define('__EMAIL_MSG', getMessage('SPONSOR_ACCOUNT_LOCKED')); + $content['message'] = getMessage('SPONSOR_ACCOUNT_LOCKED'); $subject = getMessage('SPONSOR_SUBJECT_LOCKED'); - $DATA['status'] = 'LOCKED'; + $content['status'] = 'LOCKED'; } else { // Message when sponsor's account got unlock - define('__EMAIL_MSG', getMessage('SPONSOR_ACCOUNT_UNLOCKED')); + $content['message'] = getMessage('SPONSOR_ACCOUNT_UNLOCKED'); $subject = getMessage('SPONSOR_SUBJECT_UNLOCKED'); - $DATA['status'] = 'CONFIRMED'; + $content['status'] = 'CONFIRMED'; } // Load email message - $message = LOAD_EMAIL_TEMPLATE('lock_sponsor', REQUEST_POST('reason'), bigintval(REQUEST_GET('id'))); + $message = loadEmailTemplate('lock_sponsor', $content, bigintval(getRequestElement('id'))); // And send it away - sendEmail($DATA['email'], $subject, $message); + sendEmail($content['email'], $subject, $message); // Update sponsor's account - SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET `status`='".$DATA['status']."' WHERE `id`='%s' LIMIT 1", - array(bigintval(REQUEST_GET('id'))), __FILE__, __LINE__); - } elseif (REQUEST_ISSET_POST('no')) { + SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `status`='%s' WHERE `id`='%s' LIMIT 1", + array($content['status'], bigintval(getRequestElement('id'))), __FILE__, __LINE__); + } elseif (isPostRequestElementSet('no')) { // No don't lock / unlock now! - redirectToUrl('modules.php?module=admin&what=list_sponsor&id='.bigintval(REQUEST_GET('id'))); + redirectToUrl('modules.php?module=admin&what=list_sponsor&id=' . bigintval(getRequestElement('id'))); } else { // Create header and text messages - if ($DATA['status'] == 'CONFIRMED') { + if ($content['status'] == 'CONFIRMED') { // Messages when sponsor's account is confirmed - define('__HEADER_MESSAGE', getMessage('SPONSOR_LOCK_SPONSOR_HEADER')); - define('__TEXT_MESSAGE' , getMessage('SPONSOR_LOCK_SPONSOR_TEXT')); + $content['header_message'] = getMessage('SPONSOR_LOCK_SPONSOR_HEADER'); + $content['text_message'] = getMessage('SPONSOR_LOCK_SPONSOR_TEXT'); } else { // Messages when sponsor's account is locked - define('__HEADER_MESSAGE', getMessage('SPONSOR_UNLOCK_SPONSOR_HEADER')); - define('__TEXT_MESSAGE' , getMessage('SPONSOR_UNLOCK_SPONSOR_TEXT')); + $content['header_message'] = getMessage('SPONSOR_UNLOCK_SPONSOR_HEADER'); + $content['text_message'] = getMessage('SPONSOR_UNLOCK_SPONSOR_TEXT'); } // Create email link - define('__EMAIL_LINK', '{!__GENDER!} {!__SURNAME!} {!__FAMILY!}'); + $content['email_link'] = '' . $content['gender'] . ' ' . $content['surname'] . ' ' . $content['family'] . ''; // Display form - LOAD_TEMPLATE('admin_lock_sponsor'); + loadTemplate('admin_lock_sponsor', false, $content); } } else { // Cannot change status on unconfirmed or pending accounts! @@ -111,7 +109,7 @@ if (REQUEST_ISSET_GET('id')) { } } else { // Sponsor not found! - $message = sprintf(getMessage('ADMIN_SPONSOR_404'), bigintval(REQUEST_GET('id'))); + $message = sprintf(getMessage('ADMIN_SPONSOR_404'), bigintval(getRequestElement('id'))); } // Free result @@ -123,8 +121,8 @@ if (REQUEST_ISSET_GET('id')) { if (!empty($message)) { // Output message - LOAD_TEMPLATE('admin_settings_saved', false, $message); + loadTemplate('admin_settings_saved', false, $message); } // END - if -// +// [EOF] ?>