- $result = SQL_QUERY_ESC("UPDATE "._MYSQL_PREFIX."_sponsor_data SET status='CONFIRMED'
-WHERE id='%s' AND status='PENDING' LIMIT 1",
- array($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__);
+ 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`+{?sponsor_ref_points?}, `ref_count`=`ref_count`+1
+WHERE
+ `id`='%s'
+LIMIT 1",
+ array(bigintval($content['refid'])), __FILE__, __LINE__);