ilch.de :: Forum :: Ilch Clan 1.1 :: Module und Modifikationen

Dürfte nicht der fall sein, habe wie in der anleitung beschrieben die zeilen ergänzt den rest kopiert.
Wobei bei bbcode2.0 ja keine datein vom raidplaner bei sind die er überschreiben hätte können??

hier ma die raid.php
<?php
#   Copyright by: Benjamin Brauns
#   Support: www.Manticors-Thorn.de
#
				/*
				-9 = Admin
				-8 = CoAdmin
				-7 = SiteAdmin
				-6 = Leader
				-5 = CoLeader
				-4 = Member
				*/

defined ('main') or die ( 'no direct access' );
defined ('admin') or die ( 'only admin access' );

$um = $menu->get(1);				// Menü auslesen z.b. admin.php?raid-(XYZ)

#########################################################################
$charda = db_num_rows(db_query("SELECT CID FROM prefix_wowchars"));

switch ( $um ) {

	case 'charview' :
				$design = new design ( 'Admins Area', 'Admins Area', 2 );
				$design->header();
				$tpl = new tpl ('raid/raid-charview', 1);
				$tpl->out(0);
	

	// Char anlegen
		if ($_POST['veraendern'] == "Anlegen"){
			// Alle Felder überprüfen
			if (!empty($_POST['UID']) AND !empty($_POST['charname'])  AND !empty($_POST['klasse']) AND !empty($_POST['rasse']) AND !empty($_POST['level']) AND !empty($_POST['sex']) AND !empty($_POST['gilde'])) {
			echo "User wurde angelegt";
			db_query("INSERT INTO prefix_wowchars (UID, name, klasse, rasse, sex, level, skill, rosterlink, CID, gilde, 1anm, onoff, work1, work2) VALUES ('".$_POST['UID']."', '".$_POST['charname']."', '".$_POST['klasse']."', '".$_POST['rasse']."', '".$_POST['sex']."', '".$_POST['level']."', '".$_POST['skill']."', '', '', '".$_POST['gilde']."', '', '', '".$_POST['work1']."', '".$_POST['work2']."')");
			db_query("INSERT INTO prefix_Raid_DKP VALUES ('".$_POST['UID']."', '0')");
			echo mysql_error();
			} else { 
			
			echo "Es fehlt ein Muss Feld. In der Hilfe ( Rechte seite ) findest du alle notwendigen Infoprmationen.";
			}
		}
	
	
	// Char zuteilen:
		if ($_POST['veraendern'] == "Ändern"){
			if ($_POST['RAIDSELECT'] != "") {
			if (!db_result(db_query("SELECT uid FROM prefix_RaidMember WHERE uid = '".$_POST['UID']."' AND rid = '".$_POST['RAIDSELECT']."'"), 0)) {
				db_query("INSERT INTO prefix_RaidMember (RMID, uid, rid, zusage, eingeteilt, kom,  WoWc,leader , dkp, zsdate) VALUES ('', '".$_POST['UID']."', '".$_POST['RAIDSELECT']."', '1', '','Eintrag durch Admin',  '".$_POST['CID']."', '', '', '')");
				echo mysql_error();
				echo "Der User wurde dem Raid zugeteilt.";
			} else {
	// Char zuteilung ändern
				
			//	echo "Der im Raid Aktive Char des User wurde gewechselt.";
			}
			}
			
			if ($_POST['raidmove'] != "") {
			db_query("UPDATE prefix_RaidMember SET WoWc = '".$_POST['CID']."' WHERE uid = '".$_POST['UID']."' AND rid = '".$_POST['raidmove']."'");
			echo mysql_error();
			}
			
			$_POST['charname'] = ltrim(rtrim($_POST['charname']));
			db_query("UPDATE prefix_wowchars SET UID = '".$_POST['UID']."', name = '".$_POST['charname']."', klasse = '".$_POST['klasse']."', rasse = '".$_POST['rasse']."', sex = '".$_POST['sex']."', level = '".$_POST['level']."', skill = '".$_POST['skill']."', rosterlink = '".$_POST['rosterlink']."', gilde = '".$_POST['gilde']."', 1anm = '".$_POST['1anm']."', onoff = '".$_POST['onoff']."', work1 = '".$_POST['work1']."', work2 = '".$_POST['work2']."' WHERE CID = '".$_POST['CID']."'");
			echo mysql_error();
		}
		
	// Char Löschen
		if (!empty($_GET['delete'])) {
			db_query('DELETE FROM prefix_wowchars WHERE CID = '.$_GET['delete']);
			db_query('DELETE FROM prefix_RaidMember WHERE WoWc = '.$_GET['delete']);
			echo mysql_error();
		}
		

	// Alle Chars sortiert nach Usern auslesen

		$charSQL = db_query("SELECT *  FROM prefix_wowchars ORDER BY UID ASC");
		echo mysql_error();
		while($rowCHAR = db_fetch_assoc($charSQL)) {
			$row['charname'] .= '<option>'.$rowCHAR['name'].'</option>'."\n";
		}
		$tpl->set_ar_out ( $row,1 );
	
	// Char bearbeiten
		if ($_POST['AUSWAHL'] == "Auswahl" OR $_POST['CharName_wahl'] != "") {	
		if (!empty($_POST['CharName_wahl'])) {
		$_POST['CharName'] = $_POST['CharName_wahl'];
		}
		$charSQL = db_query("SELECT *  FROM prefix_wowchars WHERE name = '".$_POST['CharName']."' ORDER BY UID ASC");
		echo mysql_error();
		$row = db_fetch_assoc($charSQL); 
		$UserName = db_result(db_query("SELECT name FROM prefix_user WHERE id = '".$row['UID']."'"),0);
			$row['username'] = "<input type='hidden' name='UID' value='".$row['UID']."' /> ".$UserName;
			$row['level'] = arlistee($row['level'],get_level_array());
			$row['klasse'] = arlistee($row['klasse'],get_klasse_array());
			$row['work1'] = arlistee($row['work1'],get_work_array());
			$row['work2'] = arlistee($row['work2'],get_work_array());
			$row['rasse'] = arlistee($row['rasse'],get_rasse_array());
			$row['skill'] = arlistee($row['skill'],get_skill_array());
			$row['sex'] = arlistee($row['sex'],get_sex_array ());
			$row['gilde'] = '<input type="text" name="gilde" id="gilde" value="'.$row['gilde'].'" size="15" \>';
			$row['UID'];
			$row['CID'];
			$row['CharName_wahl'] = $_POST['CharName'];
	// wurde KEIN Char ausgewählt, wird alles so gesetzt, damit man einen Neuen Char anlegen könnte
			if ($_POST['CharName'] == "") {
			$row['RAIDMOVE'] = "";
			$row['veraendern'] = "Anlegen";
			$row['rechtD'] = "";
	// Die Benutzer ausesen zum erstellen eines Chars 
			$user = db_query("SELECT id, name FROM prefix_user");
			while ($rowU = db_fetch_assoc($user)) {
				$alleUser .= '<option value="'.$rowU['id'].'">'.$rowU['name'].'</option>'."<br />\n";
			}
			$row['username'] = '<select size="1"  name="UID">'.$alleUser.'</select>';
			$row['charname'] = '<input type="text" name="charname" id="charname" value="" \>';
			
			} else {
			$RaidMengeSQL = db_query("SELECT rid FROM prefix_RaidMember WHERE uid = '".$row['UID']."'");
			$RaidMenge = db_num_rows($RaidMengeSQL);

			while($go = db_fetch_assoc($RaidMengeSQL)) {
				$raidnameSQL = db_query("SELECT instanz FROM prefix_Raid WHERE id = '".$go['rid']."'");
				$instanzNr = db_result($raidnameSQL, 0);
				$instanzName = db_result(db_query("SELECT name FROM prefix_RaidInstanz WHERE RIID = '".$instanzNr."'"), 0);
				echo mysql_error();
				$Raids2Move .= '<option value="'.$go['rid'].'">'.$instanzName.'</option>';
			}
			 $Raids2Move = '<select size="'.$RaidMenge.'" name="raidmove" id="raidmove" />'.$Raids2Move.'</select><br />';
			If ($RaidMenge == 0) {
			$row['RAIDMOVE'] = "";
			}else{
			$row['RAIDMOVE'] = "Der User ist zugeteilt f&uuml;r:<br />\n".$Raids2Move;
			}
			$row['charname'] = '<input type="text" name="charname" value=" '.$row['name'].'" />';
			$row['veraendern'] = '&Auml;ndern';
			if ( $_SESSION['authid'] == $row['uid'] OR $_SESSION['authright'] <= $allgAr['raid-edit-L'] ) {
				$row['rechtD'] = '<a href="javascript:del(\''.$row['CID'].'\')"'.'"><img src="include/images/icons/del.gif" alt="Löschen" width="15" height="13" title="Löschen" /></a> ';
			} else {
				$row['rechtD'] = "";
			}
			}
			$row['rechtE'] = "";
			
			} else {
	// Ab hier wenn die Felder leer sind.
			
	// Die Benutzer ausesen zum erstellen eines Chars 
			$user = db_query("SELECT id, name FROM prefix_user");
			while ($rowU = db_fetch_assoc($user)) {
				$alleUser .= '<option value="'.$rowU['id'].'">'.$rowU['name'].'</option>'."<br />\n";
			}
			$row['charname'] = '<input type="text" name="charname" id="charname" value="" \>';
			$row['UID'];
			$row['CID'];
			$row['sex'] = arlistee($row['sex'],get_sex_array ());
			$row['work1'] = arlistee($row['work1'],get_work_array());
			$row['work2'] = arlistee($row['work2'],get_work_array());			
			$row['rasse'] = arlistee($row['rasse'],get_rasse_array());
			$row['level'] = arlistee($row['level'],get_level_array());
			$row['klasse'] = arlistee($row['klasse'],get_klasse_array());
			$row['rechtD'] = "";
			$row['gilde'] = '<input type="text" name="gilde" id="gilde" value="" size="15" \>';
			$row['rechtE'] = "";
			$row['username'] = '<select size="1"  name="UID">'.$alleUser.'</select>';
			$row['skill'] = arlistee($row['skill'],get_skill_array());
			$row['veraendern'] = "Anlegen";
			$row['RAIDMOVE'] = "";
			}
			// Hier eine schleife bauen, der alle zweiten werte ausfiltert.
			
	// Auslesen der offenen Raids	
		$openRAIDSsql = db_query("SELECT * FROM prefix_Raid WHERE status = '1'");
		echo mysql_error();
		while($rowOR = db_fetch_assoc($openRAIDSsql)) {
		$openRAID[] = $rowOR['id'];
		$openRAID[] = $rowOR['instanz'];
		}
			$c = 0;
			foreach($openRAID as $WERT) {
			if ($c == 1) {
			$sql = db_query("SELECT name FROM prefix_RaidInstanz WHERE RIID = ".$WERT);
			$RAIDname = db_result($sql, 0);
			$row['openraid'] .= $RAIDname.'</option>';
			$c = $c - 1;
			}else{
			$row['openraid'] .= '<option value="'.$WERT.'">';
			$c = $c + 1;
			}
			}
			
			$tpl->set_ar_out ( $row,2 );
				
		$tpl->out(3);
		$design->footer();	
	break;

	case 'dkp' :					
				$design = new design ( 'Admins Area', 'Admins Area', 2 );
				$design->header();
				$tpl = new tpl ('raid/raid-dkp', 1);
				$tpl->out(0);
				
		if (isset($_POST[DKPberech])) {
			$operator = strpos($_POST['DKPdiffrenz'], "-");
			switch ($operator) {

			case "-":
				$dkp_haben = $_POST['DKPhaben'] - $_POST['DKPdifferenz'];
				db_query("UPDATE prefix_Raid_DKP SET dkp = '".$dkp_haben."' WHERE uid = '".$_POST['uid']."'" );
				echo mysql_error();
				break;
			default:
				$dkp_haben = $_POST['DKPhaben'] + $_POST['DKPdifferenz'];
				db_query("UPDATE prefix_Raid_DKP SET dkp = '".$dkp_haben."' WHERE uid = '".$_POST['uid']."'" );
				echo mysql_error();		
			}
		}
				
				
if ( $_POST['suche'] == "" ) { $_POST['suche'] = "%"; }

	$sqlid = db_query('SELECT distinct(UID) FROM prefix_wowchars');
	$c = 0;
	$RUID[$c] = 0;
			while ($row = db_fetch_assoc($sqlid)) {
			if (array_key_exists($row['UID'], $RUID) == FALSE) {
				$RUID[$c] = $row['UID'];
				$c = $c + 1;
			}
			}
	$TMPc = $c;
	$c = 0;
			while ($c < $TMPc) {
				$sqluser = db_query("SELECT name FROM prefix_user WHERE id = ".$RUID[$c]);	
				$RuserName = db_fetch_assoc($sqluser);
				$row['account'] = $RuserName['name'];
				echo mysql_error();
						$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite' );
						$row['class'] = $class;
						$row['uid'] = $RUID[$c];										
						#----Komplett DKP
						$ergSUM = db_query("SELECT dkp FROM prefix_Raid_DKP WHERE uid = '".$RUID[$c]."'");
						$DKP = db_fetch_assoc($ergSUM);
						echo mysql_error();
						$row['DKPzg'] = $DKP['dkp'];
						$row['DKPDIFF'] = "";
						$tpl->set_ar_out ( $row,1 );
						$c = $c + 1;
			}

				$design->footer();	
				#----------
		break;
	case 'inst' :
				#--inst---------------------------------------------------------------------
				//---
						// Insztanzen Update		
						if ( $_POST['sub'] == "Update") {		
								#db_query("UPDATE prefix_RaidMember SET dkp = '".$_POST['dkp']."', eingeteilt = '".$_POST['eingeteilt']."' WHERE RMID = '".$menu->get(3)."'");
								db_query("UPDATE prefix_RaidInstanz SET name = '".$_POST['Name']."', beschr = '".$_POST['beschr']."', gruppemax = '".$_POST['gruppemax']."', levelmin = '".$_POST['levelmin']."', pix = '".$_POST['pix']."', RIDKP = '".$_POST['RIDKP']."' WHERE RIID = '".$_POST['RIID']."'");
								echo mysql_error();
								}				
				//---
				$design = new design ( 'Admins Area', 'Admins Area', 2 );
				$design->header();
				$tpl = new tpl ('raid/raid-inst', 1);	

				// inst auslesen
				$erg = db_query("SELECT * FROM prefix_RaidInstanz WHERE RIID = '".$menu->get(2)."'");
				$row = db_fetch_assoc($erg);		// Raid Ausgeben
				
				// leres Array erzeugen
					if ( db_num_rows ( $erg ) == 0 ) {
						$row = array (
										"name"=>"", "beschr"=>"", "pix"=>"no", "RIDKP"=>""
										);
					}
				// --------------------
				
				$row['gruppemax'] = arlistee ( $row['gruppemax'] , get_groese_array() );
				$row['levelmin'] = arlistee ( $row['levelmin'] , get_level_array() );
				$row['RIDKP'];
				$tpl->set_ar_out($row,0);
				
						#----------------------------------------------
						$abf = "SELECT * FROM prefix_RaidInstanz";
						$erg = db_query($abf);
							while ($row = db_fetch_assoc($erg) ) {
									$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite' );
									$row['class'] = $class;
									$row['RIID'];
									$row['name'];
									$row['gruppemax'];
									#$row['gruppemax'] = arlistee ( $row['gruppemax'] , get_groese_array() );
									$row['beschr'];
									$row['gametype'];
									$row['RIDKP'];

								$tpl->set_ar_out ( $row,3 );
								$tpl->out(1);
									}
								#$tpl->set ( 'MPL', $MPL );

				$design->footer();
				#----------		
		break;
	case 'add' :
				#--- ADD -----------------------------------------------------------------
				$design = new design ( 'Admins Area', 'Admins Area', 2 );
				$design->header();
				$tpl = new tpl ('raid/raid-add', 1);
				$_ilch['now'] = date("Y-m-d H:i:s");	// Datum/ Uhrzeit anzeige
		#$msg = "test msg"; // DEBUG
		$tpl->set('msg' ,$msg);

		// Raid eintragen
		if ( $_POST['sub'] == "Erstellen" AND $_POST['instanz'] != "-" ) {
							db_query("INSERT INTO prefix_Raid (uid,datime,text,instanz,status,groese,bosse,loottyp,leader,level,treff,start,end) VALUES ('".$_SESSION['authid']."','".get_dattime()."','".$_POST['text']."','".$_POST['instanz']."','".$_POST['status']."','".$_POST['groese']."','".$_POST['bosse']."','".$_POST['loottyp']."','".$_POST['leader']."','".$_POST['level']."','".$_POST['treff']."','".get_start()."','".get_end()."')");
		#--------------------------------------------
		# in den kalender eintragen wenn gewuenscht
        if (isset($_POST['kalender']) AND $_POST['kalender'] == 'yes') {
          $timestamp = strtotime(get_dattime());
          $page = str_replace('admin.php','index.php',$_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"]);
				$_POST['instanz'] = dbwert ( $_POST['instanz'], "SELECT RIID, name FROM prefix_RaidInstanz WHERE RIID = '".$_POST['instanz']."'");
				#echo mysql_error();
          db_query("INSERT INTO prefix_kalender (time, title, text, recht) VALUES (".$timestamp.",'Raid: ".$_POST['instanz']."', '".$_POST['groese']."er Gruppe, Treffpunkt: ".$_POST['treff'].", ab level ".$_POST['level']." \n\n[url=http://".$page."?raid-show-".$_POST['idX']."]>> Details des Raids[/url]', 0)");
        }
		#--------------------------------------------
								$msg = "Raid wurde erstellt";
								}
				// leres Array erzeugen
			if ( $menu->get(2) == "add" OR $menu->get(2) == "") { 
				$_ilch = array (
							"leader"=>"", "bosse"=>"", "treff"=>"", "text"=>""
							);
			#---- Datum/Uhrzeit ANZEIGE
			$_ilch['jahr'] = date("Y"); $_ilch['mon'] = date("m"); $_ilch['day'] = date("d"); $_ilch['stu'] = date("H"); $_ilch['min'] = date("i");
			$_ilch['stu'] = date("H"); $_ilch['min'] = "00";
			$_ilch['stuS'] = date("H"); $_ilch['minS'] = "00";
			$stuE = date("H"); $stuEP = $stuE +3;
			#$_ilch['stuE'] = $stuEP;//date("H"); // Jetztzeit + 3 Stunden
			#$_ilch['minE'] = "00";
			$_ilch['stuE'] = ""; $_ilch['minE'] = "";	// OFFEN
			$_ilch['leader'] = $_SESSION['authname'];
				$_ilch['instanz'] = dblistee ( $_ilch['instanz'], "SELECT RIID, name FROM prefix_RaidInstanz ORDER BY '".$_POST['instanz']."'");
				$_ilch['loottyp'] = arlistee ( $_ilch['loottyp'] , get_loot_array() );
				$_ilch['groese'] = arlistee ( $_ilch['groese'] , get_groese_array() );
				$_ilch['level'] = arlistee ( $_ilch['level'] , get_level_array() );
				$_ilch['msg'] = ( isset ($msg) ? $msg : '' );
				$bosseSql = db_query("SELECT * FROM prefix_RaidBosse");
				while($boss = db_fetch_assoc($bosseSql)){
				$_ilch['bosse'] .= '<option value ="'.$boss['RBID'].'">'.$boss['name'].'</option>';
				}
			
			}
				$tpl->set_ar_out($_ilch,0);
							
				$design->footer();	
				#---------
		break;
case 'show' :
				#----SHOW ---------------------------------------------------------------
				$design = new design ( 'Admins Area', 'Admins Area', 2 );
				$design->header();
				$tpl = new tpl ('raid/raid-show', 1);

		// Raid updaten
		if ($_POST['sub'] == "Ändern") {
					db_query("UPDATE prefix_Raid SET datime = '".get_dattime()."', end = '".get_end()."', start = '".get_start()."', text = '".$_POST['text']."', instanz = '".$_POST['instanz']."', status = '".$_POST['status']."', groese = '".$_POST['groese']."', bosse = '".$_POST['bosse']."', loottyp = '".$_POST['loottyp']."', leader = '".$_POST['leader']."', level = '".$_POST['level']."', treff = '".$_POST['treff']."' WHERE id = '".$menu->get(2)."'");
		//------Kallender Eintrag -------
        if (isset($_POST['kalender']) AND $_POST['kalender'] == 'yes') {
          $timestamp = strtotime(get_dattime());
          $page = str_replace('admin.php','index.php',$_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"]);	$idX = $_POST['idX'];
          if (1 == db_result(db_query("SELECT COUNT(*) FROM prefix_kalender WHERE text like '%raid-show-".$idX."]%'"),0)) {
				$_POST['instanz'] = dbwert ( $_POST['instanz'], "SELECT RIID, name FROM prefix_RaidInstanz WHERE RIID = '".$_POST['instanz']."'");
            db_query("UPDATE prefix_kalender SET time = ".$timestamp.", title = 'Raid: ".$_POST['instanz']."', text = '".$_POST['groese']."er Gruppe, Treffpunkt: ".$_POST['treff'].", ab level ".$_POST['level']." \n\n".$_POST['text']." \n\n[url=http://".$page."?raid-show-".$_POST['idX']."]>> Details des Raids[/url]' WHERE text like '%raid-show-".$idX."]%'");
         } else {
				$_POST['instanz'] = dbwert ( $_POST['instanz'], "SELECT RIID, name FROM prefix_RaidInstanz WHERE RIID = '".$_POST['instanz']."'");
          db_query("INSERT INTO prefix_kalender (time, title, text, recht) VALUES (".$timestamp.",'Raid: ".$_POST['instanz']."', '".$_POST['groese']."er Gruppe, Treffpunkt: ".$_POST['treff'].", ab level ".$_POST['level']." \n\n".$_POST['text']." \n\n[url=http://".$page."?raid-show-".$_POST['idX']."]>> Details des Raids[/url]', 0)");
        }
		}
		// DKP Punkte für eine erfolgreiche Teilnahme zuordenen 
		if ( $allgAr['raid-dkp-active'] == 1 ){
		// Beim beenden des Raids werden dem User die Instanz DKP's gutgeschrieben
		if ($_POST['status'] == "2" AND ($_POST['loottyp'] == "4" OR $_POST['loottyp'] == "5")) {

			$RMEM = db_query("SELECT uid FROM prefix_RaidMember WHERE rid = '".$menu->get(2)."' AND zusage = '1' AND (eingeteilt = '1' OR eingeteilt = '4')");
			echo mysql_error();
			while ($RMEMerg = db_fetch_assoc($RMEM)) {
				$DKPuknkte = db_result(db_query("SELECT dkp from prefix_Raid_DKP WHERE uid = '".$RMEMerg['uid']."'"), 0);
				echo mysql_error();
				$DKPinstanz = db_result(db_query("SELECT RIDKP from prefix_RaidInstanz WHERE RIID = '".$menu->get(2)."'"), 0);
				$DKPges = $DKPuknkte + $DKPinstanz;
				db_query("UPDATE prefix_Raid_DKP SET dkp = '".$DKPges."' WHERE uid = '".$RMEMerg['uid']."'");
			}
		}
		// Beim wieder öffnen des Raids werden die Indstanz DK Punkte dem User wieder abgezogen.
		if ($_POST['status'] == "1" AND ($_POST['loottyp'] == "4" OR $_POST['loottyp'] == "5")) {

			$RMEM = db_query("SELECT uid FROM prefix_RaidMember WHERE rid = '".$menu->get(2)."' AND zusage = '1' AND (eingeteilt = '1' OR eingeteilt = '4')");
			echo mysql_error();
			while ($RMEMerg = db_fetch_assoc($RMEM)) {
				$DKPuknkte = db_result(db_query("SELECT dkp from prefix_Raid_DKP WHERE uid = '".$RMEMerg['uid']."'"), 0);
				echo mysql_error();
				$DKPinstanz = db_result(db_query("SELECT RIDKP from prefix_RaidInstanz WHERE RIID = '".$menu->get(2)."'"), 0);
				$DKPges = $DKPuknkte - $DKPinstanz;
				db_query("UPDATE prefix_Raid_DKP SET dkp = '".$DKPges."' WHERE uid = '".$RMEMerg['uid']."'");
			}
		}
		}
		}
		// RaidMember Update		
		if ( $_POST['sub'] == "update") {		
		
		if ($_POST['eingeteilt'] == 1 OR $_POST['eingeteilt'] == 4)	{
			db_query("UPDATE prefix_RaidMember SET eingeteilt = '".$_POST['eingeteilt']."' WHERE RMID = '".$menu->get(3)."'"); // , zusage = 1
			echo mysql_error();
		} else {
			db_query("UPDATE prefix_RaidMember SET eingeteilt = '".$_POST['eingeteilt']."' WHERE RMID = '".$menu->get(3)."'"); // , zusage = 0
			echo mysql_error();
		}
		
			$operator = strpos($_POST['dkp'], "-");
			switch ($operator) {

			case "-":
				$dkp_haben = $_POST['DKPhaben'] - $_POST['dkp'];
				db_query("UPDATE prefix_Raid_DKP SET dkp = '".$dkp_haben."' WHERE uid = '".$_POST['RuserID']."'" );
				echo mysql_error();
				break;
			default:
				$dkp_haben = $_POST['DKPhaben'] + $_POST['dkp'];
				db_query("UPDATE prefix_Raid_DKP SET dkp = '".$dkp_haben."' WHERE uid = '".$_POST['RuserID']."'" );
				echo mysql_error();		
			}
							
		}
				
				// Raid auslesen
				$erg = db_query("SELECT DATE_FORMAT(datime,'%d.%m.%Y.%H.%i.%s') as datime,id,uid, instanz, bosse, groese, status, loottyp, text, leader, level, treff, DATE_FORMAT(start,'%d.%m.%Y.%H.%i.%s') as start, DATE_FORMAT(end,'%d.%m.%Y.%H.%i.%s') as end FROM prefix_Raid WHERE id = '".$menu->get(2)."'");
				$_ilch = db_fetch_assoc($erg);		// Raid Ausgeben
			if ( $_SESSION['authid'] ==	$_ilch['uid'] OR $_SESSION['authright'] == "-9" ) { // Link Check, is create USER oder ADMIN!
	
						if ( !empty ( $_GET['delete'] ) ) {
							# aus kalender loeschen fals vorhanden
							#db_query("DELETE FROM prefix_kalender WHERE text like '%raid-show-".$_GET['delete']."]%'");
							db_query("DELETE FROM prefix_Raid WHERE id = '".$_GET['delete']."'");
							@db_query("DELETE FROM prefix_RaidMember WHERE rid = '".$_GET['delete']."'");
							$msg = '<tr class="Cmite"><td colspan="3">Erfolgreich gel&ouml;scht</td></tr>';
							}
				// --------------------
				#-- Rechte --- 
			if ( $_SESSION['authright'] == "-9") {
					$_ilch['rechtD'] = '<a href="javascript:del(\''.$_ilch['id'].'\')"'.'"><img src="include/images/icons/del.gif" alt="Löschen" width="15" height="13" title="Löschen" /></a>';
					} else {
					$_ilch['rechtD'] = "";;
					}
				#-------------
				$_ilch['Cuser'] = dblistee ( $_ilch['uid'], "SELECT id, name FROM prefix_user WHERE id = '".$_ilch['uid']."'");	
			// Boss Typen auslesen	
				$bossNr = db_result(db_query("SELECT bosse FROM prefix_Raid WHERE id = '".$menu->get(2)."'"), 0);
				$bossWahl = db_result(db_query("SELECT name FROM prefix_RaidBosse WHERE RBID = '".$bossNr."'"), 0);
				$bosseSql = db_query("SELECT * FROM prefix_RaidBosse");
				$_ilch['bosse'] = '<option></option>';
				while($boss = db_fetch_assoc($bosseSql)){
					$a = '';
					if ($bossWahl == $boss['name']) {
					$a = "selected";
					}
					$_ilch['bosse'] .= '<option value ="'.$boss['RBID'].'" '.$a.'>'.$boss['name'].'</option>';
				}
				
				list(
				$_ilch['day'],$_ilch['mon'],$_ilch['jahr'],$_ilch['stu'],$_ilch['min'],$_ilch['sek']
				) = explode('.',$_ilch['datime']);
							
				list($_ilch['dayS'],$_ilch['monS'],$_ilch['jahrS'],$_ilch['stuS'],$_ilch['minS'],$_ilch['sekS']) = explode('.',$_ilch['start']);
				list($_ilch['dayE'],$_ilch['monE'],$_ilch['jahrE'],$_ilch['stuE'],$_ilch['minE'],$_ilch['sekE']) = explode('.',$_ilch['end']);
			
				$_ilch['instanz'] = dblistee ( $_ilch['instanz'], "SELECT RIID, name FROM prefix_RaidInstanz ORDER BY '".$_POST['instanz']."'");
				$_ilch['status'] = arlistee ( $_ilch['status'] , get_status_array() );
				$_ilch['loottyp'] = arlistee ( $_ilch['loottyp'] , get_loot_array() );
				$_ilch['groese'] = arlistee ( $_ilch['groese'] , get_groese_array() );
				$_ilch['level'] = arlistee ( $_ilch['level'] , get_level_array() );
				
				#print_r($_ilch);		// DEBUG
							
				$tpl->set_ar_out($_ilch,0);
				

						// Angemeldete Chars pro Raid
						$abf = "SELECT * FROM prefix_RaidMember WHERE rid = '".$menu->get(2)."' ORDER BY zusage";
						$erg = db_query($abf);
							while ($row = db_fetch_assoc($erg) ) {
									$class = ($class == 'Cmite' ? 'Cnorm' : 'Cmite' );
									$row['class'] = $class;
									$row['RMID'];
									$row['uid'];
									$row['dkp'] = db_result(db_query("SELECT dkp FROM prefix_Raid_DKP WHERE uid = ".$row['uid']), 0);
									$row['rosterlink'];
									$row['WoWc'];
									$row['charname'] = dblistee ( $row['charname'], "SELECT * FROM prefix_wowchars WHERE CID = '".$row['WoWc']."'");
								// ROLLOVER effekte
								// --------
									$row['ROname'] = dbwert ( $row['ROname'], "SELECT CID,name FROM prefix_wowchars WHERE CID = '".$row['WoWc']."'");
									$row['ROklasse'] = dbwert ( $row['ROklasse'], "SELECT CID,klasse FROM prefix_wowchars WHERE CID = '".$row['WoWc']."'");
									$row['ROgilde'] = dbwert ( $row['ROgilde'], "SELECT CID,gilde FROM prefix_wowchars WHERE CID = '".$row['WoWc']."'");
									$row['ROlevel'] = dbwert ( $row['ROlevel'], "SELECT CID,level FROM prefix_wowchars WHERE CID = '".$row['WoWc']."'");
									$row['ROskill'] = dbwert ( $row['ROskill'], "SELECT CID,skill FROM prefix_wowchars WHERE CID = '".$row['WoWc']."'");
									$row['ROLLOVER'] = "'Level ".$row['ROlevel']." ".$row['ROklasse']."<br />Skill : ".$row['ROskill']."<br />',CAPTION,'".$row['ROname']." : ".$row['ROgilde']."',WRAP";
								// --------
									$row['dkp'];
									$row['kom'];
									$row['uid'];
									$row['rid'];
									#$row['zusage'];
									if ($row['zusage'] == "0"){ $row['zusage'] = 'noch keine Angabe';}  // black Anzeige
									if ($row['zusage'] == "1"){ $row['zusage'] = '<font color="#009900">zusage</font>';}	// grüne Anzeige
									if ($row['zusage'] == "2"){ $row['zusage'] = '<font color="#CC6600">ersatz</font>';}	// orange ANzeige
									if ($row['zusage'] == "3"){ $row['zusage'] = '<font color="#FF0000">absage</font>';}	// rote Anzeige
									if ($row['zusage'] == "4"){ $row['zusage'] = "leader";}
									
									$row['eingeteilt'] = arlistee ( $row['eingeteilt'] , get_eingeteilt_array() );
									
													#print_r($row);		// DEBUG
													#echo "<br>";		// DEBUG

								$tpl->set_ar_out ( $row,3 );
													
								$tpl->out(1);
							}
									#show_rechte();	// DEBUG
			} else {
							echo '<font color="#FF0000">ERROR: Linkfehler</font>';
							}			
						$tpl->out(2); // HILFE				
				$design->footer();	
				#---------
		break;
		default:
		#case 'list' :
		#---- DEFAULT ---------------------------------------------------------
				$design = new design ( 'Admins Area', 'Admins Area', 2 );
				$design->header();
				$tpl = new tpl ( 'raid/raid_list', 1 );		

$tpl->out(0);
$tpl->out(1);
				$class = '';					
						$abfN = "SELECT 
									instanz, 
									leader,
									groese, 
									datime,
									status,
									uid,
									prefix_Raid.id as Rid, 
									prefix_RaidInstanz.RIID as Iid, 
									prefix_RaidInstanz.name as Iname
								FROM prefix_Raid LEFT JOIN prefix_RaidInstanz ON prefix_RaidInstanz.RIID = prefix_Raid.instanz 
									ORDER BY status,datime";

					$ergN = db_query($abfN);
		while ($row = db_fetch_assoc($ergN) ) {
			$row['instanz'] = $row['Iname'];
			$row['groese'];
			$row['id'] = $row['Rid'];
			$row['datime'];
			switch ( $row['status']) {
				case '1' :	$row['status'] = '<font color="#009900">OFFEN</font>';	break;
				case '2' :	$row['status'] = '<font color="#FF0000">BEENDET</font>';	break;
				case '3' :	$row['status'] = '<font color="#FFEE00">ABGESAGT</font>';	break;}
			$row['erst'] = dblistee ( $row['erst'], "SELECT id, name FROM prefix_user WHERE id = '".$row['uid']."'");
		// editrecht
		$reditL = $allgAr['raid-edit-L'];
		if ( $_SESSION['authid'] == $row['uid'] OR $_SESSION['authright'] <= $allgAr['raid-edit-L'] ) {
			// if ( $_SESSION['authid'] == $row['uid'] OR $_SESSION['authright'] <= "-6" ) {	// $allgAr['raid-edit-L']
				$row['rechtD'] = "";
				#$row['rechtD'] = '<a href="javascript:del(\''.$row['Rid'].'\')"'.'"><img src="include/images/icons/del.gif" alt="Löschen" width="15" height="13" title="Löschen" /></a> ';
				$row['rechtE'] = '<a href="admin.php?raid-show-'.$row['Rid'].'"><img src="include/images/icons/edit.gif" alt="Edit" border="0" title="Edit" /></a> ';
			} else {
				$row['rechtD'] = "";
				$row['rechtE'] = "";
			}

			$tpl->set_ar_out($row,2);  
		}
			$tpl->out(4);	// HILFE
		$design->footer();	
		break;

		#---- LOOT -------------------------------------------------------------
		break;
	case 'loot' :
				$design = new design ( 'Admins Area', 'Admins Area', 2 );
				$design->header();
				?>
				<p><b>Raid-Planer Admin loot<br></b></p>
				<?php

		$design->footer();
		#---- CONFIG -----------------------------------------------------------
		break;
	case 'config' :
				$design = new design ( 'Admins Area', 'Admins Area', 2 );
				$design->header();
				$tpl = new tpl ('raid/raid-conf', 1);
				$tpl->set('msg' ,$msg);
					$msg = "DEBUG: mode!";
					// SCRIPT
					$_ilch['msg'] = ( isset ($msg) ? $msg : '' );
					
					$_ilch = array (
								"conf"=>""
									);
															#echo 'allgAr[\"raid_anz_l\"] = '.$allgAr['wars_last_limit'];	//DEBUG		
				$tpl->set_ar_out($_ilch,0); //0
							
		$design->footer();
		#---------
		break;

}

?>
Geschlossen		Seite 4 von 9 ‹1 2 345 6 ...9 ›

	Zurück zu Module und Modifikationen
Beitrag zur Merkliste hinzufügen

ilch Forum » Ilch Clan 1.1 » Module und Modifikationen » RaidPlaner
