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/add_presentation_room.php
<?php
error_reporting(E_ALL & ~E_WARNING & ~E_NOTICE & ~E_DEPRECATED);
ob_start();
session_start();
if((($_SERVER['SERVER_ADDR']==$_SESSION['demo_server_ip']) && ($_SERVER['REMOTE_ADDR']!=$_SESSION['demo_developer_ip']) && ($_SESSION['id_user']==$_SESSION['demo_user_id'])) || ($_SESSION['svt_si']!=session_id())) {
    die();
}
require_once("../../db/connection.php");
require_once("../functions.php");
session_write_close();
$id_room = (int)$_POST['id_room'];
$sleep = $_POST['sleep'];
if($sleep=='') $sleep=0; else $sleep = (int)$sleep;
$video_wait_end = (int)$_POST['video_wait_end'];
$override_pos_presentation = (int)$_POST['override_pos_presentation'];
$yaw = (float)$_POST['yaw'];
$pitch = (float)$_POST['pitch'];
$hfov = (int)$_POST['hfov'];
if($override_pos_presentation==1) {
    $pos = "$yaw,$pitch,$hfov";
} else {
    $pos = NULL;
}
$id_virtualtour = (int)$_POST['id_virtualtour'];
$query = "SELECT IFNULL(MAX(priority_1),0) as priority_1 FROM svt_presentations WHERE id_virtualtour=$id_virtualtour;";
$result = $mysqli->query($query);
if($result) {
    if ($result->num_rows == 1) {
        $row = $result->fetch_array(MYSQLI_ASSOC);
        $priority_1 = $row['priority_1'];
    } else {
        ob_end_clean();
        echo json_encode(array("status"=>"error"));
        die();
    }
} else {
    ob_end_clean();
    echo json_encode(array("status"=>"error","msg"=>$mysqli->error));
    die();
}
$priority_1 = $priority_1 + 1;
$query = "INSERT INTO svt_presentations(id_virtualtour,id_room,action,params,sleep,priority_1,priority_2,video_wait_end,pos) VALUES(?,?,'goto',?,?,?,1,?,?);";
if ($smt = $mysqli->prepare($query)) {
    $smt->bind_param('iiiiiis',$id_virtualtour,$id_room,$id_room,$sleep,$priority_1,$video_wait_end,$pos);
    $result = $smt->execute();
    if ($result) {
        ob_end_clean();
        echo json_encode(array("status"=>"ok"));
    } else {
        ob_end_clean();
        echo json_encode(array("status"=>"error"));
    }
} else {
    ob_end_clean();
    echo json_encode(array("status"=>"error"));
}