X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;f=src%2Fcmd_neonserv_search.c;h=cf304779d3c1902ab5064cc84b2cf8b7263429d1;hb=8fa1f2744c7dcb508e84aedab13b5c3c60b35255;hp=eaac114711dd58eaa4e24251cabcb632d07cb9ba;hpb=1e6c411bec962febb5c69dd4e2f224604fd5648a;p=NeonServV5.git

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) {