From 63d685297d31745261ae9dbcca802e1664c20a7f Mon Sep 17 00:00:00 2001
From: joshuaruesweg <ruesweg@woltlab.com>
Date: Sat, 13 Jun 2020 16:57:51 +0200
Subject: [PATCH] Add update script

---
 ...e_com.woltlab.wcf_5.3_emailConfirmation.php | 18 ++++++++++++++++++
 1 file changed, 18 insertions(+)
 create mode 100644 wcfsetup/install/files/acp/update_com.woltlab.wcf_5.3_emailConfirmation.php

diff --git a/wcfsetup/install/files/acp/update_com.woltlab.wcf_5.3_emailConfirmation.php b/wcfsetup/install/files/acp/update_com.woltlab.wcf_5.3_emailConfirmation.php
new file mode 100644
index 0000000000..4ad2593c0d
--- /dev/null
+++ b/wcfsetup/install/files/acp/update_com.woltlab.wcf_5.3_emailConfirmation.php
@@ -0,0 +1,18 @@
+<?php
+use wcf\system\WCF;
+
+/**
+ * @author	Joshua Ruesweg
+ * @copyright	2001-2019 WoltLab GmbH
+ * @license	GNU Lesser General Public License <http://opensource.org/licenses/lgpl-license.php>
+ * @package	WoltLabSuite\Core
+ */
+
+// HEADS UP: This script must be executed, AFTER the SQL tables are changed. 
+
+$sql = "UPDATE  wcf". WCF_N ."_user 
+	SET     emailConfirmed = activationCode
+	WHERE   activationCode <> 0";
+
+$statement = WCF::getDB()->prepareStatement($sql);
+$statement->execute();
-- 
2.20.1