<?php
# Copyright by: Manuel
# Support: www.ilch.de
defined (
'main'
)
or
die
(
'no direct access'
);
function
lastfussball1_get_memberlist (
$id
) {
$l
=
''
;
$erg
= db_query(
"SELECT prefix_user.id,prefix_user.name FROM prefix_user LEFT JOIN prefix_warmember ON prefix_warmember.uid = prefix_user.id AND prefix_warmember.wid = "
.
$id
.
" WHERE wid = "
.
$id
.
" ORDER BY prefix_user.name ASC"
);
while
(
$r
= db_fetch_assoc(
$erg
)) {
$l
.=
'<a href="index.php?user-details-'
.
$r
[
'id'
].
'">'
.
$r
[
'name'
].
'</a>, '
;
}
return
(
substr
(
$l
,0,-2));
}
if
(
$menu
->get(2) ==
''
OR
$menu
->getA(2) ==
'p'
) {
$title
=
$allgAr
[
'title'
].
' :: fussball1'
;
$hmenu
=
'fussball1'
;
$design
=
new
design (
$title
,
$hmenu
);
$design
->header();
$ergWin
= db_query(
'SELECT COUNT(id) FROM `prefix_fussball1` WHERE wlp = "1"'
);
$anzWin
= db_result(
$ergWin
,0);
$ergLos
= db_query(
'SELECT COUNT(id) FROM `prefix_fussball1` WHERE wlp = "2"'
);
$anzLos
= db_result(
$ergLos
,0);
$ergPat
= db_query(
'SELECT COUNT(id) FROM `prefix_fussball1` WHERE wlp = "3"'
);
$anzPat
= db_result(
$ergPat
,0);
$ergGes
= db_query(
'SELECT COUNT(id) FROM `prefix_fussball1` WHERE status= "3"'
);
$anzGes
= db_result(
$ergGes
,0);
$tpl
=
new
tpl (
'fussball1_vs.htm'
);
$tpl
->set_ar_out (
array
(
'PAT'
=>
$anzPat
,
'WIN'
=>
$anzWin
,
'LOS'
=>
$anzLos
,
'GES'
=>
$anzGes
,
'TITLE'
=>
$allgAr
[
'title'
] ) , 0 );
$akttime
=
date
(
'Y-m-d'
);
$class
=
''
;
$erg
= db_query(
"SELECT a.id,a.land,a.gegner,a.page,a.game,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y - %H:%i:%s') as time FROM prefix_fussball1 a left join prefix_groups b ON a.tid = b.id WHERE status = 2 AND a.datime >= '"
.
$akttime
.
"' ORDER BY a.datime LIMIT 1"
);
if
( db_num_rows (
$erg
) == 0 ) {
echo
'<tr class="Cmite"><td colspan="4"><strong>kein Spiel die Woche</strong></td></tr>'
;
}
else
{
while
(
$row
= db_fetch_assoc(
$erg
) ) {
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
$row
[
'page'
] = get_homepage(
$row
[
'page'
]);
$row
[
'team'
] = get_wargameimg(
$row
[
'game'
]).
' '
.
$row
[
'team'
];
$row
[
'class'
] =
$class
;
$tpl
->set_ar_out(
$row
,1);
}
}
$tpl
->out(2);
$class
=
''
;
if
(
$menu
->get(1) ==
''
) {
$teams
= dblistee (
''
,
"SELECT id,name FROM prefix_groups ORDER BY name"
);
$game
= dblistee (
''
,
"SELECT DISTINCT `game`,`game` FROM prefix_fussball1 ORDER BY `game`"
);
$mtype
= dblistee (
''
,
"SELECT DISTINCT `mtyp`,`mtyp` FROM prefix_fussball1 ORDER BY `mtyp`"
);
$tpl
->set_ar_out (
array
(
'tid'
=>
$teams
,
'game'
=>
$game
,
'typ'
=>
$mtype
) , 3 );
}
elseif
(
$menu
->get(1) ==
'last'
) {
$tpl
->out(4);
$sqla
=
'WHERE status = 3 '
;
if
(!
empty
(
$_POST
[
'tid'
])){
$sqla
.=
'AND tid="'
.
$_POST
[
'tid'
].
'" '
;
}
if
(!
empty
(
$_POST
[
'wpl'
])){
$sqla
.=
'AND wlp="'
.
$_POST
[
'wpl'
].
'" '
;
}
if
(!
empty
(
$_POST
[
'spiel'
])){
$sqla
.=
'AND game="'
.
$_POST
[
'spiel'
].
'" '
;
}
if
(!
empty
(
$_POST
[
'typ'
])){
$sqla
.=
'AND mtyp="'
.
$_POST
[
'typ'
].
'" '
;
}
# seiten funktion
$limit
=
$allgAr
[
'wars_last_limit'
];
$page
= (
$menu
->getA(2) ==
'p'
?
$menu
->getE(2) : 1 );
$MPL
= db_make_sites (
$page
,
"WHERE status = 3"
,
$limit
,
"?fussball1-last"
,
'wars'
);
$anfang
= (
$page
- 1) *
$limit
;
# seiten funktion
$farbe1wlpar
=
array
(1=>
'C8E1B8'
,2=>
'D8B9B9'
,3=>
'FDFBB7'
);
$farbe2wlpar
=
array
(1=>
'00FF00'
,2=>
'FF0000'
,3=>
'FFFF00'
);
$erg
= db_query(
"SELECT a.owp,a.opp,a.wlp,a.land,a.mtyp,a.game,a.id,a.gegner,a.page,b.name as team,DATE_FORMAT(datime,'%d.%m.%Y') as time FROM prefix_fussball1 a left join prefix_groups b ON a.tid = b.id "
.
$sqla
.
" ORDER BY a.datime DESC, id DESC LIMIT "
.
$anfang
.
","
.
$limit
);
while
(
$row
= db_fetch_assoc(
$erg
) ) {
$row
[
'erg'
] =
$row
[
'opp'
].
':'
.
$row
[
'owp'
];
$row
[
'farbe'
] =
$farbe1wlpar
[
$row
[
'wlp'
]];
$row
[
'farbe2'
] =
$farbe2wlpar
[
$row
[
'wlp'
]];
if
(
$class
==
'Cmite'
) {
$class
=
'Cnorm'
; }
else
{
$class
=
'Cmite'
; }
$row
[
'page'
] = get_homepage(
$row
[
'page'
]);
$row
[
'team'
] = get_wargameimg(
$row
[
'game'
]).
' '
.
$row
[
'team'
];
$row
[
'class'
] =
$class
;
$tpl
->set_ar_out(
$row
,5);
}
$tpl
->out(6);
echo
$MPL
;
}
$design
->footer();
}
?>