Change player's name in mysql.
#5

You will need to add to this and probably change the "query", but this is a base.

pawn Код:
command(changenick, playerid, params[])
{
    new id, newname[MAX_PLAYER_NAME], pName[MAX_PLAYER_NAME], iName[MAX_PLAYER_NAME], Query[128];
    if(!IsPlayerAdmin(playerid))
        return SendClientMessage(playerid, COLOR_WHITE, "You are not an RCON administrator!");
    if(sscanf(params, "us[23]", id, newname))
        return SendClientMessage(playerid, COLOR_WHITE, "SYNTAX: /changenick [playerid/name] [nickname]");
    if(!IsPlayerConnected(id))
        return SendClientMessage(playerid, COLOR_RED, "That player is not connected!");

    GetPlayerName(playerid, pName, sizeof(pName));
    GetPlayerName(id, iName, sizeof(iName));
   
    format(Query, sizeof(Query), "UPDATE `players` SET `Name` = '%s' WHERE `UserName` = '%s'", newname, iName);
    mysql_query(Query);
    return 1;
}
This uses "sscanf2" and "zcmd" - you'll need 'em!
Reply


Messages In This Thread
Change player's name in mysql. - by NewbBeginner - 13.11.2010, 19:28
Re: Change player's name in mysql. - by rs.pect - 13.11.2010, 19:32
Re: Change player's name in mysql. - by NewbBeginner - 13.11.2010, 19:37
Re: Change player's name in mysql. - by NewbBeginner - 13.11.2010, 22:27
Re: Change player's name in mysql. - by Scenario - 13.11.2010, 23:19
Re: Change player's name in mysql. - by NewbBeginner - 14.11.2010, 11:00
Re: Change player's name in mysql. - by Scenario - 14.11.2010, 13:20
Re: Change player's name in mysql. - by The_Moddler - 14.11.2010, 13:29
Re: Change player's name in mysql. - by Scenario - 14.11.2010, 13:29
Re: Change player's name in mysql. - by The_Gangstas - 14.11.2010, 13:47

Forum Jump:


Users browsing this thread: 6 Guest(s)