+
+/*
+* argv[0] nick|*auth|*!*@mask
+*/
+
+static CMD_BIND(neonserv_cmd_delban) {
+ char hostmask_buffer[NICKLEN+USERLEN+HOSTLEN+3];
+ check_mysql();
+ char *mask = make_banmask(argv[0], hostmask_buffer);
+ int matching_bans = 0;
+ MYSQL_RES *res;
+ MYSQL_ROW row;
+ //check if the provided mask is already banned by another ban
+ char *ban = getBanAffectingMask(chan, mask);
+ if(ban != NULL) {
+ reply(getTextBot(), user, "NS_DELBAN_BANNED_BY", mask, ban);
+ return;
+ }
+ //check if the provided mask affects any existing bans
+ printf_mysql_query("SELECT `ban_mask`, `ban_id` FROM `bans` WHERE `ban_channel` = '%d'", chan->channel_id);
+ res = mysql_use();
+ while ((row = mysql_fetch_row(res)) != NULL) {
+ if(!match(mask, row[0])) {
+ //remove the ban
+ printf_mysql_query("DELETE FROM `bans` WHERE `ban_id` = '%s'", row[1]);
+ matching_bans++;
+ }
+ }
+ if(matching_bans) {
+ putsock(client, "MODE %s -b %s", chan->name, mask);
+ reply(getTextBot(), user, "NS_DELBAN_DONE", mask, chan->name);
+ } else
+ reply(getTextBot(), user, "NS_DELBAN_FAIL", mask);
+}