One Hat Cyber Team
Your IP :
172.69.214.199
Server IP :
188.114.96.3
Server :
Linux thuru 6.5.11-4-pve #1 SMP PREEMPT_DYNAMIC PMX 6.5.11-4 (2023-11-20T10:19Z) x86_64
Server Software :
Apache/2.4.51 (Unix) OpenSSL/1.0.2k-fips
PHP Version :
7.3.33
Buat File
|
Buat Folder
Eksekusi
Dir :
~
/
home
/
thuruk
/
public_html
/
App
/
New
/
View File Name :
fetch_chat_list.php
<?php include("connections.php"); //database connection $session_id = mysqli_real_escape_string($connect,$_GET['session_id']);//variable $user_id = mysqli_real_escape_string($connect,$_GET['user_id']); $json; if($session_id!="5f0e6bfbafe255ds003434349") { $json['status'] = 400; $json['msg'] = 'Session Expired'; }else { $rsData = array(); //AND users.user_id='$user_id' //AND chat_list.user_id='$user_id' $skill_query="SELECT * FROM chat_list inner join users WHERE users.user_id = chat_list.peer_id AND chat_list.chat_user_id='$user_id'"; $rs = mysqli_query($connect,$skill_query) or die(mysqli_error($connect)); //following query will check hide post or reported post are available $report_array=array(); $report_post="SELECT * FROM `block_user` WHERE my_id='$user_id'"; $report_rs = mysqli_query($connect,$report_post) or die(mysqli_error($connect)); if($report_rs){ /**/while($row1 = mysqli_fetch_assoc($report_rs)) { array_push($report_array,$row1['other_user_id']);//$word_array[] = $row; } } if($rs){ //location while ($row = mysqli_fetch_assoc($rs)){ if(in_array($row['peer_id'],$report_array)){ }else{ $rsData[] = $row; } } $peer_query="SELECT * FROM chat_list inner join users WHERE users.user_id = chat_list.chat_user_id AND chat_list.peer_id='$user_id'"; $peer_res = mysqli_query($connect,$peer_query) or die(mysqli_error($connect)); while ($row = mysqli_fetch_assoc($peer_res)){ $rsData[] = $row; } $json['status'] = 200; $json['msg'] = 'Success'; $json['data'] = $rsData; } /* if($rs){ while($row = mysqli_fetch_assoc($rs)){ $rsData[] =$row; } $json['status'] = 200; $json['msg'] = 'Success'; $json['data'] = $rsData; }*/ } header("Content-Type: application/json"); echo json_encode($json);