* $Author:: $ *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
- * Copyright (c) 2009 - 2011 by Mailer Developer Team *
- * For more information visit: http://www.mxchange.org *
+ * Copyright (c) 2009 - 2013 by Mailer Developer Team *
+ * For more information visit: http://mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
// Some security stuff...
if (!defined('__SECURITY')) {
- die();
+ exit();
} elseif (!isMember()) {
redirectToIndexMemberOnlyModule();
}
// Add more bonus points here
$add = runFilterChain('add_bonus_points_user_columns', '');
-$USE = '`turbo_bunus`';
+$pointsColumns = '`turbo_bunus`';
if (!empty($add)) {
- $USE = '(0' . $add . ')';
+ $pointsColumns = '(0' . $add . ')';
} // END - if
// Init variables
} // END - if
// Let's check if there are some points left we can 'pay'...
-$result = SQL_QUERY_ESC("SELECT
- `userid`, ".$USE." AS `points`,`last_online`
+$result = sqlQueryEscaped("SELECT
+ `userid`,
+ ".$pointsColumns." AS `points`,
+ `last_online`
FROM
`{?_MYSQL_PREFIX?}_user_data`
WHERE
- " . $USE . " > 0 AND
+ " . $pointsColumns . " > 0 AND
`status`='CONFIRMED'
+ " . runFilterChain('user_exclusion_sql', ' ') . "
" . $lastOnline . "
ORDER BY
`points` DESC,
- last_online DESC,
- userid ASC
+ `last_online` DESC,
+ `userid` ASC
LIMIT {?bonus_ranks?}",
array(
$ONLINE
// Reset temporary variable and check for users
$OUT = '';
-if (!SQL_HASZERONUMS($result)) {
+if (!ifSqlHasZeroNums($result)) {
// Load our winners...
$count = 1;
- while ($content = SQL_FETCHARRAY($result)) {
+ while ($content = sqlFetchArray($result)) {
// Prepare data for the template
$content['count'] = $count;
$content['last_online'] = generateDateTime($content['last_online'], '2');
// Load row template
- $OUT .= loadTemplate('member_bonus_row', true, $content);
+ $OUT .= loadTemplate('member_bonus_row', TRUE, $content);
// Count one up
$count++;
} // END - while
} else {
// No one is interested in our "active rallye" ! :-(
- $OUT = loadTemplate('member_bonus_404', true);
+ $OUT = loadTemplate('member_bonus_404', TRUE);
}
// Free memory
-SQL_FREERESULT($result);
+sqlFreeResult($result);
// Prepare content array
$content['rows'] = $OUT;
// Load final template
-loadTemplate('member_bonus', false, $content);
+loadTemplate('member_bonus', FALSE, $content);
// [EOF]
?>