Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- "World Jump Event"--
- -- Complete: 25% --
- -- Event Coordinate & Teleport Coordinate --
- Map: 0 (Eastern Kingdoms) Zone: 3 (Badlands) Area: 341 (Camp Kosh) Phase: 1
- X: -6269.412109 Y: -3737.725098 Z: 245.676178 Orientation: 0.491973
- grid[20,24]cell[1,7] InstanceID: 0
- ZoneX: 66.675720 ZoneY: 22.904264
- GroundZ: 245.675690 FloorZ: 245.675690 Have height DATA (Map: 1 VMap: 1)
- -- GO "Reward" Coordinate --
- [Cache OF Living Stone] GUID: 40129 ID: 195046
- Map: 0 (Eastern Kingdoms) Zone: 3 (Badlands) Area: 1898 (Dustwind Gulch) Phase: 1
- X: -6349.533203 Y: -3811.443115 Z: 340.866211 Orientation: 0.308978
- grid[20,24]cell[0,6] InstanceID: 0
- ZoneX: 69.639259 ZoneY: 27.735687
- GroundZ: 340.866547 FloorZ: 340.866547 Have height DATA (Map: 1 VMap: 1)
- -- Some GO; Box & Brazier & NPC --
- [Blight Crystal Box] GUID: 200001 ID: 190946
- [Brazier] GUID: 70142 ID: 186128
- [Brewfest Canopy] GUID: 25520 ID: 186680
- [Brewfest Beer Tent] GUID: 25546 ID: 186682
- -- NPC --
- Thrall: Entry: 4949. DisplayID: 4527 (Native: 4527).
- Varian: Entry: 29611. DisplayID: 28127 (Native: 28127).
- Guards Alliance: Entry: 1756. DisplayID: 3167 (Native: 3167). 2*
- Guards Horde: Entry: 14304. DisplayID: 14360 (Native: 14360). 2*
- Orgrim s Hammer Scout: Entry: 32201. DisplayID: 26071 (Native: 26071). (more)
- Orgrimmar Fire Eater: Entry: 17041.
- -- GO "Táblák" Example & Portal --
- [Cleft OF Shadow] GUID: 16793 ID: 172983 *REWRITE!*
- [Valley OF Honor] GUID: 16860 ID: 172984 *REWRITE!*
- [Gotri s Travelling Gear] GUID: 42220 ID: 173017 *REWRITE!*
- [Dwarven District] GUID: 25230 ID: 28027 *REWRITE!*
- [Dalaran Portal TO Orgrimmar] GUID: 27361 ID: 191009
- [Dalaran Portal TO Undercity] GUID: 27362 ID: 191012
- [Dalaran Portal TO Thunder Bluff] GUID: 27363 ID: 191011
- [Dalaran Portal TO Silvermoon] GUID: 27364 ID: 191010
- [Dalaran Portal TO Shattrath] GUID: 27365 ID: 191014
- [Teleport TO Dalaran Crystal] GUID: 47796 ID: 191230
- [Shattrath Portal TO Darnassus] GUID: 67641 ID: 183317
- [Shattrath Portal TO Stormwind] GUID: 67658 ID: 183325
- [Shattrath Portal TO Ironforge] GUID: 67655 ID: 183322
- [DARKMOON FAIRE] GUID: 71887 ID: 180029 *REWRITE!* "Can't target".;
- -- Game_Event --
- INSERT INTO game_event (`entry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`) VALUES
- ('100', '2010-12-14 20:00:00', '2010-12-24 20:00:00', '525600', '20158', '0', "World Jump Event");
- -- GM Game Tele Code --
- INSERT INTO game_tele (`id`, `position_x`, `position_y`, `position_z`, `orientation`, `map`, `name`) VALUES
- (2000, -6269.412109, -3737.725098, 245.676178, 0, "Jump Event");
- -- GO [Rare Cache of Winter] Spawn & Quest_Relation & --
- [Rare Cache OF Winter] GUID: 200088 ID: 194200
- X: -6349.450195 Y: -3811.270020 Z: 340.839996 MapId: 0
- Orientation: 0.597990;
- -- Spawn --
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- ('194200', '0', '1', '1', '-6349.450195', '-3811.270020', '340.839996', '0.59799', '0', '0', '0.29456', '0.955633', '25', '255', '1');
- -- Quest_Relation --
- INSERT INTO gameobject_questrelation (`id`, `quest`) VALUES
- ('194200', 'unknown');
- -- GO_event --
- SET @guid=(SELECT guid FROM creature WHERE id=194200);
- INSERT INTO game_event_gameobject (`guid`,`event`) VALUES
- (@guid, 100);
- -- Npc [Cache Keeper] Spawn & Name Change & Rank Change & Hp Change --
- 1. NPC POSITION: -6360.706055 -3799.034912 349.294128.
- 2. NPC POSITION: -6362.360352 -3820.898438 363.955994.
- 3. NPC POSITION: -6329.288086 -3818.123779 354.627625.;
- -- Spawn --
- 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
- ('32201', '0', '1', '1', '0', '0', '-6362.36', '-3820.9', '363.956', '0.572024', '25', '5', '0', '12600', '3994', '0', '0'),
- ('32201', '0', '1', '1', '0', '0', '-6329.29', '-3818.12', '354.628', '2.79786', '25', '5', '0', '12600', '3994', '0', '0'),
- ('32201', '0', '1', '1', '0', '0', '-6360.71', '-3799.03', '349.294', '5.50825', '25', '5', '0', '12600', '3994', '0', '0');
- -- Name Change --
- UPDATE creature_template SET `name`="Cache Keeper" WHERE entry = '32201';
- -- Rank Change --
- UPDATE creature_template SET `rank`='3' WHERE entry = '32201';
- -- Hp Change --
- UPDATE creature_template SET `minhealth`='172000', `maxhealth`='172000' WHERE entry = '32201';
- -- Event Creature --
- SET @guid=(SELECT guid FROM creature WHERE id=32201);
- INSERT INTO game_event_creature (`guid`, `event`) VALUES
- (@guid, 100);
- -- Thrall & Varian Rewrite --
- -- Thrall
- 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
- 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');
- -- Varian --
- 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
- (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');
- -- Scale Update --
- UPDATE creature_template SET `scale`='1.5' WHERE entry = '25000';
- UPDATE creature_template SET `scale`='1.5' WHERE entry = '25001';
- -- Thrall & Varian Spawn - Game_Event --
- -- Spawn --
- 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
- (25000, 0, 1, 1, 0, 0, -6275.302246, -3775.832520, 242.874451, 2.229275, 600, 0, 0, 5200000, 4500, 0, 0);
- 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
- (25001, 0, 1, 1, 0, 0, -6296.952148, -3744.257813, 244.066101, 5.324525, 600, 0, 0, 5200000, 0, 0, 0);
- -- Game_Event_Creature --
- -- Thrall
- SET @guid=(SELECT guid FROM creature WHERE id=25000);
- INSERT INTO game_event_creature (`guid`, `event`) VALUES
- (@guid, 100);
- -- Varian --
- SET @guid=(SELECT guid FROM creature WHERE id=25001);
- INSERT INTO game_event_creature (`guid`, `event`) VALUES
- (@guid, 100);
- -- GO's Gate, Teleport, Canopy, etc.. Spawn & Game_Event --
- -- Gate --
- SET @guid=(SELECT guid FROM gameobject id = 180029);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (180029, 0, 1, 1, -6272.18, -3684.25, 244.144, 2.01181, 0, 0, 0.844646, 0.535325, 25, 255, 1),
- (180029, 0, 1, 1, -6292.03, -3756.39, 243.578, 3.69571, 0, 0, 0.961864, -0.273529, 25, 255, 1),
- (180029, 0, 1, 1, -6316.56, -3574.86, 244.095, 2.24744, 0, 0, 0.901715, 0.432331, 25, 255, 1);
- UPDATE gameobject_template SET `flags`='1' WHERE entry = '180029';
- -- Canopy --
- SET @guid=(SELECT guid FROM gameobject id = 186682);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (186682, 0, 1, 1, -6249.73, -3754.76, 242.913, 2.3245, 0, 0, 0.9177, 0.397273, 25, 255, 1),
- (186682, 0, 1, 1, -6249.17, -3713.55, 243.991, 3.81819, 0, 0, 0.943321, -0.331882, 25, 255, 1);
- -- Teleport --
- -- Horde --
- SET @guid=(SELECT guid FROM gameobject id = 191014);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (191014, 0, 1, 1, -6238.14, -3725.32, 243.89, 3.54328, 0, 0, 0.979899, -0.199496, 25, 255, 1);
- SET @guid=(SELECT guid FROM gameobject id = 191010);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (191010, 0, 1, 1, -6236.32, -3729.61, 243.688, 3.54328, 0, 0, 0.979899, -0.199496, 25, 255, 1);
- SET @guid=(SELECT guid FROM gameobject id = 191230);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (191230, 0, 1, 1, -6235.22, -3734.41, 243.475, 3.22127, 0, 0, 0.999207, -0.0398262, 25, 255, 1),
- (191230, 0, 1, 1, --6317.47, -3748.94, 248.253, 5.5193, 0, 0, 0.372724, -0.927942, 25, 255, 1);
- SET @guid=(SELECT guid FROM gameobject id = 191012);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (191012, 0, 1, 1, -6237.49, -3737.53, 243.24, 2.98566, 0, 0, 0.996962, 0.0778877, 25, 255, 1);
- SET @guid=(SELECT guid FROM gameobject id = 191009);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (191009, 0, 1, 1, -6241.03, -3740.4099, 243.201, 2.94246, 0, 0, 0.995048, 0.0994007, 25, 255, 1);
- -- Alliance --
- SET @guid=(SELECT guid FROM gameobject id = 183317);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (183317, 0, 1, 1, -6318.27, -3754.76, 246.759, 5.53108, 0, 0, 0.367251, -0.930122, 25, 255, 1);
- SET @guid=(SELECT guid FROM gameobject id = 183317
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (183317, 0, 1, 1, -6318.27, -3754.76, 246.759, 5.53108, 0, 0, 0.367251, -0.930122, 25, 255, 1);
- SET @guid=(SELECT guid FROM gameobject id = 183322);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (183322, 0, 1, 1, -6312.16, -3748.33, 246.905, 5.52323, 0, 0, 0.370901, -0.928672, 25, 255, 1);
- SET @guid=(SELECT guid FROM gameobject id = 191230);
- INSERT INTO game_event_gameobject (`guid`, `event`) VALUES
- (@guid, 100);
- INSERT INTO gameobject (`id`, `map`, `spawnMask`, `phaseMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES
- (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