From 9f01ca7c6136234eb82c5598394b328e1ba64d71 Mon Sep 17 00:00:00 2001 From: pk910 Date: Thu, 26 Jul 2012 17:20:13 +0200 Subject: [PATCH] added output limit for cmd_history --- src/modules/NeonHelp.mod/cmd_neonhelp_history.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/src/modules/NeonHelp.mod/cmd_neonhelp_history.c b/src/modules/NeonHelp.mod/cmd_neonhelp_history.c index 2378d5a..208418a 100644 --- a/src/modules/NeonHelp.mod/cmd_neonhelp_history.c +++ b/src/modules/NeonHelp.mod/cmd_neonhelp_history.c @@ -58,7 +58,7 @@ CMD_BIND(neonhelp_cmd_history) { } struct Table *table; char *match_str = escape_string(argv[0]); - printf_mysql_query("SELECT `id`, `nick`, `hand`, `host`, `time`, `text`, `status`, `supporter`, `users`.`user_user`, MD5(CONCAT(`id`, `host`, `time`, `supporter`)) FROM `helpserv_requests` LEFT JOIN `users` ON `supporter` = `user_id` WHERE `botid` = '%d' AND (`host` LIKE '%%%s%%' OR `hand` LIKE '%%%s%%' OR `nick` LIKE '%%%s%%') ORDER BY `time` ASC", client->clientid, match_str, match_str, match_str); + printf_mysql_query("SELECT `id`, `nick`, `hand`, `host`, `time`, `text`, `status`, `supporter`, `users`.`user_user`, MD5(CONCAT(`id`, `host`, `time`, `supporter`)) FROM `helpserv_requests` LEFT JOIN `users` ON `supporter` = `user_id` WHERE `botid` = '%d' AND (`host` LIKE '%%%s%%' OR `hand` LIKE '%%%s%%' OR `nick` LIKE '%%%s%%') ORDER BY `time` ASC LIMIT 100", client->clientid, match_str, match_str, match_str); res = mysql_use(); table = table_init(6, mysql_num_rows(res)*3 + 1, 0); table->col_flags[1] |= TABLE_FLAG_COL_SKIP_NULL; -- 2.20.1