Advertisement
Guest User

Untitled

a guest
May 26th, 2017
57
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 9.14 KB | None | 0 0
  1. -- Mr. Gossip universal NPC.
  2. -- By DoomKiller.
  3. -- Ha kérdésed van, akkor tedd fel wowemufon.
  4.  
  5. DELETE FROM `creature_template` WHERE `entry` = 60000;
  6. INSERT INTO `creature_template`
  7.     (`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`)
  8. VALUES
  9. (60000, 0, 0, 0, 0, 0, 20987, 0, 0, 0, 'Mr. Gossip', 'The Incredible', NULL, 60000, 90, 90, 0, 35, 35, 1, 1, 2, 1, 2, 45000, 65000, 0, 0, 1, 1400, 1400, 1, 4096, 0, 0, 0, 0, 0, 0, 1, 2, 100, 10, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 7, 45000, 0, 5000, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, '', 0);
  10.  
  11.  
  12. DELETE FROM `gossip_menu_option` WHERE `id` BETWEEN 60000 AND 60048;
  13. INSERT INTO `gossip_menu_option`
  14.     (`menu_id`, `id`, `option_icon`, `option_text`, `option_id`, `npc_option_npcflag`, `action_menu_id`, `action_poi_id`, `action_script_id`, `box_coded`, `box_money`, `box_text`, `cond_1`, `cond_1_val_1`, `cond_1_val_2`, `cond_2`, `cond_2_val_1`, `cond_2_val_2`, `cond_3`, `cond_3_val_1`, `cond_3_val_2`)
  15. VALUES
  16. (60000, 60047, 4, 'Remove Ressurection Sickness', 1, 1, 60000, 0, 60036, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  17. (60000, 60048, 4, 'Remove Deserter', 1, 1, 60000, 0, 60037, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  18. (60000, 60035, 0, 'Buffok', 1, 1, 60006, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  19. (60006, 60046, 4, '[Vissza]', 1, 1, 60000, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  20. (60006, 60045, 4, 'Shadow Protection', 1, 1, 60006, 0, 60035, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  21. (60006, 60044, 4, 'Power Word: Fortitude', 1, 1, 60006, 0, 60034, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  22. (60006, 60043, 4, 'Divine Spirit', 1, 1, 60006, 0, 60033, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  23. (60006, 60042, 4, 'Blessing of Wisdom', 1, 1, 60006, 0, 60031, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  24. (60006, 60041, 4, 'Blessing of Kings', 1, 1, 60006, 0, 60030, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  25. (60006, 60040, 4, 'Blessing of Might', 1, 1, 60006, 0, 60029, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  26. (60006, 60039, 4, 'Arcane Intellect', 1, 1, 60006, 0, 60028, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  27. (60006, 60038, 4, 'Thorns', 1, 1, 60006, 0, 60027, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  28. (60006, 60037, 4, 'Mark of the Wild', 1, 1, 60006, 0, 60026, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  29. (60006, 60036, 4, 'Heal', 1, 1, 60006, 0, 60025, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  30. (60001, 60014, 4, '[Vissza]', 1, 1, 60000, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  31. (60001, 60013, 0, 'Northrend Locations', 1, 1, 60005, 0, 0, 0, 0, 'Rendelkezel WotLk-al?', 0, 0, 0, 0, 0, 0, 0, 0, 0),
  32. (60005, 60034, 4, '[Vissza]', 1, 1, 60001, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  33. (60005, 60032, 4, 'Teleport to Sholazar Basin', 1, 1, 0, 0, 60023, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  34. (60005, 60031, 4, 'Teleport to Wintergrasp', 1, 1, 0, 0, 60022, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  35. (60005, 60030, 4, 'Teleport to Dragonblight', 1, 1, 0, 0, 60021, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  36. (60005, 60029, 4, 'Teleport to Icecrown', 1, 1, 0, 0, 60020, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  37. (60005, 60028, 4, 'Teleport to Dalaran', 1, 1, 0, 0, 60019, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  38. (60005, 60027, 4, 'Teleport to Storm Peaks', 1, 1, 0, 0, 60018, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  39. (60005, 60026, 4, 'Teleport to Zul\'Drak', 1, 1, 0, 0, 60017, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  40. (60005, 60025, 4, 'Teleport to Grizzly Hills', 1, 1, 0, 0, 60016, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  41. (60005, 60024, 4, 'Teleport to Howling Fjord', 1, 1, 0, 0, 60015, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  42. (60005, 60033, 4, 'Teleport to Borean Tundra', 1, 1, 0, 0, 60024, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  43. (60001, 60015, 0, 'Outland Locations', 1, 1, 60004, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  44. (60004, 60023, 4, '[Vissza]', 1, 1, 60001, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  45. (60004, 60022, 4, 'Teleport to Netherstorm', 1, 1, 0, 0, 60014, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  46. (60004, 60021, 4, 'Teleport to Blade\'s Edge Mountains', 1, 1, 0, 0, 60013, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  47. (60004, 60020, 4, 'Teleport to Hellfire Peninsula', 1, 1, 0, 0, 60012, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  48. (60004, 60019, 4, 'Teleport to Zangarmarsh', 1, 1, 0, 0, 60011, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  49. (60004, 60018, 4, 'Teleport to Nagrand', 1, 1, 0, 0, 60010, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  50. (60004, 60017, 4, 'Teleport to Shadowmoon Valley', 1, 1, 0, 0, 60009, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  51. (60004, 60016, 4, 'Teleport to Shattrath', 1, 1, 0, 0, 60008, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  52. (60001, 60002, 0, 'Alliance Locations', 1, 1, 60003, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  53. (60003, 60012, 4, '[Vissza]', 1, 1, 60001, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  54. (60003, 60010, 4, 'Teleport to Darnassus', 1, 1, 0, 0, 60007, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  55. (60003, 60009, 4, 'Teleport to Exodar', 1, 1, 0, 0, 60006, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  56. (60003, 60008, 4, 'Teleport to Ironforge', 1, 1, 0, 0, 60005, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  57. (60003, 60007, 4, 'Teleport to Stormwind', 1, 1, 0, 0, 60004, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  58. (60001, 60001, 0, 'Horde Locations', 1, 1, 60002, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  59. (60002, 60011, 4, '[Vissza]', 1, 1, 60001, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  60. (60002, 60006, 4, 'Teleport to Thunder Bluff', 1, 1, 0, 0, 60003, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  61. (60002, 60005, 4, 'Teleport to Silvermoon', 1, 1, 0, 0, 60002, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  62. (60002, 60004, 4, 'Teleport to Undercity', 1, 1, 0, 0, 60001, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  63. (60002, 60003, 4, 'Teleport to Orgrimmar', 1, 1, 0, 0, 60000, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0),
  64. (60000, 60000, 0, 'Teleportok', 1, 1, 60001, 0, 0, 0, 0, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  65.  
  66.  
  67. DELETE FROM `gossip_scripts` WHERE `id` BETWEEN 60000 AND 60037;
  68. INSERT INTO `gossip_scripts`
  69.     (`id`, `delay`, `command`, `datalong`, `datalong2`, `dataint`, `x`, `y`, `z`, `o`)
  70. VALUES
  71. (60000, 0, 6, 1, 0, 0, 1629.36, -4373.39, 31.4829, 3.54839),
  72. (60001, 0, 6, 0, 1, 0, 1583.08, 240.35, -52.157, 6.27764),
  73. (60001, 0, 6, 0, 0, 0, 1583.08, 0, 0, 0),
  74. (60002, 0, 6, 530, 0, 0, 6.27764, 0, 0, 0),
  75. (60003, 0, 6, 1, 0, 0, -1277.37, 124.804, 131.287, 5.22274),
  76. (60004, 0, 6, 0, 0, 0, -8833.38, 628.628, 94.0065, 1.06535),
  77. (60005, 0, 6, 0, 0, 0, -4918.88, -940.406, 501.564, 5.42347),
  78. (60006, 0, 6, 530, 0, 0, -3965.7, -11653.6, -138.844, 0.852154),
  79. (60007, 0, 6, 1, 0, 0, 9951.8, 2280.28, 1341.39, 1.59085),
  80. (60008, 0, 6, 530, 0, 0, -1835.36, 5304.86, -12.428, 1.61377),
  81. (60009, 0, 6, 530, 0, 0, -2998.66, 2568.9, 76.6306, 0.805772),
  82. (60010, 0, 6, 530, 0, 0, -1145.95, 0, 0, 0),
  83. (60011, 0, 6, 530, 0, 0, -54.8621, 5813.44, 20.6057, 0.081722),
  84. (60012, 0, 6, 530, 0, 0, -211.237, 4278.54, 86.5678, 4.59776),
  85. (60013, 0, 6, 530, 0, 0, 3037.11, 5962.71, 130.774, 1.10847),
  86. (60014, 0, 6, 530, 0, 0, 3830.23, 3426.5, 88.6135, 5.16677),
  87. (60015, 0, 6, 571, 0, 0, 1912.49, -4878.15, 172.683, 3.38546),
  88. (60016, 0, 6, 571, 0, 0, 4392.23, -3587.69, 238.449, 0),
  89. (60017, 0, 6, 571, 0, 0, 5560.23, -3211.66, 371.708, 0),
  90. (60018, 0, 6, 571, 0, 0, 7527.14, -1260.89, 919.049, 2.0696),
  91. (60019, 0, 6, 571, 0, 0, 5804.15, 624.771, 647.767, 1.64),
  92. (60020, 0, 6, 571, 0, 0, 7253.64, 1644.78, 433.68, 5.36775),
  93. (60021, 0, 6, 571, 0, 0, 4103.36, 264.478, 50.5019, 3.09349),
  94. (60022, 0, 6, 571, 0, 0, 4760.7, 2143.7, 422.943, 1.13),
  95. (60023, 0, 6, 571, 0, 0, 5323, 4942, -133.557, 2.17),
  96. (60024, 0, 6, 571, 0, 0, 3256.57, 5278.23, 40.8046, 0.246367),
  97. (60025, 0, 15, 26565, 1, 0, 0, 0, 0, 0),
  98. (60026, 0, 15, 48469, 1, 0, 0, 0, 0, 0),
  99. (60027, 0, 15, 53307, 1, 0, 0, 0, 0, 0),
  100. (60028, 0, 15, 42995, 1, 0, 0, 0, 0, 0),
  101. (60029, 0, 15, 48932, 1, 0, 0, 0, 0, 0),
  102. (60030, 0, 15, 20217, 1, 0, 0, 0, 0, 0),
  103. (60031, 0, 15, 48936, 1, 0, 0, 0, 0, 0),
  104. (60033, 0, 15, 48073, 1, 0, 0, 0, 0, 0),
  105. (60034, 0, 15, 48161, 1, 0, 0, 0, 0, 0),
  106. (60035, 0, 15, 48169, 1, 0, 0, 0, 0, 0),
  107. (60036, 0, 14, 15007, 1, 0, 0, 0, 0, 0),
  108. (60037, 0, 14, 26013, 1, 0, 0, 0, 0, 0);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement