Public feed #892699

Jemand

public sql v1 · immutable
Raw Edit
·published 2008-02-05 17:08 UTC
rendered paste body
-- (33167) Absolution (Rank 1) - NewDELETE FROM `spell_affect` WHERE `entry` IN (33167);INSERT INTO `spell_affect` VALUES (33167, 0, 0, 0x00, 0, 0, 0, 0x0000000100000000, 0);-- (33171) Absolution (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (33171);INSERT INTO `spell_affect` VALUES (33171, 0, 0, 0x00, 0, 0, 0, 0x0000000100000000, 0);-- (33172) Absolution (Rank 3)DELETE FROM `spell_affect` WHERE `entry` IN (33172);INSERT INTO `spell_affect` VALUES (33172, 0, 0, 0x00, 0, 0, 0, 0x0000000100000000, 0);-- (23236) Benediction () - Convert to FamilyMask-- Added 2^36 (new racial spell, Chastise)DELETE FROM `spell_affect` WHERE `entry` IN (23236);INSERT INTO `spell_affect` VALUES (23236, 0, 0, 0x00, 0, 0, 0, 0x0000003419541EC0, 0);-- (37880) Blessing of Lower City () - New only heal spells-- Added 2^37 (Prayer of Mending)DELETE FROM `spell_affect` WHERE `entry` IN (37880);INSERT INTO `spell_affect` VALUES (37880, 0, 0, 0x00, 0, 0, 0, 0x0000000411041E40, 0);-- (15259) Darkness (Rank 1) - Convert and remove non damage spells-- Split in DOTs and direct Dmg, added 2^23 (Mind Flay)DELETE FROM `spell_affect` WHERE `entry` IN (15259);INSERT INTO `spell_affect` VALUES (15259, 0, 0, 0x00, 0, 0, 0, 0x0000000202002000, 0);INSERT INTO `spell_affect` VALUES (15259, 1, 0, 0x00, 0, 0, 0, 0x0000040000808000, 0);-- (15307) Darkness (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (15307);INSERT INTO `spell_affect` VALUES (15307, 0, 0, 0x00, 0, 0, 0, 0x0000000202002000, 0);INSERT INTO `spell_affect` VALUES (15307, 1, 0, 0x00, 0, 0, 0, 0x0000040000808000, 0);-- (15308) Darkness (Rank 3)DELETE FROM `spell_affect` WHERE `entry` IN (15308);INSERT INTO `spell_affect` VALUES (15308, 0, 0, 0x00, 0, 0, 0, 0x0000000202002000, 0);INSERT INTO `spell_affect` VALUES (15308, 1, 0, 0x00, 0, 0, 0, 0x0000040000808000, 0);-- (15309) Darkness (Rank 4)DELETE FROM `spell_affect` WHERE `entry` IN (15309);INSERT INTO `spell_affect` VALUES (15309, 0, 0, 0x00, 0, 0, 0, 0x0000000202002000, 0);INSERT INTO `spell_affect` VALUES (15309, 1, 0, 0x00, 0, 0, 0, 0x0000040000808000, 0);-- (15310) Darkness (Rank 5)DELETE FROM `spell_affect` WHERE `entry` IN (15310);INSERT INTO `spell_affect` VALUES (15310, 0, 0, 0x00, 0, 0, 0, 0x0000000202002000, 0);INSERT INTO `spell_affect` VALUES (15310, 1, 0, 0x00, 0, 0, 0, 0x0000040000808000, 0);-- (14743) Focused Casting (Rank 1) - Convert and remove instant cast spells-- added 2^23 (Mind Flay) and 2^36 (new racial spell, Chastise)DELETE FROM `spell_affect` WHERE `entry` IN (14743);INSERT INTO `spell_affect` VALUES (14743, 0, 0, 0x00, 0, 0, 0, 0x0000049440963E90, 0);-- (27828) Focused Casting (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (27828);INSERT INTO `spell_affect` VALUES (27828, 0, 0, 0x00, 0, 0, 0, 0x0000049440963E90, 0);-- (33186) Focused Power (Rank 1)DELETE FROM `spell_affect` WHERE `entry` IN (33186);INSERT INTO `spell_affect` VALUES (33186, 0, 0, 0x00, 0, 0, 0, 0x0000008000000000, 0);INSERT INTO `spell_affect` VALUES (33186, 1, 0, 0x00, 0, 0, 0, 0x0000008000002080, 0);-- (33190) Focused Power (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (33190);INSERT INTO `spell_affect` VALUES (33190, 0, 0, 0x00, 0, 0, 0, 0x0000008000000000, 0);INSERT INTO `spell_affect` VALUES (33190, 1, 0, 0x00, 0, 0, 0, 0x0000008000002080, 0);-- (18544) Force of Will (Rank 1) - Convert and add only damage spells--1: 41202F8A090 (2 OR 3)--2: 01202582090 only direct dmg added 2^19 (Touch of Weakness) and 2^36 (new racial spell, Chastise)--3: 40000A08000 only dots added 2^23 (Mind Flay)DELETE FROM `spell_affect` WHERE `entry` IN (18544);INSERT INTO `spell_affect` VALUES (18544, 0, 0, 0x00, 0, 0, 0, 0x0000041202F8A090, 0);INSERT INTO `spell_affect` VALUES (18544, 1, 0, 0x00, 0, 0, 0, 0x0000001202582090, 0);INSERT INTO `spell_affect` VALUES (18544, 2, 0, 0x00, 0, 0, 0, 0x0000040000A08000, 0);-- (18547) Force of Will (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (18547);INSERT INTO `spell_affect` VALUES (18547, 0, 0, 0x00, 0, 0, 0, 0x0000041202F8A090, 0);INSERT INTO `spell_affect` VALUES (18547, 1, 0, 0x00, 0, 0, 0, 0x0000001202582090, 0);INSERT INTO `spell_affect` VALUES (18547, 2, 0, 0x00, 0, 0, 0, 0x0000040000A08000, 0);-- (18548) Force of Will (Rank 3)DELETE FROM `spell_affect` WHERE `entry` IN (18548);INSERT INTO `spell_affect` VALUES (18548, 0, 0, 0x00, 0, 0, 0, 0x0000041202F8A090, 0);INSERT INTO `spell_affect` VALUES (18548, 1, 0, 0x00, 0, 0, 0, 0x0000001202582090, 0);INSERT INTO `spell_affect` VALUES (18548, 2, 0, 0x00, 0, 0, 0, 0x0000040000A08000, 0);-- (18549) Force of Will (Rank 4)DELETE FROM `spell_affect` WHERE `entry` IN (18549);INSERT INTO `spell_affect` VALUES (18549, 0, 0, 0x00, 0, 0, 0, 0x0000041202F8A090, 0);INSERT INTO `spell_affect` VALUES (18549, 1, 0, 0x00, 0, 0, 0, 0x0000001202582090, 0);INSERT INTO `spell_affect` VALUES (18549, 2, 0, 0x00, 0, 0, 0, 0x0000040000A08000, 0);-- (18550) Force of Will (Rank 5)DELETE FROM `spell_affect` WHERE `entry` IN (18550);INSERT INTO `spell_affect` VALUES (18550, 0, 0, 0x00, 0, 0, 0, 0x0000041202F8A090, 0);INSERT INTO `spell_affect` VALUES (18550, 1, 0, 0x00, 0, 0, 0, 0x0000001202582090, 0);INSERT INTO `spell_affect` VALUES (18550, 2, 0, 0x00, 0, 0, 0, 0x0000040000A08000, 0);-- (14913) Healing Focus (Rank 1)-- added 2^34 (Binding Heal)DELETE FROM `spell_affect` WHERE `entry` IN (14913);INSERT INTO `spell_affect` VALUES (14913, 0, 0, 0x00, 0, 0, 0, 0x0000000400041E00, 0);-- (15012) Healing Focus (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (15012);INSERT INTO `spell_affect` VALUES (15012, 0, 0, 0x00, 0, 0, 0, 0x0000000400041E00, 0);-- (37706) Healing Trance ()-- Added 2^37 (Prayer of Mending)DELETE FROM `spell_affect` WHERE `entry` IN (37706);INSERT INTO `spell_affect` VALUES (37706, 0, 0, 0x00, 0, 0, 0, 0x0000000411041E40, 0);-- (37571) Improved Mind Flay and Smite ()-- split in direct and over time damageDELETE FROM `spell_affect` WHERE `entry` IN (37571);INSERT INTO `spell_affect` VALUES (37571, 0, 0, 0x00, 0, 0, 0, 0x0000000000000080, 0);INSERT INTO `spell_affect` VALUES (37571, 1, 0, 0x00, 0, 0, 0, 0x0000000000800000, 0);-- (14751) Inner Focus ()-- should be usable on all spells not only the ones with cast timeDELETE FROM `spell_affect` WHERE `entry` IN (14751);INSERT INTO `spell_affect` VALUES (14751, 0, 0, 0x00, 0, 0, 0, 0xFFFFFFFFFFFFFFFF, 0);INSERT INTO `spell_affect` VALUES (14751, 1, 0, 0x00, 0, 0, 0, 0xFFFFFFFFFFFFFFFF, 0);-- (14520) Mental Agility (Rank 1) - New Add all instant spells-- removed 2^19 (proc, 0 mana), 2^23 (not instant)-- added 2^24(Desperate Prayer), 2^31 (different spells)DELETE FROM `spell_affect` WHERE `entry` IN (14520);INSERT INTO `spell_affect` VALUES (14520, 0, 0, 0x00, 0, 0, 0, 0x00000963BF61C16F, 0);-- (14780) Mental Agility (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (14780);INSERT INTO `spell_affect` VALUES (14780, 0, 0, 0x00, 0, 0, 0, 0x00000963BF61C16F, 0);-- (14781) Mental Agility (Rank 3)DELETE FROM `spell_affect` WHERE `entry` IN (14781);INSERT INTO `spell_affect` VALUES (14781, 0, 0, 0x00, 0, 0, 0, 0x00000963BF61C16F, 0);-- (14782) Mental Agility (Rank 4)DELETE FROM `spell_affect` WHERE `entry` IN (14782);INSERT INTO `spell_affect` VALUES (14782, 0, 0, 0x00, 0, 0, 0, 0x00000963BF61C16F, 0);-- (14783) Mental Agility (Rank 5)DELETE FROM `spell_affect` WHERE `entry` IN (14783);INSERT INTO `spell_affect` VALUES (14783, 0, 0, 0x00, 0, 0, 0, 0x00000963BF61C16F, 0);-- (33206) Pain Suppression ()-- don't see reason why this needs spell_affect-- (28808) Reduced Threat ()-- mask didn't make sense-- took the one from (37880) Blessing of Lower CityDELETE FROM `spell_affect` WHERE `entry` IN (28808);INSERT INTO `spell_affect` VALUES (28808, 0, 0, 0x00, 0, 0, 0, 0x0000000411041E40, 0);-- (15318) Shadow Affinity (Rank 1) - Convert remove all non damage spells-- description doesn't say "damage" should affect all shadow spellsDELETE FROM `spell_affect` WHERE `entry` IN (15318);INSERT INTO `spell_affect` VALUES (15318, 0, 0, 0x00, 0, 0, 0, 0x00000D4A068BE104, 0);-- (15272) Shadow Affinity (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (15272);INSERT INTO `spell_affect` VALUES (15272, 0, 0, 0x00, 0, 0, 0, 0x00000D4A068BE104, 0);-- (15320) Shadow Affinity (Rank 3)DELETE FROM `spell_affect` WHERE `entry` IN (15320);INSERT INTO `spell_affect` VALUES (15320, 0, 0, 0x00, 0, 0, 0, 0x00000D4A068BE104, 0);-- (15260) Shadow Focus (Rank 1) - Convert remove positive spellsDELETE FROM `spell_affect` WHERE `entry` IN (15260);INSERT INTO `spell_affect` VALUES (15260, 0, 0, 0x00, 0, 0, 0, 0x00000442068BA000, 0);-- (15327) Shadow Focus (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (15327);INSERT INTO `spell_affect` VALUES (15327, 0, 0, 0x00, 0, 0, 0, 0x00000442068BA000, 0);-- (15328) Shadow Focus (Rank 3)DELETE FROM `spell_affect` WHERE `entry` IN (15328);INSERT INTO `spell_affect` VALUES (15328, 0, 0, 0x00, 0, 0, 0, 0x00000442068BA000, 0);-- (15329) Shadow Focus (Rank 4)DELETE FROM `spell_affect` WHERE `entry` IN (15329);INSERT INTO `spell_affect` VALUES (15329, 0, 0, 0x00, 0, 0, 0, 0x00000442068BA000, 0);-- (15330) Shadow Focus (Rank 5)DELETE FROM `spell_affect` WHERE `entry` IN (15330);INSERT INTO `spell_affect` VALUES (15330, 0, 0, 0x00, 0, 0, 0, 0x00000442068BA000, 0);-- (17322) Shadow Reach (Rank 1) - Convert remove spellsthithout range-- removed 2^8 not offensive (Shadow Protection)-- added 2^26 (different spells, e.g. Silence, 2^40 (Shadowfiend)DELETE FROM `spell_affect` WHERE `entry` IN (17322);INSERT INTO `spell_affect` VALUES (17322, 0, 0, 0x00, 0, 0, 0, 0x00000542068AA004, 0);-- (17323) Shadow Reach (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (17323);INSERT INTO `spell_affect` VALUES (17323, 0, 0, 0x00, 0, 0, 0, 0x00000542068AA004, 0);-- (14523) Silent Resolve (Rank 1) - Convert-- Dispell chance of ALL spells should be increased, HOLY/DISC is only for threat reductionDELETE FROM `spell_affect` WHERE `entry` IN (14523);INSERT INTO `spell_affect` VALUES (14523, 1, 0, 0x00, 0, 0, 0, 0xFFFFFFFFFFFFFFFF, 0);-- (14784) Silent Resolve (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (14784);INSERT INTO `spell_affect` VALUES (14784, 1, 0, 0x00, 0, 0, 0, 0xFFFFFFFFFFFFFFFF, 0);-- (14785) Silent Resolve (Rank 3)DELETE FROM `spell_affect` WHERE `entry` IN (14785);INSERT INTO `spell_affect` VALUES (14785, 1, 0, 0x00, 0, 0, 0, 0xFFFFFFFFFFFFFFFF, 0);-- (14786) Silent Resolve (Rank 4)DELETE FROM `spell_affect` WHERE `entry` IN (14786);INSERT INTO `spell_affect` VALUES (14786, 1, 0, 0x00, 0, 0, 0, 0xFFFFFFFFFFFFFFFF, 0);-- (14787) Silent Resolve (Rank 5)DELETE FROM `spell_affect` WHERE `entry` IN (14787);INSERT INTO `spell_affect` VALUES (14787, 1, 0, 0x00, 0, 0, 0, 0xFFFFFFFFFFFFFFFF, 0);-- (14912) Improved Healing (Rank 1)DELETE FROM `spell_affect` WHERE `entry` IN (14912);INSERT INTO `spell_affect` VALUES (14912, 0, 0, 0x00, 0, 0, 0, 0x0000000000041400, 0);-- (15013) Improved Healing (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (15013);INSERT INTO `spell_affect` VALUES (15013, 0, 0, 0x00, 0, 0, 0, 0x0000000000041400, 0);-- (15014) Improved Healing (Rank 3)DELETE FROM `spell_affect` WHERE `entry` IN (15014);INSERT INTO `spell_affect` VALUES (15014, 0, 0, 0x00, 0, 0, 0, 0x0000000000041400, 0);-- (14747) Improved Inner Fire (Rank 1)DELETE FROM `spell_affect` WHERE `entry` IN (14747);INSERT INTO `spell_affect` VALUES (14747, 0, 0, 0x00, 0, 0, 0, 0x0000000000000002, 0);-- (14770) Improved Inner Fire (Rank 2)DELETE FROM `spell_affect` WHERE `entry` IN (14770);INSERT INTO `spell_affect` VALUES (14770, 0, 0, 0x00, 0, 0, 0, 0x0000000000000002, 0);-- (14771) Improved Inner Fire (Rank 3)DELETE FROM `spell_affect` WHERE `entry` IN (14771);INSERT INTO `spell_affect` VALUES (14771, 0, 0, 0x00, 0, 0, 0, 0x0000000000000002, 0);-- (44297) Improved Psychic Scream ()DELETE FROM `spell_affect` WHERE `entry` IN (44297);INSERT INTO `spell_affect` VALUES (44297, 0, 0, 0x00, 0, 0, 0, 0x0000000000010000, 0);