SQL help
#3

pawn Код:
CMD:setname(playerid, params[])
{
    if(PlayerInfo[playerid][pAdmin] >= 2)
    {
        new
            szQuery[128],
            Player,
            NewPlayerName[MAX_PLAYER_NAME];

        if(sscanf(params, "us[24]", Player, NewPlayerName))
            return SendClientMessage(playerid, COLOR_GREY, "SERVER: /setname [playerid] [new name]");

        SetPVarInt(Player, "changeBy", playerid);
        SetPVarString(Player, "oldName", PlayerInfo[Player][pUsername]);

        mysql_real_escape_string(NewPlayerName, PlayerInfo[Player][pUsername], 24);

        format(szQuery, sizeof(szQuery), "UPDATE players SET Username = '%s' WHERE ID = %d", PlayerInfo[Player][pUsername], PlayerInfo[Player][pDBID]);
        mysql_query(szQuery, THREAD_CHANGE_NAME, Player, iConnectionHandle);
    }
    else return SendClientMessage(playerid, COLOR_RED, "You're not an admin!");
    return true;
}
You might have to edit it to your script.

EDIT: "This forum requires that you wait 120 seconds between posts. Please try again in 40 seconds." ffs
Reply


Messages In This Thread
SQL help - by Hybris - 07.04.2014, 19:12
Re: SQL help - by Hybris - 08.04.2014, 01:35
Re: SQL help - by Binx - 08.04.2014, 01:38
Re: SQL help - by Flake. - 08.04.2014, 02:10

Forum Jump:


Users browsing this thread: 3 Guest(s)