0) { $sql = "SELECT ".(SQL_CACHE==true?"SQL_CACHE":"")." * FROM gilden WHERE gildenid= '".$id."'"; $result = db_query($sql); $session['guild'] = db_fetch_assoc($result); db_free_result($result); $session['guild']['gildenname'] = stripslashes($session['guild']['gildenname']); $session['guild']['gildenprefix'] = stripslashes($session['guild']['gildenprefix']); $sql = "SELECT rankname FROM gildenranks WHERE rankid='".$session['user']['rankid']."'"; $rank = db_fetch_assoc(db_unbuffered_query($sql)); $session['rank'] = $rank['rank']; } } /* Gilde speichern, eigentlich nicht mehr nötig, aber ich lass es mal drinne */ function saveguild($id) { global $session; if($id>0) { $sql="UPDATE `gilden` SET "; // unset($session['house']['houseid']); reset($session[house]); while(list($key,$val)=each($session[house])){ if (is_array($val)){ $sql.="`".$key."` = '".addslashes(serialize($val))."', "; }else{ $sql.="`".$key."` = '".addslashes($val)."', "; } } $sql = substr($sql,0,strlen($sql)-2); $sql.=" WHERE `gildenid` = '".$id."' LIMIT 1"; db_unbuffered_query($sql,LINK); } } /* Zeige Gilden */ function showguilds($id=false,$withlink=false,$detaillink=false) { global $session,$output,$SQL_CACHE; if($id === false) { $output.=""; $output.=""; $sql = "SELECT ".(SQL_CACHE==true?"SQL_CACHE":"")." * FROM gilden WHERE active='1' ORDER BY gildenpunkte DESC"; $result = db_query($sql); $i = 0; while($row = db_fetch_assoc($result)) { $sql = "SELECT ".(SQL_CACHE==true?"SQL_CACHE":"")." name FROM accounts WHERE acctid='".$row['leaderid']."'"; $row2 = db_fetch_assoc(db_unbuffered_query($sql)); $bgcolor = ($i%2==1?"trdark":"trlight"); $output.=""; $i++; } db_free_result($result); } else { $sql = "SELECT ".(SQL_CACHE==true?"SQL_CACHE":"")." * FROM gilden WHERE active='1' AND gildenid='$id'"; $result = db_query($sql); $row = db_fetch_assoc($result); output("

",true); output("`b".stripslashes($row['gildenname'])."`b`n`n"); output("`3~~ Beschreibung `3~~`n`n"); output(stripslashes($row['gildendesc']),true); output("`n`n`3~~ Geschichte `3~~`n`n"); output(stripslashes($row['gildenstory']),true); output("`n`n`3~~ Regeln `3~~`n`n"); output(stripslashes($row['gildenregeln']),true); output("

",true); } } /* Preistafel */ function preistafel() { global $bewerbpreis,$goldprice,$gemprice; rawoutput("

");
  output("");
  output("`2#----------------------------------------------------------------------#");
  output("`2# - `3Bewerbungskosten: `^".bewerbpreis." Gold                                        `2#");
  output("`2# - `3Goldkosten für gegründete Gilde: `^".goldprice." Gold                        `2#");
  output("`2# - `3Edelsteinkosten für gegründete Gilde: `%".gemprice." Edelsteine                `2#");
  output("`2#----------------------------------------------------------------------#");
  rawoutput("

"); } /* Zeilen, 1 Zeile, 2 Spalten */ function rowform($title=false,$input=false) { global $output; if($title===false) { $output.= ""; } else { $output.= ""; } } /* Formular für die Gründung */ function grundform($action,$tool=false) { global $output; $output.="

"; output("Kürzel"); $output.="	"; output("Name der Gilde"); $output.="	"; output("Leader"); $output.="	"; output("Punkte"); if($withlink !== false \|\| $detaillink!==false) { $output.="	"; output("Ops"); } $output.="
"; output(stripslashes($row['gildenprefix'])); $output.="	"; output(stripslashes($row['gildenname'])); $output.="	"; output($row2['name']); $output.="	"; output("`&".$row['gildenpunkte']."`0"); if($withlink !== false \|\| $detaillink===true) { $output.="	"; if($withlink !== false) { output("`&[ `xBewerben `&] \|",true); addnav("",$withlink."&id=".$row['gildenid']); } /* Details (PopUp) */ if($withlink !== false \|\| $detaillink===true) output(" `&[ `xDetails `&]",true); } $output.="
"; $output.= $input; $output.= "
"; $output.= $title; $output.= "	"; $output.= $input; $output.= "

"; rowform("Name der Gilde (Ohne Farbcodes)",""); rowform("Name der Gilde (Mit Farbcode",""); rowform("Prefix (Ohne Farbcodes)",""); rowform("Prefix (Mit Farbcodes)",""); if($tool===true) { rowform("Besitzer",""); } rowform(false,""); $output.="

"; addnav("",$action); } /* Eingabe überprüfen */ function check_input($var) { global $error,$minchar; if($_POST['gildenname_b']!=striptag($_POST['gildenname'])) { $error = "ERROR! Verwende bitte gleiche Namen, danke."; $allow = false; } elseif($_POST['gildenprefix_b']!=striptag($_POST['gildenprefix'])) { $error = "ERROR! Verwende bitte gleiche Prefixe, danke."; $allow = false; } elseif($_POST['gildenname_b']=="" || strlen($_POST['gildenname_b'])maxgold) { $errorart = 4; $error .= "`\$Goldspeicher voll!"; return false; continue; } elseif(($_POST['gems']+$session['guild']['gems'])>maxgems) { $errorart = 5; $error .= "`\$Edelsteinspeicher voll!"; return false; } elseif($_POST['gold'] < 0 || $_POST['gold'] < 0) { $errorart = 6; $error .= "`\$Argh... Cheater! Negative Zahlen zählen nicht!"; } else return true; } if(!function_exists("page_title")) { function page_title($data) { output("`c`b$data`b`c`n",true); } } if(!function_exists("db_unbuffered_query")) { function db_unbuffered_query($sql) { global $session,$dbqueriesthishit,$dbtimethishit; $dbqueriesthishit++; $dbtimethishit -= getmicrotime(); $fname = "db_query"; $r = $fname($sql) or die(($session[user][superuser]>=3 || 1?"

".HTMLEntities($sql)."

":"").db_error(LINK)); $dbtimethishit += getmicrotime(); return $r; } } function showuser_public() { global $output,$session; $sql = "SELECT acctid,name,login,isleader,rankid FROM accounts WHERE memberid='".$session['guild']['gildenid']."' ".page("acctid","accounts","gilden.php?op=members","WHERE memberid='".$session['guild']['gildenid']."'").""; $result = db_query($sql); rawoutput(""); rawoutput(""); rawoutput(""); while($row = db_fetch_assoc($result)) { $result_2 = db_unbuffered_query("SELECT rankname FROM gildenranks WHERE rankid='{$row[rankid]}'"); $raw = db_fetch_assoc($result_2); $bgcolor = ($i%2?"trdark":"trlight"); rawoutput(""); $i++; } rawoutput("

"); output("Name"); rawoutput("	"); output("Aktueller Rang"); rawoutput("
"); output($row['name']); rawoutput("	"); output($raw['rankname']); rawoutput("

"); } if(!function_exists("page")) { function page($callfield,$table,$site,$whereclause,$perpage=30) { // Seitenfunktion 2005 by Eliwood $sql = "SELECT count($callfield) AS c FROM $table ".$whereclause.""; ///output($sql); $result = db_unbuffered_query($sql); $row = db_fetch_assoc($result); $total = $row['c']; $perpage=30; if ($_GET['page']=="") $_GET['page']=1; $pageoffset = (int)$_GET['page']; if ($pageoffset>0) $pageoffset--; $pageoffset*=$perpage; $from = $pageoffset+1; $to = min($pageoffset+$perpage,$total); $limit=" LIMIT $pageoffset,$perpage "; /* Seiten verlinken */ addnav("Seiten"); for ($i=0;$i<$total;$i+=$perpage){ addnav("Seite ".($i/$perpage+1)." (".($i+1)."-".min($i+$perpage,$total).")","$site&page=".($i/$perpage+1)); } return $limit; } } function guild_update($field,$value) { global $session,$link; $sql = "UPDATE gilden SET `$field`='".addslashes($value)."' WHERE gildenid='{$session['guild']['gildenid']}'"; db_query($sql) or die(db_error(LINK)); $session['guild'][$field] = $value; } function show_builded_navs() { global $session; $sql = "SELECT * FROM gilden_ausbau WHERE ownerguild='".$session['guild']['gildenid']."' AND name='marktplatz'"; $result = db_query($sql); if(db_num_rows($result)==1) { addnav("Marktplatz"); $sql = "SELECT * FROM gilden_ausbau WHERE ownerguild='".$session['guild']['gildenid']."' AND name!='marktplatz'"; $result = db_unbuffered_query($sql); while($row = db_fetch_assoc($result)) { addnav($row['name'],"gilden.php?op=build&action=$row[link]"); } } } function is_buildet($what) { global $session; $result = db_query("SELECT * FROM `gilden_ausbau` WHERE link='$what' AND ownerguild='".$session['guild']['gildenid']."'"); if(db_num_rows($result)==1) return true; else return false; } function drop_me($my_acctid,$my_name,$my_leaderid) { global $highestleader,$session; if($my_leaderid >= highestleader) { output("`\$Du darfst die Gilde SO nicht verlassen."); } else { db_unbuffered_query("UPDATE accounts SET isleader='0',memberid='0',gildenactive='0',rankid='0' WHERE acctid='$my_acctid'"); $session['user']['isleader'] = 0; $session['user']['memberid'] = 0; $session['user']['gildenactive'] = '0'; $session['user']['rankid'] = 0; systemmail($session['guild']['leaderid'],"Kündigung","`^".$my_name."`# hat die fristlose Kündigung eingereicht!"); unset($session['guild']); addnav("Zurück zur Gildenstrasse","gildenstrasse.php"); page_header("Gildenstrasse"); page_footer(); exit(); } } ?>