<?

session_start(); //ouverture session

mysql_connect("retrocol.mysql.db", "retrocol", "Q8mt88Vv6H"); // Connexion à MySQL
mysql_select_db("retrocol");	// Selection de la base de donnée

$retour_carte = mysql_query("SELECT * FROM carte WHERE adresse_carte=''") or die(mysql_error());
while($carte = mysql_fetch_array($retour_carte))
{
$id = $carte["id_carte"];
$titre_carte = $carte["titre_carte"];
$date_carte = $carte["date_carte"];
$lieu_carte = $carte["lieu_carte"];
$organisateur_carte = $carte["organisateur_carte"];
$editeur_carte = $carte["editeur_carte"];
$adresse_carte = $carte["adresse_carte"];
$nb_hit_carte = $carte["nb_hit_carte"];
} 

$nb_hit_carte++;

mysql_query("UPDATE carte SET nb_hit_carte='$nb_hit_carte' WHERE adresse_carte=''") or die(mysql_error());

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>


  
  <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">

  <script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(["_setAccount", "UA-30589039-1"]);
  _gaq.push(["_trackPageview"]);

  (function() {
    var ga = document.createElement("script"); ga.type = "text/javascript"; ga.async = true;
    ga.src = ("https:" == document.location.protocol ? "https://ssl" : "http://www") + ".google-analytics.com/ga.js";
    var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>


  
  <title> - Retro-colo</title>
    <style type="text/css">
body {
background-color: #333333;
margin-top: 0px;
margin-bottom: 0px;
text-align: center;
}
  </style>
  
  <link type="text/css" href="../corps.css" rel="stylesheet">
  
  
  <script language="JavaScript">
  function popup(page) {
  window.open(page, "commentaire" , "width=600, height=400, scrollbars=no, location=no, directories=no");
  }
  </script>

</head>


<body>


<table style="margin: auto; text-align: left; margin-bottom: 0px; width: 1050px;" cellpadding="0" cellspacing="0">


  <tbody>


    <tr>


      <td><? include("../menu.inc.php"); ?></td>


    </tr>


    <tr>


      <td bgcolor="#333333">
      
      <table style="text-align: left; width: 1050px;" border="0" cellpadding="0" cellspacing="0">


        <tbody>


          <tr>


            <td style="vertical-align: top; width: 20px;"></td>


            <td style="width: 1010px;">
            
            <table style="text-align: left; width: 1010px;" border="0" cellpadding="0" cellspacing="0">


              <tbody>


                <tr>


                  <td style="width: 220px; vertical-align: top;"><? include("../menu_carte.inc.php"); ?></td>


                  <td style="width: 30px;"></td>


                  <td style="width: 760px; vertical-align: top;">
                  
                  <h1><div class="titre_une"></div></h1>


                  <br>


                  
                  <table style="margin: auto; text-align: left;" border="0" cellpadding="0" cellspacing="0">


                    <tbody>


                      <tr>


                        <td><img border=0px src="../images/cartes/angle_H_gauche.gif"></td>


                        <td background="../images/cartes/fond_H_centre.gif"></td>


                        <td><img border=0px src="../images/cartes/angle_H_droite.gif"></td>


                      </tr>


                      <tr>


                        <td background="../images/cartes/fond_M_gauche.gif"></td>


                        <td><img alt="" src="../images/cartes/.JPG"></td>


                        <td background="../images/cartes/fond_M_droite.gif"></td>


                      </tr>


                      <tr>


                        <td><img border=0px src="../images/cartes/angle_B_gauche.gif"></td>


                        <td background="../images/cartes/fond_B_centre.gif"></td>


                        <td><img border=0px src="../images/cartes/angle_B_droite.gif"></td>


                      </tr>


                    
                    </tbody>
                  
                  </table>
<br>
<table style="text-align: left; width: 760px;" border="0" cellpadding="0" cellspacing="0">

              <tbody>

                <tr>

                  <td colspan="4" rowspan="1"><img style="width: 760px; height: 11px;" alt="" src="../images/fixe/separateur_gd_tableau.gif"></td>

                </tr>

                <tr>

                  <td style="width: 210px;">
                  <div class="pointilles"><img style="border: 0px solid ; width: 17px; height: 14px; float: left;" alt="Recommander cette carte" src="../images/fixe/recommander.gif" hspace="5"><a href="../recommander.php?id=<? echo $adresse_carte; ?>">RECOMMANDER
CETTE CARTE</a></div>

                  </td>

                  <td style="width: 160px;">
                  <div class="pointilles"><img src="../images/fixe/mailer.gif" alt="Envoyer par e-mail" style="border: 0px solid ; width: 20px; height: 14px; float: left;" hspace="5"><a href='javascript:popup("../mail.php?adr=<? echo $adresse_carte; ?>")'>
ENVOYER PAR E-MAIL</a></div>

                  </td>

                  <td style="width: 190px;">
                  <div class="pointilles"><img style="border: 0px solid ; width: 12px; height: 14px; float: left;" alt="Partager sur Facebook" src="../images/fixe/facebook.gif" hspace="5">
                  <a href="http://www.facebook.com/sharer.php?u=http://www.retro-colo.fr/cartes/<? echo $adresse_carte; ?>.php&t=<? echo $titre_carte; ?>" target="_blank">PARTAGER SUR FACEBOOK</a></div>



                  </td>

                  <td style="width: 200px;">
                  <div class="pointilles"><img style="border: 0px solid ; width: 16px; height: 14px; float: left;" alt="Commenter cette carte" src="../images/fixe/commenter.gif" hspace="5">
<a href='javascript:popup("../add_commentaire.php?cat=carte&id=<? echo $id; ?>")'>COMMENTER
CETTE CARTE</a></div>

                  </td>

                </tr>

                <tr>

                  <td colspan="4" rowspan="1"><img style="width: 760px; height: 11px;" alt="" src="../images/fixe/separateur_gd_tableau.gif"></td>

                </tr>

                <tr>

                </tr>

              </tbody>
            </table>
                  <br>


                  <br>


                  
                  <div class="titre_une">Informations</div>


                  <br>


                  
                  <table style="border: 1px solid rgb(51, 51, 51); border-collapse: collapse; text-align: left; width: 760px;" border="1" cellpadding="0" cellspacing="1">


                    <tbody>


                      <tr>


                        <td style="width: 150px; vertical-align: top;" class="tab_cat">ANN&Eacute;E
:</td>


                        <td colspan="1" rowspan="1" <? if($date_carte == "") { ?> class="inconnu"> inconnu <? } else{ ?> class="tab_data"><? echo $date_carte; } ?></td>


                      </tr>


                      <tr>


                        <td style="width: 150px; vertical-align: top;" class="tab_cat">LIEU
:</td>


                        <td colspan="1" rowspan="1" <? if($lieu_carte == "") { ?> class="inconnu"> inconnu <? } else{ ?> class="tab_data"><? echo $lieu_carte; } ?></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">D&Eacute;PARTEMENT :</td>


                        <td colspan="1" rowspan="1" class="tab_data"></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">ORGANISATEUR :</td>


                        <td colspan="1" rowspan="1" <? if($organisateur_carte == "") { ?> class="inconnu"> inconnu <? } else{ ?> class="tab_data"><? echo $organisateur_carte; } ?></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">EDITEUR / AUTEUR :</td>


                        <td colspan="1" rowspan="1" <? if($editeur_carte == "") { ?> class="inconnu"> inconnu <? } else{ ?> class="tab_data"><? echo $editeur_carte; } ?></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">TH&Egrave;ME :</td>


                        <td colspan="1" rowspan="1" class="tab_data">Activités diverses</td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">PROVENANCE :</td>


                        <td colspan="1" rowspan="1" class="tab_data"></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">MOTS-CL&Eacute;S :</td>


                        <td colspan="1" rowspan="1" class="tab_data">A séparer par des virgules</td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">COMMENTAIRES :</td>


                        <td class="tab_data" colspan="1" rowspan="1" align="undefined" valign="undefined"></td>


                      </tr>
					  
					  <tr>


                        <td style="width: 150px; vertical-align: top;" class="tab_cat">NOMBRE DE VUES
:</td>


                        <td colspan="1" rowspan="1" class="tab_data"><? echo $nb_hit_carte; ?></td>


                      </tr>


                    
                    </tbody>
                  
                  </table>


                  <br>


                  <br>

<? 
$retour_commentaire = mysql_query("SELECT * FROM commentaire WHERE categorie_commentaire='carte' AND id_categorie_commentaire='$id' AND valid_commentaire='oui'") or die(mysql_error());
$number_commentaire=mysql_num_rows($retour_commentaire); 

?>
                  
                  <div class="titre_une">Commentaires (<? echo $number_commentaire; ?>)</div>


                  <br>


                  
                  <div class="titre_rub"><a href='javascript:popup("../add_commentaire.php?cat=carte&id=<? echo $id; ?>")'>Laisser un commentaire</a></div>


                  <br>


                  
                  <table style="text-align: left; width: 760px;" border="0" cellpadding="0" cellspacing="0">


                    <tbody>

<? while($commentaire = mysql_fetch_array($retour_commentaire))
{
$j1 = substr($commentaire["date_commentaire"],8,2);	// transformation de la date en JJ-MM-AAAA
			$m1 = substr($commentaire["date_commentaire"],5,2);
			$a1 = substr($commentaire["date_commentaire"],0,4);
			$date_commentaire = $j1."/".$m1."/".$a1;
?>
                      
					  <tr>


                        <td style="width: 25px;"><img style="width: 25px; height: 20px;" alt="Commentaire" src="../images/admin/pt_tab_commentaire.gif"></td>


                        <td style="width: 735px;" class="commentaires"><? echo $commentaire["pseudo_commentaire"]; ?>,
le <? echo $date_commentaire; ?></td>


                        

                      </tr>


                      <tr>


                        <td class="guillemets"></td>


                        <td colspan="1" rowspan="1" class="txt_blanc"><? echo $commentaire["texte_commentaire"]; ?></td>


                      </tr>


                      <tr>


                        <td colspan="2" rowspan="1"><img style="width: 760px; height: 11px;" alt="" src="../images/admin/separateur_gd_tableau.gif"></td>


                      </tr>

<? } ?>
                    
                    </tbody>
                  
                  </table>


                 

                  </td>


                </tr>


              
              </tbody>
            
            </table>



            </td>


            <td style="vertical-align: top; width: 20px;"></td>


          </tr>


        
        </tbody>
      
      </table>





      </td>


    </tr>


    <tr>


      <td><? include("http://www.retro-colo.fr/footer.inc.php"); ?></td>


    </tr>


  
  </tbody>
</table>


</body>
</html>
<?
mysql_close(); // déconnection de la base de donnée

?>
<?

session_start(); //ouverture session

mysql_connect("retrocol.mysql.db", "retrocol", "Q8mt88Vv6H"); // Connexion à MySQL
mysql_select_db("retrocol");	// Selection de la base de donnée

$retour_carte = mysql_query("SELECT * FROM carte WHERE adresse_carte=''") or die(mysql_error());
while($carte = mysql_fetch_array($retour_carte))
{
$id = $carte["id_carte"];
$titre_carte = $carte["titre_carte"];
$date_carte = $carte["date_carte"];
$lieu_carte = $carte["lieu_carte"];
$organisateur_carte = $carte["organisateur_carte"];
$editeur_carte = $carte["editeur_carte"];
$adresse_carte = $carte["adresse_carte"];
$nb_hit_carte = $carte["nb_hit_carte"];
} 

$nb_hit_carte++;

mysql_query("UPDATE carte SET nb_hit_carte='$nb_hit_carte' WHERE adresse_carte=''") or die(mysql_error());

?>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>


  
  <meta http-equiv="content-type" content="text/html; charset=ISO-8859-1">

  <script type="text/javascript">

  var _gaq = _gaq || [];
  _gaq.push(["_setAccount", "UA-30589039-1"]);
  _gaq.push(["_trackPageview"]);

  (function() {
    var ga = document.createElement("script"); ga.type = "text/javascript"; ga.async = true;
    ga.src = ("https:" == document.location.protocol ? "https://ssl" : "http://www") + ".google-analytics.com/ga.js";
    var s = document.getElementsByTagName("script")[0]; s.parentNode.insertBefore(ga, s);
  })();

</script>


  
  <title> - Retro-colo</title>
    <style type="text/css">
body {
background-color: #333333;
margin-top: 0px;
margin-bottom: 0px;
text-align: center;
}
  </style>
  
  <link type="text/css" href="../corps.css" rel="stylesheet">
  
  
  <script language="JavaScript">
  function popup(page) {
  window.open(page, "commentaire" , "width=600, height=400, scrollbars=no, location=no, directories=no");
  }
  </script>

</head>


<body>


<table style="margin: auto; text-align: left; margin-bottom: 0px; width: 1050px;" cellpadding="0" cellspacing="0">


  <tbody>


    <tr>


      <td><? include("../menu.inc.php"); ?></td>


    </tr>


    <tr>


      <td bgcolor="#333333">
      
      <table style="text-align: left; width: 1050px;" border="0" cellpadding="0" cellspacing="0">


        <tbody>


          <tr>


            <td style="vertical-align: top; width: 20px;"></td>


            <td style="width: 1010px;">
            
            <table style="text-align: left; width: 1010px;" border="0" cellpadding="0" cellspacing="0">


              <tbody>


                <tr>


                  <td style="width: 220px; vertical-align: top;"><? include("../menu_carte.inc.php"); ?></td>


                  <td style="width: 30px;"></td>


                  <td style="width: 760px; vertical-align: top;">
                  
                  <h1><div class="titre_une"></div></h1>


                  <br>


                  
                  <table style="margin: auto; text-align: left;" border="0" cellpadding="0" cellspacing="0">


                    <tbody>


                      <tr>


                        <td><img border=0px src="../images/cartes/angle_H_gauche.gif"></td>


                        <td background="../images/cartes/fond_H_centre.gif"></td>


                        <td><img border=0px src="../images/cartes/angle_H_droite.gif"></td>


                      </tr>


                      <tr>


                        <td background="../images/cartes/fond_M_gauche.gif"></td>


                        <td><img alt="" src="../images/cartes/.JPG"></td>


                        <td background="../images/cartes/fond_M_droite.gif"></td>


                      </tr>


                      <tr>


                        <td><img border=0px src="../images/cartes/angle_B_gauche.gif"></td>


                        <td background="../images/cartes/fond_B_centre.gif"></td>


                        <td><img border=0px src="../images/cartes/angle_B_droite.gif"></td>


                      </tr>


                    
                    </tbody>
                  
                  </table>
<br>
<table style="text-align: left; width: 760px;" border="0" cellpadding="0" cellspacing="0">

              <tbody>

                <tr>

                  <td colspan="4" rowspan="1"><img style="width: 760px; height: 11px;" alt="" src="../images/fixe/separateur_gd_tableau.gif"></td>

                </tr>

                <tr>

                  <td style="width: 210px;">
                  <div class="pointilles"><img style="border: 0px solid ; width: 17px; height: 14px; float: left;" alt="Recommander cette carte" src="../images/fixe/recommander.gif" hspace="5"><a href="../recommander.php?id=<? echo $adresse_carte; ?>">RECOMMANDER
CETTE CARTE</a></div>

                  </td>

                  <td style="width: 160px;">
                  <div class="pointilles"><img src="../images/fixe/mailer.gif" alt="Envoyer par e-mail" style="border: 0px solid ; width: 20px; height: 14px; float: left;" hspace="5"><a href='javascript:popup("../mail.php?adr=<? echo $adresse_carte; ?>")'>
ENVOYER PAR E-MAIL</a></div>

                  </td>

                  <td style="width: 190px;">
                  <div class="pointilles"><img style="border: 0px solid ; width: 12px; height: 14px; float: left;" alt="Partager sur Facebook" src="../images/fixe/facebook.gif" hspace="5">
                  <a href="http://www.facebook.com/sharer.php?u=http://www.retro-colo.fr/cartes/<? echo $adresse_carte; ?>.php&t=<? echo $titre_carte; ?>" target="_blank">PARTAGER SUR FACEBOOK</a></div>



                  </td>

                  <td style="width: 200px;">
                  <div class="pointilles"><img style="border: 0px solid ; width: 16px; height: 14px; float: left;" alt="Commenter cette carte" src="../images/fixe/commenter.gif" hspace="5">
<a href='javascript:popup("../add_commentaire.php?cat=carte&id=<? echo $id; ?>")'>COMMENTER
CETTE CARTE</a></div>

                  </td>

                </tr>

                <tr>

                  <td colspan="4" rowspan="1"><img style="width: 760px; height: 11px;" alt="" src="../images/fixe/separateur_gd_tableau.gif"></td>

                </tr>

                <tr>

                </tr>

              </tbody>
            </table>
                  <br>


                  <br>


                  
                  <div class="titre_une">Informations</div>


                  <br>


                  
                  <table style="border: 1px solid rgb(51, 51, 51); border-collapse: collapse; text-align: left; width: 760px;" border="1" cellpadding="0" cellspacing="1">


                    <tbody>


                      <tr>


                        <td style="width: 150px; vertical-align: top;" class="tab_cat">ANN&Eacute;E
:</td>


                        <td colspan="1" rowspan="1" <? if($date_carte == "") { ?> class="inconnu"> inconnu <? } else{ ?> class="tab_data"><? echo $date_carte; } ?></td>


                      </tr>


                      <tr>


                        <td style="width: 150px; vertical-align: top;" class="tab_cat">LIEU
:</td>


                        <td colspan="1" rowspan="1" <? if($lieu_carte == "") { ?> class="inconnu"> inconnu <? } else{ ?> class="tab_data"><? echo $lieu_carte; } ?></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">D&Eacute;PARTEMENT :</td>


                        <td colspan="1" rowspan="1" class="tab_data"></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">ORGANISATEUR :</td>


                        <td colspan="1" rowspan="1" <? if($organisateur_carte == "") { ?> class="inconnu"> inconnu <? } else{ ?> class="tab_data"><? echo $organisateur_carte; } ?></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">EDITEUR / AUTEUR :</td>


                        <td colspan="1" rowspan="1" <? if($editeur_carte == "") { ?> class="inconnu"> inconnu <? } else{ ?> class="tab_data"><? echo $editeur_carte; } ?></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">TH&Egrave;ME :</td>


                        <td colspan="1" rowspan="1" class="tab_data">Activités diverses</td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">PROVENANCE :</td>


                        <td colspan="1" rowspan="1" class="tab_data"></td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">MOTS-CL&Eacute;S :</td>


                        <td colspan="1" rowspan="1" class="tab_data">A séparer par des virgules</td>


                      </tr>


                      <tr>


                        <td style="vertical-align: top;" class="tab_cat">COMMENTAIRES :</td>


                        <td class="tab_data" colspan="1" rowspan="1" align="undefined" valign="undefined"></td>


                      </tr>
					  
					  <tr>


                        <td style="width: 150px; vertical-align: top;" class="tab_cat">NOMBRE DE VUES
:</td>


                        <td colspan="1" rowspan="1" class="tab_data"><? echo $nb_hit_carte; ?></td>


                      </tr>


                    
                    </tbody>
                  
                  </table>


                  <br>


                  <br>

<? 
$retour_commentaire = mysql_query("SELECT * FROM commentaire WHERE categorie_commentaire='carte' AND id_categorie_commentaire='$id' AND valid_commentaire='oui'") or die(mysql_error());
$number_commentaire=mysql_num_rows($retour_commentaire); 

?>
                  
                  <div class="titre_une">Commentaires (<? echo $number_commentaire; ?>)</div>


                  <br>


                  
                  <div class="titre_rub"><a href='javascript:popup("../add_commentaire.php?cat=carte&id=<? echo $id; ?>")'>Laisser un commentaire</a></div>


                  <br>


                  
                  <table style="text-align: left; width: 760px;" border="0" cellpadding="0" cellspacing="0">


                    <tbody>

<? while($commentaire = mysql_fetch_array($retour_commentaire))
{
$j1 = substr($commentaire["date_commentaire"],8,2);	// transformation de la date en JJ-MM-AAAA
			$m1 = substr($commentaire["date_commentaire"],5,2);
			$a1 = substr($commentaire["date_commentaire"],0,4);
			$date_commentaire = $j1."/".$m1."/".$a1;
?>
                      
					  <tr>


                        <td style="width: 25px;"><img style="width: 25px; height: 20px;" alt="Commentaire" src="../images/admin/pt_tab_commentaire.gif"></td>


                        <td style="width: 735px;" class="commentaires"><? echo $commentaire["pseudo_commentaire"]; ?>,
le <? echo $date_commentaire; ?></td>


                        

                      </tr>


                      <tr>


                        <td class="guillemets"></td>


                        <td colspan="1" rowspan="1" class="txt_blanc"><? echo $commentaire["texte_commentaire"]; ?></td>


                      </tr>


                      <tr>


                        <td colspan="2" rowspan="1"><img style="width: 760px; height: 11px;" alt="" src="../images/admin/separateur_gd_tableau.gif"></td>


                      </tr>

<? } ?>
                    
                    </tbody>
                  
                  </table>


                 

                  </td>


                </tr>


              
              </tbody>
            
            </table>



            </td>


            <td style="vertical-align: top; width: 20px;"></td>


          </tr>


        
        </tbody>
      
      </table>





      </td>


    </tr>


    <tr>


      <td><? include("http://www.retro-colo.fr/footer.inc.php"); ?></td>


    </tr>


  
  </tbody>
</table>


</body>
</html>
<?
mysql_close(); // déconnection de la base de donnée

?>
