Db query

From SA-MP Wiki

Revision as of 04:38, 24 January 2010; view current revision
←Older revision | Newer revision→

This function is used to perform a SQL query on an opened SQLite database

Parameters:

(DB:db, query[])

DB:db

ID of the database you wish to query

query[]

The query you wish to perform

Returns

The query result.

dcmd_skin(playerid,params[])
{
        new pid;
        new query[256];
        if(sscanf(params,"i",pid)) return SendClientMessage(playerid,0xAFAFAFAA,"USAGE: /skin [skinid]");
        format(query,sizeof(query),"UPDATE `users` SET `Skin`='%d' WHERE (`Username` = '%s')", pid, PlayerName[playerid]);
        db_free_result(db_query(USERDB,query));
        SetPlayerSkin(playerid,pid);
        SendClientMessage(playerid,0xAFAFAFAA,"Enjoy your new skin!");
        return 1;
}