Previous fix fixed, a lot constants rewritten (unfinished)

[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 acce2dacdf18f93c43ae49feb740dedc1028bb76..268962da75b3f253e4402300690b0c29d5ae0756 100644 (file)
--- a/inc/modules/guest/what-sponsor_reg.php
+++ b/inc/modules/guest/what-sponsor_reg.php
@@ -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,13 +286,13 @@ 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";
                $SW = 2;
-               while(list($id, $name, $rate, $curr, $min) = SQL_FETCHROW($result))
+               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\">