X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=doubler.php;h=a7f83cfeb2d256584fe926214ffca49c118a3765;hb=2f83b073cdd7fdeeed2032ce6fb25e0590c83746;hp=403009eb184a3b140e8a02000a1ec06889a40f2d;hpb=db0c6702086eea2c44d0aae1702dc2e77a0afc4e;p=mailer.git

diff --git a/doubler.php b/doubler.php
index 403009eb18..a7f83cfeb2 100644
--- a/doubler.php
+++ b/doubler.php
@@ -98,12 +98,13 @@ if (isFormSent()) {
 			// So let's continue with probing his points amount
 			if (($points - getConfig('doubler_left') - postRequestParameter('points') * getConfig('doubler_charge') / 100) >= 0) {
 				// Enough points are left so let's continue with the doubling process
-				// 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')",
+				// 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'),
-						makeDatabaseUserId(determineReferalId()),
-						bigintval(postRequestParameter('points') * 2)
+						makeZeroToNull(determineReferalId()),
+						bigintval(postRequestParameter('points') * 2),
+						detectRemoteAddr()
 					), __FILE__, __LINE__);
 
 				// Subtract entered points
@@ -117,10 +118,11 @@ if (isFormSent()) {
 				// Add second line for the referal but only when userid != refid
 				if ((isValidUserId(determineReferalId())) && (determineReferalId() != 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','".detectRemoteAddr()."',UNIX_TIMESTAMP(),'N','Y')",
+					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')",
 						array(
-							makeDatabaseUserId(determineReferalId()),
-							bigintval(postRequestParameter('points') * 2 * getConfig('doubler_ref') / 100)
+							makeZeroToNull(determineReferalId()),
+							(postRequestParameter('points') * 2 * getConfig('doubler_ref') / 100),
+							detectRemoteAddr()
 						), __FILE__, __LINE__);
 
 					// And that's why we don't want to you more than one referal level of doubler-points. ^^^
@@ -170,7 +172,9 @@ if (isFormSent()) {
 } // END - if (isFormSet())
 
 // Shall I check for points immediately?
-if (getConfig('doubler_send_mode') == 'DIRECT') loadInclude('inc/mails/doubler_mails.php');
+if (getConfig('doubler_send_mode') == 'DIRECT') {
+	loadInclude('inc/mails/doubler_mails.php');
+} // END - if
 
 // Output header
 loadIncludeOnce('inc/header.php');