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)); } // 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,race 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,race FROM accounts WHERE locked=0 $search ORDER BY level DESC, dragonkills DESC, login ASC $limit"; } if ($session[user][loggedin]){ output("
Nach Name suchen:
",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"); } output("",true); output("",true); for($i=0;$i<$max;$i++){ $row = db_fetch_assoc($result); output("",true); } output("
LevelNameRasse/OrtStatusZuletzt da
",true); output("`^$row[level]`0"); output("",true); if ($session[user][loggedin]) output("Mail schreiben",true); if ($session[user][loggedin]) output("",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("",true); output("",true); output($colraces[$row['race']]); output("",true); output($row[sex]?"":"",true); output("",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("",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("
",true); page_footer(); ?>