[eventlog] Add event filtering and notification system

1 files changed, 35 insertions, 0 deletions

diff --git a/inc/database.inc.php b/inc/database.inc.php
index a55555b4..09006f3e 100644
--- a/inc/database.inc.php
+++ b/inc/database.inc.php
@@ -100,6 +100,41 @@ class Database
 	}
 
 	/**
+	 * Fetch and group by first column. First column is key, value is a list of rows with remaining columns.
+	 * [
+	 *    col1 => [
+	 *       [col2, col3],
+	 *       [col2, col3],
+	 *    ],
+	 *    ...,
+	 * ]
+	 *
+	 * @return array|bool Associative array, first column is key, remaining columns are array values
+	 */
+	public static function queryGroupList($query, $args = array(), $ignoreError = null)
+	{
+		$res = self::simpleQuery($query, $args, $ignoreError);
+		if ($res === false)
+			return false;
+		return $res->fetchAll(PDO::FETCH_GROUP);
+	}
+
+	/**
+	 * Fetch and use first column as key of returned array.
+	 * This is like queryGroup list, but it is assumed that the first column is unique, so
+	 * the remaining columns won't be wrapped in another array.
+	 *
+	 * @return array|bool Associative array, first column is key, remaining columns are array values
+	 */
+	public static function queryIndexedList($query, $args = array(), $ignoreError = null)
+	{
+		$res = self::simpleQuery($query, $args, $ignoreError);
+		if ($res === false)
+			return false;
+		return $res->fetchAll(PDO::FETCH_GROUP | PDO::FETCH_UNIQUE);
+	}
+
+	/**
 	 * Execute the given query and return the number of rows affected.
 	 * Mostly useful for UPDATEs or INSERTs
 	 *