From 16ee5477c8b098ea37dae85d400b25698235e465 Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Sat, 31 Oct 2009 16:45:15 +0000 Subject: [PATCH] SQL fixed --- inc/libs/doubler_functions.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) 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__); -- 2.39.5