Missing variable fixed, array initialization moved

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

diff --git a/inc/libs/rallye_functions.php b/inc/libs/rallye_functions.php
index b2fb6807a3a5abb1683c7fcfed959f5c7de7cf7b..56230b9022fba02148d2d21f6bcd3c7a1981015b 100644 (file)
--- a/inc/libs/rallye_functions.php
+++ b/inc/libs/rallye_functions.php
@@ -108,7 +108,7 @@ LIMIT 1",
 
                        // Add userid and his ref count to table
                        $result_ref = SQL_QUERY_ESC("SELECT 
-       SUM(p.points) AS points
+       SUM(p.points) AS `points`
 FROM
        `{?_MYSQL_PREFIX?}_user_points` AS p
 LEFT JOIN
@@ -444,9 +444,6 @@ function markReferalRallyesAsExpired ($result) {
        // Free result
        SQL_FREERESULT($result);
 
-       // Load users array (!) with assigned prices
-       $prices = getArrayFromReferalRallyeUsers($id);
-
        // Init array
        $DATA = array();
        $count = '0';
@@ -456,6 +453,9 @@ function markReferalRallyesAsExpired ($result) {
        $DATA['end']    = generateDateTime($end  , 1);
        $DATA['now_t']  = generateDateTime(time(), 1);
 
+       // Load users array (!) with assigned prices
+       $prices = getArrayFromReferalRallyeUsers($id);
+
        // Just count...
        $total = '0';
        foreach ($prices['userid'] as $key => $userid) {
@@ -645,7 +645,7 @@ function getArrayFromReferalRallyeUsers ($rallye) {
 
                // Points of ref's
                $result_ref = SQL_QUERY_ESC("SELECT
-       SUM(p.points) AS points
+       SUM(p.points) AS `points`
 FROM
        `{?_MYSQL_PREFIX?}_user_points` AS p
 LEFT JOIN