Change player's name in mysql.
#10

why such a big command

pawn Код:
CMD:changenick, playerid, params[])
{
    new id,newname[25];
    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(id == INVALID_PLAYER_ID) return SendClientMessage(playerid, COLOR_RED, "That player is not connected!");
    new pName[25], iName[25], Query[128];
    GetPlayerName(playerid, pName, 25);
    GetPlayerName(id, iName, 25);
    format(Query, 128, "UPDATE `players` SET `Name` = '%s' WHERE `UserName` = '%s'", newname, iName);
    mysql_query(Query);
    return 1;
}
basically the same, but it looks kinda better to me :P
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)