das heist raid.php
ihr
<?php
# Copyright by: Benjamin Brauns
# Support: www.Manticors-Thorn.de
defined ('main') or die ( 'no direct access' );
$akttime = date('Y-m-d');
$akttime1 = date('d.m.Y');
$gastRight = "-1";
// was kommt als nächstes nach Datum / OFFEN
if ( $menu->get(2) == '' OR $menu->getA(2) == 'p' ) {
$title = $allgAr['title'].' :: Raids';
$hmenu = 'Raids';
#design = new design ( $title , $hmenu, 1, 'forum/index.htm' ); // SOLL
$design = new design ( $title , $hmenu, 1, 'user/index.htm' ); // test
$design->header();
$ergOffen = db_query('SELECT COUNT(id) FROM `prefix_Raid` WHERE status = "1"');
$anzOffen = db_result($ergOffen,0);
$ergBeendet = db_query('SELECT COUNT(id) FROM `prefix_Raid` WHERE status = "2"');
$anzBeendet = db_result($ergBeendet,0);
$ergAbgesagt = db_query('SELECT COUNT(id) FROM `prefix_Raid` WHERE status = "3"');
$anzAbgesagt = db_result($ergAbgesagt,0);
$tpl = new tpl ( '/raid/raid.htm' );
$tpl->set_ar_out ( array('OFFEN' => $anzOffen, 'BEENDET' => $anzBeendet, 'ABGESAGT' => $anzAbgesagt) , 0 );
$class = '';
$erg = db_query("SELECT DATE_FORMAT(datime,'%d.%m.%Y - %H:%i') as time,
instanz,
leader,
groese,
datime,
status,
prefix_Raid.id as Rid,
prefix_RaidInstanz.RIID as Iid,
prefix_RaidInstanz.name as Iname,
prefix_RaidInstanz.pix
FROM prefix_Raid
LEFT JOIN prefix_RaidInstanz ON prefix_RaidInstanz.RIID = prefix_Raid.instanz
ORDER BY datime DESC,status");
if ( db_num_rows ( $erg ) == 0 ) {
echo '<tr class="Cmite"><td colspan="4"><strong><font color="#FF4242">kein Raid vorhanden</font></strong></td></tr>';
} else {
while ($row = db_fetch_assoc($erg) ) {
if ( $class == 'Cmite' ) { $class = 'Cnorm'; } else { $class = 'Cmite'; }
$row['instanz'];
$row['groese'];
$row['Iname'];
#--------Anmeldungen Pro Raid Auf der Übersichts seite
$ergANM = db_query('SELECT COUNT(RMID) FROM `prefix_RaidMember` WHERE zusage = "1" AND rid = "'.$row['Rid'].'" ');
$anzANM = db_result($ergANM,0);
$row['Evon'] = $anzANM['0']." / ";
#Print_r ($anzANM); // DEBUG
#--------
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['class'] = $class;
$tpl->set_ar_out($row,1);
}
}
$tpl->out(2);
// Raid Details //
//--------------//
$design->footer();
} elseif ( is_numeric($menu->get(2)) ) {
$_GET['mehr'] = escape($menu->get(2),'integer');
$abf = "SELECT
DATE_FORMAT(datime,'%d.%m.%Y') as datum,
DATE_FORMAT(datime,'%H:%i') as zeit,
DATE_FORMAT(start,'%H:%i') as start,
DATE_FORMAT(end,'%H:%i') as end,
instanz,
leader,
groese,
datime,
status,
loottyp,
groese,
treff,
bosse,
level,
text,
prefix_RaidInstanz.pix,
prefix_Raid.id as Rid,
prefix_RaidInstanz.RIID as Iid,
prefix_RaidInstanz.name as Iname,
prefix_RaidInstanz.pix
FROM prefix_Raid LEFT
JOIN prefix_RaidInstanz ON prefix_RaidInstanz.RIID = prefix_Raid.instanz
WHERE prefix_Raid.id = '".$_GET['mehr']."'";
$erg = @db_query($abf);
#db_check_erg ($erg);
$row = db_fetch_assoc($erg);
// Filtern von html code
$row['text'] = bbcode($row['text']);
//
$title = $allgAr['title'].' :: Raids';
#$hmenu = 'Raids';
$hmenu = '<a href="?raid" class="smalfont">Raids</a><b> » </b>Deteils';
$design = new design ( $title , $hmenu, 1, 'forum/index.htm' ); // SOLL
#$design = new design ( $title , $hmenu, 1, 'user/index.htm' ); // test
$design->header();
$tpl = new tpl ('/raid/raid_next');
#-------
switch ( $row['loottyp'] ) {
case '0' : $row['loottyp'] = ''; break;
case '1' : $row['loottyp'] = 'Plündern als Gruppe'; break;
case '2' : $row['loottyp'] = 'Plündermeister'; break;
case '3' : $row['loottyp'] = 'Bedarf vor Gier'; break;
case '4' : $row['loottyp'] = 'DKP'; break;
case '5' : $row['loottyp'] = 'DKP/Würfeln'; break;}
#-------
// rechte check Locked Anzeige für Gäste!
#if ( $_SESSION['authright'] <= $allgAr['raid_anz_gast'] ) { FÜR DB CONFIG WERT
if ( $_SESSION['authright'] <= $gastRight ) { // ab user level fixer wert
$row['treff']=$row['treff'];
$row['bosse']=$row['bosse'];
$row['loottyp']=$row['loottyp'];
$row['leader']=$row['leader'];
$row['text']=$row['text'];
} else{
$row['treff']='locked';
$row['bosse']='locked';
$row['loottyp']='locked';
$row['text']='locked';
$row['leader']='locked';
}
$tpl->set_ar_out($row,0); // Raid Info Anzeige!
// END
// checke zusagen / absagen / ersatz (summe)
$zusagen = db_count_query("SELECT COUNT(zusage) FROM prefix_RaidMember WHERE rid = ".$_GET['mehr']." AND zusage = 1");
$ersatz = db_count_query("SELECT COUNT(zusage) FROM prefix_RaidMember WHERE rid = ".$_GET['mehr']." AND zusage = 2");
$absagen = db_count_query("SELECT COUNT(zusage) FROM prefix_RaidMember WHERE rid = ".$_GET['mehr']." AND zusage = 3");
$aout1 = array (
'zusagen' => $zusagen,
'ersatz' => $ersatz,
'absagen' => $absagen,
'id' => $_GET['mehr']
);
$tpl->set_ar_out($aout1,1);
// END
$ergU = db_query("SELECT * FROM prefix_RaidMember WHERE rid = '".$_GET['mehr']."' AND uid = '".$_SESSION['authid']."'"); // Check ob an gemeldet
if ( db_num_rows ( $ergU ) != 0 ) {
echo '<tr class="Cmite"><td colspan="4"><font color="#009900">Du bist angemeldet</font></td></tr>'; // Anmelde Anzeige
#echo '<tr class="Cmite"><td colspan="4"><font color="#009900">'.$akttime1.' : '.$row['datum'].'</font></td></tr>';
#------ Update -------------
if ( isset($_POST['sub']) AND $row['status'] == 1 ) {
db_query("UPDATE prefix_RaidMember
SET zusage = '".$_POST['zusageNEW']."'
, kom = '".$_POST['komNEW']."'
, WoWc = '".$_POST['WoWcNEW']."'
WHERE
RMID = '".$_POST['RMID']."'
");
echo mysql_error();
}
#---------------------------
} else {
#---- Anmeldung ------------------------------------------------
if ( isset ($_POST['sub']) AND $ergU != 2 AND $row['status'] == 1 ) {
#if ( $_POST['Sub'] == "Anmelden" ) {
$kom = escape($_POST['Ckom'],'string');
#---- Check --
$ergCH = db_query("SELECT uid, rid, status FROM prefix_RaidMember WHERE uid = '".$_SESSION['authid']."' AND rid = '".$_GET['mehr']."' "); //CH
if ( db_num_rows ( $ergCH ) == 0 ) { //CH
#-------
db_query("INSERT INTO prefix_RaidMember (uid,rid,WoWc,kom,zusage) VALUES ('".$_SESSION['authid']."','".$_POST['ID']."','".$_POST['WoWc']."','".$_POST['Ckom']."','".$_POST['zusage']."')");
echo '<tr class="Cmite"><td colspan="4"><font color="">DU HAST DICH SOEBEN ANGEMELDET!</font></td></tr>';
} // Check
#echo "<br>ID '".$_POST['ID']."', Char '".$_POST['WoWc']."', authid '".$_SESSION['authid']."', kom '".$_POST['Ckom']."'<br>"; // für DEBUG
#echo mysql_error(); // für DEBUG
}
#---------------------------------------------------------------
#-------------Chars pro User Auslesen, --------- scheiß code, muß verbessert werden!!!
$ergUC = db_query("SELECT CID FROM prefix_wowchars WHERE UID = '".$_SESSION['authid']."' LIMIT 0,1");
#echo '<form name="form1" method="post" action="?raid-deteil-'.$_GET['mehr'].'">';
while ($rowUC = db_fetch_assoc($ergUC) ) {
$rowUC['WoWC'] = dblistee ( $rowUC['WoWC'], "SELECT CID,name FROM prefix_wowchars WHERE UID = '".$_SESSION['authid']."' AND onoff = 0");
$rowUC['ID'] = $_GET['mehr'];
$tpl->set_ar_out($rowUC,2);
}
#------------Anmelde Anzeige----------------
#if ( $_SESSION['authright'] == "-1"){ // Check Rechte ( gast?)
//BUG
if ( db_num_rows ( $ergUC ) == 0 ) {
echo '<tr class="Cmite"><td colspan="4"><b><font color="#CC6600" size="2">
Du mußt erst einen <a href="?user-mychars">Char</a> erstellt haben um dich anmelden zu können!
<b></font></td></tr>'; // Char Anlegen Anzeige
} else {
echo '<br><br>
<input type="submit" name="sub" value="Anmelden">
<br><br>
<font color="#FF0000">Du bist noch NICHT angemeldet!</font>
<form>
'; // Anmelde Anzeige
}
/* } //BUG
else {
echo '<tr class="Cmite"><td colspan="4"><b><font color="#CC6600" size="2">
Du mußt <a href="?user-regist">Registriert</a> und freigeschaltet sein um dich anmelden zu können!
<b></font></td></tr>';
}
*/
#$tpl->out(2);
}
#--- User Listen Anzeige ----
$ergC = db_query("SELECT
prefix_RaidMember.zusage,
prefix_RaidMember.eingeteilt,
prefix_RaidMember.kom as Ukom,
prefix_RaidMember.WoWc,
prefix_RaidMember.RMID,
prefix_RaidMember.uid as Ruid,
prefix_RaidMember.rid as Rid,
prefix_wowchars.UID as Cuid,
prefix_wowchars.CID as Cid,
prefix_wowchars.name as charname
FROM prefix_RaidMember
LEFT JOIN prefix_wowchars
ON prefix_wowchars.CID = prefix_RaidMember.WoWc
WHERE prefix_RaidMember.rid = '".$_GET['mehr']."'
");
while ($row2 = db_fetch_assoc($ergC) ) {
#--- Anzeige angemeldeter Char mit änderungs funktion!
if ( $_SESSION['authid'] == $row2['Ruid'] AND $row['status'] == 1 ) {
$row2['charname'] =
'<form name="form1" method="post" action="?raid-deteil-'.$_GET['mehr'].'">
<input name="RMID" value="'.$row2['RMID'].'" size="5" type="hidden">
<select name="WoWcNEW">'.
$row2['charname'] = dblistee ( $row2['charname'], "SELECT CID,name FROM prefix_wowchars WHERE UID = '".$_SESSION['authid']."' AND onoff = 0 ORDER BY name != '".$row2['charname']."'")
.'</select> ';
$row2['Ukom'] =
'<input name="komNEW" type="text" value="'
.$row2['Ukom'].
'">
<input type="submit" name="sub" value="Update"></form>
';
$row2['zusage'] =
'<select name="zusageNEW">'.
$row2['zusage'] = arlistee ( $row2['zusage'] , get_zusage_array() )
.'</select>';
}
#----------------------------------------------------
#$row2['charname'];
$row2['Cid'];
$row2['UPD'] = "";
#$row2['Ukom'];
switch ( $row2['zusage'] ) {
case '0' : $row2['zusage'] = '<font color="#FFFFFF">noch keine Angabe</font>'; break;
case '1' : $row2['zusage'] = '<font color="#009900">zugesagt</font>'; break;
case '2' : $row2['zusage'] = '<font color="#CC6600">ersatz</font> angemeldet'; break;
case '3' : $row2['zusage'] = '<font color="#FF0000">abgesagt</font>'; break;}
switch ( $row2['eingeteilt'] ) {
case '0' : $row2['eingeteilt'] = '<font color="#FFFFFF">noch keine Einteilung</font>'; break; // weiß
case '1' : $row2['eingeteilt'] = '<font color="#009900">ZUSAGE</font>'; break; // grün
case '2' : $row2['eingeteilt'] = '<font color="#CC6600">ERSATZ</font> angemeldet'; break; // orage
case '3' : $row2['eingeteilt'] = '<font color="#FF0000">ABSAGE</font>'; break; // rot
case '4' : $row2['eingeteilt'] = '<font color="#66FFFF">LEADER</font>'; break; } // türkies
#$ergdkp = db_query("SELECT COUNT(dkp) FROM prefix_RaidMember WHERE UID = '".$_SESSION['authid']."' AND rid = '".$_GET['mehr']."'");
#$anzdkp = db_result($ergdkp,0);
#array('dkp' => $anzdkp) , 0 );
#if ( $_SESSION['authright'] <= $allgAr['raid_anz_gast'] ) { FÜR DB CONFIG WERT
if ( $_SESSION['authright'] <= $gastRight ) { // ab user level fixer wert
$tpl->set_ar_out($row2,3); // User (Char) Anzeige!
}
}
#--------------------------------------------------------------------------------------------------------------------------------
$tpl->out(4);
$design->footer();
}
/*
TODO
-Char Update muß erstellt werden! <---
-Char ADD für User muß erstellt werden.
-Dropdown pro USER muß noch erstellt werden!
-Char rollover efekte mit info´s! ?!?
-Instanzen Informationen ?!?
-Item Datenbank ?!?
*/
?>
obs das ist ka