Fixes for refback mail

[mailer.git] / inc / libs / refback_functions.php

diff --git a/inc/libs/refback_functions.php b/inc/libs/refback_functions.php
index cdf60a9fff9c898be6c5c3543b4aef98d98db15d..733314735d1410972caf61fd594505388523db8a 100644 (file)
--- a/inc/libs/refback_functions.php
+++ b/inc/libs/refback_functions.php
@@ -328,7 +328,7 @@ function getArrayFromUserRefbackData ($id) {
        $id = bigintval($id);
 
        // Get entry from database
-       $result = SQL_QUERY_ESC("SELECT `id`, `refid`, `refback`, `level` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `id`=%s AND `userid`=%s LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT `id`, `userid`, `refid`, `refback`, `level`, `points` FROM `{?_MYSQL_PREFIX?}_user_refs` WHERE `id`=%s AND `userid`=%s LIMIT 1",
                array($id, getMemberId()), __FUNCTION__, __LINE__);
 
        // Is there an entry?
@@ -394,11 +394,12 @@ function updateMemberRefbackPercents ($id, $percents) {
        $content = array(
                'percents' => translateComma($percents),
                'refid'    => $dummy['refid'],
-               'level'    => $dummy['level']
+               'level'    => $dummy['level'],
+               'points'   => translateComma($dummy['points']),
        );
 
        // Load member email template
-       $mail = loadEmailTemplate('member_refback', $content, getMemberId());
+       $mail = loadEmailTemplate('member_refback', $content, $dummy['refid']);
 
        // Send email to user
        sendEmail($dummy['refid'], getMessage('MEMBER_REFBACK_SUBJECT'), $mail);