fooRequestElementBar() functions renamed, adding of request parameters added:

[mailer.git] / inc / mails / doubler_mails.php

diff --git a/inc/mails/doubler_mails.php b/inc/mails/doubler_mails.php
index 6279fd213d9608a3dfe3fecff272aefb80264248..d068ffd4cbae7320b54752a1bec8b5330797514d 100644 (file)
--- a/inc/mails/doubler_mails.php
+++ b/inc/mails/doubler_mails.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 02/16/2005 *
- * ===============                              Last change: 01/21/2006 *
+ * Mailer v0.2.1-FINAL                                Start: 02/16/2005 *
+ * ===================                          Last change: 01/21/2006 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : doubler_mails.php                                 *
@@ -58,30 +58,50 @@ if ($DOUBLER_POINTS == '0') {
 } // END - if
 
 // If not currently doubled set it to zero
-unsetGetRequestElement('DOUBLER_UID');
-unsetPostRequestElement('DOUBLER_UID');
+unsetGetRequestParameter('DOUBLER_UID');
+unsetPostRequestParameter('DOUBLER_UID');
 setSession('DOUBLER_UID', '');
 if (empty($GLOBALS['doubler_userid'])) $GLOBALS['doubler_userid'] = '0';
 
 // Check for doubles which we can pay out
-$result_total = SQL_QUERY_ESC("SELECT d.id, d.userid, d.points, d.remote_ip, d.timemark
-FROM `{?_MYSQL_PREFIX?}_doubler` AS d
-LEFT JOIN `{?_MYSQL_PREFIX?}_user_data` AS u
-ON d.userid=u.userid
-WHERE u.`status`='CONFIRMED' AND d.points <= %s AND d.points >= %s AND d.completed='N' AND d.is_ref='N'
-ORDER BY d.timemark",
+$result_total = SQL_QUERY_ESC("SELECT
+       d.id, d.userid, d.points, d.remote_ip, d.timemark
+FROM
+       `{?_MYSQL_PREFIX?}_doubler` AS d
+LEFT JOIN
+       `{?_MYSQL_PREFIX?}_user_data` AS u
+ON
+       d.userid=u.userid
+WHERE
+       u.`status`='CONFIRMED' AND
+       d.points <= %s AND
+       d.points >= %s AND
+       d.completed='N' AND
+       d.is_ref='N'
+ORDER BY
+       d.timemark ASC",
        array(
                $DOUBLER_POINTS,
                getConfig(('doubler_min') * 2)
        ), __FILE__, __LINE__);
 
 // Check for accounts with limitation
-$result_main = SQL_QUERY_ESC("SELECT d.id, d.userid, d.points, d.remote_ip, d.timemark
-FROM `{?_MYSQL_PREFIX?}_doubler` AS d
-LEFT JOIN `{?_MYSQL_PREFIX?}_user_data` AS u
-ON d.userid=u.userid
-WHERE u.`status`='CONFIRMED' AND d.points <= %s AND d.points >= %s AND d.completed='N' AND d.is_ref='N'
-ORDER BY d.timemark
+$result_main = SQL_QUERY_ESC("SELECT
+       d.id, d.userid, d.points, d.remote_ip, d.timemark
+FROM
+       `{?_MYSQL_PREFIX?}_doubler` AS d
+LEFT JOIN
+       `{?_MYSQL_PREFIX?}_user_data` AS u
+ON
+       d.userid=u.userid
+WHERE
+       u.`status`='CONFIRMED' AND
+       d.points <= %s AND
+       d.points >= %s AND
+       d.completed='N' AND
+       d.is_ref='N'
+ORDER BY
+       d.timemark ASC
 LIMIT %d",
        array(
                $DOUBLER_POINTS,