5 static CMD_BIND(neonserv_cmd_cunsuspend) {
8 char *channel = argv[0];
9 if(!is_valid_chan(channel)) {
10 reply(getTextBot(), user, "NS_INVALID_CHANNEL_NAME", argv[0]);
14 printf_mysql_query("SELECT `channel_id` FROM `channels` WHERE `channel_name` = '%s'", escape_string(channel));
16 if ((row = mysql_fetch_row(res)) != NULL) {
17 chanid = atoi(row[0]);
19 reply(getTextBot(), user, "NS_UNREGISTER_NOT_REGISTERED", argv[0], client->user->nick);
22 printf_mysql_query("SELECT `botid`, `bot_channels`.`id`, `suspended` FROM `bot_channels` LEFT JOIN `bots` ON `bot_channels`.`botid` = `bots`.`id` WHERE `chanid` = '%d' AND `botclass` = '%d'", chanid, client->botid);
24 if ((row = mysql_fetch_row(res)) == NULL) {
25 reply(getTextBot(), user, "NS_UNREGISTER_NOT_REGISTERED", argv[0], client->user->nick);
28 if(!strcmp(row[2], "0")) {
29 reply(getTextBot(), user, "NS_CUNSUSPEND_NOT", channel);
32 int botid = atoi(row[0]);
33 struct ClientSocket *bot;
34 for(bot = getBots(SOCKET_FLAG_READY, NULL); bot; bot = getBots(SOCKET_FLAG_READY, bot)) {
35 if(bot->clientid == botid)
39 putsock(bot, "JOIN %s", channel);
41 printf_mysql_query("UPDATE `bot_channels` SET `suspended` = '0' WHERE `id` = '%s'", row[1]);
42 reply(getTextBot(), user, "NS_CUNSUSPEND_DONE", channel);