<?php
include("ConfigInit.inc.php");
$con=mysql_connect(MYSQL_HOST, MYSQL_USER, MYSQL_PWD) or die('probleme de connection a la base');
mysql_select_db(MYSQL_DB_NAME, $con) or die('probleme de selection de la base');
if($texte!="" && $nom!="") {
	$sql="insert into livredor values(0,'".addslashes($nom)."','".addslashes($pays)."','".addslashes($email)."','".addslashes(str_replace('http://','',$lien))."','".addslashes($texte)."',CURRENT_DATE,0);";
	mysql_query($sql) or die("insertion echouee");
	}
$sql="select nom, pays, email, lien, texte, UNIX_TIMESTAMP(date) as date from livredor where afficher=1 order by date DESC;";
$res=mysql_query($sql);
?>
<html>
<head>
<title>Alshaworthias - Livre d'or</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<meta name="description" content="Site de prˆsentation d'une collection de plantes succulentes">
<meta name="keywords" content="alshaworthias, plantes, plantes succulentes, cactus, cactˆes, culture de succulentes, Alsace, plantes en serre, bouturage, semis">
<meta name="revisit-after" content="15 days">
<meta name="Creation_Date" content="2002/01/01">
<meta name="robots" content="Index, Follow">
<link rel="stylesheet" href="../succ.css" type="text/css">
<script language="javascript">
img_1=new Image();
img_1.src="../media/nav_gauche/a_11.gif";
img_2=new Image();
img_2.src="../media/nav_gauche/a_22.gif";
img_3=new Image();
img_3.src="../media/nav_gauche/a_33.gif";
img_4=new Image();
img_4.src="../media/nav_gauche/a_44.gif";
img_5=new Image();
img_5.src="../media/nav_gauche/a_55.gif";
img_6=new Image();
img_6.src="../media/nav_gauche/a_66.gif";
img_7=new Image();
img_7.src="../media/nav_haut/c_11.gif";

function setImg(imgName, srcFile)
	{
	imgName.src=srcFile;
	}
	
function popUp(src,name,x,y,w,h)
	{
	window.open(src,name,"left="+x+",top="+y+",height="+h+",width="+w+",scrollbars=1,status=0,location=0,menubar=0,resizable=0");
	}

</script>
</head>

<body bgcolor="#FFFFFF" text="#000000" background="../media/fond_pg.gif" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
<form name="form1" method="post" action="livredor.php3">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td align="left" width="1%">
      <table border="0" cellspacing="0" cellpadding="0">
        <tr>
            <td><a href="../../index.htm"><img src="../media/logo_acc.jpg" width="232" height="61" border="0"></a></td>
        </tr>
      </table>
    </td>
    <td valign="top" width="99%" class="vardana10noir"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0" background="../media/nav_haut/fond.jpg">
        <tr>
          <td valign="top" align="left" background="../media/nav_haut/fond.jpg"><img src="../media/vide.gif" width="444" height="40"><a href="mailto:prudhonch@wanadoo.fr" onMouseover="setImg(c1,'../media/nav_haut/c_11.gif');" onMouseout="setImg(c1, '../media/nav_haut/c_1.gif');"><img src="../media/nav_haut/c_1.gif" width="100" height="24" border="0" name="c1"></a></td>
        </tr>
      </table>
      <img src="../media/vide.gif" width="551" height="20"></td>
  </tr>
