Ticket resolved, code rewrites and caching:

[mailer.git] / inc / modules / admin / what-lock_sponsor.php

diff --git a/inc/modules/admin/what-lock_sponsor.php b/inc/modules/admin/what-lock_sponsor.php
index a4aebb3c8b3dd0fe8fc2abf78bb116c7565cf45e..1fbb82598147d1fe2c9383c1b78ea9b5bbed5d03 100644 (file)
--- 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,11 +78,11 @@ 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!
-                               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") {
@@ -96,7 +96,7 @@ if (!empty($_GET['id'])) {
                                }
 
                                // Create email link
-                               define('__EMAIL_LINK', "<A href=\"mailto:".$email."\">".__GENDER." ".__SURNAME." ".__FAMILY."</A>");
+                               define('__EMAIL_LINK', "<a href=\"mailto:".$email."\">".__GENDER." ".__SURNAME." ".__FAMILY."</a>");
 
                                // Display form
                                LOAD_TEMPLATE("admin_lock_sponsor");