<?PHP
if(!defined('VG')){ die; }
class User extends Generic {
    var $logged = false;
    var $accesslvl;
    var $userid;
    var $username;
    var $rawugi;

    function __construct() {
        global $config;
        if($this->setempty($_SESSION['GM_ID']) && $this->setempty($_SESSION['GM_UNAME']) && $this->setempty($_SESSION['GM_PASS'])){
            $this->connectForum();
            $getUser = mysql_fetch_array(mysql_query("SELECT `usergroupid` FROM `forums_user` WHERE `username` = '".$_SESSION['GM_UNAME']."' AND `userid` = '".$_SESSION['GM_ID']."' AND `password` = '".$_SESSION['GM_PASS']."'"));

            if($this->setempty($config['accesslvl'][$getUser['usergroupid']])){
                $this->logged = true;
                $this->accesslvl = $config['accesslvl'][$getUser['usergroupid']];
                $this->rawugi = $getUser['usergroupid'];
                $this->userid = $_SESSION['GM_ID'];
                $this->username = $_SESSION['GM_UNAME'];
            }
        }
    }

    function reqLogin(){
        if(!$this->logged){
            $this->red('login.php');
        }
    }

    function reqAccess($lvl){
        if($this->accesslvl < $lvl){ $this->red('index.php'); }
    }

    function checkAccess($lvl){
        if($this->accesslvl >= $lvl){ return true; }else{ return false; }
    }

    function searchUsers($sname, $rpname, $sid, $ipaddr){
        $query = "SELECT `steamid`, `name`, `ip`, `strikes` FROM `ip_intel` WHERE ";
        $orcheck = 0;
        if($this->setempty($sname) || $this->setempty($rpname) || $this->setempty($sid) || $this->setempty($ipaddr)){
            $this->connectPerp();
            if($this->setempty($sname)){ $query .= "`name` LIKE '%".mysql_escape_string($sname)."%'"; $orcheck++; }
            if($this->setempty($rpname)){ if($orcheck > 0){ $orcheck--; $query .= " OR "; } $query .= "`rp_name` LIKE '%".mysql_escape_string($rpname)."%'"; $orcheck++; }
            if($this->setempty($sid)){ if($orcheck > 0){ $orcheck--; $query .= " OR "; } $query .= "`steamid` = '".mysql_escape_string($sid)."'"; $orcheck++; }
            if($this->setempty($ipaddr)){ if($orcheck > 0){ $orcheck--; $query .= " OR "; } $query .= "`ip` = '".mysql_escape_string($ipaddr)."'"; $orcheck++; }
            $commit = mysql_query($query);
            $arr = array();
            while($row = mysql_fetch_array($commit)){
                $arr[] = array('name' => $row['name'], 'steamid' => $row['steamid'], 'ip' => $row['ip']);
            }
            return $arr;
        }else{
            return false;
        }
    }

    function getIntelFromSteam($sid, $int = 'name'){
        $this->connectPerp();
        $a = mysql_fetch_array(mysql_query("SELECT `".$int."` FROM `ip_intel` WHERE `steamid` = '".mysql_escape_string($sid)."'"));
        return $a[$int];
    }

    function login($username, $password){
        global $config;
        $this->connectForum();
        $row = mysql_fetch_array(mysql_query("SELECT `userid`, `usergroupid`, `salt`, `password` FROM `forums_user` WHERE `username` = '".mysql_escape_string($username)."'"));
        if($this->setempty($row['usergroupid'])){
            if($this->setempty($config['accesslvl'][$row['usergroupid']])){
                $enc_password = md5(md5($password).$row['salt']);
                if($row['password'] == $enc_password){
                    $_SESSION['GM_ID'] = $row['userid'];
                    $_SESSION['GM_UNAME'] = $username;
                    $_SESSION['GM_PASS'] = $enc_password;
                    $this->connectPerp();
                    mysql_query("DELETE FROM `gmadmin_sessions` WHERE `userid` = '".$row['userid']."' LIMIT 1");
                    mysql_query("INSERT INTO `gmadmin_sessions` (`userid`, `access`, `last_action`, `sessionid`) VALUES ('".$row['userid']."', '".$config['accesslvl'][$row['usergroupid']]."', '".time()."', 'N/A New System')");
                    return true;
                }
            }
        }
        return false;
    }

    function getBans($sid){
        $this->connectPerp();
        $q = mysql_fetch_array(mysql_query("SELECT * FROM `server_bans` WHERE `steamid` = '".mysql_escape_string($sid)."' LIMIT 1"));
        $arr = array();
        $arr['unban'] = $q['unban_time'];
        $arr['by'] = $q['banner_name'];
        $arr['reason'] = $q['reason'];
        return $arr;
    }

    function sidToName($sid){
        $this->connectPerp();
        $arr = mysql_fetch_array(mysql_query("SELECT `name` FROM `ip_intel` WHERE `steamid` = '".mysql_escape_string($sid)."' LIMIT 1"));
        return $arr['name'];
    }

    function getIntelInfo($sid, $field){
        $this->connectPerp();
        $ip_intel = mysql_fetch_array(mysql_query("SELECT `".$field."` FROM `ip_intel` WHERE `steamid` = '".mysql_escape_string($sid)."' LIMIT 1"));
        return $ip_intel[$field];
    }

    function getUserInfo($sid, $field){
        $this->connectPerp();
        $perp_users = mysql_fetch_array(mysql_query("SELECT `".$field."` FROM `perp_users` WHERE `steamid` = '".mysql_escape_string($sid)."' LIMIT 1"));
        return $perp_users[$field];
    }

    function returnUserProfile($sid){
        $this->connectPerp();
        $perp_users_allowed = array('blacklists', 'time_played', 'cash', 'uid', 'organization', 'bank', 'last_played', 'ammo_pistol', 'ammo_rifle', 'ammo_shotgun');
        $ip_intel_allowed = array('name', 'first_seen', 'last_seen', 'num_seen', 'unique_id', 'rp_name', 'play_time', 'strikes', 'ip');

        $perp_users = mysql_fetch_array(mysql_query("SELECT * FROM `perp_users` WHERE `steamid` = '".mysql_escape_string($sid)."' LIMIT 1"));
        $ip_intel = mysql_fetch_array(mysql_query("SELECT * FROM `ip_intel` WHERE `steamid` = '".mysql_escape_string($sid)."' LIMIT 1"));

        $arr = array();
        if(is_array($perp_users)){
            foreach($perp_users as $k => $v){
                if(in_array($k, $perp_users_allowed)){
                    $arr[$k] = $v;
                }
            }
        }

        if(is_array($ip_intel)){
            foreach($ip_intel as $k => $v){
                if(in_array($k, $ip_intel_allowed)){
                    $arr[$k] = $v;
                }
            }
        }
        $numMinutes = floor($ip_intel['play_time'] / 60);
        $numHours = floor($numMinutes / 60);

        $averageSession = floor($ip_intel['play_time'] / $ip_intel['num_seen']);
        $numMinutesAvg = floor($averageSession / 60);
        $numHoursAvg = floor($numMinutesAvg / 60);

        $arr['play_time_formatted'] = $numHours." Hours - ".($numMinutes - ($numHours * 60))." Minutes - ".($ip_intel['play_time'] - $numMinutes * 60)." Seconds";
        $arr['average_session_time'] = $numHoursAvg." Hours - ".($numMinutesAvg - ($numHoursAvg * 60))." Minutes - ".($averageSession - $numMinutesAvg * 60)." Seconds";

        return $arr;
    }
}
?>