- $result_main = SQL_QUERY_ESC("SELECT salut, surname, family, email, remote_addr, sponsor_created, points_amount, refid
-FROM "._MYSQL_PREFIX."_sponsor_data
-WHERE status='PENDING' AND id='%s' LIMIT 1",
- array(bigintval($id)), __FILE__, __LINE__);
- $refid = 0;
- if (SQL_NUMROWS($result_main) == 1)
- {
- // Load data and free memory
- list($salut, $sname, $fname, $email, $ip, $created, $points, $refid) = SQL_FETCHROW($result_main);
+ $result_main = SQL_QUERY_ESC("SELECT gender, surname, family, email, remote_addr, sponsor_created, points_amount, refid
+FROM `{!_MYSQL_PREFIX!}_sponsor_data`
+WHERE `status`='PENDING' AND id='%s' LIMIT 1",
+ array($content['id']), __FILE__, __LINE__);
+
+ if (SQL_NUMROWS($result_main) == 1) {
+ // Load data
+ $content = SQL_FETCHARRAY($result_main);