|
",">",$ShortMsg);
$ShortMsg=str_replace("\"",""",$ShortMsg);
$ShortMsg=str_replace("'","'",$ShortMsg);
$ShortMsg=str_replace("http:","",$ShortMsg);
$Website=str_replace("&","&",$Website);
$Website=str_replace("<","<",$Website);
$Website=str_replace(">",">",$Website);
$Website=str_replace("\"",""",$Website);
$Website=str_replace("'","'",$Website);
$Visitor=str_replace("&","&",$Visitor);
$Visitor=str_replace("<","<",$Visitor);
$Visitor=str_replace(">",">",$Visitor);
$Visitor=str_replace("\"",""",$Visitor);
$Visitor=str_replace("'","'",$Visitor);
$EMail=str_replace("&","&",$EMail);
$EMail=str_replace("<","<",$EMail);
$EMail=str_replace(">",">",$EMail);
$EMail=str_replace("\"",""",$EMail);
$EMail=str_replace("'","'",$EMail);
if ($Website=="http://") { $Website=""; };
//CHECK DUPLICATES DUE TO REFRESH
if (!isset($_SESSION["guestbook"]))
{
$_SESSION["guestbook"]=1;
$InsertString="INSERT INTO guestbook (posted, visitor, email, url, message, dutch, Score, ip) VALUES(Now(), '".$Visitor."', '".$EMail."', '".$Website."', '".$ShortMsg."', '".$Language."', ".$YourScore.", '".$ip."');";
// echo $InsertString;
$Conn = mysql_query($InsertString);
mail("webmaster@weethet.nl","Nieuwe melding in het Engelse Gastenboek van: ".$Visitor, "Bericht: ".$ShortMsg." - email:".$EMail,"From: webmaster@weethet.nl\r\n");
$Visitor="";
$EMail="";
$Website="http://";
$ShortMsg="";
}
else {
if ($Addmessage=="addmsg")
{
?>
ERROR: Already posted from this IP addres!
Sign the guestbook here ...
Previously posted messages
// RECORDS WEERGEVEN
//Define record field names
$fcount=0;
$fDate=1;
$fvisitor=2;
$femail=3;
$furl=4;
$fmessage=5;
$fdutch=6;
$fscore=7;
$sSum=0;
$sCount=1;
$MessagesPerPage=10;
$sql = mysql_query("SELECT Sum(guestbook.score), Count(guestbook.count) FROM guestbook;");
$qMsg = mysql_fetch_array($sql);
$ScoreSum=$qMsg[$sSum];
$ScoreCount=$qMsg[$sCount];
$PaginaTotaal=intval($ScoreCount/$MessagesPerPage);
if (($PaginaTotaal*10)<$ScoreCount)
{ $PaginaTotaal=$PaginaTotaal+1; }
$FirstPage=1;
$LastPage=$PaginaTotaal;
$PreviousPage=$Pagina-1;
$NextPage=$Pagina+1;
if ($PreviousPage<1) { $PreviousPage=1; };
if (($PaginaTotaal-$NextPage)<0) { $NextPage=$LastPage; };
$QString="SELECT guestbook.Count, guestbook.posted, guestbook.visitor, guestbook.email, guestbook.url, guestbook.message, guestbook.dutch, guestbook.Score FROM guestbook ORDER BY guestbook.Count DESC;";
$sql = mysql_query($QString);
?>
Number of messages: echo $ScoreCount; ?> ,
average score: echo round($ScoreSum/$ScoreCount,1); ?>
| |
- Page echo $Pagina; ?>/ echo $PaginaTotaal; ?> -
|
|
| |
if ($Pagina>1)
{
for ($counter=$MessagesPerPage+1; $counter<=($Pagina*$MessagesPerPage); $counter++)
{ $qMsg = mysql_fetch_array($sql, MYSQL_NUM); }
}
$counter=1;
while((($qMsg = mysql_fetch_array($sql, MYSQL_NUM)) && ($counter<$MessagesPerPage+1)))
{
$timestampie=strtotime($qMsg[$fDate])+$servertimeadjust;
$DatumStr=strftime("%b %d, %Y [%H:%M]", $timestampie);
?>
echo $DatumStr; ?> -
echo $qMsg[$fvisitor]; ?>
if ((($qMsg[$furl]!="") && ($qMsg[$furl]!="http://") && ($qMsg[$furl]!="-")))
{
?>
[Favorit website]
}
?>
echo $qMsg[$fmessage]; ?>
$counter=$counter+1;
} ?>
|
|
| |
|
|
|