From be1bb5fbeb2cb93105b12cc9d9b4cae676f59a7f Mon Sep 17 00:00:00 2001 From: Felix Favre Date: Mon, 15 Dec 2014 21:23:57 +0100 Subject: add simple search to log view --- includes/model/LogEntries_model.php | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) (limited to 'includes/model/LogEntries_model.php') diff --git a/includes/model/LogEntries_model.php b/includes/model/LogEntries_model.php index 49e063dc..2e8a8cf7 100644 --- a/includes/model/LogEntries_model.php +++ b/includes/model/LogEntries_model.php @@ -18,4 +18,11 @@ function LogEntries() { return sql_select("SELECT * FROM `LogEntries` ORDER BY `timestamp` DESC LIMIT 10000"); } -?> \ No newline at end of file +/** + * Returns log entries filtered by a keyword + */ +function LogEntries_filter($keyword) { + return sql_select("SELECT * FROM `LogEntries` WHERE `nick` LIKE '%" . sql_escape($keyword) . "%' OR `message` LIKE '%" . sql_escape($keyword) . "%' ORDER BY `timestamp` DESC"); +} + +?> -- cgit v1.2.3-54-g00ecf