<?php
#######################
# Liga Modul #
# angepasst für Ilch #
# von Mairu #
# Content #
#######################
defined (
'main'
)
or
die
(
'no direct access'
);
$menue
=
array
(
"Battles anzeigen"
=>
"showmatches"
,
"Rangliste anzeigen"
=>
"table"
,
);
$auswahl
= (
$menu
->get(1) ==
''
?
'table'
:
$menu
->get(1));
$title
=
$allgAr
[
'title'
].
' :: Liga :: '
.
array_search
(
$auswahl
,
$menue
);
$hmenu
=
'Liga <b> » </b> '
.
array_search
(
$auswahl
,
$menue
);
$design
=
new
design (
$title
,
$hmenu
);
$design
->header();
echo
'<table width="100%">'
;
foreach
(
$menue
as
$eintrag
=>
$datei
){
if
(
$datei
==
$auswahl
) {
echo
'<td align="center" bgcolor="#FF6633">'
;
echo
$eintrag
;
echo
'</td>'
;
}
else
{
echo
'<td align="center" bgcolor="#FF6633">'
;
echo
'<a href="index.php?liga-'
.
$datei
.
'">'
.
$eintrag
.
'</a>'
;
echo
'</td>'
;
}
}
echo
'</tr></table>'
;
switch
(
$auswahl
) {
case
'showmatches'
:
$gesamt
= db_result(db_query(
"SELECT COUNT(*) FROM `prefix_liga_stats`"
),0);
$page
= (
$menu
->getA(2) ==
'p'
?
$menu
->getE(2) : 1);
$limit
= 25;
$MPL
= db_make_sites (
$page
,
""
,
$limit
,
'index.php?liga-showmatches'
,
'liga_stats'
);
$anfang
= (
$page
- 1) *
$limit
;
echo
"Battles insgesamt: $gesamt<br><br> "
;
$sql
= db_query(
"SELECT * FROM `prefix_liga_stats` ORDER BY (torep1 + torep2) DESC LIMIT 1"
);
while
(
$ds
= db_fetch_object(
$sql
))
{
$id
=
$ds
->id;
$spieler1
=
$ds
->spieler1;
$spieler2
=
$ds
-> spieler2;
$torep1
=
$ds
->torep1;
$torep2
=
$ds
->torep2;
$datum
=
$ds
->datum;
$uhrzeit
=
$ds
->uhrzeit;
}
?>
<table width=
"100%"
border=
"1"
cellspacing=
"0"
cellpadding=
"1"
>
<tr>
<td><b><font size=
"1"
face=
"Verdana"
>Datum</font></b></td>
<td><b><font size=
"1"
face=
"Verdana"
>Uhrzeit</font></b></td>
<td><b><font size=
"1"
face=
"Verdana"
>DJ/Producer</font></b></td>
<td><b><font size=
"1"
face=
"Verdana"
>DJ/Producer</font></b></td>
<td><b><font size=
"1"
face=
"Verdana"
>Ergebnis</font></b></td>
<?php
$sql
= db_query(
"SELECT * FROM `prefix_liga_stats` order by id DESC LIMIT "
.
$anfang
.
", "
.
$limit
);
while
(
$ds
= db_fetch_object(
$sql
))
{
$id
=
$ds
->id;
$spieler1
=
$ds
->spieler1;
$spieler2
=
$ds
-> spieler2;
$torep1
=
$ds
->torep1;
$torep2
=
$ds
->torep2;
$datum
=
$ds
->datum;
$uhrzeit
=
$ds
->uhrzeit;
echo
"<tr><td bgcolor=\"1b1b1b\">$datum</td><td bgcolor=\"1b1b1b\">$uhrzeit</td><td bgcolor=\"1b1b1b\">$spieler1</td><td bgcolor=\"1b1b1b\">$spieler2</td><td bgcolor=\"1b1b1b\" align=\"center\">$torep1 : $torep2</td>"
;
}
echo
'</table><br />'
;
echo
"<center>$MPL</center>"
;
break
;
case
'table'
:
?>
<center>
<title><center>Rank</center></title><title>Platz</title><body>
<table width=
"100%"
border=
"1"
cellspacing=
"0"
>
<tr>
<td><b><font size=
"1"
face=
"Verdana"
><center>Rangliste</center></font></b></td>
<td><b><font size=
"1"
face=
"Verdana"
><center>DJ/Producer</center></font></b></td>
<td><b><font size=
"1"
face=
"Verdana"
><center>Battles</center></font></b></td>
<td align=
"center"
><b><font size=
"1"
face=
"Verdana"
><center>Win</center></font></b></td>
<td align=
"center"
><b><font size=
"1"
face=
"Verdana"
><center>Draw</center></font></b></td>
<td align=
"center"
><b><font size=
"1"
face=
"Verdana"
><center>Lose</center></font></b></td>
<td align=
"center"
><b><font size=
"1"
face=
"Verdana"
><center> </center></font></b></td>
<td><b><font size=
"1"
face=
"Verdana"
><center>Punkte</center></font></b></td>
<?
$sql
= db_query(
"SELECT * FROM `prefix_liga_script` ORDER BY punkte DESC"
);
while
(
$ds
= db_fetch_object(
$sql
))
{
if
(
$rank
< 3)
{
$id
=
$ds
->id;
$nick
=
$ds
->nick;
$punkte
=
$ds
-> punkte;
$tore
=
$ds
->tore;
$gtore
=
$ds
->gtore;
$s
=
$ds
->s;
$u
=
$ds
->u;
$n
=
$ds
->n;
$anzahlspiele
=
$s
+
$u
+
$n
;
$rank
++;
echo
"<tr><td bgcolor=\"#1b1b1b\" align=\"center\"><b>$rank</td><td bgcolor=\"#1b1b1b\"><b>$nick</td><td bgcolor=\"#1b1b1b\" align=\"center\">$anzahlspiele</td><td bgcolor=\"#1b1b1b\" align=\"center\">$s</td><td bgcolor=\"#1b1b1b\" align=\"center\">$u</td><td bgcolor=\"#1b1b1b\" align=\"center\">$n</td><td bgcolor=\"#1b1b1b\" align=\"center\">$tore : $gtore</td> <td bgcolor=\"#1b1b1b\" align=\"center\"><b>$punkte</td></b>"
;
}
else
{
$id
=
$ds
->id;
$nick
=
$ds
->nick;
$punkte
=
$ds
-> punkte;
$tore
=
$ds
->tore;
$gtore
=
$ds
->gtore;
$s
=
$ds
->s;
$u
=
$ds
->u;
$n
=
$ds
->n;
$anzahlspiele
=
$s
+
$u
+
$n
;
$rank
++;
echo
"<tr><td bgcolor=\"1b1b1b\"><b>$rank</td><td bgcolor=\"1b1b1b\">$nick</td><td bgcolor=\"1b1b1b\">$anzahlspiele</td><td bgcolor=\"1b1b1b\">$s</td><td bgcolor=\"1b1b1b\">$u</td><td bgcolor=\"1b1b1b\">$n</td><td bgcolor=\"1b1b1b\">$punkte</td>"
;
}
}
echo
'</table>'
;
break
;
}
$design
->footer();
?>