# manag member
for
war...
if
(
$menu
->get(2) ==
'members'
) {
$tpl
=
new
tpl (
'wars/last_member'
, 1 );
$msg
=
''
;
# aktion
if
(isset(
$_POST
[
'add_uid'
]) AND !
empty
(
$_POST
[
'add_uid'
])) {
db_query(
"INSERT INTO prefix_warmember (wid,uid,aktion) VALUES ("
.
$_REQUEST
[
'wid'
].
","
.
$_POST
[
'add_uid'
].
",1)"
);
}
if
(isset(
$_GET
[
'delete_uid'
]) AND !
empty
(
$_GET
[
'delete_uid'
])) {
db_query(
"DELETE FROM prefix_warmember WHERE wid = "
.
$_REQUEST
[
'wid'
].
" AND uid = "
.
$_GET
[
'delete_uid'
]);
}
# anzeigen
$tpl
->set(
'msg'
,
$msg
);
$tpl
->set(
'wid'
,
$_REQUEST
[
'wid'
]);
$tpl
->set(
'liste'
, dblistee ( 0,
"SELECT prefix_user.id,name FROM prefix_user LEFT JOIN prefix_warmember ON prefix_warmember.uid = prefix_user.id AND prefix_warmember.wid = "
.
$_REQUEST
[
'wid'
].
" WHERE prefix_warmember.aktion is NULL AND recht <= -2 ORDER BY `name`"
) );
$tpl
->out(0);
$class
=
''
;
$erg
= db_query(
"SELECT prefix_user.id, prefix_user.name FROM prefix_warmember LEFT JOIN prefix_user ON prefix_user.id = prefix_warmember.uid WHERE wid = "
.
$_REQUEST
[
'wid'
].
" ORDER BY prefix_user.name ASC"
);
while
(
$r
= db_fetch_assoc(
$erg
)) {
$class
= (
$class
==
'Cmite'
?
'Cnorm'
:
'Cmite'
);
$r
[
'class'
] =
$class
;
$tpl
->set_ar_out(
$r
,1);
}
$tpl
->out(2);
exit
();
}