X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-lock_sponsor.php;h=1fbb82598147d1fe2c9383c1b78ea9b5bbed5d03;hb=c47144dd555bbab4acdf9085e4623900dedb0e7c;hp=433f5be562f3a273902bf1742a7654212e981298;hpb=d18075f375db1b9db40773cdf80a5d6f2c36cd3a;p=mailer.git

diff --git a/inc/modules/admin/what-lock_sponsor.php b/inc/modules/admin/what-lock_sponsor.php
index 433f5be562..1fbb825981 100644
--- a/inc/modules/admin/what-lock_sponsor.php
+++ b/inc/modules/admin/what-lock_sponsor.php
@@ -15,9 +15,10 @@
  * Copyright (c) 2003 - 2008 by Roland Haeder                           *
  * For more information visit: http://www.mxchange.org                  *
  *                                                                      *
- * This program is free software. You can redistribute it and/or modify *
+ * This program is free software; you can redistribute it and/or modify *
  * it under the terms of the GNU General Public License as published by *
- * the Free Software Foundation; either version 2 of the License.       *
+ * the Free Software Foundation; either version 2 of the License, or    *
+ * (at your option) any later version.                                  *
  *                                                                      *
  * This program is distributed in the hope that it will be useful,      *
  * but WITHOUT ANY WARRANTY; without even the implied warranty of       *
@@ -31,27 +32,27 @@
  ************************************************************************/
 
 // Some security stuff...
-if ((ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) || (!is_admin())) {
+if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 	$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4)."/security.php";
 	require($INC);
 }
 
 // Add description as navigation point
-ADD_DESCR("admin", basename(__FILE__));
+ADD_DESCR("admin", __FILE__);
 $MSG = "";
 
 if (!empty($_GET['id'])) {
 	// Check for selected sponsor
-	$result = SQL_QUERY_ESC("SELECT salut, surname, family, email, status FROM "._MYSQL_PREFIX."_sponsor_data WHERE id='%s' LIMIT 1",
+	$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) {
 		// Get sponsor's current status and let only confirmed and locked status pass
-		list($salut, $sname, $fname, $email, $status) = SQL_FETCHROW($result);
+		list($gender, $sname, $fname, $email, $status) = SQL_FETCHROW($result);
 		SQL_FREERESULT($result);
 
 		if (($status == "CONFIRMED") || ($status == "LOCKED")) {
 			// Transfer data to constants
-			define('__SALUT'  , TRANSLATE_SEX($salut));
+			define('__GENDER'  , TRANSLATE_GENDER($gender));
 			define('__SURNAME', $sname);
 			define('__FAMILY' , $fname);
 			define('__ID'     , bigintval($_GET['id']));
@@ -77,11 +78,11 @@ if (!empty($_GET['id'])) {
 				SEND_EMAIL($email, $subject, $msg);
 
 				// Update sponsor's account
-				$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='".$status."' WHERE id='%s' LIMIT 1",
-				 array(bigintval($_GET['id'])), __FILE__, __LINE__);
+				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'])) {
 				// No don't lock / unlock now!
-				LOAD_URL(URL."/modules.php?module=admin&what=list_sponsor&id=".bigintval($_GET['id']));
+				LOAD_URL("modules.php?module=admin&what=list_sponsor&id=".bigintval($_GET['id']));
 			} else {
 				// Create header and text messages
 				if ($status == "CONFIRMED") {
@@ -95,7 +96,7 @@ if (!empty($_GET['id'])) {
 				}
 
 				// Create email link
-				define('__EMAIL_LINK', "<A href=\"mailto:".$email."\">".__SALUT." ".__SURNAME." ".__FAMILY."</A>");
+				define('__EMAIL_LINK', "<a href=\"mailto:".$email."\">".__GENDER." ".__SURNAME." ".__FAMILY."</a>");
 
 				// Display form
 				LOAD_TEMPLATE("admin_lock_sponsor");