[inc/Database] Convert bool params to 1 or 0

PDO unfortunately only does (string)<bool> for boolean params, which
converts false to '' instead of '0'. This breaks MariaDB in strict mode.

1 files changed, 9 insertions, 0 deletions

diff --git a/inc/database.inc.php b/inc/database.inc.php
index 3b2414b5..7d9cbce3 100644
--- a/inc/database.inc.php
+++ b/inc/database.inc.php
@@ -141,6 +141,15 @@ class Database
 		// Support passing nested arrays for IN statements, automagically refactor
 		$oquery = $query;
 		self::handleArrayArgument($query, $args);
+		// Now turn any bools into 0 or 1, since PDO unfortunately only does (string)<bool>, which
+		// results in an empty string for false
+		foreach ($args as &$arg) {
+			if ($arg === false) {
+				$arg = '0';
+			} elseif ($arg === true) {
+				$arg = '1';
+			}
+		}
 		try {
 			if (!isset(self::$statements[$query])) {
 				self::$statements[$query] = self::$dbh->prepare($query);