<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<meta http-equiv="Content-Language" content="it">
<TITLE>InFOCS Clan</TITLE>
<META http-equiv=Content-Type content="text/html; charset=windows-1252">
<META http-equiv=EXPIRES content=0>
<META content=DOCUMENT name=RESOURCE-TYPE>
<META content=GLOBAL name=DISTRIBUTION>
<META content=InFOCS.net name=AUTHOR>
<META content="Copyright (c) 2005 by Digital-LabDesign.net" name=COPYRIGHT>
<META content="infocs, clan, americas army, aao, clan war, ladder, tornei, infocs.net, clan aao, clan italiani, army operations" name=keywords>
<META content="INDEX, FOLLOW" name=ROBOTS>
<META content="1 DAYS" name=REVISIT-AFTER>
<META content=GENERAL name=RATING>
<META content="MSHTML 6.00.2900.2523" name=GENERATOR><LINK
href="public/config/style.css" type=text/css rel=StyleSheet></HEAD>
<body topmargin="0" leftmargin="0" rightmargin="0" bottommargin="0">
<div align="center">
<table border="0" cellspacing="0" cellpadding="0" id="table2" width="500">
<tr>
<td width="100">
<p align="center">DATA</td>
<td width="150">
<p align="center">LADDER</td>
<td width="100">
<p align="center">CLAN</td>
<td width="20">
<p align="center">VS</td>
<td>
<p align="center">CLAN AVVERSARIO</td>
<td width="70">
<p align="center">RIS</td>
</tr>
</table>
</div>
<?php
include("public/config/config.php");
$db = mysql_connect($db_host, $db_login, $db_pass);
if ($db == FALSE)
die ("Errore nella connessione.");
mysql_select_db($database, $db)
or die ("Errore nella selezione del database.");
$query = mysql_db_query ("$database","SELECT * FROM sfide ORDER BY id ASC");
while($Row = mysql_fetch_array($query)) {
if ($Row['result1'] > $Row['result2']) {
$color = 'green';
}
else if ($Row['result1'] < $Row['result2']) {
$color = 'red';
}
else {
$color = 'orange';
}
?>
<div align="center">
<table border="1" cellpadding="0" id="table1" style="border-collapse: collapse" bordercolor="#000000" width="500">
<tr>
<td width="100" bgcolor="<?php echo $color; ?>"><?php echo $row['field1']; ?><p align="center"><?php echo "".$row["day"]; ?>-<?php echo "".$row["mes"]; ?>-<?php echo "".$row["yea"]; ?></td>
<td width="150" bgcolor="<?php echo $color; ?>"><?php echo $row['field1']; ?><p align="center"><?php echo "".$row["ladder"]; ?></td>
<td width="100" bgcolor="<?php echo $color; ?>"><?php echo $row['field1']; ?><p align="center"><?php echo "".$row["clan1"]; ?></td>
<td width="20" bgcolor="<?php echo $color; ?>"><p align="center">VS</td>
<td bgcolor="<?php echo $color; ?>"><?php echo $row['field1']; ?><p align="center"><?php echo "".$row["clan2"]; ?></td>
<td width="70" bgcolor="<?php echo $color; ?>"><?php echo $row['field1']; ?><p align="center"><?php echo "".$row["result1"]; ?>-<?php echo "".$row["result2"]; ?></td>
</tr>
</table>
</div>
<?php
mysql_free_result ($query);
}
?>