Email support added to refback extension

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

diff --git a/inc/libs/refback_functions.php b/inc/libs/refback_functions.php
index 1009819e4f4f326662dc5f73ac4fcfacf31fd863..6e5c9112ba2130e48541d207817a57214236657a 100644 (file)
--- a/inc/libs/refback_functions.php
+++ b/inc/libs/refback_functions.php
@@ -307,7 +307,7 @@ function GET_USER_REF_ENTRY ($id) {
        $id = bigintval($id);
 
        // Get entry from database
-       $result = SQL_QUERY_ESC("SELECT id, refid, refback FROM "._MYSQL_PREFIX."_user_refs WHERE id=%s AND userid=%s LIMIT 1",
+       $result = SQL_QUERY_ESC("SELECT id, refid, refback, level FROM "._MYSQL_PREFIX."_user_refs WHERE id=%s AND userid=%s LIMIT 1",
                array($id, $GLOBALS['userid']), __FILE__, __LINE__);
 
        // Is there an entry?
@@ -336,11 +336,11 @@ function REFBACK_CHANGE_MEMBER_PERCENTS ($id, $percents) {
                return $status;
        } elseif ("".$id."" != "".bigintval($id)."") {
                // No number!
-               $status['message'] = MEMBER_REFBACK_INVALID_ID_NUMBER;
+               $status['message'] = MEMBER_REFBACK_ERROR_INVALID_ID_NUMBER;
                return $status;
        } elseif (($percents < 0) || ($percents > 100)) {
                // Percentage is not valid!
-               $status['message'] = MEMBER_REFBACK_INVALID_PERCENTAGE;
+               $status['message'] = MEMBER_REFBACK_ERROR_INVALID_PERCENTAGE;
                return $status;
        }
 
@@ -350,7 +350,7 @@ function REFBACK_CHANGE_MEMBER_PERCENTS ($id, $percents) {
        // Is this valid?
        if (count($dummy) == 0) {
                // ID does not belong to user!
-               $status['message'] = MEMBER_REFBACK_ID_MISMATCH;
+               $status['message'] = MEMBER_REFBACK_ERROR_ID_MISMATCH;
                return $status;
        } // END - if
 
@@ -364,10 +364,26 @@ function REFBACK_CHANGE_MEMBER_PERCENTS ($id, $percents) {
        // Entry updated?
        if (SQL_AFFECTEDROWS() < 1) {
                // Entry not updated!
-               $status['message'] = MEMBER_REFBACK_NOT_UPDATED;;
+               $status['message'] = MEMBER_REFBACK_ERROR_NOT_UPDATED;;
                return $status;
        } // END - if
 
+       // Prepare email content
+       $content = array(
+               'percents' => TRANSLATE_COMMA($percents),
+               'refid'    => $dummy['refid'],
+               'level'    => $dummy['level']
+       );
+
+       // Load member email template
+       $mail = LOAD_EMAIL_TEMPLATE("member_refback", $content, $GLOBALS['userid']);
+
+       // Send email to user
+       SEND_EMAIL($dummy['refid'], MEMBER_REFBACK_SUBJECT, $mail);
+
+       // Send admin notification
+       SEND_ADMIN_NOTIFICATION(ADMIN_REFBACK_SUBJECT, "admin_refback", $content, $GLOBALS['userid']);
+
        // All fine!
        $status['ok'] = true;