Add Game Event For Venture Bay

[CODE]-- Add Game Event for Venture Bay
DELETE FROM game_event WHERE eventEntry IN (65,66);
INSERT INTO game_event (eventEntry,start_time,end_time,occurence,length,holiday,description,world_event) VALUES
(65,‘0000-00-00 00:00:00’,‘0000-00-00 00:00:00’,5184000,2592000,0,‘Venture Bay Alliance Defence’,6),
(66,‘0000-00-00 00:00:00’,‘0000-00-00 00:00:00’,5184000,2592000,0,‘Venture Bay Horde Defence’,6);[/sql]

The lighthouse needs to be metered to capture it. The npc’s will need to be added to the game event.

[/CODE]

Could someone with more spare time than me fill in the guids for the above sql?

I’d kiss you Discover but I’m afraid you’d like it /emoticons/default_tongue.png

I would. What’s up with the font thingy?

http://paste2.org/p/1683665

Updated. Horses and riding wolves added.

[CODE]-- Add Game Event for Venture Bay
DELETE FROM game_event WHERE eventEntry IN (65,66);
INSERT INTO game_event (eventEntry,start_time,end_time,occurence,length,holiday,description,world_event) VALUES
(65,‘0000-00-00 00:00:00’,‘0000-00-00 00:00:00’,5184000,2592000,0,‘Venture Bay Alliance Defence’,6),
(66,‘0000-00-00 00:00:00’,‘0000-00-00 00:00:00’,5184000,2592000,0,‘Venture Bay Horde Defence’,6);

– Missing Westfall Brigade Defender Spawn
SET @GUID := 209198;
DELETE FROM creature WHERE guid=@GUID;
INSERT INTO creature (guid,id,map,spawnMask,phaseMask,modelid,equipment_id,position_x,position_y,position_z,orientation,spawntimesecs,spawndist,currentwaypoint,curhealth,curmana,MovementType) VALUES
(@GUID,27758,571,1,1,0,0,2401.28833,-1835.28992,1.870854,5.934119,120,0,0,1,0,0);

– Addons for Westfall Brigade Defender
DELETE FROM creature_addon WHERE guid IN (@GUID);
INSERT INTO creature_addon (guid,bytes2) VALUES
(@GUID,257);

– Add Game event spawns for Venture Bay
DELETE FROM game_event_creature WHERE eventEntry IN (65,66);
INSERT INTO game_event_creature (eventEntry,guid) VALUES
– Alliance
(65,106209), – Commander Howser
(65,106275), – “Grizzly” D. Adams
(65,102110), – Tim Street
(65,102293), – Jason Riggins
(65,106139), – Westfall Brigade Defender
(65,106140), – Westfall Brigade Defender
(65,106141), – Westfall Brigade Defender
(65,106142), – Westfall Brigade Defender
(65,106168), – Westfall Brigade Defender
(65,106169), – Westfall Brigade Defender
(65,106170), – Westfall Brigade Defender
(65,106171), – Westfall Brigade Defender
(65,106172), – Westfall Brigade Defender
(65,106173), – Westfall Brigade Defender
(65,106174), – Westfall Brigade Defender
(65,106175), – Westfall Brigade Defender
(65,106176), – Westfall Brigade Defender
(66,209198), – Westfall Brigade Defender
(65,107711), – Horse
(65,107712), – Horse
(65,107713), – Horse
(65,107714), – Horse
– Horde
(66,85483), – General Gorlok
(66,107018), – Purkom
(66,85484), – Kor
(66,102366), – Koloth
(66,86565), – Conquest Hold Defender
(66,86566), – Conquest Hold Defender
(66,86567), – Conquest Hold Defender
(66,86568), – Conquest Hold Defender
(66,86569), – Conquest Hold Defender
(66,86570), – Conquest Hold Defender
(66,86571), – Conquest Hold Defender
(66,86572), – Conquest Hold Defender
(66,86573), – Conquest Hold Defender
(66,86574), – Conquest Hold Defender
(66,86575), – Conquest Hold Defender
(66,86651), – Conquest Hold Defender
(66,86652), – Conquest Hold Defender
(66,86654), – Conquest Hold Defender
(66,108972), – Riding Wolf
(66,108973), – Riding Wolf
(66,108974), – Riding Wolf
(66,108975); – Riding Wolf

– Add Game event spawns for Venture Bay
DELETE FROM game_event_gameobject WHERE eventEntry IN (65,66);
INSERT INTO game_event_gameobject (eventEntry,guid) VALUES
– Alliance
(65,59043), – Forge
(65,59616), – Blacksmith’s Anvil
– Horde
(66,59624), – Forge
(66,59029); – Blacksmith’s Anvil[/sql]

Updated. More to come. 1 Westfall Brigade Defender missing on dock. Still to determine missing horde.

[/CODE]

