19.01.2014, 18:34
Still a complete n00b to threaded queries, so here's the code:
Command:
Callback:
REP will be distributed if resolved.
Command:
pawn Код:
COMMAND:unban(playerid, params[])
{
if(Player[playerid][Admin] > 0)
{
if(AdminDuty[playerid] == 1)
{
new string2[128]; //query[256];
format(string2, sizeof(string2), "Usage: /unban <Account>");
TextDrawSetString(CommandTD[playerid], string2);
SetTimerEx("RemoveCMDTD", 6000, false, "i", playerid);
new name[25];
if(sscanf(params, "s[25]", name)) return TextDrawShowForPlayer(playerid, CommandTD[playerid]);
{
new query[128];
format(query, sizeof(query), "SELECT FROM `bans` WHERE 'Name' = '%s'", name);
mysql_function_query(SQL, query, true, "UnbanPlayer", "ds[25]", playerid, name);
}
}
else return AdminDutyOnly;
}
else return AdminOnly;
return 1;
}
pawn Код:
forward UnbanPlayer(playerid, q_result[]);
public UnbanPlayer(playerid, q_result[])
{
new rows,fields;
cache_get_data(rows,fields);
new query[128], string[128], a_string[128];
if(rows > 0)
{
format(string, sizeof(string), "You have successfully unbanned the account '%s'.", q_result);
format(query, sizeof(query), "DELETE * FROM `bans` WHERE `Name` = '%s'", q_result);
format(a_string, sizeof(a_string), "[AdminMsg] %s has just unbanned the account '%s'", RemoveUnderScore(playerid), q_result);
SendADutyMessage(RED, a_string);
}
else
{
new string1[128];
format(string1, sizeof(string1), "The name '{FFFF00}%s{FFFFFF}' was not found in the database.");
SendClientMessage(playerid, WHITE, string1);
}
return 1;
}