diff options
| author | Seyden <saiifii@live.de> | 2022-12-27 16:39:05 +0100 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2022-12-27 16:39:05 +0100 |
| commit | 61c51b76c00d932a9180bc6781a244dc18375ef7 (patch) | |
| tree | 291da8d7ade7f1eb9663007550c84936a51f21d3 /sql | |
| parent | 8e6842b8b6c12a1a7537909ceea386a215250b89 (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>
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/updates/world/master/2022_12_27_01_world.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/sql/updates/world/master/2022_12_27_01_world.sql b/sql/updates/world/master/2022_12_27_01_world.sql new file mode 100644 index 00000000000..5e0f6fd45c8 --- /dev/null +++ b/sql/updates/world/master/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; |