Advertisement
Guest User

Untitled

a guest
Jun 22nd, 2017
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 14.39 KB | None | 0 0
  1. -- "World Jump Event"--
  2. -- Complete: 25% --
  3. -- Event Coordinate & Teleport Coordinate --
  4. Map: 0 (Eastern Kingdoms) Zone: 3 (Badlands) Area: 341 (Camp Kosh) Phase: 1
  5. X: -6269.412109 Y: -3737.725098 Z: 245.676178 Orientation: 0.491973
  6. grid[20,24]cell[1,7] InstanceID: 0
  7.  ZoneX: 66.675720 ZoneY: 22.904264
  8. GroundZ: 245.675690 FloorZ: 245.675690 Have height DATA (Map: 1 VMap: 1)
  9. -- GO "Reward" Coordinate --
  10. [Cache OF Living Stone] GUID: 40129 ID: 195046
  11. Map: 0 (Eastern Kingdoms) Zone: 3 (Badlands) Area: 1898 (Dustwind Gulch) Phase: 1
  12. X: -6349.533203 Y: -3811.443115 Z: 340.866211 Orientation: 0.308978
  13. grid[20,24]cell[0,6] InstanceID: 0
  14.  ZoneX: 69.639259 ZoneY: 27.735687
  15. GroundZ: 340.866547 FloorZ: 340.866547 Have height DATA (Map: 1 VMap: 1)
  16.  
  17. -- Some GO; Box &  Brazier & NPC --
  18. [Blight Crystal Box] GUID: 200001 ID: 190946
  19. [Brazier] GUID: 70142 ID: 186128
  20. [Brewfest Canopy] GUID: 25520 ID: 186680
  21. [Brewfest Beer Tent] GUID: 25546 ID: 186682
  22.  
  23. -- NPC --
  24. Thrall: Entry: 4949. DisplayID: 4527 (Native: 4527).
  25. Varian: Entry: 29611. DisplayID: 28127 (Native: 28127).
  26. Guards Alliance: Entry: 1756. DisplayID: 3167 (Native: 3167).  2*
  27. Guards Horde: Entry: 14304. DisplayID: 14360 (Native: 14360).  2*
  28. Orgrim s Hammer Scout: Entry: 32201. DisplayID: 26071 (Native: 26071). (more)
  29. Orgrimmar Fire Eater: Entry: 17041.
  30. -- GO "Táblák"  Example & Portal --
  31. [Cleft OF Shadow] GUID: 16793 ID: 172983 *REWRITE!*
  32. [Valley OF Honor] GUID: 16860 ID: 172984 *REWRITE!*
  33. [Gotri s Travelling Gear] GUID: 42220 ID: 173017 *REWRITE!*
  34. [Dwarven District] GUID: 25230 ID: 28027 *REWRITE!*
  35. [Dalaran Portal TO Orgrimmar] GUID: 27361 ID: 191009
  36. [Dalaran Portal TO Undercity] GUID: 27362 ID: 191012
  37. [Dalaran Portal TO Thunder Bluff] GUID: 27363 ID: 191011
  38. [Dalaran Portal TO Silvermoon] GUID: 27364 ID: 191010
  39. [Dalaran Portal TO Shattrath] GUID: 27365 ID: 191014
  40. [Teleport TO Dalaran Crystal] GUID: 47796 ID: 191230
  41. [Shattrath Portal TO Darnassus] GUID: 67641 ID: 183317
  42. [Shattrath Portal TO Stormwind] GUID: 67658 ID: 183325
  43. [Shattrath Portal TO Ironforge] GUID: 67655 ID: 183322
  44. [DARKMOON FAIRE] GUID: 71887 ID: 180029 *REWRITE!* "Can't target".;
  45.  
  46. -- Game_Event --
  47. INSERT INTO game_event (`entry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`) VALUES
  48. ('100', '2010-12-14 20:00:00', '2010-12-24 20:00:00', '525600', '20158', '0', "World Jump Event");
  49.  
  50. -- GM Game Tele Code --
  51. INSERT INTO game_tele (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, `name`) VALUES
  52. (2000, -6269.412109, -3737.725098, 245.676178, 0, "Jump Event");
  53.  
  54. -- GO [Rare Cache of Winter] Spawn & Quest_Relation &  --
  55. [Rare Cache OF Winter] GUID: 200088 ID: 194200
  56. X: -6349.450195 Y: -3811.270020 Z: 340.839996 MapId: 0
  57. Orientation: 0.597990;
  58.  
  59. -- Spawn --
  60. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  61. ('194200', '0', '1', '1', '-6349.450195', '-3811.270020', '340.839996', '0.59799', '0', '0', '0.29456', '0.955633', '25', '255', '1');
  62.  
  63. -- Quest_Relation --
  64. INSERT INTO gameobject_questrelation (`id`, `quest`) VALUES
  65. ('194200', 'unknown');
  66.  
  67. -- GO_event --
  68. SET @guid=(SELECT guid FROM creature WHERE id=194200);
  69. INSERT INTO game_event_gameobject (`guid`,`event`) VALUES
  70. (@guid, 100);
  71.  
  72. -- Npc [Cache Keeper] Spawn & Name Change & Rank Change & Hp Change --
  73. 1. NPC POSITION: -6360.706055 -3799.034912 349.294128.
  74. 2. NPC POSITION: -6362.360352 -3820.898438 363.955994.
  75. 3. NPC POSITION: -6329.288086 -3818.123779 354.627625.;
  76.  
  77. -- Spawn --
  78. INSERT INTO creature (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id` ,`position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  79. ('32201', '0', '1', '1', '0', '0', '-6362.36', '-3820.9', '363.956', '0.572024', '25', '5', '0', '12600', '3994', '0', '0'),
  80. ('32201', '0', '1', '1', '0', '0', '-6329.29', '-3818.12', '354.628', '2.79786', '25', '5', '0', '12600', '3994', '0', '0'),
  81. ('32201', '0', '1', '1', '0', '0', '-6360.71', '-3799.03', '349.294', '5.50825', '25', '5', '0', '12600', '3994', '0', '0');
  82.  
  83. -- Name Change --
  84. UPDATE creature_template SET `name`="Cache Keeper" WHERE entry = '32201';
  85. -- Rank Change --
  86. UPDATE creature_template SET `rank`='3' WHERE entry = '32201';
  87.  
  88. -- Hp Change --
  89. UPDATE creature_template SET `minhealth`='172000', `maxhealth`='172000' WHERE entry = '32201';
  90.  
  91. -- Event Creature --
  92. SET @guid=(SELECT guid FROM creature WHERE id=32201);
  93. INSERT INTO game_event_creature (`guid`, `event`) VALUES
  94. (@guid, 100);
  95.  
  96. -- Thrall & Varian Rewrite --
  97.  
  98. -- Thrall
  99. INSERT INTO creature_template (`entry`, `difficulty_entry1`, `difficulty_entry2`, `difficulty_entry3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `mindrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  100. 25000, 0, 0, 0, 0, 0, 4527, 0, 0, 0, "Thrall Warchief", 3664, 73, 73, 5578000, 5578000, 127740, 127740, 7561, 35, 35, 3, 2.15, 1.14286, 1, 3, 143, 215, 0, 54, 17.5, 1000, 1000, 2, 4160, 0, 0, 0, 0, 0, 0, 114, 172, 43, 7, 12, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 638000, 638000, 0, 3, 400, 30, 1, 0, 0, 0, 0, 0, 0, 0, 1, 1219, 650854399, 2, 'npc_thrall_warchief');
  101.  
  102. -- Varian --
  103. INSERT INTO creature_template (`entry`, `difficulty_entry1`, `difficulty_entry2`, `difficulty_entry3`, `KillCredit1`, `KillCredit2`, `modelid_1`, `modelid_2`, `modelid_3`, `modelid_4`, `name`, `subname`, `IconName`, `gossip_menu_id`, `minlevel`, `maxlevel`, `minhealth`, `maxhealth`, `minmana`, `maxmana`, `armor`, `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`, `mindrangedmg`, `maxrangedmg`, `rangedattackpower`, `type`, `type_flags`, `lootid`, `pickpocketloot`, `skinloot`, `resistance1`, `resistance2`, `resistance3`, `resistance4`, `resistance5`, `resistance6`, `spell1`, `spell2`, `spell3`, `spell4`, `PetSpellDataId`, `mingold`, `maxgold`, `AIName`, `MovementType`, `InhabitType`, `unk16`, `unk17`, `RacialLeader`, `questItem1`, `questItem2`, `questItem3`, `questItem4`, `questItem5`, `questItem6`, `movementId`, `RegenHealth`, `equipment_id`, `mechanic_immune_mask`, `flags_extra`, `ScriptName`) VALUES
  104. (25001, 0, 0, 0, 0, 0, 28127, 0, 0, 0, "King Varian Wrynn", "King of Stormwind", 9834, 83, 83, 5578000, 5578000, 0, 0, 10627, 1802, 1802, 3, 1.8, 1.14286, 1, 3, 468, 702, 0, 175, 2.1, 2000, 2000, 1, 0, 0, 0, 0, 0, 0, 0, 374, 562, 140, 7, 76, 0, 0, 0, 0, 0, 0, 0, 0, 0, 59688, 41057, 41056, 0, 0, 730500, 730500, 0, 3, 400, 20, 1, 0, 0, 0, 0, 0, 0, 144, 1, 1883, 617299803, 0, 'generic_creature');
  105.  
  106. -- Scale Update --
  107. UPDATE creature_template SET `scale`='1.5' WHERE entry = '25000';
  108. UPDATE creature_template SET `scale`='1.5' WHERE entry = '25001';
  109. -- Thrall & Varian Spawn - Game_Event --
  110.  
  111. -- Spawn --
  112. INSERT INTO creature (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  113. (25000, 0, 1, 1, 0, 0, -6275.302246, -3775.832520, 242.874451, 2.229275, 600, 0, 0, 5200000, 4500, 0, 0);
  114. INSERT INTO creature (`id`, `map`, `spawnMask`, `phaseMask`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `DeathState`, `MovementType`) VALUES
  115. (25001, 0, 1, 1, 0, 0, -6296.952148, -3744.257813, 244.066101, 5.324525, 600, 0, 0, 5200000, 0, 0, 0);
  116. -- Game_Event_Creature --
  117.  
  118. -- Thrall
  119. SET @guid=(SELECT guid FROM creature WHERE id=25000);
  120. INSERT INTO game_event_creature (`guid`, `event`) VALUES
  121. (@guid, 100);
  122.  
  123. -- Varian --
  124. SET @guid=(SELECT guid FROM creature WHERE id=25001);
  125. INSERT INTO game_event_creature (`guid`, `event`) VALUES
  126. (@guid, 100);
  127. -- GO's Gate, Teleport, Canopy, etc.. Spawn & Game_Event --
  128.  
  129. -- Gate --
  130. SET @guid=(SELECT guid FROM gameobject id = 180029);
  131. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  132. (@guid, 100);
  133. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  134. (180029, 0, 1, 1, -6272.18, -3684.25, 244.144, 2.01181, 0, 0, 0.844646, 0.535325, 25, 255, 1),
  135. (180029, 0, 1, 1, -6292.03, -3756.39, 243.578, 3.69571, 0, 0, 0.961864, -0.273529, 25, 255, 1),
  136. (180029, 0, 1, 1, -6316.56, -3574.86, 244.095, 2.24744, 0, 0, 0.901715, 0.432331, 25, 255, 1);
  137. UPDATE gameobject_template SET `flags`='1' WHERE entry = '180029';
  138. -- Canopy --
  139. SET @guid=(SELECT guid FROM gameobject id = 186682);
  140. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  141. (@guid, 100);
  142. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  143. (186682, 0, 1, 1, -6249.73, -3754.76, 242.913, 2.3245, 0, 0, 0.9177, 0.397273, 25, 255, 1),
  144. (186682, 0, 1, 1, -6249.17, -3713.55, 243.991, 3.81819, 0, 0, 0.943321, -0.331882, 25, 255, 1);
  145.  
  146. -- Teleport --
  147. -- Horde --
  148.  
  149. SET @guid=(SELECT guid FROM gameobject id = 191014);
  150. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  151. (@guid, 100);
  152. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  153. (191014, 0, 1, 1, -6238.14, -3725.32, 243.89, 3.54328, 0, 0, 0.979899, -0.199496, 25, 255, 1);
  154.  
  155. SET @guid=(SELECT guid FROM gameobject id = 191010);
  156. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  157. (@guid, 100);
  158. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  159. (191010, 0, 1, 1, -6236.32, -3729.61, 243.688, 3.54328, 0, 0, 0.979899, -0.199496, 25, 255, 1);
  160.  
  161. SET @guid=(SELECT guid FROM gameobject id = 191230);
  162. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  163. (@guid, 100);
  164. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  165. (191230, 0, 1, 1, -6235.22, -3734.41, 243.475, 3.22127, 0, 0, 0.999207, -0.0398262, 25, 255, 1),
  166. (191230, 0, 1, 1, --6317.47, -3748.94, 248.253, 5.5193, 0, 0, 0.372724, -0.927942, 25, 255, 1);
  167.  
  168. SET @guid=(SELECT guid FROM gameobject id = 191012);
  169. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  170. (@guid, 100);
  171. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  172. (191012, 0, 1, 1, -6237.49, -3737.53, 243.24, 2.98566, 0, 0, 0.996962, 0.0778877, 25, 255, 1);
  173.  
  174. SET @guid=(SELECT guid FROM gameobject id = 191009);
  175. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  176. (@guid, 100);
  177. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  178. (191009, 0, 1, 1, -6241.03, -3740.4099, 243.201, 2.94246, 0, 0, 0.995048, 0.0994007, 25, 255, 1);
  179.  
  180. -- Alliance --
  181. SET @guid=(SELECT guid FROM gameobject id = 183317);
  182. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  183. (@guid, 100);
  184. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  185. (183317, 0, 1, 1, -6318.27, -3754.76, 246.759, 5.53108, 0, 0, 0.367251, -0.930122, 25, 255, 1);
  186.  
  187. SET @guid=(SELECT guid FROM gameobject id = 183317
  188. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  189. (@guid, 100);
  190. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  191. (183317, 0, 1, 1, -6318.27, -3754.76, 246.759, 5.53108, 0, 0, 0.367251, -0.930122, 25, 255, 1);
  192.  
  193. SET @guid=(SELECT guid FROM gameobject id = 183322);
  194. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  195. (@guid, 100);
  196. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  197. (183322, 0, 1, 1, -6312.16, -3748.33, 246.905, 5.52323, 0, 0, 0.370901, -0.928672, 25, 255, 1);
  198.  
  199. SET @guid=(SELECT guid FROM gameobject id = 191230);
  200. INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
  201. (@guid, 100);
  202. INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
  203. (191230, 0, 1, 1, -6317.47, -3748.94, 248.253, 5.5193, 0, 0, 0.372724, -0.927942, 25, 255, 1);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement