<?php
/* 
 * Asigna pareja a participantes activos
 */
require_once("../../include/constantes.php");
require_once("../../include/bd_pdo.php");

session_start();
if(!isset($_SESSION["n_usuario_id"])){
    session_destroy();
    $pag = "../salir.php?expired=1";
    header("Location: ".$pag);
    exit();
}

$session_life = 1*60*60;//convertido a segundos
if (isset($_SESSION["n_timeout"])) {
// calculate the session's "time to live"
    $sessionTTL = time() - $_SESSION["n_timeout"];
    if ($sessionTTL > $session_life) {
        $_SESSION = array();
        session_destroy();
        $pag = $_SERVER['SERVER_NAME']."/navidad/salir.php?expired=1";
        header("Location: http://".$pag);
        exit();
    }
}else{
    $_SESSION = array();
    session_destroy();
    $pag = $_SERVER['SERVER_NAME']."/navidad/salir.php?expired=1";
    header("Location: http://".$pag);
    exit();
}
$_SESSION["n_timeout"] = time();


if(!isset($_SESSION["n_sgi_administrador"]) || !$_SESSION["n_sgi_administrador"]){
    header("Location: ../main.php?error=0");
    exit();
}

$pag = "../participantes.php";

if(!isset($_POST["nombre"], $_POST["apellidos"], $_POST["usr"], $_POST["pass"])){
    header("Location: ".$pag."?error=3");
    exit();
}

$nombre = mb_strtoupper(trim(filter_input(INPUT_POST, "nombre", FILTER_SANITIZE_STRING,array('flags' => FILTER_FLAG_STRIP_LOW))));//limpia texto
$apellidos = mb_strtoupper(trim(filter_input(INPUT_POST, "apellidos", FILTER_SANITIZE_STRING,array('flags' => FILTER_FLAG_STRIP_LOW))));//limpia texto
$usr = trim(filter_input(INPUT_POST, "usr", FILTER_SANITIZE_STRING,array('flags' => FILTER_FLAG_STRIP_LOW)));//limpia texto
$pass = password_hash(trim($_POST["pass"]), PASSWORD_DEFAULT);

//Inserta
$stmt = $pdo->prepare('Select * from fi_navidadusuarioexterno(:nom, :apell, :usr, :pass)');
$stmt->bindParam(":nom", $nombre);
$stmt->bindParam(":apell", $apellidos);
$stmt->bindParam(":usr", $usr);
$stmt->bindParam(":pass", $pass);
if(!$stmt->execute()){
    header("Location: ".$pag."?error=2");
    exit();
}
$stmt->closeCursor();
header("Location: ".$pag."?ok=2");
?>