[RedJohn]

Hey. How'd I could write to SQL database my tag I selected using:

pawn Код:

COMMAND:tag(playerid, params[])
{
    new
        string[128],
        text
    ;
    if(sscanf(params, "s[30]", text)) return SendClientMessage(playerid, LIGHTBLUE, "[USAGE]: /tag [tag]");
    format(string, sizeof(string), "%s", text);
    GivePlayerTag(playerid, string);
    return 1;
}

pawn Код:

stock GivePlayerTag(playerid, tag[])
{
    new string[30];
    GetPlayerName(playerid, pName, sizeof(pName));
    format(string, sizeof(string), "[%s] %s", tag, pName);
    SetPlayerName(playerid, string);
    return 1;
}

I done my SQL system using this tutorial: https://sampforum.blast.hk/showthread.php?tid=278188

Thanks.

[Sinner]

Query to add the column:

Код:

ALTER `your_table_name` ADD COLUMN `tag` VARCHAR(30)

Query to insert a tag in the database:

Код:

UPDATE `your_table_name` SET `tag` = 'your_tag' WHERE `NAME` = 'your_username'

[RedJohn]

Can't make it working.

[RedJohn]

BUMP