[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);

[ikey07]

Guess this would be most compact way

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[256],pname[24];
    GetPlayerName(playerid, pname, 24);
    mysql_real_escape_string(pname,pname);
    if(PlayerInfo[playerid][pDuty] == 0) { PlayerInfo[playerid][pDuty] = 1; }
    else { PlayerInfo[playerid][pDuty] = 1; }
    format(string,sizeof(string),"{COLOR_ORANGE}Admin {COL_WHITE}%s {COLOR_ORANGE}is now %s duty",GetName(playerid),PlayerInfo[playerid][pDuty] ? ("on") : ("off"));
    SendClientMessageToAll(-1, string);
    format(string, sizeof(string), "UPDATE `playerdata` SET `duty` = '%d' WHERE `user_name` = '%s'",PlayerInfo[playerid][pDuty],pname);
    mysql_query(string);
    return 1;
}

[Markus1337]

Can anyone show me how to update this to R7, i find this tutorial very hard to understand:https://sampforum.blast.hk/showthread.php?tid=337810

pawn Код:

new string2[256], pname[24];
        GetPlayerName(playerid, pname, 24);
        format(string2, sizeof(string2), "UPDATE `playerdata` SET `frozen` = '%d' WHERE `user_name` = '%s'",PlayerInfo[playerid][pFrozen],pname);

This one isnt even working but still:

pawn Код:

new Query[500];
    strcat(Query, "mysql_query(CREATE TABLE IF NOT EXISTS `playerdata` (\
    `user` VARCHAR(24),\
    `password` VARCHAR(40),\
    `score` INT(20),\
    `money` INT(20),\
    `health` INT(20),\
    `armour` INT(20),\
    `interior` INT(20),");

    strcat(Query, "`virtualworld` INT(20),\
    `level` INT(20),\
    `vip` INT(20),\
    `kma` INT(20),\
    `rank` INT(20),\
    `kills` INT(20),\
    `deaths` INT(20),\
    `muted` INT(20),\
    `skin` INT(20),");
                      

    strcat(Query, "`spec` INT(20),\
    `duty` INT(20),\
    `jailed` INT(20),\
    `frozen` INT(20),\
    `mutedtimes` INT(20),\
    `jailedtimes` INT(20),\
    `frozentimes` INT(20),\
    `banned` INT(20),\
    `bannedby` VARCHAR(24),");
                      
    strcat(Query, "`logins` INT(20),\
    `posx` INT(20),\
    `posy` INT(20),\
    `posz` INT(20),\
    `posa` INT(20),\
    `Tut` INT(20),\
    `IP` VARCHAR(15),\
    PRIMARY KEY (`playerdata`)) ENGINE=InnoDB DEFAULT CHARSET=latin1;");
    mysql_query(Query);

pawn Код:

stock MySQL_Register(playerid, passwordstring[])
{
    new query[425], pname[24], IP[15];
    new Bannedby[20];
    format(Bannedby, 20, "Not Banned");
    GetPlayerName(playerid, pname, 24);
    GetPlayerIp(playerid, IP, 15);

    format(query, sizeof(query), "INSERT INTO playerdata (user, password, score, money, health, armour, interior, virtualworld, level, vip, kma, rank, kills, deaths, muted, skin, spec, duty, jailed, frozen, mutedtimes, jailedtimes, frozentimes, banned, bannedby, logins, posx, posy, posz, posa, tut, IP) VALUES('%s', SHA1('%s'), 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '%s', 0, 0, 0, 0, 0, 0, '%s')", pname, passwordstring, Bannedby, IP);
    mysql_query(query);
    SendMessage(playerid, "~g~Info: ~w~You have been registered on this server!");
    Logged[playerid] = 1;
    return 1;
}

stock MySQL_Login(playerid)
{
    new query[425], pname[24], savingstring[24];
    GetPlayerName(playerid, pname, 24);
    format(query, sizeof(query), "SELECT score, money, health, armour, interior, virtualworld, level, vip, kma, rank, kills, deaths, muted, skin, spec, duty, jailed, frozen, mutedtimes, jailedtimes, frozentimes, banned, bannedby, logins, posx, posy, posz, posa, tut, FROM playerdata WHERE user = '%s'", pname);
    mysql_query(query);
    mysql_store_result();
    while(mysql_fetch_row_format(query,"|"))
    {
        mysql_fetch_field_row(savingstring, "score"); SetPlayerScore(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "money"); MoneyGiven[playerid] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "health"); SetPlayerHealth(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "armour"); SetPlayerArmour(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "interior"); SetPlayerInterior(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "virtualworld"); SetPlayerVirtualWorld(playerid, strval(savingstring));
        mysql_fetch_field_row(savingstring, "level"); PlayerInfo[playerid][pLevel] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "vip"); PlayerInfo[playerid][pVIP] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "kma"); PlayerInfo[playerid][pKMA] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "rank"); PlayerInfo[playerid][pRank] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "kills"); PlayerInfo[playerid][pKills] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "deaths"); PlayerInfo[playerid][pDeaths] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "muted"); PlayerInfo[playerid][pMuted] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "skin"); PlayerInfo[playerid][pSkin] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "spec"); PlayerInfo[playerid][pSpec] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "duty"); PlayerInfo[playerid][pDuty] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "jailed"); PlayerInfo[playerid][pJailed] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "frozen"); PlayerInfo[playerid][pFrozen] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "mutedtimes"); PlayerInfo[playerid][pMutedTimes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "jailedtimes"); PlayerInfo[playerid][pJailedTimes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "frozentimes"); PlayerInfo[playerid][pFrozenTimes] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "banned"); PlayerInfo[playerid][pBanned] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "bannedby"); PlayerInfo[playerid][pBannedBy] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "logins"); PlayerInfo[playerid][pLogins] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "posx"); PlayerInfo[playerid][pPosX] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "posy"); PlayerInfo[playerid][pPosY] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "posz"); PlayerInfo[playerid][pPosZ] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "posa"); PlayerInfo[playerid][pPosA] = strval(savingstring);
        mysql_fetch_field_row(savingstring, "tut"); PlayerInfo[playerid][Tut] = strval(savingstring);
    }
    mysql_free_result();
    JustLogged[playerid] = 1;
    Logged[playerid] = 1;
    PlayerInfo[playerid][pLogins]++;
    SendMessage(playerid, "~g~Info: ~w~You have been logged-in!");
    return 1;
}