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{
echo "<script>alert(\"Zpráva obsahuje nepovolené slovo!\");</script>";
}
}
}