session_start();
include('config.php');
pconnect($mysqlhost, $mysqluser, $mysqlpasswd,$mysqldbname);
?>
}tao|clan{ - clanwars
| Datum |
Game |
Gegner |
Typ |
Spieler |
Maps |
Ergebnis |
Details |
$points_all['win'] = 0;
$points_all['lost'] = 0;
$games_all['win'] = 0;
$games_all['lost'] = 0;
$games_all['draw'] = 0;
$dbquery = "SELECT * FROM taoclan_clanwar WHERE beendet=1 ORDER BY datum DESC";
$dbergebnis = mysql_query($dbquery);
$dbrows = mysql_num_rows($dbergebnis);
if (!$dbrows) {
echo '| noch keine Wars bestritten... |
';
} else {
for ($i=0;$i<$dbrows;$i++) {
$dbzeile = mysql_fetch_array($dbergebnis);
$dbquery2 = mysql_query("SELECT DATE_FORMAT(datum,'%d.%m.%y') as datum FROM taoclan_clanwar WHERE id='".$dbzeile['id']."'");
$dbzeile2 = mysql_fetch_array($dbquery2);
$datum = $dbzeile2['datum'];
switch ($dbzeile['game']) {
case 0: $game = "none";
break;
case 1: $game = "CS";
break;
case 2: $game = "Q3";
break;
case 3: $game = "OTHER";
break;
}
switch ($dbzeile['details']) {
case 0: $details = "nop";
break;
case 1: $details = "lesen";
break;
}
switch ($dbzeile['warart']) {
case 0: $warart = "ClanWar";
break;
case 1: $warart = "FunWar";
break;
}
if ($dbzeile['map2']!="") {
$maps = $dbzeile['map1']." / ".$dbzeile['map2'];
} else {
$maps = $dbzeile['map1'];
}
$points = $dbzeile['pointswin'].":".$dbzeile['pointslost'];
$points_all['win']+=$dbzeile['pointswin'];
$points_all['lost']+=$dbzeile['pointslost'];
if ($dbzeile['pointswin']<$dbzeile['pointslost']) {
$points .= " LOST";
$games_all['lost'] += 1;
} elseif ($dbzeile['pointswin']==$dbzeile['pointslost']) {
$points .= " DRAW";
$games_all['draw'] += 1;
} else {
$points .= " WIN";
$games_all['win'] += 1;
}
echo'
| '.$datum.' |
'.$game.' | ';
if($dbzeile['gegnerhp']!="") {
echo ''.$dbzeile['gegner'].'[#] | ';
} else {
echo ''.$dbzeile['gegner'].' | ';
}
echo' '.$warart.' |
'.$dbzeile['gameranzahl'].'vs'.$dbzeile['gameranzahl'].' |
'.$maps.' |
'.$points.' |
'.$details.' |
';
}
/* echo'
| |
|
Spiele W:D:L |
'.$games_all['win'].':'.$games_all['draw'].':'.$games_all['lost'].' |
|
Punkte: |
'.$points_all['win'].':'.$points_all['lost'].' |
|
';
*/
}
?>