From 0f9fe8dbeb3990175cfac07a3b7349c9d8e668b7 Mon Sep 17 00:00:00 2001 From: Shauren Date: Thu, 2 Sep 2010 10:40:32 +0200 Subject: Core/Players: Don't set instanceId to 0 when player is on transport during loading, there CAN be transports inside instances Core/Scripts: Added waypoint id to OnRelocate transport hook Core/Scripts: Make use of ZoneScript::GetGameObjectEntry at gameobject creation (makes it possible to override gameobject entries in instances) Core/Transports: Call InstanceScript::EventInform for transport events Core/Transports: Use guid from db for transports, not just its entry - adds partial support for instancing them (still cannot use transports table for it, but can spawn manually now) Scripts/Icecrown Citadel: Fixed crash in Deathbringer Saurfang when event is started by more than one person (can't do this anymore) Closes isssue #3749. --HG-- branch : trunk --- sql/updates/9760_world_transports.sql | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 sql/updates/9760_world_transports.sql (limited to 'sql/updates') diff --git a/sql/updates/9760_world_transports.sql b/sql/updates/9760_world_transports.sql new file mode 100644 index 00000000000..bed2528adfb --- /dev/null +++ b/sql/updates/9760_world_transports.sql @@ -0,0 +1,6 @@ +ALTER TABLE `transports` + ADD COLUMN `guid` int(10) UNSIGNED NOT NULL AUTO_INCREMENT FIRST, + MODIFY COLUMN `entry` mediumint(8) unsigned NOT NULL DEFAULT '0' AFTER `guid`, + DROP PRIMARY KEY, + ADD PRIMARY KEY (`guid`), + ADD UNIQUE INDEX `idx_entry` (`entry`); -- cgit v1.2.3