ADD_DESCR ("admin", basename(__FILE__));
// Check for accounts
-$result = SQL_QUERY("SELECT userid, gender, surname, family, email, REMOTE_ADDR, refid, user_hash FROM "._MYSQL_PREFIX."_user_data WHERE status='UNCONFIRMED' ORDER BY userid", __FILE__, __LINE__);
+$result = SQL_QUERY("SELECT userid, gender, surname, family, email, REMOTE_ADDR, refid, user_hash
+FROM `{!_MYSQL_PREFIX!}_user_data`
+WHERE `status`='UNCONFIRMED'
+ORDER BY userid ASC", __FILE__, __LINE__);
if (SQL_NUMROWS($result) > 0) {
// We have some (new?) registrations!
'gender' => TRANSLATE_GENDER($gender),
'sname' => $sname,
'fname' => $fname,
- 'email' => "<A href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".$email."</A>",
+ 'email' => "<a href=\"".CREATE_EMAIL_LINK($email, "user_data")."\">".$email."</a>",
'ip' => $IP,
'ref' => $ref,
'hash' => $hash,
LOAD_TEMPLATE("admin_reg");
} else {
// No registrations left - or all has confirmed their email address... :-)
- LOAD_TEMPLATE("admin_settings_saved", false, ADMIN_ALL_CONFIRMED_EMAIL);
+ LOAD_TEMPLATE("admin_settings_saved", false, getMessage('ADMIN_ALL_CONFIRMED_EMAIL'));
}
// Free memory