"); rawoutput(""); rawoutput(""); output("Bewerbername"); rawoutput(""); output("Optionen"); rawoutput(""); while($row = db_fetch_assoc($result)) { $bgcolor = ($i%2?"trdark":"trlight"); $login = RawUrlEncode($row['login']); $link = array(1=>"gildenverwalt.php?op=nimm&id=$row[acctid]&login=$login",2=>"gildenverwalt.php?op=ablehn&id=$row[acctid]&login=$login"); rawoutput(""); output($row['name']); rawoutput(""); output("`0[`2Annehmen`0] `0[`^Ablehnen`0]",true); rawoutput(""); allownav($link[1]); allownav($link[2]); $i++; } if($i == 0) { output("`~`b`iKeine Bewerbungen vorhanden`i`b",true); } rawoutput(""); } function showtitles($link = "gildenverwalt.php?op=ranks") { global $session,$output; $sql = "SELECT * FROM gildenranks WHERE gildenid='".$session['guild']['gildenid']."' ORDER BY sortid,rankname DESC ".page("rankid","gildenranks","gildenverwalt.php?op=ranks","WHERE gildenid='{$session['guild']['gildenid']}'").""; $result = db_unbuffered_query($sql); $output .= ""; $output .= ""; $output .= ""; $output .= ""; $i = 0; while($row = db_fetch_assoc($result)) { $bgcolor = ($i%2?"trlight":"trdark"); $output .= ""; $output .= ""; $output .= ""; allownav($link1); allownav($link2); $i++; } $output .= "

"; output("Rangname"); $output .= "	"; output("Optionen"); $output .= "
"; output("`&".stripslashes($row['rankname'])); $output .= "	"; $linkb = $link."&id=".$row['rankid']; $link1 = $linkb."&subop=edit"; $link2 = $linkb."&subop=del"; output("`0`&[`2Rename`&] `0`&[`\$Löschen`&]",true); $output .= "

"; $linkb = $link."&subop=add"; output("`n`n`c[ Rang hinzufügen ]`c",true); allownav($linkb); } function createtitle($id=false) { global $output,$session; if(!isset($_POST['rankname'])) { if($id!==false) { $sql = "SELECT * FROM gildenranks WHERE rankid='$id'"; $row = db_fetch_assoc(db_query($sql)); } $output .= "

"; allownav("gildenverwalt.php?op=ranks&subop=save"); $output .= ""; $output .= ""; $output .= ""); rawoutput(""); rawoutput(""); while($row = db_fetch_assoc($result)) { /* Ränge laden */ $result_2 = db_query("SELECT * FROM gildenranks WHERE gildenid='{$session[guild][gildenid]}' ORDER BY rankid"); $ranklist.=""); $i++; unset($ranklist); unset($acrank); unset($links); } rawoutput("

