diff options
6 files changed, 18 insertions, 11 deletions
diff --git a/sql/updates/world/2011_03_23_10_world_gameobject.sql b/sql/updates/world/2011_03_23_10_world_gameobject.sql new file mode 100644 index 00000000000..aa44b110caa --- /dev/null +++ b/sql/updates/world/2011_03_23_10_world_gameobject.sql @@ -0,0 +1,3 @@ +-- Delete uneed made up GO template +UPDATE `gameobject` SET `id`=202275 WHERE `id`=300149; -- TEMP Wrathscale Lair Fountain -> Wrathscale Fountain +DELETE FROM `gameobject_template` WHERE `entry`=300149; diff --git a/sql/updates/world/2011_03_23_11_world_game_event_arena_seasons.sql b/sql/updates/world/2011_03_23_11_world_game_event_arena_seasons.sql new file mode 100644 index 00000000000..ee7a545a67e --- /dev/null +++ b/sql/updates/world/2011_03_23_11_world_game_event_arena_seasons.sql @@ -0,0 +1,3 @@ +-- Delete wrongly assigned Arena Seasons game events +DELETE FROM `game_event_arena_seasons` WHERE `eventEntry`=53 AND `season`=1; -- Call to Arms: Strand of the Ancients! +DELETE FROM `game_event_arena_seasons` WHERE `eventEntry`=54 AND `season`=2; -- Call to Arms: Isle of Conquest! diff --git a/sql/updates/world/2011_03_23_12_world_misc.sql b/sql/updates/world/2011_03_23_12_world_misc.sql new file mode 100644 index 00000000000..115e3da6ca4 --- /dev/null +++ b/sql/updates/world/2011_03_23_12_world_misc.sql @@ -0,0 +1,9 @@ +-- DB Startup errors +DELETE FROM `conditions` WHERE `SourceEntry`=43151 AND `SourceTypeOrReferenceId`=13; -- Delete uneed/wrong conditions. Assigned SAI will take care of targeting the right creature +UPDATE `pool_creature` SET `chance`=0 WHERE `pool_entry`=1079; -- 3 creatures, 33.3333..% (repeating, of course) chance; there is no need to hardcode the value +-- Delete wrong equip template and revert the one that shouldn't have been changed +UPDATE `creature_template` SET `equipment_id`=2431 WHERE `entry`=18697; +DELETE FROM `creature_equip_template` WHERE `entry` IN (1807,2431); +INSERT INTO `creature_equip_template` (`entry`,`equipentry1`,`equipentry2`,`equipentry3`) VALUES +(1807,50757,0,0), +(2431,31301,0,0); 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 deleted file mode 100644 index 611977140ce..00000000000 --- a/sql/updates/world/2011_03_23_5_world_season_linked_event.sql +++ /dev/null @@ -1,3 +0,0 @@ --- Delete wrongly assigned season linked events --- DELETE FROM `season_linked_event` WHERE `event` IN (124,125); --- OUTDATED FIX, SORRY diff --git a/sql/updates/world/2011_03_23_7_world_creatureinvolvedrelation.sql b/sql/updates/world/2011_03_23_7_world_creatureinvolvedrelation.sql index 1c1a5c195ff..1a8e09c0727 100644 --- a/sql/updates/world/2011_03_23_7_world_creatureinvolvedrelation.sql +++ b/sql/updates/world/2011_03_23_7_world_creatureinvolvedrelation.sql @@ -1,4 +1,4 @@ --- Battle to Undercity should be turned in to Bragor Bloodfirst +-- Battle to Undercity should be turned in to Bragor Bloodfist DELETE FROM `creature_involvedrelation` WHERE `quest` IN (14351,550); DELETE FROM `creature_questrelation` WHERE `quest` IN (14351,550); INSERT INTO `creature_involvedrelation` (`id`,`quest`) VALUES (36273,14351); diff --git a/sql/updates/world/2011_03_23_8_world_gameobject_template.sql b/sql/updates/world/2011_03_23_8_world_gameobject_template.sql index 40093da5955..8db2ac8f117 100644 --- a/sql/updates/world/2011_03_23_8_world_gameobject_template.sql +++ b/sql/updates/world/2011_03_23_8_world_gameobject_template.sql @@ -1,13 +1,8 @@ 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 +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 +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); - |