List of Users';
$order = 'nickname';
$query = "SELECT nickname,realname,email,register_date FROM users WHERE status = 1 ORDER BY $order";
$sth = db_query($query);
if ($sth === false || pg_num_rows ($sth) == 0)
$ret .= '
Keine Nutzerdaten vorhanden.
';
else {
$ret .= '';
$ret .= 'Login | Email | Since |
';
for ($n=0; $n < pg_num_rows ($sth); $n++) {
$row = pg_fetch_array ($sth, $n);
if (strlen($row['realname']))
$email = $row['email'] . '/' . $row['realname'];
else
$email = $row['email'];
$name = $row['realname'];
$register = explode(' ', $row['register_date']);
$register = $register[0];
$ret .= sprintf('%s | %s | %s |
',
$row['nickname'], $email, $register);
}
$ret .= '
';
}
return $ret;
}
function admin_hitlist()
{
global $cfg;
$ret = 'Globale Hitlist
';
$query = "SELECT zeitung,name,sum(counter) as counter FROM hits " .
"INNER JOIN zeitungen ON id = zeitung " .
"WHERE deleted IS false " .
"GROUP BY zeitung,name ORDER BY counter DESC";
$sth = db_query($query);
if ($sth === false || pg_num_rows ($sth) == 0)
$ret .= 'Keint Hitliste vorhanden
';
else {
$ret .= '';
$ret .= 'Hits | Name |
';
for ($n=0; $n < pg_num_rows ($sth); $n++) {
$row = pg_fetch_array ($sth, $n);
$ret .= sprintf('%d | %s |
',
$row['counter'], $cfg['basepath'], $row['zeitung'], $row['name']);
}
$ret .= '
';
}
return $ret;
}
function layout_admin()
{
$ret = 'Admin page
';
$ret .= admin_userlist();
$ret .= admin_hitlist();
return $ret;
}
?>