X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fdoubler_functions.php;h=28ce65d9b8cfaa87725e12708a55869e927ce44a;hb=d495bd859975d08ee459d03c9b1cd51dd9b9304d;hp=6d54679d7fb728dfc14bf38410d41dcdbbeeaf9c;hpb=dbb6aa4eaeff7c3bab27f143d881781380d43d41;p=mailer.git

diff --git a/inc/libs/doubler_functions.php b/inc/libs/doubler_functions.php
index 6d54679d7f..28ce65d9b8 100644
--- a/inc/libs/doubler_functions.php
+++ b/inc/libs/doubler_functions.php
@@ -43,12 +43,12 @@ if (!defined('__SECURITY')) {
 
 // Generates a HTML table based on given data
 // @TODO Lame description
-function generateDoublerTable ($userid = 0, $done = 'N', $ref = 'N', $sort = 'ASC') {
-	if (empty($cnt)) $cnt = 0;
-	$add = ''; $DT_MODE = 0;
+function generateDoublerTable ($userid = '0', $done = 'N', $ref = 'N', $sort = 'ASC') {
+	if (empty($cnt)) $cnt = '0';
+	$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__);
@@ -122,7 +122,7 @@ LIMIT ".$limit, __FUNCTION__, __LINE__);
 //
 function DOUBLER_GET_TOTAL_POINTS_LEFT() {
 	// Initialize variables
-	$points = 0;
+	$points = '0';
 
 	if (getConfig('doubler_own') == 'Y') {
 		// Take points from doubler's own account