<?php
//Send HTML-Header Information
header("Content-Type: application/xhtml+xml; charset=utf-8");
//Connect to MyBB db and get Users
define("IN_MYBB", 1);
require_once "./inc/config.php";
mysql_connect($config['hostname'], $config['username'], $config['password']) or die("Verbindung fehlgeschlagen");
mysql_select_db($config['database']) or die("Verbindung fehlgeschlagen");
if(!isset($_GET['page']))
{
$page = 1;
}
else
{
$page = $_GET['page'];
}
$count = 30;
$start = $count*($page-1);
$end = $count*$page;
$query = mysql_query("SELECT u.username, u.uid, u.avatar, u.birthday, f.fid2, f.fid9, f.fid7, f.fid4 FROM mybb_users u LEFT JOIN mybb_userfields f ON (u.uid=f.ufid) ORDER BY f.fid4 ASC LIMIT $start,$end");
//HTML Code Part Top
echo '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">';
echo "\n<html xmlns=\"http://www.w3.org/1999/xhtml\" xml:lang=\"de\" lang=\"de\">\n<head>\n<title>New Page</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=UTF-8\" />\n<style type=\"text/css\">
img {border: none;}
* html a.bilderlink {border: 1px solid black;}
* html a.bilderlink:hover {border: 1px solid white}
.bilderlink img {border: 1px solid black;}
.bilderlink img:hover {border: 1px solid white;}
a.speziell:link {
background-color: solid white;
color: #000000;
}
a.speziell:visited {
background-color: solid white;
color: solid blue;
}
a.speziell:hover {
background-color: solid white;
color: soild blue;
}
a.speziell:active {
background-color: solid white;
color: solid black;
}
body{
font-family: Verdana;
}
#rundrum {
border-width:1px;
border-style:solid;
border-color:black;
padding:2.5em;
text-align:justify;
background-image:url(gr01013.gif);
}
</style>
</head>\n<body>\n<table border=\"0\" align=\"center\">\n<tr>\n<td>Übersicht</td>\n<td></td>\n</tr>\n";
//Userlist
while($user = mysql_fetch_array($query))
{
if($user['fid9'] != 'nein')
{
$newest_member = "<tr><td width=\"250\"><a class=\"speziell\" href=\"/member.php?action=profile&uid={$user['uid']}\">{$user['fid4']}</a> <br />Deckname: {$user['username']}<br /><br /><br />{$user['fid2']}<br />{$user['fid7']}</td> \n";
//Make IE not display the X icon if user has no avatar
if($user['avatar'] == '')
{
$avatar = "<td width=\"90\"><center>{$user['birthday']}<br /><br /><a href=\"/member.php?action=profile&uid={$user['uid']}\" class=\"bilderlink\"><img src=\"/uploads/avatars/nophoto.jpg\" width=\"52\" height=\"64\" alt=\"\" /></a></center></td></tr>";
}
else
{
$avatar = "<td width=\"90\"><center>{$user['birthday']}<br /><br /><a href=\"/member.php?action=profile&uid={$user['uid']}\" class=\"bilderlink\"><img src=\"{$user['avatar']}\" width=\"52\" height=\"64\" alt=\"\" /></a></center></td></tr>";
}
//Output User
echo "<p id=\"rundrum\"> $newest_member";
echo "<td width =\"25\"></td>$avatar </p>";
}
}
$query = mysql_query("SELECT COUNT(uid) AS count FROM mybb_users");
$output = mysql_fetch_array($query);
$pages = ceil($output['count']/$count);
echo "Seiten: ";
for ($i = 1; $i <= $pages; $i++)
{
echo "<a href=\"Wanted2.html?page=$i\">$i</a>\n";
}
//HTML Code Bottom
echo "</table>\n</body>\n</html>";
?>