diff options
| author | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-03-23 10:17:09 +0100 |
|---|---|---|
| committer | ZxBiohazardZx <zxbiohazardzx@gmail.com> | 2011-03-23 10:17:09 +0100 |
| commit | 3ea0f931699ed0d831866608d8294a665c848a1e (patch) | |
| tree | 1cac84a02092a9daab62fb93fce2ad055ad3694a | |
| parent | 96a7d6aa9d4682b4e999185b3a3e91ef0fbf19c3 (diff) | |
DB/Quest: Call of Water (9504) temp-spawn for quest
Commit: comment out 2011_03_23_5 as it was using outdated table
fixes #1023
| -rw-r--r-- | sql/updates/world/2011_03_23_5_world_season_linked_event.sql | 3 | ||||
| -rw-r--r-- | sql/updates/world/2011_03_23_gameobject_template.sql | 13 |
2 files changed, 15 insertions, 1 deletions
diff --git a/sql/updates/world/2011_03_23_5_world_season_linked_event.sql b/sql/updates/world/2011_03_23_5_world_season_linked_event.sql index 46c539928bb..611977140ce 100644 --- a/sql/updates/world/2011_03_23_5_world_season_linked_event.sql +++ b/sql/updates/world/2011_03_23_5_world_season_linked_event.sql @@ -1,2 +1,3 @@ -- Delete wrongly assigned season linked events -DELETE FROM `season_linked_event` WHERE `event` IN (124,125); +-- DELETE FROM `season_linked_event` WHERE `event` IN (124,125); +-- OUTDATED FIX, SORRY diff --git a/sql/updates/world/2011_03_23_gameobject_template.sql b/sql/updates/world/2011_03_23_gameobject_template.sql new file mode 100644 index 00000000000..960f1a0442e --- /dev/null +++ b/sql/updates/world/2011_03_23_gameobject_template.sql @@ -0,0 +1,13 @@ +DELETE FROM `gameobject_template` WHERE `entry`=300149; +INSERT INTO gameobject_template + (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) +VALUES +(300149,8,1287, 'TEMP Wrathscale Lair Fountain', '', '', '',0,0,1,0,0,0,0,0,0,223,5,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0, '', '',1); + +-- NEEDS VISUAL (apart form Ruins of Stardust, its MISSING!) +DELETE FROM `gameobject` WHERE `id`=300149 +INSERT INTO gameobject + (`guid`,`id`,`map`,`spawnMask`,`phaseMask`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`) +VALUES +(1160,300149,530,1,1,-2186.4,-12340.5,56.2888,5.31,0,0,0.121294,-0.992617,-300,0,1); + |