$page = $menu->getA(3) == 'p' ? $menu->getE(3) : 1;
$filtername = escape($menu->get(2), 'string');
} else {
$page = $menu->getA(1) == 'p' ? $menu->getE(1) : 1;
}
$anfang = ($page - 1) * $limit;
$tpl = new tpl('user/memb_list.htm');
if (isset($_GET['filtername']) and !empty($_GET['filtername'])) {
$filtername = escape($_GET['filtername'], 'string');
}
if (!empty($filtername)) {
$sql_search = " WHERE prefix_user.name LIKE '%" . $filtername . "%'";
$MPL = db_make_sites($page, $sql_search, $limit, '?user-filtername-' . $filtername, 'user');
} else {
$sql_search = "";
$MPL = db_make_sites($page, "", $limit, '?user', 'user');
}
$tpl->set_out('SITELINK', $MPL, 0);
$class = '';
$erg = db_query("SELECT\r\n posts,\r\n prefix_user.id,\r\n prefix_grundrechte.name as recht_name,\r\n regist,\r\n prefix_user.name\r\nFROM prefix_user\r\n LEFT JOIN prefix_grundrechte ON prefix_user.recht = prefix_grundrechte.id\r\n {$sql_search}\r\nORDER by recht,prefix_user.posts DESC LIMIT " . $anfang . "," . $limit);
while ($row = db_fetch_object($erg)) {
if ($class == 'Cmite') {
$class = 'Cnorm';
} else {
$class = 'Cmite';
}
$ar = array('NAME' => $row->name, 'RANG' => userrang($row->posts, $row->id), 'CLASS' => $class, 'POSTS' => $row->posts, 'UID' => $row->id, 'DATE' => date('d.m.Y', $row->regist), 'GRUPE' => $row->recht_name);
$tpl->set_ar_out($ar, 1);
}
$tpl->set_out('filtername', $filtername ? $filtername : '', 2);
$design->footer();
# Copyright by: Manuel
# Support: www.ilch.de
defined('main') or die('no direct access');
$uid = intval($menu->get(2));
$abf = 'SELECT * FROM prefix_user WHERE id = "' . $uid . '"';
$erg = db_query($abf);
if (db_num_rows($erg)) {
$row = db_fetch_assoc($erg);
$avatar = '';
if (file_exists($row['avatar'])) {
$avatar = '<img src="' . $row['avatar'] . '" border="0">';
}
$regsek = mktime(0, 0, 0, date('m'), date('d'), date('Y')) - $row['regist'];
$regday = round($regsek / 86400);
$postpday = $regday == 0 ? 0 : round($row['posts'] / $regday, 2);
$ar = array('NAME' => $row['name'], 'JOINED' => date('d M Y', $row['regist']), 'LASTAK' => date('d M Y - H:i', $row['llogin']), 'POSTS' => $row['posts'], 'postpday' => $postpday, 'RANG' => userrang($row['posts'], $uid), 'AVATA' => $avatar);
$title = $allgAr['title'] . ' :: Users :: Details von ' . $row['name'];
$hmenu = $extented_forum_menu . '<a class="smalfont" href="?user">Users</a><b> » </b> Details von ' . $row['name'] . $extented_forum_menu_sufix;
$design = new design($title, $hmenu, 1);
$design->header();
$tpl = new tpl('user/userdetails');
$l = profilefields_show($uid);
$ar['rowspan'] = 4 + substr_count($l, '<tr><td class="');
$ar['profilefields'] = $l;
$tpl->set_ar_out($ar, 0);
} else {
$title = $allgAr['title'] . ' :: Users :: User nicht gefunden';
$hmenu = $extented_forum_menu . '<a class="smalfont" href="?user">Users</a> ' . $extented_forum_menu_sufix;
$design = new design($title, $hmenu, 1);
$design->header();
echo 'Der Benutzer wurde nicht gefunden bzw. die Seite wurde nicht richtig aufgerufen.<br />';
if ($row['sperre'] == 1) {
$row['sperre'] = '<br /><strong>gesperrt</strong>';
} else {
$row['sperre'] = '';
}
if (!is_numeric($row['geschlecht'])) {
$row['geschlecht'] = 0;
}
if (file_exists($row['avatar'])) {
$row['avatar'] = '<br /><br /><img src="' . $row['avatar'] . '" alt="User Pic" border="0" /><br />';
} elseif ($allgAr['forum_default_avatar']) {
$row['avatar'] = '<br /><br /><img src="include/images/avatars/' . $ges_ar[$row['geschlecht']] . '.jpg" alt="User Pic" border="0" /><br />';
} else {
$row['avatar'] = '';
}
$row['rang'] = userrang($row['posts'], $row['erstid']);
$row['txt'] = isset($_GET['such']) ? markword(bbcode($row['txt']), $_GET['such']) : bbcode($row['txt']);
$row['i'] = $i;
$row['page'] = $page;
if ($row['posts'] != 0) {
$row['erst'] = '<a href="index.php?user-details-' . $row['erstid'] . '"><b>' . $row['erst'] . '</b></a>';
} elseif ($row['erstid'] != 0) {
$row['rang'] = 'gelöschter User';
}
if ($forum_rights['mods'] == true and $i > 1) {
$row['delete'] = true;
}
if ($forum_rights['reply'] == true and loggedin() || $row["erstid"] == $_SESSION["authid"]) {
$row['change'] = true;
}
$row['posts'] = ($row['posts'] ? '<br />Posts: ' . $row['posts'] : '') . '<br />';
$yahoo = '';
}
if (!empty($row['aim'])) {
$aim = '<div id="infoAngabe">AIM-Messenger</div> ' . $row['aim'] . '<br />';
} else {
$aim = '';
}
if (!empty($email) or !empty($pn) or !empty($icq) or !empty($msn) or !empty($yahoo) or !empty($aim)) {
$kontakt = '<div id="contentBigTop"><div class="HeadText"><a href="">KONTAKT</a>' . $edit . '</div></div>
<div id="contentBig">
<div class="contenText">
' . $email . '
' . $pn . '
' . $icq . '
' . $msn . '
' . $yahoo . '
' . $aim . '
</div>
</div>';
}
if (!empty($row['sig'])) {
$signatur = '<div id="contentBigTop"><div class="HeadText"><a href="">SIGNATUR</a>' . $edit . '</div></div>
<div id="contentBig">
<div class="contenText">
' . bbcode($row['sig']) . '
</div>
</div>';
}
$ar = array('JOINED' => date('d M Y', $row['regist']), 'LASTAK' => date('d M Y - H:i', $row['llogin']), 'POSTS' => $row['posts'], 'postpday' => $postpday, 'RANG' => userrang($row['posts'], $uid), 'GEBURTSDATUM' => $gebdatum, 'GEBURTSJAHR' => $gebjahr, 'STERNZEICHEN' => $sternzeichen, 'WOHNORT' => $wohnort, 'GESCHLECHT' => $geschlecht, 'SIGNATUR' => $signatur, 'STATUS' => $status, 'HOMEPAGE' => $homepage, 'KONTAKT' => $kontakt, 'EDIT' => $edit);
$tpl->set_ar_out($ar, 0);
$design->footer();
