<?php require_once('Connections/yoleronde.php'); ?>
<?php
mysql_select_db($database_yoleronde, $yoleronde);
$query_compet = "SELECT DISTINCT etape.ID ,etape.etape FROM etape RIGHT JOIN tour ON tour.etape=etape.ID ORDER BY etape.ID DESC";
$compet = mysql_query($query_compet, $yoleronde) or die(mysql_error());
$row_compet = mysql_fetch_assoc($compet);
$totalRows_compet = mysql_num_rows($compet);

$recentetp=$row_compet['ID'];//ici je charge l'id de la derniere etape

mysql_select_db($database_yoleronde, $yoleronde);
$query_etape = "SELECT DISTINCT etape.ID ,etape.etape FROM etape RIGHT JOIN tour ON tour.etape=etape.ID ORDER BY etape.ID ASC ";
$etape = mysql_query($query_etape, $yoleronde) or die(mysql_error());
$row_etape = mysql_fetch_assoc($etape);
$totalRows_etape = mysql_num_rows($etape);

$colname_nometape = $recentetp;
if (isset($_GET['etape'])) {
  $colname_nometape = (get_magic_quotes_gpc()) ? $_GET['etape'] : addslashes($_GET['etape']);
}
mysql_select_db($database_yoleronde, $yoleronde);
$query_nometape = sprintf("SELECT *, DATE_FORMAT( jour,'%%d-%%m-%%Y') as jour, DATE_FORMAT( jour,'%%w/%%d/%%c/%%Y') as lejourfr FROM etape WHERE ID = %s", $colname_nometape);
$nometape = mysql_query($query_nometape, $yoleronde) or die(mysql_error());
$row_nometape = mysql_fetch_assoc($nometape);
$totalRows_nometape = mysql_num_rows($nometape);

$colname_temps = $recentetp;
if (isset($_GET['etape'])) {
  $colname_temps = (get_magic_quotes_gpc()) ? $_GET['etape'] : addslashes($_GET['etape']);
}
mysql_select_db($database_yoleronde, $yoleronde);
$query_temps = sprintf("SELECT tour.etape, tour.temp_etape,tour.penalite, SEC_TO_TIME(TIME_TO_SEC(tour.temp_etape)+TIME_TO_SEC(tour.penalite)) as final,  tour.yole, tour.observation, tour.points, tour.place FROM tour WHERE etape='%s' ORDER BY final,id ASC", $colname_temps);
$temps = mysql_query($query_temps, $yoleronde) or die(mysql_error());
$row_temps = mysql_fetch_assoc($temps);
$totalRows_temps = mysql_num_rows($temps);

$colname_tempsprem = $recentetp;
if (isset($_GET['etape'])) {
  $colname_tempsprem = (get_magic_quotes_gpc()) ? $_GET['etape'] : addslashes($_GET['etape']);
}
mysql_select_db($database_yoleronde, $yoleronde);
$query_tempsprem = sprintf("SELECT tour.etape, tour.temp_etape,tour.penalite, SEC_TO_TIME(TIME_TO_SEC(tour.temp_etape)+TIME_TO_SEC(tour.penalite)) as final,  tour.yole FROM tour WHERE  etape='%s' ORDER BY final,id ASC", $colname_tempsprem);
$tempsprem = mysql_query($query_tempsprem, $yoleronde) or die(mysql_error());
$row_tempsprem = mysql_fetch_assoc($tempsprem);
$totalRows_tempsprem = mysql_num_rows($tempsprem);

$colname_points = $recentetp;
if (isset($_GET['etape'])) {
  $colname_points = (get_magic_quotes_gpc()) ? $_GET['etape'] : addslashes($_GET['etape']);
}
mysql_select_db($database_yoleronde, $yoleronde);
$query_points = sprintf("SELECT points, yole, SUM(tour.points)  as pointpre FROM tour WHERE  tour.etape='%s' GROUP BY tour.yole ORDER BY tour.points DESC", $colname_points);
$points = mysql_query($query_points, $yoleronde) or die(mysql_error());
$row_points = mysql_fetch_assoc($points);
$totalRows_points = mysql_num_rows($points);

$colname_T_mail = $recentetp;//ici la valeur par defaut est la variable $recentetp
if (isset($_GET['etape'])) {
  $colname_T_mail = (get_magic_quotes_gpc()) ? $_GET['etape'] : addslashes($_GET['etape']);
}
mysql_select_db($database_yoleronde, $yoleronde);
$query_T_mail = sprintf("SELECT * FROM maillot_tour WHERE idetape = %s", $colname_T_mail);
$T_mail = mysql_query($query_T_mail, $yoleronde) or die(mysql_error());
$row_T_mail = mysql_fetch_assoc($T_mail);
$totalRows_T_mail = mysql_num_rows($T_mail);

$colname_comba = $recentetp;
if (isset($_GET['etape'])) {
  $colname_comba = (get_magic_quotes_gpc()) ? $_GET['etape'] : addslashes($_GET['etape']);
}
mysql_select_db($database_yoleronde, $yoleronde);
$query_comba = sprintf("SELECT * FROM comba WHERE idetape = %s ORDER BY comba.defi ASC", $colname_comba);
$comba = mysql_query($query_comba, $yoleronde) or die(mysql_error());
$row_comba = mysql_fetch_assoc($comba);
$totalRows_comba = mysql_num_rows($comba);

