- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='CONFIRMED'
-WHERE id='%s' AND status='PENDING' LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
-
- // Update, if applyable, referral count and points
- if (($refid > 0) && ($refid != $id))
- {
- // Update referral 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",
- array($CONFIG['sponsor_ref_points'], bigintval($refid)), __FILE__, __LINE__);
-
- // Load referral's data
- if (SQL_AFFECTED_ROWS($link) == 1)
- {
- $result = SQL_QUERY_ESC("SELECT id, salut, surname, family, email,
-(points_amount - points_used) AS points, receive_warnings, ref_count AS refs
-FROM "._MYSQL_PREFIX."_sponsor_data
-WHERE id='%s' LIMIT 1",
- array(bigintval($refid)), __FILE__, __LINE__);
- $REFERRAL = SQL_FETCHARRAY($result);
- if ($REFERRAL['receive_warnings'] == "Y")
- {
- // Translate some data
- $REFERRAL['points'] = TRANSLATE_COMMA($REFERRAL['points']);
- $REFERRAL['ref_points'] = TRANSLATE_COMMA($CONFIG['sponsor_ref_points']);
- $REFERRAL['salut'] = TRANSLATE_SEX($REFERRAL['salut']);
-
- // Send notification to referral
- $REF_MSG = LOAD_EMAIL_TEMPLATE("sponsor_ref_notify", $REFERRAL);
- SEND_EMAIL($REFERRAL['email'], SPONSOR_REF_NOTIFY_SUBJ, $REF_MSG);
- }
+ SQL_QUERY_ESC("UPDATE
+ `{?_MYSQL_PREFIX?}_sponsor_data`
+SET
+ `status`='CONFIRMED'
+WHERE
+ `id`=%s AND
+ `status` IN('PENDING','UNCONFIRMED')
+LIMIT 1",
+ array($content['id']), __FILE__, __LINE__);
+
+ // Update, if applyable, referal count and points
+ if ((isValidUserId($content['refid'])) && ($content['refid'] != $content['id'])) {
+ // Update referal account
+ SQL_QUERY_ESC("UPDATE
+ `{?_MYSQL_PREFIX?}_sponsor_data`
+SET
+ `points_amount`=`points_amount`+{?sponsor_ref_points?}, `ref_count`=`ref_count`+1
+WHERE
+ `id`=%s
+LIMIT 1",
+ array(bigintval($content['refid'])), __FILE__, __LINE__);
+
+ // Whas that update fine?
+ if (!SQL_HASZEROAFFECTED()) {
+ // 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`
+WHERE
+ `id`=%s
+LIMIT 1",
+ array(bigintval($content['refid'])), __FILE__, __LINE__);
+ $REFERAL = SQL_FETCHARRAY($result);
+
+ // Send warnings out?
+ if ($REFERAL['receive_warnings'] == 'Y') {
+ // Send notification to referal
+ $REFERAL_MSG = loadEmailTemplate('sponsor_ref_notify', $REFERAL);
+ sendEmail($REFERAL['email'], '{--SPONSOR_REFERAL_NOTIFY_SUBJECT--}', $REFERAL_MSG);
+ } // END - if