From 0ae268bf40e98b598db9d62ea9cf52b7513d1fd9 Mon Sep 17 00:00:00 2001 From: pk910 Date: Sun, 23 Oct 2011 21:35:13 +0200 Subject: [PATCH] fixed cmd_move (remove existing channels first) --- src/cmd_neonserv_move.c | 12 +++++++++++- 1 file changed, 11 insertions(+), 1 deletion(-) diff --git a/src/cmd_neonserv_move.c b/src/cmd_neonserv_move.c index 197bd65..c837d79 100644 --- a/src/cmd_neonserv_move.c +++ b/src/cmd_neonserv_move.c @@ -69,7 +69,17 @@ CMD_BIND(neonserv_cmd_move) { putsock(bot, "PART %s :Channel moved to %s.", channel, new_channel); putsock(bot, "JOIN %s", new_channel); } - printf_mysql_query("DELETE FROM `channels` WHERE `channel_name` = '%s'", escape_string(new_channel)); + printf_mysql_query("SELECT `channel_id` FROM `channels` WHERE `channel_name` = '%s'", escape_string(new_channel)); + res = mysql_use(); + if ((row = mysql_fetch_row(res)) != NULL) { + chanid = atoi(row[0]); + printf_mysql_query("DELETE FROM `chanusers` WHERE `chanuser_cid` = '%d'", chanid); + printf_mysql_query("DELETE FROM `bans` WHERE `ban_channel` = '%d'", chanid); + printf_mysql_query("DELETE FROM `events` WHERE `cid` = '%d'", chanid); + printf_mysql_query("DELETE FROM `noinvite` WHERE `cid` = '%d'", chanid); + printf_mysql_query("DELETE FROM `owner_history` WHERE `owner_history_cid` = '%d'", chanid); + printf_mysql_query("DELETE FROM `channels` WHERE `channel_id` = '%d'", chanid); + } printf_mysql_query("UPDATE `channels` SET `channel_name` = '%s' WHERE `channel_id` = '%s'", escape_string(new_channel), row[1]); struct ChanNode *channode = getChanByName(channel); if(channode && channode->flags & CHANFLAG_REQUESTED_CHANINFO) { -- 2.20.1