30.12.2013, 19:05
How can I change it to Non MySQL?
Код:
CMD:ipwhitelist(playerid, params[])
{
if (PlayerInfo[playerid][pAdmin] >= 4)
{
new string[128], query[256], giveplayer[MAX_PLAYER_NAME], ip[16];
if(sscanf(params, "s[24]s[16]", giveplayer, ip))
{
SendClientMessageEx(playerid, COLOR_GREY, "USAGE: /ipwhitelist [admin name] [IP]");
return 1;
}
new tmpName[24], tmpIP[16];
mysql_real_escape_string(giveplayer, tmpName, MainPipeline);
mysql_real_escape_string(ip, tmpIP, MainPipeline);
SetPVarString(playerid, "OnIPWhitelist", tmpName);
format(query, sizeof(query), "UPDATE `accounts` SET `SecureIP`='%s' WHERE `Username`='%s' AND `AdminLevel` <= %d", tmpIP, tmpName, PlayerInfo[playerid][pAdmin]);
mysql_function_query(MainPipeline, query, false, "OnIPWhitelist", "i", playerid);
format(string, sizeof(string), "Attempting to whitelist %s on %s's account...", tmpIP, tmpName);
SendClientMessageEx(playerid, COLOR_YELLOW, string);
}
return 1;
}
forward OnIPWhitelist(index);
public OnIPWhitelist(index)
{
new string[128], name[24];
GetPVarString(index, "OnIPWhitelist", name, 24);
if(mysql_affected_rows(MainPipeline)) {
format(string, sizeof(string), "You have successfully whitelisted %s's account.", name);
SendClientMessageEx(index, COLOR_WHITE, string);
}
else {
format(string, sizeof(string), "There was a issue with whitelisting %s's account.", name);
SendClientMessageEx(index, COLOR_WHITE, string);
}
DeletePVar(index, "OnIPWhitelist");
return 1;
}