X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doubler.php;h=5d4c3ce0924416621b04c9b03805f5e65a03ffa2;hb=d1cf572ce023d55e2dbb810d1d6f9301c3d4e3db;hp=72f7123cf19c1e1aa5db0a86d354f5eba20fd515;hpb=cd7d344ea7007cfa20413acd3e03e50f0ab86d86;p=mailer.git diff --git a/doubler.php b/doubler.php index 72f7123cf1..5d4c3ce092 100644 --- a/doubler.php +++ b/doubler.php @@ -99,7 +99,7 @@ if (isFormSent()) { if (($points - getConfig('doubler_left') - postRequestElement('points') * getDoublerCharge() / 100) >= 0) { // Enough points are left so let's continue with the doubling process // 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')", + sqlQueryEscaped("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'), convertZeroToNull(determineReferralId()), @@ -118,7 +118,7 @@ if (isFormSent()) { // Add second line for the referral but only when userid != refid if ((isValidId(determineReferralId())) && (determineReferralId() != getUserData('userid'))) { // Okay add a refid line and apply refid percents - SQL_QUERY_ESC("INSERT INTO `{?_MYSQL_PREFIX?}_doubler` (`userid`, `refid`, `points`, `remote_ip`, `timemark`, `completed`, `is_ref`) VALUES (%s,0,%s,'%s',UNIX_TIMESTAMP(),'N','Y')", + sqlQueryEscaped("INSERT INTO `{?_MYSQL_PREFIX?}_doubler` (`userid`, `refid`, `points`, `remote_ip`, `timemark`, `completed`, `is_ref`) VALUES (%s,0,%s,'%s',UNIX_TIMESTAMP(),'N','Y')", array( convertZeroToNull(determineReferralId()), (postRequestElement('points') * 2 * getDoublerRef() / 100),