API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 19th, 2015
210
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.74 KB | None | 0 0
raw download clone embed print report
  1. DELETE FROM gameobject WHERE id = '810835' AND position_x = '-7721.419922';
  2. DELETE FROM gameobject WHERE id = '810835' AND position_x = '-7722.939941';
  3. DELETE FROM gameobject WHERE id = '810834' AND position_x = '-7736.500000';
  4. DELETE FROM gameobject WHERE id = '810844' AND position_x = '-7735.58007';
  5. DELETE FROM gameobject WHERE id = '810839' AND position_x = '-7730.04';
  6. INSERT INTO `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
  7. (810839, 723, 0, 0, 1, 1, -7730.04, 948.522, 153.23, 0, 0, 0, 0, 1, 300, 0, 1, 0);
  8. DELETE FROM gameobject_template WHERE entry = 810857;
  9. INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `faction`, `flags`, `size`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `currencyId`, `currencyCount`, `data0`, `data1`, `data2`, `data3`, `data4`, `data5`, `data6`, `data7`, `data8`, `data9`, `data10`, `data11`, `data12`, `data13`, `data14`, `data15`, `data16`, `data17`, `data18`, `data19`, `data20`, `data21`, `data22`, `data23`, `data24`, `data25`, `data26`, `data27`, `data28`, `data29`, `data30`, `data31`, `unkInt32`, `AIName`, `ScriptName`, `WDBVerified`) VALUES
  10. (810857, 5, 4651, 'Drevo', '', '', '', 0, 0, 0.6, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', 15595);
  11. DELETE FROM game_event_gameobject where evententry = 89;
  12. DELETE FROM gameobject WHERE id = 810857;
  13. INSERT INTO `gameobject` (`id`, `map`, `zoneId`, `areaId`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES
  14. (810857, 723, 0, 0, 1, 1, -7733.92, 978.937, 153.294, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  15. (810857, 723, 0, 0, 1, 1, -7733.9, 958.889, 153.298, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  16. (810857, 723, 0, 0, 1, 1, -7725.2, 958.926, 153.297, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  17. (810857, 723, 0, 0, 1, 1, -7725.22, 978.946, 153.297, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  18. (810857, 723, 0, 0, 1, 1, -7722.16, 968.497, 147.823, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  19. (810857, 723, 0, 0, 1, 1, -7729.7, 958.891, 153.295, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  20. (810857, 723, 0, 0, 1, 1, -7722.21, 961.99, 149.191, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  21. (810857, 723, 0, 0, 1, 1, -7733.92, 978.937, 150.559, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  22. (810857, 723, 0, 0, 1, 1, -7733.92, 978.937, 147.823, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  23. (810857, 723, 0, 0, 1, 1, -7722.16, 968.497, 153.295, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  24. (810857, 723, 0, 0, 1, 1, -7722.16, 968.497, 151.927, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  25. (810857, 723, 0, 0, 1, 1, -7722.16, 968.497, 150.559, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  26. (810857, 723, 0, 0, 1, 1, -7722.16, 968.497, 149.191, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  27. (810857, 723, 0, 0, 1, 1, -7722.21, 961.99, 150.559, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  28. (810857, 723, 0, 0, 1, 1, -7729.7, 958.891, 150.559, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  29. (810857, 723, 0, 0, 1, 1, -7729.7, 958.891, 149.191, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  30. (810857, 723, 0, 0, 1, 1, -7729.7, 958.891, 147.823, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  31. (810857, 723, 0, 0, 1, 1, -7729.72, 978.989, 153.295, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  32. (810857, 723, 0, 0, 1, 1, -7729.72, 978.989, 151.927, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  33. (810857, 723, 0, 0, 1, 1, -7729.72, 978.989, 150.559, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  34. (810857, 723, 0, 0, 1, 1, -7729.72, 978.989, 149.191, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  35. (810857, 723, 0, 0, 1, 1, -7733.9, 958.889, 149.192, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  36. (810857, 723, 0, 0, 1, 1, -7733.92, 978.937, 149.191, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  37. (810857, 723, 0, 0, 1, 1, -7733.9, 958.889, 147.823, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  38. (810857, 723, 0, 0, 1, 1, -7722.21, 961.99, 147.823, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  39. (810857, 723, 0, 0, 1, 1, -7729.72, 978.989, 147.824, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  40. (810857, 723, 0, 0, 1, 1, -7722.2, 975.31, 147.824, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  41. (810857, 723, 0, 0, 1, 1, -7725.2, 958.926, 150.56, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  42. (810857, 723, 0, 0, 1, 1, -7725.2, 958.926, 151.928, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  43. (810857, 723, 0, 0, 1, 1, -7722.2, 975.31, 153.296, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  44. (810857, 723, 0, 0, 1, 1, -7722.2, 975.31, 151.928, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  45. (810857, 723, 0, 0, 1, 1, -7725.22, 978.946, 147.824, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  46. (810857, 723, 0, 0, 1, 1, -7725.22, 978.946, 149.192, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  47. (810857, 723, 0, 0, 1, 1, -7722.2, 975.31, 149.192, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  48. (810857, 723, 0, 0, 1, 1, -7733.9, 958.889, 150.561, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  49. (810857, 723, 0, 0, 1, 1, -7729.7, 958.891, 151.927, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  50. (810857, 723, 0, 0, 1, 1, -7733.9, 958.889, 151.929, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  51. (810857, 723, 0, 0, 1, 1, -7725.22, 978.946, 150.56, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  52. (810857, 723, 0, 0, 1, 1, -7725.2, 958.926, 147.823, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  53. (810857, 723, 0, 0, 1, 1, -7722.21, 961.99, 151.926, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  54. (810857, 723, 0, 0, 1, 1, -7725.2, 958.926, 149.192, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  55. (810857, 723, 0, 0, 1, 1, -7725.22, 978.946, 151.929, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  56. (810857, 723, 0, 0, 1, 1, -7722.21, 961.99, 153.294, 0, 0, 0, 0, 1, 300, 0, 1, 0),
  57. (810857, 723, 0, 0, 1, 1, -7733.92, 978.937, 151.926, 1.5718, 0, 0, 0.707462, 0.706752, 300, 0, 1, 0),
  58. (810857, 723, 0, 0, 1, 1, -7722.2, 975.31, 150.56, 0, 0, 0, 0, 1, 300, 0, 1, 0);
  59. INSERT INTO `game_event_gameobject` select 87,guid from `gameobject` WHERE id BETWEEN 810830 AND 810857;
  60. DELETE FROM creature_template WHERE entry BETWEEN 811019 AND 811022;
  61. 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`, `exp_unk`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangedattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `currencyId`, `currencyCount`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Mana_mod_extra`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `ReactState`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  62. (811019, 0, 0, 0, 0, 0, 29827, 0, 0, 0, 'Spawner', NULL, NULL, 0, 1, 1, 0, 0, 35, 0, 1, 1.14286, 1.5, 0, 0, 0, 0, 0, 1, 0, 0, 1, 33554432, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1048576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 4, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 0, 128, '', 1),
  63. (811020, 0, 0, 0, 0, 0, 29827, 0, 0, 0, 'Spawner', NULL, NULL, 0, 1, 1, 0, 0, 35, 0, 1, 1.14286, 1.5, 0, 0, 0, 0, 0, 1, 0, 0, 1, 33554432, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1048576, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 4, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 0, 128, '', 1),
  64. (811021, 0, 0, 0, 0, 0, 37157, 0, 0, 0, 'Portovnice Parma', NULL, NULL, 0, 1, 1, 0, 0, 35, 1, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 4, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 0, 128, '', 1),
  65. (811022, 0, 0, 0, 0, 0, 33639, 0, 0, 0, 'Mushroom', '', '', 0, 80, 80, 2, 0, 35, 1, 1, 1.57143, 0.05, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 4, 1, 3.96825, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 157, 1, 2, 0, 0, '', 15595);
  66. DELETE FROM game_event_creature where evententry = 87;
  67. DELETE FROM creature WHERE id IN (811019,811021,811022);
  68. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `dynamicflags`, `zoneId`, `areaId`) VALUES
  69. (811019, 723, 1, 1, 0, 0, -7735.32, 964.202, 146.785, 0, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0, 0),
  70. (811019, 723, 1, 1, 0, 0, -7735.32, 973.54, 146.785, 0, 300, 0, 0, 42, 0, 0, 0, 0, 0, 0, 0, 0),
  71. (811021, 723, 1, 1, 0, 0, -7794.52, 962.604, 141.5, 1.53153, 300, 0, 0, 42, 0, 0, 0, 33554432, 0, 0, 0, 0),
  72. (811022, 723, 1, 1, 0, 0, -7732.09, 986.04, 131.407, 3.33396, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  73. (811022, 723, 1, 1, 0, 0, -7731.25, 974.89, 131.408, 1.88098, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  74. (811022, 723, 1, 1, 0, 0, -7725.37, 979.795, 131.408, 4.88512, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  75. (811022, 723, 1, 1, 0, 0, -7727.4, 985.175, 131.408, 1.37832, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  76. (811022, 723, 1, 1, 0, 0, -7733.25, 981.464, 131.408, 1.64143, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  77. (811022, 723, 1, 1, 0, 0, -7726.37, 953.42, 131.407, 6.27133, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  78. (811022, 723, 1, 1, 0, 0, -7733.86, 977.324, 131.408, 1.81814, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  79. (811022, 723, 1, 1, 0, 0, -7733.07, 965.627, 131.408, 4.81051, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  80. (811022, 723, 1, 1, 0, 0, -7733.95, 968.982, 131.408, 1.41366, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  81. (811022, 723, 1, 1, 0, 0, -7730.45, 947.082, 131.408, 4.98329, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  82. (811022, 723, 1, 1, 0, 0, -7735.15, 956.97, 131.408, 5.19535, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  83. (811022, 723, 1, 1, 0, 0, -7728.71, 955.13, 131.408, 3.85624, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  84. (811022, 723, 1, 1, 0, 0, -7726.31, 971.827, 131.408, 1.48041, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  85. (811022, 723, 1, 1, 0, 0, -7728.92, 966.635, 131.408, 2.59175, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  86. (811022, 723, 1, 1, 0, 0, -7726.63, 964.25, 131.408, 4.95972, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  87. (811022, 723, 1, 1, 0, 0, -7724.75, 967.414, 131.408, 6.15352, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  88. (811022, 723, 1, 1, 0, 0, -7727.59, 959.996, 131.407, 1.13798, 300, 0, 0, 50000, 0, 0, 0, 0, 0, 0, 0, 0),
  89. (811022, 723, 1, 1, 0, 0, -7623.3, 812.197, 138.063, 1.5708, 300, 0, 0, 4, 0, 0, 0, 33554432, 0, 0, 0, 0),
  90. (811022, 723, 1, 1, 0, 0, -7623.3, 812.197, 137.491, 1.5708, 300, 0, 0, 4, 0, 0, 0, 33554432, 0, 0, 0, 0),
  91. (811022, 723, 1, 1, 0, 0, -7623.3, 812.197, 136.918, 1.5708, 300, 0, 0, 4, 0, 0, 0, 33554432, 0, 0, 0, 0),
  92. (811022, 723, 1, 1, 0, 0, -7623.3, 812.197, 136.311, 1.5708, 300, 0, 0, 4, 0, 0, 0, 33554432, 0, 0, 0, 0),
  93. (811022, 723, 1, 1, 0, 0, -7623.3, 812.197, 135.684, 1.5708, 300, 0, 0, 4, 0, 0, 0, 33554432, 0, 0, 0, 0);
  94. DELETE FROM smart_scripts WHERE entryorguid in (811002,811003,811010,811011,811021,811022);
  95. 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
  96. (811002, 0, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, ''),
  97. (811002, 0, 1, 0, 64, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 811004, 0, 70, 0, 0, 0, 0, ''),
  98. (811002, 0, 2, 0, 64, 0, 100, 0, 0, 0, 0, 0, 28, 64328, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  99. (811002, 0, 3, 0, 64, 0, 100, 0, 0, 0, 0, 0, 75, 64328, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  100. (811002, 0, 4, 0, 64, 0, 100, 0, 0, 0, 0, 0, 28, 64328, 0, 0, 0, 0, 0, 19, 811003, 10, 0, 0, 0, 0, 0, ''),
  101. (811002, 0, 5, 0, 64, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 811020, 0, 60, 0, 0, 0, 0, ''),
  102. (811003, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 75, 64328, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  103. (811003, 0, 1, 0, 64, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 811005, 0, 100, 0, 0, 0, 0, ''),
  104. (811003, 0, 2, 0, 64, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, ''),
  105. (811003, 0, 3, 0, 64, 0, 100, 0, 0, 0, 0, 0, 28, 64328, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  106. (811003, 0, 4, 0, 64, 0, 100, 0, 0, 0, 0, 0, 75, 64328, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  107. (811003, 0, 5, 0, 64, 0, 100, 0, 0, 0, 0, 0, 28, 64328, 0, 0, 0, 0, 0, 19, 811002, 10, 0, 0, 0, 0, 0, ''),
  108. (811003, 0, 6, 0, 64, 0, 100, 0, 0, 0, 0, 0, 45, 1, 1, 0, 0, 0, 0, 9, 811019, 0, 60, 0, 0, 0, 0, ''),
  109. (811010, 0, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, ''),
  110. (811010, 0, 1, 0, 64, 0, 100, 0, 0, 0, 0, 0, 12, 811011, 3, 900000, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, ''),
  111. (811011, 0, 1, 0, 1, 0, 100, 0, 5000, 5000, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  112. (811011, 0, 2, 0, 27, 0, 100, 0, 0, 0, 0, 0, 44, 1, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  113. (811011, 0, 3, 0, 28, 1, 100, 0, 1, 1, 0, 0, 28, 42146, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  114. (811011, 0, 4, 0, 28, 1, 100, 0, 1, 1, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  115. (811021, 0, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 62, 723, 0, 0, 0, 0, 0, 17, 5, 80, 0, -7729.56, 970.869, 154, 1.61, ''),
  116. (811021, 0, 1, 0, 64, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, ''),
  117. (811022, 0, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, ''),
  118. (811022, 0, 1, 0, 64, 0, 100, 0, 0, 0, 0, 0, 62, 723, 0, 0, 0, 0, 0, 7, 0, 0, 0, -7729.56, 970.869, 155, 1.61, ''),
  119. (811019, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 12, 811020, 3, 1800000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  120. (811019, 0, 1, 0, 38, 0, 100, 0, 1, 1, 0, 0, 45, 1, 1, 0, 0, 0, 0, 19, 811020, 4, 0, 0, 0, 0, 0, ''),
  121. (811019, 0, 2, 0, 38, 0, 100, 0, 1, 1, 0, 0, 12, 811020, 3, 1800000, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  122. (811020, 0, 0, 0, 1, 0, 100, 1, 0, 0, 0, 0, 50, 810832, 1800000, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, ''),
  123. (811020, 0, 1, 0, 38, 0, 100, 0, 1, 1, 0, 0, 41, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, '');
  124. INSERT INTO game_event_creature select 89,guid from creature WHERE id BETWEEN 811000 AND 811022;
  125. DELETE FROM npc_text WHERE ID = 49947;
  126. INSERT INTO `npc_text` (`ID`, `text0_0`, `text0_1`, `lang0`, `prob0`, `em0_0`, `em0_1`, `em0_2`, `em0_3`, `em0_4`, `em0_5`, `text1_0`, `text1_1`, `lang1`, `prob1`, `em1_0`, `em1_1`, `em1_2`, `em1_3`, `em1_4`, `em1_5`, `text2_0`, `text2_1`, `lang2`, `prob2`, `em2_0`, `em2_1`, `em2_2`, `em2_3`, `em2_4`, `em2_5`, `text3_0`, `text3_1`, `lang3`, `prob3`, `em3_0`, `em3_1`, `em3_2`, `em3_3`, `em3_4`, `em3_5`, `text4_0`, `text4_1`, `lang4`, `prob4`, `em4_0`, `em4_1`, `em4_2`, `em4_3`, `em4_4`, `em4_5`, `text5_0`, `text5_1`, `lang5`, `prob5`, `em5_0`, `em5_1`, `em5_2`, `em5_3`, `em5_4`, `em5_5`, `text6_0`, `text6_1`, `lang6`, `prob6`, `em6_0`, `em6_1`, `em6_2`, `em6_3`, `em6_4`, `em6_5`, `text7_0`, `text7_1`, `lang7`, `prob7`, `em7_0`, `em7_1`, `em7_2`, `em7_3`, `em7_4`, `em7_5`, `VerifiedBuild`) VALUES
  127. (49947, 'Event Krabicky:\r\n\r\nV Eventu vyhrava ten, kdo zustane jako posledni na plosine z krabicek. \r\n\r\nJakmile si doctete pravidla, vemte si od Gnoma zebru, na kterou nasednete.\r\n\r\nKdyz budou vsichni na zebrach, spawnou se bednicky na ktere vjedete a cekate na odpocet, po nem se Vase zebra rozbehne a nepujde zastavit, take se zacnou nahodne despawnovat bednicky. Jak jiz bylo zmineno, Vasim cilem je tedy klickovat mezi bednickami a snazit se udrzet co nejdele.\r\n\r\nPokud se propadnete pod krabice vypadavate. Kliknete na zlutou houbu, ta Vas portne na tribunu, kde muzete pockat na dalsi kolo.\r\n\r\nDespawnovani beden muze beden muze byt dvojiho druhu. Bud se bedna despawne nahodne a bez varovani, nebo do ni uderi blesk, objevi se nad ni sipka a az potom se despawne. EM Vam na zacatku kola sdeli, jak se budou bedny despawnovat.\r\n\r\nEvent muze byt tedy na vice kol.\r\n\r\nJe zakazano zustat na teto plosine a schodech po odpoctu.\r\nJe zakazano byt zaseknu do neviditelne zdi ve stredu plosiny a nepohybovat se tedy.\r\n\r\nPokud mate nejake dotazy, pokladejte je rovnou do chatu (nepiste \"Em, mam dotaz!\" ale \"Em, co mam delat kdyz jsem nakazen Neisseriou gonorrhoeou\"?)\r\n\r\nTvurce Eventu: Rakesh\r\n\r\nVerze: 19.4.2015\r\n', 'Event Krabicky:\r\n\r\nV Eventu vyhrava ten, kdo zustane jako posledni na plosine z krabicek. \r\n\r\nJakmile si doctete pravidla, vemte si od Gnoma zebru, na kterou nasednete.\r\n\r\nKdyz budou vsichni na zebrach, spawnou se bednicky na ktere vjedete a cekate na odpocet, po nem se Vase zebra rozbehne a nepujde zastavit, take se zacnou nahodne despawnovat bednicky. Jak jiz bylo zmineno, Vasim cilem je tedy klickovat mezi bednickami a snazit se udrzet co nejdele.\r\n\r\nPokud se propadnete pod krabice vypadavate. Kliknete na zlutou houbu, ta Vas portne na tribunu, kde muzete pockat na dalsi kolo.\r\n\r\nDespawnovani beden muze beden muze byt dvojiho druhu. Bud se bedna despawne nahodne a bez varovani, nebo do ni uderi blesk, objevi se nad ni sipka a az potom se despawne. EM Vam na zacatku kola sdeli, jak se budou bedny despawnovat.\r\n\r\nEvent muze byt tedy na vice kol.\r\n\r\nJe zakazano zustat na teto plosine a schodech po odpoctu.\r\nJe zakazano byt zaseknu do neviditelne zdi ve stredu plosiny a nepohybovat se tedy.\r\n\r\nPokud mate nejake dotazy, pokladejte je rovnou do chatu (nepiste \"Em, mam dotaz!\" ale \"Em, co mam delat kdyz jsem nakazen Neisseriou gonorrhoeou\"?)\r\n\r\nTvurce Eventu: Rakesh\r\n\r\nVerze: 19.4.2015\r\n', 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, 0, 0, 0, 0, 0, 0, 0, 0, 0);
  128.  
  129. UPDATE creature_template SET modelid1 = '29827' WHERE entry IN (810471,810473,810470,810506,810466,810482);
  130. UPDATE creature_template SET unit_flags = '33554432' WHERE entry IN (810471,810473,810470,810506,810466,810482);
  131. UPDATE creature_template SET type_flags = '1048576' WHERE entry IN (810471,810473,810470,810506,810466,810482);
  132. DELETE FROM smart_scripts WHERE entryorguid = 810462 AND id BETWEEN 20 AND 30;
  133. 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
  134. (810462, 0, 20, 0, 62, 0, 100, 0, 49989, 0, 0, 0, 75, 110154, 0, 0, 0, 0, 0, 9, 810463, 0, 99, 0, 0, 0, 0, ''),
  135. (810462, 0, 21, 0, 62, 0, 100, 0, 49989, 0, 0, 0, 75, 110154, 0, 0, 0, 0, 0, 9, 810480, 0, 99, 0, 0, 0, 0, ''),
  136. (810462, 0, 22, 0, 62, 0, 100, 0, 49989, 0, 0, 0, 75, 110154, 0, 0, 0, 0, 0, 9, 810481, 0, 99, 0, 0, 0, 0, ''),
  137. (810462, 0, 23, 0, 62, 0, 100, 0, 49989, 0, 0, 0, 75, 110154, 0, 0, 0, 0, 0, 9, 810482, 0, 99, 0, 0, 0, 0, ''),
  138. (810462, 0, 24, 0, 62, 0, 100, 0, 49989, 0, 0, 0, 75, 110154, 0, 0, 0, 0, 0, 9, 810483, 0, 99, 0, 0, 0, 0, ''),
  139. (810462, 0, 25, 0, 62, 0, 100, 0, 49989, 0, 0, 0, 75, 110154, 0, 0, 0, 0, 0, 9, 810484, 0, 99, 0, 0, 0, 0, ''),
  140. (810462, 0, 26, 0, 62, 0, 100, 0, 49989, 0, 0, 0, 75, 110154, 0, 0, 0, 0, 0, 9, 810485, 0, 99, 0, 0, 0, 0, ''),
  141. (810462, 0, 27, 0, 62, 0, 100, 0, 49989, 0, 0, 0, 75, 110154, 0, 0, 0, 0, 0, 9, 810486, 0, 99, 0, 0, 0, 0, ''),
  142. (810462, 0, 27, 0, 62, 0, 100, 0, 49989, 0, 0, 0, 75, 110154, 0, 0, 0, 0, 0, 9, 810494, 0, 99, 0, 0, 0, 0, ''),
  143. DELETE FROM creature_template WHERE entry = 810523;
  144. 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`, `exp_unk`, `faction`, `npcflag`, `speed_walk`, `speed_run`, `scale`, `rank`, `mindmg`, `maxdmg`, `dmgschool`, `attackpower`, `dmg_multiplier`, `baseattacktime`, `rangedattacktime`, `unit_class`, `unit_flags`, `unit_flags2`, `dynamicflags`, `family`, `trainer_type`, `trainer_class`, `trainer_race`, `minrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `type_flags2`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `spell5`, `spell6`, `spell7`, `spell8`, `PetSpellDataId`, `VehicleId`, `mingold`, `maxgold`, `currencyId`, `currencyCount`, `AIName`, `MovementType`, `InhabitType`, `HoverHeight`, `Health_mod`, `Mana_mod`, `Mana_mod_extra`, `Armor_mod`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `ReactState`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`, `WDBVerified`) VALUES
  145. (810523, 0, 0, 0, 0, 0, 37157, 0, 0, 0, 'Portovnice Parma', NULL, NULL, 0, 1, 1, 0, 0, 35, 1, 1, 1.14286, 1, 0, 0, 0, 0, 0, 1, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'SmartAI', 0, 4, 1, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 1, 2, 0, 128, '', 1);
  146. DELETE FROM game_event_creature where evententry = 74;
  147. DELETE FROM creature WHERE id = 810523;
  148. INSERT INTO `creature` (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `unit_flags2`, `dynamicflags`, `zoneId`, `areaId`) VALUES
  149. (810523, 723, 1, 1, 0, 0, -7787.038574, 1214.631470, 136.359726, 2.251637, 300, 0, 0, 42, 0, 0, 0, 33554432, 0, 0, 0, 0);
  150. DELETE FROM smart_scripts WHERE entryorguid = 810523;
  151. 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
  152. (810523, 0, 0, 0, 64, 0, 100, 0, 0, 0, 0, 0, 62, 723, 0, 0, 0, 0, 0, 17, 5, 80, 0, -7769.56, 1232.869, 138, 0.67, ''),
  153. (810523, 0, 1, 0, 64, 0, 100, 0, 0, 0, 0, 0, 72, 0, 0, 0, 0, 0, 0, 7, 0, 0, 0, 0, 0, 0, 0, '');
  154. DELETE FROM gameobject WHERE id = 810508;
  155. INSERT INTO game_event_creature select 74,guid from creature WHERE id BETWEEN 810460 AND 810523;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
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!