]> git.mxchange.org Git - mailer.git/blobdiff - inc/libs/rallye_functions.php
Referal system refactured (and some parts fixed), wrapper function introduced:
[mailer.git] / inc / libs / rallye_functions.php
index b3fb7f1fa6d37a6dc6ab579a5efa9c32060b31dc..c301b593e0761d68cf37d554d1f9362675dfe158 100644 (file)
@@ -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') {