From: pk910 Date: Mon, 31 Oct 2011 22:30:54 +0000 (+0100) Subject: ignore inactive bots on cmd_search X-Git-Tag: v5.3~229 X-Git-Url: http://git.pk910.de/?p=NeonServV5.git;a=commitdiff_plain;h=063d7e6254bf71edc4ea9665d5644de04b30db1e ignore inactive bots on cmd_search --- diff --git a/src/cmd_neonserv_search.c b/src/cmd_neonserv_search.c index cf30477..35128ef 100644 --- a/src/cmd_neonserv_search.c +++ b/src/cmd_neonserv_search.c @@ -115,7 +115,7 @@ CMD_BIND(neonserv_cmd_search) { reply(getTextBot(), user, "NS_SEARCH_HEADER"); MYSQL_RES *res, *res2; MYSQL_ROW row, row2; - printf_mysql_query("SELECT `channel_name`, `user_user`, `channel_registered`, `channel_nodelete`, `suspended`, `channel_id` FROM `bot_channels` LEFT JOIN `bots` ON `bots`.`id` = `botid` LEFT JOIN `channels` ON `chanid` = `channel_id` LEFT JOIN `users` ON `channel_registrator` = `user_id` WHERE `botclass` = '%d'", client->botid); + printf_mysql_query("SELECT `channel_name`, `user_user`, `channel_registered`, `channel_nodelete`, `suspended`, `channel_id` FROM `bot_channels` LEFT JOIN `bots` ON `bots`.`id` = `botid` LEFT JOIN `channels` ON `chanid` = `channel_id` LEFT JOIN `users` ON `channel_registrator` = `user_id` WHERE `botclass` = '%d' AND `active` = '1'", client->botid); res = mysql_use(); while ((row = mysql_fetch_row(res)) != NULL) { if(show_chans && matches == criteria->limit) {