[LF] Need DB developers for the Emucoach repack projects
What's new

33314 33345 Vrykul Scroll of Ascension Loot Chances

eyerobot

eyerobot

Gold Supporter
Superior Member
916
2015
24
Location
Barryton Michigan USA
Code: 
-- 33314 33345 Vrykul Scroll of Ascension
-- Stop The Ascension

-- 23671 Halfdan the Ice-Hearted
UPDATE `creature_template` SET `unit_flags` = 32768 WHERE `entry` = 23671;

DELETE FROM `creature_text` WHERE `entry`=23671 AND `groupid`=0 AND `id`=0;
INSERT INTO `creature_text` (`entry`, `groupid`, `id`, `text`, `type`, `language`, `probability`, `emote`, `duration`, `sound`, `BroadcastTextId`, `comment`) VALUES (23671, 0, 0, '%s No! You will not defeat me!', 16, 0, 100, 0, 0, 0, 7798, 'combat Enrage');


DELETE FROM `smart_scripts` WHERE (`entryorguid`=23671 AND `source_type`=0);
INSERT INTO `smart_scripts` (`entryorguid`, `source_type`, `id`, `link`, `event_type`, `event_phase_mask`, `event_chance`, `event_flags`, `event_param1`, `event_param2`, `event_param3`, `event_param4`, `action_type`, `action_param1`, `action_param2`, `action_param3`, `action_param4`, `action_param5`, `action_param6`, `target_type`, `target_param1`, `target_param2`, `target_param3`, `target_x`, `target_y`, `target_z`, `target_o`, `comment`) VALUES 
(23671, 0, 0, 0, 54, 0, 100, 1, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Halfdan the Ice-Hearted - On Just Summoned - Say 0"),
(23671, 0, 1, 0, 4, 0, 100, 1, 0, 0, 0, 0, 11, 19131, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Halfdan the Ice-Hearted - On Aggro - Shield charge"),
(23671, 0, 2, 0, 2, 0, 100, 0, 0, 50, 8000, 12000, 11, 12169, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Halfdan the Ice-Hearted - In Combat - Shield Block"),
(23671, 0, 3, 0, 0, 0, 100, 0, 4000, 5000, 12000, 13000, 11, 32736, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Halfdan the Ice-Hearted - In Combat - Mortal Strike"),
(23671, 0, 4, 0, 0, 0, 100, 0, 7000, 8000, 14000, 18000, 11, 32015, 0, 0, 0, 0, 0, 2, 0, 0, 0, 0, 0, 0, 0, "Halfdan the Ice-Hearted - In Combat - Knockdown"),
(23671, 0, 5, 0, 2, 0, 100, 1, 0, 30, 0, 0, 11, 8599, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Halfdan the Ice-Hearted - In Combat - Cast 'Frost Attack'"),
(23671, 0, 6, 0, 2, 0, 100, 1, 0, 30, 0, 0, 1, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, "Halfdan the Ice-Hearted - In Combat - Cast 'Mortal Strike'");

DELETE FROM `creature_loot_template` WHERE `entry`=23661 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23661, 33314, 2, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23662 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23662, 33314, 3, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23663 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23663, 33314, 2, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23664 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23664, 33314, 2, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23665 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23665, 33314, 1.9, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23666 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23666, 33314, 1.6, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23667 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23667, 33314, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23668 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23668, 33314, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23669 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23669, 33314, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23670 AND `item`=33314;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23670, 33314, 1, 1, 0, 1, 1);

DELETE FROM `creature_loot_template` WHERE `entry`=23661 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23661, 33345, 3, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23662 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23662, 33345, 4, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23663 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23663, 33345, 2, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23664 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23664, 33345, 2, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23665 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23665, 33345, 3, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23666 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23666, 33345, 2, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23667 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23667, 33345, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23668 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23668, 33345, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23669 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23669, 33345, 1, 1, 0, 1, 1);
DELETE FROM `creature_loot_template` WHERE `entry`=23670 AND `item`=33345;
INSERT INTO `creature_loot_template` (`entry`, `item`, `ChanceOrQuestChance`, `lootmode`, `groupid`, `mincountOrRef`, `maxcount`) VALUES (23670, 33345, 1, 1, 0, 1, 1);
 
Last edited:
You must log in or register to reply here.
Top