From e98233e2ef46d95645e461f5a5735215d1eb0dbf Mon Sep 17 00:00:00 2001 From: pk910 Date: Sat, 24 Sep 2011 02:57:19 +0200 Subject: [PATCH] fixed oplog query --- cmd_neonserv_oplog.c | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/cmd_neonserv_oplog.c b/cmd_neonserv_oplog.c index 7b72483..bf33f4f 100644 --- a/cmd_neonserv_oplog.c +++ b/cmd_neonserv_oplog.c @@ -13,7 +13,7 @@ static CMD_BIND(neonserv_cmd_oplog) { str_match = "*"; MYSQL_RES *res; MYSQL_ROW row; - printf_mysql_query("SELECT `godlog_time`, `user_user`, `channel_channel`, `godlog_cmd` FROM `godlog` LEFT JOIN `channels` ON `godlog_cid` = `channel_id` LEFT JOIN `users` ON `godlog_uid` = `user_id` WHERE `godlog_time` > '%lu' ORDER BY `godlog_time` ASC", ((unsigned long) time(0) - duration)); + printf_mysql_query("SELECT `godlog_time`, `user_user`, `channel_name`, `godlog_cmd` FROM `godlog` LEFT JOIN `channels` ON `godlog_cid` = `channel_id` LEFT JOIN `users` ON `godlog_uid` = `user_id` WHERE `godlog_time` > '%lu' ORDER BY `godlog_time` ASC", ((unsigned long) time(0) - duration)); res = mysql_use(); int skip = mysql_num_rows(res) - 100; int count = 0; -- 2.20.1