playerinfo

function playerinfo( player )
{
try
{
	local ip = player.IP;
	local id = player.ID;
	local query = QuerySQL(db, "SELECT * FROM Accounts WHERE Name = '"+player.Name+"'" );


	if ( GetLevel( player ) == 0 )
	{
		SendMessage( "[#008000][Server] -  [#FFFFFF]Welcome to Low Gravity community! "+player.Name+".",player );
		ErrorMessage( "[#FF0000][HELP] - [#FFFFFF]You are not registered with us. Please, register by /register <password>",player);
	}
	else if ( ip != LastIP( player ) )
	{
		SendMessage( "[#008000][Server] -  [#FFFFFF]Welcome back to Low Gravity community, "+player.Name+".",player );
		ErrorMessage( "[#FF0000][HELP] - [#FFFFFF]Please enter your password to access the services. /login <password>", player );
		status[ player.ID ].Registered = true;
		status[ player.ID ].Logged = false;
	}
	else if ( ip == LastIP( player ) )
	{
		SendMessage( "[#008000][Server] -  [#FFFFFF]Welcome back to VCDM Community! "+player.Name+".",player );
		SendMessage( "[#008000][SUCCESS] - [#FFFFFF]You have been successfully auto logged in the community.", player );
		SendMessage( "[#008000][INFORMATION] - [#FFFFFF]Nick: [#FFFFFF][ " +player.Name+ " ], Level: [ " +GetLevel( player )+  " ], Last IP: [ " +LastIP( player )+ " ].", player );
		ServerMessage( "[LOGIN] - [#8000FF]" +player.Name+ " has been auto identified as level (" +GetLevel( player )+  ")." );
		EchoMessage( ICOL_GREY+"[LOGIN] "+ICOL_PURPLE+" - " +player.Name+ " has been auto identified as level (" +GetLevel( player )+  ")." );
		status[ player.ID ].Registered = true;
		status[ player.ID ].Logged = true;
		status[ player.ID ].Joins++;
		status[ player.ID ].LastIPUsed = player.IP;

		status[ player.ID ].Kills = GetSQLColumnData( query, 4 );
		status[ player.ID ].Deaths = GetSQLColumnData( query, 5 );
		status[ player.ID ].Cash = GetSQLColumnData( query, 6 );
		status[ player.ID ].Bank = GetSQLColumnData( query, 7 );
		status[ player.ID ].Joins = GetSQLColumnData( query, 8 );
		status[ player.ID ].Randspawn = GetSQLColumnData( query, 10 );
		status[ player.ID ].Nogoto = GetSQLColumnData( query, 11 );
		status[ player.ID ].VIPLevel = GetSQLColumnData( query, 12 );
		status[ player.ID ].phone = GetSQLColumnData( query, 14 );
		player.Cash = status[ player.ID ].Cash;
	}
FreeSQLQuery( query );
}
catch(e) print( "playerinfo function Error: " + e );

}