Kód: Vybrat vše
<?php
class Chat extends Core{
public function fetchMessages() {
$this->query("
SELECT `chat`.`message`,
`chat`.`timestamp`,
`chat`.`ip`,
`chat`.`message_id`,
`uzivatele`.`jmeno`,
`uzivatele`. `id`,
`uzivatele`. `admin`
FROM `chat`
JOIN `uzivatele`
ON `chat`.`id` = `uzivatele`.`id`
ORDER BY `chat`.`timestamp`
DESC
");
return $this->rows();
}
public function throwMessage($id, $message){
$adr=$_SERVER["REMOTE_ADDR"];
if(!strstr($message, "heslo")){
$this->query("
INSERT INTO `chat` (`id`, `message`, `timestamp`, `ip`)
VALUES (" . (int)$id.", '" .$this->db->real_escape_string($message) ."', UNIX_TIMESTAMP(), '$adr')
");
}else{
?>
<script type"text/javascript">
alert("Text obsahuje nepovolené slovo!");
</script>
<?
}
}
}
Zprávu to sice neodešle, ale hláška nevyskočí