LoGD Standardrelease steht hier zum Download zur Verfügung!
<?php
// 09092004
require_once "common.php";
if ($session[loggedin]){
redirect("badnav.php");
}
page_header();
output("`cWillkommen bei Legend of the Green Dragon, schamlos abgekupfert von Seth Able's Legend of the Red Dragon.`n");
if (getsetting('activategamedate','0')==1) output("`@Wir schreiben den `%".getgamedate()."`@.`0`n");
output("`@Die gegenwärtige Zeit im Dorf ist `%".getgametime()."`@.`0`n");
//Next New Day in ... is by JT from logd.dragoncat.net
$time = gametime();
// $tomorrow = strtotime(date("Y-m-d H:i:s",$time)." + 1 day");
$tomorrow = mktime(0,0,0,date('m',$time),date('d',$time)+1,date('Y',$time));
// $tomorrow = strtotime(date("Y-m-d 00:00:00",$tomorrow));
$secstotomorrow = $tomorrow-$time;
$realsecstotomorrow = round($secstotomorrow / (int)getsetting("daysperday",4));
output("`@Nächster neuer Tag in: `3".date("G \\S\\t\\u\\n\\d\\e\\n, i \\M\\i\\n\\u\\t\\e\\n, s \\S\\e\\k\\u\\n\\d\\e\\n\\ \\(\\E\\c\\h\\t\\z\\e\\i\\t\\)",strtotime("1980-01-01 00:00:00 + $realsecstotomorrow seconds"))."`0`n`n");
$newplayer=stripslashes(getsetting("newplayer",""));
if ($newplayer!="") output("`@Unser jüngster Spieler ist `^$newplayer`@!`0`n");
$newdk=stripslashes(getsetting("newdragonkill",""));
if ($newdk!="") output("`@Der letzte Drachentöter war: `&$newdk`@!`0`n");
$sql = "SELECT name,dragonkills FROM accounts WHERE 1 AND superuser < 1 ORDER BY dragonkills DESC LIMIT 1";
$resultx = db_query($sql);
$rowx = db_fetch_assoc($resultx);
$dker = $rowx[name];
$dkkills = $rowx[dragonkills];
$sql2 = "SELECT name,herotattoo,sex FROM accounts WHERE 1 AND superuser < 1 ORDER BY herotattoo DESC LIMIT 1";
$result2 = db_query($sql2);
$row2 = db_fetch_assoc($result2);
$hero1 = $row2[name];
$hero2 = $row2[herotattoo];
$sql4 = "SELECT gildenname,gildenpunkte FROM gilden WHERE 1 ORDER BY gildenpunkte DESC LIMIT 1";
$result4 = db_query($sql4);
$row4 = db_fetch_assoc($result4);
$gildn = $row4[gildenname];
$gildp = $row4[gildenpunkte];
$sql3 = "SELECT name,monsterkills,sex FROM accounts WHERE 1 AND superuser < 1 ORDER BY monsterkills DESC LIMIT 1";
$result3 = db_query($sql3);
$row3 = db_fetch_assoc($result3);
$monster1 = $row3[name];
$monster2 = $row3[monsterkills];
output("`2Die stärkste Gilde in diesem Land:`6 `b$gildn`b`2 mit `@`i`b$gildp`b`i `2Punkten!`n", true);
output("`2".($rowx[sex]?"Die Spielerin, die":"Der Spieler, der")." die meisten Drachen getötet hat:`6 `b$dker`b`2 mit unglaublichen `@`i`b$dkkills`b`i `2Drachenkills!`n", true);
output("`2".($row2[sex]?"Die Spielerin":"Der Spieler").", mit den meisten Tätowierungen:`6 `b$hero1`b`2 mit `@`i`b$hero2`b`i `2Tattoo's!`n", true);
output("`2".($row3[sex]?"Die Spielerin":"Der Spieler").", mit den meisten Monsterkills:`6 `b$monster1`b`2 mit `@`i`b$monster2`b`i `2Monsterkill's!`n", true);
// Die letzten 5 Drachentöter/innen, 2006 by Eliwood aka Wasili
output('`n`%`bDie letzten 5 Drachentöter/innen`b`0`n');
$sql = 'SELECT `newsdate`,`accountid` FROM `news` '
.'WHERE `newstext` LIKE "%hat die abscheuliche, als % bekannte Kreatur besiegt.%" ORDER BY `newsdate` DESC';
$result = db_query($sql);
output("<table border='0' cellpadding='2' cellspacing='1' bgcolor='#999999'>",true);
output("<tr class='trhead'><td><b>Name</b></td><td><b>Drachenkills</b></td><td><b>Datum</b></td></tr>",true);
$i = 0;
while($row = db_fetch_assoc($result)) {
$sql2 = 'SELECT `name`,`dragonkills` FROM `accounts` WHERE `acctid` = "'.$row['accountid'].'" LIMIT 1';
$res2 = db_query($sql2);
if(db_num_rows($res2) == 1) {
$row2 = db_fetch_assoc($res2);
$class = ($i%2?"trdark":"trlight");
$date = date('Y-m-d',strtotime($row['newsdate']));
output('<tr>'
.'<td>`&'.$row2['name'].'`0</td>'
.'<td>`^'.$row2['dragonkills'].'`0</td>'
.'<td>`^'.$date.'`0</td>'
.'</tr>',true);
$i++;
}
if($i === 5) {
break;
}
}
rawoutput('</table>');
//Ende: Die letzten 5 Drachentöter/innen, 2006 by Eliwood aka Wasili
// Die jüngsten 5 Spieler, 2006 by Eliwood aka Wasili
output('`n`%`bDie jüngsten 5 Spieler/innen:`b`0`n');
$sql = 'SELECT `newsdate`,`accountid` FROM `news` '
.'WHERE `newstext` LIKE "%hat unsere Welt betreten%" ORDER BY `newsdate` DESC';
$result = db_query($sql);
output("<table border='0' cellpadding='2' cellspacing='1' bgcolor='#999999'>",true);
output("<tr class='trhead'><td><b>Name</b></td><td><b>Datum</b></td></tr>",true);
$i = 0;
while($row = db_fetch_assoc($result)) {
$sql2 = 'SELECT `name`,`dragonkills` FROM `accounts` WHERE `acctid` = "'.$row['accountid'].'" LIMIT 1';
$res2 = db_query($sql2);
if(db_num_rows($res2) == 1) {
$row2 = db_fetch_assoc($res2);
$class = ($i%2?"trdark":"trlight");
$date = date('Y-m-d',strtotime($row['newsdate']));
output('<tr>'
.'<td>`&'.$row2['name'].'`0</td>'
.'<td>`^'.$date.'`0</td>'
.'</tr>',true);
$i++;
}
if($i === 5) {
break;
}
}
rawoutput('</table>');
//Ende: Die jüngsten 5 Spieler, 2006 by Eliwood aka Wasili
// Die reichsten 5 Spieler, 2006 by Daisuke, based on Eliwoods Code
output('`n`%`bDie reichsten 5 Spieler/innen:`b`0`n');
$sql = 'SELECT acctid,gold FROM accounts ORDER BY gold DESC';
$result = db_query($sql);
output("<table border='0' cellpadding='2' cellspacing='1' bgcolor='#999999'>",true);
output("<tr class='trhead'><td><b>Name</b></td><td><b>Gold</b></td></tr>",true);
$i = 0;
while($row = db_fetch_assoc($result)) {
$sql2 = 'SELECT `name`,`gold` FROM `accounts` WHERE `acctid` = "'.$row['acctid'].'" LIMIT 1';
$res2 = db_query($sql2);
if(db_num_rows($res2) == 1) {
$row2 = db_fetch_assoc($res2);
$class = ($i%2?"trdark":"trlight");
$date = date('Y-m-d',strtotime($row['newsdate']));
output('<tr>'
.'<td>`&'.$row2['name'].'`0</td>'
.'<td>`^'.$row2['gold'].'`0</td>'
.'</tr>',true);
$i++;
}
if($i === 5) {
break;
}
}
rawoutput('</table>');
//goldenegg
if (getsetting("hasegg",0)>0){
$sql = "SELECT name FROM accounts WHERE acctid = ".getsetting("hasegg",0);
$result1 = db_query($sql) or die(db_error(LINK));
$row = db_fetch_assoc($result1);
output("`@Das `^goldene Ei `@ist im Besitz von `&$row[name]!`n");
}else{
output("`&Niemand `@besitzt zur Zeit das goldene Ei!`n");
}
//orden
if (getsetting("orden",0)>0){
$sql = "SELECT name FROM accounts WHERE acctid = ".getsetting("orden",0);
$result = db_query($sql) or die(db_error(LINK));
$row = db_fetch_assoc($result);
output("`@Der Spieler mit den meisten `^Orden ist: $row[name]!`n");
}
$result = db_fetch_assoc(db_query("SELECT COUNT(acctid) AS onlinecount FROM accounts WHERE locked=0 AND loggedin=1 AND laston>'".date("Y-m-d H:i:s",strtotime("-".getsetting("LOGINTIMEOUT",900)." seconds"))."'"));
$onlinecount = $result['onlinecount'];
// do not check if playerlimit is not reached!
if ($onlinecount >= getsetting("maxonline",10) && getsetting("maxonline",10)!=0) {
$id=$_COOKIE[lgi];
$sql = "SELECT superuser,uniqueid FROM accounts WHERE uniqueid='$id' AND superuser>0";
$result = db_query($sql) or die(db_error(LINK));
if (db_num_rows($result)>0) $is_superuser=1;
else $is_superuser=0;
}
else $is_superuser = 0;
if ($onlinecount<getsetting("maxonline",10) || getsetting("maxonline",10)==0 || $is_superuser){
output("Gib deinen Namen und dein Passwort ein, um diese Welt zu betreten.`n");
if ($_GET['op']=="timeout"){
$session['message'].=" Deine Sessionzeit ist abgelaufen. Bitte neu einloggen.`n";
if (!isset($_COOKIE['PHPSESSID'])){
$session['message'].=" Es scheint, als ob die Cookies dieser Seite von deinem System blockiert werden. Zumindest Sessioncookies müssen für diese Seite zugelassen werden.`n";
}
}
if ($session[message]>"") output("`b`\$$session[message]`b`n");
output("<form action='login.php' method='POST'>"
.templatereplace("login",array("username"=>"<u>N</u>ame","password"=>"<u>P</u>asswort","button"=>"Einloggen"))
."</form>`c",true);
// Without this, I had one user constantly get 'badnav.php' :/ Everyone else worked, but he didn't
addnav("","login.php");
} else {
output("`^`bDer Server ist im Moment ausgelastet, die maximale Anzahl an Usern ist bereits online.`b`nBitte warte, bis wieder ein Platz frei ist.`n`n");
if ($_GET['op']=="timeout"){
$session['message'].=" Deine Sessionzeit ist abgelaufen. Bitte neu einloggen.`n";
if (!isset($_COOKIE['PHPSESSID'])){
$session['message'].=" Es scheint, als ob die Cookies dieser Seite von deinem System blockiert werden. Zumindest Sessioncookies müssen für diese Seite zugelassen werden.`n";
}
}
if ($session[message]>"") output("`b`\$$session[message]`b`n");
output(templatereplace("full")."`c",true);
}
//output("`n`b`&**BETA**`0 This is a BETA of this website, things are likely to change now and again, as it is under active development (when I have time ;-)) `&**BETA**`0`n");
output("`n`b`&".getsetting("loginbanner","*BETA* This is a BETA of this website, things are likely to change now and again, as it is under active development *BETA*")."`0`b`n");
$session[message]="";
output("`c`2Version auf diesem Gameserver: `@{$logd_version}`0`c");
clearnav();
addnav("Neu hier?");
addnav("Über LoGD","about.php");
addnav("F.A.Q.","petition.php?op=faq",false,true);
addnav("Charakter erstellen","create.php");
addnav("Das Spiel");
addnav("Liste der Kämpfer","list.php");
addnav("Tägliche News", "news.php");
addnav("Spieleinstellungen", "about.php?op=setup");
addnav("Passwort vergessen?","create.php?op=forgot");
// addnav("DAS Spielforum","http://www.logd-welt.de/forum/index.php",false,false,true);
addnav("Die LoGD-Welt");
addnav("LoGD Netz","logdnet.php?op=list");
addnav("DragonPrime","http://www.dragonprime.net",false,false,true);
page_footer();
?>