[N0FeaR]

i trying make change chatstyle cmd but when i change chatstyle wont update it in my mysql database what might be the problme?

PHP код:

}
CMD:chatstyle(playerid, params[])
{
    new aimid, szQuery[128];
    if(sscanf(params, "i", aimid)) SendClientMessage(playerid, COLOR_GREY, "USAGE: /chatstyle [0-8]");
    else
    {
        if (PlayerCuffed[playerid] >= 1) return SendClientMessageEx(playerid, COLOR_WHITE, "You cannot use this while cuffed!");
        if (PlayerInfo[playerid][pJailTime] > 0) return SendClientMessageEx(playerid, COLOR_WHITE, "You cannot use this now!");
        if (PlayerInfo[playerid][pHospital] > 0) return SendClientMessageEx(playerid, COLOR_WHITE, "You cannot use this while in hospital");
        if (GetPVarInt(playerid, "Injured")) return SendClientMessageEx(playerid, COLOR_WHITE, "You cannot use this while dead!");
        switch(aimid)
        {
            case 0:
            {
                DeletePVar(playerid,"ChatStyle");
                SendClientMessage(playerid,COLOR_WHITE,"Chatstyle removed.");
            }
            case 1 .. 8:
            {
                format(szQuery, sizeof(szQuery), "UPDATE `accounts` SET `ChatStyle`=%d WHERE `ChatStyle` = '%d'", PlayerInfo[aimid][pChatStyle]);
                mysql_function_query(MainPipeline, szQuery, false, "OnQueryFinish", "ii", SENDDATA_THREAD, playerid);
                SetPVarInt(playerid, "ChatStyle", aimid);
                SendClientMessage(playerid,COLOR_WHITE,"Chatstyle set.");
            }
            default: SendClientMessage(playerid, COLOR_GREY, "USAGE: /chatstyle [0-8]");
        }
    }
    return 1;
} 


[OwlIT]

Well you have forgotten to update the pChatStyle variable and you have inserted in the 'playerid' parameter 'aimid'. Put this before the query:

Код:

PlayerInfo[playerid][pChatStyle] = aimid;

[N0FeaR]

Quote:

Originally Posted by OwlIT Well you have forgotten to update the pChatStyle variable and you have inserted in the 'playerid' parameter 'aimid'. Put this before the query: Код: PlayerInfo[playerid][pChatStyle] = aimid;

Still same problem.

[jlalt]

Change:

PHP код:

format(szQuery, sizeof(szQuery), "UPDATE `accounts` SET `ChatStyle`=%d WHERE `ChatStyle` = '%d'", PlayerInfo[aimid][pChatStyle]); 


with

PHP код:

format(szQuery, sizeof(szQuery), "UPDATE `accounts` SET `ChatStyle`= '%d' WHERE `ChatStyle` = '%d'", aimid, PlayerInfo[playerid][pChatStyle]); 


You were using two %d but just telling one of them what should it be so my code should work :c

[PrO.GameR]

`ChatStyle` = '%d'"
Are you seriously using Chatstyle as the where clause ? Do you know what that will do ? Lemme show you

I use chatstyle, set my chatstyle to 3, You having chatstyle 3 use it, change yours to 5, that actually will change everyone that have/had chatstyle 3 to 5, including me, your where clause should be
`ID` = %d, %d pointing to PlayerInfo[aimid][SQLID] or whatever you saved SQLID into.

PHP код:

                format(szQuery, sizeof(szQuery), "UPDATE `accounts` SET `ChatStyle`=%d WHERE `ID` = %d", aimid,PlayerInfo[playerid][SQLID]); 


Honestly this feels a lot like copy-pasted now not working kind of topic, Where the hell did you take this from ? PlayerInfo[aimid][pChatStyle] << What is this supposed to mean ? it should be playerid not aimid.