SUBTIME(now(),"0:05")')); if ($limite[0] > 1) { $erreur = 'You have already sent too many signatures!'; } else { // on prepare notre requête d'insertion des données $sql = 'INSERT INTO livre_or VALUES("", "'.mysql_escape_string($_POST['auteur']).'", "'.mysql_escape_string($_SERVER['REMOTE_ADDR']).'", "'.date("Y-m-d H:i:s").'", "'.mysql_escape_string($_POST['message']).'", "en")'; // on lance la requête mysql_query($sql) or $erreur='Failed to send to the database.'; } // on ferme la connexion à la base de données mysql_close(); } else { $erreur = 'You did not answer the question correctly. Please try again.'; } } else { $erreur = 'Your message could not be sent because it is too long (> 800 characters).'; } } else { $erreur = 'Please fill in all fields.'; } } else { $erreur = 'Error: variables are not defined.'; } } ?> Guestbook — Jumpman and Robinhood’s domain

Guestbook

',$erreur,'

'; else echo '

You can sign our guestbook to acknowledge your visitation to the site. We are eager for what you have to say about our videos! Thank you for your support.

'; ?>

Security: please answer the question below to prove you are human.
What is the opposite of “hot”?

Your signature has been added to the list below.

'; } unset($erreur);?>

Signatures

No entry.'; } else if (isset($erreur)) { echo '

'.$erreur; } else { while ($data = mysql_fetch_array($req)) { $meridiem = "am"; sscanf($data['date_signature'], "%4s-%2s-%2s %2s:%2s:%2s", $annee, $mois, $jour, $heure, $minute, $seconde); if ($heure > 12) { $heure -= 12; $meridiem = "pm"; } $langImg = ''; if ($data['langue'] == 'fr') { $langImg = 'src="flag-fr.png" title="Message sent from the French version of this site" alt="[French]"'; } else if ($data['langue'] == 'en') { $langImg = 'src="flag-en.png" title="Message sent from the English version of this site" alt="[English]"'; } echo '

' , stripslashes(htmlentities(trim($data['auteur']), ENT_QUOTES, "UTF-8")); echo ' (' , $mois , '/' , $jour , '/' , $annee , ' at ' , $heure , ':' , $minute , ' ', $meridiem, ')
'; echo nl2br(stripslashes(htmlentities(trim($data['message']), ENT_QUOTES, "UTF-8"))), '

'; echo '
'; } } mysql_free_result ($req); mysql_close (); ?>