Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- #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;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement