From: Roland Häder <roland@mxchange.org>
Date: Sat, 31 Oct 2009 16:45:15 +0000 (+0000)
Subject: SQL fixed
X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=commitdiff_plain;h=16ee5477c8b098ea37dae85d400b25698235e465;ds=sidebyside

SQL fixed
---

diff --git a/inc/libs/doubler_functions.php b/inc/libs/doubler_functions.php
index 6d54679d7f..6b8d7f8b92 100644
--- a/inc/libs/doubler_functions.php
+++ b/inc/libs/doubler_functions.php
@@ -48,7 +48,7 @@ function generateDoublerTable ($userid = 0, $done = 'N', $ref = 'N', $sort = 'AS
 	$add = ''; $DT_MODE = 0;
 	if ($userid > 0) {
 		// Load entries only from a single user
-		$add = " AND `userid`='".bigintval($userid)."'";
+		$add = sprintf(" AND `userid`=%s", bigintval($userid));
 		$mode = 'member'; $COLS = 4; $DT_MODE = 2;
 		$message = getMessage('DOUBLER_MEMBER_NO_ENTRIES_FOUND');
 	} else {
@@ -74,7 +74,7 @@ function generateDoublerTable ($userid = 0, $done = 'N', $ref = 'N', $sort = 'AS
 FROM
 	`{?_MYSQL_PREFIX?}_doubler`
 WHERE
-	`completed`='".$done."' AND is_ref`='".$ref."'".$add."
+	`completed`='".$done."' AND `is_ref`='".$ref."'".$add."
 ORDER BY
 	`timemark` ".$sort."
 LIMIT ".$limit, __FUNCTION__, __LINE__);