Mailer used in many places, we still need a good 'selling' title

[mailer.git] / inc / libs / rallye_functions.php

diff --git a/inc/libs/rallye_functions.php b/inc/libs/rallye_functions.php
index fa219af1ddf03cc49cf037efaff26383406507a1..201b11db96ccf777313e6744022fc79cceabe1e5 100644 (file)
--- 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