class Mages
{
    Register=false;
    Logined=false;
    Kills=0;
    Deaths=0;
    Cash=0;
    Bank=0;
    Joins=0;
    MagicL=1;
    Mana=100;
    AMana=100;
    Exp=0;
    AExp=525;
    RMPoint=0;
    GMPoint=0;
    BMPoint=0;
    showpos=false;
    abisec=null;
    overuse=false;
    toveruse=0;
    timer=null;
    intimer=null;
    inoveruse=0;
    invisible=false;
    type=null;
    typeing="self";
    mutetime=0;
}

function onServerStart()
{
Mage <- array( GetMaxPlayers(), null );
}

function onPlayerJoin(player)
{

    stats[player.ID]=PlayerStats();
    //
    MessagePlayer("Your mechine id is "+player.UniqueID,player);
    //print("Player '"+player.Name+"' ID "+player.ID+" UID "+player.UniqueID);
    //Announce("~r~Welcome!",player,3);

    NewTimer( "AccInfo", 500, 1, player.ID );

    UpdateText(player);
    //loler = myGates(player.ID);


}

function AccInfo( plr )
{
    local player=FindPlayer(plr);
    if(player)
    {
        Mage[ player.ID ] = Mages();
        local id = player.ID;
        local ip = player.IP;
        local level = GetLevel( player );
        local q = QuerySQL( db, "SELECT * FROM Account WHERE Name='" + player.Name.tolower() + "'" );

        if ( q )
        {
            if ( ip != GetIP( player ) )
            {
                Logout( player );
                MessagePlayer("[#FF3636]Please, insert your password to login.",player);
                MessagePlayer("[#FF3636]To login type: /login <password>.",player);
                Mage[ player.ID ].Register = true;

            }
            else if ( ip == GetIP( player ) && GetSQLColumnData( q, 4 ) == "true"  )
            {

                if ( GetSQLColumnData( q, 0 ) != null ) SetStats(player, q);
                GetSQLNextRow( q );
                MessagePlayer("[#FFFF81]"+player.Name+" has been auto-logged on the server!",player);
                MessagePlayer("[#FFFF81]Name:[" + player.Name + "], Level:[" + GetLevel(player) + "], State:[" + GetLevelTag(player) + "].",player);
                Mage[ player.ID ].Register = true;
                Mage[ player.ID ].Logined = true;
                Mage[ player.ID ].Joins++;
            }
            else if(GetSQLColumnData( q, 4 ) == "false")
            {
                Mage[ player.ID ].Register = true;
                Mage[ player.ID ].Logined = false;
                MessagePlayer("[#FF3636]Please, insert your password to login.",player);
                MessagePlayer("[#FF3636]To login type: /login <password>.",player);

            }
        }
        else
        {
            MessagePlayer("Please register your nick for access to services.",player);
            MessagePlayer("To register type: /register <password>.",player);
        }
            fps.push({Player = player, Text = null});
            speed.push({Player = player, Text = null});
            posofplr.push({Player = player, x = null, y = null, z = null, angle = null, district=null});
    }
}

function Register( player, password )
{
    local pass = password;
    QuerySQL( db, "INSERT INTO Account ( Name, IP, Level, Pass, Logined, Kills, Deaths, Cash, Bank, Joins, MagicL, Mana, AMana, Exp, AExp,RMPoint,GMPoint,BMPoint ) VALUES ( '" + player.Name.tolower() + "', '" + player.IP + "', 1, '" + password + "', 'true' , 0, 0, 2000, 0, 0, 1, 100, 100, 0, 525, 0, 0, 0 )" );
    player.Cash=2000;
    Mage[ player.ID ].Register = true;
    Mage[ player.ID ].Logined = true;


    //Message("[#FFFF81]---> You have registered.");
    Message("[#FFFF81]---> Nick:[ "+ player.Name +"  ] Password:[ " + password + " ]");

}

function onPlayerCommand( player, command, arguments )
{

    local cmd, text;
        cmd = command;
        text = arguments;

    if ( cmd == "register" )
    {
        if( Mage[ player.ID ].Register == false)
        {

            if(text)
            {
                Register( player, text );
                MessagePlayer("[#FFFF81]--> Registered",player);

            }else MessagePlayer("[#FF3636]Error - [#8181FF]Syntax: /register <password>!",player);

        }else MessagePlayer("[#FF3636]Error - [#8181FF]You are already registered.",player);
    }

    else if ( cmd == "login" )
    {
        if ( Mage[ player.ID ].Register == true )
        {
            if ( Mage[ player.ID ].Logined == false )
            {
                if ( text )
                {
                    if ( text == GetPass( player ) )
                    {
                        Login( player, text );
                    }else MessagePlayer( "[Error] - Invalid Password.", player );

                }else MessagePlayer( "[Syntax] -  /" + cmd + " <Password>", player );

            }else MessagePlayer( "[Error] - You're Already Logged-In.", player );

        }else MessagePlayer( "You're Not Registered. Register by /register <password>", player );
    }

    else if ( cmd == "logout" )
    {
        if ( Mage[ player.ID ].Register == true )
        {
            if ( Mage[ player.ID ].Logined == true )
            {
                Logout( player);

            }else MessagePlayer( "[Error] - You're Already Logged-Out.", player );

        }else MessagePlayer( "You're Not Registered. Register by /register <password>", player );
    }
}