fixed oplog query

diff --git a/cmd_neonserv_oplog.c b/cmd_neonserv_oplog.c
index 7b724839d02dd549f63c16560124ad5199063cc9..bf33f4f088a4dab6ac9630f74e464194f1712444 100644 (file)
--- 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;