PHP код:
stock GetName(playerid)
{
new name[MAX_PLAYER_NAME];
GetPlayerName(playerid, name, sizeof(name));
return name;
}
ACMD:offlineban(playerid, params[])
{
new playername[MAX_PLAYER_NAME], reason[50];
if(sscanf(params, "s[24]s[50]", playername, reason)) return SendClientMessage(playerid, -1, "USAGE: /offlineban [playername] [reason]");
new query[350];
mysql_format(connectionHandle, query, sizeof(query), "SELECT * FROM `account` WHERE `username` = '%e' LIMIT 1;", playername);
new Cache:result = mysql_query(connectionHandle, query);
if(!cache_num_rows()) return SendClientMessage(playerid, -1, "ERROR: No users found. Make sure that you have entered full and correct username.");
mysql_format(connectionHandle, query, sizeof(query), "INSERT INTO `bans` VALUES (NULL, '%s', '%d', '%e')", playername, pData[playerid][RealID], reason);
mysql_query(connectionHandle, query);
SendClientMessageToAll(-1, "[IG] {A9C4E4}%s has been offline-banned from the server by %s. {00FF00}[REASON: %s]", playername, GetName(playerid), reason);
MessageAdmin(COLOR_BLUE, "%s has offline-banned %s. {00FF00}[REASON: %s]", GetName(playerid), playername, reason);
SendAdminText(playerid, "%s has offline-banned %s", GetName(playerid), playername);
WriteLog("admin.html", "%s has offline-banned %s", GetName(playerid), playername);
cache_delete(result);
return 1;
}