diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/mangos.sql | 16 | ||||
| -rw-r--r-- | sql/updates/4043_world_npc_spellclick_spells.sql | 28 | ||||
| -rw-r--r-- | sql/updates/4045_world_spell_proc_event.sql | 5 | ||||
| -rw-r--r-- | sql/world_spell_full.sql | 80 |
4 files changed, 69 insertions, 60 deletions
diff --git a/sql/mangos.sql b/sql/mangos.sql index af73760ac0e..7316cd17dfa 100644 --- a/sql/mangos.sql +++ b/sql/mangos.sql @@ -23,7 +23,7 @@ DROP TABLE IF EXISTS `db_version`; CREATE TABLE `db_version` ( `version` varchar(120) default NULL, `creature_ai_version` varchar(120) default NULL, - `required_7988_09_mangos_spell_proc_event` bit(1) default NULL + `required_8021_01_mangos_spell_proc_event` bit(1) default NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes'; -- @@ -3190,11 +3190,12 @@ UNLOCK TABLES; DROP TABLE IF EXISTS `npc_spellclick_spells`; CREATE TABLE `npc_spellclick_spells` ( - `npc_entry` INT UNSIGNED NOT NULL COMMENT 'reference to creature_template', - `spell_id` INT UNSIGNED NOT NULL COMMENT 'spell which should be casted ', - `quest_id` INT UNSIGNED NOT NULL COMMENT 'reference to quest_template', - `quest_status` INT(11) UNSIGNED NOT NULL DEFAULT 3 COMMENT 'Quest status: 3 incompleted, 1 completed/rewarded', - `cast_flags` TINYINT UNSIGNED NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit' + `npc_entry` int unsigned NOT NULL COMMENT 'reference to creature_template', + `spell_id` int unsigned NOT NULL COMMENT 'spell which should be casted ', + `quest_start` mediumint(8) unsigned NOT NULL COMMENT 'reference to quest_template', + `quest_start_active` tinyint(1) unsigned NOT NULL default '0', + `quest_end` mediumint(8) unsigned NOT NULL default '0', + `cast_flags` tinyint unsigned NOT NULL COMMENT 'first bit defines caster: 1=player, 0=creature; second bit defines target, same mapping as caster bit' ) ENGINE = MYISAM DEFAULT CHARSET=utf8; -- @@ -17408,6 +17409,9 @@ INSERT INTO `spell_proc_event` VALUES (51474, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0.000000, 0.000000, 0), (51478, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0.000000, 0.000000, 0), (51479, 0x00000000, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0.000000, 0.000000, 0), +(51483, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0), +(51485, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0), +(51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00004000, 0x00000000, 0.000000, 0.000000, 0), (51556, 0x00000000, 11, 0x000000C0, 0x00000000, 0x00000010, 0x00000000, 0x00000002, 0.000000, 0.000000, 0), (51557, 0x00000000, 11, 0x000000C0, 0x00000000, 0x00000010, 0x00000000, 0x00000002, 0.000000, 0.000000, 0), (51558, 0x00000000, 11, 0x000000C0, 0x00000000, 0x00000010, 0x00000000, 0x00000002, 0.000000, 0.000000, 0), diff --git a/sql/updates/4043_world_npc_spellclick_spells.sql b/sql/updates/4043_world_npc_spellclick_spells.sql new file mode 100644 index 00000000000..2e1895a25fd --- /dev/null +++ b/sql/updates/4043_world_npc_spellclick_spells.sql @@ -0,0 +1,28 @@ +ALTER TABLE npc_spellclick_spells + DROP COLUMN quest_status, + CHANGE COLUMN quest_id quest_start mediumint(8) unsigned NOT NULL COMMENT 'reference to quest_template', + ADD COLUMN quest_start_active tinyint(1) unsigned NOT NULL default '0' AFTER quest_start, + ADD COLUMN quest_end mediumint(8) unsigned NOT NULL default '0' AFTER quest_start_active; + +/* compatibility with old data */ +UPDATE npc_spellclick_spells + SET quest_end = quest_start, quest_start_active = 1 + WHERE quest_start <> 0; + +DELETE FROM `npc_spellclick_spells` WHERE `spell_id` IN ( +54568, 54575, 52263, 52280, 52447); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES +(29488, 54568, 12670, 1, 0, 3), -- Taxi to Death's Breath +(29501, 54575, 12670, 1, 0, 3), +(28605, 52263, 12680, 1, 12680, 1), -- Stolen Horse +(28606, 52263, 12680, 1, 12680, 1), +(28607, 52263, 12680, 1, 12680, 1), +(28782, 52280, 12687, 1, 12687, 1), -- Unbound Charger +(28833, 52447, 12701, 1, 12701, 1), -- Scarlet Cannon Master +(28887, 52447, 12701, 1, 12701, 1); + +DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29912); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES +(29912, 55479, 0, 0, 0, 3); # Obedience Crystal - Force Obedience + +REPLACE into `spell_target_position` values (51852, 609, 2361.21, -5660.45, 503.828, 4.49);
\ No newline at end of file diff --git a/sql/updates/4045_world_spell_proc_event.sql b/sql/updates/4045_world_spell_proc_event.sql new file mode 100644 index 00000000000..6104f0d0782 --- /dev/null +++ b/sql/updates/4045_world_spell_proc_event.sql @@ -0,0 +1,5 @@ +DELETE FROM `spell_proc_event` WHERE `entry` IN (51483,51485,51486); +INSERT INTO `spell_proc_event` VALUES +(51483, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0), +(51485, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0), +(51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0);
\ No newline at end of file diff --git a/sql/world_spell_full.sql b/sql/world_spell_full.sql index 08c23a2b726..c39370ec588 100644 --- a/sql/world_spell_full.sql +++ b/sql/world_spell_full.sql @@ -164,22 +164,6 @@ UPDATE creature_template SET speed = 1.0 WHERE entry = 23095; # molten_flame -- CLICK -- -------- -DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488'); -INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -('29488', '54568', '12670', '1', '3'), -('29501', '54575', '12670', '1', '3'); - -DELETE FROM npc_spellclick_spells WHERE `npc_entry` IN (28605,28606,28607); -INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -(28605, 52263, 12680, 3, 1), -(28606, 52263, 12680, 3, 1), -(28607, 52263, 12680, 3, 1); - --- Spellclick spell to mount deathcharger -DELETE FROM npc_spellclick_spells WHERE `npc_entry`=28782; -INSERT INTO npc_spellclick_spells (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -(28782, 52280, 12687, 3, 1); - -- -------- -- TARGET -- -------- @@ -1216,6 +1200,9 @@ INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `Spell ( 51474, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Astral Shift (Rank 1) ( 51478, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Astral Shift (Rank 2) ( 51479, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00010000, 0, 0, 0), -- Astral Shift (Rank 3) +(51483, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0), +(51485, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0), +(51486, 0x00000001, 11, 0x20000000, 0x00000000, 0x00000000, 0x00000400, 0x00000000, 0.000000, 0.000000, 0), ( 51521, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Improved Stormstrike ( 51522, 0x00, 11, 0x00000000, 0x01000000, 0x00000000, 0x00000000, 0x00000000, 0, 0, 0), -- Improved Stormstrike ( 51528, 0x00, 0, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 0x00000000, 2.5, 0, 0), -- Maelstrom Weapon (Rank 1) @@ -1510,25 +1497,24 @@ UPDATE creature_template SET VehicleId = 312 WHERE entry IN (31857,31858,31861,3 update creature_template set spell5=51890 where entry = 28511; -- Eye of Acherus flight DELETE FROM `spell_script_target` WHERE entry IN -(51859, 48743); +(51859, 48743, 52124, 52479, 52576, 53110); INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES (51859, 1, 28525), -- siphon of archerus (51859, 1, 28542), (51859, 1, 28543), (51859, 1, 28544), +(52124, 1, 28655), -- Sky Darkener Assault +(52479, 1, 28819), -- gift of harvester +(52479, 1, 28822), +(52576, 1, 28834), -- Electro-magnetic Pulse +(52576, 1, 28886), +(53110, 1, 28940), -- Devour Humanoid (48743, 1, 26125); -- Death pact -update creature_template set minlevel=50,maxlevel=52,minhealth=2215,maxhealth=2317,faction_A=2084,faction_H=2084,mindmg=50,maxdmg=50 where entry=28528; -- ghoul - --- taxi -DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN ('29501', '29488'); -INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -('29488', '54568', '12670', '1', '3'), -('29501', '54575', '12670', '1', '3'); +-- Eye of Acherus +REPLACE into `spell_target_position` values (51852, 609, 2361.21, -5660.45, 503.828, 4.49); -DELETE FROM `spell_script_target` WHERE entry IN (52124); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(52124, 1, 28655); +update creature_template set minlevel=50,maxlevel=52,minhealth=2215,maxhealth=2317,faction_A=2084,faction_H=2084,mindmg=50,maxdmg=50 where entry=28528; -- ghoul UPDATE `creature_template` SET spell1=52372,spell2=52373,spell3=52374,spell4=52375 WHERE `entry`=28406; -- death charger @@ -1542,14 +1528,6 @@ UPDATE creature_template SET `VehicleId`=200 WHERE `entry` IN (28605,28606,28607 -- Vehicle and summon spell(summon npc 28788) for Acherus Deathcharger UPDATE creature_template SET `spell1`=52362, `VehicleId`=200 WHERE `entry`=28782; --- gift of harvester -DELETE FROM `spell_script_target` WHERE entry IN -(52479); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(52479,1,28819), -(52479,1,28822); - - replace into creature_questrelation (id,quest) VALUES (28377,12701); replace into creature_involvedrelation (id,quest) VALUES (28377,12701); replace into creature_involvedrelation (id,quest) VALUES (28914,12723); @@ -1560,31 +1538,25 @@ replace into creature_involvedrelation (id,quest) VALUES (28912,12725); replace into creature_questrelation (id,quest) VALUES (28912,12727); replace into creature_involvedrelation (id,quest) VALUES (28913,12727); --- ship cannon -DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (28833,28887); -INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `quest_status`, `cast_flags`) VALUES -(28833, 52447, 12701, 3, 3), -(28887, 52447, 12701, 3, 3); +DELETE FROM `npc_spellclick_spells` WHERE `spell_id` IN ( +54568, 54575, 52263, 52280, 52447); +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES +(29488, 54568, 12670, 1, 0, 3), -- Taxi to Death's Breath +(29501, 54575, 12670, 1, 0, 3), +(28605, 52263, 12680, 1, 12680, 1), -- Stolen Horse +(28606, 52263, 12680, 1, 12680, 1), +(28607, 52263, 12680, 1, 12680, 1), +(28782, 52280, 12687, 1, 12687, 1), -- Unbound Charger +(28833, 52447, 12701, 1, 12701, 1), -- Scarlet Cannon Master +(28887, 52447, 12701, 1, 12701, 1); UPDATE creature_template SET spell1=52435,spell2=52576,spell5=52588,VehicleId=68,speed=0 WHERE entry IN (28833,28887); UPDATE creature_template SET spell1=52211 WHERE entry=28864; -DELETE FROM `spell_script_target` WHERE entry IN -(52576); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(52576,1,28834), -(52576,1,28886); - -- frostbrood vanquisher update creature_template set maxhealth = 133525, minhealth = 133525, maxmana = 51360, minmana = 51360, spell1 = 53114, spell2 = 53112, spell3=53110, VehicleId = 156 where entry = 28670; -DELETE FROM `spell_script_target` WHERE entry IN -(53110); -INSERT INTO `spell_script_target` (`entry`, `type`, `targetEntry`) VALUES -(53110,1,28940); - - -- -------- -- NAXXARAMAS @@ -1634,8 +1606,8 @@ flags_extra = VALUES(flags_extra), scriptname = VALUES(scriptname); DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` IN (29912); -INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_id`, `cast_flags`) VALUES -(29912, 55479, 0, 1); # Obedience Crystal - Force Obedience +INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES +(29912, 55479, 0, 0, 0, 3); # Obedience Crystal - Force Obedience DELETE FROM `spell_script_target` WHERE `entry` IN (28732,54097,55479, |