session_start();

/* * **************************************************** 
 * La suite des fonctiones ne doit surtout pas etre ***** 
 * modifier sous peine de dysfonctionnement du site ***** 
 * aucun support ne serra fait si les fonctions ne ****** 
 * sont plus celles d'origines, merci de votre ********** 
 * compréhension DARKWITCH_ Dev web de WISPE ************
 * ************************************************** * */
$host = "localhost";
$login = "root";
$password = "";
$base = "vylaria";

function Mysqli() {//ne pas touchez a la fonction les changement sont automatiques 
    $host = "localhost";
    $login = "root";
    $password = "";
    $base = "vylaria";
    $mysqli = new mysqli("$host", "$login", "$password", "$base");
    if (mysqli_connect_errno()) {
        printf("Echec de la connexion: %s\n", mysqli_connect_error());
        exit();
    }

    return $mysqli;
}

$mysqli = Mysqli();

function redirect($url) {
    header('Location: ' . $url);
    exit();
}

function VoirNews($id) {
    $mysqli = Mysqli();
    $selectnews = $mysqli->query('SELECT * FROM news  WHERE id="' . $id . '"');
    $nb_news = $selectnews->num_rows;
    if ($nb_news == 0) {
        $url = "index.php";
        redirect($url);
    } else {
        $var1 = $selectnews->fetch_object();
        return $var1;
    }
}

function CryptPass($pass) {
    $mysqli = Mysqli();
    $finalcrypt = $mysqli->real_escape_string(password_hash($pass, PASSWORD_DEFAULT));
    return $finalcrypt;
}

function ReadConf() {
    $mysqli = Mysqli();
    $select = $mysqli->query('SELECT * FROM conf WHERE id = "1"');
    $data = $select->fetch_object();
    return $data;
}
function GetNews(){
    $mysqli = Mysqli();
    $select = $mysqli->query('SELECT * FROM news ORDER BY id DESC LIMIT 0,5');
    return $select;
}