mmo-ref/vmangos
1
0
Fork 0
mirror of https://github.com/vmangos/core synced 2026-08-14 16:29:10 -04:00
Code Issues Projects Releases Packages Wiki Activity
vmangos/sql/custom/zethkur_transfer_event.sql
brotalnia da9cb9b4c9 Add folder for custom database changes.
2017-10-06 21:06:12 +03:00

271 lines
69 KiB
SQL
Raw Permalink Blame History

#
# Zeth'Kur merge event
#
# ZK event
INSERT INTO `game_event` (`entry`, `start_time`, `end_time`, `occurence`, `length`, `holiday`, `description`, `hardcoded`, `disabled`) VALUES ('79', '2010-01-01 01:00:00', '2025-01-01 01:00:00', '1', '2', '0', 'ZK Transfer', '0', '1');
# Kodos and mules
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530161', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530162', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530160', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530163', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530164', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530147', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530148', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530149', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530150', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530151', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530152', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530153', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530155', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530156', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530157', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530158', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530159', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530165', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530168', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530169', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530170', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530175', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530174', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530173', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530176', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530166', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530178', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530179', '79');
# Sack of Oats
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998448', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998449', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998450', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998451', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998452', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998453', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998454', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998455', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998456', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998457', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998458', '79');
# Crates
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998459', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998460', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998461', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998462', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998464', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998466', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998467', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998468', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998471', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998472', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998474', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998475', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998476', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998477', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998479', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998480', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998484', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998483', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998485', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998487', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998488', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998489', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998490', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998492', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998493', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998494', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998495', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998496', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998497', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998498', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998499', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998463', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998465', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998469', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998470', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998473', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998478', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998486', '79');
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998491', '79');
# Crates
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998459,179969,1,9839.31,2298.21,1320.31,6.04515,0,0,0.118737,-0.992926,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998460,179969,1,9841.99,2302.53,1319.46,0.50809,0,0,0.251321,0.967904,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998461,179969,1,9855.82,2308.77,1318.13,0.339229,0,0,0.168802,0.98565,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998462,179969,1,9853.72,2308.24,1318.2,5.84016,0,0,0.219707,-0.975566,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998464,179969,1,9853.91,2308.45,1318.83,3.86959,0,0,0.93448,-0.356015,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998466,179969,1,9866.27,2311.88,1322.15,3.8955,0,0,0.92979,-0.36809,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998467,179969,1,9866.27,2311.88,1322.79,3.64731,0,0,0.968201,-0.250175,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998468,179969,1,9866.27,2311.88,1323.42,3.64731,0,0,0.968201,-0.250175,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998471,179969,1,9867.18,2309.64,1322.15,1.76236,0,0,0.771491,0.63624,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998472,179969,1,9860.25,2300.6,1320.39,3.29075,0,0,0.99722,-0.0745094,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998474,179969,1,9865.78,2310.38,1322.15,0.296814,0,0,0.147863,0.989008,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998475,179969,0,-8792.23,649.667,94.9889,3.58177,0,0,0.975879,-0.218314,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998476,179969,0,-8792.23,649.667,95.626,3.28646,0,0,0.997378,-0.0723684,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998477,179969,0,-8793.36,651.446,95.0068,2.98408,0,0,0.9969,0.0786761,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998479,179969,0,-8793.26,651.534,95.6419,5.25938,0,0,0.489838,-0.871814,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998480,179969,0,-8790.34,643.964,94.9118,3.05791,0,0,0.999125,0.0418315,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998484,179969,0,-8796.21,642.256,94.9475,2.98408,0,0,0.9969,0.0786756,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998483,179969,0,-8796.21,642.256,94.3122,3.182,0,0,0.999796,-0.0202018,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998485,179969,0,-8794.95,641.722,94.3185,2.19868,0,0,0.890908,0.454184,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998487,179969,0,-8794.83,643.192,94.3725,1.12426,0,0,0.532988,0.846123,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998488,179969,1,1660.48,-4432.79,19.0626,1.73884,0,0,0.763954,0.64527,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998489,179969,1,1654.44,-4445.96,22.3822,1.60453,0,0,0.718932,0.69508,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998490,179969,1,1653.02,-4444.63,20.8749,2.38679,0,0,0.929625,0.368507,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998492,179969,1,1653.67,-4442.62,19.4103,1.33435,0,0,0.618768,0.785574,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998493,179969,1,1653.67,-4442.62,20.0453,1.482,0,0,0.675026,0.737794,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998494,179969,1,1653.67,-4442.62,20.6805,1.8747,0,0,0.805992,0.591926,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998495,179969,1,1653.15,-4441.1,18.5026,1.70427,0,0,0.752688,0.658378,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998496,179969,1,1653.15,-4441.1,19.1377,1.82679,0,0,0.791583,0.611061,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998497,179969,1,1649.92,-4439.93,18.232,1.46237,0,0,0.667753,0.744383,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998498,179969,1,1655.01,-4442.07,19.0561,1.82758,0,0,0.791824,0.61075,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998499,179969,1,1637.82,-4431.33,15.7247,1.82443,0,0,0.79086,0.611996,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998463,179970,1,9852.58,2310.5,1318.22,4.36832,0,0,0.817716,-0.575622,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998465,179970,1,9853.91,2308.45,1319.47,3.35751,0,0,0.994178,-0.10775,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998469,179970,1,9866.27,2311.88,1324.06,5.3155,0,0,0.465184,-0.885214,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998470,179970,1,9867.17,2308.28,1322.15,2.98759,0,0,0.997037,0.0769274,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998473,179970,1,9858.88,2294.61,1323.07,2.60589,0,0,0.964341,0.264662,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998478,179970,0,-8795.42,653.651,96.2425,3.73021,0,0,0.957003,-0.290077,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998486,179970,0,-8795.06,641.624,94.9535,2.54583,0,0,0.95596,0.293497,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998491,179970,1,1651.45,-4441.49,18.4666,1.94775,0,0,0.82707,0.562099,25,100,1,0);
# Oats
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998448,2724,0,-4897.26,-966.648,501.443,2.33918,0,0,0.92059,0.39053,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998449,2724,0,-4889.9,-959.129,501.461,2.18682,0,0,0.888198,0.459461,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998450,2724,0,-8797.29,654.553,95.3044,3.76319,0,0,0.952089,-0.30582,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998451,2724,0,-8789.52,642.41,94.9232,3.34222,0,0,0.994973,-0.100144,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998452,2724,0,-8790.74,641.895,94.5434,2.40601,0,0,0.933123,0.359557,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998453,2724,0,1655.84,264.671,-62.1794,0.0229459,0,0,0.0114727,0.999934,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998454,2724,0,1654.18,253.485,-62.1776,6.12077,0,0,0.0811182,-0.996704,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998455,2724,0,1645.71,272.846,-62.1782,3.52268,0,0,0.981902,-0.18939,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998456,2724,1,9855.88,2294.68,1322.49,2.9923,0,0,0.997215,0.0745749,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998457,2724,1,9850.09,2308.1,1318.47,1.50397,0,0,0.683091,0.730333,25,100,1,0);
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998458,2724,1,9860.72,2312.53,1322.46,4.83799,0,0,0.661337,-0.750089,25,100,1,0);
# Kodos
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530179,11564,0,0,0,-4897.88,-957.27,501.455,2.71228,25,5,0,2016,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530178,11564,0,0,0,-4900.51,-961.467,501.456,2.71621,25,5,0,2016,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530166,11564,1,0,0,1656.85,-4397.74,21.1823,4.47673,25,5,0,2016,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530176,11564,1,0,0,-1242.48,125.673,130.96,0.405121,25,5,0,2016,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530173,11564,1,0,0,-1229.34,113.178,130.424,2.73303,25,5,0,2016,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530174,11564,1,0,0,-1224.58,126.888,132.24,0.892847,25,5,0,2016,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530175,11564,1,0,0,-1220.32,118.922,132.09,0.251969,25,5,0,2016,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530170,11564,1,0,0,1655.75,-4436.44,17.8476,1.75062,25,5,0,2016,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530169,11564,1,0,0,1643.04,-4428.61,16.4085,0.96443,25,5,0,2016,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530168,11564,1,0,0,1648.11,-4429.28,16.6452,1.01547,25,5,0,2016,0,0,0,0);
# Mules
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530165,16232,1,0,0,9865.06,2306.14,1322.15,3.37559,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530159,16232,1,0,0,9856.2,2299.45,1320.53,3.38737,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530158,16232,1,0,0,9861.53,2298.03,1321.88,3.52089,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530157,16232,1,0,0,9863.87,2312.71,1322.15,3.94108,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530156,16232,1,0,0,9856.26,2297.14,1321.49,3.12348,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530155,16232,0,0,0,1654.77,267.932,-62.179,2.01706,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530153,16232,0,0,0,1649.23,270.502,-62.179,1.15548,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530152,16232,0,0,0,1654.33,261.228,-62.179,5.23405,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530151,16232,0,0,0,1647.01,271.185,-62.1793,1.0746,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530150,16232,0,0,0,-8795.14,650.93,94.9242,3.68236,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530149,16232,0,0,0,-8798.21,646.253,94.4002,2.95588,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530148,16232,0,0,0,-8793.97,644.886,94.4581,2.81059,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530147,16232,0,0,0,-8795.31,647.466,94.5115,2.96767,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530164,16232,1,0,0,9834.02,2295.87,1320.86,4.64872,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530163,16232,1,0,0,9836.12,2307.13,1318.38,6.11034,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530160,16232,1,0,0,9844.59,2296.13,1321.29,6.22108,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530162,16232,1,0,0,9842.58,2301.11,1319.78,0.318031,25,5,0,5100,0,0,1,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530161,16232,1,0,0,9846.26,2293.61,1322.24,0.134248,25,5,0,5100,0,0,1,0);
# NPC quest giver templates
INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_1`,`modelid_2`,`modelid_3`,`modelid_4`,`name`,`subname`,`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`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`Civilian`,`RacialLeader`,`RegenHealth`,`equipment_id`,`trainer_id`,`vendor_id`,`MechanicImmuneMask`,`SchoolImmuneMask`,`flags_extra`,`ScriptName`) VALUES (99994,0,0,11353,0,0,0,'Caravaneer Ruzzleskin','Zeth\'Kur Transfer Co.',30000,33,33,1846,1846,0,0,1200,35,35,3,1.1,1.14286,0,0,46,58,0,132,1,2000,2000,1,512,0,0,0,0,0,0,48.7872,67.0824,100,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,0,1,598,0,0,0,0,2,'');
INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_1`,`modelid_2`,`modelid_3`,`modelid_4`,`name`,`subname`,`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`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`Civilian`,`RacialLeader`,`RegenHealth`,`equipment_id`,`trainer_id`,`vendor_id`,`MechanicImmuneMask`,`SchoolImmuneMask`,`flags_extra`,`ScriptName`) VALUES (99995,0,0,11353,0,0,0,'Caravaneer Ribblescrew','Zeth\'Kur Transfer Co.',30001,33,33,1846,1846,0,0,1200,35,35,3,1.1,1.14286,0,0,46,58,0,132,1,2000,2000,1,512,0,0,0,0,0,0,48.7872,67.0824,100,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,0,1,598,0,0,0,0,2,'');
INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_1`,`modelid_2`,`modelid_3`,`modelid_4`,`name`,`subname`,`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`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`Civilian`,`RacialLeader`,`RegenHealth`,`equipment_id`,`trainer_id`,`vendor_id`,`MechanicImmuneMask`,`SchoolImmuneMask`,`flags_extra`,`ScriptName`) VALUES (99996,0,0,11353,0,0,0,'Caravaneer Fizzlepot','Zeth\'Kur Transfer Co.',30002,33,33,1846,1846,0,0,1200,35,35,3,1.1,1.14286,0,0,46,58,0,132,1,2000,2000,1,512,0,0,0,0,0,0,48.7872,67.0824,100,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,0,1,598,0,0,0,0,2,'');
INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_1`,`modelid_2`,`modelid_3`,`modelid_4`,`name`,`subname`,`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`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`Civilian`,`RacialLeader`,`RegenHealth`,`equipment_id`,`trainer_id`,`vendor_id`,`MechanicImmuneMask`,`SchoolImmuneMask`,`flags_extra`,`ScriptName`) VALUES (99997,0,0,11353,0,0,0,'Caravaneer Rivet','Zeth\'Kur Transfer Co.',30003,33,33,1846,1846,0,0,1200,35,35,3,1.1,1.14286,0,0,46,58,0,132,1,2000,2000,1,512,0,0,0,0,0,0,48.7872,67.0824,100,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,0,1,598,0,0,0,0,2,'');
INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_1`,`modelid_2`,`modelid_3`,`modelid_4`,`name`,`subname`,`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`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`Civilian`,`RacialLeader`,`RegenHealth`,`equipment_id`,`trainer_id`,`vendor_id`,`MechanicImmuneMask`,`SchoolImmuneMask`,`flags_extra`,`ScriptName`) VALUES (99998,0,0,11353,0,0,0,'Caravaneer Wizzlewix','Zeth\'Kur Transfer Co.',30004,33,33,1846,1846,0,0,1200,35,35,3,1.1,1.14286,0,0,46,58,0,132,1,2000,2000,1,512,0,0,0,0,0,0,48.7872,67.0824,100,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,0,1,598,0,0,0,0,2,'');
INSERT INTO `creature_template` (`entry`,`KillCredit1`,`KillCredit2`,`modelid_1`,`modelid_2`,`modelid_3`,`modelid_4`,`name`,`subname`,`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`,`minrangedmg`,`maxrangedmg`,`rangedattackpower`,`type`,`type_flags`,`lootid`,`pickpocketloot`,`skinloot`,`resistance1`,`resistance2`,`resistance3`,`resistance4`,`resistance5`,`resistance6`,`spell1`,`spell2`,`spell3`,`spell4`,`PetSpellDataId`,`mingold`,`maxgold`,`AIName`,`MovementType`,`InhabitType`,`Civilian`,`RacialLeader`,`RegenHealth`,`equipment_id`,`trainer_id`,`vendor_id`,`MechanicImmuneMask`,`SchoolImmuneMask`,`flags_extra`,`ScriptName`) VALUES (99999,0,0,11353,0,0,0,'Caravaneer Wizzywig','Zeth\'Kur Transfer Co.',30005,33,33,1846,1846,0,0,1200,35,35,3,1.1,1.14286,0,0,46,58,0,132,1,2000,2000,1,512,0,0,0,0,0,0,48.7872,67.0824,100,7,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'',0,3,0,0,1,598,0,0,0,0,2,'');
# NPC spawns
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530180,99994,0,0,598,1652.56,272.481,-62.1794,1.26939,25,5,0,1846,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530181,99995,1,0,598,-1218.29,124.719,132.925,0.416116,25,5,0,1846,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530182,99996,1,0,598,1654.02,-4430.25,16.8684,1.40662,25,5,0,1846,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530183,99997,1,0,598,9861.68,2307.9,1322.15,3.55387,25,5,0,1846,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530185,99998,0,0,598,-8799.56,649.044,94.4644,3.38618,25,5,0,1846,0,0,0,0);
INSERT INTO `creature` (`guid`,`id`,`map`,`modelid`,`equipment_id`,`position_x`,`position_y`,`position_z`,`orientation`,`spawntimesecs`,`spawndist`,`currentwaypoint`,`curhealth`,`curmana`,`DeathState`,`MovementType`,`spawnFlags`) VALUES (2530186,99999,0,0,598,-4902.01,-964.698,501.457,2.71384,25,5,0,1846,0,0,0,0);
# NPC event links
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530180', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530181', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530182', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530183', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530185', '79');
INSERT INTO `game_event_creature` (`guid`, `event`) VALUES ('2530186', '79');
# gossip_menu
INSERT INTO `gossip_menu` (`entry`,`text_id`,`condition_id`) VALUES (30000,500004,0);
INSERT INTO `gossip_menu` (`entry`,`text_id`,`condition_id`) VALUES (30001,500003,0);
INSERT INTO `gossip_menu` (`entry`,`text_id`,`condition_id`) VALUES (30002,500002,0);
INSERT INTO `gossip_menu` (`entry`,`text_id`,`condition_id`) VALUES (30003,500001,0);
INSERT INTO `gossip_menu` (`entry`,`text_id`,`condition_id`) VALUES (30004,500005,0);
INSERT INTO `gossip_menu` (`entry`,`text_id`,`condition_id`) VALUES (30005,500000,0);
INSERT INTO `gossip_menu` (`entry`,`text_id`,`condition_id`) VALUES (30006,500007,0);
INSERT INTO `gossip_menu` (`entry`,`text_id`,`condition_id`) VALUES (30007,500008,0);
INSERT INTO `gossip_menu` (`entry`,`text_id`,`condition_id`) VALUES (30008,500006,0);
# gossip_menu_option
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30000,0,0,'I\'d like to learn about Anathema.',1,1,30008,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30000,1,0,'I\'d like to learn about Darrowshire.',1,1,30006,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30000,2,0,'I\'d like to learn about Elysium.',1,1,30007,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30001,0,0,'I\'d like to learn about Anathema.',1,1,30008,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30001,1,0,'I\'d like to learn about Darrowshire.',1,1,30006,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30001,2,0,'I\'d like to learn about Elysium.',1,1,30007,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30002,0,0,'I\'d like to learn about Anathema.',1,1,30008,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30002,1,0,'I\'d like to learn about Darrowshire.',1,1,30006,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30002,2,0,'I\'d like to learn about Elysium.',1,1,30007,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30003,0,0,'I\'d like to learn about Anathema.',1,1,30008,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30003,1,0,'I\'d like to learn about Darrowshire.',1,1,30006,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30003,2,0,'I\'d like to learn about Elysium.',1,1,30007,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30004,0,0,'I\'d like to learn about Anathema.',1,1,30008,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30004,1,0,'I\'d like to learn about Darrowshire.',1,1,30006,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30004,2,0,'I\'d like to learn about Elysium.',1,1,30007,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30005,0,0,'I\'d like to learn about Anathema.',1,1,30008,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30005,1,0,'I\'d like to learn about Darrowshire.',1,1,30006,0,0,0,0,NULL,0);
INSERT INTO `gossip_menu_option` (`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`,`condition_id`) VALUES (30005,2,0,'I\'d like to learn about Elysium.',1,1,30007,0,0,0,0,NULL,0);
# npc_text
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`) VALUES (500000,'What\'s the problem, $N? Have you never seen a kodo before? A kodo can do the work of several packmules - it\'s just good logistics and good logistics make for a good bottom line.$B$BAnd no, that isn\'t a Horde insignia on the kodo. It\'s the Zeth\'Kur Transfer Co. insignia! They look nothing alike.$B$BLook, $N, my caravan will be leaving on June 21st, so make sure you\'ve made your decision before I depart.$B$BIf you want to learn more about the three lands my caravan will be stopping at, simply ask. Discuss your choices with your allies and then talk to me again to purchase your ticket.$B$BA word of advice though, $N - it\'s a long journey and you seem a bit... ripe. You might want to consider freshening up for the benefit of your fellow travelers.$B$BWhat? It isn\'t you? Oh, bad kodo!$B',NULL,0,1,0,0,0,0,0,0,'',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);
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`) VALUES (500001,'Another $r $c? You are a $c, right? Your choice of outfit makes it difficult to tell. Company regulations strictly prohibit us from selling caravan tickets to more than two of each race and class.$B$B*Caravenner Fizzlepot looks at you sympathetically.*$B$BFine, I\'ll sell you a ticket but make it quick. My caravan will be departing here on June 21st, so make sure you\'ve purchased your ticket before I depart. If anybody asks, you told me that you\'re a monk.$B$BOh, before you go, it would be wise to take suitable precautions by purchasing another outfit. If the ticket inspectors sniff you out, there will be no journey and no refund.$B',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,NULL,NULL,0,0,0,0,0,0,0,0);
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`) VALUES (500002,'Mok\'ra, $N! Are you here to join my caravan?$B$B*Caravenner Fizzlepot thumbs through what appears to be small booklet of common Orcish phrases*$B$BMy caravan will be stopping at two dimensions before our third and final stop. If you want to learn more about the three dimensions, simply ask and I\'ll tell you what I know. Zug zug, $r?$B$BMy caravan will be departing Orgrimmar on June 21st, so make sure you\'ve purchased your ticket before then. $B$BDiscuss your choices with your allies and then talk to me again to purchase your ticket.$B$BBefore you go, $N, I had an unpleasant encounter with an orc earlier. He muttered what sounded like \'mu gezzno\' to my untrained ears. Perhaps you could translate that for me?$B',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,NULL,NULL,0,0,0,0,0,0,0,0);
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`) VALUES (500003,'Thunderbluff is a beautiful city, isn\'t it, $N? It makes me yearn for the simple life. I sure hope the Thunderbluff on the other side of the dimensional rift is as peaceful as this one.$B$BYou didn\'t know about the dimensional rift? My colleague in Stormwind could tell you more about that but it\'s way over my head.$B$BRift or no rift, my caravan will be leaving on June 21st, so make sure you\'ve purchased your ticket before I depart.$B$BIf you want to learn more about the three lands my caravan will be stopping at, simply ask. Discuss your choices with your allies and then talk to me again to purchase your ticket.$B',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,NULL,NULL,0,0,0,0,0,0,0,0);
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`) VALUES (500004,'Egads, don\'t scare me like that, $c! Any closer to the edge and I\'m worried that I\'ll lose my marbles. I\'m cursing my company for stationing me in this forsaken sewer.$B$BThe only silver lining to my posting here is that I\'ll never again be able to claim that I\'m the most handsome creature around.$B$BLook, $c, my caravan will be leaving on June 21st, so make sure you\'ve made your decision before I depart.$B$BIf I\'ve fled this damnation before you\'ve made your decision, don\'t be too surprised. You\'ll be able to find my colleagues in Orgrimmar and Thunderbluff.$B$BIf you want to learn more about the three lands my caravan will be stopping at, simply ask. Discuss your choices with your allies and then talk to me again to purchase your ticket.$B',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,NULL,NULL,0,0,0,0,0,0,0,0);
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`) VALUES (500005,'We all knew gnomes would eventually be responsible for a catastrophe but who could have guessed it would bring the end times?$B$BMeddling with technology far beyond their comprehension, the gnomes discovered the Titan Particle and unleashed a dimensional rift upon Azeroth. If only us goblins had more time, we could undoubtedly find a way to contain the rift. At the current rate of expansion, this reality is projected to cease to exist by the end of the month.$B$BFortunately, goblin ingenuity has discovered a method to harness the rift to travel to other dimensions and yes, we\'ll be using these mules to get there. Don\'t sweat the details, your simple $r mind wouldn\'t understand the science.$B$BMy caravan will be leaving on June 21st, so make sure you\'ve made your decision before I depart. Who knows where you\'ll end up if you allow the rift to swallow you whole.$B$BIt isn\'t safe to go alone, so review your choices, confer with your allies and then talk to me again to purchase your ticket.$B',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,NULL,NULL,0,0,0,0,0,0,0,0);
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`) VALUES (500006,'Anathema is a PvP realm on patch 1.9 offering the largest choice of content from the three realms.$B$BAll battlegrounds are available and the raid content includes Molten Core, Onyxia, Blackwing Lair, Zul\'Gurub, Ahn\'Qiraj, Nightmare Dragons, Kazzak and Azuregos.$B$BGuilds are always looking for new members to bolster their rosters and replace fallen heroes.$B$BKel\'Thuzad is expected to begin his assault on Anathema in September, giving newcomers ample time to upgrade their garb in preparation.',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,NULL,NULL,0,0,0,0,0,0,0,0);
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`) VALUES (500007,'Darrowshire is a peaceful PvE server on patch 1.7.$B$BAll battlegrounds are available and the raid content includes Molten Core, Onyxia, Blackwing Lair, Zul\'Gurub, Kazzak and Azuregos.$B$BThe next patch will unlease the Nightmare Dragons upon the world, with the next again patch unlocking The Gates of Ahn\'Qiraj.',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,NULL,NULL,0,0,0,0,0,0,0,0);
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`) VALUES (500008,'Elysium is a PvP realm on patch 1.3, matching Zeth\'Kur, and is the newest of the three realms.$B$BWarsong Gulch and Arathi Basin are available, with Alterac Valley opening at the end of June.$B$BCurrent raid content includes Onyxia, Molten Core, Kazzak and Azuregos, with Blackwing Lair being released in the very near future.',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,NULL,NULL,0,0,0,0,0,0,0,0);
# quest
INSERT INTO `quest_template` (`entry`,`Method`,`ZoneOrSort`,`MinLevel`,`QuestLevel`,`Type`,`RequiredClasses`,`RequiredRaces`,`RequiredSkill`,`RequiredSkillValue`,`RepObjectiveFaction`,`RepObjectiveValue`,`RequiredMinRepFaction`,`RequiredMinRepValue`,`RequiredMaxRepFaction`,`RequiredMaxRepValue`,`SuggestedPlayers`,`LimitTime`,`QuestFlags`,`SpecialFlags`,`PrevQuestId`,`NextQuestId`,`ExclusiveGroup`,`NextQuestInChain`,`SrcItemId`,`SrcItemCount`,`SrcSpell`,`Title`,`Details`,`Objectives`,`OfferRewardText`,`RequestItemsText`,`EndText`,`ObjectiveText1`,`ObjectiveText2`,`ObjectiveText3`,`ObjectiveText4`,`ReqItemId1`,`ReqItemId2`,`ReqItemId3`,`ReqItemId4`,`ReqItemCount1`,`ReqItemCount2`,`ReqItemCount3`,`ReqItemCount4`,`ReqSourceId1`,`ReqSourceId2`,`ReqSourceId3`,`ReqSourceId4`,`ReqSourceCount1`,`ReqSourceCount2`,`ReqSourceCount3`,`ReqSourceCount4`,`ReqCreatureOrGOId1`,`ReqCreatureOrGOId2`,`ReqCreatureOrGOId3`,`ReqCreatureOrGOId4`,`ReqCreatureOrGOCount1`,`ReqCreatureOrGOCount2`,`ReqCreatureOrGOCount3`,`ReqCreatureOrGOCount4`,`ReqSpellCast1`,`ReqSpellCast2`,`ReqSpellCast3`,`ReqSpellCast4`,`RewChoiceItemId1`,`RewChoiceItemId2`,`RewChoiceItemId3`,`RewChoiceItemId4`,`RewChoiceItemId5`,`RewChoiceItemId6`,`RewChoiceItemCount1`,`RewChoiceItemCount2`,`RewChoiceItemCount3`,`RewChoiceItemCount4`,`RewChoiceItemCount5`,`RewChoiceItemCount6`,`RewItemId1`,`RewItemId2`,`RewItemId3`,`RewItemId4`,`RewItemCount1`,`RewItemCount2`,`RewItemCount3`,`RewItemCount4`,`RewRepFaction1`,`RewRepFaction2`,`RewRepFaction3`,`RewRepFaction4`,`RewRepFaction5`,`RewRepValue1`,`RewRepValue2`,`RewRepValue3`,`RewRepValue4`,`RewRepValue5`,`RewOrReqMoney`,`RewMoneyMaxLevel`,`RewSpell`,`RewSpellCast`,`RewMailTemplateId`,`RewMailDelaySecs`,`PointMapId`,`PointX`,`PointY`,`PointOpt`,`DetailsEmote1`,`DetailsEmote2`,`DetailsEmote3`,`DetailsEmote4`,`DetailsEmoteDelay1`,`DetailsEmoteDelay2`,`DetailsEmoteDelay3`,`DetailsEmoteDelay4`,`IncompleteEmote`,`CompleteEmote`,`OfferRewardEmote1`,`OfferRewardEmote2`,`OfferRewardEmote3`,`OfferRewardEmote4`,`OfferRewardEmoteDelay1`,`OfferRewardEmoteDelay2`,`OfferRewardEmoteDelay3`,`OfferRewardEmoteDelay4`,`StartScript`,`CompleteScript`) VALUES (137706,2,3459,1,60,0,0,0,0,0,0,0,0,0,0,0,0,0,2,0,0,0,0,0,0,0,0,'A Strange Journey','Are you ready to decide where you\'d like to go, $N? Please remember, this transaction is for a one-way, non-refundable ticket, so make sure you\'re happy with your choice before you proceed with your purchase.$B$BI\'ll give you one final opportunity to assess your options.','Return to the caravaneer when you\'re ready to purchase your ticket.','Have you come to a conclusion, $N? Remember, there is no going back from this choice!',NULL,NULL,'Objective1','Objective2','Objective3','Objective4',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,50002,50001,50003,0,0,0,1,1,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,6,0,0,0,0,0,0,0,0,3,4,3,0,0,0,0,0,0,0,0);
INSERT INTO `game_event_quest` (`quest`, `event`) VALUES ('137706', '79');
# questrelation
INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES (99994,137706);
INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES (99995,137706);
INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES (99996,137706);
INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES (99997,137706);
INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES (99998,137706);
INSERT INTO `creature_questrelation` (`id`,`quest`) VALUES (99999,137706);
# involvedrelation
INSERT INTO `creature_involvedrelation` (`id`,`quest`) VALUES (99994,137706);
INSERT INTO `creature_involvedrelation` (`id`,`quest`) VALUES (99995,137706);
INSERT INTO `creature_involvedrelation` (`id`,`quest`) VALUES (99996,137706);
INSERT INTO `creature_involvedrelation` (`id`,`quest`) VALUES (99997,137706);
INSERT INTO `creature_involvedrelation` (`id`,`quest`) VALUES (99998,137706);
INSERT INTO `creature_involvedrelation` (`id`,`quest`) VALUES (99999,137706);
# quest reward items
INSERT INTO `item_template` (`entry`,`class`,`subclass`,`name`,`displayid`,`Quality`,`Flags`,`BuyCount`,`BuyPrice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`requiredhonorrank`,`RequiredCityRank`,`RequiredReputationFaction`,`RequiredReputationRank`,`maxcount`,`stackable`,`ContainerSlots`,`stat_type1`,`stat_value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`stat_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`stat_value7`,`stat_type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_type10`,`stat_value10`,`dmg_min1`,`dmg_max1`,`dmg_type1`,`dmg_min2`,`dmg_max2`,`dmg_type2`,`dmg_min3`,`dmg_max3`,`dmg_type3`,`dmg_min4`,`dmg_max4`,`dmg_type4`,`dmg_min5`,`dmg_max5`,`dmg_type5`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`arcane_res`,`delay`,`ammo_type`,`RangedModRange`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spellppmRate_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigger_2`,`spellcharges_2`,`spellppmRate_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellppmRate_3`,`spellcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`spellppmRate_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellppmRate_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycooldown_5`,`bonding`,`description`,`PageText`,`LanguageID`,`PageMaterial`,`startquest`,`lockid`,`Material`,`sheath`,`RandomProperty`,`block`,`itemset`,`MaxDurability`,`area`,`Map`,`BagFamily`,`ScriptName`,`DisenchantID`,`FoodType`,`minMoneyLoot`,`maxMoneyLoot`,`Duration`,`ExtraFlags`,`OtherTeamEntry`) VALUES (50003,0,0,'Elysium Caravan Ticket',31745,1,0,1,0,0,0,-1,-1,1,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,0,0,0,1,'This ticket entitles the holder to a one-way trip to Elysium on June 21st. Strictly non-refundable.',0,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,1);
INSERT INTO `item_template` (`entry`,`class`,`subclass`,`name`,`displayid`,`Quality`,`Flags`,`BuyCount`,`BuyPrice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`requiredhonorrank`,`RequiredCityRank`,`RequiredReputationFaction`,`RequiredReputationRank`,`maxcount`,`stackable`,`ContainerSlots`,`stat_type1`,`stat_value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`stat_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`stat_value7`,`stat_type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_type10`,`stat_value10`,`dmg_min1`,`dmg_max1`,`dmg_type1`,`dmg_min2`,`dmg_max2`,`dmg_type2`,`dmg_min3`,`dmg_max3`,`dmg_type3`,`dmg_min4`,`dmg_max4`,`dmg_type4`,`dmg_min5`,`dmg_max5`,`dmg_type5`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`arcane_res`,`delay`,`ammo_type`,`RangedModRange`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spellppmRate_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigger_2`,`spellcharges_2`,`spellppmRate_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellppmRate_3`,`spellcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`spellppmRate_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellppmRate_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycooldown_5`,`bonding`,`description`,`PageText`,`LanguageID`,`PageMaterial`,`startquest`,`lockid`,`Material`,`sheath`,`RandomProperty`,`block`,`itemset`,`MaxDurability`,`area`,`Map`,`BagFamily`,`ScriptName`,`DisenchantID`,`FoodType`,`minMoneyLoot`,`maxMoneyLoot`,`Duration`,`ExtraFlags`,`OtherTeamEntry`) VALUES (50002,0,0,'Anathema Caravan Ticket',31745,1,0,1,0,0,0,-1,-1,1,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,0,0,0,1,'This ticket entitles the holder to a one-way trip to Anathema on June 21st. Strictly non-refundable.',0,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,1);
INSERT INTO `item_template` (`entry`,`class`,`subclass`,`name`,`displayid`,`Quality`,`Flags`,`BuyCount`,`BuyPrice`,`SellPrice`,`InventoryType`,`AllowableClass`,`AllowableRace`,`ItemLevel`,`RequiredLevel`,`RequiredSkill`,`RequiredSkillRank`,`requiredspell`,`requiredhonorrank`,`RequiredCityRank`,`RequiredReputationFaction`,`RequiredReputationRank`,`maxcount`,`stackable`,`ContainerSlots`,`stat_type1`,`stat_value1`,`stat_type2`,`stat_value2`,`stat_type3`,`stat_value3`,`stat_type4`,`stat_value4`,`stat_type5`,`stat_value5`,`stat_type6`,`stat_value6`,`stat_type7`,`stat_value7`,`stat_type8`,`stat_value8`,`stat_type9`,`stat_value9`,`stat_type10`,`stat_value10`,`dmg_min1`,`dmg_max1`,`dmg_type1`,`dmg_min2`,`dmg_max2`,`dmg_type2`,`dmg_min3`,`dmg_max3`,`dmg_type3`,`dmg_min4`,`dmg_max4`,`dmg_type4`,`dmg_min5`,`dmg_max5`,`dmg_type5`,`armor`,`holy_res`,`fire_res`,`nature_res`,`frost_res`,`shadow_res`,`arcane_res`,`delay`,`ammo_type`,`RangedModRange`,`spellid_1`,`spelltrigger_1`,`spellcharges_1`,`spellppmRate_1`,`spellcooldown_1`,`spellcategory_1`,`spellcategorycooldown_1`,`spellid_2`,`spelltrigger_2`,`spellcharges_2`,`spellppmRate_2`,`spellcooldown_2`,`spellcategory_2`,`spellcategorycooldown_2`,`spellid_3`,`spelltrigger_3`,`spellcharges_3`,`spellppmRate_3`,`spellcooldown_3`,`spellcategory_3`,`spellcategorycooldown_3`,`spellid_4`,`spelltrigger_4`,`spellcharges_4`,`spellppmRate_4`,`spellcooldown_4`,`spellcategory_4`,`spellcategorycooldown_4`,`spellid_5`,`spelltrigger_5`,`spellcharges_5`,`spellppmRate_5`,`spellcooldown_5`,`spellcategory_5`,`spellcategorycooldown_5`,`bonding`,`description`,`PageText`,`LanguageID`,`PageMaterial`,`startquest`,`lockid`,`Material`,`sheath`,`RandomProperty`,`block`,`itemset`,`MaxDurability`,`area`,`Map`,`BagFamily`,`ScriptName`,`DisenchantID`,`FoodType`,`minMoneyLoot`,`maxMoneyLoot`,`Duration`,`ExtraFlags`,`OtherTeamEntry`) VALUES (50001,0,0,'Darrowshire Caravan Ticket',31745,1,0,1,0,0,0,-1,-1,1,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,-1,0,-1,0,0,0,0,0,0,0,1,'This ticket entitles the holder to a one-way trip to Darrowshire on June 21st. Strictly non-refundable.',0,0,0,0,0,7,0,0,0,0,0,0,0,0,'',0,0,0,0,0,0,1);
# kodo poop
INSERT INTO `gameobject` (`guid`,`id`,`map`,`position_x`,`position_y`,`position_z`,`orientation`,`rotation0`,`rotation1`,`rotation2`,`rotation3`,`spawntimesecs`,`animprogress`,`state`,`spawnFlags`) VALUES (3998501,182128,0,-4896.3,-963.939,501.446,2.49786,0,0,0.948647,0.316337,25,100,1,0);
INSERT INTO `game_event_gameobject` (`guid`, `event`) VALUES ('3998501', '79');
Reference in a new issue View git blame Copy permalink