08.07.2011, 14:27
pawn Код:
public OnFilterScriptInit( )
{
Database = db_open( "RepPlayers.db" );
db_free_result( db_query( Database, "CREATE TABLE IF NOT EXISTS `REP` (`Name`, `Reputation`)" ) );
}
public OnFilterScriptExit( )
{
db_close( Database );
}
public OnPlayerConnect( playerid )
{
new Query2[ 256 ];
new DBResult:RRezult;
format( Query2, sizeof( Query2 ), "SELECT 'Reputation' FROM `REP` WHERE `Name` = '%s'", CName( playerid ) );
RRezult = db_query( Database, Query2 );
if( db_num_rows( RRezult ) )
{
new Field[ 30 ];
new Reputation;
db_get_field_assoc( RRezult, "Reputation", Field, 30);
Reputation = strval( Field );
RK_REP[ playerid ][ RK_REPUTATION ] = Reputation;
}
db_free_result( RRezult );
}
public OnPlayerDisconnect( playerid )
{
format( Query, sizeof( Query ), "UPDATE 'Reputation' FROM `REP` (`Name`, `Reputation`) VALUES('%s', '%d')", CName( playerid ), RK_REP[ playerid ][ RK_REPUTATION ] );
db_free_result( db_query( Database, Query ) );
}