";
}
if(strlen($mymessage)==0){
$errors .= "Please enter a message
";
}
$mymessage = out_text($mymessage);
$myname = out_text($myname);
if(strlen($errors)==0){
mysql_query("INSERT INTO chat(time, sender, message) VALUES(
NOW(), '" . mysql_escape_string($myname) . "','" . mysql_escape_string($mymessage) . "' )") or die(mysql_error());
$mymessage = "";
} else{
$errors = "
$errors
"; } } // --- form submitted --- // =========================================================================== // -- QUERY -- if($_GET['starting']>0){ $starting = $_GET['starting']; if($starting - 50 > 0 ){ $back = $starting - 50; } else{ $back = 0; } $backlink = "More recent"; } else{ $starting = 0; } $query = mysql_query(" SELECT SQL_CALC_FOUND_ROWS chat.message_id, chat.message, DATE_FORMAT(chat.time,'%d %b, %H:%i') AS time, DATE_FORMAT(NOW(),'%d %b %H:%i') AS now, chat.sender FROM chat ORDER BY chat.time DESC LIMIT $starting, 50 "); $total_num_yachts = mysql_query("SELECT FOUND_ROWS() AS rows_found"); $result = mysql_fetch_array($total_num_yachts, MYSQL_ASSOC); $num_results = $result['rows_found']; if($num_results - $starting > 50){ $starting2 = $starting + 50; if($starting2 + 50 >= $num_results){ $forward = $starting2 + 50; } else{ $forward = $num_results; } $forwardlink = "Older messages"; } while($result = mysql_fetch_array($query, MYSQL_ASSOC)){ $time = $result['time']; $message = $result['message']; $sender = $result['sender']; $now = $result['now']; $message_id= $result['message_id']; $table_messages .= <<
| $backlink | $forwardlink |
|
Current Server Time: Courant Temps de Serveur: $now |
|
| $backlink | $forwardlink |
Special Characters
You can highlight/copy/paste the special characters below, or hold ALT and type the corresponding number on the numeric keypad, to reproduce the special characters.
| à | 133 | â | 131 | ä | 132 | è | 138 |
| é | 130 | ê | 136 | ë | 137 | î | 140 |
| ï | 139 | ô | 147 | ù | 151 | û | 150 |
| ü | 129 | ÿ | 152 | À | 0192 | Á | 0193 |
| Ä | 142 | È | 144 | É | 0201 | Ê | 0202 |
| Ë | 0203 | Î | 0206 | Ï | 0207 | Ô | 0212 |
| Œ | 0140 | Ù | 0217 | Û | 0219 | Ü | 0220 |
| Ÿ | 0159 | ç | 135 | Ç | 128 | € | 0128 |