Tfe

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

<?
if (empty($_GET['id']))
{


    $start = (empty($_GET['start']) ? 0 : preg_replace("/\D/","",$_GET['start']));
    $order = ((strcmp($_GET['order'],"desc")==0) ? "desc" : "asc");
    $norder = ((strcmp($order,"asc") == 0) ? "desc" : "asc");
    if (
       $_GET['by'] == "id" or
       $_GET['by'] == "date" or
        $_GET['by'] == "bague" or
        $_GET['by'] == "pere" or	
        $_GET['by'] == "mere" or		
        $_GET['by'] == "concours" or			
        $_GET['by'] == "note") { $by = $_GET['by']; }
    else { $by = "bague"; }
        
    $query = "SELECT * FROM mp_pigeon WHERE pseudo='".$owner."' ORDER BY $by $order LIMIT $start,5";
    $result = mysql_query($query) or die(mysql_error()."<br>$query");
    
    echo "
    <p>Pour trier les pigeons par cat&eacute;gories, il vous suffit de cliquer sur la cat&eacute;gorie voulue.</p>
    <table border=\"1\" cellspacing=\"0\">
    <tr>
    <th>Image</th>\n
    ";
    
    foreach(array("date","bague","concours","note") as $key)
	{
	echo "
	    <th><a href=\"?page=pigeons&amp;by=$key&amp;order=";
	    echo  ((strcasecmp($by,$key) == 0) ? $norder."\" class=\"selected\" " : $order."\"");
	    echo ">".$key."</a></th>
	    ";
       }    
    echo "</tr>\n";
    if (mysql_num_rows($result) == 0) { echo "<tr><td colspan=\"7\">Aucun pigeon<br>$query</td></tr>\n"; }
    while ($row = mysql_fetch_assoc($result))
    {
	$row{'date'} = preg_replace("/^([0-9]{4})([0-9]{2})([0-9]{2}).*/","$3/$2/$1",$row{'date'});
	echo "<tr>
	<td><a href=\"index.php?page=pigeons&amp;id=".$row{'id'}."\"><img src=\"http://www.monpigeonnier.be/pigeons/".$row{'bague'}.".jpg\" alt=\"Image du pigeon ".$row{'bague'}.".jpg\" /></a></td>\n
	";
        foreach(array("date","bague","concours","note") as $key)
	{
	echo "\t<td class=\"center\"><a href=\"index.php?page=pigeons&amp;id=".$row{'id'}."\">".$row{$key}."</a></td>\n"; 
	}
	echo "</tr>";
	    
    }	    
    echo "</table>";
    $query = "SELECT count(id) FROM mp_pigeon WHERE pseudo='".$owner."'";
    $result = mysql_query($query) or die(mysql_error());
    $row = mysql_fetch_array($result);
    echo "<p>";


    if ($start-5 > -1)
    {
    echo "<a href=\"?page=pigeons&amp;by=$by&amp;order=$order&amp;start=".($start-5)."\">Les cinq pr&eacute;c&eacute;dents</a>";
    }
    if ($start+5 < $row{0})
    {
    echo "<a href=\"?page=pigeons&amp;by=$by&amp;order=$order&amp;start=".($start+5)."\">Les cinq suivants</a>";
    }
    echo "</p>";
    
}
else 
{
    $id = preg_replace("/\D/","",$_GET['id']);
    $query = "SELECT * FROM mp_pigeon WHERE pseudo='".$owner."' and id='".$id."' LIMIT 1";
    $result = mysql_query($query) or die(mysql_error()."<br>$query");
    $row = mysql_fetch_assoc($result);

    $row{'date'} = preg_replace("/^([0-9]{4})([0-9]{2})([0-9]{2}).*$/","$3/$2/$1",$row{'date'});
    echo "
    <div class=\"blog\">
    <h4>Bague ".$row{'bague'}."</h4>
    <p>Ce pigeon a &eacute;t&eacute; mis en libert&eacute; le ".$row{'date'}."</p>
    <dl>
    <dt>Descriptif du p&egrave;re</dt>
    <dd>";
    $contenu = explode("\n",$row{'pere'});
    print join("<br />",$contenu);
    print "</dd>";
    echo "<dt>Descriptif de la  m&egrave;re</dt>
    <dd>";
    $contenu = explode("\n",$row{'mere'});
    print join("<br />",$contenu);
    echo "</dd>
    <dt>Concours particip&eacute;s</dt>
    <dd>".$row{'concours'}." </dd>
    <dt>Note du propri&eacute;taire</dt>
    <dd>".$row{'note'}."/20</dd>
    <dt>Apparence</dt>
    <dd><a href=\"http://www.monpigeonnier.be/pigeons/".$row{'bague'}."_big.jpg\"><img src=\"http://www.monpigeonnier.be/pigeons/".$row{'bague'}.".jpg\" alt=\"apparence\" /></a></dd>
    
    ";
    
    echo "</dl>
    </div>
    ";




}