X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Flibs%2Fdoubler_functions.php;h=2a2100f59272ed2a4613f8525377ed613aa071ff;hp=27c33d2582e679feee938c337aeb5fda5fecafcf;hb=263a089d8a499e0e26d0af9e7aa7639f88b8ca60;hpb=4e47eb8b83ed2fcd4320aeed8b8c460eb1c8fe4b diff --git a/inc/libs/doubler_functions.php b/inc/libs/doubler_functions.php index 27c33d2582..2a2100f592 100644 --- a/inc/libs/doubler_functions.php +++ b/inc/libs/doubler_functions.php @@ -1,7 +1,7 @@ 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($uid)."'"; - $mode = 'member'; $COLS = '4'; $DT_MODE = '2'; - $NOT_FOUND = getMessage('DOUBLER_MEMBER_NO_ENTRIES_FOUND'); + $add = sprintf(" AND `userid`=%s", bigintval($userid)); + $mode = 'member'; $COLS = 4; $DT_MODE = 2; + $message = getMessage('DOUBLER_MEMBER_NO_ENTRIES_FOUND'); } else { // Guest mode! - $mode = 'guest'; $COLS = '3'; $DT_MODE = '3'; - $NOT_FOUND = getMessage('DOUBLER_GUEST_NO_ENTRIES_FOUND'); + $mode = 'guest'; $COLS = 3; $DT_MODE = 3; + $message = getMessage('DOUBLER_GUEST_NO_ENTRIES_FOUND'); } if (($done == 'Y') && ($sort == 'ASC')) { @@ -70,10 +69,14 @@ function DOUBLER_GENERATE_TABLE ($uid = '0', $done = 'N', $ref = 'N', $sort = 'A } // List entries - $result = SQL_QUERY("SELECT userid, refid, points, timemark -FROM `{!_MYSQL_PREFIX!}_doubler` -WHERE completed='".$done."' AND is_ref='".$ref."'".$add." -ORDER BY timemark ".$sort." + $result = SQL_QUERY("SELECT + `userid`, `refid`, `points`, `timemark` +FROM + `{?_MYSQL_PREFIX?}_doubler` +WHERE + `completed`='".$done."' AND `is_ref`='".$ref."'".$add." +ORDER BY + `timemark` ".$sort." LIMIT ".$limit, __FUNCTION__, __LINE__); if (SQL_NUMROWS($result) > 0) { @@ -81,7 +84,7 @@ LIMIT ".$limit, __FUNCTION__, __LINE__); $OUT = ''; $SW = 2; while ($content = SQL_FETCHARRAY($result)) { // Rewrite userid/refid only if admin is in - if (IS_ADMIN()) { + if (isAdmin()) { // Set links to admin area if ($content['userid'] > 0) { $content['userid'] = generateUserProfileLink($content['userid']); } else { $content['userid'] = '---'; } if ($content['refid'] > 0) { $content['refid'] = generateUserProfileLink($content['refid']); } else { $content['refid'] = '---'; } @@ -89,15 +92,15 @@ LIMIT ".$limit, __FUNCTION__, __LINE__); // Prepare data for the row template $content = array( - 'uid' => $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 - $OUT .= LOAD_TEMPLATE($mode . '_doubler_list_rows', true, $content); + $OUT .= loadTemplate($mode . '_doubler_list_rows', true, $content); $SW = 3 - $SW; } @@ -107,37 +110,37 @@ LIMIT ".$limit, __FUNCTION__, __LINE__); // List no entries $OUT = "