From f81cfca7bd5583cef0254920e3fae234d0789e69 Mon Sep 17 00:00:00 2001 From: Nay Date: Mon, 7 Feb 2011 21:52:14 +0000 Subject: SQL: Any content SQL should be able to be re-imported without errors; Fix an import error in world_scripts_full; P.S Full DB will be available soon Closes #586 --- sql/updates/world/2011_02_03_3_world_spell_dbc.sql | 1 + .../world/2011_02_07_1_world_creature_questrelation.sql | 11 ++++++----- 2 files changed, 7 insertions(+), 5 deletions(-) (limited to 'sql/updates') diff --git a/sql/updates/world/2011_02_03_3_world_spell_dbc.sql b/sql/updates/world/2011_02_03_3_world_spell_dbc.sql index 223c4760d0b..0d26399cf42 100644 --- a/sql/updates/world/2011_02_03_3_world_spell_dbc.sql +++ b/sql/updates/world/2011_02_03_3_world_spell_dbc.sql @@ -1,3 +1,4 @@ +DELETE FROM `spell_dbc` WHERE `Id` IN (58630,68572,68574,59046,68184,59450,65195,64899,64985,65074); INSERT INTO `spell_dbc` (`Id`,`Dispel`,`Mechanic`,`Attributes`,`AttributesEx`,`AttributesEx2`,`AttributesEx3`,`AttributesEx4`,`AttributesEx5`,`Stances`,`StancesNot`,`Targets`,`CastingTimeIndex`,`AuraInterruptFlags`,`ProcFlags`,`ProcChance`,`ProcCharges`, `MaxLevel`,`BaseLevel`,`SpellLevel`,`DurationIndex`,`RangeIndex`,`StackAmount`,`EquippedItemClass`,`EquippedItemSubClassMask`,`EquippedItemInventoryTypeMask`,`Effect1`,`Effect2`,`Effect3`,`EffectDieSides1`,`EffectDieSides2`,`EffectDieSides3`, `EffectRealPointsPerLevel1`,`EffectRealPointsPerLevel2`,`EffectRealPointsPerLevel3`,`EffectBasePoints1`,`EffectBasePoints2`,`EffectBasePoints3`,`EffectMechanic1`,`EffectMechanic2`,`EffectMechanic3`,`EffectImplicitTargetA1`,`EffectImplicitTargetA2`,`EffectImplicitTargetA3`, diff --git a/sql/updates/world/2011_02_07_1_world_creature_questrelation.sql b/sql/updates/world/2011_02_07_1_world_creature_questrelation.sql index c0f93b24ced..4aeb7a70775 100644 --- a/sql/updates/world/2011_02_07_1_world_creature_questrelation.sql +++ b/sql/updates/world/2011_02_07_1_world_creature_questrelation.sql @@ -1,11 +1,12 @@ -- Missing relation for quest You've Been Served -INSERT INTO `creature_questrelation`(`id`,`quest`) VALUES -(38208,14488); -INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES -(36296,14488); +DELETE FROM `creature_questrelation` WHERE `id`=38208 AND `quest`=14488; +DELETE FROM `creature_involvedrelation` WHERE `id`=36296 AND `quest`=14488; +INSERT INTO `creature_questrelation`(`id`,`quest`) VALUES (38208,14488); +INSERT INTO `creature_involvedrelation`(`id`,`quest`) VALUES (36296,14488); -- Missing loot form Standard Apothecary Serving Kit request for quest You've Been Served - INSERT INTO `item_loot_template`(`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES +DELETE FROM `item_loot_template` WHERE `entry`=49631 AND `item` IN (49352,49351,49635); +INSERT INTO `item_loot_template`(`entry`,`item`,`ChanceOrQuestChance`,`lootmode`,`groupid`,`mincountOrRef`,`maxcount`) VALUES (49631,49352,100,1,0,1,1), (49631,49351,100,1,0,1,1), (49631,49635,100,1,0,1,1); -- cgit v1.2.3