[Pawn] How to save message with custom color to database?

[Zow]

PHP Code:

CMD:save(playerid, params[])
{
? ? new message[100];
? ? sscanf(params, "s[100]", message);
? ? format(PlayerInfo[playerid][pMessage], 100, message);
    SaveMessage(playerid);
? ? return 1;
}
CMD:show(playerid, params[])
{
? ? new string[100];
? ? if (!strcmp(PlayerInfo[playerid][pMessage], "None", true))
? ? ? ? ?return SendClientMessage(playerid, COLOR_YELLOW, "No message");

? ? format(string, sizeof string, "%s", PlayerInfo[playerid][pMessage]);
? ? SendClientMessage(playerid, COLOR_WHITE, string);
? ? return 1;
}
SaveMessage(playerid)
{
    new query[256];
    mysql_format(dbCon, query, sizeof(query), "UPDATE `players` SET `MessageText` = '%e' WHERE `ID` = '%d'",
    PlayerInfo[playerid][pMessage],
    PlayerInfo[playerid][pSQLID]);
    mysql_tquery(dbCon, query);
    return 1;
} 


/save {F60000}Message {FFFFFF}Message
But its only save Message?Message?
This is what I want

[Pinch]

Code:

CMD:save(playerid, params[]
{
    const MESSAGE_LENGTH_LIMIT = 100;
    if (strlen(params) > MESSAGE_LENGTH_LIMIT)
        return 0; // You probably want to return error message to player here.
        
    strcpy(PlayerInfo[playerid][pMessage], params);
    SaveMessage(playerid);
    return 1;
}

[Zow]

Code:

CMD:save(playerid, params[]

{

? ? const MESSAGE_LENGTH_LIMIT = 100;

? ? if (strlen(params) > MESSAGE_LENGTH_LIMIT)

? ? ? ? return 0; // You probably want to return error message to player here.

? ? ? ?

? ? strcpy(PlayerInfo[playerid][pMessage], params);

? ? SaveMessage(playerid);

? ? return 1;

}

The problem is when I do /save {FF0000}Test{FFFFFF}Test

Its only save TestTest not full message

[Josh]

Colour codes get removed by SA-MP when a player sends them.

[Pinch]

Colour codes get removed by SA-MP when a player sends them.

They aren't removed when they're sent to the dialogs I think so they can do it via dialog



I thought sscanf removes them, oopsie

[Zow]

Any idea how to do this in other way?



https://youtu.be/m9oY8dXgNPY?t=91



This is what I try to do but I don't know how he save the color

[Pinch]

Any idea how to do this in other way?



https://youtu.be/m9oY8dXgNPY?t=91



This is what I try to do but I don't know how he save the color

Dialogs...



OnDialogResponse, dialog style inputtext, inputtext[]...?

[Zow]

Any idea how to do this in other way?



https://youtu.be/m9oY8dXgNPY?t=91



This is what I try to do but I don't know how he save the color

Dialogs...



OnDialogResponse, dialog style inputtext, inputtext[]...?

I was late sorry just post before reading your comment?

Now its worked