HEX
Server: LiteSpeed
System: Linux s1049.use1.mysecurecloudhost.com 4.18.0-477.27.2.lve.el8.x86_64 #1 SMP Wed Oct 11 12:32:56 UTC 2023 x86_64
User: xedaptot (3356)
PHP: 8.3.31
Disabled: NONE
Upload Files
File: /home/xedaptot/360.naniguide.com/backend/ajax/get_map.php
<?php
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE & ~E_DEPRECATED);
ob_start();
session_start();
if($_SESSION['svt_si']!=session_id()) {
    die();
}
require_once("../../db/connection.php");
require_once("../functions.php");
session_write_close();
$id_virtualtour = (int)$_POST['id_virtualtour'];
$id_map = (int)$_POST['id_map'];
$map_type = $_POST['map_type'];
$all_points = true;
$s3_params = check_s3_tour_enabled($id_virtualtour);
$s3_enabled = false;
if(!empty($s3_params)) {
    $s3_bucket_name = $s3_params['bucket'];
    $s3_region = $s3_params['region'];
    $s3_url = init_s3_client($s3_params);
    if($s3_url!==false) {
        $s3_enabled = true;
    }
}
switch ($map_type) {
    case 'floorplan':
        $array = array();
        $map = "";
        $query = "SELECT id,map,point_color FROM svt_maps WHERE id_virtualtour = $id_virtualtour AND id=$id_map LIMIT 1;";
        $result = $mysqli->query($query);
        if($result) {
            if($result->num_rows==1) {
                $row = $result->fetch_array(MYSQLI_ASSOC);
                $id_map = $row['id'];
                $map = "";
                if(!empty($row['map'])) {
                    if($s3_enabled) {
                        $map = $s3_url."viewer/maps/".$row['map'];
                    } else {
                        $map = "../viewer/maps/".$row['map'];
                    }
                }
                $point_color = $row['point_color'];
                $query = "SELECT id,id_map,name,map_top,map_left,panorama_image FROM svt_rooms WHERE id_virtualtour = $id_virtualtour;";
                $result = $mysqli->query($query);
                if($result) {
                    if($result->num_rows>0) {
                        while($row=$result->fetch_array(MYSQLI_ASSOC)) {
                            if($row['map_top']==null) {
                                $all_points = false;
                            }
                            $row['point_color'] = $point_color;
                            if($s3_enabled) {
                                $row['room_image'] = $s3_url."viewer/panoramas/thumb/".$row['panorama_image'];
                            } else {
                                $row['room_image'] = "../viewer/panoramas/thumb/".$row['panorama_image'];
                            }
                            $array[]=$row;
                        }
                    }
                }
            }
        }
        ob_end_clean();
        echo json_encode(array("id_map"=>$id_map,"map"=>$map,"map_points"=>$array,"all_points"=>$all_points));
        break;
    case 'map':
        $array = array();
        $query = "SELECT id,id_map,name,lat,lon,thumb_image,panorama_image FROM svt_rooms WHERE id_virtualtour = $id_virtualtour;";
        $result = $mysqli->query($query);
        if($result) {
            if($result->num_rows>0) {
                while($row=$result->fetch_array(MYSQLI_ASSOC)) {
                    if($row['lat']==null) {
                        $all_points = false;
                    }
                    if($s3_enabled) {
                        $path_thumb = "s3://$s3_bucket_name/viewer/panoramas/thumb_custom/".$row['thumb_image'];
                        $path_preview = "s3://$s3_bucket_name/viewer/panoramas/preview/".$row['panorama_image'];
                    } else {
                        $path_thumb = __DIR__.DIRECTORY_SEPARATOR.'..'.DIRECTORY_SEPARATOR.'..'.DIRECTORY_SEPARATOR.'viewer'.DIRECTORY_SEPARATOR.'panoramas'.DIRECTORY_SEPARATOR.'thumb_custom'.DIRECTORY_SEPARATOR.$row['thumb_image'];
                        $path_preview = __DIR__.DIRECTORY_SEPARATOR.'..'.DIRECTORY_SEPARATOR.'..'.DIRECTORY_SEPARATOR.'viewer'.DIRECTORY_SEPARATOR.'panoramas'.DIRECTORY_SEPARATOR.'preview'.DIRECTORY_SEPARATOR.$row['panorama_image'];
                    }
                    if(!empty($row['thumb_image']) && file_exists($path_thumb)) {
                        if($s3_enabled) {
                            $row['icon'] = $s3_url."viewer/panoramas/thumb_custom/".$row['thumb_image'];
                        } else {
                            $row['icon'] = '../viewer/panoramas/thumb_custom/'.$row['thumb_image'];
                        }
                    } else if(file_exists($path_preview)) {
                        if($s3_enabled) {
                            $row['icon'] = $s3_url."viewer/panoramas/preview/".$row['panorama_image'];
                        } else {
                            $row['icon'] = '../viewer/panoramas/preview/'.$row['panorama_image'];
                        }
                    } else {
                        if($s3_enabled) {
                            $row['icon'] = $s3_url."viewer/panoramas/thumb/".$row['panorama_image'];
                        } else {
                            $row['icon'] = '../viewer/panoramas/thumb/'.$row['panorama_image'];
                        }
                    }
                    if($s3_enabled) {
                        $row['room_image'] = $s3_url."viewer/panoramas/thumb/".$row['panorama_image'];
                    } else {
                        $row['room_image'] = "../viewer/panoramas/thumb/".$row['panorama_image'];
                    }
                    $array[]=$row;
                }
            }
        }
        ob_end_clean();
        echo json_encode(array("id_map"=>$id_map,"map_points"=>$array,"all_points"=>$all_points));
        break;
}