X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fmails%2Fdoubler_mails.php;h=69852389ddef0c34a27192fcf136c38966e6ddbd;hp=6279fd213d9608a3dfe3fecff272aefb80264248;hb=83574a6475896fbdc231e685e2ebb0ee4f3e6eba;hpb=b09d135d6a0078142a44b33a91d939d6569c8782

diff --git a/inc/mails/doubler_mails.php b/inc/mails/doubler_mails.php
index 6279fd213d..69852389dd 100644
--- a/inc/mails/doubler_mails.php
+++ b/inc/mails/doubler_mails.php
@@ -64,24 +64,44 @@ 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,