- // Create doubling "account" width *DOUBLED* points
- SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_doubler` (`userid`, `refid`, `points`, `remote_ip`, `timemark`, `completed`, `is_ref`) VALUES ('%s','%s','%s','".detectRemoteAddr()."', UNIX_TIMESTAMP(), 'N','N')",
- array(getUserData('userid'), determineReferalId(), bigintval(postRequestElement('points') * 2)), __FILE__, __LINE__);
-
- // Subtract entered points
- subtractPoints('doubler', getUserData('userid'), postRequestElement('points'));
+ // Create doubling "account" with *DOUBLED* points
+ SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_doubler` (`userid`,`refid`,`points`,`remote_ip`,`timemark`,`completed`,`is_ref`) VALUES (%s,%s,%s,'%s', UNIX_TIMESTAMP(), 'N','N')",
+ array(
+ getUserData('userid'),
+ makeZeroToNull(determineReferalId()),
+ bigintval(postRequestParameter('points') * 2),
+ detectRemoteAddr()
+ ), __FILE__, __LINE__);
+
+ // Subtract entered points and ignore return status
+ subtractPoints('doubler', getUserData('userid'), postRequestParameter('points'));