<?php

/**
 * @Author Deformed
 * @Copyright 2011
 * @Project Fatal Content Management System
 */

class Users
{
    //Server Update
    function mSU($table,$column,$value,$condition,$server)
    {
        switch ($server)
        {
            case 1:
            $query = mQuery("UPDATE $table SET $column = '$value' WHERE $condition LIMIT 1;");
            break;

        }
    }

    //Server Select
    function mSS($table,$select,$condition,$limit,$server)
    {
        switch ($server)
        {
            case 1:
            return mQuery("SELECT $select FROM $table WHERE $condition LIMIT $limit;");
            break;
        }
    }

    function mCheckSSO($id,$server)
	{
        switch($server)
        {
            case 1:
            $this->mSU("users","auth_ticket",$this->mGenerateTicket(USERNAME),"id = '$id'", $server);
            break;
        }
    }

    function mGenerateTicket($seed = '')
	{
		$ticket = "ST-";
		$ticket .= sha1($seed . 'fatal' . rand(118,283));
		$ticket .= '-' . rand(100, 255);
		return $ticket;
	}

    function mValidate($user,$pass,$email,$ip_reg)
    {
        $username = mClean($user);
        $email = mClean($email);
        $rows = mysql_num_rows($this->mSS("users","1","username='$username'",1,1));
        if ($rows > 0)
        {
            return false;
        }
        else
        {
            $this->mAddUser($username,$pass,$email,$ip_reg);
            return true;
        }
    }

   	function mValidName($username)
	{
		if (preg_match('/^[a-z0-9]+$/i', $username) && strlen($username) >= 1 && strlen($username) <= 32)
		{
			return true;
		}

		return false;
	}

    function mMultiCheck($ip_reg)
    {
        $return = mysql_num_rows($this->mSS("users","username","ip_reg='$ip_reg'",4,1));
        return $return;
    }

    function mAddUser($user,$pass,$email,$ip_reg)
    {
         $time = time();
         $unix_timestamp = strtotime($time);
        $query = mQuery("INSERT INTO users (username,password,mail,auth_ticket,rank,motto,credits,activity_points,last_online,ip_reg,account_created,newbie_status,home_room,ip_last) VALUES ('" . $user . "','" . $pass . "','" . $email . "','','1','','5000','1000','','" . $ip_reg . "','" . $unix_timestamp . "','1','5559022','" . $ip_reg . "');");
    }

    function mLogin($user,$pass)
    {
        $return = mysql_result($this->mSS("users","1","username='$user' AND password='$pass'",1,1),0);
        return $return;
    }

    function mGetVar($request,$username)
    {
        $return = mysql_result(mQuery("SELECT $request FROM users WHERE username = '$username' LIMIT 1;"),0);
        return $return;
    }


    function mIpBanned()
    {
        $return = mysql_result($this->mSS("bans","1","value = '".$_SERVER['REMOTE_ADDR']."'",1,1),0);
        return $return;
    }


    function mUserBanned()
    {
        $return = mysql_result($this->mSS("bans","1","value = '".$_SESSION['username']."'",1,1),0);
        return $return;
    }


    function mDeleteBan()
    {
        $return = mQuery("DELETE FROM bans WHERE value = '".$_SESSION['username']."' LIMIT 1;");
    }

    function mUpdate($column,$value,$id)
    {
        $this->mSU("users",$column,$value,"id='$id'",1);
    }

    function mAddTag($value,$user_id)
    {
        $return = mQuery("INSERT INTO user_tags (`id`, `user_id`, `tag`) VALUES (NULL, '$user_id', '$value');");
    }

    function mRemoveTag($id,$user_id)
    {
        $return = mQuery("DELETE FROM user_tags WHERE id = '$id' AND user_id = '$user_id';");
    }

    function mCountTag($user_id)
    {
        $return = mysql_num_rows(mQuery("SELECT tag FROM user_tags WHERE user_id = '$user_id'"));
        return $return;
    }

    function mGetRank($rank)
    {
        switch($rank)
        {
            case 1:
            return "Normal User";
            break;

            case 2:
            return "Super VIP";
            break;

            case 3:
            return "Events Staff";
            break;

            case 4:
            return "Trial Moderator";
            break;

            case 5:
            return "Moderator";
            break;

            case 6:
            return "Senior Moderator";
            break;

            case 7:
            return "Administrator";
            break;

            case 8:
            return "Owner";
            break;
        }
    }
}

?>