<?php
session_start();

// Se vuoi saltare la parte della connessione sottostante, puoi semplicemente fare un include al tuo core. \\

$Host = "127.0.0.1";
$Nome = "root";
$pass = "svtcsm74";
$db_nome = "asd";
$dbCon = mysql_connect($Host, $Nome, $pass) or die(mysql_error());
$selDb = mysql_select_db($db_nome, $dbCon);

function FilterText($str, $advanced=false) {
    if($advanced == true){ return mysql_real_escape_string($str); }
    $str = mysql_real_escape_string(htmlspecialchars($str));
    return $str;
}

if(!isset($_SESSION['username'])){
    header('location:'.$path.'/index.php');
    return false;
}
if(isset($_SESSION['username'])){
    $verifica = mysql_query("SELECT * FROM users WHERE username = '".FilterText($_SESSION['username'])."' AND password = '".$_SESSION['password']."' LIMIT 1");
    $verifica_2 = mysql_fetch_assoc($verifica);
    if($verifica_2['username'] !== $_SESSION['username'] && $verifica_2['password'] !== $_SESSION['password']){
        header('location:'.$path.'/index.php');
        return false;
    }
}
function mus($header, $data=''){
        $musData = $header . chr(1) . $data;
        $sock = @socket_create(AF_INET, SOCK_STREAM, getprotobyname('tcp'));
        @socket_connect($sock, '127.0.0.1', '30001');
        @socket_send($sock, $musData, strlen($musData), MSG_DONTROUTE);
        @socket_close($sock);
}

function salva_modello($code)
    {
      $random = "model_".rand(555,999999);
      $stmt = mysql_query("INSERT INTO room_models(id,door_x,door_y,door_dir,heightmap)
                                                   VALUES('".$random."', '0', '10', '2', '".htmlspecialchars($code)."')");
      $room = mysql_query("INSERT INTO rooms(caption,owner,model_name)
                                                   VALUES('Stanza Realizzata con Floor!', '".$myrow['username']."', '".$random."')");
      mus("update_navigator");
      return $stmt;
        }





if(isset($_POST['salva'])){
$code = trim($_POST['export1']);
if($code == ""){
  echo "<script>alert('Errore Modello non caricato');</script>";
}else if(!strstr($code,'X') && !strstr($code,'0'))
{
echo"<script>alert('Errore Modello non caricato');</script>";
}
else if($myrow['vip_points'] < 40)
{
    echo"<script>alert('Devi avere almeno 40 Crediti per creare il Modello!');</script>";
}
else{
mysql_query("UPDATE users SET vip_points = vip_points -40 WHERE username = '".$myrow['username']."' LIMIT 1");
if(salva_modello($code)){
echo "<script>alert('Modello Creato con successo ! Puoi trovare il nuovo modello nella Stanza *CREATA CON IL FLOOR* del tuo Navigatore se non la vedi rientra in Hotel!');</script>";
}
}
}

?>