X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Frallye_functions.php;h=201b11db96ccf777313e6744022fc79cceabe1e5;hp=fa219af1ddf03cc49cf037efaff26383406507a1;hb=263a089d8a499e0e26d0af9e7aa7639f88b8ca60;hpb=79cab07c8937729e73bfacd4977bd5a203a7d950

diff --git a/inc/libs/rallye_functions.php b/inc/libs/rallye_functions.php
index fa219af1dd..201b11db96 100644
--- a/inc/libs/rallye_functions.php
+++ b/inc/libs/rallye_functions.php
@@ -1,7 +1,7 @@
 <?php
 /************************************************************************
- * MXChange v0.2.1                                    Start: 08/22/2004 *
- * ===============                              Last change: 08/24/2004 *
+ * Mailer v0.2.1-FINAL                                Start: 08/22/2004 *
+ * ===================                          Last change: 08/24/2004 *
  *                                                                      *
  * -------------------------------------------------------------------- *
  * File              : rallye_functions.php                             *
@@ -80,7 +80,7 @@ function autostartReferalRallyes ($result) {
 		if (empty($cnt)) $cnt = '0'; // Added prevent some unknown troubles... :-?
 
 		// Check if line is already included...
-		$result_ref = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE rallye_id=%s AND `userid`=%s LIMIT 1",
+		$result_ref = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s AND `userid`=%s LIMIT 1",
 			array(bigintval($id), bigintval($content['userid'])), __FUNCTION__, __LINE__);
 		if (SQL_NUMROWS($result_ref) == '0') {
 			// Free memory
@@ -195,7 +195,7 @@ ORDER BY
 //
 function addReferalRallyeTopUsers ($rallye, $default=0) {
 	// First check how many prices are set
-	$result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE rallye_id=%s ORDER BY price_level",
+	$result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s ORDER BY price_level",
 		array(bigintval($rallye)), __FUNCTION__, __LINE__);
 	$prices = SQL_NUMROWS($result);
 	SQL_FREERESULT($result);
@@ -214,7 +214,7 @@ LEFT JOIN
 ON
 	u.rallye_id=rd.id
 WHERE
-	u.rallye_id=%s AND r.counter > 0
+	u.`rallye_id`=%s AND r.counter > 0
 ORDER BY
 	u.refs DESC",
 		array(bigintval($rallye)), __FUNCTION__, __LINE__);
@@ -244,9 +244,9 @@ WHERE
 	d.`status`='CONFIRMED' AND
 	p.ref_depth=1 AND
 	d.max_mails > 0 AND
-	d.mails_confirmed >= %s
+	d.mails_confirmed >= {?ref_payout?}
 LIMIT 1",
-			array(bigintval($content['userid']), getConfig('ref_payout')), __FUNCTION__, __LINE__);
+			array(bigintval($content['userid'])), __FUNCTION__, __LINE__);
 
 		// Get points
 		list($refpoints) = SQL_FETCHROW($result_ref);
@@ -267,8 +267,8 @@ LIMIT 1",
 		$DATA['userid'][]   = $userid;
 		$DATA['ref'][]      = $cnt;
 		$DATA['cpoints'][]  = $content['curr_points'];
-		$DATA['min_users']  = $content['min_users'];
-		$DATA['min_prices'] = $content['min_prices'];
+		$min_users  = $content['min_users'];
+		$min_prices = $content['min_prices'];
 	} // END - while
 
 	// Free memory
@@ -301,11 +301,11 @@ LIMIT 1",
 	} // END - for
 
 	// Translate min_prices/users
-	$DATA['min_prices'] = determineReferalRallyeMinimumPrices($content['min_prices']);
-	$DATA['min_users']  = determineReferalRallyeMinimumUsers($content['min_users']);
+	$content['min_prices'] = determineReferalRallyeMinimumPrices($min_prices);
+	$content['min_users']  = determineReferalRallyeMinimumUsers($min_users);
 
 	// Add footer
-	$OUT .= loadTemplate('guest_rallye_footer', true);
+	$OUT .= loadTemplate('guest_rallye_footer', true, $content);
 
 	// And finnally return the output
 	return $OUT;
@@ -552,7 +552,7 @@ function getArrayFromReferalRallyePrices ($rallye) {
 	);
 
 	// Load prices
-	$result = SQL_QUERY_ESC("SELECT price_level, points, info FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE rallye_id=%s ORDER BY price_level",
+	$result = SQL_QUERY_ESC("SELECT price_level, points, info FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s ORDER BY price_level",
 	array(bigintval($rallye)), __FUNCTION__, __LINE__);
 
 	// Transfer elements
@@ -738,9 +738,9 @@ WHERE end_time <= (UNIX_TIMESTAMP() - {?ONE_DAY?} - %s) AND expired='Y'",
 			// Purge whole rallye
 			addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_data` WHERE `id`=%s LIMIT 1",
 				array(bigintval($content['id'])), __FUNCTION__, __LINE__, false));
-			addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE rallye_id=%s LIMIT 1",
+			addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_prices` WHERE `rallye_id`=%s LIMIT 1",
 				array(bigintval($content['id'])), __FUNCTION__, __LINE__, false));
-			addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE rallye_id=%s LIMIT 1",
+			addSql(SQL_QUERY_ESC("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s LIMIT 1",
 				array(bigintval($content['id'])), __FUNCTION__, __LINE__, false));
 
 			// Add task