", $text); $text = stripslashes($text); $text = trim($text); return $text; } if($submit){ ## submitting script ###################################### $id="home"; if($nieuwbericht){ $connect = @mysql_connect($sql_server, $sql_username, $sql_password) or die("".$sqlc1."
".$sqlt1); mysql_select_db($sql_database); $gbdb = mysql_query("SELECT nummer,naam,email,url,bericht,comment,tijd,datum FROM gbooknts ORDER BY nummer DESC"); $rij = mysql_fetch_array($gbdb); $nieuwnummer = $rij["nummer"]; $nieuwnummer = $nieuwnummer + 1; $nieuwdatum = date("d-m-y"); $nieuwtijd = date("H:i:s"); if($in_checkhtml){ $nieuwbericht = flt_tags($nieuwbericht); $nieuwnaam = flt_tags($nieuwnaam); $nieuwurl = flt_tags($nieuwurl); } $insertstring = "INSERT INTO gbooknts(nummer,naam,email,url,bericht,comment,tijd,datum) VALUES('$nieuwnummer', '$nieuwnaam', '$nieuwemail', '$nieuwurl', '$nieuwbericht', '$nieuwcomment', '$nieuwtijd', '$nieuwdatum');"; mysql_query($insertstring); mysql_free_result($gbdb); $submit = ""; } else {$err_txt = $errt1; $err_cap = $errc1; $id="error";} } if($admin){ ## Admin inlog script ################################# $admin = ""; $id = "home"; if ($password == $in_password){ $psswd = $password; session_register("psswd"); $psswd = $password; } else {$err_txt = $errt1; $err_cap = $errc1; $id="error";} } if($uitloggen){ ## Uitlog Script ###################################### $psswd=""; session_unregister("psswd"); $id = "error"; $err_cap = $msgc1; $err_txt = $msgt1; } if($id=="trash"){ ## delete Script ###################################### if($psswd == $in_password){ $connect = @mysql_connect($sql_server, $sql_username, $sql_password) or die("".$sqlc1."
".$sqlt1); mysql_select_db($sql_database); $killstring = "DELETE from gbooknts WHERE nummer=".$welke.";"; mysql_query($killstring); mysql_close ($connect); $err_txt = $msgt3; $err_cap = $msgc3; $id="error"; } else {$err_txt = $errt4; $err_cap = $errc4; $id="error";} } if($comment){ ## Comment Script ###################################### if($psswd == $in_password){ $id="home"; $connect = @mysql_connect($sql_server, $sql_username, $sql_password) or die("".$sqlc1."
".$sqlt1); mysql_select_db($sql_database); $killstring = "DELETE from gbooknts WHERE nummer=".$nieuwnummer.";"; $insertstring = "INSERT INTO gbooknts(nummer,naam,email,url,bericht,comment,tijd,datum) VALUES('$nieuwnummer', '$nieuwnaam', '$nieuwemail', '$nieuwurl', '$nieuwbericht', '$nieuwcomment', '$nieuwtijd', '$nieuwdatum');"; mysql_query($killstring); mysql_query($insertstring); $comment=""; } else {$err_txt = $errt2; $err_cap = $errc2; $id="error"; $comment="";} } ## begin van de html ######################################### ?>

[ "> | "> | "> ] | "> ]

".$sqlc1." ".$sqlt1); mysql_select_db($sql_database) or die("".$sqlc1." ".$sqlt1); $gbdb = mysql_query("SELECT nummer,naam,email,url,bericht,comment,tijd,datum FROM gbooknts ORDER BY nummer DESC") or die("".$sqlc1." ".$sqlt1); $aantalregels = mysql_num_rows($gbdb); if ($aantalregels>0) { while($rij=mysql_fetch_array($gbdb)) { ?> ">" src="images/email.gif" border=0 width=18 height=14"> ">" src="images/homepage.gif" border=0 width=18 height=14"> "> "> °

HTML filter active

: : : :

".$sqlc1." ".$sqlt1); mysql_select_db($sql_database) or die("".$sqlc1." ".$sqlt1); $query = "SELECT * FROM gbooknts WHERE nummer='$welke' "; $gbdb = mysql_query($query); $rij = mysql_fetch_array($gbdb); ?> : " name="nieuwnummer"> : "> : "> : " size="40"> : " name="nieuwdatum"> : " name="nieuwtijd"> : <? print($rij["bericht"]); ?> : <? print($rij["comment"]); ?>