<?php
session_start();
include($_SERVER['DOCUMENT_ROOT']. '/../db_connect.php');

if (!Isset($_SESSION['crecketgaming_usergroup'])){
    $_SESSION['crecketgaming_usergroup'] = "Guest";
}
    try {
        $conn = new PDO("mysql:host=$servername:3307;dbname=$dbname", $username, $password);
        $conn->setAttribute(PDO::ATTR_ERRMODE,  PDO::ERRMODE_EXCEPTION);
    }catch(PDOException $e){
    }

mainCheck($conn);
function mainCheck($conn){
    $session_id = "";
    if(isset($_COOKIE['Crecketgaming_sessionid'])){
        $time = time();
        $session_id = $_COOKIE['Crecketgaming_sessionid'];
        $addrip = $_SERVER['REMOTE_ADDR'];
        $userid = $_SESSION['crecketgaming_userid'];
        $sql = "SELECT * FROM sessions WHERE session_id = :sessionid AND ip = :addrip";
        $sth = $conn->prepare($sql);
        $sth->bindParam(':sessionid', $session_id, PDO::PARAM_STR);
        $sth->bindParam(':addrip', $addrip, PDO::PARAM_STR);
        $sth->execute();
        $rowcount = $sth->rowCount();
        $row = $sth->fetch();
        if ($rowcount > 0) {
            echo $row ['user_id'];
        } else {
            $session_id = storeUID($conn);
        }
    } else {
        $session_id = storeUID($conn);
    }

    if($session_id == "") {

    } else {
        session_start($session_id);
        session_id($session_id);
        /*$sql = "INSERT INTO sessions (user_id, session_id, ip, time) VALUES (:userid, :sessionid, :addrip, :time)";
        $sth = $conn->prepare($sql);
        $sth->bindParam(':userid', $userid, PDO::PARAM_STR);
        $sth->bindParam(':sessionid', $session_id, PDO::PARAM_STR);
        $sth->bindParam(':addrip', $addrip, PDO::PARAM_STR);
        $sth->bindParam(':time', $time, PDO::PARAM_INT);
        $sth->execute();*/
    }
    setSessionDetails($conn, $userid);
}

function storeUID($conn){
    $addrip = $_SERVER['REMOTE_ADDR'];
    $userid = $_SESSION['crecketgaming_userid'];
    $session_id = createUID(100);
    $time = time();
    if(setcookie("Crecketgaming_sessionid", $session_id, mktime(). time()+60*60*24*30)){
        $agent = $_SERVER['HTTP_USER_AGENT'];
        $ip = $ip = $_SERVER['REMOTE_ADDR'];
        $sql = "INSERT INTO sessions (user_id, session_id, ip, time) VALUES (:userid, :sessionid, :addrip, :time)";
        $sth = $conn->prepare($sql);
        $sth->bindParam(':userid', $userid, PDO::PARAM_STR);
        $sth->bindParam(':sessionid', $session_id, PDO::PARAM_STR);
        $sth->bindParam(':addrip', $addrip, PDO::PARAM_STR);
        $sth->bindParam(':time', $time, PDO::PARAM_INT);
        $sth->execute();
    }
    return $session_id;
}

function createUID($length) {
    $chars = "abcdefghijkmnopqrstuvwxyz0123456789";
    srand((double)microtime()*1000000);
    $i = 0;
    $pass = '' ;
    while ($i < $length) {
        $num = rand() % 33;
        $tmp = substr($chars, $num, 1);
        $pass = $pass . $tmp;
        $i++;
    }
    return $pass;
}

function setSessionDetails($conn, $userid) {
    $sql = "SELECT Usergroup, user_ID FROM users WHERE Username = :username";
    $sth = $conn->prepare($sql);
    $sth->bindParam(':username', $userid, PDO::PARAM_STR);
    $sth->execute();
    $row = $sth->fetch();

    $_SESSION['crecketgaming_usergroup'] = $row['Usergroup'];
    $_SESSION['crecketgaming_username'] = $row['Username'];
    $_SESSION['crecketgaming_userid'] = $row['user_ID'];
}