From 0e5f82db7c29681080600b47acaf3cce715ed7c1 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Wed, 21 Mar 2018 11:11:11 +0100
Subject: [inc/*] Suppress warning, don't close statements

---
 inc/database.inc.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'inc/database.inc.php')

diff --git a/inc/database.inc.php b/inc/database.inc.php
index 082b13b6..d5992795 100644
--- a/inc/database.inc.php
+++ b/inc/database.inc.php
@@ -132,7 +132,7 @@ class Database
 			if (!isset(self::$statements[$query])) {
 				self::$statements[$query] = self::$dbh->prepare($query);
 			} else {
-				self::$statements[$query]->closeCursor();
+				//self::$statements[$query]->closeCursor();
 			}
 			$start = microtime(true);
 			if (self::$statements[$query]->execute($args) === false) {
-- 
cgit v1.2.3-55-g7522


From 6c7a5ff06159c6908a47f11adbe30e2349a5fd75 Mon Sep 17 00:00:00 2001
From: Simon Rettberg
Date: Tue, 12 Jun 2018 17:13:37 +0200
Subject: [inc/Database] Method to return single-column queries as array

---
 inc/database.inc.php | 13 +++++++++++++
 1 file changed, 13 insertions(+)

(limited to 'inc/database.inc.php')

diff --git a/inc/database.inc.php b/inc/database.inc.php
index d5992795..3b2414b5 100644
--- a/inc/database.inc.php
+++ b/inc/database.inc.php
@@ -76,6 +76,19 @@ class Database
 		return $res->fetchAll(PDO::FETCH_ASSOC);
 	}
 
+	/**
+	 * Fetch the first column of the query as a plain list-of-values array.
+	 *
+	 * @return array|bool List of values representing first column of query
+	 */
+	public static function queryColumnArray($query, $args = array(), $ignoreError = null)
+	{
+		$res = self::simpleQuery($query, $args, $ignoreError);
+		if ($res === false)
+			return false;
+		return $res->fetchAll(PDO::FETCH_COLUMN, 0);
+	}
+
 	/**
 	 * Execute the given query and return the number of rows affected.
 	 * Mostly useful for UPDATEs or INSERTs
-- 
cgit v1.2.3-55-g7522