API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Aug 7th, 2018
146
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 31.96 KB | None | 0 0
raw download clone embed print report
  1. <?php
  2.  
  3.     /*===================================================
  4.     || # SpisCMS - Versione di Test - Alpha Build
  5.     ||===================================================
  6.     || # Made & Produced by Cosimo Celeste
  7.     || # https://www.facebook.com/CosimoCelesteGoglia
  8.     |+===================================================
  9.     || # Licenza Creative Commons Attribuzione.
  10.     || # Non commerciale 4.0 Internazionale.
  11.     |+===================================================*/
  12.  
  13.     /*
  14.         Lista delle Funzioni
  15.         IpUtente();
  16.         GestioneUtente();
  17.         Loggato();
  18.         ControlloUtente();
  19.         Crypto();
  20.         Login();
  21.         UsernameValido();
  22.         ControlloMailR();
  23.         ControlloUtenteR();
  24.         Register();
  25.         Ticket();
  26.         AggiornamentoLastOnline();
  27.         Data();
  28.         Ora();
  29.         CambiaPassword();
  30.         ControlloBan();
  31.     */
  32.  
  33.     /// Impostazione della zona CMS
  34.     if(!defined('SpisCMS'))
  35.     {
  36.         die('Non puoi accedere a questa zona di SpisCMS.');
  37.     }
  38.  
  39.     /// Classe Utente
  40.     class Utente
  41.     {
  42.         public static function IpUtente()
  43.         {
  44.             if(isset($_SERVER['HTTP_CF_CONNECTING_IP'])){
  45.                 $ip_utente = $_SERVER['HTTP_CF_CONNECTING_IP'];
  46.             } else {
  47.                 $ip_utente = $_SERVER['REMOTE_ADDR'];
  48.             }
  49.             return $ip_utente;
  50.         }
  51.  
  52.         public static function GestioneUtente($key)
  53.         {
  54.             global $database;
  55.             $stmt = $database->prepare("SELECT * FROM users WHERE id = :id");
  56.             $stmt->bindParam(":id", $_SESSION['id']);
  57.             $stmt->execute();
  58.             $row = $stmt->fetch();
  59.             return $row[$key];
  60.         }
  61.  
  62.         public static function Loggato()
  63.         {
  64.             if(isset($_SESSION['id']))
  65.             {
  66.                 return true;
  67.             } else
  68.             {
  69.                 return false;
  70.             }
  71.         }
  72.  
  73.         public static function ControlloUtente($password, $passwordDb, $username)
  74.         {
  75.             global $database;
  76.             if (substr($passwordDb, 0, 1) == "$" && password_verify($password, $passwordDb))
  77.                 return true;
  78.  
  79.             $passwordBcrypt = Utente::Crypto($password);
  80.             if (sha1($password) == $passwordDb)
  81.             {  
  82.                 $stmt = $database->prepare("UPDATE users SET password = :password WHERE username = :username");
  83.                 $stmt->bindParam(':username', $username);
  84.                 $stmt->bindParam(':password', $passwordBcrypt);
  85.                 $stmt->execute();
  86.                 return true;
  87.             }
  88.            
  89.             return false;  
  90.            
  91.         }
  92.  
  93.         public static function Crypto($password)
  94.         {
  95.             return password_hash($password, PASSWORD_BCRYPT);
  96.         }
  97.  
  98.         public static function Login()
  99.         {
  100.             global $database, $Configurazione, $lingua;
  101.             if(!isset($_POST['username'], $_POST['password']))
  102.                 return;
  103.  
  104.             $username = Html::Filtro($_POST['username']);
  105.             $password = Html::Filtro($_POST['password']);
  106.  
  107.             if(empty($username))
  108.                 return Html::Errore($lingua["IErrore5"]);
  109.             if(empty($password))
  110.                 return Html::Errore($lingua["IErrore4"]);
  111.  
  112.             $stmt = $database->prepare("SELECT id, password, username, rank FROM users WHERE username = :username");
  113.             $stmt->bindParam(':username', $username);
  114.             $stmt->execute();
  115.  
  116.             if($stmt->RowCount() == 0)
  117.                 return Html::Errore($lingua["IErrore3"]);
  118.  
  119.             $row = $stmt->fetch();
  120.             if(!Utente::ControlloUtente($password, $row['password'], $row['username']))
  121.                 return Html::Errore($lingua["IErrore2"]);
  122.  
  123.             $IpUsersBan = Utente::IpUtente();
  124.             $stmtBans = $database->prepare("SELECT * FROM bans WHERE value = :user OR value = :ip LIMIT 1");
  125.             $stmtBans->bindParam(":user", $username);
  126.             $stmtBans->bindParam(":ip", $IpUsersBan);
  127.             $stmtBans->execute();
  128.             $stmtBansFetch = $stmtBans->fetch(PDO::FETCH_ASSOC);
  129.             if($stmtBans->rowCount() > "0")
  130.             {
  131.                 return Html::Errore("Sei stato bannato per ".$stmtBansFetch['reason']." e il ban scade il ".date("d/m/Y H:i:s", $stmtBansFetch['expire'])."");
  132.             }
  133.  
  134.             $_SESSION['id'] = $row['id'];
  135.             if($Configurazione['manutenzione'])
  136.             {
  137.                 if($row['rank'] >= $Configurazione['rankminimologinstaff'])
  138.                 {
  139.                     session_regenerate_id();
  140.                     header("location: ".$Configurazione['link']."home.php");
  141.                     exit;
  142.                 }
  143.                 return Html::Errore($lingua["IErrore1"]);
  144.             }
  145.             session_regenerate_id();
  146.             header("location: ".$Configurazione['link']."home.php");
  147.             exit;
  148.         }
  149.  
  150.         public static function UsernameValido($username)
  151.         {
  152.             if(strlen($username) <= 12 && strlen($username) >= 3 && ctype_alnum($username))
  153.             {
  154.                 return true;
  155.             }
  156.             return false;
  157.         }
  158.  
  159.         public static function ControlloMailR($email)
  160.         {
  161.             global $database;
  162.             $stmt = $database->prepare("SELECT mail FROM users WHERE mail = :email LIMIT 1");
  163.             $stmt->bindParam(':email', $email);
  164.             $stmt->execute();
  165.             if($stmt->RowCount() > 0)
  166.             {
  167.                 return true;
  168.             }
  169.             else
  170.             {
  171.                 return false;
  172.             }
  173.         }
  174.  
  175.         public static function ControlloUtenteR($username)
  176.         {
  177.             global $database;
  178.             $stmt = $database->prepare("SELECT username FROM users WHERE username = :username LIMIT 1");
  179.             $stmt->bindParam(':username', $username);
  180.             $stmt->execute();
  181.             if($stmt->RowCount() > 0)
  182.             {
  183.                 return true;
  184.             }
  185.             else
  186.             {
  187.                 return false;
  188.             }
  189.         }
  190.  
  191.         public static function Register()
  192.         {
  193.             global $database, $Configurazione, $Client, $lingua;
  194.             if(!isset($_POST['register']))
  195.                 return;
  196.  
  197.             $username = Html::Filtro($_POST['username']);
  198.             $motto = Html::Filtro($_POST['motto']);
  199.             $mail = Html::Filtro($_POST['mail']);
  200.             $password = Utente::Crypto(Html::Filtro($_POST['password']));
  201.             $ripetipassword = Utente::Crypto(Html::Filtro($_POST['ripetipassword']));
  202.             $avatar = Html::Filtro($_POST['look']);
  203.             $IpReg = Utente::IpUtente();
  204.             $RankIniziale = Html::Filtro($Configurazione['rankiniziale']);
  205.             $RankVipIniziale = Html::Filtro($Configurazione['rankvipiniziale']);
  206.             $CreditiPartenza = Html::Filtro($Configurazione["creditipartenza"]);
  207.             $DucketsPartenza = Html::Filtro($Configurazione["ducketspartenza"]);
  208.             $DiamantiPartenza = Html::Filtro($Configurazione["diamantipartenza"]);
  209.             $HomeRoom = Html::Filtro($Client["home_room"]);
  210.             $time = strtotime('now');
  211.             $stanza = Html::Filtro($_POST['stanza']);
  212.  
  213.             if(empty($username))
  214.                 return Html::Errore($lingua['RErrore10']);
  215.  
  216.             if(!Utente::UsernameValido($username))
  217.                 return Html::Errore($lingua['RErrore9']);
  218.  
  219.             if(empty($_POST['password']))
  220.                 return Html::Errore($lingua['RErrore8']);
  221.  
  222.             if(empty($_POST['ripetipassword']))
  223.                 return Html::Errore($lingua['RErrore7']);
  224.  
  225.             if(empty($mail))
  226.                 return Html::Errore($lingua['RErrore6']);
  227.  
  228.             if(!filter_var($mail, FILTER_VALIDATE_EMAIL))
  229.                 return Html::Errore($lingua['RErrore5']);
  230.  
  231.             if(Utente::ControlloUtenteR($username))
  232.                 return Html::Errore($lingua['RErrore4']);
  233.  
  234.             if(Utente::ControlloMailR($mail))
  235.                 return Html::Errore($lingua['RErrore3']);
  236.  
  237.             if(!strlen($_POST['password']) >= 6)
  238.                 return Html::Errore($lingua['RErrore2']);
  239.  
  240.             if(!$_POST['password'] == $_POST['ripetipassword'])
  241.                 return Html::Errore($lingua['RErrore1']);
  242.  
  243.             session_regenerate_id();
  244.             $AggiungiNuovoUtente = $database->prepare("INSERT INTO users(username,password,mail,look,gender,motto,rank,rank_vip,ip_reg,credits,activity_points,vip_points,account_created) VALUES (:username, :password, :mail, :look, 'M', :motto, :rank, :rank_vip, :ip_reg, :crediti, :duckets, :diamanti, :creazioneaccount)");
  245.             $AggiungiNuovoUtente->bindParam(":username", $username);
  246.             $AggiungiNuovoUtente->bindParam(":password", $password);
  247.             $AggiungiNuovoUtente->bindParam(":mail", $mail);
  248.             $AggiungiNuovoUtente->bindParam(":look", $avatar);
  249.             $AggiungiNuovoUtente->bindParam(":motto", $motto);
  250.             $AggiungiNuovoUtente->bindParam(":rank", $RankIniziale);
  251.             $AggiungiNuovoUtente->bindParam(":rank_vip", $RankVipIniziale);
  252.             $AggiungiNuovoUtente->bindParam(":ip_reg", $IpReg);
  253.             $AggiungiNuovoUtente->bindParam(":crediti", $CreditiPartenza);
  254.             $AggiungiNuovoUtente->bindParam(":duckets", $DucketsPartenza);
  255.             $AggiungiNuovoUtente->bindParam(":diamanti", $DiamantiPartenza);
  256.             $AggiungiNuovoUtente->bindParam(":creazioneaccount", $time);
  257.             $AggiungiNuovoUtente->execute();
  258.             $UltimoId = $database->lastInsertId();
  259.             $_SESSION['id'] = $UltimoId;
  260.             switch ($_POST['stanza'])
  261.             {
  262.                 case 'stanza1':
  263.                     $nuovaStanza = $database->prepare("INSERT INTO `rooms`(roomtype, caption, owner, description, category, state, users_now, users_max, model_name, score, tags, password, wallpaper, floor, landscape, allow_pets, allow_pets_eat, room_blocking_disabled, allow_hidewall, wallthick, floorthick, group_id, mute_settings, ban_settings, kick_settings, chat_mode, chat_size, chat_speed, chat_extra_flood, chat_hearing_distance, trade_settings, push_enabled, pull_enabled, enables_enabled, respect_notifications_enabled, pet_morphs_allowed, spull_enabled, spush_enabled, golpe_enabled, tutorial) VALUES ('private','La Stanza di ".$_POST['username']."','".$UltimoId."','',36,'locked',0,50,'model_bc_99999991',0,'','','215','110','5.1','0','0','0','0',0,1,0,'0','1','1',0,0,0,0,0,2,'1','1','1','1','1','1','1','1','false');");
  264.                     $nuovaStanza->execute();
  265.                     $TrovaIdSala = $database->prepare("SELECT * FROM rooms WHERE caption = 'La Stanza di ".$_POST['username']."' AND owner = ".$UltimoId." LIMIT 1");
  266.                     $TrovaIdSala->execute();
  267.                     $TrovaIdSalaFetch = $TrovaIdSala->fetch(PDO::FETCH_ASSOC);
  268.                     $addFurni = $database->prepare("INSERT INTO `items`(user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos, limited_number, limited_stack, VinkingThiago) VALUES (".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 10, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 8, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 6, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 4, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 10, 2, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 10, 4, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 8, 4, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 8, 2, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 6, 2, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 6, 4, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 4, 2, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20131, '4', 4, 4, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1737, '1', 0, 0, 0, 0, ':w=3,8 l=32,50 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1731, '1', 0, 0, 0, 0, ':w=5,0 l=29,51 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1736, '1', 0, 0, 0, 0, ':w=3,10 l=12,71 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1359, '', 11, 1, 0.7, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1359, '', 4, 1, 0.7, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1349, '', 6, 3, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1349, '', 5, 3, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1349, '', 10, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1349, '', 8, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1349, '', 6, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1349, '', 4, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1356, '0', 5, 2, 0.7, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1360, '', 7, 4, 0.7, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1361, '1', 4, 4, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1353, '1', 4, 3, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20403, '1', 8, 2, 0.7, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1349, '', 9, 3, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1349, '', 8, 3, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20394, '1', 0, 0, 0, 0, ':w=3,12 l=13,33 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1712, '', 0, 0, 0, 0, ':w=8,0 l=31,51 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 8, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 6, 8, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 6, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 4, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 4, 8, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 4, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 10, 8, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 8, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 10, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 6, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 8, 8, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 10, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 10, 12, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 8, 12, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 6, 12, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900340, '2', 4, 12, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900354, '', 10, 8, 0, 6, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900354, '', 8, 8, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900354, '', 9, 11, 0, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900354, '', 9, 13, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900343, '', 4, 12, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900331, '', 9, 8, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900331, '', 9, 12, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900329, '', 5, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 900355, '', 4, 7, 0, 0, '', 0, 0, 'true');");
  269.                     $addFurni->execute();
  270.                     $addroom = $database->prepare("UPDATE users SET home_room = ".$TrovaIdSalaFetch['id']." WHERE id = ".$UltimoId);
  271.                     $addroom->execute();
  272.                     exit;
  273.                 case 'stanza2':
  274.                     $nuovaStanza = $database->prepare("INSERT INTO `rooms`(roomtype, caption, owner, description, category, state, users_now, users_max, model_name, score, tags, password, wallpaper, floor, landscape, allow_pets, allow_pets_eat, room_blocking_disabled, allow_hidewall, wallthick, floorthick, group_id, mute_settings, ban_settings, kick_settings, chat_mode, chat_size, chat_speed, chat_extra_flood, chat_hearing_distance, trade_settings, push_enabled, pull_enabled, enables_enabled, respect_notifications_enabled, pet_morphs_allowed, spull_enabled, spush_enabled, golpe_enabled, tutorial) VALUES ('private','La Stanza di ".$_POST['username']."','".$UltimoId."','',36,'locked',0,50,'model_bc_99999992',0,'','','215','110','5.1','0','0','0','0',0,1,0,'0','1','1',0,0,0,0,0,2,'1','1','1','1','1','1','1','1','false');");
  275.                     $nuovaStanza->execute();
  276.                     $TrovaIdSala = $database->prepare("SELECT * FROM rooms WHERE caption = 'La Stanza di ".$_POST['username']."' AND owner = ".$UltimoId." LIMIT 1");
  277.                     $TrovaIdSala->execute();
  278.                     $TrovaIdSalaFetch = $TrovaIdSala->fetch(PDO::FETCH_ASSOC);
  279.                     $addFurni = $database->prepare("INSERT INTO `items`(user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos, limited_number, limited_stack, VinkingThiago) VALUES(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1704, '', 0, 0, 0, 0, ':w=2,4 l=25,72 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1704, '', 0, 0, 0, 0, ':w=10,0 l=23,68 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65274, '', 9, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65323, '', 0, 0, 0, 0, ':w=7,0 l=28,33 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65290, '', 7, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65275, '', 10, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65269, '', 1, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65311, '', 0, 0, 0, 0, ':w=0,9 l=23,34 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65305, '', 1, 8, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65305, '', 2, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65319, '', 0, 0, 0, 0, ':w=4,2 l=2,68 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65280, '', 6, 1, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 12240, '', 7, 5, 0, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 12240, '', 6, 6, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 12237, '', 7, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 12235, '', 11, 10, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 11, 8, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 9, 10, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 8, 10, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 7, 10, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 4, 6, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 3, 6, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 2, 6, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 1, 6, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 44391305, '', 3, 6, 1.5, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 44391305, '', 1, 6, 1.5, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 11, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 7, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 9, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 8, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 10, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 11, 9, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 11, 8, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 11, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 11, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 3, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 2, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 3, 6, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 4, 6, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 2, 6, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 1, 6, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 2, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 3, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 4, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 1, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 89985, '1', 2, 7, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 8, 10, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 7, 10, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 9, 10, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 11, 8, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 11, 7, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 11, 6, 1.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 11, 7, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 11, 6, 0.25, 0, '', 0, 0, 'true');");
  280.                     $addFurni->execute();
  281.                     $addroom = $database->prepare("UPDATE users SET home_room = ".$TrovaIdSalaFetch['id']." WHERE id = ".$UltimoId);
  282.                     $addroom->execute();
  283.                     exit;
  284.                 case 'stanza3':
  285.                     $nuovaStanza = $database->prepare("INSERT INTO `rooms`(roomtype, caption, owner, description, category, state, users_now, users_max, model_name, score, tags, password, wallpaper, floor, landscape, allow_pets, allow_pets_eat, room_blocking_disabled, allow_hidewall, wallthick, floorthick, group_id, mute_settings, ban_settings, kick_settings, chat_mode, chat_size, chat_speed, chat_extra_flood, chat_hearing_distance, trade_settings, push_enabled, pull_enabled, enables_enabled, respect_notifications_enabled, pet_morphs_allowed, spull_enabled, spush_enabled, golpe_enabled, tutorial) VALUES ('private','La Stanza di ".$_POST['username']."','".$UltimoId."','',36,'locked',0,50,'model_bc_99999993',0,'','','215','110','5.1','0','0','0','0',0,1,0,'0','1','1',0,0,0,0,0,2,'1','1','1','1','1','1','1','1','false');");
  286.                     $nuovaStanza->execute();
  287.                     $TrovaIdSala = $database->prepare("SELECT * FROM rooms WHERE caption = 'La Stanza di ".$_POST['username']."' AND owner = ".$UltimoId." LIMIT 1");
  288.                     $TrovaIdSala->execute();
  289.                     $TrovaIdSalaFetch = $TrovaIdSala->fetch(PDO::FETCH_ASSOC);
  290.                     $addFurni = $database->prepare("INSERT INTO `items`(user_id, room_id, base_item, extra_data, x, y, z, rot, wall_pos, limited_number, limited_stack, VinkingThiago) VALUES (".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65081, '', 1, 10, 0.25, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65019, '3', 1, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 12283, '', 8, 10, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 65836, '1', 1, 10, 1.25, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1794, '1', 0, 0, 0, 0, ':w=5,1 l=1,103 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1794, '1', 0, 0, 0, 0, ':w=6,0 l=31,103 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1794, '1', 0, 0, 0, 0, ':w=8,0 l=23,99 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1794, '1', 0, 0, 0, 0, ':w=10,0 l=17,96 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1794, '1', 0, 0, 0, 0, ':w=12,0 l=10,93 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1794, '1', 0, 0, 0, 0, ':w=14,0 l=1,89 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1794, '1', 0, 0, 0, 0, ':w=5,3 l=23,93 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1794, '1', 0, 0, 0, 0, ':w=5,5 l=29,91 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '', 13, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '1', 13, 9, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '', 13, 11, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '3', 11, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '2', 11, 9, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '3', 11, 11, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '', 9, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '1', 9, 9, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '', 9, 11, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '3', 7, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '2', 7, 9, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '3', 7, 11, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '0', 5, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '1', 5, 9, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '', 5, 11, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '3', 3, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '2', 3, 9, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '3', 3, 11, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '0', 1, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '1', 1, 9, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20125, '', 1, 11, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '', 12, 5, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '', 7, 5, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '', 14, 2, 1, 6, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '', 14, 3, 1, 6, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '', 11, 1, 1, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '', 6, 2, 1, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '', 6, 3, 1, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '', 9, 1, 1, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '', 7, 1, 1, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95382, '1', 12, 1, 1, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95384, '', 9, 5, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95384, '', 11, 5, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95384, '1', 14, 1, 1, 6, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95384, '1', 14, 5, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95384, '1', 6, 1, 1, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95384, '1', 6, 5, 1, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95383, '', 10, 5, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 25362, '', 12, 3, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 25362, '', 12, 2, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 25362, '', 11, 3, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 25362, '', 11, 2, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 25362, '', 9, 3, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 25362, '', 9, 2, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 25362, '', 7, 3, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 25362, '', 7, 2, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 95389, '1', 7, 2, 1, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1620, '0', 10, 1, 1.5, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 540022, '', 0, 0, 0, 0, ':w=0,12 l=32,116 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 77707, '0', 12, 10, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 949, '', 1, 11, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 540022, '', 0, 0, 0, 0, ':w=2,6 l=3,116 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 540022, '', 0, 0, 0, 0, ':w=0,8 l=32,116 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 540022, '', 0, 0, 0, 0, ':w=0,9 l=4,130 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 20202, '2', 0, 0, 0, 0, ':w=0,8 l=28,105 l', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 77706, '1', 6, 6, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 171, '', 1, 9, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 921, '', 10, 11, 0, 6, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 930, '', 8, 9, 0, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 921, '', 9, 9, 0, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 930, '', 10, 10, 0, 6, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 930, '', 7, 11, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 921, '', 7, 10, 0, 2, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 1528, '', 8, 10, 0.7, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 710001999, 'mlg-270-92.ch-250-78.sh-906-92Ropa', 3, 7, 0, 4, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 710002014, '', 0, 0, 0, 0, ':w=4,6 l=18,106 r', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 710002000, '', 4, 7, 0, 0, '', 0, 0, 'true'),(".$UltimoId.", ".$TrovaIdSalaFetch['id'].", 710002006, '1', 1, 7, 0, 2, '', 0, 0, 'true');");
  291.                     $addFurni->execute();
  292.                     $addroom = $database->prepare("UPDATE users SET home_room = ".$TrovaIdSalaFetch['id']." WHERE id = ".$UltimoId);
  293.                     $addroom->execute();
  294.                     exit;
  295.             }
  296.             header("location: ".$Configurazione['link']."home.php");
  297.             exit;
  298.         }
  299.  
  300.         public static function Ticket()
  301.         {
  302.             $data = "SpisCMS-";
  303.             for ($i=1; $i<=9; $i++){
  304.                 $data = $data . rand(0,6);
  305.             }
  306.             $data = $data . "-";
  307.             for ($i=1; $i<=9; $i++){
  308.                 $data = $data . rand(0,6);
  309.             }
  310.             $data = $data . "-";
  311.             for ($i=1; $i<=9; $i++){
  312.                 $data = $data . rand(0,6);
  313.             }
  314.             $data = $data . "-key-client";
  315.             return $data;
  316.         }
  317.  
  318.         public static function AggiornamentoLastOnline()
  319.         {
  320.             global $database, $Configurazione, $lingua;
  321.             if(Utente::Loggato() == true)
  322.             {
  323.                 $time = strtotime('now');
  324.                 $username = Utente::GestioneUtente('username');
  325.                 $SystemSQL = $database->prepare("UPDATE users SET last_online = :lastonline WHERE username = :username");
  326.                 $SystemSQL->bindParam(":lastonline", $time);
  327.                 $SystemSQL->bindParam(":username", $username);
  328.                 $SystemSQL->execute();
  329.             }
  330.         }
  331.  
  332.         public static function Data()
  333.         {
  334.             $m = date('m');
  335.             $d = date('d');
  336.             $Y = date('Y');
  337.             $DateSystem = date('d/m/Y',mktime($m,$d,$Y));
  338.             return $DateSystem;
  339.         }
  340.  
  341.         public static function Ora()
  342.         {
  343.             $H = date('H');
  344.             $i = date('i');
  345.             $s = date('s');
  346.             $OraSystem = date('H:i:s',mktime($H,$i,$s));
  347.             return $OraSystem;
  348.         }
  349.  
  350.         public static function Adesso()
  351.         {
  352.             return strtotime("now");
  353.         }
  354.  
  355.         public static function CambiaPassword()
  356.         {
  357.             global $database, $Configurazione, $lingua;
  358.             if(!isset($_POST['cambiapassword']))
  359.                 return;
  360.  
  361.             $mailattuale = Html::Filtro($_POST['mailattuale']);
  362.             $nuovapassword = Utente::Crypto(Html::Filtro($_POST['nuovapassword']));
  363.             $username = Utente::GestioneUtente('username');
  364.             $mailattuale2 = Utente::GestioneUtente('mail');
  365.  
  366.             if(empty($mailattuale))
  367.                 return Html::Errore("Il campo della mail attuale non può essere vuoto.");
  368.  
  369.             if(empty($nuovapassword))
  370.                 return Html::Errore("Il campo della nuova password non può essere vuoto.");
  371.  
  372.             if(!$mailattuale == $mailattuale2)
  373.                 return Html::Errore("La mail attuale non corrisponde a quella di registrazione.");
  374.  
  375.             $SystemSQL = $database->prepare("UPDATE users SET password = :nuovapassword WHERE username = :username AND mail = :mailattuale");
  376.             $SystemSQL->bindParam(":nuovapassword", $nuovapassword);
  377.             $SystemSQL->bindParam(":username", $username);
  378.             $SystemSQL->bindParam(":mailattuale", $mailattuale);
  379.             $SystemSQL->execute();
  380.         }
  381.  
  382.         public static function ControlloBan()
  383.         {
  384.             global $database, $Configurazione, $lingua;
  385.             $UsernameBan = Utente::GestioneUtente('username');
  386.             $IpUsersBan = Utente::IpUtente();
  387.             $stmtBans = $database->prepare("SELECT * FROM bans WHERE value = :user OR value = :ip LIMIT 1");
  388.             $stmtBans->bindParam(":user", $UsernameBan);
  389.             $stmtBans->bindParam(":ip", $IpUsersBan);
  390.             $stmtBans->execute();
  391.             $stmtBansFetching = $stmtBans->fetch(PDO::FETCH_ASSOC);
  392.             if($stmtBans->rowCount() > "0")
  393.             {
  394.                 session_destroy();
  395.                 header("location: ".$Configurazione['link']."index.php");
  396.                 exit;
  397.             }
  398.         }
  399.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!