"; $output .= "Titelname: "; $output .= "	"; $output .= ""; $output .= "
"; $output .= ""; $output .= "	"; $output .= ""; $output .= "
"); output("Name"); rawoutput("	"); output("Aktueller Rang"); rawoutput("	"); output("Optionen"); rawoutput("
"); output($row['name']); rawoutput("	"); output($acrank); rawoutput("	"); $links = array( 1=>"gildenverwalt.php?op=members&action=leader", 2=>"gildenverwalt.php?op=members&action=rank", 3=>"gildenverwalt.php?op=members&action=dropmember&dropid=".$row['acctid'] ); allownav($links[1]); allownav($links[2]); allownav($links[3]); /* Verwalterid zuweisen lassen / output(" ",true); / Rang zuweisen lassen */ output(" " ."" ."" ."" ." `n",true); output("`0[`0`\$Entlassen`0]",true); rawoutput("

"); } function showuser_pay() { global $output,$session; $sql = "SELECT acctid,name,login,isleader,rankid FROM accounts WHERE memberid='".$session['guild']['gildenid']."' AND acctid!='".$session['user']['acctid']."' ".page("acctid","accounts","gildenverwalt.php?op=belohnen","WHERE memberid='".$session['guild']['gildenid']."' AND acctid!='".$session['user']['acctid']."'").""; $result = db_query($sql); rawoutput(""); rawoutput(""); rawoutput(""); while($row = db_fetch_assoc($result)) { $bgcolor = ($i%2?"trdark":"trlight"); rawoutput(""); $i++; } rawoutput("

"); output("Name"); rawoutput("	"); output("Optionen"); rawoutput("
"); output($row['name']);; rawoutput("	"); $links = array(1=>"gildenverwalt.php?op=belohnen&action=gold","gildenverwalt.php?op=belohnen&action=gems"); allownav($links[1]); allownav($links[2]); /* Gold / output(" " ."" ."" ."" ."" ." ",true); / Edelsteine */ output(" " ."" ."" ."" ."" ." ",true); rawoutput("

"); } fuNcTiOn show_text($art) { GlObAl $session; switch ($art): case "desc": $field = "gildendesc"; $ptitle = "Beschreibung ändern"; break; case "story": $field = "gildenstory"; $ptitle = "Geschichte ändern"; break; case "regeln": $field = "gildenregeln"; $ptitle = "Regeln ändern"; break; endswitch; page_title($ptitle); rawoutput("

"); output("`#Aktuell:`n`n"); output(stripslashes($session['guild'][$field]),true); output("`#`n`nÄndern:`n`n"); $link = "gildenverwalt.php?op=texte&text=".$art.""; allownav($link); rawoutput("

"); output("`\$HTML erlaubt, für Absätze ``n oder
verwenden."); rawoutput("

"); } function show_build_navs() { global $session; /* Marktplatz Stufe 1 (Nötig)*/ $result = db_query("SELECT * FROM `gilden_ausbau` WHERE `ownerguild`='".$session['guild']['gildenid']."' AND `name`='Marktplatz'") or die(db_error(LINK)); if(db_num_rows($result)==0) { $row = db_fetch_assoc($result); addnav("Marktplatz bauen (Stufe `^1`0)","gildenverwalt.php?op=build&action=marktplatz&stufe=1"); } /* Sonstiges */ else { $row = db_fetch_assoc($result); $count = db_fetch_assoc(db_unbuffered_query("SELECT COUNT(name) AS count FROM gilden_ausbau WHERE name!='Marktplatz' AND ownerguild='".$session['guild']['gildenid']."'")); $count = $count['count']; $freeplaces = ($row['value1']-$count); // $freeplaces = 0; addnav("Noch ".($freeplaces)." Plätze frei",""); if($freeplaces == 0) { $sql = "SELECT * FROM gilden_ausbau WHERE name='Marktplatz' AND stufe>'$row[stufe]' ORDER BY stufe ASC LIMIT 1"; $result2 = db_query($sql) or die(db_error(LINK)); if(db_num_rows($result2)>0) { $row2 = db_fetch_Assoc($result2); addnav($row['name']." ausbauen (Stufe `^$row2[stufe]`0)","gildenverwalt.php?op=build&action=$row2[link]&stufe=$row2[stufe]"); } else {addnav("Marktplatz nicht weiter ausbaubar","");} } else { $sql_ = "SELECT * FROM gilden_ausbau WHERE ownerguild='0' AND name!='Marktplatz'"; $result2_ = db_query($sql_); while($row2 = db_fetch_assoc($result2_)) { $check_sql = db_query("SELECT * FROM gilden_ausbau WHERE ownerguild='{$session[guild][gildenid]}' AND name='$row2[name]'"); if(db_num_rows($check_sql)==0) { $navlink = ""; if($row2['goldcost']<$session['guild']['gold'] && $row2['gemcost']<$session['guild']['gems']) $navlink = "gildenverwalt.php?op=build&action=".$row2['link']."&stufe=".$row2['stufe']; addnav($row2['name'],$navlink); } // end if } // end while } // end else } // end else } // end function function build_something($what) { global $session; $sql = "SELECT * FROM gilden_ausbau WHERE ownerguild='0' AND link='$what'"; $row = db_fetch_assoc(db_unbuffered_query($sql)); } /* User entlassen */ function drop_member($id) { global $session,$highestleader; $drop_user = db_fetch_assoc(db_unbuffered_query("SELECT name,isleader FROM accounts WHERE acctid='$id'")); if($drop_user['isleader']>=highestleader) { output("`\$ERROR! Du darfst den Gründer nicht entlassen!"); } elseif($session['user']['isleader']0 && $drop_user['isleader']>0) { output("`\$ERROR! Nur der Gründer kann eingesetzte Verwalter entlassen!"); } elseif($id === $session['user']['acctid']) { output("`\$ERROR! Du KANNST dich nicht entlassen, du musst schon deine Kündigung einreichen ;D"); } else { db_unbuffered_query("UPDATE accounts SET isleader='0',memberid='0',gildenactive='0' WHERE acctid='$id'"); output("`c`b`2User ".$drop_user['name']."`2 entlassen!`b`n`c;: ".$highestleader); } } function renameform($action) { global $output,$session; $output.=""; addnav("",$action); } function dropguild($id) { global $session; addnews("`#Die Gilde `@{$session['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 $session['user']['memberid'] = 0; $session['user']['gildenactive'] = '0'; $session['user']['isleader'] = 0; $session['user']['rankid'] = 0; saveuser(); redirect("gildenstrasse.php"); } ?>