diff options
| author | Nay <dnpd.dd@gmail.com> | 2011-02-07 21:52:14 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2011-02-07 21:52:14 +0000 |
| commit | f81cfca7bd5583cef0254920e3fae234d0789e69 (patch) | |
| tree | d8bb223cbe576383b995e1044ee30e10dc02162b /sql/updates | |
| parent | 774f8e86505ab8ca371c8c4d1acfcfaceedec4a9 (diff) | |
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
Diffstat (limited to 'sql/updates')
| -rw-r--r-- | sql/updates/world/2011_02_03_3_world_spell_dbc.sql | 1 | ||||
| -rw-r--r-- | sql/updates/world/2011_02_07_1_world_creature_questrelation.sql | 11 |
2 files changed, 7 insertions, 5 deletions
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); |