- SQL_QUERY_ESC("UPDATE `{!_MYSQL_PREFIX!}_sponsor_data` SET `status`='CONFIRMED'
-WHERE id='%s' AND `status`='PENDING' LIMIT 1",
- array($content['id']), __FILE__, __LINE__);
-
- // Update, if applyable, referal count and points
- if (($content['refid'] > 0) && ($content['refid'] != $content['id'])) {
- // Update referal account
- 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(getConfig('sponsor_ref_points'), bigintval($content['refid'])), __FILE__, __LINE__);
+ 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, referral count and points
+ if ((isValidUserId($content['refid'])) && ($content['refid'] != $content['id'])) {
+ // Update referral 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__);