Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function ChatHeader($id){
- global $sqlConnect;
- global $url;
- $MyID = GetUserSession();
- $query = mysqli_query($sqlConnect, "SELECT relation_arr FROM " . T_FOLLOWS . " WHERE `user_id` = '" . $MyID . "'");
- $fetched_data = mysqli_fetch_assoc($query);
- $arr = $fetched_data['relation_arr'];
- $arr = unserialize($arr);
- $content = '';
- if(in_array($id,$arr, TRUE)){
- $awsbucketurl = "https://yozax-main-bucket.s3.amazonaws.com/";
- $data = mysqli_query($sqlConnect, "SELECT * FROM " . T_USERS . " WHERE `user_id` = '" . $id . "'");
- $fetched_user = mysqli_fetch_assoc($data);
- $content .= '<img class="shotimgonlistHeader" src="'.$awsbucketurl . $fetched_user['avatar'].'">';
- $content .= '<div>';
- $content .= '<h2 class="onlistName">'.$fetched_user['username'].'</h2>';
- $content .= '</div>';
- }
- return $content;
- }
- function AddMessage($toid,$msg){
- global $sqlConnect;
- $MyID = GetUserSession();
- if (empty($toid) || empty($msg)) {
- return false;
- }
- $query = mysqli_query($sqlConnect, "SELECT user_id FROM " . T_USERS . " WHERE `user_id` = '" .$toid. "'");
- $fetched_data = mysqli_fetch_assoc($query);
- if (empty($fetched_data['user_id'])) {
- return false;
- }
- if($MyID == $toid){
- return false;
- }
- $fields = $fields = 'from_id,to_id,msg,date';
- $now = date("Y-m-d H:i:s");
- $query = mysqli_query($sqlConnect, "INSERT INTO " . T_MSG . " ({$fields}) VALUES ('{$MyID}','{$toid}','{$msg}','{$now}')") or die(mysqli_error($sqlConnect));
- return true;
- }
- function LoadChat($id){
- global $sqlConnect;
- $MyID = GetUserSession();
- $query = mysqli_query($sqlConnect, "SELECT relation_arr FROM " . T_FOLLOWS . " WHERE `user_id` = '" . $MyID . "'");
- $fetched_data = mysqli_fetch_assoc($query);
- $arr = $fetched_data['relation_arr'];
- $arr = unserialize($arr);
- $content = '';
- if(in_array($id,$arr, TRUE)){
- $query = mysqli_query($sqlConnect, "SELECT * FROM " . T_MSG . " WHERE `from_id` = '" . $MyID . "' and `to_id` = '" . $id . "' OR `from_id` = '" . $id . "' and `to_id` = '" . $MyID . "'");
- while ($v = mysqli_fetch_assoc($query)) {
- if($v['from_id'] == $MyID){
- $content .='<li class="me">';
- $content .='<div class="entete">';
- $content .='<h3>'.$v['date'].'</h3>';
- $content .='<span class="status blue"</span>';
- $content .='</div>';
- $content .='<div class="triangle"></div>';
- $content .='<div class="message">';
- $content .=$v['msg'];
- $content .='</div>';
- $content .='</li>';
- }else{
- $content .='<li class="you">';
- $content .='<div class="entete">';
- $content .='<h3>'.$v['date'].'</h3>';
- $content .='<span class="status green"</span>';
- $content .='</div>';
- $content .='<div class="triangle"></div>';
- $content .='<div class="message">';
- $content .=$v['msg'];
- $content .='</div>';
- $content .='</li>';
- }
- }
- }
- return $content;
- }
- ///////////////////////////////////////////////////////////////////////////
- THE AJAX FILE
- if( $_GET['type'] === 'chatheader'){
- if(isset($_POST['id'])){
- $content = ChatHeader($_POST['id']);
- $data = array(
- 'status' => true,
- 'content' => $content
- );
- echo json_encode($data);
- exit;
- }
- }
- if( $_GET['type'] === 'addmsg'){
- if(isset($_POST['id'])){
- if(isset($_POST['msg'])){
- $return = AddMessage($_POST['id'],$_POST['msg']);
- $data = array(
- 'status' => $return
- );
- echo json_encode($data);
- exit;
- }
- }
- }
- if( $_GET['type'] === 'chatlist'){
- if(isset($_POST['id'])){
- $content = LoadChat($_POST['id']);
- $data = array(
- 'content' =>$content,
- 'status' => true
- );
- echo json_encode($data);
- exit;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement