Guest User

Untitled

a guest
Oct 21st, 2017
71
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.88 KB | None | 0 0
  1. UPDATE `creature_template` SET `npcflag` = '16777216', `spell1` = '48558', `spell2` = '48604', `spell3` = '48548', `spell4` = '48610' WHERE `entry` = '27354';
  2. DELETE FROM `creature_template_addon` WHERE `entry` = '27354';
  3. INSERT INTO `creature_template_addon` (`entry`, `path_id`, `mount`, `bytes1`, `bytes2`, `emote`, `auras`) VALUES ('27354', '0', '0', '0', '0', '0', '48456');
  4. DELETE FROM `npc_spellclick_spells` WHERE `npc_entry` = '27354';
  5. INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`) VALUES ('27354', '48533', '12270', '1', '12270', '1');
  6. DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId` = '13' AND `SourceEntry` = '48610';
  7. INSERT INTO `conditions` (`SourceTypeOrReferenceId`, `SourceEntry`, `ConditionTypeOrReference`, `ConditionValue1`, `ConditionValue2`) VALUES ('13', '48610', '18', '1', '27423');
Add Comment
Please, Sign In to add comment