}
// Check if at least one is in the active rallye
- $result = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, ".$USE." AS points, last_online
+ $result = SQL_QUERY_ESC("SELECT userid AS uid, email, gender, surname, family, ".$USE." AS points, last_online AS last
FROM "._MYSQL_PREFIX."_user_data
WHERE status='CONFIRMED' AND ".$USE." > 0".$LAST."
ORDER BY points DESC, last_online DESC, userid",
}
// Prepare content
+ $content['uid'] = ADMIN_USER_PROFILE_LINK($content['uid']);
$content['email'] = CREATE_EMAIL_LINK($content['email'], "user_data");
$content['gender'] = TRANSLATE_GENDER($content['gender']);
$content['points'] = TRANSLATE_COMMA($content['points']);