Advertisement
Vacamagra

[FIX] [FIX] Quest 12973 The Brothers Bronzebeard

Jan 20th, 2019
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 3.42 KB | None | 0 0
  1. /*
  2. TrinityCore Quest: 12973 The Brothers Bronzebeard
  3. By Vacamagra
  4. Bugs and contact with E-mail: vacamagrac@gmail.com
  5. */
  6.  
  7. -- Quest: 12973 The Brothers Bronzebeard
  8.  
  9. DELETE FROM `creature` WHERE `id`=30382;
  10. DELETE FROM `creature_template` WHERE `entry`=30382;
  11.  
  12. INSERT INTO `creature` (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES
  13. ('144231','30382','571','0','0','1','1','0','0','7525.7','-971.724','478.799','5.63741','0','0','0','1','0','0','0','0','0','0');
  14. INSERT INTO `creature_template` (`entry`, `difficulty_entry_1`, `difficulty_entry_2`, `difficulty_entry_3`, `KillCredit1`, `KillCredit2`, `modelid1`, `modelid2`, `modelid3`, `modelid4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `exp`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `dmgschool`, `BaseAttackTime`, `RangeAttackTime`, `BaseVariance`, `RangeVariance`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `HealthModifier`, `ManaModifier`, `ArmorModifier`, `DamageModifier`, `ExperienceModifier`, `RacialLeader`, `movementId`, `RegenHealth`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `VerifiedBuild`) VALUES
  15. ('30382','0','0','0','0','0','26353','0','0','0','Brann Bronzebeard','','','0','80','80','2','35','2','1','1.14286','1','1','0','2000','2000','1','1','1','0','2048','0','0','0','0','0','0','7','4096','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','SmartAI','0','3','1','6','1','1','7.5','1','0','0','1','0','0','','12340');
  16.  
  17. DELETE FROM `smart_scripts` WHERE `entryorguid`=30382;
  18. 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
  19. ('30382','0','0','0','19','0','100','0','12973','0','0','0','80','3038200','0','0','0','0','0','1','0','0','0','0','0','0','0','Brann - On Quest Accept - action list');
  20. 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
  21. ('30382','0','1','0','1','0','100','0','4000','4000','4000','7000','11','60888','0','0','0','0','0','1','0','0','0','0','0','0','0','Brann - Ooc - Cast cosmetic movement');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement