- Major change in LOAD_EMAIL_TEMPLATE(). The deprecated switch() block has

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

diff --git a/inc/modules/admin/what-unlock_sponsor.php b/inc/modules/admin/what-unlock_sponsor.php
index 130f511cf97a8569334ca83f422fbae2921be5f9..c3894d99a6da88f5d699ff12edadf32396be9716 100644 (file)
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -34,19 +34,19 @@ if (isset($_POST['ok'])) {
        // Does he have selected at least one sponsor?
        if (SELECTION_COUNT($_POST['id']) > 0) {
                // At least one entry selected
-               foreach ($_POST['id'] as $id=>$sel) {
+               foreach ($_POST['id'] as $id => $sel) {
                        // Secure ID number
                        $id = bigintval($id);
 
                        // Load his personal data
-                       $result_main = SQL_QUERY_ESC("SELECT salut, surname, family, email, remote_addr, sponsor_created, points_amount, refid
+                       $result_main = SQL_QUERY_ESC("SELECT gender, surname, family, email, remote_addr, sponsor_created, points_amount, refid
 FROM "._MYSQL_PREFIX."_sponsor_data
 WHERE status='PENDING' AND id='%s' LIMIT 1",
  array($id), __FILE__, __LINE__);
                        $refid = 0;
                        if (SQL_NUMROWS($result_main) == 1) {
                                // Load data and free memory
-                               list($salut, $sname, $fname, $email, $ip, $created, $points, $refid) = SQL_FETCHROW($result_main);
+                               list($gender, $sname, $fname, $email, $ip, $created, $points, $refid) = SQL_FETCHROW($result_main);
 
                                // Check for open payments and close them
                                $result = SQL_QUERY_ESC("SELECT DISTINCT so.aid, so.pay_count, so.pay_ordered, so.pay_status,
@@ -112,9 +112,9 @@ WHERE id='%s' LIMIT 1",
  array($CONFIG['sponsor_ref_points'], bigintval($refid)), __FILE__, __LINE__);
 
                                // Whas that update fine?
-                               if (SQL_AFFECTED_ROWS($link) == 1) {
+                               if (SQL_AFFECTEDROWS() == 1) {
                                        // Load referral's data
-                                       $result = SQL_QUERY_ESC("SELECT id, salut, surname, family, email,
+                                       $result = SQL_QUERY_ESC("SELECT id, gender, surname, family, email,
 (points_amount - points_used) AS points, receive_warnings, ref_count AS refs
 FROM "._MYSQL_PREFIX."_sponsor_data
 WHERE id='%s' LIMIT 1",
@@ -126,7 +126,7 @@ WHERE id='%s' LIMIT 1",
                                                // Translate some data
                                                $REFERRAL['points']     = TRANSLATE_COMMA($REFERRAL['points']);
                                                $REFERRAL['ref_points'] = TRANSLATE_COMMA($CONFIG['sponsor_ref_points']);
-                                               $REFERRAL['salut']      = TRANSLATE_SEX($REFERRAL['salut']);
+                                               $REFERRAL['gender']      = TRANSLATE_GENDER($REFERRAL['gender']);
 
                                                // Send notification to referral
                                                $REF_MSG = LOAD_EMAIL_TEMPLATE("sponsor_ref_notify", $REFERRAL);
@@ -139,7 +139,7 @@ WHERE id='%s' LIMIT 1",
                        }
 
                        // Transfer data to array
-                       $content['salut']   = TRANSLATE_SEX($salut);
+                       $content['gender']   = TRANSLATE_GENDER($gender);
                        $content['surname'] = $sname;
                        $content['family']  = $fname;
                        $content['sponsor'] = $id;
@@ -159,19 +159,19 @@ WHERE id='%s' LIMIT 1",
 }
 
 // Begin listing of all pending sponsor accounts
-$result = SQL_QUERY("SELECT id, salut, surname, family, email, remote_addr, sponsor_created
+$result = SQL_QUERY("SELECT id, gender, surname, family, email, remote_addr, sponsor_created
 FROM "._MYSQL_PREFIX."_sponsor_data
 WHERE status='PENDING' ORDER BY id", __FILE__, __LINE__);
 
 if (SQL_NUMROWS($result) > 0) {
        // Entries found so let's list them!
        $OUT = ""; $SW = 2;
-       while(list($id, $salut, $sname, $fname, $email, $ip, $created) = SQL_FETCHROW($result)) {
+       while(list($id, $gender, $sname, $fname, $email, $ip, $created) = SQL_FETCHROW($result)) {
                // Transfer data to array
                $content = array(
                        'sw'      => $SW,
                        'id'      => $id,
-                       'salut'   => TRANSLATE_SEX($salut),
+                       'gender'   => TRANSLATE_GENDER($gender),
                        'surname' => $sname,
                        'family'  => $fname,
                        'email'   => "mailto:".$email,