X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Frallye_functions.php;h=c301b593e0761d68cf37d554d1f9362675dfe158;hp=b3fb7f1fa6d37a6dc6ab579a5efa9c32060b31dc;hb=56931cd9321119dd37372bd16d6c552857e40066;hpb=330dbb3e2b34450cd1665497506455e195a0a166

diff --git a/inc/libs/rallye_functions.php b/inc/libs/rallye_functions.php
index b3fb7f1fa6..c301b593e0 100644
--- a/inc/libs/rallye_functions.php
+++ b/inc/libs/rallye_functions.php
@@ -117,11 +117,11 @@ ON
 	p.userid=d.userid
 WHERE
 	d.`status`='CONFIRMED' AND
-	d.max_mails > 0 AND
-	d.mails_confirmed >= {?ref_payout?} AND
-	p.ref_depth=1 AND
-	p.points > 0 AND
-	d.userid=%s",
+	d.`max_mails` > 0 AND
+	d.`mails_confirmed` >= {?ref_payout?} AND
+	p.`ref_depth`=1 AND
+	p.`points` > 0 AND
+	d.`userid`=%s",
 				array(bigintval($content['userid'])), __FUNCTION__, __LINE__);
 
 			// Get points
@@ -498,18 +498,18 @@ function markReferalRallyesAsExpired ($result) {
 			// Determine winner level
 			if ($DATA['level'] == 1) {
 				// The winner!
-				$winnerLevel = '_gold';
+				$winnerLevel = 'gold';
 			} elseif ($DATA['level'] == 2) {
 				// The vice winner!
-				$winnerLevel = '_silver';
+				$winnerLevel = 'silver';
 			} elseif ($DATA['level'] == 3) {
 				// The bronce winner
-				$winnerLevel = '_bronce';
+				$winnerLevel = 'bronce';
 			}
 
 			if ($DATA['points'] > 0) {
 				// Add points directly to user's account
-				addPointsDirectly('rallye_winner' . $winnerLevel, $userid, $DATA['points']);
+				addPointsThroughReferalSystem('rallye_winner:' . $winnerLevel, $userid, $DATA['points']);
 			} // END - if
 
 			if ($notify == 'Y') {