Core/Items: implement reforging items

4 files changed, 33 insertions, 1 deletions

diff --git a/sql/base/characters_database.sql b/sql/base/characters_database.sql
index 13c47a14fdf..02bb7a2153f 100644
--- a/sql/base/characters_database.sql
+++ b/sql/base/characters_database.sql
@@ -2689,6 +2689,7 @@ CREATE TABLE `item_instance_modifiers` (
   `itemGuid` bigint unsigned NOT NULL,
   `fixedScalingLevel` int unsigned DEFAULT '0',
   `artifactKnowledgeLevel` int unsigned DEFAULT '0',
+  `itemReforgeId` int unsigned DEFAULT '0',
   PRIMARY KEY (`itemGuid`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
 /*!40101 SET character_set_client = @saved_cs_client */;
@@ -3477,7 +3478,8 @@ INSERT INTO `updates` VALUES
 ('2024_03_13_00_characters.sql','6360F50059E5DB1F248FA8A270CDC4788A03A0EC','RELEASED','2024-03-13 17:10:46',0),
 ('2024_03_19_00_characters.sql','1D200630578074A4E3A373F891323DB867D00B02','RELEASED','2024-03-19 19:59:26',0),
 ('2024_04_09_00_characters.sql','07AC79B4E489B1CD073852EC57D12939C2A1D4B1','RELEASED','2024-04-09 12:54:11',0),
-('2024_04_12_00_characters.sql','043E023F998DA77170C9D2D0162CAA340290B215','RELEASED','2024-04-12 00:23:51',0);
+('2024_04_12_00_characters.sql','043E023F998DA77170C9D2D0162CAA340290B215','RELEASED','2024-04-12 00:23:51',0),
+('2024_06_01_00_characters.sql','0440E0A8BE109101B390A640397D9B024C8E124B','RELEASED','2024-06-01 19:29:34',0);
 /*!40000 ALTER TABLE `updates` ENABLE KEYS */;
 UNLOCK TABLES;
 
diff --git a/sql/updates/characters/cata_classic/2024_06_01_00_characters.sql b/sql/updates/characters/cata_classic/2024_06_01_00_characters.sql
new file mode 100644
index 00000000000..143e3e1e620
--- /dev/null
+++ b/sql/updates/characters/cata_classic/2024_06_01_00_characters.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `item_instance_modifiers` 
+ADD COLUMN `itemReforgeId` int UNSIGNED NULL DEFAULT 0 AFTER `artifactKnowledgeLevel`;
diff --git a/sql/updates/hotfixes/cata_classic/2024_06_01_00_hotfixes.sql b/sql/updates/hotfixes/cata_classic/2024_06_01_00_hotfixes.sql
new file mode 100644
index 00000000000..504dea84a37
--- /dev/null
+++ b/sql/updates/hotfixes/cata_classic/2024_06_01_00_hotfixes.sql
@@ -0,0 +1,27 @@
+--
+-- Table structure for table `item_reforge`
+--
+
+DROP TABLE IF EXISTS `item_reforge`;
+/*!40101 SET @saved_cs_client     = @@character_set_client */;
+/*!50503 SET character_set_client = utf8mb4 */;
+CREATE TABLE `item_reforge` (
+  `ID` int(10) unsigned NOT NULL DEFAULT '0',
+  `SourceStat` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `SourceMultiplier` float NOT NULL DEFAULT '0',
+  `TargetStat` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `TargetMultiplier` float NOT NULL DEFAULT '0',
+  `LegacyItemReforgeID` smallint(5) unsigned NOT NULL DEFAULT '0',
+  `VerifiedBuild` int(11) NOT NULL DEFAULT '0',
+  PRIMARY KEY (`ID`,`VerifiedBuild`)
+) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `item_reforge`
+--
+
+LOCK TABLES `item_reforge` WRITE;
+/*!40000 ALTER TABLE `item_reforge` DISABLE KEYS */;
+/*!40000 ALTER TABLE `item_reforge` ENABLE KEYS */;
+UNLOCK TABLES;
diff --git a/sql/updates/world/cata_classic/2024_06_01_00_world.sql b/sql/updates/world/cata_classic/2024_06_01_00_world.sql
new file mode 100644
index 00000000000..cc92a1149be
--- /dev/null
+++ b/sql/updates/world/cata_classic/2024_06_01_00_world.sql
@@ -0,0 +1 @@
+UPDATE `creature_template` SET `npcflag`= (0x00400000 << 32) WHERE `entry` IN (54441, 54471);