A lot has been rewritten, ext-teams added, ext-forced continued:
[mailer.git] / inc / modules / admin / what-lock_sponsor.php
index 834aab41f51a630c7fc84b4e7358ee48bc07011c..dff0cb7793e00706148f1393a3e841a49422fda8 100644 (file)
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * M-XChange v0.2.1                                   Start: 04/24/2005 *
- * ================                             Last change: 05/19/2008 *
+ * Mailer v0.2.1-FINAL                                Start: 04/24/2005 *
+ * ===================                          Last change: 05/19/2008 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : what-lock_sponsor.php                            *
  * -------------------------------------------------------------------- *
  * Kurzbeschreibung  : Sponsorenaccount aendern                         *
  * -------------------------------------------------------------------- *
- *                                                                      *
+ * $Revision::                                                        $ *
+ * $Date::                                                            $ *
+ * $Tag:: 0.2.1-FINAL                                                 $ *
+ * $Author::                                                          $ *
  * -------------------------------------------------------------------- *
- * Copyright (c) 2003 - 2008 by Roland Haeder                           *
+ * Copyright (c) 2003 - 2009 by Roland Haeder                           *
+ * Copyright (c) 2009 - 2011 by Mailer Developer Team                   *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
  * This program is free software; you can redistribute it and/or modify *
  ************************************************************************/
 
 // 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__);
-$MSG = "";
+addYouAreHereLink('admin', __FILE__);
+$message = '';
 
