VIP & ADMIN su laiku // v0.1 @ MartynasK

/*

    VIP ir ADMIN su laiku @ MartynasK
    Už idėja dėkoju Renas!.

*/
#define VERSIJA "0.1"
#define mySQL_HOST  "localhost"
#define mySQL_USER  "root"
#define mySQL_DATA  "test"
#define mySQL_PASS  ""
#define USERS_TABLE "zaidejai"

#define MAX_PLAYERS 10

#include <a_samp>
#include <a_mysql>
#include <zmcd>
#include <sscanf2>

enum playerInfo
{
    Admin,
    AdminL,
    Vip,
    VipL
}
new pData[ MAX_PLAYERS ][ playerInfo ];

main( )
{
    print( "# VIP and ADMIN privileges ( v"VERSIJA" ) for 30 days by MartynasK" );
}

public OnGameModeInit()
{
    mysql_debug( true );
    mysql_connect( mySQL_HOST, mySQL_USER, mySQL_DATA, mySQL_PASS );
    print( "# Jungiamasi prie mySQL..." );
    if( mysql_ping( ) >= 1 )
    {
        print( "# Prie mySQL prisijungta sėkmingai." );

    } else {

        print( "# Prie mySQL prisijungti nepavyko. Serveris išjungiamas." );
        SendRconCommand( "exit" );
    }
    return 1;
}

public OnGameModeExit()
{
    mysql_close( );
    return 1;
}

CMD:p( playerid, params[] )
{
    if( isnull( params ) ) return SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Pirkimai: /p admin, /p vip" );

    new
        Check   [ 1 ][ 10 ];

    sscanf( params, "s[ 10 ]", Check[ 0 ] ) );

    if( !strcmp( Check[ 0 ], "admin", true ) )
    {
            if( pData[ playerid ][ Admin ] > 0 ) return SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Jūs jau turite administratoriaus privilegijas." );
            pData[ playerid ][ Admin ] = 1;
            pData[ playerid ][ AdminL ] = gettime( ) + 86400000 * 30;
            SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Jūsų administratoriaus statusas aktyvuotas 30 dienų." );
            return true;
    }

    else if( !strcmp( Check[ 0 ], "vip", true ) )
    {
            if( pData[ playerid ][ Vip ] > 0 ) return SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Jūs jau turite VIP privilegijas." );
            pData[ playerid ][ Vip ] = 1;
            pData[ playerid ][ VipL ] = gettime( ) + 86400000 * 30;
            SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Jūsų VIP statusas aktyvuotas 30 dienų." );
            return true;
    }
    return true;
}

public OnPlayerConnect(playerid)
{
    LoadPlayer( playerid );
    return 1;
}

public OnPlayerDisconnect(playerid, reason)
{
    SavePlayer( playerid );
    return 1;
}

public OnPlayerSpawn(playerid)
{
    if( pData[ playerid ][ AdminL ] < gettime( ) )
    {
            if( pData[ playerid ][ Admin ] > 0 )
            {
                SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Deja, bet jūsų ADMIN laikas baigėsi, todėl privilegijos jums nuimamos." );
                pData[ playerid ][ Admin ] = 0;
                return true;
        }
    }

    else if( pData[ playerid ][ VipL ] < gettime( ) )
    {
            if( pData[ playerid ][ Vip ] > 0 )
            {
                SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Deja, bet jūsų VIP laikas baigėsi, todėl privilegijos jums nuimamos." );
                pData[ playerid ][ Vip ] = 0;
                return true;
        }
    }
    return 1;
}

stock LoadPlayer( playerid )
{
    new
        Query   [ 280 ],
        Fetch   [ 280 ],
        tempInt;

    format( Query, sizeof( Query ), "SELECT * FROM "USERS_TABLE" WHERE Vardas = '%s'", zVardas( playerid ) );
    mysql_query( Query );
    mysql_store_result( );
    mysql_retrieve_row( );

    mysql_fetch_field_row( Fetch, "Admin" );
    sscanf( Fetch, "i", pData[ playerid ][ Admin ] );

    mysql_fetch_field_row( Fetch, "AdminL" );
    sscanf( Fetch, "i", pData[ playerid ][ AdminL ] );

    mysql_fetch_field_row( Fetch, "Vip" );
    sscanf( Fetch, "i", pData[ playerid ][ Vip ] );

    mysql_fetch_field_row( Fetch, "VipL" );
    sscanf( Fetch, "i", pData[ playerid ][ VipL ] );

    mysql_free_result( );
}

stock SavePlayer( playerid )
{
    new
        Query[ 280 ];

    format( Query, sizeof( Query ), "UPDATE "USERS_TABLE" SET Admin = '%i', AdminL = '%i', Vip = '%i', VipL = '%i' WHERE Vardas = '%s'", zVardas( playerid ) );
    mysql_query( Query );
}

stock zVardas( playerid )
{
    new pName[ MAX_PLAYER_NAME ];
    GetPlayerName( playerid, pName, MAX_PLAYER_NAME );
    return pName;
}