Referal overview finished and rewritten for refback extension

[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 c919881b8363cd6570a24be503b290a93868cf41..812dca9103f1d49df253896cc51e4a229e4012a1 100644 (file)
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -66,13 +66,7 @@ ORDER BY sp.pay_name",
                                                        $aid = SPONSOR_NO_ADMIN;
                                                } else {
                                                        // Load admin's email address for contact
-                                                       $result_aid = SQL_QUERY_ESC("SELECT email FROM "._MYSQL_PREFIX."_admins WHERE id='%s' LIMIT 1",
-                                                        array(bigintval($aid)), __FILE__, __LINE__);
-                                                       list($aid) = SQL_FETCHROW($result_aid);
-                                                       SQL_FREERESULT($result_aid);
-
-                                                       // Check if admin login is still in db
-                                                       if (empty($aid)) $aid = ADMIN_NOT_FOUND;
+                                                       $aid = GET_ADMIN_EMAIL(GET_ADMIN_LOGIN(($aid));
                                                }
 
                                                // Transfer data to array
@@ -103,9 +97,9 @@ ORDER BY sp.pay_name",
 WHERE id='%s' AND status='PENDING' LIMIT 1",
  array($id), __FILE__, __LINE__);
 
-                       // Update, if applyable, referral count and points
+                       // Update, if applyable, referal count and points
                        if (($refid > 0) && ($refid != $id)) {
-                               // Update referral account
+                               // Update referal account
                                $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data
 SET points_amount=points_amount+%s, ref_count=ref_count+1
 WHERE id='%s' LIMIT 1",
@@ -113,7 +107,7 @@ WHERE id='%s' LIMIT 1",
 
                                // Whas that update fine?
                                if (SQL_AFFECTEDROWS() == 1) {
-                                       // Load referral's data
+                                       // Load referal's data
                                        $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
@@ -128,7 +122,7 @@ WHERE id='%s' LIMIT 1",
                                                $REFERRAL['ref_points'] = TRANSLATE_COMMA($_CONFIG['sponsor_ref_points']);
                                                $REFERRAL['gender']      = TRANSLATE_GENDER($REFERRAL['gender']);
 
-                                               // Send notification to referral
+                                               // Send notification to referal
                                                $REF_MSG = LOAD_EMAIL_TEMPLATE("sponsor_ref_notify", $REFERRAL);
                                                SEND_EMAIL($REFERRAL['email'], SPONSOR_REF_NOTIFY_SUBJ, $REF_MSG);
                                        }