<?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 *
* svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team *
* For more information visit: http://www.mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
} // 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 >= ({?doubler_min?} * 2) AND
+ d.completed='N' AND
+ d.is_ref='N'
+ORDER BY
+ d.timemark ASC",
array(
- $DOUBLER_POINTS,
- getConfig(('doubler_min') * 2)
+ $DOUBLER_POINTS
), __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
-LIMIT %d",
+$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 >= ({?doubler_min?} * 2) AND
+ d.completed='N' AND
+ d.is_ref='N'
+ORDER BY
+ d.timemark ASC
+LIMIT {?doubler_max_sent?}",
array(
- $DOUBLER_POINTS,
- getConfig(('doubler_min') * 2),
- getConfig('doubler_max_sent')
+ $DOUBLER_POINTS
), __FILE__, __LINE__);
// Do we have entries found?