Tfe

Old stuff/old_sites/portail/include/accueil.php

<div class="presentation">
<?
    $query = "SELECT * FROM mp_accueil WHERE pseudo='".$owner."' ORDER BY id DESC LIMIT 1";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_assoc($result);
    $contenu = explode("\n",$row{'contenu'});
    foreach($contenu as $key)
    {
	print "\t<p>$key</p>\n"; 
    }
    
?>
</div>





<div class="top3">
<?
    $query = "SELECT * FROM mp_pigeon WHERE pseudo='".$owner."' ORDER BY note DESC, concours DESC LIMIT 3";
    $result = mysql_query($query) or die(mysql_error());
    $i = 0;
    while($row = mysql_fetch_assoc($result))
    {
    $row{'date'} = preg_replace("/([0-9]{4})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})([0-9]{2})/","$3/$2/$1",$row{'date'});
    echo "<div>
    <a href=\"index.php?page=pigeons&amp;id=".$row{'id'}."\"><img src=\"http://www.monpigeonnier.be/pigeons/".$row{'bague'}.".jpg\" alt=\"Pigeon ".$row{'bague'}."\"></a>
    <p>Bague: ".$row{'bague'}."</p>
    <p>N&eacute; le : ".$row{'date'}."</p>    
    <p>Note : ".$row{'note'}."</p>       
    </div>
    ";
    }
    
    
?>
</div>

<div class="stats">
<?
    $query = "SELECT count(id) FROM mp_pigeon WHERE pseudo='".$owner."'";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);
    echo "\t<p>Total de ".$row{0}." pigeons appartenant &agrave; <i>".$owner."</i>.</p>\n";

    $query = "SELECT sum(concours) FROM mp_pigeon WHERE pseudo='".$owner."'";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);
    echo "\t<p>Nombre de concours : ".$row{0}."</p>\n";
    $query = "SELECT bague FROM mp_pigeon WHERE pseudo='".$owner."' ORDER BY id DESC LIMIT 1";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);
    echo "\t<p>Bague du dernier pigeon ajout&eacute; : ".$row{0}." </p>\n";    
    
    
    
?>
</div>