</table>
<table width="95%" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td width="123" valign="top"><img src="../media/nav_gauche/degrad1.jpg" width="89" height="61"><br>
      <a href="substrats.htm" onMouseover="setImg(a1,'../media/nav_gauche/a_11.gif');" onMouseout="setImg(a1, '../media/nav_gauche/a_1.gif');"><img src="../media/nav_gauche/a_1.gif" width="123" height="35" name="a1" border="0"></a><br>
      <a href="semis.htm" onMouseover="setImg(a2,'../media/nav_gauche/a_22.gif');" onMouseout="setImg(a2, '../media/nav_gauche/a_2.gif');"><img src="../media/nav_gauche/a_2.gif" width="123" height="34" name="a2" border="0"></a><br>
      <a href="litterature.htm" onMouseover="setImg(a3,'../media/nav_gauche/a_33.gif');" onMouseout="setImg(a3, '../media/nav_gauche/a_3.gif');"><img src="../media/nav_gauche/a_3.gif" width="123" height="34" name="a3" border="0"></a><br>
      <a href="sources.htm" onMouseover="setImg(a4,'../media/nav_gauche/a_44.gif');" onMouseout="setImg(a4, '../media/nav_gauche/a_4.gif');"><img src="../media/nav_gauche/a_4.gif" width="123" height="34" name="a4" border="0"></a><br>
      <a href="collection.php" onMouseover="setImg(a5,'../media/nav_gauche/a_55.gif');" onMouseout="setImg(a5, '../media/nav_gauche/a_5.gif');"><img src="../media/nav_gauche/a_5.gif" width="123" height="33" name="a5" border="0"></a><br>
      <img src="../media/nav_gauche/a_66.gif" width="123" height="48" name="a6" border="0"><br>
      <img src="../media/nav_gauche/boutons.gif" width="89" height="110" border="0" usemap="#Map">
      <map name="Map">
        <area shape="circle" coords="44,33,30" href="collect_result.php3?new_only=yes">
        <area shape="rect" coords="12,74,76,102" href="collect_result.php3?to_sell=yes">
      </map></td>
    <td width="67"><img src="../media/vide.gif" width="67" height="10" class="vardana10boldvert"></td>
    <td valign="top"> 
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td><img src="../media/vide.gif" width="590" height="19"></td>
        </tr>
        <tr> 
            <td><img src="../media/livredor/tit_1.gif" width="103" height="21"></td>
        </tr>
        <tr> 
          <td background="../media/vide.gif"><img src="../media/accueil/pointille.gif" width="189" height="3"></td>
        </tr>
        <tr>
          <td><img src="../media/vide.gif" width="10" height="10"> </td>
        </tr>
      </table>
      <table width="100%" border="0" cellspacing="0" cellpadding="0">
        <tr> 
          <td>
              <table border="0" cellspacing="0" cellpadding="0">
                <tr> 
                <td><img src="../media/vide.gif" width="10" height="10"></td>
                <td class="vardana11noir">
                    <table border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td class="vardana11noirbold"><a href="#ecrire"><img src="../media/livredor/but_1.gif" width="116" height="19" border="0"></a></td>
                      </tr>
                      <tr> 
                        <td class="vardana11noirbold">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td class="vardana11noirbold">Messages laiss&eacute;s 
                          dans le livre d'or</td>
                      </tr>
                      <tr> 
                        <td class="vardana11noirbold">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td> 
                          <table border="0" cellspacing="3" cellpadding="0" width="500px">
                            <?
					while($val=mysql_fetch_array($res)) {
                    	print("<tr><td class='vardana12noirbold' valign='top'>&#149;&nbsp;</td>\n");
                   		printf("<td class='vardana11noir'><span class='vardana12noirbold'>%s, le %s</span><br>\n",$val['nom'], date("d-m-Y",$val['date']));
						print("<img src='../media/vide.gif' width='10' height='4'><br>");
                        printf("%s<br>\n",$val['texte']);
						print("<img src='../media/vide.gif' width='10' height='4'><br>");
						$val['pays']!=""?printf("<span class='vardana11noirbold'>pays&nbsp;:&nbsp;</span>%s<br>\n", $val['pays']):print("");
                    	$val['email']!=""?printf("<span class='vardana11noirbold'>e-mail&nbsp;:&nbsp;</span><a href='mailto:%s' class='a10boldvert'>%s</a><br>\n",$val['email'], $val['email']):print("");
                        $val['lien']!=""?printf("<span class='vardana11noirbold'>site web&nbsp;:&nbsp;</span><a href='http://%s' class='a10boldvert' target='_blank'>%s</a>\n", $val['lien'], $val['lien']):print("");
                      	print("</td>\n");
                    	print("</tr>\n");
                    	print("<tr>\n");
                      	print("<td><img src='../media/vide.gif' width='10' height='1'></td>\n");
                      	print("<td bgcolor='#FF9900'><img src='../media/vide.gif' width='10' height='1'></td>\n");
                    	print("</tr>\n");
                    	print("<tr>\n");
                      	print("<td>&nbsp;</td><td>&nbsp;</td>\n");
                    	print("</tr>\n");
						}
					?>
                          </table>
                        </td>
                      </tr>
                      <tr> 
                        <td><img src="../media/vide.gif" width="10" height="25"></td>
                      </tr>
                      <tr> 
                        <td class="vardana11noirbold"><a name="ecrire"></a>Pour 
                          &eacute;crire un message dans le livre d'or, remplissez 
                          le formulaire</td>
                      </tr>
                      <tr> 
                        <td class="vardana11noirbold">&nbsp;</td>
                      </tr>
                      <tr> 
                        <td class="vardana10noir"> 
                          <table border="0" cellspacing="0" cellpadding="0">
                            <tr> 
                              <td class="vardana11noir">Votre nom ou surnom<font color="#FF0000">*</font></td>
                              <td><img src="../media/vide.gif" width="10" height="10"></td>
                              <td class="vardana11noir"> 
                                <input type="text" name="nom">
                              </td>
                            </tr>
                            <tr>
                              <td class="vardana11noir">Votre pays</td>
                              <td>&nbsp;</td>
                              <td class="vardana11noir">
                                <input type="text" name="pays">
                              </td>
                            </tr>
                            <tr> 
                              <td class="vardana11noir">Votre e-mail</td>
                              <td>&nbsp;</td>
                              <td class="vardana11noir"> 
                                <input type="text" name="email">
                              </td>
                            </tr>
                            <tr> 
                              <td class="vardana11noir">L'adresse de votre site</td>
                              <td>&nbsp;</td>
                              <td class="vardana11noir"> 
                                <input type="text" name="lien">
                              </td>
                            </tr>
                            <tr> 
                              <td class="vardana11noir">Le texte de votre message<font color="#FF0000">*</font><br>
                                <br>
                              </td>
                              <td>&nbsp;</td>
                              <td class="vardana11noir"> 
                                <textarea name="texte" cols="30" rows="5"></textarea>
                              </td>
                            </tr>
                          </table>
                          <br>
                          <font color="#FF0000">*</font>champs obligatoires&nbsp;:<br>
                          s'ils ne sont pas renseign&eacute;s,<br>
                          votre message ne sera pas enregistr&eacute;<br>
                          <br>
                          <input type="submit" name="Submit" value="Enregitrer">
                        </td>
                      </tr>
                    </table>
                </td>
              </tr>
            </table>
          </td>
        </tr>
        <tr> 
            <td><img src="../media/vide.gif" width="10" height="150"></td>
        </tr>
      </table>  
    </td>
  </tr>
</table>
</form>
</body>
</html>
