public function sendMessage()
{
$username = Input::get('username');
$text = Input::get('text');
$chatMessage = new ChatMessage();
$chatMessage->sender_username = $username;
$chatMessage->message = $text;
$chatMessage->save();
}
public function sendMessage()
{
$chat = new ChatMessage();
$chat->sender = Auth::user()->id;
$chat->send_to = Input::get('send_to');
$chat->message = Input::get('message');
$chat->save();
return date("Y-m-d H:i:s");
}
public function say()
{
if ($this->isPost()) {
$message = new ChatMessage();
$message->set_model($this->vars());
$message->save();
C($message)->commit();
self::$static_flag = true;
}
exit;
}
public function sendMessage()
{
// $username = Input::get('username');
$message = Input::get('message');
$chatMessage = new ChatMessage();
$chatMessage->user_id = Auth::id();
$chatMessage->body = $message;
$chatMessage->save();
}
public function actionChat()
{
if ($_POST) {
//check if its an ajax request, exit if not
if (!isset($_SERVER['HTTP_X_REQUESTED_WITH']) and strtolower($_SERVER['HTTP_X_REQUESTED_WITH']) != 'xmlhttprequest') {
die;
}
$username = filter_var(trim($_POST["username"]), FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_HIGH);
$receiver = filter_var(trim($_POST["receiver"]), FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_HIGH);
if (isset($_POST["message"]) && strlen($_POST["message"]) > 0) {
//sanitize user name and message received from chat box
//You can replace username with registerd username, if only registered users are allowed.
$username = filter_var(trim($_POST["username"]), FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_HIGH);
$receiver = filter_var(trim($_POST["receiver"]), FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_HIGH);
$message = filter_var(trim($_POST["message"]), FILTER_SANITIZE_STRING, FILTER_FLAG_STRIP_LOW | FILTER_FLAG_STRIP_HIGH);
$user_ip = $_SERVER['REMOTE_ADDR'];
$model = new ChatMessage();
$model->UserId = $username;
$model->ReceiverId = $receiver;
$model->Message = $message;
$model->Date = date('Y-m-d H:i:s');
$model->IpAddress = $user_ip;
if ($model->save()) {
$msg_time = date('h:i A M d', time());
// current time
echo '<div class="shout_msg"><time>' . $msg_time . '</time><span class="username">' . Profile::model()->findByPk($username)->UserName . '</span><span class="message">' . $message . '</span></div>';
}
// delete all records except last 10, if you don't want to grow your db size!
$query = "DELETE FROM tbl_chat_message WHERE Objid NOT IN (SELECT * FROM (SELECT Objid FROM tbl_chat_message ORDER BY Objid DESC LIMIT 0, 10) as sb)";
Yii::app()->db->createCommand($query);
} else {
if (isset($_POST["fetch"]) && $_POST["fetch"] == 1) {
$query = "SELECT UserId, Message, Date FROM (SELECT * FROM tbl_chat_message WHERE (ReceiverId = {$username} AND UserId= {$receiver}) OR (UserId = {$username} AND ReceiverId= {$receiver} ) ORDER BY Objid DESC LIMIT 10) tbl_chat_message ORDER BY tbl_chat_message.Objid ASC";
$results = Yii::app()->db->createCommand($query)->queryAll();
if ($results) {
foreach ($results as $row) {
$msg_time = date('h:i A M d', strtotime($row["Date"]));
//message posted time
echo '<div class="shout_msg"><time>' . $msg_time . '</time><span class="username">' . Profile::model()->findByPk($row["UserId"])->UserName . '</span> <span class="message">' . $row["Message"] . '</span></div>';
}
}
} else {
header('HTTP/1.1 500 Please type something?');
exit;
}
}
}
}
