View difference between Paste ID: NCuAN8v8 and b1GVC3c3

 /*
 
 	VIP ir ADMIN su laiku @ MartynasK
 	Už idėja dėkoju Renas!.
 
 */
-#define VERSIJA "0.1"
+#define VERSIJA "0.2"
 #define mySQL_HOST  "localhost"
 #define mySQL_USER  "root"
 #define mySQL_DATA  "test"
 #define mySQL_PASS  ""
 #define USERS_TABLE "zaidejai"
 
-#define MAX_PLAYERS 10
+#define MAX_PLAYERS 	10
 #define p 		playerid
 
 #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" );
 
-	    Check   [ 1 ][ 10 ];
+	if( !strcmp( params, "admin", true ) )
 	{
-	sscanf( params, "s[ 10 ]", Check[ 0 ] ) );
+
 	    	pData[ playerid ][ Admin ] = 1;
-	if( !strcmp( Check[ 0 ], "admin", true ) )
+	    	pData[ playerid ][ AdminL ] = gettime( ) + 86400 * 30;
 	    	SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Jūsų administratoriaus statusas aktyvuotas 30 dienų." );
 	    	return true;
 	}
-	    	pData[ playerid ][ AdminL ] = gettime( ) + 86400000 * 30;
+
 	else if( !strcmp( params, "vip", true ) )
 	{
 	    	if( pData[ playerid ][ Vip ] > 0 ) return SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Jūs jau turite VIP privilegijas." );
 	    	pData[ playerid ][ Vip ] = 1;
-	else if( !strcmp( Check[ 0 ], "vip", true ) )
+	    	pData[ playerid ][ VipL ] = gettime( ) + 86400 * 30;
 	    	SendClientMessage( playerid, 0xFFFFFFFF, "[ > ] {ff7e7e}Jūsų VIP statusas aktyvuotas 30 dienų." );
 	    	return true;
 	}
-	    	pData[ playerid ][ VipL ] = gettime( ) + 86400000 * 30;
+
 }
 
 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   [ 100 ],
 	    tempInt;
 
 	format( Query, sizeof( Query ), "SELECT Admin, AdminL, Vip, VipL FROM "USERS_TABLE" WHERE Vardas = '%s'", zVardas( playerid ) );
-	    Query   [ 280 ],
+
-	    Fetch   [ 280 ],
+
 	if( myqsl_fetch_field_row_format( Query, "|" ) )
 	{
-	format( Query, sizeof( Query ), "SELECT * FROM "USERS_TABLE" WHERE Vardas = '%s'", zVardas( playerid ) );
+		sscanf( Query, "p<|>iiii>", pData[ playerid ][ Admin ], pData[ playerid ][ AdminL ], pData[ playerid ][ Vip ], pData[ playerid ][ VipL ] );
 		mysql_free_result( );
 	}
-	mysql_retrieve_row( );
+
 
-	mysql_fetch_field_row( Fetch, "Admin" );
+
-	sscanf( Fetch, "i", pData[ playerid ][ Admin ] );
+
 	new
-	mysql_fetch_field_row( Fetch, "AdminL" );
+
-	sscanf( Fetch, "i", pData[ playerid ][ AdminL ] );
+
 	format( Query, sizeof( Query ), "UPDATE "USERS_TABLE" SET Admin = '%i', AdminL = '%i', Vip = '%i', VipL = '%i' WHERE Vardas = '%s'", pData[p][Admin], pData[p][AdminL], pData[p][Vip], pData[p][VipL], zVardas( playerid ) );
-	mysql_fetch_field_row( Fetch, "Vip" );
+
-	sscanf( Fetch, "i", pData[ playerid ][ Vip ] );
+
 
-	mysql_fetch_field_row( Fetch, "VipL" );
+
-	sscanf( Fetch, "i", pData[ playerid ][ VipL ] );
+
 	new pName[ MAX_PLAYER_NAME ];
-	mysql_free_result( );
+
 	return pName;
 }