$offx="Résultats officieux";
$offl="Résultats officiels";
$offx="Résultats officieux";
$offl="Résultats officiels";
if($row_nometape['ofic']=="n"){
$of=$offx;}
else{$of=$offl;}
//script du refresh toutes les deux minutes.
if($row_nometape['ofic']=="n"){
$refresh=120;$rafra="Cette page s'actualise toutes les deux minutes lors de l'arrivée des yoles";}
else{
$refresh="";}
?>
<?php 
include ("testfonc.php");

?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="refresh" content="<?php echo $refresh?>">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>resultat de la <?php echo $row_nometape['etape']; ?></title>
<link href="yolestat.css" rel="stylesheet" type="text/css" />

<script src="AC_RunActiveContent.js" type="text/javascript"></script>
<link href="csstitre/histoire.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
#texte {
	position: relative;
	left: 250px;
	z-index: 18;
	background-image: url(imagestabtour/hauttableautour3.jpg);
	background-repeat: no-repeat;
	padding-top: 480px;
	background-color: #3399ff;
	width: 675px;
	border: 1px solid #FF0000;
	top: -10px;
}
#centrage {
	margin-left: 30px;
}
#nometape {
	width: auto;
}
#rept {
	background-color: #3399ff;
	position: absolute;
	z-index: 18;
}
#bastab {
	background-color: #990000;
	position: relative;
	z-index: 18;
}
#frepet {
	background-image: url(imagestabtour/imagerpt.jpg);
	background-repeat: repeat;
}
.Style1 {
	font-size: 18px;
	font-weight: bold;
	color: #FF9900;
}
.Style2 {font-size: 26px; font-weight: bold; color: #330099; }
table{
	font-size:15px;
	text-align: center;
}
a {
	font-weight: bold;
}
a:link {
	text-decoration: none; color: #C0090E;
}
a:visited {
	text-decoration: none;
	color: #C0090E;
}
a:hover {
	text-decoration: underline;
}
a:active {
	text-decoration: none;
}
a:hover {
	color: #00FF66;
}
#actu {
	position:absolute;
	left:281px;
	top:742px;
	width:563px;
	height:24px;
	z-index:19;
	color: #FFFFFF;
}
#ban {
	position:absolute;
	left:388px;
	top:177px;
	width:370px;
	height:97px;
	z-index:13;
	border: 2px solid #FFCC00;
}
.Style4 {
	color: #FFFFFF;
	font-weight: bold;
	font-size: 18px;
}
.Style7 {font-size: 18px; color: #FFFFFF;}
.Style10 {color: #000000; font-size: 24px; }
-->
</style>
</head>

<body>
<div id="ban"><img src="imagetania/bannieretour/bannieretour2007.gif" alt="banniere tour 2007" width="372" height="97" /></div>
<div id="fond1">
 

<div id="dhaut"></div>

<div id="droite"></div>

<div id="flash"> 
  <script type="text/javascript">
AC_FL_RunContent( 'codebase','http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0','width','610','height','320','src','site','quality','high','wmode','transparent','pluginspage','http://www.macromedia.com/go/getflashplayer','movie','yole' ); //end AC code
</script><noscript><object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=7,0,19,0" width="300" height="322">
  <param name="movie" value="yole.swf" />
    <PARAM NAME=wmode VALUE=transparent>
  <param name="quality" value="high" />
  <embed src="yole.swf"   quality="high"wmode=transparent pluginspage="http://www.macromedia.com/go/getflashplayer" type="application/x-shockwave-flash" width="610" height="320"></embed>
</object></noscript></div>
	 
<div id="barre"></div>
<div id="logo"></div>

<div id="titretour">

 
</div>

<div id="texte">
  <div id="centrage">
    <p align="center"><span class="Style4"><br />
      <span class="Style10">REMISE DES RECOMPENSES CONSEIL REGIONAL</span><br />
        <br />
        </span><span class="Style7"><br />
    Voici un diaporama photos de la remise des r&eacute;compenses qui s'est d&eacute;roul&eacute; le mercredi 8 Ao&ucirc;t.</span><span class="Style4"><br />
        </span><br />
      <br />
    </p>
    <div align="center"></div>
    <p>&nbsp;</p>
    <p><br/>
        <br/>
    </p>
    <div id="nometape">
      <p align="center" class="Style2">&nbsp;</p>
      <p align="left">&nbsp;</p>
      </div>
    <p class="Style1">&nbsp;</p>
    <p class="Style1">&nbsp;</p>
    </div>
  <img src="imagestabtour/bastableautour3.jpg" alt="image du bas de tableau" width="675" height="141" /></div>
</div>
<script src="http://www.google-analytics.com/urchin.js" type="text/javascript">
</script>
<script type="text/javascript">
_uacct = "UA-1905254-1";
urchinTracker();
</script>       
</body>
</html>
<?php
mysql_free_result($etape);

mysql_free_result($nometape);

mysql_free_result($temps);

mysql_free_result($tempsprem);

mysql_free_result($points);

mysql_free_result($T_mail);

mysql_free_result($comba);

mysql_free_result($compet);
?>