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 ASC", __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!
$OUT = ''; $SW = 2;
while ($content = SQL_FETCHARRAY($result)) {
// Add link to refid
- if ($content['refid'] > 0) $content['refid'] = ADMIN_USER_PROFILE_LINK($content['refid']);
+ if ($content['refid'] > 0) $content['refid'] = generateUserProfileLink($content['refid']);
// Prepare array for the row template
// @TODO Rewritings: sname->surname,fname->family,ip->REMOTE_ADDR,ref->refid,hash->user_hash in template
$content = array(
'sw' => $SW,
- 'gender' => TRANSLATE_GENDER($content['gender']),
+ 'gender' => translateGender($content['gender']),
'sname' => $content['surname'],
'fname' => $content['family'],
- 'email' => "<a href=\"".CREATE_EMAIL_LINK($content['email'], "user_data")."\">".$content['email']."</a>",
+ 'email' => "<a href=\"".generateEmailLink($content['email'], 'user_data')."\">".$content['email']."</a>",
'ip' => $content['REMOTE_ADDR'],
'ref' => $content['refid'],
'hash' => $content['user_hash'],
- 'link' => ADMIN_USER_PROFILE_LINK($content['userid']),
+ 'link' => generateUserProfileLink($content['userid']),
);
// Load row template and switch color