Better text here

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

diff --git a/inc/libs/rallye_functions.php b/inc/libs/rallye_functions.php
index 8be338a0662694a510e26e160d426beed789ba3c..faf162d6002a6e56648f2782dd70d44c0edcdb6d 100644 (file)
--- a/inc/libs/rallye_functions.php
+++ b/inc/libs/rallye_functions.php
@@ -135,7 +135,7 @@ WHERE
                        // Add info line
                        SQL_QUERY_ESC("INSERT INTO
        `{?_MYSQL_PREFIX?}_rallye_users`
-(`rallye_id`, `userid`, `refs`, `curr_points`)
+(`rallye_id`,`userid`,`refs`,`curr_points`)
        VALUES
 (%s, %s, %s, %s)",
                                array(
@@ -182,7 +182,7 @@ function addReferalRallyePrices ($rallye, $mode = 'email') {
 
        // Load prices
        $result_prices = SQL_QUERY_ESC("SELECT
-       `price_level`, `points`, `info`
+       `price_level`,`points`,`info`
 FROM
        `{?_MYSQL_PREFIX?}_rallye_prices`
 WHERE
@@ -351,12 +351,12 @@ function addUserToReferalRallye ($userid, $content = array()) {
 
        // Updated extension?
        if (isExtensionInstalledAndNewer('rallye', '0.2.0')) {
-               $add .= ', `min_users`, `min_prices`';
+               $add .= ', `min_users`,`min_prices`';
        } // END - if
 
        // Check for an auto-add rallye
        $result = SQL_QUERY("SELECT
-       `id`, `title`, `start_time`, `end_time`, `send_notify`".$add."
+       `id`,`title`,`start_time`,`end_time`,`send_notify`".$add."
 FROM
        `{?_MYSQL_PREFIX?}_rallye_data`
 WHERE
@@ -420,7 +420,7 @@ LIMIT 1",
                        // Add userid and his ref count to table
                        SQL_QUERY_ESC("INSERT INTO
        `{?_MYSQL_PREFIX?}_rallye_users`
-(`rallye_id`, `userid`, `refs`)
+(`rallye_id`,`userid`,`refs`)
        VALUES
 (%s,%s,0)",
                                array(
@@ -510,6 +510,7 @@ function markReferalRallyesAsExpired ($result) {
 
                        if ($DATA['points'] > 0) {
                                // Add points directly to user's account
+                               initReferalSystem();
                                addPointsThroughReferalSystem('rallye_winner:' . $winnerLevel, $userid, $DATA['points']);
                        } // END - if
 
@@ -563,7 +564,7 @@ function getReferalRallyeUserDataFromArray ($userIds) {
 
        // Load users
        $result = SQL_QUERY_ESC("SELECT
-       `userid`, `gender`, `surname`, `family`, `email`
+       `userid`,`gender`,`surname`,`family`,`email`
 FROM
        `{?_MYSQL_PREFIX?}_user_data`
 WHERE
@@ -602,7 +603,7 @@ function getArrayFromReferalRallyePrices ($rallye) {
 
        // Load prices
        $result = SQL_QUERY_ESC("SELECT
-       `price_level`, `points`, `info`
+       `price_level`,`points`,`info`
 FROM
        `{?_MYSQL_PREFIX?}_rallye_prices`
 WHERE
@@ -638,7 +639,7 @@ function getArrayFromReferalRallyeUsers ($rallye) {
        );
 
        // Load users                          userid    old   points earned
-       $result_user = SQL_QUERY_ESC("SELECT `userid`, `refs`, `curr_points` FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s ORDER BY `userid` ASC",
+       $result_user = SQL_QUERY_ESC("SELECT `userid`,`refs`,`curr_points` FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s ORDER BY `userid` ASC",
                array(bigintval($rallye)), __FUNCTION__, __LINE__);
        while ($content = SQL_FETCHARRAY($result_user)) {
                // Load current ref count
@@ -768,7 +769,7 @@ function purgeExpiredReferalRallyes () {
        // Check for expired rallyes
        $EXPIRE = 3; // @TODO The hard-coded value...
        $result_rallye = SQL_QUERY_ESC("SELECT
-       `id`, `title`, `start_time`, `end_time`
+       `id`,`title`,`start_time`,`end_time`
 FROM
        `{?_MYSQL_PREFIX?}_rallye_data`
 WHERE