X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fmodules%2Fadmin%2Fwhat-lock_sponsor.php;h=1fbb82598147d1fe2c9383c1b78ea9b5bbed5d03;hb=ab92fb7241d00636b0eb940f147449758820cba1;hp=adcc4407a21845763ab917b54fa7c67f35c887f9;hpb=a312348b000e45f28d989902bb377218393d5f06;p=mailer.git diff --git a/inc/modules/admin/what-lock_sponsor.php b/inc/modules/admin/what-lock_sponsor.php index adcc4407a2..1fbb825981 100644 --- a/inc/modules/admin/what-lock_sponsor.php +++ b/inc/modules/admin/what-lock_sponsor.php @@ -43,7 +43,7 @@ $MSG = ""; if (!empty($_GET['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", + $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 @@ -78,7 +78,7 @@ if (!empty($_GET['id'])) { SEND_EMAIL($email, $subject, $msg); // Update sponsor's account - SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='".$status."' WHERE id='%s' LIMIT 1", + 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! @@ -96,7 +96,7 @@ if (!empty($_GET['id'])) { } // Create email link - define('__EMAIL_LINK', "".__GENDER." ".__SURNAME." ".__FAMILY.""); + define('__EMAIL_LINK', "".__GENDER." ".__SURNAME." ".__FAMILY.""); // Display form LOAD_TEMPLATE("admin_lock_sponsor");