projects / mailer.git / blobdiff
? search:
summary | shortlog | log | commit | commitdiff | tree
raw | inline | side by side
Some code moved
[mailer.git] / inc / libs / rallye_functions.php
diff --git a/inc/libs/rallye_functions.php b/inc/libs/rallye_functions.php
index a390b61829d3248efbc243abcdaf4365f96f8c87..22ddd6cb3d03af37173fbb65bfd981b95dfad69c 100644 (file)
--- a/inc/libs/rallye_functions.php
+++ b/inc/libs/rallye_functions.php
@@ -59,11 +59,11 @@ function autostartReferalRallyes ($result) {
 
        // 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['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
+       $DATA['id']         = $id;  // id for the rallye details link
 
        // Determine min_users and min_prices
        $DATA['min_users']  = determineReferalRallyeMinimumUsers($min_users);
@@ -81,12 +81,12 @@ function autostartReferalRallyes ($result) {
 
                // Get refs by userid
                $cnt = getReferalRallyeRefsCount($content['userid']);
-               if (empty($cnt)) $cnt = 0; // Added prevent some unknown troubles... :-?
+               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",
                        array(bigintval($id), bigintval($content['userid'])), __FUNCTION__, __LINE__);
-               if (SQL_NUMROWS($result_ref) == 0) {
+               if (SQL_NUMROWS($result_ref) == '0') {
                        // Free memory
                        SQL_FREERESULT($result_ref);
 
@@ -139,7 +139,7 @@ VALUES ('%s','%s','%s','%s')",
        if ($notify == 'Y') $templ = 'admin_rallye_notify';
 
        // Send email to admin
-       sendAdminNotification(sprintf(getMessage('RALLYE_ADMIN_NOTIFY'), $title), $templ, $prices, '0');
+       sendAdminNotification(sprintf(getMessage('RALLYE_ADMIN_NOTIFY'), $title), $templ, $prices, 0);
 
        // Free memory
        SQL_FREERESULT($result_user);
@@ -247,13 +247,13 @@ LIMIT 1",
                // Free result
                SQL_FREERESULT($result_ref);
 
-               if (empty($refpoints)) $refpoints = 0;
+               if (empty($refpoints)) $refpoints = '0';
 
                // Init userid for list
                $_userid = '---';
 
                // List only users with at least one ref!
-               //* DEBUG: */ outputHtml("*".$cnt.'/'.$content['userid'].'/'.$content['curr_points'].'/'.$refpoints."*<br />");
+               //* DEBUG: */ print("*".$cnt.'/'.$content['userid'].'/'.$content['curr_points'].'/'.$refpoints."*<br />");
                if (($cnt > 0) && ($refpoints > $content['curr_points'])) { $_userid = $content['userid']; } else { $cnt = ''; }
 
                // Save values to array
@@ -271,7 +271,7 @@ LIMIT 1",
        // Generate table
        $OUT = loadTemplate('guest_rallye_header', true);
        $SW = 2;
-       for ($idx = 0; $idx < $prices; $idx++) {
+       for ($idx = '0'; $idx < $prices; $idx++) {
                if (empty($DATA['userid'][$idx])) $DATA['userid'][$idx] = '---';
                if (empty($DATA['ref'][$idx])) $DATA['ref'][$idx] = '---';
                // Add row
@@ -299,8 +299,7 @@ LIMIT 1",
 }
 
 // Run this function only when a new member has confirmed his email address!
-function addUserToReferalRallye ($userid) {
-       global $DATA;
+function addUserToReferalRallye ($userid, $content = array()) {
        $add = '';
 
        // Updated extension?
@@ -321,7 +320,8 @@ WHERE
 LIMIT 1", __FUNCTION__, __LINE__);
        if (SQL_NUMROWS($result) == 1) {
                // Init variables
-               $min_users = 0; $min_prices = 0;
+               $min_users = '0'; $min_prices = '0';
+
                // Load data
                if (getExtensionVersion('rallye') >= '0.2.0') {
                        list($id, $title, $start, $end, $notify, $min_users, $min_prices) = SQL_FETCHROW($result);
@@ -332,42 +332,48 @@ LIMIT 1", __FUNCTION__, __LINE__);
                // Free result
                SQL_FREERESULT($result);
 
+               if ($notify == 'Y') {
+                       // Transfer all neccessary data to the global $content array
+                       $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
+                       $content['ref']   = '0';
+                       $content['refs']  = countSumTotalData($userid, 'user_data', 'userid', 'refid', true);
+
+                       // Load prices
+                       $content['prices'] = addReferalRallyePrices($id);
+
+                       // Determine min_users/prices tring
+                       $content['min_users']  = determineReferalRallyeMinimumUsers($min_users);
+                       $content['min_prices'] = determineReferalRallyeMinimumPrices($min_prices);
+
+                       // Send notification to member
+                       $message = loadEmailTemplate('member_rallye_notify', $content, $userid);
+                       sendEmail($userid, sprintf(getMessage('RALLYE_MEMBER_NOTIFY'), $title), $message);
+               } // END - if
+
                // Check if line is already included...
                $result = SQL_QUERY_ESC("SELECT `id` FROM `{?_MYSQL_PREFIX?}_rallye_users` WHERE `rallye_id`=%s AND `userid`=%s LIMIT 1",
-                       array(bigintval($id), bigintval($userid)), __FUNCTION__, __LINE__);
+                       array(
+                               bigintval($id),
+                               bigintval($userid)
+                       ), __FUNCTION__, __LINE__);
 
                // Is this user added?
-               if (SQL_NUMROWS($result) == 0) {
+               if (SQL_NUMROWS($result) < 1) {
                        // Add userid and his ref count to table
                        SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_rallye_users` (`rallye_id`, `userid`, `refs`)
-VALUES ('%s','%s','0')",
-                       array(bigintval($id), bigintval($userid)), __FUNCTION__, __LINE__);
+VALUES ('%s','%s',0)",
+                               array(
+                                       bigintval($id),
+                                       bigintval($userid)
+                               ), __FUNCTION__, __LINE__);
                } // END - if
 
                // Free memory
                SQL_FREERESULT($result);
-
-               if ($notify == 'Y') {
-                       // Transfer all neccessary data to the global $DATA array
-                       $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
-                       $DATA['ref']   = 0;
-                       $DATA['refs']  = countSumTotalData($userid, 'user_data', 'userid', "refid", true);
-
-                       // Load prices
-                       $prices = addReferalRallyePrices($id);
-
-                       // Determine min_users/prices tring
-                       $DATA['min_users']  = determineReferalRallyeMinimumUsers($min_users);
-                       $DATA['min_prices'] = determineReferalRallyeMinimumPrices($min_prices);
-
-                       // Send notification to member
-                       $message = loadEmailTemplate('member_rallye_notify', array('prices' => $prices), $userid);
-                       sendEmail($userid, sprintf(getMessage('RALLYE_MEMBER_NOTIFY'), $title), $message);
-               } // END - if
        } // END - if
 }
 
@@ -385,19 +391,19 @@ function markReferalRallyesAsExpired ($result) {
        $prices = getArrayFromReferalRallyeUsers($id);
 
        // Init array
-       $DATA = array(); $cnt = 0;
+       $DATA = array(); $cnt = '0';
        $users = array();
        $DATA['title']  = $title;
-       $DATA['start']  = generateDateTime($start, '1');
-       $DATA['end']    = generateDateTime($end  , '1');
-       $DATA['now_t']  = generateDateTime(time(), '1');
+       $DATA['start']  = generateDateTime($start, 1);
+       $DATA['end']    = generateDateTime($end  , 1);
+       $DATA['now_t']  = generateDateTime(time(), 1);
 
        // Just count...
-       $total = 0;
+       $total = '0';
        foreach($prices['userid'] as $key => $userid) {
                // Check status
                //   active = 1: account is still confirmed
-               //   active = 0: account is deleted or locked
+               //   active = '0': account is deleted or locked
                $result = SQL_QUERY_ESC("SELECT
        COUNT(`userid`) AS active
 FROM
@@ -417,7 +423,7 @@ LIMIT 1",
                } // END - if
        } // END - foreach
 
-       if (($total < $min_prices) || ($total == 0)) {
+       if (($total < $min_prices) || ($total == '0')) {
                // Do not end this rallye!
                unset($DATA);
                return;
@@ -595,7 +601,7 @@ LIMIT 1",
                SQL_FREERESULT($result_ref);
 
                // Fix empty refpoints
-               if (empty($refpoints)) $refpoints = 0;
+               if (empty($refpoints)) $refpoints = '0';
 
                // Store calculated new refs to array
                $users['userid'][]     = $content['userid'];
@@ -642,14 +648,14 @@ function addReferalRallyeWinners ($rallye, $default=0) {
        // Generate table
        $OUT = loadTemplate('guest_rallye_expired_header', true);
        $SW = 2;
-       for ($idx = 0; $idx < $prices; $idx++) {
+       for ($idx = '0'; $idx < $prices; $idx++) {
                // Check status
                //   active = 1: account is still confirmed
-               //   active = 0: account is deleted or locked
+               //   active = '0': account is deleted or locked
                $active = countSumTotalData($DATA['userid'][$idx], 'user_data', 'userid', 'userid', true, " AND `status`='CONFIRMED'");
 
                if (empty($DATA['userid'][$idx])) $DATA['userid'][$idx] = '---';
-               if ((empty($DATA['ref'][$idx])) || ($DATA['ref'][$idx] == 0) || ($active == 0) || ("".round($DATA['cpoints'][$idx])."" == '0') || (empty($DATA['cpoints'][$idx]))) {
+               if ((empty($DATA['ref'][$idx])) || ($DATA['ref'][$idx] == '0') || ($active == '0') || ("".round($DATA['cpoints'][$idx])."" == '0') || (empty($DATA['cpoints'][$idx]))) {
                        // Allow valid and active users with at least one ref to get points
                        $DATA['ref'][$idx]   = '---';
                        $DATA['userid'][$idx]   = '---';
@@ -709,9 +715,9 @@ WHERE end_time <= (UNIX_TIMESTAMP() - {?ONE_DAY?} - %s) AND expired='Y'",
                // Expire found rallyes and notify admin
                while ($content = SQL_FETCHARRAY($result_rallye)) {
                        // Prepare data for mail template
-                       $content['start_time']  = generateDateTime($content['start_time'], '1');
-                       $content['end_time']    = generateDateTime($content['end_time']  , '1');
-                       $content['now_time']    = generateDateTime(time(), '1');
+                       $content['start_time']  = generateDateTime($content['start_time'], 1);
+                       $content['end_time']    = generateDateTime($content['end_time']  , 1);
+                       $content['now_time']    = generateDateTime(time(), 1);
 
                        // Send mail to admin
                        sendAdminNotification(sprintf(getMessage('RALLYE_ADMIN_PURGED_SUBJ'), $content['title']), 'admin_rallye_purged', $content, 0);
@@ -779,21 +785,21 @@ function addReferalRallyeTemplateSelection ($name = 'template', $default = '') {
 }
 
 //
-function getReferalRallyeRefsCount ($userid, $old = 0) {
+function getReferalRallyeRefsCount ($userid, $old = '0') {
        // Check current refs
        if (getExtensionVersion('cache') >= '0.1.2') {
                // Get refs from cache
-               $cnt = 0;
+               $cnt = '0';
                foreach ($GLOBALS['cache_array']['refsystem']['userid'] as $id => $userid) {
                        // Do we have a ref for this user?
-                       //* DEBUG: */ outputHtml("id={$id},userid={$userid},userid={$userid},old={$old},level={$GLOBALS['cache_array']['refsystem']['level'][$id]}<br />");
+                       //* DEBUG: */ print("id={$id},userid={$userid},userid={$userid},old={$old},level={$GLOBALS['cache_array']['refsystem']['level'][$id]}<br />");
                        if (($userid == $userid) && ($GLOBALS['cache_array']['refsystem']['level'][$id] == 1)) {
-                               //* DEBUG: */ outputHtml("userid matches!<br />");
+                               //* DEBUG: */ print("userid matches!<br />");
                                foreach ($GLOBALS['cache_array']['refdepths']['level'] as $level) {
                                        if (($level == $GLOBALS['cache_array']['refsystem']['level'][$id]) && ($level == 1)) {
                                                // Level does exist so abort here
                                                $cnt = $GLOBALS['cache_array']['refsystem']['counter'][$id];
-                                               //* DEBUG: */ outputHtml("*".$userid.'/'.$cnt."*<br />");
+                                               //* DEBUG: */ print("*".$userid.'/'.$cnt."*<br />");
                                                break;
                                        } elseif ($level > 1) {
                                                // Not interesting here...
@@ -806,9 +812,9 @@ function getReferalRallyeRefsCount ($userid, $old = 0) {
                        } // END - if
                } // END - foreach
 
-               //* DEBUG: */ outputHtml("<pre>");
-               //* DEBUG: */ outputHtml(print_r($GLOBALS['cache_array']['refsystem'], true));
-               //* DEBUG: */ outputHtml("</pre>");
+               //* DEBUG: */ print("<pre>");
+               //* DEBUG: */ print(print_r($GLOBALS['cache_array']['refsystem'], true));
+               //* DEBUG: */ print("</pre>");
                //* DEBUG: */ shutdown();
 
                if ($cnt > 0) {
@@ -816,7 +822,7 @@ function getReferalRallyeRefsCount ($userid, $old = 0) {
                        incrementStatsEntry('cache_hits');
 
                        // Remove old refs
-                       //* DEBUG: */ outputHtml('+'.$cnt.'/'.$old."+<br />");
+                       //* DEBUG: */ print('+'.$cnt.'/'.$old."+<br />");
                        $cnt -= $old;
                } // END - if
        } else {
@@ -829,14 +835,14 @@ WHERE s.userid=%s AND s.level=1", array(bigintval($userid)), __FUNCTION__, __LIN
                list($cnt) = SQL_FETCHROW($result_ref);
                SQL_FREERESULT($result_ref);
                if (empty($cnt)) {
-                       $cnt = 0;
+                       $cnt = '0';
                } else {
                        $cnt -= $old;
                }
        }
 
        // Return count
-       //* DEBUG: */ outputHtml("*".$userid.'/'.$old.'/'.$cnt."*<br />");
+       //* DEBUG: */ print("*".$userid.'/'.$old.'/'.$cnt."*<br />");
        return $cnt;
 }
 
Mailer-Project repository