All database names are now 'back-ticked' and constant _MYSQL_PREFIX is wrapped. Partl...

[mailer.git] / inc / modules / guest / what-sponsor_reg.php

diff --git a/inc/modules/guest/what-sponsor_reg.php b/inc/modules/guest/what-sponsor_reg.php
index 7060952e9d3e3b83ec031c873712d41ee5ad4fac..acce2dacdf18f93c43ae49feb740dedc1028bb76 100644 (file)
--- a/inc/modules/guest/what-sponsor_reg.php
+++ b/inc/modules/guest/what-sponsor_reg.php
@@ -36,9 +36,9 @@ if (!defined('__SECURITY')) {
        require($INC);
 } elseif ((!EXT_IS_ACTIVE("sponsor"))) {
        if (IS_ADMIN()) {
-               ADD_FATAL(sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "sponsor"));
+               addFatalMessage(sprintf(EXTENSION_PROBLEM_NOT_INSTALLED, "sponsor"));
        } else {
-               ADD_FATAL(EXTENSION_PROBLEM_EXT_INACTIVE, "sponsor");
+               addFatalMessage(EXTENSION_PROBLEM_EXT_INACTIVE, "sponsor");
        }
        return;
 }
@@ -211,7 +211,7 @@ if ((isset($_POST['ok'])) && (count($FORM_ERRORS) == 0)) {
 
        // Calulate points
        $result = SQL_QUERY_ESC("SELECT (pay_rate * pay_min_count) AS points, pay_min_count AS pay, pay_currency AS curr
-FROM "._MYSQL_PREFIX."_sponsor_paytypes
+FROM `{!MYSQL_PREFIX!}_sponsor_paytypes`
 WHERE id='%s' LIMIT 1", array($_POST['pay_type']), __FILE__, __LINE__);
        list($points, $pay, $curr) = SQL_FETCHROW($result);
 
@@ -232,7 +232,7 @@ WHERE id='%s' LIMIT 1", array($_POST['pay_type']), __FILE__, __LINE__);
        {
        case "added": // Sponsor successfully added with account status = UNCONFIRMED!
                // Check for his ID number
-               $result = SQL_QUERY_ESC("SELECT id, hash FROM "._MYSQL_PREFIX."_sponsor_data WHERE email='%s' LIMIT 1",
+               $result = SQL_QUERY_ESC("SELECT id, hash FROM `{!MYSQL_PREFIX!}_sponsor_data` WHERE email='%s' LIMIT 1",
                 array($_POST['email']), __FILE__, __LINE__);
                if (SQL_NUMROWS($result) == 1)
                {
@@ -286,23 +286,23 @@ WHERE id='%s' LIMIT 1", array($_POST['pay_type']), __FILE__, __LINE__);
 } else {
        // Check for payment types
        $result = SQL_QUERY("SELECT id, pay_name, pay_rate, pay_currency, pay_min_count
-FROM "._MYSQL_PREFIX."_sponsor_paytypes
+FROM `{!MYSQL_PREFIX!}_sponsor_paytypes`
 ORDER BY pay_name", __FILE__, __LINE__);
        if (SQL_NUMROWS($result) > 0) {
                // Load all types...
-               $OUT = "<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"300\" class=\"left2 right2 top2\">\n";
+               $OUT = "<table border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"300\" class=\"left2 right2 top2\">\n";
                $SW = 2;
                while(list($id, $name, $rate, $curr, $min) = SQL_FETCHROW($result))
                {
-                       $OUT .= "<TR>
-  <TD class=\"bottom2 switch_sw".$SW."\" height=\"50\" style=\"padding-left: 2px; padding-right: 2px\">
-    <INPUT type=\"radio\" name=\"pay_type\" class=\"guest_normal\" value=\"".bigintval($id)."\">&nbsp;".$name."<br />
-    <DIV align=\"right\">(".$min." ".$curr." = ".TRANSLATE_COMMA($rate * $min)." ".POINTS.")</DIV>
-  </TD>
-</TR>\n";
+                       $OUT .= "<tr>
+  <td class=\"bottom2 switch_sw".$SW."\" height=\"50\" style=\"padding-left: 2px; padding-right: 2px\">
+    <input type=\"radio\" name=\"pay_type\" class=\"guest_normal\" value=\"".bigintval($id)."\" />&nbsp;".$name."<br />
+    <div align=\"right\">(".$min." ".$curr." = ".TRANSLATE_COMMA($rate * $min)." {!POINTS!})</div>
+  </td>
+</tr>\n";
                        $SW = 3 - $SW;
                }
-               $OUT .= "</TABLE>\n";
+               $OUT .= "</table>\n";
                define('__PAYMENT_LIST', $OUT);
                SQL_FREERESULT($result);
 
@@ -364,14 +364,14 @@ ORDER BY pay_name", __FILE__, __LINE__);
 
                        // Errors found
                        $OUT = "<P align=\"center\">
-  <STRONG><FONT class=\"guest_failed\">".SPONSOR_REGISTER_SOMETHING_MISSING.":</FONT></STRONG><br />
+  <strong><div class=\"guest_failed\">".SPONSOR_REGISTER_SOMETHING_MISSING.":</div></strong><br />
 </P>
-<OL>\n";
+<ol>\n";
                        foreach ($FORM_ERRORS as $error) {
-                               $OUT .= "<LI>".$error."</LI>\n";
+                               $OUT .= "<li>".$error."</li>\n";
                        } // END - if
 
-                       $OUT .= "</OL><br />\n";
+                       $OUT .= "</ol><br />\n";
                        define('__SPONSOR_FORM_ERRORS', $OUT);
                        define('__SPONSOR_REFID', $_POST['refid']);
                } else {