[CODE]-- Pathing for Westfall Brigade Defender Entry: 27758
SET @NPC := 106168;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2497.696,position_y=-1869.719,position_z=9.103054 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,257,8469, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2496.031,-1893.335,8.478054,0,0,0,100,0),
(@PATH,2,2508.669,-1917.371,6.410792,0,0,0,100,0),
(@PATH,3,2520.141,-1947.965,7.359051,0,0,0,100,0),
(@PATH,4,2527.398,-1963.128,7.609051,0,0,0,100,0),
(@PATH,5,2528.865,-1971.647,7.790438,0,0,0,100,0),
(@PATH,6,2528.865,-1971.647,7.790438,11000,0,0,100,0), – turn to 3.124139
(@PATH,7,2524.346,-1957.296,7.484051,0,0,0,100,0),
(@PATH,8,2513.969,-1927.193,5.910792,0,0,0,100,0),
(@PATH,9,2497.374,-1896.456,8.353054,0,0,0,100,0),
(@PATH,10,2496.965,-1868.76,9.103054,0,0,0,100,0),
(@PATH,11,2474.013,-1852.263,7.679791,0,0,0,100,0),
(@PATH,12,2455.206,-1850.57,4.343608,0,0,0,100,0),
(@PATH,13,2447.093,-1846.895,1.968608,0,0,0,100,0),
(@PATH,14,2462.255,-1849.974,5.593608,0,0,0,100,0),
(@PATH,15,2478.127,-1855.555,8.304791,0,0,0,100,0),
(@PATH,16,2497.696,-1869.719,9.103054,0,0,0,100,0);
– F1306C6E0CB9F4F7 .go 2496.031 -1893.335 8.478054

– Pathing for Westfall Brigade Defender Entry: 27758
SET @NPC := 106169;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2496.554,position_y=-1890.696,position_z=8.478054 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,257,8469, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2503.714,-1913.277,7.160792,0,0,0,100,0),
(@PATH,2,2496.554,-1890.696,8.478054,0,0,0,100,0),
(@PATH,3,2498.982,-1865.834,9.179791,0,0,0,100,0),
(@PATH,4,2510.136,-1847.062,9.191589,0,0,0,100,0),
(@PATH,5,2536.351,-1827.397,9.33048,0,0,0,100,0),
(@PATH,6,2558.184,-1812.495,9.95548,0,0,0,100,0),
(@PATH,7,2571.104,-1805.639,10.08385,0,0,0,100,0),
(@PATH,8,2558.184,-1812.495,9.95548,0,0,0,100,0),
(@PATH,9,2532.806,-1829.652,9.16322,0,0,0,100,0),
(@PATH,10,2510.136,-1847.062,9.191589,0,0,0,100,0),
(@PATH,11,2499.809,-1869.629,9.228054,0,0,0,100,0),
(@PATH,12,2496.554,-1890.696,8.478054,0,0,0,100,0);
– F1306C6E0CB9F5F7 .go 2503.714 -1913.277 7.160792[/sql]

[sql]-- Pathing for Conquest Hold Defender Entry: 27748
SET @NPC := 86565;
SET @PATH := @NPC * 10;
UPDATE creature SET spawndist=0,MovementType=2,position_x=2527.629,position_y=-1829.358,position_z=9.16322 WHERE guid=@NPC;
DELETE FROM creature_addon WHERE guid=@NPC;
INSERT INTO creature_addon (guid,path_id,bytes2,mount,auras) VALUES (@NPC,@PATH,257,14334, ‘’);
DELETE FROM waypoint_data WHERE id=@PATH;
INSERT INTO waypoint_data (id,point,position_x,position_y,position_z,delay,move_flag,action,action_chance,wpguid) VALUES
(@PATH,1,2507.953,-1848.898,9.316589,0,0,0,100,0),
(@PATH,2,2496.745,-1869.892,8.978054,0,0,0,100,0),
(@PATH,3,2495.564,-1895.246,8.728054,0,0,0,100,0),
(@PATH,4,2509.788,-1917.869,6.285792,0,0,0,100,0),
(@PATH,5,2530.956,-1923.234,3.660793,0,0,0,100,0),
(@PATH,6,2538.894,-1922.25,3.142995,0,0,0,100,0),
(@PATH,7,2538.894,-1922.25,3.142995,12000,0,0,100,0), – turn to 0
(@PATH,8,2529.43,-1923.145,3.785793,0,0,0,100,0),
(@PATH,9,2512.314,-1922.614,6.035792,0,0,0,100,0),
(@PATH,10,2499.274,-1901.508,8.021339,0,0,0,100,0),
(@PATH,11,2496.062,-1876.079,8.853054,0,0,0,100,0),
(@PATH,12,2507.123,-1850.746,9.316589,0,0,0,100,0),
(@PATH,13,2529.624,-1830.826,9.03822,0,0,0,100,0),
(@PATH,14,2524.574,-1805.798,10.03822,0,0,0,100,0),
(@PATH,15,2524.574,-1805.798,10.03822,11000,0,0,100,0), – turn to 5.288348
(@PATH,16,2527.629,-1829.358,9.16322,0,0,0,100,0);
– 0xF130006C644B2CE6 .go 2507.953 -1848.898 9.316589
[/CODE]