diff options
| author | Seyden <saiifii@live.de> | 2022-12-27 16:39:05 +0100 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2024-10-05 17:25:07 +0200 |
| commit | 78fe841adb81e3fd1b5bc5f14b1d023d3125d9bb (patch) | |
| tree | 557625564f1d72c892823ede1e27538df1cc1a59 /sql | |
| parent | da7367208ca5967ee48310643243cdd66f36f248 (diff) | |
Core/Creatures: Implement StringId for Creatures, a custom identifier to make finding specific creatures in script easier (#28500)
Allows targeting specific spawns without hardcoding guids or find a bunch of different creatures with a single search
Co-authored-by: Shauren <shauren.trinity@gmail.com>
(cherry picked from commit 61c51b76c00d932a9180bc6781a244dc18375ef7)
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/3.3.5/2024_10_05_00_world_2022_12_27_01_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/3.3.5/2024_10_05_00_world_2022_12_27_01_world.sql b/sql/updates/world/3.3.5/2024_10_05_00_world_2022_12_27_01_world.sql new file mode 100644 index 00000000000..5e0f6fd45c8 --- /dev/null +++ b/sql/updates/world/3.3.5/2024_10_05_00_world_2022_12_27_01_world.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `trinity_string` WHERE `entry`=5089; +INSERT INTO `trinity_string` (`entry`,`content_default`) VALUES +(5089,'Template StringID: %.*s\Spawn StringID: %.*s\nScript StringID: %.*s'); + +ALTER TABLE `creature` ADD `StringId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER ScriptName; + +ALTER TABLE `creature_template` ADD `StringId` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL AFTER ScriptName; |