} // END - if
// Add description as navigation point
-addMenuDescription('admin', __FILE__);
+addYouAreHereLink('admin', __FILE__);
if (isGetRequestParameterSet('id')) {
// Show detailed informations to a sponsor
`id`, `gender`, `surname`, `family`, `email`, `status`,
UNIX_TIMESTAMP(`sponsor_created`) AS `sponsor_created`,
UNIX_TIMESTAMP(`last_online`) AS `last_online`,
- `points_amount`, `points_used`, `remote_addr`
+ `points_amount`, `points_used`,
+ (`points_amount` + `points_used`) AS `points`,
+ `remote_addr`
FROM
`{?_MYSQL_PREFIX?}_sponsor_data`
ORDER BY
$content['email'] = generateEmailLink($content['email'], 'sponsor_data');
$content['sponsor_created'] = generateDateTime($content['sponsor_created'], 2);
$content['last_online'] = generateDateTime($content['last_online'], 2);
- $content['points'] = ($content['points_amount'] - $content['points_used']);
// Load row template
$OUT .= loadTemplate('admin_list_sponsor_row', true, $content);