diff options
| author | Ovahlord <dreadkiller@gmx.de> | 2024-06-01 17:45:20 +0200 |
|---|---|---|
| committer | Ovahlord <dreadkiller@gmx.de> | 2024-06-01 19:32:24 +0200 |
| commit | 57c36d758fabadd0385cde75b5b6abdcd8c493dd (patch) | |
| tree | 5a9ef5b1822347cda950fc2c1cf9e0d900c8c769 /sql/updates | |
| parent | d4c36db8aca9b3da8c589ac313c230763687f171 (diff) | |
Core/Items: implement reforging items
Diffstat (limited to 'sql/updates')
3 files changed, 30 insertions, 0 deletions
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); |