<?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"
;
if
(
$menu
->get(2) ==
''
OR
$menu
->getA(2) ==
'p'
) {
$title
=
$allgAr
[
'title'
].
' :: Raids'
;
$hmenu
=
'Raids'
;
#design =
new
design (
$title
,
$hmenu
, 1,
'forum/index.htm'
);
$design
=
new
design (
$title
,
$hmenu
, 1,
'user/index.htm'
);
$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"Zwinker;
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
);
#--------
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);
$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
);
$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'
);
#
$design
=
new
design (
$title
,
$hmenu
, 1,
'user/index.htm'
);
$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
;}
#-------
#
if
(
$_SESSION
[
'authright'
] <=
$allgAr
[
'raid_anz_gast'
] ) { FÜR DB CONFIG WERT
if
(
$_SESSION
[
'authright'
] <=
$gastRight
) {
$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);
$zusagen
= db_count_query(
"SELECT COUNT(zusage) FROM prefix_RaidMember WHERE rid = "
.
$_GET
[
'mehr'
].
" AND zusage = 1"
Zwinker;
$ersatz
= db_count_query(
"SELECT COUNT(zusage) FROM prefix_RaidMember WHERE rid = "
.
$_GET
[
'mehr'
].
" AND zusage = 2"
Zwinker;
$absagen
= db_count_query(
"SELECT COUNT(zusage) FROM prefix_RaidMember WHERE rid = "
.
$_GET
[
'mehr'
].
" AND zusage = 3"
Zwinker;
$aout1
=
array
(
'zusagen'
=>
$zusagen
,
'ersatz'
=>
$ersatz
,
'absagen'
=>
$absagen
,
'id'
=>
$_GET
[
'mehr'
]
);
$tpl
->set_ar_out(
$aout1
,1);
$ergU
= db_query(
"SELECT * FROM prefix_RaidMember WHERE rid = '"
.
$_GET
['mehr
']."'
AND uid =
'".$_SESSION['
authid
']."'
"Zwinker;
if
( db_num_rows (
$ergU
) != 0 ) {
echo
'<tr class="Cmite"><td colspan="4"><font color="#009900">Du bist angemeldet</font></td></tr>'
;
#
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
']."'
"Zwinker;
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
']."'
"Zwinker;
if
( db_num_rows (
$ergCH
) == 0 ) {
#-------
db_query(
"INSERT INTO prefix_RaidMember (uid,rid,WoWc,kom,zusage) VALUES ('"
.
$_SESSION
['authid
']."'
,
'".$_POST['
ID
']."'
,
'".$_POST['
WoWc
']."'
,
'".$_POST['
Ckom
']."'
,
'".$_POST['
zusage
']."'
)"Zwinker;
echo
'<tr class="Cmite"><td colspan="4"><font color="">DU HAST DICH SOEBEN ANGEMELDET!</font></td></tr>'
;
}
#
echo
"<br>ID '"
.
$_POST
['ID
']."'
, Char
'".$_POST['
WoWc
']."'
, authid
'".$_SESSION['
authid
']."'
, kom
'".$_POST['
Ckom
']."'
<br>";
#
echo
mysql_error();
}
#---------------------------------------------------------------
#-------------Chars pro User Auslesen, --------- scheiß code, muß verbessert werden!!!
$ergUC
= db_query(
"SELECT CID FROM prefix_wowchars WHERE UID = '"
.
$_SESSION
['authid
']."'
LIMIT 0,1"Zwinker;
#
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"Zwinker;
$rowUC
[
'ID'
] =
$_GET
[
'mehr'
];
$tpl
->set_ar_out(
$rowUC
,2);
}
#------------Anmelde Anzeige----------------
#
if
(
$_SESSION
[
'authright'
] ==
"-1"
Zwinker{
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>';
}
else
{
echo
'<br><br>
<input type=
"submit"
name=
"sub"
value=
"Anmelden"
>
<br><br>
<font color=
"#FF0000"
>Du bist noch NICHT angemeldet!</font>
<form>
';
}
#
$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
']."'
"Zwinker;
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
']."'
"Zwinker
.
'</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
;
case
'1'
:
$row2
[
'eingeteilt'
] =
'<font color="#009900">ZUSAGE</font>'
;
break
;
case
'2'
:
$row2
[
'eingeteilt'
] =
'<font color="#CC6600">ERSATZ</font> angemeldet'
;
break
;
case
'3'
:
$row2
[
'eingeteilt'
] =
'<font color="#FF0000">ABSAGE</font>'
;
break
;
case
'4'
:
$row2
[
'eingeteilt'
] =
'<font color="#66FFFF">LEADER</font>'
;
break
; }
#
$ergdkp
= db_query(
"SELECT COUNT(dkp) FROM prefix_RaidMember WHERE UID = '"
.
$_SESSION
['authid
']."'
AND rid =
'".$_GET['
mehr
']."'
"Zwinker;
#
$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
) {
$tpl
->set_ar_out(
$row2
,3);
}
}
#--------------------------------------------------------------------------------------------------------------------------------
$tpl
->out(4);
$design
->footer();
}
?>