<?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);
}catch(PDOException $e){
    echo "Connection failed: " . $e->getMessage();
}

onLoad($conn);
function onLoad($conn){
    $session_id = "";
    $userid = "";
    if(isset($_COOKIE['Crecketgaming_sessionid'])){
        $time = time();
        $session_id = $_COOKIE['Crecketgaming_sessionid'];
        $addrip = $_SERVER['REMOTE_ADDR'];
        $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);
        if($sth->execute()){
        }else{
            echo "error";
        }
        $rowcount = $sth->rowCount();
        $row = $sth->fetch();
        $userid = $row['user_id'];
        if ($rowcount > 0) {
            if($userid === NULL){
            }else{
                setSessionDetails($conn, $userid);
            }

        } else {
            $session_id = storeUID($conn);
        }
    } else {
        $session_id = storeUID($conn);
    }
    if($session_id !== "") {
        if($userid === NULL){
        }else{
            setSessionDetails($conn, $userid);
        }
    }
}

function storeUID($conn){
    $addrip = $_SERVER['REMOTE_ADDR'];
    $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 (session_id, ip, time) VALUES (:sessionid, :addrip, :time)";
        $sth = $conn->prepare($sql);
        $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) {
    echo $userid;
    session_start($session_id);
    session_id($session_id);
    $sql = "SELECT * FROM users WHERE user_ID = :user_ID";
    $sth = $conn->prepare($sql);
    $sth->bindParam(':user_ID', $userid);
    $row = $sth->fetch();
    print_r($row);
    $_SESSION['crecketgaming_usergroup'] = $row['Usergroup'];
    $_SESSION['crecketgaming_username'] = $row['Username'];
    $_SESSION['crecketgaming_userid'] = $row['user_ID'];
}