-if (!empty($_GET['id'])) {
+if (isGetRequestParameterSet('id')) {
        // Check for selected sponsor
-       $result = SQL_QUERY_ESC("SELECT gender, surname, family, email, status FROM `{!MYSQL_PREFIX!}_sponsor_data` WHERE id='%s' LIMIT 1",
-        array(bigintval($_GET['id'])), __FILE__, __LINE__);
-       if (SQL_NUMROWS($result) == 1) {
+       $result_sponsor = SQL_QUERY_ESC("SELECT `gender`,`surname`,`family`,`email`,`status` FROM `{?_MYSQL_PREFIX?}_sponsor_data` WHERE `id`=%s LIMIT 1",
+               array(bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
+       if (SQL_NUMROWS($result_sponsor) == 1) {
                // Get sponsor's current status and let only confirmed and locked status pass
-               list($gender, $sname, $fname, $email, $status) = SQL_FETCHROW($result);
-               SQL_FREERESULT($result);
+               $content = SQL_FETCHARRAY($result_sponsor);
 
-               if (($status == "CONFIRMED") || ($status == "LOCKED")) {
+               if (($content['status'] == 'CONFIRMED') || ($content['status'] == 'LOCKED')) {
                        // Transfer data to constants
-                       define('__GENDER'  , TRANSLATE_GENDER($gender));
-                       define('__SURNAME', $sname);
-                       define('__FAMILY' , $fname);
-                       define('__ID'     , bigintval($_GET['id']));
+                       $content['id']     = bigintval(getRequestParameter('id'));
+                       $content['reason'] = postRequestParameter('reason');
 
-                       if (isset($_POST['ok'])) {
+                       if (isFormSent()) {
                                // Create messages
-                               if ($status == "CONFIRMED") {
+                               if ($content['status'] == 'CONFIRMED') {
                                        // Message when sponsor's account got lock
-                                       define('__EMAIL_MSG', SPONSOR_ACCOUNT_LOCKED);
-                                       $subject = SPONSOR_SUBJECT_LOCKED;
-                                       $status = "LOCKED";
+                                       $content['message'] = '{--SPONSOR_ACCOUNT_LOCKED--}';
+                                       $subject = '{--SPONSOR_LOCKED_SUBJECT--}';
+                                       $content['status'] = 'LOCKED';
                                } else {
                                        // Message when sponsor's account got unlock
-                                       define('__EMAIL_MSG', SPONSOR_ACCOUNT_UNLOCKED);
-                                       $subject = SPONSOR_SUBJECT_UNLOCKED;
-                                       $status = "CONFIRMED";
+                                       $content['message'] = '{--SPONSOR_ACCOUNT_UNLOCKED--}';
+                                       $subject = '{--SPONSOR_UNLOCKED_SUBJECT--}';
+                                       $content['status'] = 'CONFIRMED';
                                }
 
                                // Load email message
-                               $msg = LOAD_EMAIL_TEMPLATE("lock_sponsor", $_POST['reason'], bigintval($_GET['id']));
+                               $message = loadEmailTemplate('lock_sponsor', $content, bigintval(getRequestParameter('id')));
 
                                // And send it away
-                               SEND_EMAIL($email, $subject, $msg);
+                               sendEmail($content['email'], $subject, $message);
 
                                // Update sponsor's account
-                               SQL_QUERY_ESC("UPDATE `{!MYSQL_PREFIX!}_sponsor_data` SET status='".$status."' WHERE id='%s' LIMIT 1",
-                                       array(bigintval($_GET['id'])), __FILE__, __LINE__);
-                       } elseif (!empty($_POST['no'])) {
+                               SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_sponsor_data` SET `status`='%s' WHERE `id`=%s LIMIT 1",
+                                       array($content['status'], bigintval(getRequestParameter('id'))), __FILE__, __LINE__);
+                       } elseif (isPostRequestParameterSet('no')) {
                                // No don't lock / unlock now!
-                               LOAD_URL("modules.php?module=admin&amp;what=list_sponsor&amp;id=".bigintval($_GET['id']));
+                               redirectToUrl('modules.php?module=admin&amp;what=list_sponsor&amp;id=' . bigintval(getRequestParameter('id')));
                        } else {
                                // Create header and text messages
-                               if ($status == "CONFIRMED") {
+                               if ($content['status'] == 'CONFIRMED') {
                                        // Messages when sponsor's account is confirmed
-                                       define('__HEADER_MESSAGE', SPONSOR_LOCK_SPONSOR_HEADER);
-                                       define('__TEXT_MESSAGE'  , SPONSOR_LOCK_SPONSOR_TEXT);
+                                       $content['header_message'] = '{--SPONSOR_LOCK_SPONSOR_HEADER--}';
+                                       $content['text_message']   = '{--SPONSOR_LOCK_SPONSOR_TEXT--}';
                                } else {
                                        // Messages when sponsor's account is locked
-                                       define('__HEADER_MESSAGE', SPONSOR_UNLOCK_SPONSOR_HEADER);
-                                       define('__TEXT_MESSAGE'  , SPONSOR_UNLOCK_SPONSOR_TEXT);
+                                       $content['header_message'] = '{--SPONSOR_UNLOCK_SPONSOR_HEADER--}';
+                                       $content['text_message']   = '{--SPONSOR_UNLOCK_SPONSOR_TEXT--}';
                                }
 
                                // Create email link
-                               define('__EMAIL_LINK', "<a href=\"mailto:".$email."\">".__GENDER." ".__SURNAME." ".__FAMILY."</a>");
+                               $content['email_link'] = '<a href="' . generateEmailLink($content['email'], 'sponsor_data') . '">' . $content['gender'] . ' ' . $content['surname'] . ' ' . $content['family'] . '</a>';
 
                                // Display form
-                               LOAD_TEMPLATE("admin_lock_sponsor");
+                               loadTemplate('admin_lock_sponsor', false, $content);
                        }
                } else {
                        // Cannot change status on unconfirmed or pending accounts!
-                       $MSG = ADMIN_SPONSPOR_CANNOT_LOCK_PENDING_UNCINFIRMED_ACCOUNTS;
+                       $message = '{--ADMIN_SPONSOR_CANNOT_LOCK_PENDING_UNCINFIRMED_ACCOUNTS--}';
                }
        } else {
-               // Sponsor not found!
-               $MSG = ADMIN_SPONSOR_404_1.bigintval($_GET['id']).ADMIN_SPONSOR_404_2;
+               // Sponsor not found
+               $message = '{%message,ADMIN_SPONSOR_404=' . bigintval(getRequestParameter('id')) . '%}';
        }
+
+       // Free result
+       SQL_FREERESULT($result_sponsor);
 } else {
        // Not called by what-list_sponsor.php
-       $MSG = ADMIN_CALL_NOT_DIRECTLY;
+       $message = '{--ADMIN_CALL_NOT_DIRECTLY--}';
 }
 
-if (!empty($MSG)) {
+if (!empty($message)) {
        // Output message
-       LOAD_TEMPLATE("admin_settings_saved", false, $MSG);
-}
-//
+       displayMessage($message);
+} // END - if
+
+// [EOF]
 ?>