Changeset 178 for trunk/sql

Show
Ignore:
Timestamp:
11/19/08 13:43:40 (17 years ago)
Author:
yumileroy
Message:

[svn] Rewrite canSeeOrDetect function.
Minor change on trigger creatures.
Remove some unused hacks in scripts.

Original author: megamage
Date: 2008-11-06 10:27:58-06:00

Location:
trunk/sql/updates
Files:
2 modified

Legend:

Unmodified
Added
Removed

  • trunk/sql/updates/146_world.sql

    r161 r178  
    1 update creature_template set spell1 = 40836, flags_extra = 128, scriptname = '' where entry = 23336; 
    2  
    31DROP TABLE IF EXISTS `spell_linked_spell`; 
    42CREATE TABLE `spell_linked_spell` ( 

  • trunk/sql/updates/163_world.sql

    r162 r178  
    1 DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (39992, 39835, 42052, -41914, 41126); 
     1DELETE FROM spell_linked_spell WHERE `spell_trigger` IN (39992, 39835, 42052, -41914, 41126, 41376); 
    22-- INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39992, 39835, 1, 'Needle Spine'); 
    33INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (39835, 39968, 1, 'Needle Spine'); 
     4INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41376, 41377, 0, 'Spite'); 
    45INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (-41914, 41915, 0, 'Summon Parasitic Shadowfiend'); 
    56INSERT INTO spell_linked_spell (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES (41126, 41131, 1, 'Flame Crash'); 
    67 
     8-- molten_flame 
    79UPDATE creature_template SET flags_extra = 128, speed = 1.0 WHERE entry = 23095; 
     10-- volcano 
     11UPDATE creature_template SET spell1 = 40117, flags_extra = 128, scriptname = '' WHERE entry = 23085; 
     12-- flame crash 
     13update creature_template set spell1 = 40836, flags_extra = 128, scriptname = '' where entry = 23336; 
     14-- blaze 
     15update creature_template set spell1 = 40610, flags_extra = 128, scriptname = '' where entry = 23259;