<?php
function debug($variable){

    echo '<pre class="error">' . print_r($variable, true) . '</pre>';

}

function str_random($length){
    $alphabet = "0123456789azertyuiopqsdfghjklmwxcvbnAZERTYUIOPQSDFGHJKLMWXCVBN";
    return substr(str_shuffle(str_repeat($alphabet, $length)), 0, $length);
}

function logged_only(){
    if(!isset($_SESSION['auth'])){
        $_SESSION['flash']['danger'] = "Vous n'avez pas le droit d'accéder à cette page";
        header('Location: /connexion.php');
        exit();
    }
}

function is_connected(){
    if(isset($_SESSION['auth'])){
        return true;
    }else{
        return false;
    }
}

function reconnect_from_cookie(){
    if(session_status() == PHP_SESSION_NONE){
        session_start();
    }
    if(isset($_COOKIE['remember']) && !isset($_SESSION['auth'])){
        require_once 'db.php';
        if(!isset($pdo)){
            global $pdo;
        }
        $remember_token = $_COOKIE['remember'];
        $parts = explode('==', $remember_token);
        $user_id = $parts['0'];
        $req = $pdo->prepare('SELECT * FROM users WHERE id = ?');
        $req->execute([$user_id]);
        $user = $req->fetch();
        if($user){
            $expected = $user_id . '==' . $user['remember_token'] . sha1($user_id . 'ratonlaveurs');
            if($expected == $remember_token){
                $_SESSION['auth'] = $user;
                unset($_SESSION['flash']);
                setcookie('remember', $remember_token, time() + 60 * 60 * 24 * 7);
            }else{
                setcookie('remember', NULL, -1);
            }
        }else{
            setcookie('remember', NULL, -1);
        }
    }
}

// Récupérer la liste d'histoires
function get_last_stories(){
    require_once 'db.php';
    $req = $pdo->prepare('SELECT id, titre, auteur, histoire_resume, category, DATE_FORMAT(date_publication, \'%d/%m/%Y à %Hh%i (Heure française)\') AS good_date_publication FROM histoires ORDER BY id DESC LIMIT 0, 10');
    $req->execute();
    $data = $req->fetchAll();
    return $data;
    $req->closeCursor();
}
// Récupérer une histoire
function get_story($id){
    require 'db.php';
    $req = $pdo->prepare('SELECT *, DATE_FORMAT(date_publication, \'%d/%m/%Y à %Hh%i (Heure française)\') AS good_date_publication FROM histoires WHERE id = ?');
    $req->execute([$id]);
    if($req->rowCount() == 1){
        $data = $req->fetch();
        return $data;
    } else {
        header('Location: index.php');
    }
}
// Rechercher une histoire
function search($content){
    require_once 'db.php';
    $valid_content = strip_tags($content);
    $req = $pdo->prepare("SELECT id, titre, auteur, histoire_resume, category, DATE_FORMAT(date_publication, '%d/%m/%Y à %Hh%i (UTC+1)') AS good_date_publication FROM histoires WHERE titre LIKE '%" . $valid_content . "%'");
    $req->execute();
    $data = $req->fetchAll();
    return $data;
}

function search_inside($content){
    require_once 'db.php';
    $valid_content = strip_tags($content);
    $req = $pdo->prepare("SELECT id, titre, histoire_resume, category, DATE_FORMAT(date_publication, '%d/%m/%Y à %Hh%i (UTC+1)') AS good_date_publication FROM histoires WHERE titre LIKE '%" . $valid_content . "%' OR id LIKE '%" . $valid_content . "%'");
    $req->execute();
    $data = $req->fetchAll();
    return $data;
}

function search_category($content){
    require_once 'db.php';
    $valid_content = strip_tags($content);
    $req = $pdo->prepare("SELECT id, titre, auteur, histoire_resume, category, DATE_FORMAT(date_publication, '%d/%m/%Y à %Hh%i (UTC+1)') AS good_date_publication FROM histoires WHERE category = ?");
    $req->execute([$valid_content]);
    $data = $req->fetchAll();
    return $data;
}