<?php
///////////////////////////////////////////
// mcGuestbook 1.2 //
// Marc Cagninacci -
marc@phpforums.net //
// http://www.phpforums.net //
///////////////////////////////////////////
include "mcgconf.inc.php";
include "$lang";
$connect= mysql_connect($host,$login,$pass);
mysql_select_db($base, $connect);
$resultat=mysql_query("SELECT id FROM mcguestbook");
if(!$start)
{$start=0;}
$mcgnum = mysql_num_rows($resultat);
$config=mysql_query("SELECT * FROM mcguestbook_conf");
$conf=mysql_fetch_row($config);
$fontface =$conf[1];
$fontsize =$conf[2];
$fonttitrcolor =$conf[3];
$fontmesscolor =$conf[4];
$liencolor =$conf[5];
$hovercolor =$conf[6];
$bgtitrcolor =$conf[7];
$bgmesscolor =$conf[8];
$bgpagecolor =$conf[9];
$nomsite =$conf[10];
$monemail =$conf[11];
$mcgnb =$conf[12];
?>
<html>
<head>
<title>LIVRE D'OR</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>
<style type="text/css">
<!--
a:link { font-family: <? echo $fontface; ?>; color: <? echo $liencolor; ?>; text-decoration: none}
a:actif { font-family: <? echo $fontface; ?>;color: <? echo $liencolor; ?>; text-decoration: none}
a:hover { font-family: <? echo $fontface; ?>; color: <? echo $hovercolor; ?>; text-decoration: none}
a:visited { font-family: <? echo $fontface; ?>; color: <? echo $liencolor; ?>; text-decoration: none}
-->
</style>
<body bgcolor="<? echo $bgpagecolor; ?>" text="<? echo $fonttitrcolor; ?>">
////////////////////////////////////////////////////////////////////////
<td width=15%"><?php include('menu.php');?></td>
<td width="85%">
<?
$nb=$mcgnb;
if(!$start)
{$start=0;}
$jour= date("Y-m-d");
$resultat=mysql_query("SELECT id FROM mcguestbook where date = '$jour'");
$njour= mysql_num_rows($resultat);
if ($njour>=1) {
$njour=', '.$njour.' '.$lAujourdhui;
}
else {$njour="";}
if($mcgnum>1) {$message=$lMessages;}
else {$message=$lMessage;}
echo '<table width="95%" cellspacing="0" align="center" bgcolor="'.$bgmesscolor.'">';
echo '<tr><td><font face="'.$fontface.'" size="'.$fontsize.'" color="'.$fontmesscolor.'">'.$mcgnum.' '.$message.$njour.'.</font></td>';
echo '<td align="right"><font face="'.$fontface.'" size="'.$fontsize.'"><b><a href="index.php?page=ecrire">'.$lEcrire.'</a></b></font></td></tr></table>';
echo '<br>';
//Barre de navigation - haut
echo '<table width="95%" cellspacing="0" align="center" bgcolor="'.$bgmesscolor.'"><tr><td width="33%" align="left"> ';
if($start)
{
echo '<a href="lire.php?start='.($start-$nb).'"><img src="http://membres.lycos.fr/fdeconiac/livre_dor/images/gauche.gif" border="0" alt="'.$lPagePrec.'"></a>';
}
$result=mysql_query("SELECT COUNT(id) FROM mcguestbook");
$row=mysql_fetch_row($result);
echo '</td><td align="center"><font color="'.$fontmesscolor.'" face="'.$fontface.'" size="'.$fontsize.'">';
echo $lPage.' ';
echo ($start + $nb)/$nb;
echo ' '.$lSur.' ';
echo ceil($mcgnum/ $nb);
echo '</font></td><td bgcolor="'.$bgmesscolor.'" width="33%" align="right"> ';
if($row[0]>($start+$nb))
{
if($start)
{
print(" ");
}
echo '<a href="lire.php?start='.($start+$nb).'"><img src="http://membres.lycos.fr/fdeconiac/livre_dor/images/droit.gif" border="0" alt="'.$lPageSuiv.'"></a>';
}
echo '</font></td></tr>';
echo '</table><br>';
//Récupération et affichage des messages
$result=mysql_query("SELECT * FROM mcguestbook ORDER BY id DESC LIMIT $start,$nb");
while($enr=mysql_fetch_array($result))
{
echo '<table width="95%" cellspacing="0" align="center" bgcolor="'.$bgmesscolor.'"><tr><td bgcolor="'.$bgtitrcolor.'" align="center" width="80"> ';
if($enr[3]!=""){
echo '<a href="mailto:'.htmlspecialchars($enr[3]).'"><img src="http://membres.lycos.fr/fdeconiac/livre_dor/images/email.gif" border="0" alt="mal"></a> ';
}
if($enr[4]!=""){
if (substr($enr[4], 0, 4) != 'http') $http = 'http://';
echo ' <a href="'.$http . htmlspecialchars($enr[4]).'" target="_blank"><img src="http://membres.lycos.fr/fdeconiac/livre_dor/images/site.gif" border="0" alt="home"></a>';
}
echo ' </td><td bgcolor="'.$bgtitrcolor.'"><font face="'.$fontface.'" color="'.$fonttitrcolor.'" size="'.$fontsize.'"> <b>'.stripslashes($enr[1]).'</b>';
echo '</font></td>';
echo '<td bgcolor="'.$bgtitrcolor.'" align="right" width="80"><font face="'.$fontface.'" color="'.$fonttitrcolor.'" size="'.$fontsize.'">';
list($y,$m,$d) = explode("-",$enr[2]);
$mdate = $d.' '.$m.' '.$y;
echo $mdate;
echo '</font></td></tr><tr>';
echo '<td align="center">';
if($enr[5]!=""){
echo '<a href="'.htmlspecialchars($enr[4]).'" target="_blank"><img src="'.htmlspecialchars($enr[5]).'" height="40" width="80" border="0"></a>';
}
else {
echo ' ';
}
echo '</td><td><font face="'.$fontface.'" color="'.$fontmesscolor.'" size="'.$fontsize.'">';
$rep=" ";
$len=20;
$enr[6]=preg_replace('/([^ ]{'.$len.'})/si','\\1'.$rep,$enr[6]);
$enr[6]=nl2br(htmlspecialchars($enr[6]));
$m=eregi_replace(":\)","<img src=http://membres.lycos.fr/fdeconiac/livre_dor/images/content.gif align=\"middle\">", $enr[6]);
$m1=eregi_replace(":grr:","<img src=http://membres.lycos.fr/fdeconiac/livre_dor/images/grr.gif align=\"middle\">", $m);
$m2=eregi_replace("\?!\?","<img src=http://membres.lycos.fr/fdeconiac/livre_dor/images/crazy2.gif align=\"middle\">", $m1);
$m3=eregi_replace(":\(","<img src=http://membres.lycos.fr/fdeconiac/livre_dor/images/cry.gif align=\"middle\">", $m2);
echo ' '.stripslashes($m3).'</font></td><td> </td>';
echo '</tr></table><br>';
}
echo '<br><table width="95%" cellspacing="0" align="center">';
echo '<tr><td bgcolor="'.$bgmesscolor.'" width="33%" align="left"> ';
//Barre de navigation - bas
if($start)
{
echo '<a href="lire.php?start='.($start-$nb).'"><img src="http://membres.lycos.fr/fdeconiac/livre_dor/images/gauche.gif" border="0" alt="'.$lPagePrec.'"></a> ';
}
$result=mysql_query("SELECT COUNT(id) FROM mcguestbook");
$row=mysql_fetch_row($result);
mysql_close($connect);
echo '</td><td bgcolor="'.$bgmesscolor.'" width="33%" align="center"><font color="'.$fontmesscolor.'" face="'.$fontface.'" size="'.$fontsize.'">';
echo $lPage.' ';
echo ($start + $nb)/$nb;
echo ' '.$lSur.' ';
echo ceil($mcgnum/ $nb);
echo '</font></td><td bgcolor="'.$bgmesscolor.'" align="right"> ';
if($row[0]>($start+$nb))
{
if($start)
{
print(" ");
}
echo '<a href="lire.php?start='.($start+$nb).'"><img src="http://membres.lycos.fr/fdeconiac/livre_dor/images/droit.gif" border="0" alt="'.$lPageSuiv.'"></a>';
}
echo '</font></td></tr>';
echo '</table><br>';
?>
<p align="center"><font size="2"><a href="<? echo $url; ?>"><b><? echo $lRet; ?></b></a></font>
<br><br>
</a>
</p>
</td>
</tr>
<tr>
<?php include("footer.php");?>
</tr>
////////////////////////////////////////////////////////////////////////
</body>
</html>