* svn:keywords Date Revision" (autoprobset!) at least!!!!!! *
* -------------------------------------------------------------------- *
* Copyright (c) 2003 - 2009 by Roland Haeder *
+ * Copyright (c) 2009, 2010 by Mailer Developer Team *
* For more information visit: http://www.mxchange.org *
* *
* This program is free software; you can redistribute it and/or modify *
} // END - if
// Autopurge installed?
-$lastOnline = "%s";
+$lastOnline = '%s';
$ONLINE = '';
if (isExtensionActive('autopurge')) {
// Use last online timestamp to keep inactive members away from here
- $lastOnline = " AND `last_online` >= (UNIX_TIMESTAMP() - %s)";
- $ONLINE = getConfig('ap_inactive_since');
+ $lastOnline = " AND `last_online` >= (UNIX_TIMESTAMP() - {?ap_inactive_since?})";
} // END - if
// Let's check if there are some points left we can 'pay'...
$result = SQL_QUERY_ESC("SELECT
- `userid`, `beg_points` AS beg, `last_online`
+ `userid`, `beg_points` AS points, `last_online`
FROM
`{?_MYSQL_PREFIX?}_user_data`
WHERE
- `beg_points` > 0 AND `status`='CONFIRMED'".$lastOnline."
+ `beg_points` > 0 AND
+ `status`='CONFIRMED'
+ " . $lastOnline . "
ORDER BY
- `beg_points` DESC, `last_online` DESC, `userid` ASC LIMIT %s",
+ `beg_points` DESC,
+ `last_online` DESC,
+ `userid` ASC
+LIMIT {?beg_ranks?}",
array(
- $ONLINE,
- getConfig('beg_ranks')
+ $ONLINE
), __FILE__, __LINE__);
// Reset temporary variable and check for users
while ($content = SQL_FETCHARRAY($result)) {
// Prepare data for the template
$content = array(
- 'sw' => $SW,
- 'cnt' => $cnt,
- 'userid' => bigintval($content['userid']),
- 'points' => translateComma($content['beg']),
- 'last_online' => generateDateTime($content['last_online'], 2),
+ 'sw' => $SW,
+ 'cnt' => $cnt,
+ 'userid' => $content['userid'],
+ 'points' => $content['points'],
+ 'last_online' => generateDateTime($content['last_online'], 2),
);
// Load row template
// Count one up and switch colors
$cnt++; $SW = 3 - $SW;
- }
+ } // END - while
} else {
// No one is interested in our "active rallye" ! :-(
$OUT = loadTemplate('member_beg_404', true);
// Load final template
loadTemplate('member_list_beg', false, $content);
-//
+// [EOF]
?>