0) redirect("village.php"); else isnewday(2); addcommentary(); addnav("W?Zurück zum Weltlichen","village.php"); if ($_GET[op]=="newsdelete"){ $sql = "DELETE FROM news WHERE newsid='$_GET[newsid]'"; db_query($sql); $return = $_GET['return']; $return = preg_replace("'[?&]c=[[:digit:]-]*'","",$return); $return = substr($return,strrpos($return,"/")+1); redirect($return); } if ($_GET[op]=="commentdelete"){ $sql = "DELETE FROM commentary WHERE commentid='$_GET[commentid]'"; db_query($sql); $return = $_GET['return']; $return = preg_replace("'[?&]c=[[:digit:]-]*'","",$return); $return = substr($return,strrpos($return,"/")+1); if (strpos($return,"?")===false && strpos($return,"&")!==false){ $x = strpos($return,"&"); $return = substr($return,0,$x-1)."?".substr($return,$x+1); } redirect($return); } if ($_GET[op]=="dbrepair"){ $sql="REPAIR TABLE `accounts`"; db_query($sql); $sql="REPAIR TABLE `bans`"; db_query($sql); $sql="REPAIR TABLE `commentary`"; db_query($sql); $sql="REPAIR TABLE `debuglog`"; db_query($sql); $sql="REPAIR TABLE `faillog`"; db_query($sql); $sql="REPAIR TABLE `houses`"; db_query($sql); $sql="REPAIR TABLE `items`"; db_query($sql); $sql="REPAIR TABLE `mail`"; db_query($sql); $sql="REPAIR TABLE `motd`"; db_query($sql); $sql="REPAIR TABLE `news`"; db_query($sql); $sql="REPAIR TABLE `petitions`"; db_query($sql); $sql="REPAIR TABLE `pollresults`"; db_query($sql); $sql="REPAIR TABLE `pvp`"; db_query($sql); $sql="REPAIR TABLE `referers`"; db_query($sql); $sql="REPAIR TABLE `settings`"; db_query($sql); output("Tabellen gefixt.`n`n"); } if($_GET['op'] == 'fixuser') { $sql = "SELECT acctid FROM accounts WHERE login='".$_POST['login']."'"; $resultU = db_query($sql); if(false !== ($user = db_fetch_assoc($resultU))) { $sql = "UPDATE accounts SET allowednavs='',output='' WHERE login='".$user['acctid']."'"; db_query($sql); output("`b".$_POST['login']." wurde erfolgreich befreit!`b`n"); } else { output("`QKonnte User '".$_POST['login']."' nicht finden!`0"); } } page_header("Admin Grotte"); if ($_GET[op]=="checkcommentary"){ addnav("G?Zurück zur Grotte","superuser.php"); viewcommentary(array(),"X",100); //viewcommentary("' or '1'='1","X",100); }else if ($_GET[op] == "bounties") { addnav("G?Zurück zur Grotte","superuser.php"); output("`c`bDie Kopfgeldliste`b`c`n"); $sql = "SELECT name,alive,sex,level,laston,loggedin,lastip,uniqueid,bounty FROM accounts WHERE bounty>0 ORDER BY bounty DESC"; $result = db_query($sql) or die(sql_error($sql)); output("
| Kopfgeld | Level | Name | Ort | Geschlecht | Status | Zuletzt da | ",true); output("`^$row[bounty]`0"); output(" | ",true); output("`^$row[level]`0"); output(" | ",true); output("`&$row[name]`0"); if ($session[user][loggedin]) output("",true); output(" | ",true); $loggedin=(date("U") - strtotime($row[laston]) < getsetting("LOGINTIMEOUT",900) && $row[loggedin]); output($row[location] ?"`3Kneipe`0" :($loggedin ?"`#Online`0" :"`3Die Felder`0")); output(" | ",true); output($row[sex]?"`!Weiblich`0":"`!Männlich`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("c"))-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("c")."-1 day"))) $laston="Gestern"; if ($loggedin) $laston="Jetzt"; output($laston); output(" | ",true); } output("