/
var
/
www
/
html
/
sugar14
/
include
/
chat_script
/
Upload File
HOME
<?php global $db; $user_id = $_REQUEST['online_user_id']; $user_cookie = $_COOKIE["user_cookie"]; $msg_id = ''; $sql = "SELECT * FROM chat_messages WHERE reciever_id = " . $user_id . " OR sender_id = " . $user_id . " and user_cookie= '" . $user_cookie . "'"; $res = $db->query($sql); while ($rs = $db->fetchByAssoc($res)) { $msg_id = $rs['msg_id']; } if ($msg_id != '') { $sqlCon = "select a.*, b.* from chat_tbl_user a LEFT JOIN chat_conversation b ON (a.id=b.reciever_id or a.id=b.sender_id) where a.id=" . $user_id . " and b.msg_id=" . $msg_id . " order by b.curr_time ASC"; $resCon = $db->query($sqlCon); $count = 1; if ($resCon) { while ($rs = $db->fetchByAssoc($resCon)) { if ($rs['reciever_id'] == $user_id) { $username = "SugarIQ"; } else { if ($rs['user_name'] == '') { $username = "Visitor" . $rs['id']; } else { $username = $rs['user_name']; } } $time = date("H:i", strtotime($rs['curr_time'])); $message = $rs['message']; echo '<div class="row"> <div class="col-lg-12"> <div class="media"> <div class="media-body"> <div class="msg-head" style="width:220px;"> <div style="float:left;"> <h4 class="media-heading">' . $username . '</h4> </div> <div style="float:right;"> <span class="small">' . $time . '</span> </div> <div style="clear:both" class="clear"></div> </div> <p>' . $message . '</p> </div> </div> </div> </div> <hr style="margin:5px 20px;">'; } } }