diff options
| author | ShinDarth <shin.darth@hotmail.it> | 2012-03-22 21:50:13 +0000 |
|---|---|---|
| committer | Nay <dnpd.dd@gmail.com> | 2012-03-22 21:50:13 +0000 |
| commit | 011a73e3e5d1e18508b6a594b9dc26a26ce374d6 (patch) | |
| tree | d511bf1380a60a18f9ceb67037486fd8dd88b220 | |
| parent | a2818cc442624acbbc293ff20d39444c818b4aaf (diff) | |
DB/Conditions: 39152 should only be lootable if you have at least 390 skills in First Aid;
Also add proper file ending to recent SQLs
Closes #5840
| -rw-r--r-- | sql/updates/world/2012_03_21_00_world_creature.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2012_03_22_00_world_creature_template.sql | 2 | ||||
| -rw-r--r-- | sql/updates/world/2012_03_22_01_world_conditions.sql | 2 |
3 files changed, 4 insertions, 2 deletions
diff --git a/sql/updates/world/2012_03_21_00_world_creature.sql b/sql/updates/world/2012_03_21_00_world_creature.sql index 254e86b94dc..def72f74cd6 100644 --- a/sql/updates/world/2012_03_21_00_world_creature.sql +++ b/sql/updates/world/2012_03_21_00_world_creature.sql @@ -68,4 +68,4 @@ INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `phaseMask`, `modelid` (@GUID+58,@NPC_TRIGGER2,649,15,1,0,0,563.997,187.644,395.489,0,7200,0,0,1,0,0,0,0,0), (@GUID+59,@NPC_TRIGGER2,649,15,1,0,0,555.695,86.0208,395.253,0,7200,0,0,1,0,0,0,0,0), (@GUID+60,@NPC_TRIGGER2,649,15,1,0,0,535.924,184.207,395.279,0,7200,0,0,1,0,0,0,0,0), -(@GUID+61,@NPC_TRIGGER2,649,15,1,0,0,538.024,92.441,395.289,0,7200,0,0,1,0,0,0,0,0);
\ No newline at end of file +(@GUID+61,@NPC_TRIGGER2,649,15,1,0,0,538.024,92.441,395.289,0,7200,0,0,1,0,0,0,0,0); diff --git a/sql/updates/world/2012_03_22_00_world_creature_template.sql b/sql/updates/world/2012_03_22_00_world_creature_template.sql index 6cf07ff4103..e6c03ed589c 100644 --- a/sql/updates/world/2012_03_22_00_world_creature_template.sql +++ b/sql/updates/world/2012_03_22_00_world_creature_template.sql @@ -1,2 +1,2 @@ -- Flame Sphere should not be visible to players(only their visual) -UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry` IN (30106,31686,31687);
\ No newline at end of file +UPDATE `creature_template` SET `flags_extra`=128 WHERE `entry` IN (30106,31686,31687); diff --git a/sql/updates/world/2012_03_22_01_world_conditions.sql b/sql/updates/world/2012_03_22_01_world_conditions.sql new file mode 100644 index 00000000000..074328137a5 --- /dev/null +++ b/sql/updates/world/2012_03_22_01_world_conditions.sql @@ -0,0 +1,2 @@ +-- Manual: Heavy Frostweave Bandage should be lootable if you have at least 390 skills in First Aid +UPDATE `conditions` SET `ConditionValue2`=390 WHERE `SourceTypeOrReferenceId`=1 AND `SourceEntry`=39152 AND `ConditionTypeOrReference`=7 AND `ConditionValue1`=129; |