[Markus1337]

EDIT: Check what include i'm using, i wont change cuz im not that good with mysql.
Also: Is this really the best way to do it? Please show me a better way if possible.

pawn Код:

CMD:duty(playerid, params[], help)
{
        #pragma unused help
        #pragma unused params
        if(PlayerInfo[playerid][pLevel] < 5) return SendClientMessage(playerid, COLOR_RED, "You need to be admin to use this!");
        new string[128];
        if(PlayerInfo[playerid][pDuty] == 0)
        {
            format(string,sizeof(string),"{COLOR_ORANGE}Admin {COL_WHITE}%s {COLOR_ORANGE}is now on duty",GetName(playerid));
            SendClientMessageToAll(-1, string);
            PlayerInfo[playerid][pDuty] = 1;
            new Query[500], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(Query, sizeof(Query), "UPDATE playerdata SET duty=%d",
            PlayerInfo[playerid][pDuty],
            pname);
            mysql_query(Query);
        }
        else
        {
            format(string,sizeof(string),"{COLOR_ORANGE}Admin {COL_WHITE}%s {COLOR_ORANGE}is now off duty",GetName(playerid));
            SendClientMessageToAll(-1,string);
            PlayerInfo[playerid][pDuty] = 1;
            new Query[500], pname[24];
            GetPlayerName(playerid, pname, 24);
            format(Query, sizeof(Query), "UPDATE playerdata SET duty=%d",
            PlayerInfo[playerid][pDuty],
            pname);
            mysql_query(Query);
            }
        return 1;
}

Include:

pawn Код:

/*
    SA-MP MySQL plugin R5
    Copyright © 2008-2010, G-sTyLeZzZ 
*/

#if defined mysql_included
    #endinput
#endif
#define mysql_included

//Common error codes (http://dev.mysql.com/doc/refman/5.0/en/e...rver).html)

#define ER_DBACCESS_DENIED_ERROR 1044
#define ER_ACCESS_DENIED_ERROR 1045
#define ER_UNKNOWN_TABLE 1109
#define ER_SYNTAX_ERROR 1149
#define CR_SERVER_GONE_ERROR 2006
#define CR_SERVER_LOST 2013
#define CR_COMMAND_OUT_OF_SYNC 2014
#define CR_SERVER_LOST_EXTENDED 2055

//Native functions

#define mysql_fetch_row(%1) mysql_fetch_row_format(%1,"|")
#define mysql_next_row() mysql_retrieve_row()
#define mysql_get_field(%1,%2) mysql_fetch_field_row(%2,%1)

native mysql_affected_rows(connectionHandle = 1);
native mysql_close(connectionHandle = 1);
native mysql_connect(const host[],const user[],const database[],const password[]);
native mysql_debug(enable = 1);
native mysql_errno(connectionHandle = 1);
native mysql_fetch_int(connectionHandle = 1);
native mysql_fetch_field(number,dest[],connectionHandle = 1);
native mysql_fetch_field_row(string[],const fieldname[],connectionHandle = 1);
native mysql_fetch_float(&Float:result,connectionHandle = 1);
native mysql_fetch_row_format(string[],const delimiter[] = "|",connectionHandle = 1);
native mysql_format(connectionHandle, output[], format[], {Float,_}:...);
native mysql_field_count(connectionHandle = 1);
native mysql_free_result(connectionHandle = 1);
native mysql_get_charset(destination[],connectionHandle = 1);
native mysql_insert_id(connectionHandle = 1);
native mysql_num_rows(connectionHandle = 1);
native mysql_num_fields(connectionHandle = 1);
native mysql_ping(connectionHandle = 1);
native mysql_query(query[],resultid = (-1),extraid = (-1),connectionHandle = 1);
native mysql_query_callback(index,query[],callback[],extraid = (-1),connectionHandle = 1);
native mysql_real_escape_string(const source[],destination[],connectionHandle = 1);
native mysql_reconnect(connectionHandle = 1);
native mysql_reload(connectionHandle = 1);
native mysql_retrieve_row(connectionHandle = 1);
native mysql_set_charset(charset[],connectionHandle = 1);
native mysql_stat(const destination[],connectionHandle = 1);
native mysql_store_result(connectionHandle = 1);
native mysql_warning_count(connectionHandle = 1);

//forward declarations

forward OnQueryFinish(query[], resultid, extraid, connectionHandle);
forward OnQueryError(errorid, error[], resultid, extraid, callback[], query[], connectionHandle);