From 8fa1f2744c7dcb508e84aedab13b5c3c60b35255 Mon Sep 17 00:00:00 2001 From: pk910 Date: Mon, 31 Oct 2011 22:42:47 +0100 Subject: [PATCH] fixed cmd_search mysql query --- src/cmd_neonserv_search.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/cmd_neonserv_search.c b/src/cmd_neonserv_search.c index eaac114..cf30477 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 `channels` ON `chanid` = `channel_id` LEFT JOIN `users` ON `channel_registrator` = `user_id` WHERE `botid` = '%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'", client->botid); res = mysql_use(); while ((row = mysql_fetch_row(res)) != NULL) { if(show_chans && matches == criteria->limit) { -- 2.20.1