". "Name". "Kürzel". "Gründer". "`^Gold". "`%Edelsteine". "Punkte". "Mitglieder". "Aktiviert?". "". "

---

",true ); while($row['all'] = db_fetch_assoc($result['all'])) { $row['counter'] = db_fetch_assoc(db_query("SELECT ".(SQL_CACHE===true?"SQL_CACHE":"")." COUNT(acctid) AS members FROM accounts WHERE memberid='".$row['all']['gildenid']."' AND isleader!='".highestleader."'")); output( "". "".$row['all']['gildenname']."". "".$row['all']['gildenprefix']."". "".$row['all']['login']."". "`^".$row['all']['gold']."". "`%".$row['all']['gems']."". "".$row['all']['gildenpunkte']."". "".$row['counter']['members']."". "".($row['all']['active']?"Ja":"Nein")."". "",true ); $nav = array( $prelink."op=edit&id=".$row['all']['gildenid'], $prelink."op=activate&id=".$row['all']['gildenid']."&active=".$row['all']['active'], $prelink."op=drop&id=".$row['all']['gildenid'] ); allownav($nav[0]); allownav($nav[1]); allownav($nav[2]); output( "Optionen:". "`0`&[ ". "`0`2Bearbeiten `&| ". "`0`^".($row['all']['active']?"Dea":"A")."ktivieren `&| ". "`0`\$Löschen". " `&]`0". "". "

---

",true ); } } function dropguild_su($id) { global $session,$SQL_CACHE; $drop_guild = db_fetch_assoc(db_unbuffered_query("SELECT ".(SQL_CACHE===true?"SQL_CACHE":"")." * FROM gilden WHERE gildenid = '$id'")); addnews("`#Die Gilde `@{$drop_guild['gildenname']}`# wurde von `@{$session['user']['name']}`# aufgelöst."); db_query("DELETE FROM gilden WHERE gildenid='$id' LIMIT 1"); // Gilde löschen db_query("DELETE FROM gildenranks WHERE gildenid='$id' LIMIT 1"); // Ränge löschen db_query("DELETE FROM gilden_ausbau WHERE ownerguild='$id' LIMIT 1"); // Gebäude löschen db_query("DELETE FROM gilden_data WHERE gildenid='$id' LIMIT 1"); // Ausbau-Daten löschen db_query("UPDATE accounts SET isleader='0',memberid='0',gildenactive='0',rankid='0' WHERE memberid='$id'"); // User entlassen } function edit_form($id,$formlink) { global $session,$SQL_CACHE; $input = new input(); $edit_guild = db_fetch_assoc(db_unbuffered_query("SELECT ".(SQL_CACHE===true?"SQL_CACHE":"")." * FROM gilden WHERE gildenid = '$id'")); allownav($formlink); output( "" ."" ,true); rawoutput( "" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ."" ); } function update_guild_su($id) { $edit_guild = db_fetch_assoc(db_unbuffered_query("SELECT ".(SQL_CACHE===true?"SQL_CACHE":"")." gildenname FROM gilden WHERE gildenid = '$id'")); db_query( "UPDATE `gilden` SET " ."`gildenname` = '".addslashes($_POST['gildenname'])."', " ."`gildenname_b` = '".addslashes($_POST['gildenname'])."', " ."`gildenprefix` = '".addslashes($_POST['gildenprefix'])."', " ."`gildenprefix_b` = '".addslashes($_POST['gildenprefix_b'])."', " ."`gold` = '".(is_numeric($_POST['gold'])?$_POST['gold']:0)."', " ."`gems` = '".(is_numeric($_POST['gems'])?$_POST['gems']:0)."', " ."`gildenpunkte` = '".(is_numeric($_POST['gildenpunkte'])?$_POST['gildenpunkte']:0)."', " ."`gildenstory` = '".addslashes($_POST['gildenstory'])."', " ."`gildendesc` = '".addslashes($_POST['gildendesc'])."', " ."`gildenregeln` = '".addslashes($_POST['gildenregeln'])."', " ."`active` = '".$_POST['active']."'" ."WHERE `gildenid`='$id' LIMIT 1" ); output("`c".$edit_guild['gildenname']." geändert!`c`n"); } function activateguild($id,$active) { if($active == 1) { db_unbuffered_query("UPDATE gilden SET active='0' WHERE gildenid='$id'"); } else { db_unbuffered_query("UPDATE gilden SET active='1' WHERE gildenid='$id'"); } output("Die Gilde wurde ".($active==1?"Dea":"A")."ktiviert."); } ?>

Bearbeite: ".$edit_guild['gildenname']."
Name der Gilde (Inkl. Farbcodes)
Name der Gilde (Ohne Farbcodes)
Kürzel (Inkl. Farbcodes)
Kürzel (Ohne Farbcodes)
Gold
Edelsteine
Punkte
Geschichte	".$input->textarea("gildenstory",5,30,stripslashes($edit_guild['gildenstory']))."
Beschreibung	".$input->textarea("gildendesc",5,30,stripslashes($edit_guild['gildendesc']))."
Regeln	".$input->textarea("gildenregeln",5,30,stripslashes($edit_guild['gildenregeln']))."
Aktiviert?	".$input->select("active",$edit_guild['active'],1,array("value"=>0,"name"=>"Nein"),array("value"=>1,"name"=>"Ja"))."
".$input->button("Änderungen übernehmen")."