X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Flibs%2Fdoubler_functions.php;h=f13c6cb529b0bccdbf0e66ba581cfca815538ad4;hb=d92a340159ca45047eafc111fcac64933a7babeb;hp=6d54679d7fb728dfc14bf38410d41dcdbbeeaf9c;hpb=c2e17d983fcbc0c3bd1dd37908d87c678f0367df;p=mailer.git diff --git a/inc/libs/doubler_functions.php b/inc/libs/doubler_functions.php index 6d54679d7f..f13c6cb529 100644 --- a/inc/libs/doubler_functions.php +++ b/inc/libs/doubler_functions.php @@ -1,7 +1,7 @@ 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__); @@ -92,11 +92,11 @@ LIMIT ".$limit, __FUNCTION__, __LINE__); // Prepare data for the row template $content = array( - 'userid' => $content['userid'], - 'rid' => $content['refid'], - 'points' => translateComma($content['points']), - 'stamp' => generateDateTime($content['timemark'], $DT_MODE), - 'sw' => $SW, + 'userid' => $content['userid'], + 'rid' => $content['refid'], + 'points' => translateComma($content['points']), + 'timemark' => generateDateTime($content['timemark'], $DT_MODE), + 'sw' => $SW, ); // Load template and switch color @@ -109,7 +109,7 @@ LIMIT ".$limit, __FUNCTION__, __LINE__); } else { // List no entries $OUT = " - + ".loadTemplate('admin_settings_saved', true, $message)." \n"; @@ -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