-
Content count
83 -
Joined
-
Last visited
Posts posted by Fyriond
-
-
You are facing the wrong section. This is the section for submitting patches do develop the server by your own.
If you know spells that don't work please submit to bugtracker.
-
The developers fix parts of every aspect in the game.
-
Thanks for your information. I never though about this.
-
--http://www.wowhead.com/npc=14772/east-frostwolf-warmaster --http://www.wowhead.com/npc=14776/tower-point-warmaster --http://www.wowhead.com/npc=14777/west-frostwolf-warmaster --http://www.wowhead.com/npc=11946/drekthar --http://www.wowhead.com/npc=14773/iceblood-warmaster --http://www.wowhead.com/npc=12122/duros --http://www.wowhead.com/npc=12121/drakan --http://www.wowhead.com/npc=11947/captain-galvangar UPDATE `creature_template` SET spell1='8599', spell2='13736', spell3='15589', spell4='40504' WHERE entry='14772'; UPDATE `creature_template` SET spell1='8599', spell2='13736', spell3='15589', spell4='40504' WHERE entry='14776'; UPDATE `creature_template` SET spell1='8599', spell2='13736', spell3='15589', spell4='40504' WHERE entry='14777'; UPDATE `creature_template` SET spell1='8269', spell2='13736', spell3='15589', spell4='19128' WHERE entry='11946'; UPDATE `creature_template` SET spell1='8599', spell2='13736', spell3='15589', spell4='40504' WHERE entry='14773'; UPDATE `creature_template` SET spell1='8599', spell2='223971' WHERE entry='12122'; UPDATE `creature_template` SET spell1='8599', spell2='223971' WHERE entry='12121'; UPDATE `creature_template` SET spell1='13736', spell2='15284', spell3='15589', spell4='16856' WHERE entry='11947';
-
--http://www.wowhead.com/npc=108133/blacksail-salvor DELETE FROM `creature_loot_template` WHERE entry='108133'; INSERT INTO `creature_loot_template` VALUES ('108133', '121001', '0', '0.24', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121002', '0', '0.41', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121004', '0', '0.03', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121005', '0', '0.69', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121006', '0', '0.1', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121008', '0', '0.28', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121012', '0', '0.38', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121015', '0', '0.17', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121016', '0', '0.69', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121017', '0', '0.41', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121018', '0', '0.21', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121019', '0', '0.07', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121020', '0', '0.21', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121021', '0', '0.31', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121023', '0', '0.52', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121024', '0', '0.65', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121027', '0', '0.58', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121028', '0', '0.72', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121040', '0', '0.34', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121041', '0', '0.21', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121042', '0', '0.17', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121043', '0', '0.76', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121044', '0', '0.03', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121045', '0', '0.21', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121046', '0', '0.28', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121047', '0', '0.03', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121048', '0', '0.1', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121049', '0', '0.72', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121050', '0', '0.24', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121051', '0', '0.31', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121052', '0', '0.28', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121053', '0', '0.1', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121054', '0', '0.48', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121055', '0', '0.62', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121333', '0', '1.03', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121334', '0', '0.93', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121335', '0', '1.14', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121336', '0', '0.31', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121337', '0', '0.62', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121338', '0', '0.14', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121340', '0', '0.28', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121341', '0', '0.38', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121342', '0', '0.52', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121343', '0', '0.31', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121344', '0', '0.48', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121345', '0', '0.69', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121346', '0', '1.07', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121347', '0', '1.41', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121348', '0', '1.07', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121349', '0', '0.28', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121350', '0', '0.89', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121352', '0', '0.69', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121353', '0', '0.72', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121354', '0', '0.58', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121355', '0', '0.17', '1', '0', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121356', '0', '0.48', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121357', '0', '0.93', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121359', '0', '0.07', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121360', '0', '0.69', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121361', '0', '1', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121363', '0', '0.96', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121365', '0', '1', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121368', '0', '1.07', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121369', '0', '0.52', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121371', '0', '0.89', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121372', '0', '0.14', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121373', '0', '0.65', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121385', '0', '0.21', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121396', '0', '0.03', '0' ,'1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121400', '0', '0.24', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121401', '0', '0.03', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121406', '0', '0.03', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121407', '0', '0.07', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '121414', '0', '0.45', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '124437', '0', '63.5', '0', '1', '0', '1', '3', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '129081', '0', '0.41', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '132184', '0', '4.06', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '132190', '0', '0.24', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '132223', '0', '0.24', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '138781', '0', '2.55', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '138782', '0', '0.34', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '139520', '0', '0.03', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '139521', '0', '0.07', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '139522', '0', '0.45', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '140220', '0', '0.65', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '140221', '0', '0.89', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '140222', '0', '1', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '140224', '0', '0.1', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '140225', '0', '0.41', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '140226', '0', '1.48', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '140227', '0', '0.07', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '141031', '0', '0.55', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('108133', '141285', '0', '0.65', '0', '1', '0', '1', '1', ''); UPDATE `creature_template` SET lootid='108133' WHERE entry='108133';
-
--http://www.wowhead.com/npc=107105/broodmother-lizax DELETE FROM `creature_loot_template` WHERE entry='107105'; INSERT INTO `creature_loot_template` VALUES ('107105', '121002', '0', '0.74', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '121003', '0', '0.74', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '121014', '0', '0.74', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '121021', '0', '0.49', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '121041', '0', '0.25', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '121042', '0', '1.23', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '121044', '0', '1.23', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '121045', '0', '0.25', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '121050', '0', '1.23', '0','1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '124437', '0', '10.78', '0', '1', '0', '1', '3', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '127925', '0', '0.74', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '132183', '0', '5.15', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '132184', '0', '39.09', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '132199', '0', '36.64', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '132200', '0', '28.8', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '132204', '0', '30.76', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '137335', '0', '23.04', '0', '1', '0', '2', '3', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '137626', '0', '0.74', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '137677', '0', '1.35', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '138817', '0', '0.74', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '138839', '0', '21.69', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '138991', '0', '0.25', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '140222', '0', '0.49', '0', '1', '0', '1', '1', ''); INSERT INTO `creature_loot_template` VALUES ('107105', '141869', '0', '30.64', '0', '1', '0', '1', '1', ''); UPDATE `creature_template` SET lootid='107105' WHERE entry='107105';
-
--http://www.wowhead.com/npc=109504/ragemaw DELETE FROM `creature_loot_template` WHERE entry='109504'; INSERT INTO `creature_loot_template` VALUES ('109504', '121003', '0', '0.08', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '121005', '0', '0.08', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '121020', '0', '0.08', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '121041', '0', '0.08', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '121046', '0', '0.79', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '129075', '0', '93.21', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '132197', '0', '7.73', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '132199', '0', '14.29', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '132204', '0', '3.24', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '132231', '0', '79.32', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '137677', '0', '1.89', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '138839', '0', '21.78', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '138991', '0', '0.39', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '140220', '0', '0.08', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '140224', '0', '0.47', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('109504', '141285', '0', '0.16', '0', '1', '0', '1', '1', ''); UPDATE `creature_template` SET lootid='109504' WHERE entry='109504';
-
--The creature is regulary released by a ingame-event, which isn't scripted yet. Infernal Lord is nevertheless attackable. --http://www.wowhead.com/npc=90803/infernal-lord DELETE FROM `creature_loot_template` WHERE entry='90803'; INSERT INTO `creature_loot_template` VALUES ('90803', '121001', '0', '0.21', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121006', '0', '0.28', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121008', '0', '0.07', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121015', '0', '0.07', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121017', '0', '0.21', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121019', '0', '0.03', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121020', '0', '0.21', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121024', '0', '0.03', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121041', '0', '0.24', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121042', '0', '0.07', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121043', '0', '0.28', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121044', '0', '0.21', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121046', '0', '0.63', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121052', '0', '0.35', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '121054', '0', '0.24', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '127925', '0', '0.21', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '129083', '0', '8.96', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '132197', '0', '0.07', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '132199', '0', '17.92', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '132200', '0', '0.21', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '132204', '0', '78.84', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '132218', '0', '3.31', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '137677', '0', '0.56', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '138781', '0', '0.31', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '138817', '0', '0.24', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '138839', '0', '9.34', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '138991', '0', '0.03', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '139520', '0', '0.03', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '140220', '0', '0.21', '0', '1', '0', '1', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '140221', '0', '0.14', '0', '1', '0', '0', '1', ''), INSERT INTO `creature_loot_template` VALUES ('90803', '140226', '0', '0.14', '0', '1', '0', '0', '1', ''); UPDATE `creature_template` SET lootid='90803' WHERE entry='90803'; UPDATE `creature_template` SET `unitflags`='1' WHERE `entry`='90803';
-
Unit is currently not attackable. Should be regulary released by an event (not implemented yet)
http://www.wowhead.com/npc=91579/doomlord-kazrok
UPDATE `creature_template` SET `unitflags`='1' WHERE `entry`='91579';
-
http://www.wowhead.com/npc=108255/coura-mistress-of-arcana DELETE FROM `creature_loot_template` WHERE `entry`=108255; UPDATE `creature_template` SET `lootid`='108255' WHERE `entry`='108255'; INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`, `itembonuses`) VALUES ('108255', '141877', '81', '1', '0', '1', '1', ''), ('108255', '138839', '20', '1', '0', '1', '1', ''), ('108255', '138007', '0.4', '1', '0', '1', '1', ''), ('108255', '139520', '0.09', '1', '0', '1', '1', ''), ('108255', '-1220', '83', '1', '0', '70', '70', ''), ('108255', '132234', '79', '1', '0', '1', '1', ''), ('108255', '132233', '39', '1', '0', '1', '1', ''), ('108255', '132212', '17', '1', '0', '1', '1', ''), ('108255', '132232', '15', '1', '0', '1', '1', ''), ('108255', '132217', '6', '1', '0', '1', '1', ''), ('108255', '132213', '', '1', '0', '1', '1', ''), ('108255', '121048', '1.9', '1', '0', '1', '1', ''), ('108255', '121055', '1.3', '1', '0', '1', '1', ''), ('108255', '121047', '1.3', '1', '0', '1', '1', ''), ('108255', '140222', '0.9', '1', '0', '1', '1', ''), ('108255', '121049', '0.9', '1', '0', '1', '1', ''), ('108255', '121050', '0.9', '1', '0', '1', '1', ''), ('108255', '121019', '0.9', '1', '0', '1', '1', ''), ('108255', '121023', '0.8', '1', '0', '1', '1', ''), ('108255', '138781', '0.7', '1', '0', '1', '1', ''), ('108255', '121027', '0.6', '1', '0', '1', '1', ''), ('108255', '121054', '0.6', '1', '0', '1', '1', ''), ('108255', '121043', '0.6', '1', '0', '1', '1', ''), ('108255', '121053', '0.5', '1', '0', '1', '1', ''), ('108255', '121021', '0.4', '1', '0', '1', '1', ''), ('108255', '121040', '0.3', '1', '0', '1', '1', ''), ('108255', '121017', '0.09', '1', '0', '1', '1', ''), ('108255', '140226', '0.09', '1', '0', '1', '1', ''), ('108255', '121004', '0.09', '1', '0', '1', '1', ''), ('108255', '121052', '0.09', '1', '0', '1', '1', '');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('98241', '-1220', '92', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('95221', '-1220', '98', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('95318', '-1220', '29', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('94485', '-1220', '87', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('92180', '-1220', '62', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('93654', '-1220', '40', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('93205', '-1220', '27', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('109708', '-1220', '96', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('97504', '-1220', '75', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('90505', '-1220', '25', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('107113', '-1220', '34', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('107327', '-1220', '90', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('107136', '-1220', '43', '1', '0', '70', '70', '0');
-
order resources additionally
INSERT INTO `creature_loot_template` VALUES ('107657', '-1220', '36', '1', '0', '70', '70', '0');
in Accepted
Posted
Title: Efflorescence Mushroom Fix
Bugtracker Link:
Patch Content:
NPC-ID http://www.wowhead.com/npc=47649/
https://trinitycore.atlassian.net/wiki/display/tc/creature_template
https://trinitycore.atlassian.net/wiki/display/tc/creature_template#creature_template-unit_flags
Flags used: UNIT_FLAG_PVP_ATTACKABLE (8); UNIT_FLAG_IMMUNE_TO_NPC (512) = 520