/functions/sessions.php

<?

if(!IsSet($indexloaded)) {

    header("Location: index.php");

}



$ip=getenv("REMOTE_ADDR");

$tday=date("Y-m-d H:i:s");

if($ip){

    $sessioninfo=mysql_query("SELECT sessionid FROM sessions WHERE ipaddress='$ip'");

    $session=mysql_fetch_array($sessioninfo);

}



if($session[sessionid]){

    if(($plyr[id]) && (!$admn[id])){

        mysql_query("UPDATE sessions SET ipaddress='$ip', userid='$plyr[id]', useralias='$plyr[alias]', usertype='2', lastactive='$tday' WHERE sessionid='$session[sessionid]'");

    }



    else if($admn[id]){

        mysql_query("UPDATE sessions SET ipaddress='$ip', userid='$admn[id]', useralias='$admn[alias]', usertype='1', lastactive='$tday' WHERE sessionid='$session[sessionid]'");

    }



    else{

        mysql_query("UPDATE sessions SET ipaddress='$ip', userid='0', useralias='Guest', usertype='3', lastactive='$tday' WHERE sessionid='$session[sessionid]'");

    }



}else{



    $newsession=md5(uniqid(microtime()));

    if(($plyr[id]) && (!$admn[id])){

        $userid="$plyr[id]";

        $useralias="$plyr[alias]";

        $usertype="2";

    }



    else if($admn[id]){

        $userid="$admn[id]";

        $useralias="$admn[alias]";

        $usertype="1";

    }



    else{

        $userid="0";

        $useralias="Guest";

        $usertype="3";

    }



    //CREATE SESSION

    if($ip){

        mysql_query("INSERT INTO sessions VALUES (

        '$newsession',

        '$ip',

        '$userid',

        '$useralias',

        '$usertype',

        '$tday');");

    }



}



//CLEAN SESSIONS

if($timeout[session] > 1){

	$expiredsession=date("Y-m-d H:i:s",time()-$timeout[session]);

	mysql_query("DELETE FROM sessions WHERE lastactive < '$expiredsession'");

}

?>