Login form for guests in surfbar added, some trigger_error() added, misc rewrites

[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 e6e6866993d369deba3747d1cba97e46ceca321d..16eecaa2bb8df1bb1136df794f2444a3566b133a 100644 (file)
--- a/inc/modules/admin/what-unlock_sponsor.php
+++ b/inc/modules/admin/what-unlock_sponsor.php
@@ -46,7 +46,7 @@ if ((!defined('__SECURITY')) || (!IS_ADMIN())) {
 ADD_DESCR('admin', __FILE__);
 
 // Check if admin has submitted form
-if (IS_FORM_SENT()) {
+if (isFormSent()) {
        // Does he have selected at least one sponsor?
        if (countSelection(REQUEST_POST('id')) > 0) {
                // At least one entry selected
@@ -61,7 +61,7 @@ if (IS_FORM_SENT()) {
                        $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($content['id']), __FILE__, __LINE__);
+                       array($content['id']), __FILE__, __LINE__);
 
                        if (SQL_NUMROWS($result_main) == 1) {
                                // Load data
@@ -75,7 +75,7 @@ LEFT JOIN `{!_MYSQL_PREFIX!}_sponsor_paytypes` AS sp
 ON sp.id=so.payid
 WHERE so.sponsorid='%s'
 ORDER BY sp.pay_name",
-                                       array($content['id']), __FILE__, __LINE__);
+                               array($content['id']), __FILE__, __LINE__);
                                if (SQL_NUMROWS($result) > 0) {
                                        // Payment does exist
                                        while ($content2 = SQL_FETCHARRAY($result)) {
@@ -93,10 +93,10 @@ ORDER BY sp.pay_name",
                                                $data = array(
                                                        'aid'   => $content['email'],
                                                        'order' => ($content['pay_count'] * $content['pay_rate'])." ".$content['pay_currency'],
-                                                       'stamp' => generateDateTime($content['pay_ordered'], "2"),
+                                                       'stamp' => generateDateTime($content['pay_ordered'], '2'),
                                                        'pname' => $content['pay_name'],
                                                );
-       
+
                                                // Load email template
                                                $content['msg'] = LOAD_EMAIL_TEMPLATE("sponsor_unlock_sponsor_pay", $data, $content['id']);
                                        }
@@ -115,7 +115,7 @@ ORDER BY sp.pay_name",
                        // Unlock sponsor account
                        SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET `status`='CONFIRMED'
 WHERE `id`='%s' AND `status`='PENDING' LIMIT 1",
-                               array($content['id']), __FILE__, __LINE__);
+                       array($content['id']), __FILE__, __LINE__);
 
                        // Update, if applyable, referal count and points
                        if (($content['refid'] > 0) && ($content['refid'] != $content['id'])) {
@@ -123,7 +123,7 @@ WHERE `id`='%s' AND `status`='PENDING' LIMIT 1",
                                SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data`
 SET points_amount=points_amount+%s, ref_count=ref_count+1
 WHERE `id`='%s' LIMIT 1",
-                                       array(getConfig('sponsor_ref_points'), bigintval($content['refid'])), __FILE__, __LINE__);
+                               array(getConfig('sponsor_ref_points'), bigintval($content['refid'])), __FILE__, __LINE__);
 
                                // Whas that update fine?
                                if (SQL_AFFECTEDROWS() == 1) {
@@ -132,7 +132,7 @@ WHERE `id`='%s' LIMIT 1",
 (points_amount - points_used) AS points, receive_warnings, ref_count AS refs
 FROM `{!_MYSQL_PREFIX!}_sponsor_data`
 WHERE `id`='%s' LIMIT 1",
-                                               array(bigintval($content['refid'])), __FILE__, __LINE__);
+                                       array(bigintval($content['refid'])), __FILE__, __LINE__);
                                        $REFERRAL = SQL_FETCHARRAY($result);
 
                                        // Send warnings out?
@@ -158,8 +158,8 @@ WHERE `id`='%s' LIMIT 1",
                        $content['points']   = translateComma($content['points_amount']);
 
                        // So let's send the email away
-                       $msg = LOAD_EMAIL_TEMPLATE("sponsor_unlocked", $content);
-                       sendEmail($content['email'], getMessage('SPONSOR_UNLOCKED_SUBJ'), $msg);
+                       $message = LOAD_EMAIL_TEMPLATE('sponsor_unlocked', $content);
+                       sendEmail($content['email'], getMessage('SPONSOR_UNLOCKED_SUBJ'), $message);
                }
        } else {
                // Nothing selected
@@ -167,12 +167,12 @@ WHERE `id`='%s' LIMIT 1",
        }
 
        // Add seperator
-       OUTPUT_HTML("<br />");
+       OUTPUT_HTML('<br />');
 }
 
 // Begin listing of all pending sponsor accounts
 $result = SQL_QUERY("SELECT
-       id, gender, surname, family, email, remote_addr, sponsor_created
+       `id`, `gender`, `surname`, `family`, `email`, `remote_addr`, `sponsor_created`
 FROM
        `{!_MYSQL_PREFIX!}_sponsor_data`
 WHERE
@@ -192,19 +192,19 @@ if (SQL_NUMROWS($result) > 0) {
                        'gender'   => translateGender($content['gender']),
                        'surname' => $content['surname'],
                        'family'  => $content['family'],
-                       'email'   => "mailto:".$content['email'],
+                       'email'   => generateEmailLink($content['email'], 'sponsor_data'),
                        'remote'  => $content['remote_addr'],
-                       'created' => generateDateTime($content['sponsor_created'], "2"),
+                       'created' => generateDateTime($content['sponsor_created'], '2'),
                );
 
                // Load row template and switch colors
-               $OUT .= LOAD_TEMPLATE("admin_unlock_sponsor_row", true, $content);
+               $OUT .= LOAD_TEMPLATE('admin_unlock_sponsor_row', true, $content);
                $SW = 3 - $SW;
        }
        define('__SPONSOR_ROWS', $OUT);
 
        // Load template
-       LOAD_TEMPLATE("admin_unlock_sponsor");
+       LOAD_TEMPLATE('admin_unlock_sponsor');
 } else {
        // No pending accounts found
        LOAD_TEMPLATE('admin_settings_saved', false, getMessage('ADMIN_SPONSOR_NONE_PENDING'));