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
// 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') {