UPDATE `table` SET `Nick` = 'NewNick' WHERE `Nick` = 'OldNick';
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;
}
Errors: K:(2933) : warning 202: number of arguments does not match definition K:(2933) : error 033: array must be indexed (variable "newname") K:(2933) : error 029: invalid expression, assumed zero K:(2933 -- 2934) : warning 215: expression has no effect K:(2934) : error 001: expected token: ";", but found "return" K:(2934) : fatal error 107: too many error messages on one line
CMD:setname(playerid, params[]) { if(PlayerInfo[playerid][pAdmin] < 2 ) return SendClientMessage(playerid, COLOR_RED, "[Error]: You are not an admin with required level. "); new otherId; new newname[MAX_PLAYER_NAME]; new iName[MAX_PLAYER_NAME]; if(sscanf(params), "is[23]", otherId, newname)) return SendClientMessage(playerid, COLOR_WHITE, "[Usage]: /setname [PLAYERID] [NEW NAME]"); if(!IsPlayerConnected(playerid)) return SendClientMessage(playerid, COLOR_RED, "That player is not connected!"); GetPlayerName(playerid, playerName, sizeof(pName)); GetPlayerName(otherId, iName, sizeof(iName)); new Query[128]; format(Query, sizeof(Query), "UPDATE `players` SET `Name` = '%s' WHERE `UserName` = '%s'", newname, iName); mysql_query(Query); return 1; }
if(sscanf(params), "is[23]", otherId, newname))
if(!IsPlayerConnected(playerid))
return SendClientMessage(playerid, COLOR_RED, "That player is not connected!");
command(changenick, playerid, params[])
{
new id, newname[25], pName[25], iName[25], 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, 25);
GetPlayerName(id, iName, 25);
format(Query, 128, "UPDATE `players` SET `Name` = '%s' WHERE `UserName` = '%s'", newname, iName);
mysql_query(Query);
}
}
}
return 1;
}
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;
}