Saver

#include <	a_samp	>

#pragma tabsize 0

enum pInfo
{
	Moneys,
	Score,
};

new P_DATA[ MAX_PLAYERS ][ pInfo ],
	DB:Saver;

public OnFilterScriptInit( )
{
	Saver = db_open( "Saver.db" );
	db_free_result( db_query( Saver, "CREATE TABLE IF NOT EXISTS `Saver` \
										( `Keys` INTEGER PRIMARY KEY AUTOINCREMENT, \
										  `Nume` TEXT, \
										  `Bani` NUMERIC, \
										  `Score` NUMERIC )" ) );
	return 1;
}

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

public OnPlayerConnect( playerid )
{
	new DBResult:Result, Query[ 256 ], Field[ 30 ];

	format( Query, 256, "SELECT * FROM `Saver` WHERE `Nume` = '%s'", PlayerName2( playerid ) );
	Result = db_query( Saver, Query );

	if ( db_num_rows( Result ) )
	{
		db_get_field_assoc( Result, "Bani", Field, 30 );
		P_DATA[ playerid ][ Moneys ] = strval( Field );
		db_get_field_assoc( Result, "Score", Field, 30 );
		P_DATA[ playerid ][ Score ] = strval( Field );

		ResetPlayerMoney( playerid );
		GivePlayerMoney( playerid, P_DATA[ playerid ][ Moneys ] );
		SetPlayerScore( playerid, P_DATA[ playerid ][ Score ] );
	} else {
		format( Query, sizeof( Query ), "INSERT INTO `Saver` VALUES(NULL, '%s', '%d', '%d' )", PlayerName2( playerid ), 0, 0 );
		db_free_result( db_query( Saver, Query ) );
	}
	db_free_result( Result );
	return 1;
}

public OnPlayerDisconnect( playerid, reason )
{
	new Query[ 256 ];
	format( Query, sizeof( Query ), "UPDATE `Saver` SET `Bani` = '%d', `Score` = '%d' WHERE `Nume` = '%s'", GetPlayerMoney( playerid ), GetPlayerMoney( playerid ), PlayerName2( playerid ) );
	db_free_result( db_query( Saver, Query ) );
	return 1;
}

PlayerName2( playerid )
{
	new name[ 30 ];
	GetPlayerName( playerid, name, 30 );
	return name;
}