session_start();
include("../config.php");
include("../show_tip.php");
$team_db = mysql_query("SELECT * FROM teams");
$team = mysql_num_rows($team_db);
$team2_db = mysql_query("SELECT * FROM status WHERE team > '0'");
$team2 = mysql_num_rows($team2_db);
$status_db = mysql_query("SELECT * FROM status WHERE nickname = '$_SESSION[nickname]'");
$status = mysql_fetch_array($status_db);
?>
if($_SESSION['nickname'] == ""){ echo "Du bist nicht eingeloggt!"; }else{
include_once("../_menu.php");
$links = array('
Die Team Hall of Fame '.show_tip(101,$_SESSION['nickname'],0));
echo createMenu($links,250)."
";
if($_GET['seite'] == "info"){
$in_db = mysql_query("SELECT * FROM teams WHERE ID = '$_GET[ID]'");
$in = mysql_fetch_array($in_db);
$tell_db = mysql_query("SELECT * FROM status WHERE team = '$_GET[ID]'");
$tell = mysql_num_rows($tell_db);
?>
echo $in['name']; ?>

if($_GET['member'] == "show"){
?>
zurück zur Teaminfo
Rang berechnet um echo strftime("%R Uhr",$config['rang']); ?>
Name |
Punkte |
Team / UR - Rang |
$x = 0;
$member_db = mysql_query("SELECT nickname,pkt,rang FROM status WHERE team = '$_GET[ID]' ORDER BY pkt DESC");
while($member = mysql_fetch_array($member_db))
{
$x++;
?>
echo $member['nickname']; ?> |
echo $member['pkt']; ?> |
echo $x." / ".$member['rang']; ?> |
} ?>
}else{ ?>
Dieses Team hat echo $tell; ?>
Mitglieder.
$wing = mysql_fetch_array(mysql_query("SELECT * FROM teams WHERE ID='$in[wing]'"));
if($wing){?>
Dieses Team ist ein Wing von
echo $wing['name']; ?>.
}
$main = mysql_fetch_array(mysql_query("SELECT * FROM teams WHERE wing='$in[ID]'"));
if($main){?>
Dieses Team ist das Hauptteam von
echo $main['name']; ?>.
}
echo nl2br($in['info']); ?>
Bewerben für eine MitgliedschaftZurück zu der Teams Liste
}}else{
$mo = mysql_fetch_array(mysql_query("SELECT * FROM teams ORDER BY m_punkte DESC LIMIT 1"));
$ge = mysql_fetch_array(mysql_query("SELECT * FROM teams ORDER BY punkte DESC LIMIT 1"));
?>
Es gibt derzeit echo $team; ?> Teams mit echo $team2; ?> Mitgliedern.
Alle Teams in der Übersicht.

if($_GET['sorder'] == "DESC")
$sorder = "ASC";
else $sorder = "DESC";
?>
Platz |
Name |
Monats-Pkt |
Team-Pkt |
Gesamt-Fahrer-Pkt |
Schnitt |
Mitglieder |
$x = 0;
if(!$_GET['sort'])
$team_pkt_db = mysql_query("SELECT teams.ID,team,m_punkte,m2_pkt,punkte,ge_pkt,name,sum(pkt) AS pkt,avg(pkt) AS avg,count(status.ID) AS count FROM status LEFT JOIN teams on teams.ID=status.team WHERE teams.ID!=0 GROUP BY team ORDER BY m_punkte DESC,punkte DESC,pkt DESC");
else $team_pkt_db = mysql_query("SELECT teams.ID,team,m_punkte,m2_pkt,punkte,ge_pkt,name,sum(pkt) AS pkt,avg(pkt) AS avg,count(status.ID) AS count FROM status LEFT JOIN teams on teams.ID=status.team WHERE teams.ID!=0 GROUP BY team ORDER BY $_GET[sort] $_GET[sorder]");
while($team_pkt = mysql_fetch_array($team_pkt_db)){
$x++;
if($team_pkt['m_punkte']-$team_pkt['m2_pkt'] > 0){
$zeichen = "+ ";
}elseif($team_pkt['m_punkte']-$team_pkt['m2_pkt'] < 0){
$zeichen = " ";
}elseif($team_pkt['m_punkte']-$team_pkt['m2_pkt'] == 0){
$zeichen = "+- ";
}
?>
echo $x; ?> |
echo $team_pkt['name']; ?> |
echo $team_pkt['m_punkte']." (".$zeichen.($team_pkt['m_punkte']-$team_pkt['m2_pkt']).")"; ?> |
echo $team_pkt['punkte']." (".($team_pkt['punkte']-$team_pkt['ge_pkt']).")"; ?> |
echo $team_pkt['pkt']; ?> |
echo round($team_pkt['avg'],0); ?> |
echo $team_pkt['count']; ?> |
}}}
?>
include("../werbung.php");
?>