X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Frallye_functions.php;h=22ddd6cb3d03af37173fbb65bfd981b95dfad69c;hp=9b2827786f45b9d157db11409accd34eed24f213;hb=2d55583e262436e3c7baee24fcbe5c224a748770;hpb=4f2414a0134da82027fce8a6c98696a207c8c8cc diff --git a/inc/libs/rallye_functions.php b/inc/libs/rallye_functions.php index 9b2827786f..22ddd6cb3d 100644 --- a/inc/libs/rallye_functions.php +++ b/inc/libs/rallye_functions.php @@ -63,7 +63,7 @@ function autostartReferalRallyes ($result) { $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); @@ -247,7 +247,7 @@ LIMIT 1", // Free result SQL_FREERESULT($result_ref); - if (empty($refpoints)) $refpoints = 0; + if (empty($refpoints)) $refpoints = '0'; // Init userid for list $_userid = '---'; @@ -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__); + 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,7 +391,7 @@ 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); @@ -393,11 +399,11 @@ function markReferalRallyesAsExpired ($result) { $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; @@ -553,7 +559,7 @@ function getArrayFromReferalRallyePrices ($rallye) { // function getArrayFromReferalRallyeUsers ($rallye) { // Fix zero points to 0.00000 - if (getConfig('ref_payout') == 0) setConfigEntry('ref_payout', '0.00000'); + if (getConfig('ref_payout') == '0') setConfigEntry('ref_payout', '0.00000'); // Init multi array $users = array( @@ -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] = '---'; @@ -779,11 +785,11 @@ 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: */ print("id={$id},userid={$userid},userid={$userid},old={$old},level={$GLOBALS['cache_array']['refsystem']['level'][$id]}
"); @@ -829,7 +835,7 @@ 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; }