From 00c3252a1d66bc1b4bc46b80901c0540a37e1dce Mon Sep 17 00:00:00 2001
From: Marcel Werk <burntime@woltlab.com>
Date: Thu, 30 Jul 2020 18:03:14 +0200
Subject: [PATCH] New method that will ignore duplicate key errors while
 inserting rows into the database

---
 .../lib/data/DatabaseObjectEditor.class.php   | 22 +++++++++++++++++++
 1 file changed, 22 insertions(+)

diff --git a/wcfsetup/install/files/lib/data/DatabaseObjectEditor.class.php b/wcfsetup/install/files/lib/data/DatabaseObjectEditor.class.php
index 19cea93519..1126fae67d 100644
--- a/wcfsetup/install/files/lib/data/DatabaseObjectEditor.class.php
+++ b/wcfsetup/install/files/lib/data/DatabaseObjectEditor.class.php
@@ -1,5 +1,6 @@
 <?php
 namespace wcf\data;
+use wcf\system\database\exception\DatabaseQueryExecutionException;
 use wcf\system\database\util\PreparedStatementConditionBuilder;
 use wcf\system\WCF;
 
@@ -123,4 +124,25 @@ abstract class DatabaseObjectEditor extends DatabaseObjectDecorator implements I
 		
 		return $affectedCount;
 	}
+	
+	/**
+	 * Creates a new object, returns null if the row already exists.
+	 *
+	 * @param	array	$parameters
+	 * @return	IStorableObject|null
+	 * @since       5.3
+	 */
+	public static function createOrIgnore(array $parameters = []) {
+		try {
+			return static::create($parameters);
+		}
+		catch (DatabaseQueryExecutionException $e) {
+			// Error code 23000 = duplicate key
+			if ($e->getCode() == '23000') {
+				return null;
+			}
+			
+			throw $e;
+		}
+	}
 }
-- 
2.20.1