LoGD Standardrelease steht hier zum Download zur Verfügung!
<?php
// 15082004
require_once "common.php";
if ($session[user][loggedin]) {
addcommentary();
checkday();
$session[user][ort]="`gBügerliste";
output("<script type=\"text/javascript\" src=\"wz_tooltip.js\"></script>",true);
if ($session[user][alive]) {
addnav("Zurück zum Dorf","village.php");
} else {
addnav("Zurück zu den Schatten", "shades.php");
}
addnav("Gerade Online","list.php");
// addnav("TEST","list.php");
if ($session['user']['rpb']==0) {addnav("Im Rp","list.php?op=rpb");
addnav("Suche Rp","list.php?op=rpon");}
if ($session['user']['rpb']==1) {addnav("Suche Rp","list.php?op=rpon");
addnav("Kein Rp","list.php?op=rpoff");}
if ($session['user']['rpb']==2){ addnav("Kein Rp","list.php?op=rpoff");
addnav("Im Rp","list.php?op=rpb");}
}else{
addnav("Login Seite","index.php");
addnav("Gerade Online","list.php");
}
page_header("Bürgerliste");
if($_GET[op]=="rpon")
{
$session['user']['rpb']=2;
redirect("list.php");
}
if($_GET[op]=="rpb")
{
$session['user']['rpb']=1;
redirect("list.php");
}
if($_GET[op]=="rpoff")
{
$session['user']['rpb']=0;
redirect("list.php");
}
$playersperpage=50;
$sql = "SELECT count(acctid) AS c FROM accounts WHERE locked=0";
$result = db_query($sql);
$row = db_fetch_assoc($result);
$totalplayers = $row['c'];
if ($_GET['op']=="search"){
$search="%";
for ($x=0;$x<strlen($_POST['name']);$x++){
$search .= substr($_POST['name'],$x,1)."%";
}
$search=" AND name LIKE '".addslashes($search)."' ";
//addnav("List Warriors","list.php");
}else{
$pageoffset = (int)$_GET['page'];
if ($pageoffset>0) $pageoffset--;
$pageoffset*=$playersperpage;
$from = $pageoffset+1;
$to = min($pageoffset+$playersperpage,$totalplayers);
$limit=" LIMIT $pageoffset,$playersperpage ";
}
addnav("Seiten");
for ($i=0;$i<$totalplayers;$i+=$playersperpage){
addnav("Seite ".($i/$playersperpage+1)." (".($i+1)."-".min($i+$playersperpage,$totalplayers).")","list.php?page=".($i/$playersperpage+1));
}
output("`cRp-Bereitschaft:`n `n`<table><td><img src=\"images/rpb3.jpg\"><td width=100> kein Interesse <td> <img src=\"images/rpb1.jpg\"><td width=100> ist im Rp<td>
<img src=\"images/rpb2.jpg\"><td width=100> will ein Rp</table> `c`n`n`n",true);
// Order the list by level, dragonkills, name so that the ordering is total!
// Without this, some users would show up on multiple pages and some users
// wouldn't show up
if ($_GET['page']=="" && $_GET['op']==""){
output("`c`bDiese Krieger sind gerade online`b`c");
$sql = "SELECT acctid,name,login,alive,location,sex,level,laston,loggedin,lastip,uniqueid,race2,rpb,race,ort FROM accounts WHERE locked=0 AND loggedin=1 AND laston>'".date("Y-m-d H:i:s",strtotime(date("r")."-".getsetting("LOGINTIMEOUT",900)." seconds"))."' ORDER BY level DESC, dragonkills DESC, login ASC";
}else{
output("`c`bKrieger in dieser Welt (Seite ".($pageoffset/$playersperpage+1).": $from-$to von $totalplayers)`b`c");
$sql = "SELECT acctid,name,login,alive,location,sex,level,laston,loggedin,lastip,uniqueid,race2,rpb,race,ort FROM accounts WHERE locked=0 $search ORDER BY level DESC, dragonkills DESC, login ASC $limit";
}
if ($session[user][loggedin]){
output("<form action='list.php?op=search' method='POST'>Nach Name suchen: <input name='name'><input type='submit' class='button' value='Suchen'></form>",true);
addnav("","list.php?op=search");
}
$result = db_query($sql) or die(sql_error($sql));
$max = db_num_rows($result);
if ($max>100) {
output("`\$Es treffen zu viele Namen auf diese Suche zu. Nur die ersten 100 werden angezeigt.`0`n");
$max=100;
}
output("<table border=0 cellpadding=2 cellspacing=1 bgcolor='#999999'>",true);
output("<tr class='trhead'><td><b>Name</b></td><td><b>Rasse</b></td><td><b><img src=\"images/female.gif\">/<img src=\"images/male.gif\"></b></td><td><b>Rp?</b></td><td><b>Ort</b></td><td><b>Rang</b></td><td><b>Zuletzt da</b></tr>",true);
for($i=0;$i<$max;$i++){
$row = db_fetch_assoc($result);
output("<tr class='".($i%2?"trdark":"trlight")."'><td>",true);
$sqlb = "SELECT avatar FROM bio WHERE acctid=".$row['acctid']."";
$resultb = db_query($sqlb) or die(sql_error($sqlb));
$rowb = db_fetch_assoc($resultb);
$l=$row['login'];
if ($session[user][loggedin]) output("<a href=\"mail.php?op=write&to=".rawurlencode($row['login'])."\" target=\"_blank\" onClick=\"".popup("mail.php?op=write&to=".rawurlencode($row['login'])."").";return false;\"><img src='images/newscroll.GIF' width='16' height='16' alt='Mail schreiben' border='0'></a>",true);
if ($session[user][loggedin]) output("<a href='bio.php?char=".rawurlencode($row['login'])."' onmouseover=\"TagToTip('$l' , BGCOLOR, '#050505')\" onmouseout=\"UnTip()\" target='window_popup' onClick=".popup($link)."; return false;\">",true);
if ($session[user][loggedin]) addnav("","bio.php?char=".rawurlencode($row['login'])."");
output("`".($row[acctid]==getsetting("hasegg",0)?"^":"&")."$row[name]`0");
if ($session[user][loggedin]) output("</a><span id='$l'> <table><td> <img src=".$rowb['avatar']." height=\"150\" width=\"150\" alt=\"`4(Kein Avatar)\"/></td></table> </span>",true);
output("</td><td>",true);
output($row['race2']."`n".$row['race']);
output("</td><td align=\"center\">",true);
output($row['sex']?"<img src=\"images/female.gif\">":"<img src=\"images/male.gif\">",true);
output("</td><td align=\"center\">",true);
switch ($row['rpb']){
case 1:
rawoutput("<img src=\"images/rpb1.jpg\">");
break;
case 2:
rawoutput("<img src=\"images/rpb2.jpg\">");
break;
case 0;
rawoutput("<img src=\"images/rpb3.jpg\">");
break; }
output("</td><td>",true);
$loggedin=(date("U") - strtotime($row[laston]) < getsetting("LOGINTIMEOUT",900) && $row[loggedin]);
if ($row[location]==0) output($loggedin?"`f".$row['ort']."`0":"`/Die Felder`0");
if ($row[location]==1) output("`/Zimmer`0");
if ($row[location]==2) output("`/Im Haus`0");
output("</td><td>",true);
switch ($row['login']){
case "Sekhmet":
if ($session[user][loggedin]) rawoutput("<a onmouseover=\"TagToTip('Prinzessin',BGCOLOR, '#050505')\" onmouseout=\"UnTip()\" return false;\">");
rawoutput("Prinzessin");
if ($session[user][loggedin]) rawoutput("</a><span id='Prinzessin'> <table><td valign=top>Rang:<br><br>Aufgaben:</td><td width=7><td>Regent (Admin)<br><br>Technischer Support,
Programmierung</TD></table> </span>",true);
break;
case "Ombrage":
if ($session[user][loggedin]) rawoutput("<a onmouseover=\"TagToTip('Pharao',BGCOLOR, '#050505')\" onmouseout=\"UnTip()\" return false;\">");
rawoutput("Pharao");
if ($session[user][loggedin]) rawoutput("</a><span id='Pharao'> <table><td valign=top>Rang:<br><br>Aufgaben:</td><td width=7><td>Regent (Admin)<br><br>Ingame-Support, Gestaltung </TD></table> </span>",true);
break;
case "Maat":
case "Ayesha":
if ($session[user][loggedin]) rawoutput("<a onmouseover=\"TagToTip('Ushepti',BGCOLOR, '#050505')\" onmouseout=\"UnTip()\" return false;\">");
rawoutput("Ushebti</a>");
break;
default;
output("Einwohner");
break; }
output("</td><td>",true);
//$laston=round((strtotime("0 days")-strtotime($row[laston])) / 86400,0)." Tage";
$laston=round((strtotime(date("r"))-strtotime($row[laston])) / 86400,0)." Tage";
if (substr($laston,0,2)=="1 ") $laston="1 Tag";
if (date("Y-m-d",strtotime($row[laston])) == date("Y-m-d")) $laston="Heute";
if (date("Y-m-d",strtotime($row[laston])) == date("Y-m-d",strtotime(date("r")."-1 day"))) $laston="Gestern";
if ($loggedin) $laston="Jetzt";
output($laston);
output("</td></tr>",true);
}
output("</table>",true);
if ($session[user][loggedin]) {if (!$session['user']['prefs']['ot']){
output("`c`@`n`n`n`bOFF-TOPIC`b`nin den Einstellungen auschaltbar`n`n`c");
viewcommentary("OFFTOPIC","Hinzufügen",15);
} }if ($session[user][loggedin]) rawoutput("<div style='visibility : hidden'><span id='Ushepti'> <table><td valign=top>Rang:<br><br>Aufgaben:</td><td width=7><td>Ushepti (Moderator)<br><br>Spieler-Support,<br> Unterstützung der Admins, Texten</TD></table> </span></div>",true);
page_footer();
?>