$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?
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;
}
// 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
// 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;