root/trunk/sql/updates/78_world.sql @ 73

Revision 73, 1.2 kB (checked in by yumileroy, 17 years ago)

[svn] * DB data for item 28356 and related, and also for 28602, 30317, 28578. source: Mangos
* List fake data for last spells expected to listed in spell_affect. source: Mangos
* Fixed: wrong arg name for va_start call in

WorldSession::SendNotification?. source: Mangos

* Implemented dummy aura of spell 43873. source: Mangos

Original author: KingPin?
Date: 2008-10-19 17:27:18-05:00
Line 
1DELETE FROM spell_affect WHERE entry IN (30017,30280,44373) AND effectId = 0;
2INSERT INTO spell_affect (entry, effectId, SpellFamilyMask) VALUES
3(30017,0,0x0000000000000000),
4(30280,0,0x0000000000000000),
5(44373,0,0x0000000000000000);
6
7DELETE FROM spell_affect WHERE entry IN (34520,37508) AND effectId = 1;
8INSERT INTO spell_affect (entry, effectId, SpellFamilyMask) VALUES
9(34520,1,0x0000000000000000),
10(37508,1,0x0000000000000000);
11
12DELETE FROM spell_proc_event WHERE entry IN (34139,42368,43726,46092);
13INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES
14(34139,0,0,0,10,0x0000000040000000,0x08000000,0,0),
15(42368,0,0,0,10,0x0000000040000000,0x08000000,0,0),
16(43726,0,0,0,10,0x0000000040000000,0x08000000,0,0),
17(46092,0,0,0,10,0x0000000040000000,0x08000000,0,0);
18
19DELETE FROM spell_proc_event where entry IN (34598, 34584, 36488);
20INSERT INTO spell_proc_event (entry, SchoolMask, Category, SkillID, SpellFamilyName, SpellFamilyMask, procFlags, ppmRate, cooldown) VALUES
21(34598,0,0,0,0,0x0000000000000000,0x00020000,0,45),
22(36488,0,0,0,0,0x0000000000000000,0x08000000,0,0),
23(34584,0,0,0,0,0x0000000000000000,0x00004000,0,30);
Note: See TracBrowser for help on using the browser.