X-Git-Url: http://git.pk910.de/?a=blobdiff_plain;f=src%2Fmodules%2FNeonHelp.mod%2Fcmd_neonhelp_history.c;h=72d81f6600b2bb681ea33af508f4487576f2675b;hb=fc61be208ca6dbf2fd915591c8dc7e5ef5779891;hp=2378d5a7be336e7133ec2566620947b46731215d;hpb=b3e84a339e7a4c777209b0bbceaca40bb71a2594;p=NeonServV5.git diff --git a/src/modules/NeonHelp.mod/cmd_neonhelp_history.c b/src/modules/NeonHelp.mod/cmd_neonhelp_history.c index 2378d5a..72d81f6 100644 --- a/src/modules/NeonHelp.mod/cmd_neonhelp_history.c +++ b/src/modules/NeonHelp.mod/cmd_neonhelp_history.c @@ -1,4 +1,4 @@ -/* cmd_neonhelp_history.c - NeonServ v5.4 +/* cmd_neonhelp_history.c - NeonServ v5.6 * Copyright (C) 2011-2012 Philipp Kreil (pk910) * * This program is free software: you can redistribute it and/or modify @@ -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;