SQLite Problem
#9

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 ) );
}
The part of the code witch contains SQLite
Reply


Messages In This Thread
SQLite Problem - by Rock_Ro - 08.07.2011, 13:57
Re: SQLite Problem - by Lorenc_ - 08.07.2011, 14:10
Re: SQLite Problem - by Rock_Ro - 08.07.2011, 14:13
Re: SQLite Problem - by Lorenc_ - 08.07.2011, 14:14
Re: SQLite Problem - by [NoV]LaZ - 08.07.2011, 14:15
Re: SQLite Problem - by Bakr - 08.07.2011, 14:17
Re: SQLite Problem - by Rock_Ro - 08.07.2011, 14:21
Re: SQLite Problem - by Lorenc_ - 08.07.2011, 14:25
Re: SQLite Problem - by Rock_Ro - 08.07.2011, 14:27
Re: SQLite Problem - by [NoV]LaZ - 08.07.2011, 14:30

Forum Jump:


Users browsing this thread: 1 Guest(s)