The entry has been APPROVED and is now displayed in the Guestbook



"; }; if ($deleteguestbook=='YES') { $sql="delete from guestbook where id=".$id." and passid=".$pass; $result = mysql_query($sql,$dbi); $msg="



The entry has been deleted from our database.



"; }; if ($sendform=='YES' and $msg=="") { //Check if a name & comment have been entered if ($comment=="") { $msg.= "
You haven't Entered any comment. The entry is not accepted."; } ; $tpass=rand(99,9999); if (strpos(" ".$comment,'http')>0 || strpos(" ".$name,'http')>0 || strpos(" ".$country,'http')>0 ){ $msg.="
Your comment contains the word [http]. This is not allowed, please remove any links from the comment."; } if (strpos(" ".$comment,'www')>0 || strpos(" ".$name,'www')>0 || strpos(" ".$country,'www')>0 ){ $msg.="
Your comment contains the word [www]. This is not allowed, please remove any links from the comment."; } if ($msg==''){ // Insert the Details into the Database $sql = "INSERT INTO guestbook (name,email,v_comment,country,approved,insertdate,passid) VALUES ('$name','$email','$comment','$country',0,'".date("Y-m-d h:m:s")."',$tpass)"; $result = mysql_query($sql,$dbi); $id = mysql_insert_id( ); if ($languagecode==0){ If ($result) { } else { $msg.=" Your guestbook entry has not added due to some database problem. You may send your entry by email."; }; }; }; if ($msg==''){ $headers = "MIME-Version: 1.0\r\n"; $headers .= "Content-type: text/html; charset=windows-1253\r\n"; $mailBody .= 'There was a guestbook entry at romeo.gr with the following information:
'; $mailBody .= 'Name: '.$name."
"; $mailBody .= 'Email: '.$email."
"; $mailBody .= 'Country: '.$country."
"; $mailBody .= 'Comment:'."
".$comment."
"; $mailBody .= "

CLICK ->>APPROVE to approve this message and add it in the guestbook"; $mailBody .= "

CLICK ->>DELETE to DELETE this message"; if ($email=='') $emailfrom='manos@brainsoft.gr'; else $emailfrom=$email; mail("manos@brainsoft.gr","GUESTBOOK ENTRY From ROMEO", $mailBody, "From: $emailfrom\r\n".$headers); $msg.="

Your Details have been added to the database.
We will read your comment and will post it at soon as possible at the guestbook
Thank you for your visit.
"; $msg.=" Click here to go back to the guestbook

" ; }; //if msg }; // sendform //XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX ?> Romeo Garden restaurant
'; $st.=''; while ($row = mysql_fetch_row($result)) { $st.=''; }; $st.='


GuestBook  •  Cancel
To log your visit in our guestbook, please fill in the following information.
Thank you for your visit.
Your Name:
Your Email ID:
Will not be published
Country:
Comments :
'; $st.='
Romeo GuestBook  •  '; $st.='Sign our Guestbook
DateNameCountryComment
'.showdate($row[3]).''.$row[0].''.$row[1].''.str_replace("\n","
",$row[2]).'
'; print $st; }; } else { print "
".$msg."
"; }; // END OF IF MSG=0 ?>

 

7-9 Menekleous & Sokratous Str. (Old Town) - 851 00 Rhodes Tel: +30 22410 25186 - 74402
E-Mail: romeorodos@acn.gr

 

".substr($tdate,11,2).":".substr($tdate,14,2); }; }; ?>