Required fix for NULL vs. 0 in user_points

[mailer.git] / doubler.php

diff --git a/doubler.php b/doubler.php
index 16aceb6e3eaf93baa3566f8987054c89159d4308..306e8f01ab44cd8ab0877a1482eb9db9b513387f 100644 (file)
--- a/doubler.php
+++ b/doubler.php
@@ -102,7 +102,7 @@ if (isFormSent()) {
                                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()),
+                                               makeZeroToNull(determineReferalId()),
                                                bigintval(postRequestParameter('points') * 2),
                                                detectRemoteAddr()
                                        ), __FILE__, __LINE__);
@@ -120,7 +120,7 @@ if (isFormSent()) {
                                        // 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')",
                                                array(
-                                                       makeDatabaseUserId(determineReferalId()),
+                                                       makeZeroToNull(determineReferalId()),
                                                        (postRequestParameter('points') * 2 * getConfig('doubler_ref') / 100),
                                                        detectRemoteAddr()
                                                ), __FILE__, __LINE__);