fixed cmd_search mysql query

diff --git a/src/cmd_neonserv_search.c b/src/cmd_neonserv_search.c
index eaac114711dd58eaa4e24251cabcb632d07cb9ba..cf304779d3c1902ab5064cc84b2cf8b7263429d1 100644 (file)
--- 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) {