1 /* cmd_neonserv_events.c - NeonServ v5.3
2 * Copyright (C) 2011-2012 Philipp Kreil (pk910)
4 * This program is free software: you can redistribute it and/or modify
5 * it under the terms of the GNU General Public License as published by
6 * the Free Software Foundation, either version 3 of the License, or
7 * (at your option) any later version.
9 * This program is distributed in the hope that it will be useful,
10 * but WITHOUT ANY WARRANTY; without even the implied warranty of
11 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
12 * GNU General Public License for more details.
14 * You should have received a copy of the GNU General Public License
15 * along with this program. If not, see <http://www.gnu.org/licenses/>.
18 #include "cmd_neonserv.h"
25 CMD_BIND(neonserv_cmd_events) {
27 int duration = (argc ? strToTime(user, argv[0]) : 0);
28 if(argc > (duration ? 1 : 0))
29 str_match = merge_argv(argv, (duration ? 1 : 0), argc);
32 if(!duration) duration = (60*60*24);
35 printf_mysql_query("SELECT `time`, `auth`, `nick`, `command` FROM `events` WHERE `cid` = '%d' AND `time` > '%lu' ORDER BY `time` ASC", chan->channel_id, ((unsigned long) time(0) - duration));
37 int skip = mysql_num_rows(res) - 100;
42 if(skip < 0) skip = 0;
43 reply(getTextBot(), user, "NS_EVENTS_HEADER");
44 while ((row = mysql_fetch_row(res)) != NULL) {
49 if(*str_match && match(str_match, row[3])) continue;
51 event_time = (time_t) atol(row[0]);
52 timeinfo = localtime(&event_time);
53 strftime(timeBuf, 80, "%X %x", timeinfo);
54 reply(getTextBot(), user, "[%s] [%s:%s]: %s", timeBuf, row[2], row[1], row[3]);
56 reply(getTextBot(), user, "NS_TABLE_COUNT", count);