![](\"images/female.gif\")
`b Name`b![](\"images/male.gif\")
`b Name`b| `bRang`b | `bName`b | ", true); if ($data_header !== false) { for ($i = 0; $i < count($data_header); $i++) { output("`b".$data_header[$i]."`b | ", true); } } $result = db_query($sql) or die(db_error(LINK)); if (db_num_rows($result)==0){ $size = ($data_header === false) ? 2 : 2+count($data_header); //echo $size; if ($none === false) $none = "Keine Spieler gefunden"; output('
| `&' . $none .'`0 | ||
| ".($i+$from).". | `&{$row[name]}`0 | ",true); if ($data_header !== false) { for ($j = 0; $j < count($data_header); $j++) { $id = "data" . ($j+1); $val = $row[$id]; if ($tag !== false) $val = $val . " " . $tag[$j]; output("$val | ",true); } } output("
',' ')";
$racesel = "CASE race WHEN 1 THEN '`2Troll`0' WHEN 2 THEN '`^Elf`0' WHEN 3 THEN '`&Mensch`0' WHEN 4 THEN '`#Zwerg`0' WHEN 5 THEN '`5Echse`0' ELSE '`7Unbekannt`0' END";
if ($_GET[op]=="money"){
$sql = "SELECT name,(goldinbank+gold+round((((rand()*10)-5)/100)*(goldinbank+gold))) AS data1 FROM accounts WHERE locked=0 ORDER BY data1 $order, level $order, experience $order, acctid $order LIMIT $limit";
$adverb = "reichsten";
if ($_GET[subop] == "least") $adverb = "ärmsten";
$title = "Die $adverb Krieger in diesem Land";
$foot = "(Vermögen +/- 5%)";
$headers = array("Geschätztes Vermögen");
$tags = array("Gold");
display_table($title, $sql, false, $foot, $headers, $tags);
} elseif ($_GET[op] == "gems") {
$sql = "SELECT name FROM accounts WHERE locked=0 ORDER BY gems $order, level $order, experience $order, acctid $order LIMIT $limit";
if ($_GET[subop] == "least") $adverb = "wenigsten";
else $adverb = "meisten";
$title = "Die Krieger mit den $adverb Edelsteinen";
display_table($title, $sql);
} elseif ($_GET[op]=="charm"){
$sql = "SELECT name,$sexsel AS data1,$racesel AS data2 FROM accounts WHERE locked=0 ORDER BY charm $order, level $order, experience $order, acctid $order LIMIT $limit";
$adverb = "schönsten";
if ($_GET[subop] == "least") $adverb = "hässlichsten";
$title = "Die $adverb Krieger in diesem Land.";
$headers = array("/", "Rasse");
display_table($title, $sql, false, false, $headers, false);
} elseif ($_GET[op]=="tough"){
$sql = "SELECT name,level AS data2 ,$racesel as data1 FROM accounts WHERE locked=0 ORDER BY maxhitpoints $order, level $order, experience $order, acctid $order LIMIT $limit";
$adverb = "stärksten";
if ($_GET[subop] == "least") $adverb = "schwächsten";
$title = "Die $adverb Krieger in diesem Land";
$headers = array("Rasse", "Level");
display_table($title, $sql, false, false, $headers, false);
}elseif ($_GET[op]=="punch"){
$sql = "SELECT name,punch AS data1,$racesel AS data2 FROM accounts WHERE locked=0 ORDER BY data1 $order, level $order, experience $order, acctid $order LIMIT $limit";
$adverb = "härtesten";
if ($_GET[subop] == "least") $adverb = "armseligsten";
$title = "Die $adverb Schläge aller Zeiten";
$headers = array("Punkte","Rasse");
display_table($title, $sql, false, false, $headers, false);
} elseif ($_GET[op]=="resurrects"){
$sql = "SELECT name,level AS data1 FROM accounts WHERE locked=0 ORDER BY resurrections $order, level $order, experience $order, acctid $order LIMIT $limit";
$adverb = "tollpatschigsten";
if ($_GET[subop] == "least") $adverb = "geschicktesten";
$title = "Die $adverb Krieger in diesem Land";
$headers = array("Level");
display_table($title, $sql, false, false, $headers, false);
} elseif ($_GET[op]=="grave"){
$sql = "SELECT name,deathpower,location,loggedin,laston,alive FROM accounts WHERE locked=0 ORDER BY deathpower $order, level $order, experience $order, acctid $order LIMIT $limit";
$adverb = "fleissigste";
if ($_GET[subop] == "least") $adverb = "faulste";
$title = "Ramius' $adverb Krieger";
output("`c`b`^$title`0`b `7(Seite $page: $from-$to)`0`c`n");
output('| `bRang`b | `bName`b | `bGefallen`b | `bOrt`b | `bStatus`b |
| `&Keine Spieler gefunden`0 | ||||
| ".($i+$from).". | `&{$row[name]}`0 | `){$row[deathpower]}`0 | ",true); $loggedin=(date("U") - strtotime($row[laston]) < getsetting("LOGINTIMEOUT",900) && $row[loggedin]); if ($row[location]==0) output($loggedin?"`#Online`0":"`3Die Felder`0"); if ($row[location]==1) output("`3Zimmer in Kneipe`0"); if ($row[location]==2) output("`3Im Haus`0"); output(" | ",true); output($row[alive]?"`1Lebt`0":"`4Tot`0"); output(" |
| `b Name`b | `b Name`b | ||
| `&`iIn diesem Land gibt es keine Paare`i`0 | `&$row2[name]`0 | `) und `0 | `&",true); output("$row[name]`0 | ",true); } output("