fixed cmd_move (remove existing channels first)

diff --git a/src/cmd_neonserv_move.c b/src/cmd_neonserv_move.c
index 197bd6583a9b676640804bba647cb4ba1e96ad38..c837d797a7d14d3c956002bb41ddd50127397164 100644 (file)
--- 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) {