}
// Check if at least one is in the active rallye
- $result = SQL_QUERY_ESC("SELECT userid, email, sex, surname, family, ".$USE." AS active_bonus, last_online
+ $result = SQL_QUERY_ESC("SELECT userid, email, gender, surname, family, ".$USE." AS active_bonus, last_online
FROM "._MYSQL_PREFIX."_user_data
WHERE status='CONFIRMED' AND ".$USE." > 0".$LAST."
ORDER BY active_bonus DESC, last_online DESC, userid",
if (SQL_NUMROWS($result) > 0) {
// List users
$OUT = "";$SW = 2; $cnt = 1; $total = 0;
- while(list($uid, $email, $sex, $sname, $fname, $turbo, $last) = SQL_FETCHROW($result)) {
+ while(list($uid, $email, $gender, $sname, $fname, $turbo, $last) = SQL_FETCHROW($result)) {
// Generate array fore the dynamic template
$WIN1 = ""; $WIN2 = "";
if ($cnt <= $_CONFIG['bonus_ranks']) {
// Prepare content
$content = array(
- 'uid' => $uid,
- 'email' => CREATE_EMAIL_LINK($email, "user_data"),
- 'salut' => TRANSLATE_SEX($sex),
- 'sname' => $sname,
- 'fname' => $fname,
- 'turbo' => TRANSLATE_COMMA($turbo),
- 'last' => MAKE_DATETIME($last, "2"),
- 'sw' => $SW,
- 'win1' => $WIN1,
- 'win2' => $WIN2,
- 'cnt' => $cnt,
+ 'uid' => $uid,
+ 'email' => CREATE_EMAIL_LINK($email, "user_data"),
+ 'gender' => TRANSLATE_GENDER($gender),
+ 'sname' => $sname,
+ 'fname' => $fname,
+ 'turbo' => TRANSLATE_COMMA($turbo),
+ 'last' => MAKE_DATETIME($last, "2"),
+ 'sw' => $SW,
+ 'win1' => $WIN1,
+ 'win2' => $WIN2,
+ 'cnt' => $cnt,
);
// Load template and add it