<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined (
'main'
)
or
die
(
'no direct access'
);
$title
=
$allgAr
[
'title'
].
' :: Teams'
;
$hmenu
=
'Teams'
;
$design
=
new
design (
$title
,
$hmenu
);
$design
->header();
$tpl
=
new
tpl (
'teams'
);
$tpl
->out(0);
$erg1
= db_query(
"SELECT a.name,b.img,gid FROM prefix_teams b LEFT JOIN prefix_groups a ON b.gid = a.id ORDER BY b.pos"
);
while
(
$row1
= db_fetch_assoc(
$erg1
) ) {
if
( !
empty
(
$row1
[
'img'
]) ) {
$row1
[
'show'
] =
'<img src="'
.
$row1
[
'img'
].
'" title="'
.
$row1
[
'name'
].
'" alt="'
.
$row1
[
'name'
].
'"><br /><b>'
.
$row1
[
'name'
].
'</b>'
;
}
else
{
$row1
[
'show'
] =
'<b>'
.
$row1
[
'name'
].
'</b>'
;
}
$tpl
->set_ar_out(
$row1
,1);
$class
=
'Cnorm'
;
$q
=
"SELECT uid, a.name, c.name as pos FROM prefix_groupusers b LEFT JOIN prefix_user a ON a.id = b.uid LEFT JOIN prefix_userfuncs c ON b.fid = c.id WHERE b.gid = "
.
$row1
[
'gid'
].
" ORDER BY c.pos ASC"
;
$erg
= db_query(
$q
);
while
(
$row
= db_fetch_assoc(
$erg
) ) {
$class
= (
$class
==
'Cmite'
?
'Cnorm'
:
'Cmite'
);
$row
[
'class'
] =
$class
;
$row
[
'flag'
] = @db_result(db_query(
"SELECT val FROM prefix_userfields WHERE uid = "
.
$row
[
'uid'
].
" AND fid = 10"
),0);
if
(
$row
[
'flag'
] !=
''
) {
$row
[
'flag'
] =
'<img src="include/images/flags/'
.
$row
[
'flag'
].
'" alt="" border="0">'
;
}
$row
[
'status'
] = ( db_count_query(
"SELECT COUNT(uid) FROM prefix_userfields WHERE uid = "
.
$row
[
'uid'
].
" AND fid = 11 AND val = 1"
) == 0 ?
'inaktiv'
:
'aktiv'
);
$tpl
->set_ar_out(
$row
,2);
}
}
$tpl
->out(3);
$design
->footer();
?>