Pain: Naxx bossovia a porty

[leo]

Code:

-- npc
UPDATE `creature_template` SET `spell1`=0, `ScriptName`='npc_zombie_chow' WHERE `entry`=16360;
UPDATE `creature_template` SET `spell1`=0 WHERE `entry`=30303;

-- spelly
DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_gluth_decimate', 'spell_gluth_zombiechow_search');
INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES
(28374, 'spell_gluth_decimate'),
(54426, 'spell_gluth_decimate'),
(28239, 'spell_gluth_zombiechow_search'),
(28404, 'spell_gluth_zombiechow_search');

-- podminky
DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 13 AND `SourceEntry` IN (28374, 28404, 54426);
INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrReference`, `ConditionTarget`, `ConditionValue1`, `ConditionValue2`, `ConditionValue3`, `NegativeCondition`, `ErrorType`, `ErrorTextId`, `ScriptName`, `Comment`) VALUES
(13, 1, 28404, 0, 0, 31, 0, 3, 16360, 0, 0, 0, 0, '', 'Zombie Chow Search targets zombies only'),
(13, 1, 28374, 0, 0, 31, 0, 3, 16360, 0, 0, 0, 0, '', 'Decimate damage should only hit zombie or player'),
(13, 1, 28374, 0, 1, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Decimate damage should only hit zombie or player'),
(13, 1, 54426, 0, 0, 31, 0, 3, 16360, 0, 0, 0, 0, '', 'Decimate damage should only hit zombie or player'),
(13, 1, 54426, 0, 1, 31, 0, 4, 0, 0, 0, 0, 0, '', 'Decimate damage should only hit zombie or player');

-- chybejici texty npc
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `TextRange`, `comment`) VALUES
(15932, 0, 0, '%s spots a zombie to devour!', 16, 0, 100, 0, 0, 0, 12242, 2/3, 'Gluth - spots one'),
(15932, 1, 0, '%s decimates all nearby flesh!', 41, 0, 100, 0, 0, 0, 32321, 2/3, 'Gluth - decimate'),
(15932, 2, 0, '%s becomes enraged!', 41, 0, 100, 0, 0, 0, 24144, 2/3, 'Gluth - enrage'),
(15932, 3, 0, '%s devours all nearby zombies!', 16, 0, 100, 0, 0, 0, 12348, 2/3, 'Gluth - devours all'),
(15932, 4, 0, '%s goes into a berserker rage!', 41, 0, 100, 0, 0, 0, 34057, 2/3, 'Gluth - berserker');

-- spawn skupiny npc
INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orientation`,`summonType`,`summonTime`) VALUES
(15932,0,1,16360,3270.132,-3169.948,297.5891,5.88176,6,10000),
(15932,0,2,16360,3307.298,-3183.449,297.5891,5.74213,6,10000),
(15932,0,2,16360,3255.708,-3135.677,297.5891,1.86750,6,10000);

[leo]

nahodené

[mirra]

8 queries executed, 7 success, 1 errors, 0 warnings

Query: UPDATE `creature_template` SET `spell1`=0, `ScriptName`='npc_zombie_chow' WHERE `entry`=16360

0 row(s) affected

Execution Time : 0.006 sec
Transfer Time : 0 sec
Total Time : 0.006 sec
--------------------------------------------------

Query: UPDATE `creature_template` SET `spell1`=0 WHERE `entry`=30303

0 row(s) affected

Execution Time : 0.005 sec
Transfer Time : 0 sec
Total Time : 0.005 sec
--------------------------------------------------

Query: DELETE FROM `spell_script_names` WHERE `ScriptName` IN ('spell_gluth_decimate', 'spell_gluth_zombiechow_search')

4 row(s) affected

Execution Time : 0.005 sec
Transfer Time : 0 sec
Total Time : 0.006 sec
--------------------------------------------------

Query: INSERT INTO `spell_script_names` (`spell_id`, `ScriptName`) VALUES (28374, 'spell_gluth_decimate'), (54426, 'spell_gluth_decimat...

4 row(s) affected

Execution Time : 0.005 sec
Transfer Time : 0 sec
Total Time : 0.005 sec
--------------------------------------------------

Query: DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`= 13 AND `SourceEntry` IN (28374, 28404, 54426)

5 row(s) affected

Execution Time : 0.008 sec
Transfer Time : 0 sec
Total Time : 0.009 sec
--------------------------------------------------

Query: INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceGroup`, `SourceEntry`, `SourceId`, `ElseGroup`, `ConditionTypeOrRefe...

5 row(s) affected

Execution Time : 0.005 sec
Transfer Time : 0 sec
Total Time : 0.005 sec
--------------------------------------------------

Query: INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, ...

Error Code: 1062
Duplicate entry '15932-0-0' for key 'PRIMARY'

Execution Time : 0 sec
Transfer Time : 0 sec
Total Time : 0.005 sec
--------------------------------------------------

Query: INSERT INTO `creature_summon_groups` (`summonerId`,`summonerType`,`groupId`,`entry`,`position_x`,`position_y`,`position_z`,`orie...

3 row(s) affected

Execution Time : 0.005 sec
Transfer Time : 0 sec
Total Time : 0.005 sec