More fixes/rewrites for rallye
authorRoland Häder <roland@mxchange.org>
Thu, 5 Nov 2009 16:23:00 +0000 (16:23 +0000)
committerRoland Häder <roland@mxchange.org>
Thu, 5 Nov 2009 16:23:00 +0000 (16:23 +0000)
inc/libs/rallye_functions.php

index 22ddd6c..fa219af 100644 (file)
@@ -43,10 +43,6 @@ if (!defined('__SECURITY')) {
 
 // Auto-start referal rallyes
 function autostartReferalRallyes ($result) {
-       // Global data array for loadEmailTemplate()
-       global $DATA;
-       $DATA = array();
-
        // Load all rallyes (usally we have only one rallye active per time!
        list($id, $title, $start, $end, $notify, $min_users, $min_prices) = SQL_FETCHROW($result);
 
@@ -57,26 +53,26 @@ function autostartReferalRallyes ($result) {
        SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `notified`='Y' WHERE `id`=%s LIMIT 1",
                array(bigintval($id)), __FUNCTION__, __LINE__);
 
-       // Transfer all neccessary data to the $DATA array
-       $DATA['userid_cnt'] = countSumTotalData('CONFIRMED','user_data','userid','status',true);
-       $DATA['start']      = generateDateTime($start, 2);
-       $DATA['end']        = generateDateTime($end  , 2);
-       $DATA['now_t']      = generateDateTime(time(), 2);
-       $DATA['title']      = $title;
-       $DATA['id']         = $id;  // id for the rallye details link
+       // Transfer all neccessary data to the $content array
+       $content['userid_cnt'] = countSumTotalData('CONFIRMED','user_data','userid','status',true);
+       $content['start']      = generateDateTime($start, 2);
+       $content['end']        = generateDateTime($end  , 2);
+       $content['now_t']      = generateDateTime(time(), 2);
+       $content['title']      = $title;
+       $content['id']         = $id;  // id for the rallye details link
 
        // Determine min_users and min_prices
-       $DATA['min_users']  = determineReferalRallyeMinimumUsers($min_users);
-       $DATA['min_prices'] = determineReferalRallyeMinimumPrices($min_prices);
+       $content['min_users']  = determineReferalRallyeMinimumUsers($min_users);
+       $content['min_prices'] = determineReferalRallyeMinimumPrices($min_prices);
 
        // Load prices
-       $prices = addReferalRallyePrices($id);
+       $content['prices'] = addReferalRallyePrices($id);
 
        // Query all users
        $result_user = SQL_QUERY("SELECT `userid` FROM `{?_MYSQL_PREFIX?}_user_data` WHERE `status`='CONFIRMED' ORDER BY `userid` ASC", __FUNCTION__, __LINE__);
 
        // Let's begin with the userids...
-       while ($content = SQL_FETCHARRAY($result_user)) {
+       while ($content = merge_array($content, SQL_FETCHARRAY($result_user))) {
                $un = false;
 
                // Get refs by userid
@@ -117,19 +113,24 @@ WHERE
                        if (empty($cpoints)) $cpoints = '0.00000';
 
                        // Add info line
-                       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_rallye_users` (rallye_id, userid, refs, curr_points)
-VALUES ('%s','%s','%s','%s')",
-                       array(bigintval($id), bigintval($content['userid']), bigintval($cnt), $cpoints), __FUNCTION__, __LINE__);
+                       SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_rallye_users` (`rallye_id`, `userid`, `refs`, `curr_points`)
+VALUES (%s, %s, %s, %s)",
+                               array(
+                                       bigintval($id),
+                                       bigintval($content['userid']),
+                                       bigintval($cnt),
+                                       $cpoints
+                               ), __FUNCTION__, __LINE__);
                        $un = true;
                } // END - if
 
                // Ignored but for the template required refs (made before start of rallye)
-               $DATA['refs']  = $cnt;
+               $content['refs']  = $cnt;
 
                // Shall I notify this member?
                if (($notify == 'Y') && ($un)) {
                        // Load email template and send it to the user
-                       $message = loadEmailTemplate('member_rallye_notify', array('prices' => $prices), $content['userid']);
+                       $message = loadEmailTemplate('member_rallye_notify', $content, $content['userid']);
                        sendEmail($content['userid'], sprintf(getMessage('RALLYE_MEMBER_NOTIFY'), $title), $message);
                } // END - if
        } // END - while
@@ -201,11 +202,17 @@ function addReferalRallyeTopUsers ($rallye, $default=0) {
 
        // And load only limited users
        $result = SQL_QUERY_ESC("SELECT
-       u.userid, u.refs, u.curr_points FROM `{?_MYSQL_PREFIX?}_rallye_users` AS u
+       u.userid, u.refs, u.curr_points, rd.min_users, rd.min_prices
+FROM
+       `{?_MYSQL_PREFIX?}_rallye_users` AS u
 LEFT JOIN
        `{?_MYSQL_PREFIX?}_refsystem` AS r
 ON
        u.userid=r.userid
+LEFT JOIN
+       `{?_MYSQL_PREFIX?}_rallye_data` AS rd
+ON
+       u.rallye_id=rd.id
 WHERE
        u.rallye_id=%s AND r.counter > 0
 ORDER BY
@@ -214,7 +221,7 @@ ORDER BY
 
        // Load users
        $DATA = array(
-               'userid'      => array(),
+               'userid'   => array(),
                'ref'      => array(),
                'cpoints'  => array()
        );
@@ -250,16 +257,18 @@ LIMIT 1",
                if (empty($refpoints)) $refpoints = '0';
 
                // Init userid for list
-               $_userid = '---';
+               $userid = '---';
 
                // List only users with at least one ref!
                //* DEBUG: */ print("*".$cnt.'/'.$content['userid'].'/'.$content['curr_points'].'/'.$refpoints."*<br />");
-               if (($cnt > 0) && ($refpoints > $content['curr_points'])) { $_userid = $content['userid']; } else { $cnt = ''; }
+               if (($cnt > 0) && ($refpoints > $content['curr_points'])) { $userid = $content['userid']; } else { $cnt = ''; }
 
                // Save values to array
-               $DATA['userid'][]     = $_userid;
-               $DATA['ref'][]     = $cnt;
-               $DATA['cpoints'][] = $content['curr_points'];
+               $DATA['userid'][]   = $userid;
+               $DATA['ref'][]      = $cnt;
+               $DATA['cpoints'][]  = $content['curr_points'];
+               $DATA['min_users']  = $content['min_users'];
+               $DATA['min_prices'] = $content['min_prices'];
        } // END - while
 
        // Free memory
@@ -291,6 +300,10 @@ LIMIT 1",
                $SW = 3 - $SW;
        } // END - for
 
+       // Translate min_prices/users
+       $DATA['min_prices'] = determineReferalRallyeMinimumPrices($content['min_prices']);
+       $DATA['min_users']  = determineReferalRallyeMinimumUsers($content['min_users']);
+
        // Add footer
        $OUT .= loadTemplate('guest_rallye_footer', true);
 
@@ -431,7 +444,7 @@ LIMIT 1",
 
        // Expire rallye
        SQL_QUERY_ESC("UPDATE `{?_MYSQL_PREFIX?}_rallye_data` SET `expired`='Y' WHERE `id`=%s LIMIT 1",
-       array(bigintval($id)), __FUNCTION__, __LINE__);
+               array(bigintval($id)), __FUNCTION__, __LINE__);
 
        // Run array through (by userid is the most important 2nd-level-array)
        foreach($prices['userid'] as $key => $userid) {
@@ -490,9 +503,9 @@ LIMIT 1",
 
        // Select template depending on notfication is switch on / off
        if ($notify == 'Y') {
-               $templ = "admin_rallye_expired";
+               $templ = 'admin_rallye_expired';
        } elseif (is_array($users['userid'])) {
-               $templ = "admin_rallye_expired_no";
+               $templ = 'admin_rallye_expired_no';
                $cnt = getReferalRallyeUserDataFromArray($users);
        }