WHERE id='%s' AND status='PENDING' LIMIT 1",
array($id), __FILE__, __LINE__);
- // Update, if applyable, referral count and points
+ // Update, if applyable, referal count and points
if (($refid > 0) && ($refid != $id)) {
- // Update referral account
+ // Update referal account
$result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data
SET points_amount=points_amount+%s, ref_count=ref_count+1
WHERE id='%s' LIMIT 1",
// Whas that update fine?
if (SQL_AFFECTEDROWS() == 1) {
- // Load referral's data
+ // Load referal's data
$result = SQL_QUERY_ESC("SELECT id, gender, surname, family, email,
(points_amount - points_used) AS points, receive_warnings, ref_count AS refs
FROM "._MYSQL_PREFIX."_sponsor_data
$REFERRAL['ref_points'] = TRANSLATE_COMMA($_CONFIG['sponsor_ref_points']);
$REFERRAL['gender'] = TRANSLATE_GENDER($REFERRAL['gender']);
- // Send notification to referral
+ // Send notification to referal
$REF_MSG = LOAD_EMAIL_TEMPLATE("sponsor_ref_notify", $REFERRAL);
SEND_EMAIL($REFERRAL['email'], SPONSOR_REF_NOTIFY_SUBJ, $REF_MSG);
}