API tools faq
paste
Guest User

Untitled

a guest
Jun 19th, 2018
92
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.42 KB | None | 0 0
raw download clone embed print report
  1.  
  2. -- Quest: Vile Like Fire!
  3. -- NPC
  4. SET @NPC_NPROTO_DRAKE_13071 := 30270; -- Njorndar Proto-Drake
  5. SET @VEHICLE_NPROTO_DRAKE_13071 := 30564; -- Vehicle Njorndar Proto-Drake
  6. SET @NPC_BUNNY_TARGET_13071 := 30576; -- Vile Like Fire! Kill Credit Bunny
  7. -- Gameobject
  8. SET @GO_FIRE_13071 := 900001; -- medium fire
  9. -- Spells
  10. SET @SPELL_STJOBUILDING_13071 := 7769; -- Strafe Jotunheim Building
  11. SET @SPELL_BOSPEED_13071 := 57493; -- Burst of Speed
  12.  
  13. -- Fire
  14. DELETE FROM `gameobject_template` WHERE `entry`= @GO_FIRE_13071;
  15. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `AIName`, `ScriptName`, `WDBVerified`) VALUES
  16. (@GO_FIRE_13071, 5, 5751, 'Cosmetic Object - Fire Large', '', '', '', 0, 0, 3, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 12340);
  17.  
  18. -- Njorndar Proto-Drake
  19. UPDATE `creature_template` SET `npcflag` =16777216, `VehicleId` =247 WHERE `entry`=@NPC_NPROTO_DRAKE_13071;
  20. DELETE FROM `npc_spellclick_spells` WHERE `npc_entry`= @NPC_NPROTO_DRAKE_13071;
  21. INSERT INTO `npc_spellclick_spells` (`npc_entry`, `spell_id`, `quest_start`, `quest_start_active`, `quest_end`, `cast_flags`, `aura_required`, `aura_forbidden`, `user_type`) VALUES
  22. (@NPC_NPROTO_DRAKE_13071, 57401, 13071, 1, 13071, 1, 0, 0, 0);
  23.  
  24. -- Vehicle Njorndar Proto-Drake
  25. DELETE FROM `creature_template` WHERE `entry`= @VEHICLE_NPROTO_DRAKE_13071;
  26. 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_A`, `faction_H`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangeattacktime`, `unit_class`, `unit_flags`, `dynamicflags`, `family`, `trainer_type`, `trainer_spell`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `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`, `Health_mod`, `Mana_mod`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  27. (@VEHICLE_NPROTO_DRAKE_13071, 0, 0, 0, 0, 0, 26882, 0, 0, 0, 'Njorndar Proto-Drake', '', 'vehichleCursor', 0, 1, 1, 0, 35, 35, 0, 1, 1.14286, 1, 1, 2, 2, 0, 24, 7.5, 2000, 0, 1, 2, 8, 0, 0, 0, 0, 0, 1, 1, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 247, 0, 0, 'SmartAI', 0, 5, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 180, 1, 0, 0, 0, '', 12340);
  28. -- SAI
  29. DELETE FROM `smart_scripts` WHERE `entryorguid`= @VEHICLE_NPROTO_DRAKE_13071;
  30. 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
  31. (@VEHICLE_NPROTO_DRAKE_13071, 0, 0, 0, 54, 0, 100, 0, 0, 0, 0, 0, 60, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Njorndar Proto-Drake - On Summon - Set Fly');
  32. DELETE FROM `mq_vehicle_data` WHERE `entry`= 247;
  33. INSERT INTO `mq_vehicle_data` (`entry`, `flags`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `spell9`, `spell10`, `linked_auras`, `speed_walk`, `speed_run`, `speed_run_back`, `speed_swim`, `speed_swim_back`, `speed_turn_rate`, `speed_flight`, `speed_flight_back`, `speed_pitch_rate`) VALUES
  34. (247, 0, @SPELL_BOSPEED_13071, 0, @SPELL_STJOBUILDING_13071, 0, 0, 0, 0, 0, 0, 0, '', 1, 1, 1, 1, 1, 1, 3, 1, 1);
  35.  
  36. -- Vile Like Fire! Kill Credit Bunny
  37. UPDATE `creature_template` SET `AIName`= 'SmartAI' WHERE `entry`= @NPC_BUNNY_TARGET_13071;
  38. DELETE FROM `smart_scripts` WHERE `entryorguid`= @NPC_BUNNY_TARGET_13071;
  39. 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
  40. (@NPC_BUNNY_TARGET_13071, 0, 0, 0, 8, 0, 100, 0, 7769, 0, 5000, 5000, 33, @NPC_BUNNY_TARGET_13071, 0, 0, 0, 0, 0, 18, 70, 0, 0, 0, 0, 0, 0, 'Bunny - On Spellhit - Give Kill kredit'),
  41. (@NPC_BUNNY_TARGET_13071, 0, 1, 0, 8, 0, 100, 0, 7769, 0, 30000, 30000, 50, @GO_FIRE_13071, 30, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 'Bunny - On Spellhit - Summon Fire');
  42.  
  43. -- Strafe Jotunheim Building deffine target
  44. DELETE FROM `conditions` WHERE `SourceEntry`= @SPELL_STJOBUILDING_13071;
  45. INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`ConditionTypeOrReference`,`ConditionValue1`,`ConditionValue2`) VALUES
  46. (13,0,@SPELL_STJOBUILDING_13071,18,1,@NPC_BUNNY_TARGET_13071);
  47. -- Strafe Jotunheim Building and Burst of Speed inner cd
  48. DELETE FROM `spell_proc_event` WHERE `entry` IN (@SPELL_STJOBUILDING_13071, @SPELL_BOSPEED_13071);
  49. INSERT INTO `spell_proc_event` (`entry`, `SchoolMask`, `SpellFamilyName`, `SpellFamilyMask0`, `SpellFamilyMask1`, `SpellFamilyMask2`, `procFlags`, `procEx`, `ppmRate`, `CustomChance`, `Cooldown`) VALUES
  50. (@SPELL_STJOBUILDING_13071, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.5),
  51. (@SPELL_BOSPEED_13071, 0, 0, 0, 0, 0, 0, 0, 0, 0, 30);
  52.  
  53. -- Dismounted on leave Area
  54. DELETE FROM `mq_vehicle_conditions` WHERE `entry`= 247;
  55. INSERT INTO `mq_vehicle_conditions` (`entry`, `conditionType`, `conditionValue`) VALUES
  56. (247, 6, 4526);
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!