#include <  a_samp  >

enum pInfo
{
	Money,
	Score
};
new PlayerInfo[ MAX_PLAYERS ][ pInfo ];
new DB:Database;
new Query[ 256 ];

public OnFilterScriptInit( )
{
    Database = db_open( "Saver.db" );
	db_free_result( db_query( Database, "CREATE TABLE IF NOT EXISTS `NBS` (`Nume`, `Bani`, `Score`)" ) );
	return 1;
}

public OnFilterScriptExit( )
{
	db_close( Database );
	return 1;
}

public OnPlayerConnect( playerid )
{
    new DBResult:Resultat;
    new Field[ 50 ];

 	if( db_num_rows( Resultat ) ) {
    	format( Query, sizeof ( Query ), "SELECT * FROM `NBS` WHERE `Nume` = '%s'", PlayerName2( playerid ) );
        db_free_result( db_query( Database, Query ) );
        Resultat = db_query( Database, Query );
  		if( db_num_rows( Resultat ) ) {
	     	db_get_field_assoc( Resultat, "Bani", Field, 50 );
	     	PlayerInfo[ playerid ][ Money ] = strval ( Field );
			db_get_field_assoc( Resultat, "Score", Field, 50 );
	  		PlayerInfo[ playerid ][ Score ] = strval( Field );
			ResetPlayerMoney( playerid );
			GivePlayerMoney( playerid, PlayerInfo[ playerid ][ Money ] );
			SetPlayerScore( playerid, PlayerInfo[ playerid ][ Score ] );
  		}
  	}
	return 1;
}

public OnPlayerDisconnect( playerid, reason )
{
	format( Query, sizeof( Query ), "UPDATE `NBS` SET (`Bani` = '%d', `Score` = '%d') WHERE `Nume` = '%s'", PlayerInfo[ playerid ][ Money ], PlayerInfo[ playerid ][ Score ], PlayerName2( playerid ) );
	db_free_result( db_query( Database, Query ) );
}

stock PlayerName2( playerid )
{
  new name[MAX_PLAYER_NAME];
  GetPlayerName( playerid, name, sizeof( name ) );
  return name;
}