From d836d365d30d44c6140dda17f82b9bd245db03e9 Mon Sep 17 00:00:00 2001
From: Matthias Schmidt <gravatronics@live.com>
Date: Sun, 24 Jan 2021 13:02:22 +0100
Subject: [PATCH] Support `environment=all` for event listeners in database

See #3145
---
 com.woltlab.wcf/package.xml                   |  1 +
 .../acp/update_com.woltlab.wcf_5.3.3_db.php   | 30 +++++++++++++++++++
 wcfsetup/setup/db/install.sql                 |  2 +-
 3 files changed, 32 insertions(+), 1 deletion(-)
 create mode 100644 wcfsetup/install/files/acp/update_com.woltlab.wcf_5.3.3_db.php

diff --git a/com.woltlab.wcf/package.xml b/com.woltlab.wcf/package.xml
index 5a71c03d0a..c77c80ddb5 100644
--- a/com.woltlab.wcf/package.xml
+++ b/com.woltlab.wcf/package.xml
@@ -107,4 +107,5 @@
 	</instructions>
 	
 	<!-- Run update_com.woltlab.wcf_5.3.3_style.php for 5.3.2 -> 5.3.3 -->
+	<!-- Run update_com.woltlab.wcf_5.3.3_db.php for 5.3.2 -> 5.3.3 -->
 </package>
diff --git a/wcfsetup/install/files/acp/update_com.woltlab.wcf_5.3.3_db.php b/wcfsetup/install/files/acp/update_com.woltlab.wcf_5.3.3_db.php
new file mode 100644
index 0000000000..5e352a3b5b
--- /dev/null
+++ b/wcfsetup/install/files/acp/update_com.woltlab.wcf_5.3.3_db.php
@@ -0,0 +1,30 @@
+<?php
+
+use wcf\system\database\table\column\EnumDatabaseTableColumn;
+use wcf\system\database\table\DatabaseTableChangeProcessor;
+use wcf\system\database\table\PartialDatabaseTable;
+use wcf\system\package\plugin\ScriptPackageInstallationPlugin;
+use wcf\system\WCF;
+
+/**
+ * Updates the database table layout from WoltLab Suite Core 5.3.2 to 5.3.3.
+ *
+ * @author  Matthias Schmidt
+ * @copyright   2001-2021 WoltLab GmbH
+ * @license GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
+ */
+
+$tables = [
+    PartialDatabaseTable::create('wcf1_event_listener')
+        ->columns([
+            EnumDatabaseTableColumn::create('environment')
+                ->enumValues(['user', 'admin', 'all'])
+        ]),
+];
+
+(new DatabaseTableChangeProcessor(
+/** @var ScriptPackageInstallationPlugin $this */
+    $this->installation->getPackage(),
+    $tables,
+    WCF::getDB()->getEditor())
+)->process();
diff --git a/wcfsetup/setup/db/install.sql b/wcfsetup/setup/db/install.sql
index 98afb751b9..65663347f3 100644
--- a/wcfsetup/setup/db/install.sql
+++ b/wcfsetup/setup/db/install.sql
@@ -576,7 +576,7 @@ DROP TABLE IF EXISTS wcf1_event_listener;
 CREATE TABLE wcf1_event_listener (
 	listenerID INT(10) NOT NULL AUTO_INCREMENT PRIMARY KEY,
 	packageID INT(10) NOT NULL,
-	environment ENUM('user', 'admin') NOT NULL DEFAULT 'user',
+	environment ENUM('user', 'admin', 'all') NOT NULL DEFAULT 'user',
 	listenerName VARCHAR(191) NOT NULL,
 	eventClassName VARCHAR(255) NOT NULL DEFAULT '',
 	eventName TEXT,
-- 
2.20.1