"; print $Kopregel; print ": "; print $Kop; print ""; print ""; ?>

'') {$displaydatum.='-';} $displaydatum.=substr($Datum, 5, 2); if ($displaydatum<>'') {$displaydatum.='-';} $displaydatum.=substr($Datum, 0, 4); $displaydatum=str_replace ('--', '-', $displaydatum); $displaydatum=str_replace (' ', '', $displaydatum); $Txt=$Dbvalues['Txt1']; $Txt.=' '; $Txt.=$Dbvalues['Txt2']; $Txt.=' '; $Txt.=$Dbvalues['Txt3']; $Txt.=' '; $Txt.=$Dbvalues['Txt4']; $Txt.=' '; $Txt.=$Dbvalues['Txt5']; $Txt.=' '; $Txt.=$Dbvalues['Txt6']; $Txt.=' '; $Txt.=$Dbvalues['Txt7']; if (strlen($Txt)<560) { if($PicURL<>"") { print " "; } } print "$Kop, $displaydatum

"; if (strlen($Txt)>559) { if($PicURL<>"") { print " "; } } if (!$Dbvalues['Loc']=="") { print "$Loc - "; } print "$Txt1

"; if($Txt2<>"") { print "$Txt2

"; } if($Txt3<>"") { print "$Txt3

"; } if($Txt4<>"") { print "$Txt4

"; } if($Txt5<>"") { print "$Txt5

"; } if($Txt6<>"") { print "$Txt6

"; } if($Txt7<>"") { print "$Txt7

"; } if($Bron<>"") { print "Bron: $Bron

"; } if(!isset($_GET['toonreacties'])) { $toonreacties="N"; } else { $toonreacties=$_GET['toonreacties']; } $order="SELECT * from Reacties_berichten where onderdeel='$onderdeel' and parent_ID=$ID"; $order2=mysqli_query($db, $order) or die(mysqli_error($db)); $num=mysqli_num_rows($order2); if($toonreacties<>"J") { if($num==1) { print "  $num reactie
"; } else { print "  $num reacties
"; } } else { print "
"; if($num==1) { print "
  $num reactie

"; } else { if($num==0) { print "
  $num reacties
"; } else { print "
  $num reacties

"; } } $teller=$num; $teller++; while($order3=mysqli_fetch_array($order2)) { $Reactie_var="Select * FROM Reacties_berichten where onderdeel='$onderdeel' and parent_ID=$ID order by ID DESC"; //retrieve entries from sql $row=mysqli_query($db, $Reactie_var); } ?> "; } ?>
$teller. $Reactie_values[naam], $Reactie_values[woonplaats]  "; } else { print "
$teller. $Reactie_values[naam]  "; } if($Reactie_values['homepage']) { print "  "; } if($Reactie_values['mail']) { print " "; } print "
$Reactie_values[bericht]
"; $postdate=date("d-m-Y H:i",$Reactie_values['time']); $postdate=str_replace(' ', ', ', $postdate); print "Gepost op $postdate


Reageer

"; print "
"; while($ipbancheck3=mysqli_fetch_array($ipbancheck2)) { $IPBANNED=$ipbancheck3['IP']; } if (isset($IPBANNED)) { print "Jij mag niet posten."; } else { if (!isset($_POST['submit'])) { $parent_ID=$_GET['ID']; print "
"; print ""; print ""; print ""; print ""; print ""; print "
"; print "
NaamVerplicht veld:
Woonplaats:
Homepage:
EmailVerplicht veld:
BerichtVerplicht veld:
"; print "
"; print ""; print ""; print ""; print ""; print ""; print ""; print "
"; print "
"; print "
"; } else if (isset($_POST['submit'])) { $ID=trim($_GET['ID']); $name=trim($_POST['name']); $country=trim($_POST['country']); $email=trim($_POST['email']); $homepage=trim($_POST['homepage']); if (!$homepage == "") { $pos=strpos($homepage, "http://"); if ($pos === false) { $homepage="http://" . $homepage; } } $comment=$_POST['comment']; $NumBannedWords = substr_count($comment, 'http'); $Melding="Je hebt geen naam of bericht ingevuld! Probeer het opnieuw"; $MeldingHTML="Geen HTML en geen spam invoeren, graag! Probeer het opnieuw"; if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'HTTP'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'href'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'HREF'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($country, '75'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($country, 'Other'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($country, 'Canada'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($country, 'other'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'ery good'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'orry :('); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'Cool'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'nteresting'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'nice'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($homepage, 'link'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'Nice'); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } $NumBannedWords = substr_count($comment, 'xcellent '); if ($NumBannedWords>0) { $name=''; $Melding=$MeldingHTML; } if(!$email) { print "Email moet ingevuld zijn. Probeer het opnieuw.
"; } else { if(!$name || !$comment) { print "$Melding
"; } else { $r=$_SERVER["REMOTE_ADDR"]; $day=date("D M d, Y H:i:s"); $timegone=date("U") ; //seconds since Jan 1st, 1970 $putinguestbook="INSERT INTO Reacties_berichten(onderdeel, parent_ID, naam, woonplaats, mail, homepage, bericht, realtime, time,IP) VALUES('$onderdeel','$ID','$name','$country','$email','$homepage','$comment','$day','$timegone','$r')"; mysqli_query($db, $putinguestbook); print " "; } } } } } print "
"; ?>