diff options
| author | Shauren <shauren.trinity@gmail.com> | 2016-07-06 00:05:13 +0200 |
|---|---|---|
| committer | Shauren <shauren.trinity@gmail.com> | 2016-07-06 00:05:13 +0200 |
| commit | 70137b8f3aae7c875f1fc0b1643d80aece933104 (patch) | |
| tree | 2ffc5d94bca4988dd5ba5af1a4bd3f077de5e238 /sql/updates | |
| parent | f7883bd5251a759da1ca8be3ba6f6cead36723ec (diff) | |
| parent | a7fcae93280d5d8010c4fe8139ce1925a92c8744 (diff) | |
Merge branch '6.x' of https://github.com/TrinityCore/TrinityCore into legion
Diffstat (limited to 'sql/updates')
30 files changed, 2003 insertions, 0 deletions
diff --git a/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_11.sql b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_11.sql new file mode 100644 index 00000000000..ac0e9d5a81b --- /dev/null +++ b/sql/updates/hotfixes/2016_xx_xx_xx_hotfixes_legion_11.sql @@ -0,0 +1,13 @@ +ALTER TABLE `item_upgrade` + CHANGE `CurrencyCost` `CurrencyCost` int(10) unsigned NOT NULL DEFAULT '0' AFTER `ID`, + CHANGE `PrevItemUpgradeID` `PrevItemUpgradeID` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `CurrencyCost`, + CHANGE `CurrencyID` `CurrencyID` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `PrevItemUpgradeID`, + CHANGE `ItemUpgradePathID` `ItemUpgradePathID` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `CurrencyID`, + CHANGE `ItemLevelBonus` `ItemLevelBonus` tinyint(3) unsigned NOT NULL DEFAULT '0' AFTER `ItemUpgradePathID`; + +ALTER TABLE `ruleset_item_upgrade` + CHANGE `ItemID` `ItemID` int(10) unsigned NOT NULL DEFAULT '0' AFTER `ID`, + CHANGE `ItemUpgradeID` `ItemUpgradeID` smallint(5) unsigned NOT NULL DEFAULT '0' AFTER `ItemID`, + DROP `RulesetID`; + +ALTER TABLE `skill_line_ability` CHANGE `AquireMethod` `AcquireMethod` tinyint(3) unsigned NOT NULL DEFAULT '0'; diff --git a/sql/updates/hotfixes/6.x/2016_06_21_00_hotfixes.sql b/sql/updates/hotfixes/6.x/2016_06_21_00_hotfixes.sql new file mode 100644 index 00000000000..e2ca7d2ce65 --- /dev/null +++ b/sql/updates/hotfixes/6.x/2016_06_21_00_hotfixes.sql @@ -0,0 +1,27 @@ +-- +-- Table structure for table `item_upgrade` +-- +DROP TABLE IF EXISTS `item_upgrade`; +CREATE TABLE `item_upgrade` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemUpgradePathID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemLevelBonus` int(10) unsigned NOT NULL DEFAULT '0', + `PrevItemUpgradeID` int(10) unsigned NOT NULL DEFAULT '0', + `CurrencyID` int(10) unsigned NOT NULL DEFAULT '0', + `CurrencyCost` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +-- +-- Table structure for table `ruleset_item_upgrade` +-- +DROP TABLE IF EXISTS `ruleset_item_upgrade`; +CREATE TABLE `ruleset_item_upgrade` ( + `ID` int(10) unsigned NOT NULL DEFAULT '0', + `RulesetID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemUpgradeID` int(10) unsigned NOT NULL DEFAULT '0', + `ItemID` int(10) unsigned NOT NULL DEFAULT '0', + `VerifiedBuild` smallint(6) NOT NULL DEFAULT '0', + PRIMARY KEY (`ID`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; diff --git a/sql/updates/world/3.3.5/2016_07_05_02_world.sql b/sql/updates/world/3.3.5/2016_07_05_02_world.sql new file mode 100644 index 00000000000..2921c19b0c1 --- /dev/null +++ b/sql/updates/world/3.3.5/2016_07_05_02_world.sql @@ -0,0 +1 @@ +UPDATE `command` SET `help` = 'Syntax: .cometome\nMake selected creature come to your current location (new position not saved to DB).' WHERE `command`.`name` = 'cometome'; diff --git a/sql/updates/world/6.x/2016_06_14_00_world.sql b/sql/updates/world/6.x/2016_06_14_00_world.sql new file mode 100644 index 00000000000..4f597165174 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_14_00_world.sql @@ -0,0 +1,26 @@ +-- +SET @FIRSTTROUGH := 36727; +SET @SECONDTROUGH := 37155; +SET @THIRDTROUGH := 37156; +SET @BURNEFFECT := 42345; +SET @SPELLTHROWTORCH := 69228; + +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=1 AND `SourceEntry`=@SPELLTHROWTORCH; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,@SPELLTHROWTORCH,0,0,31,0,3,@THIRDTROUGH, 0,0,"","Throw Torch target Third Trough"), +(13,1,@SPELLTHROWTORCH,0,1,31,0,3,@SECONDTROUGH,0,0,"","Throw Torch target Second Trough"), +(13,1,@SPELLTHROWTORCH,0,2,31,0,3,@FIRSTTROUGH, 0,0,"","Throw Torch target First Trough"); + +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@FIRSTTROUGH; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@SECONDTROUGH; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@THIRDTROUGH; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@FIRSTTROUGH AND `source_type`=0 AND `id` in (0,1); +DELETE FROM `smart_scripts` WHERE `entryorguid`=@SECONDTROUGH AND `source_type`=0 AND `id` in (0,1); +DELETE FROM `smart_scripts` WHERE `entryorguid`=@THIRDTROUGH AND `source_type`=0 AND `id` in (0,1); +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@FIRSTTROUGH,0,0,1,8,0,100,0,@SPELLTHROWTORCH,0,0,0,33,@FIRSTTROUGH,0,0,0,0,0,7,0,0,0,0,0,0,0,"First Trough - On Spellhit 'Throw Torch' - Quest Credit 'Feed of Evil'"), +(@FIRSTTROUGH,0,1,0,61,0,100,0,@SPELLTHROWTORCH,0,0,0,11,@BURNEFFECT,0,0,0,0,0,1,0,0,0,0,0,0,0,"First Trough - On Spellhit 'Throw Torch' - Cast 'Cosmetic - Flame Patch'"), +(@SECONDTROUGH,0,0,1,8,0,100,0,@SPELLTHROWTORCH,0,0,0,33,@SECONDTROUGH,0,0,0,0,0,7,0,0,0,0,0,0,0,"Second Trough - On Spellhit 'Throw Torch' - Quest Credit 'Feed of Evil'"), +(@SECONDTROUGH,0,1,0,61,0,100,0,@SPELLTHROWTORCH,0,0,0,11,@BURNEFFECT,0,0,0,0,0,1,0,0,0,0,0,0,0,"Second Trough - On Spellhit 'Throw Torch' - Cast 'Cosmetic - Flame Patch'"), +(@THIRDTROUGH,0,0,1,8,0,100,0,@SPELLTHROWTORCH,0,0,0,33,@THIRDTROUGH,0,0,0,0,0,7,0,0,0,0,0,0,0,"Third Trough - On Spellhit 'Throw Torch' - Quest Credit 'Feed of Evil'"), +(@THIRDTROUGH,0,1,0,61,0,100,0,@SPELLTHROWTORCH,0,0,0,11,@BURNEFFECT,0,0,0,0,0,1,0,0,0,0,0,0,0,"Third Trough - On Spellhit 'Throw Torch' - Cast 'Cosmetic - Flame Patch'"); diff --git a/sql/updates/world/6.x/2016_06_15_00_world.sql b/sql/updates/world/6.x/2016_06_15_00_world.sql new file mode 100644 index 00000000000..cd2de3f62ff --- /dev/null +++ b/sql/updates/world/6.x/2016_06_15_00_world.sql @@ -0,0 +1,8 @@ +-- +DELETE FROM `terrain_swap_defaults` WHERE `MapId`= 0 AND `TerrainSwapMap`= 1190; +INSERT INTO `terrain_swap_defaults` (`MapId`,`TerrainSwapMap`,`Comment`) VALUES +(0, 1190, 'Blasted Land Terrian'); + +DELETE FROM `terrain_worldmap` WHERE `TerrainSwapMap`= 545 AND `WorldMapArea`= 683; +INSERT INTO `terrain_worldmap` (`TerrainSwapMap`,`WorldMapArea`,`Comment`) VALUES +(545, 683, 'Blasted Land Swap'); diff --git a/sql/updates/world/6.x/2016_06_15_01_world.sql b/sql/updates/world/6.x/2016_06_15_01_world.sql new file mode 100644 index 00000000000..a24ec70a972 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_15_01_world.sql @@ -0,0 +1,50 @@ +-- +SET @NPC := 452424; +DELETE FROM `creature` WHERE `guid`=@NPC; +INSERT INTO `creature` (`guid`, `id`, `map`, `position_x`, `position_y`, `position_z`) VALUES (@NPC, 50839,0, -7507.344, -1167.55, 261.0904); +-- Pathing for Chromehound Entry: 50839 'TDB FORMAT' +SET @PATH := @NPC * 10; +UPDATE `creature` SET `spawndist`=0,`MovementType`=2,`position_x`=-7507.344,`position_y`=-1167.55,`position_z`=261.0904 WHERE `guid`=@NPC; +DELETE FROM `creature_addon` WHERE `guid`=@NPC; +INSERT INTO `creature_addon` (`guid`,`path_id`,`mount`,`bytes1`,`bytes2`,`emote`,`auras`) VALUES (@NPC,@PATH,0,0,1,0, ''); +DELETE FROM `waypoint_data` WHERE `id`=@PATH; +INSERT INTO `waypoint_data` (`id`,`point`,`position_x`,`position_y`,`position_z`,`orientation`,`delay`,`move_type`,`action`,`action_chance`,`wpguid`) VALUES +(@PATH,1,-7507.344,-1167.55,261.0904,0,0,0,0,100,0), +(@PATH,2,-7492.085,-1164.431,262.7305,0,0,0,0,100,0), +(@PATH,3,-7489.484,-1149.292,264.4326,0,0,0,0,100,0), +(@PATH,4,-7490.816,-1130.962,265.503,0,0,0,0,100,0), +(@PATH,5,-7494.488,-1121.899,265.6144,0,0,0,0,100,0), +(@PATH,6,-7492.366,-1110.879,266.0537,0,0,0,0,100,0), +(@PATH,7,-7493.984,-1094.67,265.577,0,0,0,0,100,0), +(@PATH,8,-7495.3,-1083.632,265.1164,0,0,0,0,100,0), +(@PATH,9,-7503.222,-1072.288,264.4205,0,0,0,0,100,0), +(@PATH,10,-7507.295,-1060.439,263.3694,0,0,0,0,100,0), +(@PATH,11,-7521.344,-1044.481,260.9198,0,0,0,0,100,0), +(@PATH,12,-7531.807,-1033.694,258.3916,0,0,0,0,100,0), +(@PATH,13,-7550.604,-1024.927,254.4957,0,0,0,0,100,0), +(@PATH,14,-7566.979,-1019.031,250.771,0,0,0,0,100,0), +(@PATH,15,-7587.071,-1014.3,246.2627,0,0,0,0,100,0), +(@PATH,16,-7609.59,-1013.542,240.6937,0,0,0,0,100,0), +(@PATH,17,-7628.318,-1020.125,235.8074,0,0,0,0,100,0), +(@PATH,18,-7643.806,-1026.658,231.2818,0,0,0,0,100,0), +(@PATH,19,-7662.762,-1041.675,225.5605,0,0,0,0,100,0), +(@PATH,20,-7679.563,-1057.769,220.2642,0,0,0,0,100,0), +(@PATH,21,-7687.872,-1075.955,218.3654,0,0,0,0,100,0), +(@PATH,22,-7692.823,-1094.333,217.3829,0,0,0,0,100,0), +(@PATH,23,-7699.91,-1104.755,216.755,0,0,0,0,100,0), +(@PATH,24,-7698.327,-1124.78,215.6021,0,0,0,0,100,0), +(@PATH,25,-7693.615,-1147.448,215.0171,0,0,0,0,100,0), +(@PATH,26,-7688.542,-1162.736,215.4126,0,0,0,0,100,0), +(@PATH,27,-7678.569,-1177.247,217.1286,0,0,0,0,100,0), +(@PATH,28,-7665.182,-1194.701,220.6102,0,0,0,0,100,0), +(@PATH,29,-7649.865,-1205.075,224.4757,0,0,0,0,100,0), +(@PATH,30,-7635.476,-1212.811,228.4464,0,0,0,0,100,0), +(@PATH,31,-7622.031,-1217.165,231.4845,0,0,0,0,100,0), +(@PATH,32,-7605.257,-1222.564,234.1023,0,0,0,0,100,0), +(@PATH,33,-7593.495,-1223.609,237.124,0,0,0,0,100,0), +(@PATH,34,-7579.444,-1221.302,241.1097,0,0,0,0,100,0), +(@PATH,35,-7564.16,-1218.061,245.7083,0,0,0,0,100,0), +(@PATH,36,-7547.385,-1211.174,249.913,0,0,0,0,100,0), +(@PATH,37,-7532.037,-1200.672,253.8217,0,0,0,0,100,0), +(@PATH,38,-7522.413,-1193.398,256.1735,0,0,0,0,100,0), +(@PATH,39,-7515.12,-1179.415,258.7101,0,0,0,0,100,0); diff --git a/sql/updates/world/6.x/2016_06_15_02_world.sql b/sql/updates/world/6.x/2016_06_15_02_world.sql new file mode 100644 index 00000000000..830b14012c0 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_15_02_world.sql @@ -0,0 +1,14 @@ +-- +SET @OGUID := 300915; -- set by TDB team (1) + +DELETE FROM `gameobject_template` WHERE `entry`=244447; +INSERT INTO `gameobject_template` (`entry`, `type`, `displayId`, `name`, `IconName`, `castBarCaption`, `unk1`, `size`, `Data0`, `Data1`, `Data2`, `Data3`, `Data4`, `Data5`, `Data6`, `Data7`, `Data8`, `Data9`, `Data10`, `Data11`, `Data12`, `Data13`, `Data14`, `Data15`, `Data16`, `Data17`, `Data18`, `Data19`, `Data20`, `Data21`, `Data22`, `Data23`, `Data24`, `Data25`, `Data26`, `Data27`, `Data28`, `Data29`, `Data30`, `Data31`, `Data32`, `unkInt32`, `VerifiedBuild`) VALUES +(244447, 3, 3851, 'White Murloc Egg', '', '', '', 1, 1691, 62019, 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, 20726); -- White Murloc Egg + +DELETE FROM `gameobject` WHERE `guid`=@OGUID+0; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `PhaseID`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`, `VerifiedBuild`) VALUES +(@OGUID+0, 244447, 571, 1, 0, 1462.983, 5422.067, 0.6317602, 4.443114, 0, 0, 0, 1, 5, 255, 1, 20726); -- White Murloc Egg (Area: Riplash Ruins) + +DELETE FROM `gameobject_loot_template` WHERE `Entry`=244447; +INSERT INTO `gameobject_loot_template` (`Entry`, `Item`, `Reference`, `Chance`, `QuestRequired`, `LootMode`, `GroupId`, `MinCount`, `MaxCount`, `Comment`) VALUES +(244447, 22780, 0, 100, 0, 1, 0, 1, 1, 'White Murloc Egg'); diff --git a/sql/updates/world/6.x/2016_06_15_03_world.sql b/sql/updates/world/6.x/2016_06_15_03_world.sql new file mode 100644 index 00000000000..f1b024e2d30 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_15_03_world.sql @@ -0,0 +1,6 @@ +-- +-- remove loot item 4893, 'Savannah Lion Tusk' from the loot table +-- move loot item 5096 from Savannah Prowler (3425) to Savannah Huntress (3415) +DELETE FROM `creature_loot_template` WHERE `Item` IN (4893,5096); +INSERT INTO `creature_loot_template` (`Entry`,`Item`,`Reference`,`Chance`,`QuestRequired`,`LootMode`,`GroupId`,`MinCount`,`MaxCount`,`Comment`) VALUES +(3415, 5096, 0, 50.08, 1, 1, 0, 1, 1, NULL); diff --git a/sql/updates/world/6.x/2016_06_15_04_world.sql b/sql/updates/world/6.x/2016_06_15_04_world.sql new file mode 100644 index 00000000000..be66984e8e0 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_15_04_world.sql @@ -0,0 +1,6 @@ +-- +DELETE FROM `spell_area` WHERE `spell` IN (60922, 49417, 49416) AND `quest_start` = 14071; +INSERT INTO `spell_area` (`spell`, `area`, `quest_start`, `gender`, `autocast`, `quest_start_status`) VALUES +(60922, 4765, 14071, 2, 1, 8), +(49417, 4737, 14071, 2, 1, 8), +(49416, 4767, 14071, 2, 1, 8); diff --git a/sql/updates/world/6.x/2016_06_15_05_world.sql b/sql/updates/world/6.x/2016_06_15_05_world.sql new file mode 100644 index 00000000000..7e833b44ea8 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_15_05_world.sql @@ -0,0 +1,4 @@ +-- +DELETE FROM `spell_linked_spell` WHERE `spell_trigger` = 108212; +INSERT INTO `spell_linked_spell` (`spell_trigger`, `spell_effect`, `type`, `comment`) VALUES +(108212, 137681, 0, 'Burst of Speed - Rogue Talent'); diff --git a/sql/updates/world/6.x/2016_06_15_06_world.sql b/sql/updates/world/6.x/2016_06_15_06_world.sql new file mode 100644 index 00000000000..6d63a4ca441 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_15_06_world.sql @@ -0,0 +1 @@ +DROP TABLE IF EXISTS `spell_ranks`; diff --git a/sql/updates/world/6.x/2016_06_15_07_world.sql b/sql/updates/world/6.x/2016_06_15_07_world.sql new file mode 100644 index 00000000000..cc6aa2db566 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_15_07_world.sql @@ -0,0 +1,3 @@ +-- Huntress Claws: http://eu.battle.net/wow/en/item/5096 +-- Drop Chance: Guaranteed +UPDATE `creature_loot_template` SET `Chance`=100 WHERE `Item`=5096; diff --git a/sql/updates/world/6.x/2016_06_15_08_world.sql b/sql/updates/world/6.x/2016_06_15_08_world.sql new file mode 100644 index 00000000000..1a7d606352f --- /dev/null +++ b/sql/updates/world/6.x/2016_06_15_08_world.sql @@ -0,0 +1,13 @@ +-- +DELETE FROM `game_event_gameobject` WHERE `guid` IN (220041, 220044, 220043, 220042, 220048, 220049, 220076, 220148, 220147, 220029); +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(3, 220029), +(3, 220041), +(3, 220042), +(3, 220043), +(3, 220044), +(3, 220147), +(3, 220048), +(3, 220049), +(3, 220076), +(3, 220148); diff --git a/sql/updates/world/6.x/2016_06_16_00_world.sql b/sql/updates/world/6.x/2016_06_16_00_world.sql new file mode 100644 index 00000000000..49d6c2debd4 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_16_00_world.sql @@ -0,0 +1,16 @@ +-- +DELETE FROM `game_event_creature` WHERE `guid` IN (314040, 314484, 310945); +INSERT INTO `game_event_creature` (`eventEntry`, `guid`) VALUES +(3, 314040), +(3, 314484), +(3, 310945); + +DELETE FROM `game_event_gameobject` WHERE `guid` IN (220437, 220463, 220468, 220476, 220461, 220436, 220466); +INSERT INTO `game_event_gameobject` (`eventEntry`, `guid`) VALUES +(3, 220437), +(3, 220463), +(3, 220468), +(3, 220476), +(3, 220461), +(3, 220436), +(3, 220466); diff --git a/sql/updates/world/6.x/2016_06_17_00_world.sql b/sql/updates/world/6.x/2016_06_17_00_world.sql new file mode 100644 index 00000000000..af5e1dca844 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_17_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `npcflag`=`npcflag` &~2 WHERE `entry` IN (16521, 16522); diff --git a/sql/updates/world/6.x/2016_06_17_01_world.sql b/sql/updates/world/6.x/2016_06_17_01_world.sql new file mode 100644 index 00000000000..e5bc16000ce --- /dev/null +++ b/sql/updates/world/6.x/2016_06_17_01_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_monk_provoke'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(115546,'spell_monk_provoke'); diff --git a/sql/updates/world/6.x/2016_06_19_00_world.sql b/sql/updates/world/6.x/2016_06_19_00_world.sql new file mode 100644 index 00000000000..e125222ebf3 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_19_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `npcflag`=`npcflag` &~2 WHERE `entry` IN (3101); diff --git a/sql/updates/world/6.x/2016_06_19_01_world.sql b/sql/updates/world/6.x/2016_06_19_01_world.sql new file mode 100644 index 00000000000..8b139241f60 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_19_01_world.sql @@ -0,0 +1 @@ +ALTER TABLE `playercreateinfo_cast_spell` ADD PRIMARY KEY(`raceMask`, `classMask`, `spell`); diff --git a/sql/updates/world/6.x/2016_06_20_00_world.sql b/sql/updates/world/6.x/2016_06_20_00_world.sql new file mode 100644 index 00000000000..0a24574d5b6 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_20_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `flags_extra`=`flags_extra`|128|2 WHERE `entry` IN (35010,35011,35830); diff --git a/sql/updates/world/6.x/2016_06_20_01_world.sql b/sql/updates/world/6.x/2016_06_20_01_world.sql new file mode 100644 index 00000000000..35c5bf01c16 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_20_01_world.sql @@ -0,0 +1,1431 @@ +-- +-- Felwood (Zone 361) Ore spawns +SET @LASTGUID := 173; +SET @OGUID1 := 234355; +SET @OGUID2 := @OGUID1 + (@LASTGUID + 1); +SET @OGUID3 := @OGUID2 + (@LASTGUID + 1); +SET @POOL := 361001; -- 174 pooled +SET @MOTHER := 36101; +SET @ACTIVE := 66; -- Max number of active spawns +SET @TIMER := 30; -- Respawn timer in seconds + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID1 AND @OGUID1+@LASTGUID; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID2 AND @OGUID2+@LASTGUID; +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID3 AND @OGUID3+@LASTGUID; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `PhaseId`, `PhaseGroup`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +-- Mithril Deposits +(@OGUID1+0,2040,1,1,1,0,3518.36,-1096.71,230.29,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+1,2040,1,1,1,0,3532.12,-1080.09,234.065,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+2,2040,1,1,1,0,3555.23,-1051.94,241.666,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+3,2040,1,1,1,0,3595.66,-1205.04,227.842,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+4,2040,1,1,1,0,3595.67,-993.8,233.478,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+5,2040,1,1,1,0,3612.46,-935.637,297.772,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+6,2040,1,1,1,0,3646.68,-1379.49,224.298,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+7,2040,1,1,1,0,3674.1,-1247.69,231.801,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+8,2040,1,1,1,0,3688.55,-947.625,297.762,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+9,2040,1,1,1,0,3701.43,-1354.14,233.103,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+10,2040,1,1,1,0,3719.78,-885.641,334.797,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+11,2040,1,1,1,0,3724.96,-808.394,343.181,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+12,2040,1,1,1,0,3741.6,-1266.94,219.244,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+13,2040,1,1,1,0,3742.2,-1698.85,272.017,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+14,2040,1,1,1,0,3769.26,-1731.45,281.997,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+15,2040,1,1,1,0,3769.4,-864.252,311.543,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+16,2040,1,1,1,0,3778.65,-722.302,351.5,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+17,2040,1,1,1,0,3794.74,-719.337,342.173,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+18,2040,1,1,1,0,3813.47,-1754.63,300.244,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+19,2040,1,1,1,0,3816.61,-936.957,270.896,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+20,2040,1,1,1,0,3818.71,-688.347,341.798,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+21,2040,1,1,1,0,3831.14,-661.13,339.622,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+22,2040,1,1,1,0,3838.67,-1729.82,284.623,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+23,2040,1,1,1,0,3852.45,-923.967,285.531,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+24,2040,1,1,1,0,3904.94,-733.469,326.517,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+25,2040,1,1,1,0,3909.45,-821.382,327.248,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+26,2040,1,1,1,0,3922.89,-1479.14,232.244,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+27,2040,1,1,1,0,3923.16,-786.628,321.315,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+28,2040,1,1,1,0,3923.49,-1648.37,284.106,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+29,2040,1,1,1,0,3931.29,-677.875,338.391,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+30,2040,1,1,1,0,3939.84,-724.755,303.409,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+31,2040,1,1,1,0,3942.22,-569.201,352.489,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+32,2040,1,1,1,0,3965.01,-722.538,297.317,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+33,2040,1,1,1,0,3967.32,-1537.2,271.055,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+34,2040,1,1,1,0,3968.31,-688.894,328.956,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+35,2040,1,1,1,0,3975.79,-1488.68,266.003,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+36,2040,1,1,1,0,4025.35,-607.109,339.809,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+37,2040,1,1,1,0,4026.89,-715.2,290.555,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+38,2040,1,1,1,0,4072.45,-644.082,304.451,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+39,2040,1,1,1,0,4142.32,-1208.18,313.861,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+40,2040,1,1,1,0,4164.01,-1181.65,315.052,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+41,2040,1,1,1,0,4204.95,-1193.75,327.289,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+42,2040,1,1,1,0,4270.48,-493.052,314.379,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+43,2040,1,1,1,0,4293.27,-671.332,296.312,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+44,2040,1,1,1,0,4305.38,-1110.16,339.926,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+45,2040,1,1,1,0,4327.34,-1089.69,344.662,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+46,2040,1,1,1,0,4476.36,-446.014,329.234,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+47,2040,1,1,1,0,4499.75,-403.543,344.001,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+48,2040,1,1,1,0,4509.84,-1013.56,353.013,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+49,2040,1,1,1,0,4538.48,-399.399,318.674,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+50,2040,1,1,1,0,4595.53,-420.356,331.271,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+51,2040,1,1,1,0,4606.84,-459.365,319.505,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+52,2040,1,1,1,0,4617.51,-587.194,294.599,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+53,2040,1,1,1,0,4661.36,-930.628,349.474,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+54,2040,1,1,1,0,4667.22,-724.479,301.801,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+55,2040,1,1,1,0,4680.24,-881.153,349.374,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+56,2040,1,1,1,0,4704.11,-949.054,364.112,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+57,2040,1,1,1,0,4709.69,-738.403,314.423,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+58,2040,1,1,1,0,4749.24,-722.13,310.143,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+59,2040,1,1,1,0,4776.74,-837.42,333.643,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+60,2040,1,1,1,0,4792.78,-803.882,317.419,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+61,2040,1,1,1,0,4821.81,-671.188,312.993,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+62,2040,1,1,1,0,4839.51,-812.58,319.261,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+63,2040,1,1,1,0,4857.02,-419.045,367.752,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+64,2040,1,1,1,0,4888.34,-807.721,305.402,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+65,2040,1,1,1,0,4890.75,-353.943,369.361,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+66,2040,1,1,1,0,4977.67,-790.019,326.817,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+67,2040,1,1,1,0,4989.58,-519.306,350.89,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+68,2040,1,1,1,0,5093.99,-815.09,352.615,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+69,2040,1,1,1,0,5123.59,-808.363,352.909,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+70,2040,1,1,1,0,5155.09,-529.038,344.48,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+71,2040,1,1,1,0,5186.75,-801.981,359.166,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+72,2040,1,1,1,0,5273.65,-901.323,370.16,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+73,2040,1,1,1,0,5293.68,-915.602,383.933,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+74,2040,1,1,1,0,5298.8,-483.415,345.655,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+75,2040,1,1,1,0,5326.76,-941.991,384.361,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+76,2040,1,1,1,0,5354.51,-945.491,384.49,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+77,2040,1,1,1,0,5377.76,-970.936,388.505,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+78,2040,1,1,1,0,5410.82,-963.049,389.923,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+79,2040,1,1,1,0,5442.81,-508.226,379.438,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+80,2040,1,1,1,0,5473.56,-1028.85,388.938,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+81,2040,1,1,1,0,5488.17,-500.201,378.676,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+82,2040,1,1,1,0,5522.06,-1031.1,387.649,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+83,2040,1,1,1,0,5542.26,-1039.36,394.232,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+84,2040,1,1,1,0,5589.41,-498.7,384.993,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+85,2040,1,1,1,0,5596.71,-1155.65,408.308,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+86,2040,1,1,1,0,5626.65,-1160.9,401.451,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+87,2040,1,1,1,0,5649.58,-1166.41,403.607,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+88,2040,1,1,1,0,5689.34,-1185.81,408.171,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+89,2040,1,1,1,0,5718.74,-1211.69,434.88,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+90,2040,1,1,1,0,5753.47,-1190.98,407.722,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+91,2040,1,1,1,0,5847.39,-1348.74,455.415,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+92,2040,1,1,1,0,5852.26,-1267.06,423.101,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+93,2040,1,1,1,0,5869.19,-1315.33,421.243,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+94,2040,1,1,1,0,5875.35,-606.835,406.306,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+95,2040,1,1,1,0,5958.91,-1412.89,444.033,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+96,2040,1,1,1,0,5989.43,-619.717,410.86,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+97,2040,1,1,1,0,6009.19,-658.227,406.552,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+98,2040,1,1,1,0,6017.37,-1488.13,451.171,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+99,2040,1,1,1,0,6048.66,-1597.7,492.117,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+100,2040,1,1,1,0,6052.97,-1573.89,476.19,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+101,2040,1,1,1,0,6112.73,-1036.49,405.857,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+102,2040,1,1,1,0,6127.9,-688.844,420.179,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+103,2040,1,1,1,0,6138.25,-1024.62,401.109,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+104,2040,1,1,1,0,6151.11,-1796.5,552.678,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+105,2040,1,1,1,0,6179.23,-974.965,405.433,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+106,2040,1,1,1,0,6181.83,-1417.01,403.935,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+107,2040,1,1,1,0,6201.63,-1760.22,538.785,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+108,2040,1,1,1,0,6224.72,-649.944,426.282,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+109,2040,1,1,1,0,6248.72,-2052.01,610.663,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+110,2040,1,1,1,0,6252.74,-679.368,437.375,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+111,2040,1,1,1,0,6258.6,-769.642,427.735,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+112,2040,1,1,1,0,6267.66,-707.227,432.376,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+113,2040,1,1,1,0,6305.11,-1468.17,394.291,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+114,2040,1,1,1,0,6336.31,-651.368,496.393,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+115,2040,1,1,1,0,6344.4,-617.972,483.824,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+116,2040,1,1,1,0,6347.32,-660.427,487.705,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+117,2040,1,1,1,0,6362.56,-1440.67,387.155,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+118,2040,1,1,1,0,6523.49,-2018.68,571.073,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+119,2040,1,1,1,0,6547,-780.592,484.607,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+120,2040,1,1,1,0,6556.96,-1829.11,540.269,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+121,2040,1,1,1,0,6572.51,-927.887,497.34,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+122,2040,1,1,1,0,6573.16,-1792.3,550.087,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+123,2040,1,1,1,0,6575.55,-778.285,483.815,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+124,2040,1,1,1,0,6582.12,-899.059,483.995,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+125,2040,1,1,1,0,6592.13,-1953.67,560.754,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+126,2040,1,1,1,0,6616.44,-1018.3,483.959,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+127,2040,1,1,1,0,6634.33,-936.304,492.336,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+128,2040,1,1,1,0,6651.69,-1685.27,497.607,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+129,2040,1,1,1,0,6654.5,-1200.41,473.482,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+130,2040,1,1,1,0,6679.9,-1999.93,554.918,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+131,2040,1,1,1,0,6682.84,-1218.41,475.421,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+132,2040,1,1,1,0,6684.67,-2043.19,571.531,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+133,2040,1,1,1,0,6695.35,-1668.53,506.223,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+134,2040,1,1,1,0,6696.96,-1357.71,493.868,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+135,2040,1,1,1,0,6715.46,-1377.59,491.777,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+136,2040,1,1,1,0,6720.77,-1282.89,492.925,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+137,2040,1,1,1,0,6741.15,-1987.21,555.494,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+138,2040,1,1,1,0,6751.67,-1528.59,496.243,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+139,2040,1,1,1,0,6774.01,-2034.64,576.012,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+140,2040,1,1,1,0,6789.58,-1966.37,556.149,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+141,2040,1,1,1,0,6807.13,-1763.37,621.515,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+142,2040,1,1,1,0,6855.63,-1545.64,510.091,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+143,2040,1,1,1,0,6883.95,-1969.92,573.449,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+144,2040,1,1,1,0,6890.68,-1780.24,590.574,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+145,2040,1,1,1,0,6893.74,-1637.91,507.892,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+146,2040,1,1,1,0,6910.06,-1923.74,582.433,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+147,2040,1,1,1,0,6918.18,-2045.36,596.652,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+148,2040,1,1,1,0,6925.78,-1579.02,518.463,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+149,2040,1,1,1,0,6926.55,-1785.23,586.29,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+150,2040,1,1,1,0,6957.56,-1994.14,610.338,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+151,2040,1,1,1,0,6255.08,-1719.68,432.793,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+152,2040,1,1,1,0,6262.42,-1679.22,433.738,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+153,2040,1,1,1,0,6299.92,-1767.96,421.915,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+154,2040,1,1,1,0,6319.9,-1633.21,428.503,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+155,2040,1,1,1,0,6340.79,-1844,436.472,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+156,2040,1,1,1,0,6342.07,-1739.85,422.616,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+157,2040,1,1,1,0,6349.85,-1777.57,421.974,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+158,2040,1,1,1,0,6351.52,-1633.01,431.807,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+159,2040,1,1,1,0,6353.48,-1867.76,436.986,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+160,2040,1,1,1,0,6356.96,-1684.74,441.362,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+161,2040,1,1,1,0,6363.45,-1836.28,434.892,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+162,2040,1,1,1,0,6374.6,-1648.47,436.67,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+163,2040,1,1,1,0,6374.99,-1746.69,421.572,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+164,2040,1,1,1,0,6376.33,-1670.75,438.206,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+165,2040,1,1,1,0,6409.36,-1673.24,419.222,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+166,2040,1,1,1,0,6412.9,-1636.42,435.787,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+167,2040,1,1,1,0,6425.6,-1649.16,435.996,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+168,2040,1,1,1,0,6436.65,-1657.93,414.83,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+169,2040,1,1,1,0,6442.42,-1606.78,433.71,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+170,2040,1,1,1,0,6442.44,-1641.64,433.461,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+171,2040,1,1,1,0,6460.49,-1583.25,436.143,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+172,2040,1,1,1,0,6472.37,-1703.37,418.753,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID1+173,2040,1,1,1,0,6480.74,-1632.92,436.187,2.932139,0,0,0,1, @TIMER, 255, 1), +-- Gold Veins +(@OGUID2+0,1734,1,1,1,0,3518.36,-1096.71,230.29,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+1,1734,1,1,1,0,3532.12,-1080.09,234.065,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+2,1734,1,1,1,0,3555.23,-1051.94,241.666,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+3,1734,1,1,1,0,3595.66,-1205.04,227.842,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+4,1734,1,1,1,0,3595.67,-993.8,233.478,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+5,1734,1,1,1,0,3612.46,-935.637,297.772,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+6,1734,1,1,1,0,3646.68,-1379.49,224.298,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+7,1734,1,1,1,0,3674.1,-1247.69,231.801,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+8,1734,1,1,1,0,3688.55,-947.625,297.762,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+9,1734,1,1,1,0,3701.43,-1354.14,233.103,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+10,1734,1,1,1,0,3719.78,-885.641,334.797,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+11,1734,1,1,1,0,3724.96,-808.394,343.181,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+12,1734,1,1,1,0,3741.6,-1266.94,219.244,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+13,1734,1,1,1,0,3742.2,-1698.85,272.017,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+14,1734,1,1,1,0,3769.26,-1731.45,281.997,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+15,1734,1,1,1,0,3769.4,-864.252,311.543,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+16,1734,1,1,1,0,3778.65,-722.302,351.5,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+17,1734,1,1,1,0,3794.74,-719.337,342.173,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+18,1734,1,1,1,0,3813.47,-1754.63,300.244,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+19,1734,1,1,1,0,3816.61,-936.957,270.896,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+20,1734,1,1,1,0,3818.71,-688.347,341.798,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+21,1734,1,1,1,0,3831.14,-661.13,339.622,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+22,1734,1,1,1,0,3838.67,-1729.82,284.623,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+23,1734,1,1,1,0,3852.45,-923.967,285.531,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+24,1734,1,1,1,0,3904.94,-733.469,326.517,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+25,1734,1,1,1,0,3909.45,-821.382,327.248,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+26,1734,1,1,1,0,3922.89,-1479.14,232.244,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+27,1734,1,1,1,0,3923.16,-786.628,321.315,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+28,1734,1,1,1,0,3923.49,-1648.37,284.106,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+29,1734,1,1,1,0,3931.29,-677.875,338.391,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+30,1734,1,1,1,0,3939.84,-724.755,303.409,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+31,1734,1,1,1,0,3942.22,-569.201,352.489,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+32,1734,1,1,1,0,3965.01,-722.538,297.317,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+33,1734,1,1,1,0,3967.32,-1537.2,271.055,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+34,1734,1,1,1,0,3968.31,-688.894,328.956,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+35,1734,1,1,1,0,3975.79,-1488.68,266.003,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+36,1734,1,1,1,0,4025.35,-607.109,339.809,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+37,1734,1,1,1,0,4026.89,-715.2,290.555,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+38,1734,1,1,1,0,4072.45,-644.082,304.451,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+39,1734,1,1,1,0,4142.32,-1208.18,313.861,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+40,1734,1,1,1,0,4164.01,-1181.65,315.052,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+41,1734,1,1,1,0,4204.95,-1193.75,327.289,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+42,1734,1,1,1,0,4270.48,-493.052,314.379,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+43,1734,1,1,1,0,4293.27,-671.332,296.312,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+44,1734,1,1,1,0,4305.38,-1110.16,339.926,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+45,1734,1,1,1,0,4327.34,-1089.69,344.662,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+46,1734,1,1,1,0,4476.36,-446.014,329.234,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+47,1734,1,1,1,0,4499.75,-403.543,344.001,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+48,1734,1,1,1,0,4509.84,-1013.56,353.013,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+49,1734,1,1,1,0,4538.48,-399.399,318.674,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+50,1734,1,1,1,0,4595.53,-420.356,331.271,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+51,1734,1,1,1,0,4606.84,-459.365,319.505,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+52,1734,1,1,1,0,4617.51,-587.194,294.599,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+53,1734,1,1,1,0,4661.36,-930.628,349.474,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+54,1734,1,1,1,0,4667.22,-724.479,301.801,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+55,1734,1,1,1,0,4680.24,-881.153,349.374,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+56,1734,1,1,1,0,4704.11,-949.054,364.112,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+57,1734,1,1,1,0,4709.69,-738.403,314.423,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+58,1734,1,1,1,0,4749.24,-722.13,310.143,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+59,1734,1,1,1,0,4776.74,-837.42,333.643,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+60,1734,1,1,1,0,4792.78,-803.882,317.419,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+61,1734,1,1,1,0,4821.81,-671.188,312.993,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+62,1734,1,1,1,0,4839.51,-812.58,319.261,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+63,1734,1,1,1,0,4857.02,-419.045,367.752,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+64,1734,1,1,1,0,4888.34,-807.721,305.402,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+65,1734,1,1,1,0,4890.75,-353.943,369.361,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+66,1734,1,1,1,0,4977.67,-790.019,326.817,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+67,1734,1,1,1,0,4989.58,-519.306,350.89,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+68,1734,1,1,1,0,5093.99,-815.09,352.615,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+69,1734,1,1,1,0,5123.59,-808.363,352.909,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+70,1734,1,1,1,0,5155.09,-529.038,344.48,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+71,1734,1,1,1,0,5186.75,-801.981,359.166,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+72,1734,1,1,1,0,5273.65,-901.323,370.16,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+73,1734,1,1,1,0,5293.68,-915.602,383.933,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+74,1734,1,1,1,0,5298.8,-483.415,345.655,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+75,1734,1,1,1,0,5326.76,-941.991,384.361,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+76,1734,1,1,1,0,5354.51,-945.491,384.49,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+77,1734,1,1,1,0,5377.76,-970.936,388.505,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+78,1734,1,1,1,0,5410.82,-963.049,389.923,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+79,1734,1,1,1,0,5442.81,-508.226,379.438,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+80,1734,1,1,1,0,5473.56,-1028.85,388.938,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+81,1734,1,1,1,0,5488.17,-500.201,378.676,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+82,1734,1,1,1,0,5522.06,-1031.1,387.649,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+83,1734,1,1,1,0,5542.26,-1039.36,394.232,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+84,1734,1,1,1,0,5589.41,-498.7,384.993,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+85,1734,1,1,1,0,5596.71,-1155.65,408.308,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+86,1734,1,1,1,0,5626.65,-1160.9,401.451,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+87,1734,1,1,1,0,5649.58,-1166.41,403.607,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+88,1734,1,1,1,0,5689.34,-1185.81,408.171,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+89,1734,1,1,1,0,5718.74,-1211.69,434.88,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+90,1734,1,1,1,0,5753.47,-1190.98,407.722,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+91,1734,1,1,1,0,5847.39,-1348.74,455.415,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+92,1734,1,1,1,0,5852.26,-1267.06,423.101,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+93,1734,1,1,1,0,5869.19,-1315.33,421.243,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+94,1734,1,1,1,0,5875.35,-606.835,406.306,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+95,1734,1,1,1,0,5958.91,-1412.89,444.033,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+96,1734,1,1,1,0,5989.43,-619.717,410.86,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+97,1734,1,1,1,0,6009.19,-658.227,406.552,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+98,1734,1,1,1,0,6017.37,-1488.13,451.171,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+99,1734,1,1,1,0,6048.66,-1597.7,492.117,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+100,1734,1,1,1,0,6052.97,-1573.89,476.19,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+101,1734,1,1,1,0,6112.73,-1036.49,405.857,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+102,1734,1,1,1,0,6127.9,-688.844,420.179,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+103,1734,1,1,1,0,6138.25,-1024.62,401.109,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+104,1734,1,1,1,0,6151.11,-1796.5,552.678,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+105,1734,1,1,1,0,6179.23,-974.965,405.433,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+106,1734,1,1,1,0,6181.83,-1417.01,403.935,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+107,1734,1,1,1,0,6201.63,-1760.22,538.785,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+108,1734,1,1,1,0,6224.72,-649.944,426.282,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+109,1734,1,1,1,0,6248.72,-2052.01,610.663,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+110,1734,1,1,1,0,6252.74,-679.368,437.375,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+111,1734,1,1,1,0,6258.6,-769.642,427.735,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+112,1734,1,1,1,0,6267.66,-707.227,432.376,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+113,1734,1,1,1,0,6305.11,-1468.17,394.291,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+114,1734,1,1,1,0,6336.31,-651.368,496.393,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+115,1734,1,1,1,0,6344.4,-617.972,483.824,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+116,1734,1,1,1,0,6347.32,-660.427,487.705,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+117,1734,1,1,1,0,6362.56,-1440.67,387.155,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+118,1734,1,1,1,0,6523.49,-2018.68,571.073,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+119,1734,1,1,1,0,6547,-780.592,484.607,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+120,1734,1,1,1,0,6556.96,-1829.11,540.269,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+121,1734,1,1,1,0,6572.51,-927.887,497.34,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+122,1734,1,1,1,0,6573.16,-1792.3,550.087,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+123,1734,1,1,1,0,6575.55,-778.285,483.815,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+124,1734,1,1,1,0,6582.12,-899.059,483.995,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+125,1734,1,1,1,0,6592.13,-1953.67,560.754,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+126,1734,1,1,1,0,6616.44,-1018.3,483.959,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+127,1734,1,1,1,0,6634.33,-936.304,492.336,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+128,1734,1,1,1,0,6651.69,-1685.27,497.607,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+129,1734,1,1,1,0,6654.5,-1200.41,473.482,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+130,1734,1,1,1,0,6679.9,-1999.93,554.918,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+131,1734,1,1,1,0,6682.84,-1218.41,475.421,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+132,1734,1,1,1,0,6684.67,-2043.19,571.531,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+133,1734,1,1,1,0,6695.35,-1668.53,506.223,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+134,1734,1,1,1,0,6696.96,-1357.71,493.868,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+135,1734,1,1,1,0,6715.46,-1377.59,491.777,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+136,1734,1,1,1,0,6720.77,-1282.89,492.925,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+137,1734,1,1,1,0,6741.15,-1987.21,555.494,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+138,1734,1,1,1,0,6751.67,-1528.59,496.243,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+139,1734,1,1,1,0,6774.01,-2034.64,576.012,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+140,1734,1,1,1,0,6789.58,-1966.37,556.149,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+141,1734,1,1,1,0,6807.13,-1763.37,621.515,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+142,1734,1,1,1,0,6855.63,-1545.64,510.091,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+143,1734,1,1,1,0,6883.95,-1969.92,573.449,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+144,1734,1,1,1,0,6890.68,-1780.24,590.574,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+145,1734,1,1,1,0,6893.74,-1637.91,507.892,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+146,1734,1,1,1,0,6910.06,-1923.74,582.433,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+147,1734,1,1,1,0,6918.18,-2045.36,596.652,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+148,1734,1,1,1,0,6925.78,-1579.02,518.463,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+149,1734,1,1,1,0,6926.55,-1785.23,586.29,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+150,1734,1,1,1,0,6957.56,-1994.14,610.338,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+151,1734,1,1,1,0,6255.08,-1719.68,432.793,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+152,1734,1,1,1,0,6262.42,-1679.22,433.738,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+153,1734,1,1,1,0,6299.92,-1767.96,421.915,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+154,1734,1,1,1,0,6319.9,-1633.21,428.503,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+155,1734,1,1,1,0,6340.79,-1844,436.472,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+156,1734,1,1,1,0,6342.07,-1739.85,422.616,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+157,1734,1,1,1,0,6349.85,-1777.57,421.974,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+158,1734,1,1,1,0,6351.52,-1633.01,431.807,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+159,1734,1,1,1,0,6353.48,-1867.76,436.986,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+160,1734,1,1,1,0,6356.96,-1684.74,441.362,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+161,1734,1,1,1,0,6363.45,-1836.28,434.892,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+162,1734,1,1,1,0,6374.6,-1648.47,436.67,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+163,1734,1,1,1,0,6374.99,-1746.69,421.572,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+164,1734,1,1,1,0,6376.33,-1670.75,438.206,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+165,1734,1,1,1,0,6409.36,-1673.24,419.222,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+166,1734,1,1,1,0,6412.9,-1636.42,435.787,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+167,1734,1,1,1,0,6425.6,-1649.16,435.996,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+168,1734,1,1,1,0,6436.65,-1657.93,414.83,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+169,1734,1,1,1,0,6442.42,-1606.78,433.71,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+170,1734,1,1,1,0,6442.44,-1641.64,433.461,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+171,1734,1,1,1,0,6460.49,-1583.25,436.143,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+172,1734,1,1,1,0,6472.37,-1703.37,418.753,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID2+173,1734,1,1,1,0,6480.74,-1632.92,436.187,2.932139,0,0,0,1, @TIMER, 255, 1), +-- Truesilver Deposits +(@OGUID3+0,2047,1,1,1,0,3518.36,-1096.71,230.29,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+1,2047,1,1,1,0,3532.12,-1080.09,234.065,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+2,2047,1,1,1,0,3555.23,-1051.94,241.666,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+3,2047,1,1,1,0,3595.66,-1205.04,227.842,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+4,2047,1,1,1,0,3595.67,-993.8,233.478,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+5,2047,1,1,1,0,3612.46,-935.637,297.772,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+6,2047,1,1,1,0,3646.68,-1379.49,224.298,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+7,2047,1,1,1,0,3674.1,-1247.69,231.801,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+8,2047,1,1,1,0,3688.55,-947.625,297.762,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+9,2047,1,1,1,0,3701.43,-1354.14,233.103,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+10,2047,1,1,1,0,3719.78,-885.641,334.797,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+11,2047,1,1,1,0,3724.96,-808.394,343.181,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+12,2047,1,1,1,0,3741.6,-1266.94,219.244,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+13,2047,1,1,1,0,3742.2,-1698.85,272.017,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+14,2047,1,1,1,0,3769.26,-1731.45,281.997,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+15,2047,1,1,1,0,3769.4,-864.252,311.543,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+16,2047,1,1,1,0,3778.65,-722.302,351.5,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+17,2047,1,1,1,0,3794.74,-719.337,342.173,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+18,2047,1,1,1,0,3813.47,-1754.63,300.244,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+19,2047,1,1,1,0,3816.61,-936.957,270.896,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+20,2047,1,1,1,0,3818.71,-688.347,341.798,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+21,2047,1,1,1,0,3831.14,-661.13,339.622,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+22,2047,1,1,1,0,3838.67,-1729.82,284.623,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+23,2047,1,1,1,0,3852.45,-923.967,285.531,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+24,2047,1,1,1,0,3904.94,-733.469,326.517,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+25,2047,1,1,1,0,3909.45,-821.382,327.248,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+26,2047,1,1,1,0,3922.89,-1479.14,232.244,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+27,2047,1,1,1,0,3923.16,-786.628,321.315,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+28,2047,1,1,1,0,3923.49,-1648.37,284.106,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+29,2047,1,1,1,0,3931.29,-677.875,338.391,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+30,2047,1,1,1,0,3939.84,-724.755,303.409,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+31,2047,1,1,1,0,3942.22,-569.201,352.489,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+32,2047,1,1,1,0,3965.01,-722.538,297.317,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+33,2047,1,1,1,0,3967.32,-1537.2,271.055,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+34,2047,1,1,1,0,3968.31,-688.894,328.956,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+35,2047,1,1,1,0,3975.79,-1488.68,266.003,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+36,2047,1,1,1,0,4025.35,-607.109,339.809,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+37,2047,1,1,1,0,4026.89,-715.2,290.555,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+38,2047,1,1,1,0,4072.45,-644.082,304.451,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+39,2047,1,1,1,0,4142.32,-1208.18,313.861,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+40,2047,1,1,1,0,4164.01,-1181.65,315.052,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+41,2047,1,1,1,0,4204.95,-1193.75,327.289,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+42,2047,1,1,1,0,4270.48,-493.052,314.379,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+43,2047,1,1,1,0,4293.27,-671.332,296.312,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+44,2047,1,1,1,0,4305.38,-1110.16,339.926,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+45,2047,1,1,1,0,4327.34,-1089.69,344.662,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+46,2047,1,1,1,0,4476.36,-446.014,329.234,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+47,2047,1,1,1,0,4499.75,-403.543,344.001,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+48,2047,1,1,1,0,4509.84,-1013.56,353.013,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+49,2047,1,1,1,0,4538.48,-399.399,318.674,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+50,2047,1,1,1,0,4595.53,-420.356,331.271,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+51,2047,1,1,1,0,4606.84,-459.365,319.505,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+52,2047,1,1,1,0,4617.51,-587.194,294.599,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+53,2047,1,1,1,0,4661.36,-930.628,349.474,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+54,2047,1,1,1,0,4667.22,-724.479,301.801,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+55,2047,1,1,1,0,4680.24,-881.153,349.374,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+56,2047,1,1,1,0,4704.11,-949.054,364.112,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+57,2047,1,1,1,0,4709.69,-738.403,314.423,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+58,2047,1,1,1,0,4749.24,-722.13,310.143,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+59,2047,1,1,1,0,4776.74,-837.42,333.643,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+60,2047,1,1,1,0,4792.78,-803.882,317.419,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+61,2047,1,1,1,0,4821.81,-671.188,312.993,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+62,2047,1,1,1,0,4839.51,-812.58,319.261,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+63,2047,1,1,1,0,4857.02,-419.045,367.752,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+64,2047,1,1,1,0,4888.34,-807.721,305.402,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+65,2047,1,1,1,0,4890.75,-353.943,369.361,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+66,2047,1,1,1,0,4977.67,-790.019,326.817,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+67,2047,1,1,1,0,4989.58,-519.306,350.89,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+68,2047,1,1,1,0,5093.99,-815.09,352.615,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+69,2047,1,1,1,0,5123.59,-808.363,352.909,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+70,2047,1,1,1,0,5155.09,-529.038,344.48,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+71,2047,1,1,1,0,5186.75,-801.981,359.166,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+72,2047,1,1,1,0,5273.65,-901.323,370.16,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+73,2047,1,1,1,0,5293.68,-915.602,383.933,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+74,2047,1,1,1,0,5298.8,-483.415,345.655,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+75,2047,1,1,1,0,5326.76,-941.991,384.361,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+76,2047,1,1,1,0,5354.51,-945.491,384.49,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+77,2047,1,1,1,0,5377.76,-970.936,388.505,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+78,2047,1,1,1,0,5410.82,-963.049,389.923,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+79,2047,1,1,1,0,5442.81,-508.226,379.438,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+80,2047,1,1,1,0,5473.56,-1028.85,388.938,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+81,2047,1,1,1,0,5488.17,-500.201,378.676,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+82,2047,1,1,1,0,5522.06,-1031.1,387.649,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+83,2047,1,1,1,0,5542.26,-1039.36,394.232,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+84,2047,1,1,1,0,5589.41,-498.7,384.993,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+85,2047,1,1,1,0,5596.71,-1155.65,408.308,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+86,2047,1,1,1,0,5626.65,-1160.9,401.451,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+87,2047,1,1,1,0,5649.58,-1166.41,403.607,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+88,2047,1,1,1,0,5689.34,-1185.81,408.171,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+89,2047,1,1,1,0,5718.74,-1211.69,434.88,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+90,2047,1,1,1,0,5753.47,-1190.98,407.722,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+91,2047,1,1,1,0,5847.39,-1348.74,455.415,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+92,2047,1,1,1,0,5852.26,-1267.06,423.101,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+93,2047,1,1,1,0,5869.19,-1315.33,421.243,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+94,2047,1,1,1,0,5875.35,-606.835,406.306,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+95,2047,1,1,1,0,5958.91,-1412.89,444.033,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+96,2047,1,1,1,0,5989.43,-619.717,410.86,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+97,2047,1,1,1,0,6009.19,-658.227,406.552,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+98,2047,1,1,1,0,6017.37,-1488.13,451.171,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+99,2047,1,1,1,0,6048.66,-1597.7,492.117,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+100,2047,1,1,1,0,6052.97,-1573.89,476.19,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+101,2047,1,1,1,0,6112.73,-1036.49,405.857,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+102,2047,1,1,1,0,6127.9,-688.844,420.179,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+103,2047,1,1,1,0,6138.25,-1024.62,401.109,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+104,2047,1,1,1,0,6151.11,-1796.5,552.678,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+105,2047,1,1,1,0,6179.23,-974.965,405.433,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+106,2047,1,1,1,0,6181.83,-1417.01,403.935,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+107,2047,1,1,1,0,6201.63,-1760.22,538.785,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+108,2047,1,1,1,0,6224.72,-649.944,426.282,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+109,2047,1,1,1,0,6248.72,-2052.01,610.663,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+110,2047,1,1,1,0,6252.74,-679.368,437.375,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+111,2047,1,1,1,0,6258.6,-769.642,427.735,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+112,2047,1,1,1,0,6267.66,-707.227,432.376,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+113,2047,1,1,1,0,6305.11,-1468.17,394.291,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+114,2047,1,1,1,0,6336.31,-651.368,496.393,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+115,2047,1,1,1,0,6344.4,-617.972,483.824,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+116,2047,1,1,1,0,6347.32,-660.427,487.705,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+117,2047,1,1,1,0,6362.56,-1440.67,387.155,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+118,2047,1,1,1,0,6523.49,-2018.68,571.073,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+119,2047,1,1,1,0,6547,-780.592,484.607,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+120,2047,1,1,1,0,6556.96,-1829.11,540.269,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+121,2047,1,1,1,0,6572.51,-927.887,497.34,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+122,2047,1,1,1,0,6573.16,-1792.3,550.087,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+123,2047,1,1,1,0,6575.55,-778.285,483.815,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+124,2047,1,1,1,0,6582.12,-899.059,483.995,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+125,2047,1,1,1,0,6592.13,-1953.67,560.754,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+126,2047,1,1,1,0,6616.44,-1018.3,483.959,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+127,2047,1,1,1,0,6634.33,-936.304,492.336,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+128,2047,1,1,1,0,6651.69,-1685.27,497.607,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+129,2047,1,1,1,0,6654.5,-1200.41,473.482,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+130,2047,1,1,1,0,6679.9,-1999.93,554.918,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+131,2047,1,1,1,0,6682.84,-1218.41,475.421,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+132,2047,1,1,1,0,6684.67,-2043.19,571.531,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+133,2047,1,1,1,0,6695.35,-1668.53,506.223,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+134,2047,1,1,1,0,6696.96,-1357.71,493.868,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+135,2047,1,1,1,0,6715.46,-1377.59,491.777,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+136,2047,1,1,1,0,6720.77,-1282.89,492.925,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+137,2047,1,1,1,0,6741.15,-1987.21,555.494,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+138,2047,1,1,1,0,6751.67,-1528.59,496.243,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+139,2047,1,1,1,0,6774.01,-2034.64,576.012,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+140,2047,1,1,1,0,6789.58,-1966.37,556.149,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+141,2047,1,1,1,0,6807.13,-1763.37,621.515,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+142,2047,1,1,1,0,6855.63,-1545.64,510.091,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+143,2047,1,1,1,0,6883.95,-1969.92,573.449,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+144,2047,1,1,1,0,6890.68,-1780.24,590.574,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+145,2047,1,1,1,0,6893.74,-1637.91,507.892,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+146,2047,1,1,1,0,6910.06,-1923.74,582.433,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+147,2047,1,1,1,0,6918.18,-2045.36,596.652,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+148,2047,1,1,1,0,6925.78,-1579.02,518.463,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+149,2047,1,1,1,0,6926.55,-1785.23,586.29,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+150,2047,1,1,1,0,6957.56,-1994.14,610.338,4.485497,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+151,2047,1,1,1,0,6255.08,-1719.68,432.793,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+152,2047,1,1,1,0,6262.42,-1679.22,433.738,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+153,2047,1,1,1,0,6299.92,-1767.96,421.915,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+154,2047,1,1,1,0,6319.9,-1633.21,428.503,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+155,2047,1,1,1,0,6340.79,-1844,436.472,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+156,2047,1,1,1,0,6342.07,-1739.85,422.616,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+157,2047,1,1,1,0,6349.85,-1777.57,421.974,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+158,2047,1,1,1,0,6351.52,-1633.01,431.807,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+159,2047,1,1,1,0,6353.48,-1867.76,436.986,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+160,2047,1,1,1,0,6356.96,-1684.74,441.362,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+161,2047,1,1,1,0,6363.45,-1836.28,434.892,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+162,2047,1,1,1,0,6374.6,-1648.47,436.67,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+163,2047,1,1,1,0,6374.99,-1746.69,421.572,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+164,2047,1,1,1,0,6376.33,-1670.75,438.206,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+165,2047,1,1,1,0,6409.36,-1673.24,419.222,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+166,2047,1,1,1,0,6412.9,-1636.42,435.787,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+167,2047,1,1,1,0,6425.6,-1649.16,435.996,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+168,2047,1,1,1,0,6436.65,-1657.93,414.83,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+169,2047,1,1,1,0,6442.42,-1606.78,433.71,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+170,2047,1,1,1,0,6442.44,-1641.64,433.461,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+171,2047,1,1,1,0,6460.49,-1583.25,436.143,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+172,2047,1,1,1,0,6472.37,-1703.37,418.753,2.932139,0,0,0,1, @TIMER, 255, 1), +(@OGUID3+173,2047,1,1,1,0,6480.74,-1632.92,436.187,2.932139,0,0,0,1, @TIMER, 255, 1); + +-- Add mother pool to pool template +DELETE FROM `pool_template` WHERE `entry`=@MOTHER; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@MOTHER,@ACTIVE, 'Felwood Ore Mother pool'); + +-- Pool Ore Spawnpoints +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID1 AND @OGUID1+@LASTGUID; +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID2 AND @OGUID2+@LASTGUID; +DELETE FROM `pool_gameobject` WHERE `guid` BETWEEN @OGUID3 AND @OGUID3+@LASTGUID; +INSERT INTO `pool_gameobject` (`guid`,`pool_entry`,`chance`,`description`) VALUES +(@OGUID1+0,@POOL+0,80, 'Mithril Deposit'), +(@OGUID2+0,@POOL+0,10, 'Truesilver Deposit'), +(@OGUID3+0,@POOL+0,10, 'Gold Vein'), +(@OGUID1+1,@POOL+1,80, 'Mithril Deposit'), +(@OGUID2+1,@POOL+1,10, 'Truesilver Deposit'), +(@OGUID3+1,@POOL+1,10, 'Gold Vein'), +(@OGUID1+2,@POOL+2,80, 'Mithril Deposit'), +(@OGUID2+2,@POOL+2,10, 'Truesilver Deposit'), +(@OGUID3+2,@POOL+2,10, 'Gold Vein'), +(@OGUID1+3,@POOL+3,80, 'Mithril Deposit'), +(@OGUID2+3,@POOL+3,10, 'Truesilver Deposit'), +(@OGUID3+3,@POOL+3,10, 'Gold Vein'), +(@OGUID1+4,@POOL+4,80, 'Mithril Deposit'), +(@OGUID2+4,@POOL+4,10, 'Truesilver Deposit'), +(@OGUID3+4,@POOL+4,10, 'Gold Vein'), +(@OGUID1+5,@POOL+5,80, 'Mithril Deposit'), +(@OGUID2+5,@POOL+5,10, 'Truesilver Deposit'), +(@OGUID3+5,@POOL+5,10, 'Gold Vein'), +(@OGUID1+6,@POOL+6,80, 'Mithril Deposit'), +(@OGUID2+6,@POOL+6,10, 'Truesilver Deposit'), +(@OGUID3+6,@POOL+6,10, 'Gold Vein'), +(@OGUID1+7,@POOL+7,80, 'Mithril Deposit'), +(@OGUID2+7,@POOL+7,10, 'Truesilver Deposit'), +(@OGUID3+7,@POOL+7,10, 'Gold Vein'), +(@OGUID1+8,@POOL+8,80, 'Mithril Deposit'), +(@OGUID2+8,@POOL+8,10, 'Truesilver Deposit'), +(@OGUID3+8,@POOL+8,10, 'Gold Vein'), +(@OGUID1+9,@POOL+9,80, 'Mithril Deposit'), +(@OGUID2+9,@POOL+9,10, 'Truesilver Deposit'), +(@OGUID3+9,@POOL+9,10, 'Gold Vein'), +(@OGUID1+10,@POOL+10,80, 'Mithril Deposit'), +(@OGUID2+10,@POOL+10,10, 'Truesilver Deposit'), +(@OGUID3+10,@POOL+10,10, 'Gold Vein'), +(@OGUID1+11,@POOL+11,80, 'Mithril Deposit'), +(@OGUID2+11,@POOL+11,10, 'Truesilver Deposit'), +(@OGUID3+11,@POOL+11,10, 'Gold Vein'), +(@OGUID1+12,@POOL+12,80, 'Mithril Deposit'), +(@OGUID2+12,@POOL+12,10, 'Truesilver Deposit'), +(@OGUID3+12,@POOL+12,10, 'Gold Vein'), +(@OGUID1+13,@POOL+13,80, 'Mithril Deposit'), +(@OGUID2+13,@POOL+13,10, 'Truesilver Deposit'), +(@OGUID3+13,@POOL+13,10, 'Gold Vein'), +(@OGUID1+14,@POOL+14,80, 'Mithril Deposit'), +(@OGUID2+14,@POOL+14,10, 'Truesilver Deposit'), +(@OGUID3+14,@POOL+14,10, 'Gold Vein'), +(@OGUID1+15,@POOL+15,80, 'Mithril Deposit'), +(@OGUID2+15,@POOL+15,10, 'Truesilver Deposit'), +(@OGUID3+15,@POOL+15,10, 'Gold Vein'), +(@OGUID1+16,@POOL+16,80, 'Mithril Deposit'), +(@OGUID2+16,@POOL+16,10, 'Truesilver Deposit'), +(@OGUID3+16,@POOL+16,10, 'Gold Vein'), +(@OGUID1+17,@POOL+17,80, 'Mithril Deposit'), +(@OGUID2+17,@POOL+17,10, 'Truesilver Deposit'), +(@OGUID3+17,@POOL+17,10, 'Gold Vein'), +(@OGUID1+18,@POOL+18,80, 'Mithril Deposit'), +(@OGUID2+18,@POOL+18,10, 'Truesilver Deposit'), +(@OGUID3+18,@POOL+18,10, 'Gold Vein'), +(@OGUID1+19,@POOL+19,80, 'Mithril Deposit'), +(@OGUID2+19,@POOL+19,10, 'Truesilver Deposit'), +(@OGUID3+19,@POOL+19,10, 'Gold Vein'), +(@OGUID1+20,@POOL+20,80, 'Mithril Deposit'), +(@OGUID2+20,@POOL+20,10, 'Truesilver Deposit'), +(@OGUID3+20,@POOL+20,10, 'Gold Vein'), +(@OGUID1+21,@POOL+21,80, 'Mithril Deposit'), +(@OGUID2+21,@POOL+21,10, 'Truesilver Deposit'), +(@OGUID3+21,@POOL+21,10, 'Gold Vein'), +(@OGUID1+22,@POOL+22,80, 'Mithril Deposit'), +(@OGUID2+22,@POOL+22,10, 'Truesilver Deposit'), +(@OGUID3+22,@POOL+22,10, 'Gold Vein'), +(@OGUID1+23,@POOL+23,80, 'Mithril Deposit'), +(@OGUID2+23,@POOL+23,10, 'Truesilver Deposit'), +(@OGUID3+23,@POOL+23,10, 'Gold Vein'), +(@OGUID1+24,@POOL+24,80, 'Mithril Deposit'), +(@OGUID2+24,@POOL+24,10, 'Truesilver Deposit'), +(@OGUID3+24,@POOL+24,10, 'Gold Vein'), +(@OGUID1+25,@POOL+25,80, 'Mithril Deposit'), +(@OGUID2+25,@POOL+25,10, 'Truesilver Deposit'), +(@OGUID3+25,@POOL+25,10, 'Gold Vein'), +(@OGUID1+26,@POOL+26,80, 'Mithril Deposit'), +(@OGUID2+26,@POOL+26,10, 'Truesilver Deposit'), +(@OGUID3+26,@POOL+26,10, 'Gold Vein'), +(@OGUID1+27,@POOL+27,80, 'Mithril Deposit'), +(@OGUID2+27,@POOL+27,10, 'Truesilver Deposit'), +(@OGUID3+27,@POOL+27,10, 'Gold Vein'), +(@OGUID1+28,@POOL+28,80, 'Mithril Deposit'), +(@OGUID2+28,@POOL+28,10, 'Truesilver Deposit'), +(@OGUID3+28,@POOL+28,10, 'Gold Vein'), +(@OGUID1+29,@POOL+29,80, 'Mithril Deposit'), +(@OGUID2+29,@POOL+29,10, 'Truesilver Deposit'), +(@OGUID3+29,@POOL+29,10, 'Gold Vein'), +(@OGUID1+30,@POOL+30,80, 'Mithril Deposit'), +(@OGUID2+30,@POOL+30,10, 'Truesilver Deposit'), +(@OGUID3+30,@POOL+30,10, 'Gold Vein'), +(@OGUID1+31,@POOL+31,80, 'Mithril Deposit'), +(@OGUID2+31,@POOL+31,10, 'Truesilver Deposit'), +(@OGUID3+31,@POOL+31,10, 'Gold Vein'), +(@OGUID1+32,@POOL+32,80, 'Mithril Deposit'), +(@OGUID2+32,@POOL+32,10, 'Truesilver Deposit'), +(@OGUID3+32,@POOL+32,10, 'Gold Vein'), +(@OGUID1+33,@POOL+33,80, 'Mithril Deposit'), +(@OGUID2+33,@POOL+33,10, 'Truesilver Deposit'), +(@OGUID3+33,@POOL+33,10, 'Gold Vein'), +(@OGUID1+34,@POOL+34,80, 'Mithril Deposit'), +(@OGUID2+34,@POOL+34,10, 'Truesilver Deposit'), +(@OGUID3+34,@POOL+34,10, 'Gold Vein'), +(@OGUID1+35,@POOL+35,80, 'Mithril Deposit'), +(@OGUID2+35,@POOL+35,10, 'Truesilver Deposit'), +(@OGUID3+35,@POOL+35,10, 'Gold Vein'), +(@OGUID1+36,@POOL+36,80, 'Mithril Deposit'), +(@OGUID2+36,@POOL+36,10, 'Truesilver Deposit'), +(@OGUID3+36,@POOL+36,10, 'Gold Vein'), +(@OGUID1+37,@POOL+37,80, 'Mithril Deposit'), +(@OGUID2+37,@POOL+37,10, 'Truesilver Deposit'), +(@OGUID3+37,@POOL+37,10, 'Gold Vein'), +(@OGUID1+38,@POOL+38,80, 'Mithril Deposit'), +(@OGUID2+38,@POOL+38,10, 'Truesilver Deposit'), +(@OGUID3+38,@POOL+38,10, 'Gold Vein'), +(@OGUID1+39,@POOL+39,80, 'Mithril Deposit'), +(@OGUID2+39,@POOL+39,10, 'Truesilver Deposit'), +(@OGUID3+39,@POOL+39,10, 'Gold Vein'), +(@OGUID1+40,@POOL+40,80, 'Mithril Deposit'), +(@OGUID2+40,@POOL+40,10, 'Truesilver Deposit'), +(@OGUID3+40,@POOL+40,10, 'Gold Vein'), +(@OGUID1+41,@POOL+41,80, 'Mithril Deposit'), +(@OGUID2+41,@POOL+41,10, 'Truesilver Deposit'), +(@OGUID3+41,@POOL+41,10, 'Gold Vein'), +(@OGUID1+42,@POOL+42,80, 'Mithril Deposit'), +(@OGUID2+42,@POOL+42,10, 'Truesilver Deposit'), +(@OGUID3+42,@POOL+42,10, 'Gold Vein'), +(@OGUID1+43,@POOL+43,80, 'Mithril Deposit'), +(@OGUID2+43,@POOL+43,10, 'Truesilver Deposit'), +(@OGUID3+43,@POOL+43,10, 'Gold Vein'), +(@OGUID1+44,@POOL+44,80, 'Mithril Deposit'), +(@OGUID2+44,@POOL+44,10, 'Truesilver Deposit'), +(@OGUID3+44,@POOL+44,10, 'Gold Vein'), +(@OGUID1+45,@POOL+45,80, 'Mithril Deposit'), +(@OGUID2+45,@POOL+45,10, 'Truesilver Deposit'), +(@OGUID3+45,@POOL+45,10, 'Gold Vein'), +(@OGUID1+46,@POOL+46,80, 'Mithril Deposit'), +(@OGUID2+46,@POOL+46,10, 'Truesilver Deposit'), +(@OGUID3+46,@POOL+46,10, 'Gold Vein'), +(@OGUID1+47,@POOL+47,80, 'Mithril Deposit'), +(@OGUID2+47,@POOL+47,10, 'Truesilver Deposit'), +(@OGUID3+47,@POOL+47,10, 'Gold Vein'), +(@OGUID1+48,@POOL+48,80, 'Mithril Deposit'), +(@OGUID2+48,@POOL+48,10, 'Truesilver Deposit'), +(@OGUID3+48,@POOL+48,10, 'Gold Vein'), +(@OGUID1+49,@POOL+49,80, 'Mithril Deposit'), +(@OGUID2+49,@POOL+49,10, 'Truesilver Deposit'), +(@OGUID3+49,@POOL+49,10, 'Gold Vein'), +(@OGUID1+50,@POOL+50,80, 'Mithril Deposit'), +(@OGUID2+50,@POOL+50,10, 'Truesilver Deposit'), +(@OGUID3+50,@POOL+50,10, 'Gold Vein'), +(@OGUID1+51,@POOL+51,80, 'Mithril Deposit'), +(@OGUID2+51,@POOL+51,10, 'Truesilver Deposit'), +(@OGUID3+51,@POOL+51,10, 'Gold Vein'), +(@OGUID1+52,@POOL+52,80, 'Mithril Deposit'), +(@OGUID2+52,@POOL+52,10, 'Truesilver Deposit'), +(@OGUID3+52,@POOL+52,10, 'Gold Vein'), +(@OGUID1+53,@POOL+53,80, 'Mithril Deposit'), +(@OGUID2+53,@POOL+53,10, 'Truesilver Deposit'), +(@OGUID3+53,@POOL+53,10, 'Gold Vein'), +(@OGUID1+54,@POOL+54,80, 'Mithril Deposit'), +(@OGUID2+54,@POOL+54,10, 'Truesilver Deposit'), +(@OGUID3+54,@POOL+54,10, 'Gold Vein'), +(@OGUID1+55,@POOL+55,80, 'Mithril Deposit'), +(@OGUID2+55,@POOL+55,10, 'Truesilver Deposit'), +(@OGUID3+55,@POOL+55,10, 'Gold Vein'), +(@OGUID1+56,@POOL+56,80, 'Mithril Deposit'), +(@OGUID2+56,@POOL+56,10, 'Truesilver Deposit'), +(@OGUID3+56,@POOL+56,10, 'Gold Vein'), +(@OGUID1+57,@POOL+57,80, 'Mithril Deposit'), +(@OGUID2+57,@POOL+57,10, 'Truesilver Deposit'), +(@OGUID3+57,@POOL+57,10, 'Gold Vein'), +(@OGUID1+58,@POOL+58,80, 'Mithril Deposit'), +(@OGUID2+58,@POOL+58,10, 'Truesilver Deposit'), +(@OGUID3+58,@POOL+58,10, 'Gold Vein'), +(@OGUID1+59,@POOL+59,80, 'Mithril Deposit'), +(@OGUID2+59,@POOL+59,10, 'Truesilver Deposit'), +(@OGUID3+59,@POOL+59,10, 'Gold Vein'), +(@OGUID1+60,@POOL+60,80, 'Mithril Deposit'), +(@OGUID2+60,@POOL+60,10, 'Truesilver Deposit'), +(@OGUID3+60,@POOL+60,10, 'Gold Vein'), +(@OGUID1+61,@POOL+61,80, 'Mithril Deposit'), +(@OGUID2+61,@POOL+61,10, 'Truesilver Deposit'), +(@OGUID3+61,@POOL+61,10, 'Gold Vein'), +(@OGUID1+62,@POOL+62,80, 'Mithril Deposit'), +(@OGUID2+62,@POOL+62,10, 'Truesilver Deposit'), +(@OGUID3+62,@POOL+62,10, 'Gold Vein'), +(@OGUID1+63,@POOL+63,80, 'Mithril Deposit'), +(@OGUID2+63,@POOL+63,10, 'Truesilver Deposit'), +(@OGUID3+63,@POOL+63,10, 'Gold Vein'), +(@OGUID1+64,@POOL+64,80, 'Mithril Deposit'), +(@OGUID2+64,@POOL+64,10, 'Truesilver Deposit'), +(@OGUID3+64,@POOL+64,10, 'Gold Vein'), +(@OGUID1+65,@POOL+65,80, 'Mithril Deposit'), +(@OGUID2+65,@POOL+65,10, 'Truesilver Deposit'), +(@OGUID3+65,@POOL+65,10, 'Gold Vein'), +(@OGUID1+66,@POOL+66,80, 'Mithril Deposit'), +(@OGUID2+66,@POOL+66,10, 'Truesilver Deposit'), +(@OGUID3+66,@POOL+66,10, 'Gold Vein'), +(@OGUID1+67,@POOL+67,80, 'Mithril Deposit'), +(@OGUID2+67,@POOL+67,10, 'Truesilver Deposit'), +(@OGUID3+67,@POOL+67,10, 'Gold Vein'), +(@OGUID1+68,@POOL+68,80, 'Mithril Deposit'), +(@OGUID2+68,@POOL+68,10, 'Truesilver Deposit'), +(@OGUID3+68,@POOL+68,10, 'Gold Vein'), +(@OGUID1+69,@POOL+69,80, 'Mithril Deposit'), +(@OGUID2+69,@POOL+69,10, 'Truesilver Deposit'), +(@OGUID3+69,@POOL+69,10, 'Gold Vein'), +(@OGUID1+70,@POOL+70,80, 'Mithril Deposit'), +(@OGUID2+70,@POOL+70,10, 'Truesilver Deposit'), +(@OGUID3+70,@POOL+70,10, 'Gold Vein'), +(@OGUID1+71,@POOL+71,80, 'Mithril Deposit'), +(@OGUID2+71,@POOL+71,10, 'Truesilver Deposit'), +(@OGUID3+71,@POOL+71,10, 'Gold Vein'), +(@OGUID1+72,@POOL+72,80, 'Mithril Deposit'), +(@OGUID2+72,@POOL+72,10, 'Truesilver Deposit'), +(@OGUID3+72,@POOL+72,10, 'Gold Vein'), +(@OGUID1+73,@POOL+73,80, 'Mithril Deposit'), +(@OGUID2+73,@POOL+73,10, 'Truesilver Deposit'), +(@OGUID3+73,@POOL+73,10, 'Gold Vein'), +(@OGUID1+74,@POOL+74,80, 'Mithril Deposit'), +(@OGUID2+74,@POOL+74,10, 'Truesilver Deposit'), +(@OGUID3+74,@POOL+74,10, 'Gold Vein'), +(@OGUID1+75,@POOL+75,80, 'Mithril Deposit'), +(@OGUID2+75,@POOL+75,10, 'Truesilver Deposit'), +(@OGUID3+75,@POOL+75,10, 'Gold Vein'), +(@OGUID1+76,@POOL+76,80, 'Mithril Deposit'), +(@OGUID2+76,@POOL+76,10, 'Truesilver Deposit'), +(@OGUID3+76,@POOL+76,10, 'Gold Vein'), +(@OGUID1+77,@POOL+77,80, 'Mithril Deposit'), +(@OGUID2+77,@POOL+77,10, 'Truesilver Deposit'), +(@OGUID3+77,@POOL+77,10, 'Gold Vein'), +(@OGUID1+78,@POOL+78,80, 'Mithril Deposit'), +(@OGUID2+78,@POOL+78,10, 'Truesilver Deposit'), +(@OGUID3+78,@POOL+78,10, 'Gold Vein'), +(@OGUID1+79,@POOL+79,80, 'Mithril Deposit'), +(@OGUID2+79,@POOL+79,10, 'Truesilver Deposit'), +(@OGUID3+79,@POOL+79,10, 'Gold Vein'), +(@OGUID1+80,@POOL+80,80, 'Mithril Deposit'), +(@OGUID2+80,@POOL+80,10, 'Truesilver Deposit'), +(@OGUID3+80,@POOL+80,10, 'Gold Vein'), +(@OGUID1+81,@POOL+81,80, 'Mithril Deposit'), +(@OGUID2+81,@POOL+81,10, 'Truesilver Deposit'), +(@OGUID3+81,@POOL+81,10, 'Gold Vein'), +(@OGUID1+82,@POOL+82,80, 'Mithril Deposit'), +(@OGUID2+82,@POOL+82,10, 'Truesilver Deposit'), +(@OGUID3+82,@POOL+82,10, 'Gold Vein'), +(@OGUID1+83,@POOL+83,80, 'Mithril Deposit'), +(@OGUID2+83,@POOL+83,10, 'Truesilver Deposit'), +(@OGUID3+83,@POOL+83,10, 'Gold Vein'), +(@OGUID1+84,@POOL+84,80, 'Mithril Deposit'), +(@OGUID2+84,@POOL+84,10, 'Truesilver Deposit'), +(@OGUID3+84,@POOL+84,10, 'Gold Vein'), +(@OGUID1+85,@POOL+85,80, 'Mithril Deposit'), +(@OGUID2+85,@POOL+85,10, 'Truesilver Deposit'), +(@OGUID3+85,@POOL+85,10, 'Gold Vein'), +(@OGUID1+86,@POOL+86,80, 'Mithril Deposit'), +(@OGUID2+86,@POOL+86,10, 'Truesilver Deposit'), +(@OGUID3+86,@POOL+86,10, 'Gold Vein'), +(@OGUID1+87,@POOL+87,80, 'Mithril Deposit'), +(@OGUID2+87,@POOL+87,10, 'Truesilver Deposit'), +(@OGUID3+87,@POOL+87,10, 'Gold Vein'), +(@OGUID1+88,@POOL+88,80, 'Mithril Deposit'), +(@OGUID2+88,@POOL+88,10, 'Truesilver Deposit'), +(@OGUID3+88,@POOL+88,10, 'Gold Vein'), +(@OGUID1+89,@POOL+89,80, 'Mithril Deposit'), +(@OGUID2+89,@POOL+89,10, 'Truesilver Deposit'), +(@OGUID3+89,@POOL+89,10, 'Gold Vein'), +(@OGUID1+90,@POOL+90,80, 'Mithril Deposit'), +(@OGUID2+90,@POOL+90,10, 'Truesilver Deposit'), +(@OGUID3+90,@POOL+90,10, 'Gold Vein'), +(@OGUID1+91,@POOL+91,80, 'Mithril Deposit'), +(@OGUID2+91,@POOL+91,10, 'Truesilver Deposit'), +(@OGUID3+91,@POOL+91,10, 'Gold Vein'), +(@OGUID1+92,@POOL+92,80, 'Mithril Deposit'), +(@OGUID2+92,@POOL+92,10, 'Truesilver Deposit'), +(@OGUID3+92,@POOL+92,10, 'Gold Vein'), +(@OGUID1+93,@POOL+93,80, 'Mithril Deposit'), +(@OGUID2+93,@POOL+93,10, 'Truesilver Deposit'), +(@OGUID3+93,@POOL+93,10, 'Gold Vein'), +(@OGUID1+94,@POOL+94,80, 'Mithril Deposit'), +(@OGUID2+94,@POOL+94,10, 'Truesilver Deposit'), +(@OGUID3+94,@POOL+94,10, 'Gold Vein'), +(@OGUID1+95,@POOL+95,80, 'Mithril Deposit'), +(@OGUID2+95,@POOL+95,10, 'Truesilver Deposit'), +(@OGUID3+95,@POOL+95,10, 'Gold Vein'), +(@OGUID1+96,@POOL+96,80, 'Mithril Deposit'), +(@OGUID2+96,@POOL+96,10, 'Truesilver Deposit'), +(@OGUID3+96,@POOL+96,10, 'Gold Vein'), +(@OGUID1+97,@POOL+97,80, 'Mithril Deposit'), +(@OGUID2+97,@POOL+97,10, 'Truesilver Deposit'), +(@OGUID3+97,@POOL+97,10, 'Gold Vein'), +(@OGUID1+98,@POOL+98,80, 'Mithril Deposit'), +(@OGUID2+98,@POOL+98,10, 'Truesilver Deposit'), +(@OGUID3+98,@POOL+98,10, 'Gold Vein'), +(@OGUID1+99,@POOL+99,80, 'Mithril Deposit'), +(@OGUID2+99,@POOL+99,10, 'Truesilver Deposit'), +(@OGUID3+99,@POOL+99,10, 'Gold Vein'), +(@OGUID1+100,@POOL+100,80, 'Mithril Deposit'), +(@OGUID2+100,@POOL+100,10, 'Truesilver Deposit'), +(@OGUID3+100,@POOL+100,10, 'Gold Vein'), +(@OGUID1+101,@POOL+101,80, 'Mithril Deposit'), +(@OGUID2+101,@POOL+101,10, 'Truesilver Deposit'), +(@OGUID3+101,@POOL+101,10, 'Gold Vein'), +(@OGUID1+102,@POOL+102,80, 'Mithril Deposit'), +(@OGUID2+102,@POOL+102,10, 'Truesilver Deposit'), +(@OGUID3+102,@POOL+102,10, 'Gold Vein'), +(@OGUID1+103,@POOL+103,80, 'Mithril Deposit'), +(@OGUID2+103,@POOL+103,10, 'Truesilver Deposit'), +(@OGUID3+103,@POOL+103,10, 'Gold Vein'), +(@OGUID1+104,@POOL+104,80, 'Mithril Deposit'), +(@OGUID2+104,@POOL+104,10, 'Truesilver Deposit'), +(@OGUID3+104,@POOL+104,10, 'Gold Vein'), +(@OGUID1+105,@POOL+105,80, 'Mithril Deposit'), +(@OGUID2+105,@POOL+105,10, 'Truesilver Deposit'), +(@OGUID3+105,@POOL+105,10, 'Gold Vein'), +(@OGUID1+106,@POOL+106,80, 'Mithril Deposit'), +(@OGUID2+106,@POOL+106,10, 'Truesilver Deposit'), +(@OGUID3+106,@POOL+106,10, 'Gold Vein'), +(@OGUID1+107,@POOL+107,80, 'Mithril Deposit'), +(@OGUID2+107,@POOL+107,10, 'Truesilver Deposit'), +(@OGUID3+107,@POOL+107,10, 'Gold Vein'), +(@OGUID1+108,@POOL+108,80, 'Mithril Deposit'), +(@OGUID2+108,@POOL+108,10, 'Truesilver Deposit'), +(@OGUID3+108,@POOL+108,10, 'Gold Vein'), +(@OGUID1+109,@POOL+109,80, 'Mithril Deposit'), +(@OGUID2+109,@POOL+109,10, 'Truesilver Deposit'), +(@OGUID3+109,@POOL+109,10, 'Gold Vein'), +(@OGUID1+110,@POOL+110,80, 'Mithril Deposit'), +(@OGUID2+110,@POOL+110,10, 'Truesilver Deposit'), +(@OGUID3+110,@POOL+110,10, 'Gold Vein'), +(@OGUID1+111,@POOL+111,80, 'Mithril Deposit'), +(@OGUID2+111,@POOL+111,10, 'Truesilver Deposit'), +(@OGUID3+111,@POOL+111,10, 'Gold Vein'), +(@OGUID1+112,@POOL+112,80, 'Mithril Deposit'), +(@OGUID2+112,@POOL+112,10, 'Truesilver Deposit'), +(@OGUID3+112,@POOL+112,10, 'Gold Vein'), +(@OGUID1+113,@POOL+113,80, 'Mithril Deposit'), +(@OGUID2+113,@POOL+113,10, 'Truesilver Deposit'), +(@OGUID3+113,@POOL+113,10, 'Gold Vein'), +(@OGUID1+114,@POOL+114,80, 'Mithril Deposit'), +(@OGUID2+114,@POOL+114,10, 'Truesilver Deposit'), +(@OGUID3+114,@POOL+114,10, 'Gold Vein'), +(@OGUID1+115,@POOL+115,80, 'Mithril Deposit'), +(@OGUID2+115,@POOL+115,10, 'Truesilver Deposit'), +(@OGUID3+115,@POOL+115,10, 'Gold Vein'), +(@OGUID1+116,@POOL+116,80, 'Mithril Deposit'), +(@OGUID2+116,@POOL+116,10, 'Truesilver Deposit'), +(@OGUID3+116,@POOL+116,10, 'Gold Vein'), +(@OGUID1+117,@POOL+117,80, 'Mithril Deposit'), +(@OGUID2+117,@POOL+117,10, 'Truesilver Deposit'), +(@OGUID3+117,@POOL+117,10, 'Gold Vein'), +(@OGUID1+118,@POOL+118,80, 'Mithril Deposit'), +(@OGUID2+118,@POOL+118,10, 'Truesilver Deposit'), +(@OGUID3+118,@POOL+118,10, 'Gold Vein'), +(@OGUID1+119,@POOL+119,80, 'Mithril Deposit'), +(@OGUID2+119,@POOL+119,10, 'Truesilver Deposit'), +(@OGUID3+119,@POOL+119,10, 'Gold Vein'), +(@OGUID1+120,@POOL+120,80, 'Mithril Deposit'), +(@OGUID2+120,@POOL+120,10, 'Truesilver Deposit'), +(@OGUID3+120,@POOL+120,10, 'Gold Vein'), +(@OGUID1+121,@POOL+121,80, 'Mithril Deposit'), +(@OGUID2+121,@POOL+121,10, 'Truesilver Deposit'), +(@OGUID3+121,@POOL+121,10, 'Gold Vein'), +(@OGUID1+122,@POOL+122,80, 'Mithril Deposit'), +(@OGUID2+122,@POOL+122,10, 'Truesilver Deposit'), +(@OGUID3+122,@POOL+122,10, 'Gold Vein'), +(@OGUID1+123,@POOL+123,80, 'Mithril Deposit'), +(@OGUID2+123,@POOL+123,10, 'Truesilver Deposit'), +(@OGUID3+123,@POOL+123,10, 'Gold Vein'), +(@OGUID1+124,@POOL+124,80, 'Mithril Deposit'), +(@OGUID2+124,@POOL+124,10, 'Truesilver Deposit'), +(@OGUID3+124,@POOL+124,10, 'Gold Vein'), +(@OGUID1+125,@POOL+125,80, 'Mithril Deposit'), +(@OGUID2+125,@POOL+125,10, 'Truesilver Deposit'), +(@OGUID3+125,@POOL+125,10, 'Gold Vein'), +(@OGUID1+126,@POOL+126,80, 'Mithril Deposit'), +(@OGUID2+126,@POOL+126,10, 'Truesilver Deposit'), +(@OGUID3+126,@POOL+126,10, 'Gold Vein'), +(@OGUID1+127,@POOL+127,80, 'Mithril Deposit'), +(@OGUID2+127,@POOL+127,10, 'Truesilver Deposit'), +(@OGUID3+127,@POOL+127,10, 'Gold Vein'), +(@OGUID1+128,@POOL+128,80, 'Mithril Deposit'), +(@OGUID2+128,@POOL+128,10, 'Truesilver Deposit'), +(@OGUID3+128,@POOL+128,10, 'Gold Vein'), +(@OGUID1+129,@POOL+129,80, 'Mithril Deposit'), +(@OGUID2+129,@POOL+129,10, 'Truesilver Deposit'), +(@OGUID3+129,@POOL+129,10, 'Gold Vein'), +(@OGUID1+130,@POOL+130,80, 'Mithril Deposit'), +(@OGUID2+130,@POOL+130,10, 'Truesilver Deposit'), +(@OGUID3+130,@POOL+130,10, 'Gold Vein'), +(@OGUID1+131,@POOL+131,80, 'Mithril Deposit'), +(@OGUID2+131,@POOL+131,10, 'Truesilver Deposit'), +(@OGUID3+131,@POOL+131,10, 'Gold Vein'), +(@OGUID1+132,@POOL+132,80, 'Mithril Deposit'), +(@OGUID2+132,@POOL+132,10, 'Truesilver Deposit'), +(@OGUID3+132,@POOL+132,10, 'Gold Vein'), +(@OGUID1+133,@POOL+133,80, 'Mithril Deposit'), +(@OGUID2+133,@POOL+133,10, 'Truesilver Deposit'), +(@OGUID3+133,@POOL+133,10, 'Gold Vein'), +(@OGUID1+134,@POOL+134,80, 'Mithril Deposit'), +(@OGUID2+134,@POOL+134,10, 'Truesilver Deposit'), +(@OGUID3+134,@POOL+134,10, 'Gold Vein'), +(@OGUID1+135,@POOL+135,80, 'Mithril Deposit'), +(@OGUID2+135,@POOL+135,10, 'Truesilver Deposit'), +(@OGUID3+135,@POOL+135,10, 'Gold Vein'), +(@OGUID1+136,@POOL+136,80, 'Mithril Deposit'), +(@OGUID2+136,@POOL+136,10, 'Truesilver Deposit'), +(@OGUID3+136,@POOL+136,10, 'Gold Vein'), +(@OGUID1+137,@POOL+137,80, 'Mithril Deposit'), +(@OGUID2+137,@POOL+137,10, 'Truesilver Deposit'), +(@OGUID3+137,@POOL+137,10, 'Gold Vein'), +(@OGUID1+138,@POOL+138,80, 'Mithril Deposit'), +(@OGUID2+138,@POOL+138,10, 'Truesilver Deposit'), +(@OGUID3+138,@POOL+138,10, 'Gold Vein'), +(@OGUID1+139,@POOL+139,80, 'Mithril Deposit'), +(@OGUID2+139,@POOL+139,10, 'Truesilver Deposit'), +(@OGUID3+139,@POOL+139,10, 'Gold Vein'), +(@OGUID1+140,@POOL+140,80, 'Mithril Deposit'), +(@OGUID2+140,@POOL+140,10, 'Truesilver Deposit'), +(@OGUID3+140,@POOL+140,10, 'Gold Vein'), +(@OGUID1+141,@POOL+141,80, 'Mithril Deposit'), +(@OGUID2+141,@POOL+141,10, 'Truesilver Deposit'), +(@OGUID3+141,@POOL+141,10, 'Gold Vein'), +(@OGUID1+142,@POOL+142,80, 'Mithril Deposit'), +(@OGUID2+142,@POOL+142,10, 'Truesilver Deposit'), +(@OGUID3+142,@POOL+142,10, 'Gold Vein'), +(@OGUID1+143,@POOL+143,80, 'Mithril Deposit'), +(@OGUID2+143,@POOL+143,10, 'Truesilver Deposit'), +(@OGUID3+143,@POOL+143,10, 'Gold Vein'), +(@OGUID1+144,@POOL+144,80, 'Mithril Deposit'), +(@OGUID2+144,@POOL+144,10, 'Truesilver Deposit'), +(@OGUID3+144,@POOL+144,10, 'Gold Vein'), +(@OGUID1+145,@POOL+145,80, 'Mithril Deposit'), +(@OGUID2+145,@POOL+145,10, 'Truesilver Deposit'), +(@OGUID3+145,@POOL+145,10, 'Gold Vein'), +(@OGUID1+146,@POOL+146,80, 'Mithril Deposit'), +(@OGUID2+146,@POOL+146,10, 'Truesilver Deposit'), +(@OGUID3+146,@POOL+146,10, 'Gold Vein'), +(@OGUID1+147,@POOL+147,80, 'Mithril Deposit'), +(@OGUID2+147,@POOL+147,10, 'Truesilver Deposit'), +(@OGUID3+147,@POOL+147,10, 'Gold Vein'), +(@OGUID1+148,@POOL+148,80, 'Mithril Deposit'), +(@OGUID2+148,@POOL+148,10, 'Truesilver Deposit'), +(@OGUID3+148,@POOL+148,10, 'Gold Vein'), +(@OGUID1+149,@POOL+149,80, 'Mithril Deposit'), +(@OGUID2+149,@POOL+149,10, 'Truesilver Deposit'), +(@OGUID3+149,@POOL+149,10, 'Gold Vein'), +(@OGUID1+150,@POOL+150,80, 'Mithril Deposit'), +(@OGUID2+150,@POOL+150,10, 'Truesilver Deposit'), +(@OGUID3+150,@POOL+150,10, 'Gold Vein'), +(@OGUID1+151,@POOL+151,80, 'Mithril Deposit'), +(@OGUID2+151,@POOL+151,10, 'Truesilver Deposit'), +(@OGUID3+151,@POOL+151,10, 'Gold Vein'), +(@OGUID1+152,@POOL+152,80, 'Mithril Deposit'), +(@OGUID2+152,@POOL+152,10, 'Truesilver Deposit'), +(@OGUID3+152,@POOL+152,10, 'Gold Vein'), +(@OGUID1+153,@POOL+153,80, 'Mithril Deposit'), +(@OGUID2+153,@POOL+153,10, 'Truesilver Deposit'), +(@OGUID3+153,@POOL+153,10, 'Gold Vein'), +(@OGUID1+154,@POOL+154,80, 'Mithril Deposit'), +(@OGUID2+154,@POOL+154,10, 'Truesilver Deposit'), +(@OGUID3+154,@POOL+154,10, 'Gold Vein'), +(@OGUID1+155,@POOL+155,80, 'Mithril Deposit'), +(@OGUID2+155,@POOL+155,10, 'Truesilver Deposit'), +(@OGUID3+155,@POOL+155,10, 'Gold Vein'), +(@OGUID1+156,@POOL+156,80, 'Mithril Deposit'), +(@OGUID2+156,@POOL+156,10, 'Truesilver Deposit'), +(@OGUID3+156,@POOL+156,10, 'Gold Vein'), +(@OGUID1+157,@POOL+157,80, 'Mithril Deposit'), +(@OGUID2+157,@POOL+157,10, 'Truesilver Deposit'), +(@OGUID3+157,@POOL+157,10, 'Gold Vein'), +(@OGUID1+158,@POOL+158,80, 'Mithril Deposit'), +(@OGUID2+158,@POOL+158,10, 'Truesilver Deposit'), +(@OGUID3+158,@POOL+158,10, 'Gold Vein'), +(@OGUID1+159,@POOL+159,80, 'Mithril Deposit'), +(@OGUID2+159,@POOL+159,10, 'Truesilver Deposit'), +(@OGUID3+159,@POOL+159,10, 'Gold Vein'), +(@OGUID1+160,@POOL+160,80, 'Mithril Deposit'), +(@OGUID2+160,@POOL+160,10, 'Truesilver Deposit'), +(@OGUID3+160,@POOL+160,10, 'Gold Vein'), +(@OGUID1+161,@POOL+161,80, 'Mithril Deposit'), +(@OGUID2+161,@POOL+161,10, 'Truesilver Deposit'), +(@OGUID3+161,@POOL+161,10, 'Gold Vein'), +(@OGUID1+162,@POOL+162,80, 'Mithril Deposit'), +(@OGUID2+162,@POOL+162,10, 'Truesilver Deposit'), +(@OGUID3+162,@POOL+162,10, 'Gold Vein'), +(@OGUID1+163,@POOL+163,80, 'Mithril Deposit'), +(@OGUID2+163,@POOL+163,10, 'Truesilver Deposit'), +(@OGUID3+163,@POOL+163,10, 'Gold Vein'), +(@OGUID1+164,@POOL+164,80, 'Mithril Deposit'), +(@OGUID2+164,@POOL+164,10, 'Truesilver Deposit'), +(@OGUID3+164,@POOL+164,10, 'Gold Vein'), +(@OGUID1+165,@POOL+165,80, 'Mithril Deposit'), +(@OGUID2+165,@POOL+165,10, 'Truesilver Deposit'), +(@OGUID3+165,@POOL+165,10, 'Gold Vein'), +(@OGUID1+166,@POOL+166,80, 'Mithril Deposit'), +(@OGUID2+166,@POOL+166,10, 'Truesilver Deposit'), +(@OGUID3+166,@POOL+166,10, 'Gold Vein'), +(@OGUID1+167,@POOL+167,80, 'Mithril Deposit'), +(@OGUID2+167,@POOL+167,10, 'Truesilver Deposit'), +(@OGUID3+167,@POOL+167,10, 'Gold Vein'), +(@OGUID1+168,@POOL+168,80, 'Mithril Deposit'), +(@OGUID2+168,@POOL+168,10, 'Truesilver Deposit'), +(@OGUID3+168,@POOL+168,10, 'Gold Vein'), +(@OGUID1+169,@POOL+169,80, 'Mithril Deposit'), +(@OGUID2+169,@POOL+169,10, 'Truesilver Deposit'), +(@OGUID3+169,@POOL+169,10, 'Gold Vein'), +(@OGUID1+170,@POOL+170,80, 'Mithril Deposit'), +(@OGUID2+170,@POOL+170,10, 'Truesilver Deposit'), +(@OGUID3+170,@POOL+170,10, 'Gold Vein'), +(@OGUID1+171,@POOL+171,80, 'Mithril Deposit'), +(@OGUID2+171,@POOL+171,10, 'Truesilver Deposit'), +(@OGUID3+171,@POOL+171,10, 'Gold Vein'), +(@OGUID1+172,@POOL+172,80, 'Mithril Deposit'), +(@OGUID2+172,@POOL+172,10, 'Truesilver Deposit'), +(@OGUID3+172,@POOL+172,10, 'Gold Vein'), +(@OGUID1+173,@POOL+173,80, 'Mithril Deposit'), +(@OGUID2+173,@POOL+173,10, 'Truesilver Deposit'), +(@OGUID3+173,@POOL+173,10, 'Gold Vein'); + +-- Add each pool to pool template +DELETE FROM `pool_template` WHERE `entry` BETWEEN @POOL AND @POOL+@LASTGUID; +INSERT INTO `pool_template` (`entry`,`max_limit`,`description`) VALUES +(@POOL+0,1, 'Felwood Ore Spawnpoint'), +(@POOL+1,1, 'Felwood Ore Spawnpoint'), +(@POOL+2,1, 'Felwood Ore Spawnpoint'), +(@POOL+3,1, 'Felwood Ore Spawnpoint'), +(@POOL+4,1, 'Felwood Ore Spawnpoint'), +(@POOL+5,1, 'Felwood Ore Spawnpoint'), +(@POOL+6,1, 'Felwood Ore Spawnpoint'), +(@POOL+7,1, 'Felwood Ore Spawnpoint'), +(@POOL+8,1, 'Felwood Ore Spawnpoint'), +(@POOL+9,1, 'Felwood Ore Spawnpoint'), +(@POOL+10,1, 'Felwood Ore Spawnpoint'), +(@POOL+11,1, 'Felwood Ore Spawnpoint'), +(@POOL+12,1, 'Felwood Ore Spawnpoint'), +(@POOL+13,1, 'Felwood Ore Spawnpoint'), +(@POOL+14,1, 'Felwood Ore Spawnpoint'), +(@POOL+15,1, 'Felwood Ore Spawnpoint'), +(@POOL+16,1, 'Felwood Ore Spawnpoint'), +(@POOL+17,1, 'Felwood Ore Spawnpoint'), +(@POOL+18,1, 'Felwood Ore Spawnpoint'), +(@POOL+19,1, 'Felwood Ore Spawnpoint'), +(@POOL+20,1, 'Felwood Ore Spawnpoint'), +(@POOL+21,1, 'Felwood Ore Spawnpoint'), +(@POOL+22,1, 'Felwood Ore Spawnpoint'), +(@POOL+23,1, 'Felwood Ore Spawnpoint'), +(@POOL+24,1, 'Felwood Ore Spawnpoint'), +(@POOL+25,1, 'Felwood Ore Spawnpoint'), +(@POOL+26,1, 'Felwood Ore Spawnpoint'), +(@POOL+27,1, 'Felwood Ore Spawnpoint'), +(@POOL+28,1, 'Felwood Ore Spawnpoint'), +(@POOL+29,1, 'Felwood Ore Spawnpoint'), +(@POOL+30,1, 'Felwood Ore Spawnpoint'), +(@POOL+31,1, 'Felwood Ore Spawnpoint'), +(@POOL+32,1, 'Felwood Ore Spawnpoint'), +(@POOL+33,1, 'Felwood Ore Spawnpoint'), +(@POOL+34,1, 'Felwood Ore Spawnpoint'), +(@POOL+35,1, 'Felwood Ore Spawnpoint'), +(@POOL+36,1, 'Felwood Ore Spawnpoint'), +(@POOL+37,1, 'Felwood Ore Spawnpoint'), +(@POOL+38,1, 'Felwood Ore Spawnpoint'), +(@POOL+39,1, 'Felwood Ore Spawnpoint'), +(@POOL+40,1, 'Felwood Ore Spawnpoint'), +(@POOL+41,1, 'Felwood Ore Spawnpoint'), +(@POOL+42,1, 'Felwood Ore Spawnpoint'), +(@POOL+43,1, 'Felwood Ore Spawnpoint'), +(@POOL+44,1, 'Felwood Ore Spawnpoint'), +(@POOL+45,1, 'Felwood Ore Spawnpoint'), +(@POOL+46,1, 'Felwood Ore Spawnpoint'), +(@POOL+47,1, 'Felwood Ore Spawnpoint'), +(@POOL+48,1, 'Felwood Ore Spawnpoint'), +(@POOL+49,1, 'Felwood Ore Spawnpoint'), +(@POOL+50,1, 'Felwood Ore Spawnpoint'), +(@POOL+51,1, 'Felwood Ore Spawnpoint'), +(@POOL+52,1, 'Felwood Ore Spawnpoint'), +(@POOL+53,1, 'Felwood Ore Spawnpoint'), +(@POOL+54,1, 'Felwood Ore Spawnpoint'), +(@POOL+55,1, 'Felwood Ore Spawnpoint'), +(@POOL+56,1, 'Felwood Ore Spawnpoint'), +(@POOL+57,1, 'Felwood Ore Spawnpoint'), +(@POOL+58,1, 'Felwood Ore Spawnpoint'), +(@POOL+59,1, 'Felwood Ore Spawnpoint'), +(@POOL+60,1, 'Felwood Ore Spawnpoint'), +(@POOL+61,1, 'Felwood Ore Spawnpoint'), +(@POOL+62,1, 'Felwood Ore Spawnpoint'), +(@POOL+63,1, 'Felwood Ore Spawnpoint'), +(@POOL+64,1, 'Felwood Ore Spawnpoint'), +(@POOL+65,1, 'Felwood Ore Spawnpoint'), +(@POOL+66,1, 'Felwood Ore Spawnpoint'), +(@POOL+67,1, 'Felwood Ore Spawnpoint'), +(@POOL+68,1, 'Felwood Ore Spawnpoint'), +(@POOL+69,1, 'Felwood Ore Spawnpoint'), +(@POOL+70,1, 'Felwood Ore Spawnpoint'), +(@POOL+71,1, 'Felwood Ore Spawnpoint'), +(@POOL+72,1, 'Felwood Ore Spawnpoint'), +(@POOL+73,1, 'Felwood Ore Spawnpoint'), +(@POOL+74,1, 'Felwood Ore Spawnpoint'), +(@POOL+75,1, 'Felwood Ore Spawnpoint'), +(@POOL+76,1, 'Felwood Ore Spawnpoint'), +(@POOL+77,1, 'Felwood Ore Spawnpoint'), +(@POOL+78,1, 'Felwood Ore Spawnpoint'), +(@POOL+79,1, 'Felwood Ore Spawnpoint'), +(@POOL+80,1, 'Felwood Ore Spawnpoint'), +(@POOL+81,1, 'Felwood Ore Spawnpoint'), +(@POOL+82,1, 'Felwood Ore Spawnpoint'), +(@POOL+83,1, 'Felwood Ore Spawnpoint'), +(@POOL+84,1, 'Felwood Ore Spawnpoint'), +(@POOL+85,1, 'Felwood Ore Spawnpoint'), +(@POOL+86,1, 'Felwood Ore Spawnpoint'), +(@POOL+87,1, 'Felwood Ore Spawnpoint'), +(@POOL+88,1, 'Felwood Ore Spawnpoint'), +(@POOL+89,1, 'Felwood Ore Spawnpoint'), +(@POOL+90,1, 'Felwood Ore Spawnpoint'), +(@POOL+91,1, 'Felwood Ore Spawnpoint'), +(@POOL+92,1, 'Felwood Ore Spawnpoint'), +(@POOL+93,1, 'Felwood Ore Spawnpoint'), +(@POOL+94,1, 'Felwood Ore Spawnpoint'), +(@POOL+95,1, 'Felwood Ore Spawnpoint'), +(@POOL+96,1, 'Felwood Ore Spawnpoint'), +(@POOL+97,1, 'Felwood Ore Spawnpoint'), +(@POOL+98,1, 'Felwood Ore Spawnpoint'), +(@POOL+99,1, 'Felwood Ore Spawnpoint'), +(@POOL+100,1, 'Felwood Ore Spawnpoint'), +(@POOL+101,1, 'Felwood Ore Spawnpoint'), +(@POOL+102,1, 'Felwood Ore Spawnpoint'), +(@POOL+103,1, 'Felwood Ore Spawnpoint'), +(@POOL+104,1, 'Felwood Ore Spawnpoint'), +(@POOL+105,1, 'Felwood Ore Spawnpoint'), +(@POOL+106,1, 'Felwood Ore Spawnpoint'), +(@POOL+107,1, 'Felwood Ore Spawnpoint'), +(@POOL+108,1, 'Felwood Ore Spawnpoint'), +(@POOL+109,1, 'Felwood Ore Spawnpoint'), +(@POOL+110,1, 'Felwood Ore Spawnpoint'), +(@POOL+111,1, 'Felwood Ore Spawnpoint'), +(@POOL+112,1, 'Felwood Ore Spawnpoint'), +(@POOL+113,1, 'Felwood Ore Spawnpoint'), +(@POOL+114,1, 'Felwood Ore Spawnpoint'), +(@POOL+115,1, 'Felwood Ore Spawnpoint'), +(@POOL+116,1, 'Felwood Ore Spawnpoint'), +(@POOL+117,1, 'Felwood Ore Spawnpoint'), +(@POOL+118,1, 'Felwood Ore Spawnpoint'), +(@POOL+119,1, 'Felwood Ore Spawnpoint'), +(@POOL+120,1, 'Felwood Ore Spawnpoint'), +(@POOL+121,1, 'Felwood Ore Spawnpoint'), +(@POOL+122,1, 'Felwood Ore Spawnpoint'), +(@POOL+123,1, 'Felwood Ore Spawnpoint'), +(@POOL+124,1, 'Felwood Ore Spawnpoint'), +(@POOL+125,1, 'Felwood Ore Spawnpoint'), +(@POOL+126,1, 'Felwood Ore Spawnpoint'), +(@POOL+127,1, 'Felwood Ore Spawnpoint'), +(@POOL+128,1, 'Felwood Ore Spawnpoint'), +(@POOL+129,1, 'Felwood Ore Spawnpoint'), +(@POOL+130,1, 'Felwood Ore Spawnpoint'), +(@POOL+131,1, 'Felwood Ore Spawnpoint'), +(@POOL+132,1, 'Felwood Ore Spawnpoint'), +(@POOL+133,1, 'Felwood Ore Spawnpoint'), +(@POOL+134,1, 'Felwood Ore Spawnpoint'), +(@POOL+135,1, 'Felwood Ore Spawnpoint'), +(@POOL+136,1, 'Felwood Ore Spawnpoint'), +(@POOL+137,1, 'Felwood Ore Spawnpoint'), +(@POOL+138,1, 'Felwood Ore Spawnpoint'), +(@POOL+139,1, 'Felwood Ore Spawnpoint'), +(@POOL+140,1, 'Felwood Ore Spawnpoint'), +(@POOL+141,1, 'Felwood Ore Spawnpoint'), +(@POOL+142,1, 'Felwood Ore Spawnpoint'), +(@POOL+143,1, 'Felwood Ore Spawnpoint'), +(@POOL+144,1, 'Felwood Ore Spawnpoint'), +(@POOL+145,1, 'Felwood Ore Spawnpoint'), +(@POOL+146,1, 'Felwood Ore Spawnpoint'), +(@POOL+147,1, 'Felwood Ore Spawnpoint'), +(@POOL+148,1, 'Felwood Ore Spawnpoint'), +(@POOL+149,1, 'Felwood Ore Spawnpoint'), +(@POOL+150,1, 'Felwood Ore Spawnpoint'), +(@POOL+151,1, 'Felwood Ore Spawnpoint'), +(@POOL+152,1, 'Felwood Ore Spawnpoint'), +(@POOL+153,1, 'Felwood Ore Spawnpoint'), +(@POOL+154,1, 'Felwood Ore Spawnpoint'), +(@POOL+155,1, 'Felwood Ore Spawnpoint'), +(@POOL+156,1, 'Felwood Ore Spawnpoint'), +(@POOL+157,1, 'Felwood Ore Spawnpoint'), +(@POOL+158,1, 'Felwood Ore Spawnpoint'), +(@POOL+159,1, 'Felwood Ore Spawnpoint'), +(@POOL+160,1, 'Felwood Ore Spawnpoint'), +(@POOL+161,1, 'Felwood Ore Spawnpoint'), +(@POOL+162,1, 'Felwood Ore Spawnpoint'), +(@POOL+163,1, 'Felwood Ore Spawnpoint'), +(@POOL+164,1, 'Felwood Ore Spawnpoint'), +(@POOL+165,1, 'Felwood Ore Spawnpoint'), +(@POOL+166,1, 'Felwood Ore Spawnpoint'), +(@POOL+167,1, 'Felwood Ore Spawnpoint'), +(@POOL+168,1, 'Felwood Ore Spawnpoint'), +(@POOL+169,1, 'Felwood Ore Spawnpoint'), +(@POOL+170,1, 'Felwood Ore Spawnpoint'), +(@POOL+171,1, 'Felwood Ore Spawnpoint'), +(@POOL+172,1, 'Felwood Ore Spawnpoint'), +(@POOL+173,1, 'Felwood Ore Spawnpoint'); + +-- Add each pool to pool_pool +DELETE FROM `pool_pool` WHERE `pool_id` BETWEEN @POOL AND @POOL+@LASTGUID; +INSERT INTO `pool_pool` (`pool_id`,`mother_pool`,`chance`,`description`) VALUES +(@POOL+0,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+1,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+2,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+3,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+4,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+5,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+6,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+7,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+8,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+9,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+10,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+11,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+12,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+13,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+14,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+15,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+16,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+17,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+18,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+19,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+20,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+21,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+22,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+23,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+24,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+25,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+26,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+27,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+28,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+29,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+30,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+31,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+32,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+33,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+34,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+35,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+36,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+37,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+38,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+39,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+40,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+41,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+42,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+43,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+44,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+45,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+46,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+47,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+48,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+49,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+50,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+51,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+52,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+53,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+54,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+55,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+56,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+57,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+58,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+59,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+60,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+61,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+62,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+63,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+64,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+65,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+66,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+67,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+68,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+69,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+70,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+71,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+72,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+73,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+74,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+75,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+76,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+77,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+78,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+79,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+80,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+81,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+82,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+83,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+84,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+85,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+86,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+87,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+88,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+89,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+90,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+91,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+92,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+93,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+94,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+95,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+96,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+97,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+98,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+99,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+100,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+101,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+102,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+103,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+104,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+105,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+106,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+107,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+108,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+109,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+110,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+111,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+112,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+113,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+114,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+115,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+116,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+117,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+118,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+119,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+120,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+121,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+122,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+123,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+124,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+125,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+126,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+127,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+128,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+129,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+130,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+131,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+132,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+133,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+134,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+135,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+136,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+137,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+138,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+139,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+140,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+141,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+142,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+143,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+144,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+145,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+146,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+147,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+148,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+149,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+150,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+151,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+152,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+153,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+154,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+155,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+156,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+157,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+158,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+159,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+160,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+161,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+162,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+163,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+164,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+165,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+166,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+167,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+168,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+169,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+170,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+171,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+172,@MOTHER,0, 'Felwood Ore Spawnpoint'), +(@POOL+173,@MOTHER,0, 'Felwood Ore Spawnpoint'); + +UPDATE `gameobject` SET `PhaseId`=169 WHERE `PhaseId`=1; diff --git a/sql/updates/world/6.x/2016_06_20_02_world.sql b/sql/updates/world/6.x/2016_06_20_02_world.sql new file mode 100644 index 00000000000..38034246657 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_20_02_world.sql @@ -0,0 +1,320 @@ +-- +SET @CGUID := 452425; +SET @OGUID := 300916; + +DELETE FROM `creature` WHERE `map`=369; +DELETE FROM `gameobject` WHERE `map`=369; + +DELETE FROM `creature` WHERE `guid` BETWEEN @CGUID+0 AND @CGUID+110; +INSERT INTO `creature` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `MovementType`) VALUES +(@CGUID+0, 59481, 369, 1, -111.592, 2497.691, -49.03749, 3.245147, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+1, 59481, 369, 1, -123.015, 2486.45, -49.03749, 1.610651, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+2, 59481, 369, 1, -112.0902, 2502.644, -49.03749, 3.245147, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+3, 66305, 369, 1, -120.93, 2499.215, -42.5099, 4.981629, 7200, 0, 0), -- Generic Bunny - PRK (Gigantic AOI) (Area: Deeprun Tram) (Auras: 131338 - Brawl Sound - Alliance, Fight (DNT)) +(@CGUID+4, 59481, 369, 1, -117.2557, 2488.732, -49.03749, 1.610651, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+5, 13018, 369, 1, -19.66991, 2459.451, -4.297698, 4.315197, 7200, 0, 0), -- Nipsy (Area: Deeprun Tram) +(@CGUID+6, 59481, 369, 1, -122.51, 2512.107, -49.03749, 1.610651, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+7, 59481, 369, 1, -113.6001, 2492.852, -49.03749, 1.610651, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+8, 68952, 369, 1, -11.66637, 2460.222, -13.67119, 0, 7200, 0, 0), -- Bizmo's Brawlpub Entrance (Area: Deeprun Tram) +(@CGUID+9, 59481, 369, 1, -117.462, 2510.872, -49.03749, 1.610651, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+10, 59481, 369, 1, -113.6244, 2507.23, -49.03749, 1.610651, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+11, 59481, 369, 1, -128.5394, 2511.586, -49.03749, 1.610651, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+12, 59481, 369, 1, -128.2716, 2486.095, -49.03749, 1.610651, 7200, 0, 0), -- World Trigger (Area: Deeprun Tram) +(@CGUID+13, 68801, 369, 1, -72.61393, 2484.34, -42.56921, 2.688661, 7200, 0, 0), -- Flora (Area: Deeprun Tram) +(@CGUID+14, 68798, 369, 1, -74.73705, 2488.276, -42.56943, 4.384407, 7200, 0, 0), -- Verah "Violet" Bustle (Area: Deeprun Tram) +(@CGUID+15, 68408, 369, 1, -79.87337, 2456.72, -43.02885, 6.074724, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) +(@CGUID+16, 68363, 369, 1, -80.62134, 2493.143, -43.04583, 3.141518, 7200, 0, 0), -- Quackenbush (Area: Deeprun Tram) +(@CGUID+17, 68408, 369, 1, -79.48066, 2462.06, -43.04464, 0.006766027, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) +(@CGUID+18, 68963, 369, 1, -69.9504, 2531.353, -43.03644, 4.470451, 7200, 0, 0), -- Boom Room Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+19, 68537, 369, 1, -77.59014, 2474.093, -42.57321, 5.390444, 7200, 0, 0), -- Keith "The Party" Westin (Area: Deeprun Tram) (Auras: 135041 - Wearing Glasses) +(@CGUID+20, 68540, 369, 1, -92.56053, 2501.646, -43.0263, 3.215507, 7200, 0, 0), -- Twix Gearspark (Area: Deeprun Tram) (Auras: 135038 - Wearing A Rose) +(@CGUID+21, 70752, 369, 1, -80.73928, 2496.621, -43.04459, 3.155379, 7200, 0, 0), -- Card Trader Leila (Area: Deeprun Tram) +(@CGUID+22, 68408, 369, 1, -80.53696, 2503.729, -43.04551, 3.495188, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+23, 68408, 369, 1, -92.82359, 2478.773, -43.02393, 5.454063, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+24, 68442, 369, 1, -185.4213, 2403.296, -19.29758, 1.549658, 7200, 0, 0), -- Subway Car (Area: Deeprun Tram) (Auras: 46598 - Ride Vehicle Hardcoded) (possible waypoints or random movement) +(@CGUID+25, 68994, 369, 1, -92.15841, 2508.988, -43.02711, 3.417215, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+26, 68442, 369, 1, -185.9497, 2378.302, -19.29758, 1.549658, 7200, 0, 0), -- Subway Car (Area: Deeprun Tram) (Auras: 46598 - Ride Vehicle Hardcoded) (possible waypoints or random movement) +(@CGUID+27, 68803, 369, 1, -77.40304, 2527.581, -43.14859, 1.466077, 7200, 0, 0), -- Willow Cloudstep (Area: Deeprun Tram) +(@CGUID+28, 68406, 369, 1, -90.78221, 2510.052, -43.02958, 3.444857, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+29, 68994, 369, 1, -91.88435, 2507.1, -43.02748, 3.360122, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+30, 68434, 369, 1, -184.8929, 2428.29, -19.29758, 1.549658, 7200, 0, 0), -- Subway Car (Area: Deeprun Tram) (Auras: ) +(@CGUID+31, 68963, 369, 1, -77.38558, 2531.209, -43.06725, 4.655104, 7200, 0, 0), -- Boom Room Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+32, 73645, 369, 1, -100.9014, 2521.038, -43.00908, 4.456221, 7200, 0, 0), -- Mochi (Area: Deeprun Tram) +(@CGUID+33, 73642, 369, 1, -101.7706, 2521.221, -43.01014, 4.267982, 7200, 0, 0), -- Carman Cheung (Area: Deeprun Tram) +(@CGUID+34, 68323, 369, 1, -100.3051, 2500.025, -38.27213, 4.704797, 7200, 0, 0), -- Bizmo (Area: Deeprun Tram) (Auras: 134727 - Announcer Control Aura) (possible waypoints or random movement) +(@CGUID+35, 68994, 369, 1, -98.8081, 2528.282, -30.94316, 4.794365, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+36, 68994, 369, 1, -92.28378, 2495.343, -43.02649, 2.885064, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+37, 68408, 369, 1, -92.80369, 2520.167, -43.02577, 0.9440587, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+38, 68408, 369, 1, -105.0908, 2536.745, -29.50906, 3.152398, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+39, 68405, 369, 1, -92.70891, 2513.377, -41.73821, 3.517262, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+40, 68992, 369, 1, -97.60636, 2521.3, -43.0251, 4.362116, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+41, 73646, 369, 1, -110.409, 2521.234, -43.09079, 3.983943, 7200, 0, 0), -- Mugen (Area: Deeprun Tram) +(@CGUID+42, 68994, 369, 1, -114.8847, 2528.314, -30.94316, 4.794365, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+43, 70722, 369, 1, -115.9391, 2548.06, -29.42094, 5.008683, 7200, 0, 0), -- Grant Lazarby (Area: Deeprun Tram) +(@CGUID+44, 68406, 369, 1, -104.7996, 2478.275, -43.02339, 1.905591, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+45, 70354, 369, 1, -111.4123, 2521.159, -43.00659, 4.784949, 7200, 0, 0), -- Stabby Joe (Area: Deeprun Tram) +(@CGUID+46, 68992, 369, 1, -107.2923, 2477.497, -41.59616, 1.724435, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+47, 68405, 369, 1, -115.9377, 2528.296, -30.94316, 4.794365, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+48, 68768, 369, 1, -107.1775, 2469.11, -43.02339, 4.816863, 7200, 0, 0), -- "Numbers" Pfeiffer (Area: Deeprun Tram) +(@CGUID+49, 68541, 369, 1, -108.9182, 2465.788, -41.7275, 1.688493, 7200, 0, 0), -- "To Catch A Spy" - Controller Bunny (Area: Deeprun Tram) +(@CGUID+50, 68992, 369, 1, -111.289, 2478.452, -43.02339, 1.660031, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+51, 68526, 369, 1, -107.7167, 2464.034, -43.02339, 1.513651, 7200, 0, 0), -- Barkeep Townsley (Area: Deeprun Tram) +(@CGUID+52, 68405, 369, 1, -115.428, 2476.831, -43.02339, 1.412076, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) (possible waypoints or random movement) +(@CGUID+53, 67559, 369, 1, -120.3602, 2498.904, -49.03749, 1.610651, 7200, 0, 0), -- Center of Arena (Area: Deeprun Tram) +(@CGUID+54, 68792, 369, 1, -117.8844, 2525.327, -43.0252, 0, 7200, 0, 0), -- Lidiya Peyton (Area: Deeprun Tram) +(@CGUID+55, 41200, 369, 1, -122.3594, 2499.679, -49.02588, 6.281145, 7200, 0, 0), -- Generic Bunny - PRK (Area: Deeprun Tram) +(@CGUID+56, 68406, 369, 1, -123.4395, 2476.39, -43.02323, 1.289963, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+57, 68992, 369, 1, -128.1297, 2522.312, -43.0252, 4.925224, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+58, 70719, 369, 1, -129.2251, 2546.816, -28.64184, 4.700079, 7200, 0, 0), -- Mozzle Gearbeer (Area: Deeprun Tram) +(@CGUID+59, 68408, 369, 1, -119.6542, 2543.874, -29.51023, 4.66066, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+60, 68535, 369, 1, -124.0146, 2470.271, -43.02339, 4.654057, 7200, 0, 0), -- Zoe Mae (Area: Deeprun Tram) +(@CGUID+61, 68799, 369, 1, -133.157, 2522.6, -43.1086, 5.253441, 7200, 0, 0), -- Sniffy Pete (Area: Deeprun Tram) +(@CGUID+62, 70721, 369, 1, -138.4244, 2531.526, -29.42594, 5.201118, 7200, 0, 0), -- Auriella Giggysprock (Area: Deeprun Tram) +(@CGUID+63, 70723, 369, 1, -138.8784, 2553.276, -29.51023, 1.654117, 7200, 0, 0), -- Dame Jesepha (Area: Deeprun Tram) +(@CGUID+64, 68408, 369, 1, -140.8107, 2543.777, -29.51023, 4.763262, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+65, 68406, 369, 1, -147.5056, 2530.823, -29.45766, 5.258637, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+66, 68539, 369, 1, -123.2527, 2468.814, -43.02339, 4.693232, 7200, 0, 0), -- Tasha Windpaw (Area: Deeprun Tram) (Auras: 135042 - Wearing A Silly Hat) +(@CGUID+67, 68992, 369, 1, -135.8501, 2520.722, -43.02504, 4.998402, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+68, 70720, 369, 1, -140.3198, 2531.583, -29.43665, 5.252556, 7200, 0, 0), -- Kreeg O'Lalley (Area: Deeprun Tram) +(@CGUID+69, 68406, 369, 1, -135.3807, 2478.33, -41.82138, 0.4567683, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+70, 68405, 369, 1, -137.7543, 2476.543, -43.02323, 0.8270133, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+71, 68992, 369, 1, -147.7791, 2492.552, -43.12021, 0.06981317, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+72, 68405, 369, 1, -148.0988, 2486.217, -43.09425, 0.4335296, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+73, 68408, 369, 1, -146.7061, 2520.218, -43.04026, 2.367301, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+74, 68994, 369, 1, -147.2167, 2488.962, -43.06815, 0.3635806, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+75, 68406, 369, 1, -147.3227, 2512.465, -43.07458, 6.069045, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+76, 68994, 369, 1, -147.2851, 2491.248, -43.07172, 0.2907128, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+77, 68406, 369, 1, -147.6912, 2490.127, -43.09228, 0.3222111, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+78, 68796, 369, 1, -133.553, 2465.56, -43.10672, 0.07545592, 7200, 0, 0), -- Brom Ironboot (Area: Deeprun Tram) (Auras: 32951 - Sleeping Sleep) +(@CGUID+79, 68797, 369, 1, -134.0696, 2467.511, -43.10672, 0.1178655, 7200, 0, 0), -- Babby Ironboot (Area: Deeprun Tram) (Auras: 32951 - Sleeping Sleep) (possible waypoints or random movement) +(@CGUID+80, 68408, 369, 1, -146.3822, 2478.488, -43.02087, 4.011124, 7200, 0, 0), -- Bizmo's Brawlpub Bouncer (Area: Deeprun Tram) (Auras: 134909 - Guard Area Trigger) +(@CGUID+81, 68764, 369, 1, -146.3028, 2529.885, -43.02577, 4.902921, 7200, 0, 0), -- Willard "Bubbles" Wilcox (Area: Deeprun Tram) +(@CGUID+82, 68406, 369, 1, -146.6423, 2475.746, -43.10672, 5.603979, 7200, 0, 0), -- Brawl Enthusiast (Area: Deeprun Tram) +(@CGUID+83, 64367, 369, 1, -121.3079, 2499.617, -51.52943, 0, 7200, 0, 0), -- Invisible Man (Area: Bizmo's Brawlpub) +(@CGUID+84, 10942, 369, 1, 75.55157, 1339.963, -117.9171, 1.745329, 7200, 0, 0), -- Nessy (Area: 0) (Auras: 3417 - Thrash) +(@CGUID+85, 5186, 369, 1, -112.5415, 1154.451, -119.3451, 1.842971, 7200, 0, 0), -- Basking Shark (Area: 0) +(@CGUID+86, 10956, 369, 1, 49.28621, 1190.869, -121.3143, 5.759336, 7200, 0, 0), -- Naga Siren (Area: 0) (possible waypoints or random movement) +(@CGUID+87, 12997, 369, 1, -19.63116, 40.07523, -4.297364, 4.799655, 7200, 0, 0), -- Monty (Area: 0) +(@CGUID+88, 13016, 369, 1, -72.91493, 28.83738, -4.295185, 4.817047, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+89, 13016, 369, 1, -48.21173, 83.58146, -13.86341, 4.895867, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+90, 13016, 369, 1, -74.56241, 26.27987, -4.296764, 1.524805, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+91, 13016, 369, 1, -64.81646, 9.109329, -4.298093, 2.861342, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+92, 13016, 369, 1, -46.58396, 50.17245, -13.86341, 1.715754, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+93, 13016, 369, 1, -57.21196, -21.82399, -4.297354, 5.160522, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+94, 13016, 369, 1, -43.35949, -36.59221, -4.297349, 2.571393, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+95, 13016, 369, 1, -69.88953, -16.39119, -4.297355, 5.97014, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+96, 13016, 369, 1, 25.99659, 8.834719, -4.297348, 5.974719, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+97, 13016, 369, 1, 2.777291, 58.8372, -13.86342, 3.297968, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+98, 14041, 369, 1, 25.26379, 14.66779, -4.29735, 0.02318603, 7200, 0, 0), -- Haggle (Area: 0) (possible waypoints or random movement) +(@CGUID+99, 13016, 369, 1, -45.03532, -14.37037, -13.86343, 1.545782, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+100, 13016, 369, 1, 5.721666, 86.90855, -13.86341, 4.284974, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+101, 13016, 369, 1, 20.23471, 24.19788, -4.287271, 2.203791, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+102, 13016, 369, 1, 31.22039, -4.568573, -4.297352, 4.505353, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+103, 13016, 369, 1, 29.57163, -19.09113, -4.297352, 1.515674, 7200, 5, 1), -- Deeprun Rat (Area: 0) +(@CGUID+104, 5186, 369, 1, 88.33257, 1046.559, -122.219, 1.076333, 7200, 0, 0), -- Basking Shark (Area: 0) +(@CGUID+105, 14121, 369, 1, 32.48093, 1253.982, -123.7761, 1.58335, 7200, 0, 0), -- Deeprun Diver (Area: 0) (Auras: 22431 - Tag: Bubbles) +(@CGUID+106, 10942, 369, 1, -113.8064, 1254.373, -123.0315, 0.541052, 7200, 0, 0), -- Nessy (Area: 0) (Auras: 3417 - Thrash) +(@CGUID+107, 5186, 369, 1, 73.59551, 1359.462, -119.6585, 2.401082, 7200, 0, 0), -- Basking Shark (Area: 0) +(@CGUID+108, 10942, 369, 1, 54.22202, 1148.91, -120.5259, 3.236281, 7200, 0, 0), -- Nessy (Area: 0) (Auras: 3417 - Thrash) +(@CGUID+109, 10942, 369, 1, -113.8064, 1254.373, -123.0315, 0.541052, 7200, 0, 0), -- Nessy (Area: 0) (Auras: 3417 - Thrash) +(@CGUID+110, 14121, 369, 1, 68.96642, 1107.01, -121.1463, 1.448623, 7200, 0, 0); -- Deeprun Diver (Area: 0) (Auras: 22431 - Tag: Bubbles) + +DELETE FROM `gameobject` WHERE `guid` BETWEEN @OGUID+0 AND @OGUID+196; +INSERT INTO `gameobject` (`guid`, `id`, `map`, `spawnMask`, `position_x`, `position_y`, `position_z`, `orientation`, `rotation0`, `rotation1`, `rotation2`, `rotation3`, `spawntimesecs`, `animprogress`, `state`) VALUES +(@OGUID+0, 218240, 369, 1, 39.73352, 2508.677, -4.294677, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+1, 218241, 369, 1, 39.82929, 2514.314, -4.294678, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+2, 218242, 369, 1, 39.70155, 2501.759, -4.294677, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+3, 218243, 369, 1, 39.70155, 2469.287, -4.294677, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+4, 218244, 369, 1, 39.73352, 2476.204, -4.294677, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+5, 218245, 369, 1, 39.82929, 2481.842, -4.294678, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+6, 218262, 369, 1, -19.9828, 2513.025, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+7, 218263, 369, 1, -20.07856, 2507.387, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+8, 218264, 369, 1, -20.11053, 2500.469, -4.294851, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+9, 218265, 369, 1, -20.66589, 2474.819, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+10, 218266, 369, 1, -20.57011, 2480.457, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+11, 218267, 369, 1, -20.69785, 2467.902, -4.294851, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+12, 218268, 369, 1, -17.70583, 2473.837, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+13, 218269, 369, 1, -17.8016, 2468.2, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+14, 218270, 369, 1, -17.01946, 2513.227, -4.29485, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+15, 218271, 369, 1, -17.1472, 2500.672, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+16, 218230, 369, 1, 23.66657, 2511.292, -4.294677, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+17, 218231, 369, 1, 23.34438, 2507.955, -4.294676, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+18, 218203, 369, 1, 4.580645, 28.20966, 7.011068, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 24), -- 0 (Area: Deeprun Tram) +(@OGUID+19, 218232, 369, 1, 23.49342, 2504.603, -4.294677, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+20, 218233, 369, 1, 23.34438, 2475.57, -4.294677, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+21, 218234, 369, 1, 23.49342, 2472.218, -4.294677, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+22, 218235, 369, 1, 23.66658, 2478.907, -4.294677, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+23, 218236, 369, 1, 20.55386, 2501.279, -4.294677, 2.932139, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+24, 218237, 369, 1, 20.75057, 2514.581, -4.294677, 3.220161, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+25, 218238, 369, 1, 20.75058, 2481.732, -4.294677, 3.220161, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+26, 218239, 369, 1, 20.55387, 2468.431, -4.294677, 2.932139, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+27, 218208, 369, 1, 4.498832, -11.34751, 7.011068, 4.71239, 0, 0, 1, -4.371139E-08, 7200, 255, 24), -- 0 (Area: Deeprun Tram) +(@OGUID+28, 218204, 369, 1, 4.528066, 8.435292, 7.011068, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 24), -- 0 (Area: Deeprun Tram) +(@OGUID+29, 218272, 369, 1, -17.05142, 2506.31, -4.29485, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+30, 218273, 369, 1, -17.67386, 2480.754, -4.294851, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+31, 218246, 369, 1, -64.48874, 2504.563, -4.294677, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+32, 218247, 369, 1, -64.16654, 2507.901, -4.294676, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+33, 218248, 369, 1, -64.31558, 2511.252, -4.294677, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+34, 218249, 369, 1, -63.73218, 2475.644, -4.294677, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+35, 218250, 369, 1, -63.88121, 2478.996, -4.294677, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+36, 218251, 369, 1, -64.05437, 2472.306, -4.294677, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+37, 218252, 369, 1, -61.37602, 2514.576, -4.294676, 6.073748, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+38, 218253, 369, 1, -61.57273, 2501.275, -4.294676, 0.07854, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+39, 218254, 369, 1, -61.13838, 2469.482, -4.294677, 0.07854, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+40, 218255, 369, 1, -60.94166, 2482.783, -4.294677, 6.073748, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+41, 218259, 369, 1, -80.64693, 2480.339, -4.294677, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+42, 218260, 369, 1, -80.6789, 2473.422, -4.294677, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+43, 218261, 369, 1, -80.77467, 2467.784, -4.294678, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+44, 218336, 369, 1, -71.31967, 2469.101, -42.869, 2.35619, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+45, 218337, 369, 1, -71.29236, 2474.231, -42.84547, 3.926991, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+46, 218338, 369, 1, -74.48042, 2475.56, -42.8726, 4.71239, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+47, 218339, 369, 1, -74.30511, 2482.061, -42.8726, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+48, 218341, 369, 1, -71.66871, 2483.934, -42.79978, 2.44346, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+49, 218342, 369, 1, -71.60806, 2487.854, -42.79978, 3.839725, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+50, 218344, 369, 1, -70.35074, 2500.099, -42.8726, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+51, 218345, 369, 1, -71.56815, 2497.768, -42.86273, 2.35619, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+52, 218334, 369, 1, -74.32562, 2467.829, -42.8726, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+53, 218335, 369, 1, -70.21131, 2471.709, -42.8726, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+54, 218340, 369, 1, -74.48042, 2489.804, -42.8726, 4.71239, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+55, 218346, 369, 1, -71.56815, 2502.425, -42.84547, 3.926991, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+56, 218256, 369, 1, -80.56744, 2507, -4.294678, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+57, 218257, 369, 1, -80.66321, 2501.362, -4.294678, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+58, 218258, 369, 1, -80.53547, 2513.917, -4.294677, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+59, 218343, 369, 1, -74.30511, 2496.409, -42.8726, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+60, 218347, 369, 1, -74.48042, 2503.618, -42.8726, 4.71239, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+61, 218348, 369, 1, -74.30511, 2510.373, -42.8726, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+62, 218349, 369, 1, -74.48042, 2517.582, -42.8726, 4.71239, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+63, 218350, 369, 1, -71.92816, 2512.242, -42.79978, 2.44346, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+64, 218351, 369, 1, -71.886, 2515.754, -42.79978, 3.839725, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+65, 220360, 369, 1, -96.89163, 2478.907, -43.10672, 4.717134, 0, 0, 0, 1, 7200, 255, 1), -- Remote Viewing Console (Area: Deeprun Tram) +(@OGUID+66, 218332, 369, 1, -95.01887, 2464.429, -43.10918, 3.054327, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+67, 218333, 369, 1, -94.87846, 2458.042, -43.16341, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+68, 218331, 369, 1, -105.69, 2469.067, -43.10918, 4.625124, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+69, 218207, 369, 1, -45.39338, 2472.931, 6.988598, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 24), -- 0 (Area: Deeprun Tram) +(@OGUID+70, 218205, 369, 1, -45.40052, 2492.792, 6.988598, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 24), -- 0 (Area: Deeprun Tram) +(@OGUID+71, 218206, 369, 1, -45.40074, 2512.148, 6.988598, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 24), -- 0 (Area: Deeprun Tram) +(@OGUID+72, 218366, 369, 1, -103.7942, 2521.406, -43.16342, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+73, 218361, 369, 1, -108.6291, 2549.7, -29.53149, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+74, 218363, 369, 1, -110.5395, 2552.282, -29.45867, 4.01426, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+75, 218364, 369, 1, -114.3652, 2552.402, -29.45867, 5.410522, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+76, 218367, 369, 1, -108.0164, 2521.269, -43.10919, 6.195921, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+77, 218319, 369, 1, -114.9488, 2531.119, -43.16342, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+78, 218321, 369, 1, -106.7227, 2530.981, -43.10919, 6.195921, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+79, 218322, 369, 1, -102.5006, 2531.119, -43.16342, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+80, 218370, 369, 1, -115.3981, 2521.104, -43.10919, 3.054327, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+81, 218330, 369, 1, -110.2254, 2468.849, -43.16341, 4.712392, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+82, 218329, 369, 1, -114.9488, 2468.849, -43.16341, 4.712392, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+83, 218365, 369, 1, -119.6202, 2520.967, -43.16342, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+84, 218328, 369, 1, -119.7294, 2468.745, -43.10918, 4.625124, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+85, 220360, 369, 1, -121.4181, 2545.575, -29.59357, 3.132858, 0, 0, 0, 1, 7200, 255, 1), -- Remote Viewing Console (Area: Deeprun Tram) +(@OGUID+86, 218352, 369, 1, -133.5216, 2541.906, -29.50879, 1.483528, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+87, 218353, 369, 1, -128.9862, 2541.802, -29.56301, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+88, 218354, 369, 1, -123.4175, 2547.911, -29.55851, 3.054327, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+89, 218355, 369, 1, -123.3138, 2551.838, -29.61273, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+90, 218362, 369, 1, -116.1536, 2549.525, -29.53149, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+91, 218320, 369, 1, -126.5526, 2530.816, -43.10919, 3.054327, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+92, 218323, 369, 1, -119.1709, 2530.981, -43.10919, 6.195921, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+93, 218368, 369, 1, -127.8463, 2521.104, -43.10919, 3.054327, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+94, 220087, 369, 1, -128.901, 2546.624, -29.59357, 5.885697, 0, 0, 0, 1, 7200, 255, 1), -- Book Stack (Area: Deeprun Tram) +(@OGUID+95, 220360, 369, 1, -142.9507, 2520.156, -43.0725, 1.592488, 0, 0, 0, 1, 7200, 255, 1), -- Remote Viewing Console (Area: Deeprun Tram) +(@OGUID+96, 218356, 369, 1, -143.9925, 2549.628, -29.49515, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+97, 218318, 369, 1, -130.7747, 2530.679, -43.16342, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+98, 218327, 369, 1, -125.339, 2468.849, -43.16341, 4.712392, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+99, 218369, 369, 1, -132.0684, 2520.967, -43.16342, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+100, 218214, 369, 1, -138.2139, 2471.3, -43.10609, 4.127707, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+101, 218215, 369, 1, -141.3755, 2471.253, -43.10609, 5.401793, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+102, 218216, 369, 1, -139.5541, 2466.639, -43.10673, 1.570796, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+103, 218217, 369, 1, -137.1418, 2468.598, -43.10609, 2.940878, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+104, 218357, 369, 1, -147.8015, 2554.089, -29.49515, 4.71239, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+105, 218358, 369, 1, -145.2794, 2552.678, -29.34725, 3.926991, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+106, 218359, 369, 1, -150.3227, 2552.781, -29.46802, 5.497789, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+107, 218360, 369, 1, -151.6096, 2549.453, -29.49515, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+108, 218324, 369, 1, -133.7215, 2463.137, -43.16341, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+109, 218325, 369, 1, -133.6178, 2458.097, -43.10918, 6.195921, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+110, 218326, 369, 1, -130.3793, 2469.195, -43.10918, 4.625124, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+111, 218213, 369, 1, -140.3532, 2463.915, -43.10609, 3.900813, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+112, 218218, 369, 1, -141.942, 2468.055, -43.10609, 0.4363316, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+113, 218209, 369, 1, -144.8453, 2461.269, -43.10609, 0.1745321, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+114, 218210, 369, 1, -140.0449, 2460.966, -43.10673, 2.836158, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+115, 218211, 369, 1, -142.2138, 2459.56, -43.10674, 1.527163, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+116, 218212, 369, 1, -143.7642, 2464.378, -43.10609, 5.218536, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+117, 218219, 369, 1, -146.5631, 2466.862, -43.10674, 2.530723, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+118, 218220, 369, 1, -146.5619, 2469.745, -43.10609, 3.700098, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+119, 218221, 369, 1, -151.3983, 2467.785, -43.10673, 6.265733, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+120, 218222, 369, 1, -149.2733, 2465.646, -43.10673, 1.596976, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+121, 218223, 369, 1, -150.1574, 2470.702, -43.10609, 5.218536, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: Deeprun Tram) +(@OGUID+122, 220360, 369, 1, -138.1376, 2456.681, -43.1059, 1.546259, 0, 0, 0, 1, 7200, 255, 1), -- Remote Viewing Console (Area: Deeprun Tram) +(@OGUID+123, 179264, 369, 1, -79.30329, 1211.732, -122.8182, 0.4014249, 0, 0, 0, 1, 7200, 255, 1), -- Giant Clam (Area: 0) +(@OGUID+124, 178304, 369, 1, -22.5045, 44.43635, -4.297362, 1.291542, 0, 0, 0, 1, 7200, 255, 1), -- Box o' Squirrels (Area: 0) +(@OGUID+125, 208864, 369, 1, -18.80994, 28.25147, -4.297366, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+126, 178304, 369, 1, -16.77179, 44.47802, -4.297363, 1.832595, 0, 0, 0, 1, 7200, 255, 1), -- Box o' Squirrels (Area: 0) +(@OGUID+127, 208864, 369, 1, -81.32017, 22.30112, -4.297349, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+128, 218306, 369, 1, -17.0512, 24.52901, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+129, 218307, 369, 1, -17.14698, 18.89099, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+130, 218308, 369, 1, -17.01924, 31.44611, -4.294851, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+131, 208864, 369, 1, -77.95713, 45.4724, -4.297347, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+132, 218315, 369, 1, -20.11032, 18.68863, -4.294851, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+133, 218316, 369, 1, -20.07835, 25.60595, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+134, 218317, 369, 1, -19.98258, 31.24376, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+135, 178304, 369, 1, -19.66363, 44.25616, -4.297363, 5.270896, 0, 0, 0, 1, 7200, 255, 1), -- Box o' Squirrels (Area: 0) +(@OGUID+136, 218277, 369, 1, -64.24798, 25.16312, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+137, 218278, 369, 1, -64.39703, 28.51469, -4.29485, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+138, 218279, 369, 1, -64.57018, 21.82545, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+139, 218282, 369, 1, -61.65417, 19.00144, -4.294851, 0.07854, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+140, 218283, 369, 1, -61.45748, 32.30244, -4.294851, 6.073748, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+141, 218287, 369, 1, -80.60516, 31.44611, -4.294851, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+142, 218288, 369, 1, -80.63712, 24.52901, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+143, 218303, 369, 1, 39.74333, 20.39353, -4.294851, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+144, 208864, 369, 1, -63.69213, -15.59292, -4.297354, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+145, 208864, 369, 1, 9.727059, -23.84358, -13.86343, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+146, 208864, 369, 1, 21.24571, 17.08864, -4.29735, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+147, 208864, 369, 1, -0.5995102, 33.58908, -13.86343, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+148, 208864, 369, 1, 37.16822, 44.65622, -4.297347, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+149, 218304, 369, 1, 39.77528, 27.31064, -4.29485, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+150, 218305, 369, 1, 39.87106, 32.94865, -4.294852, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+151, 218309, 369, 1, -20.66567, -6.96157, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+152, 218310, 369, 1, -20.56989, -1.323543, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+153, 218311, 369, 1, -20.69763, -13.87867, -4.294851, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+154, 218312, 369, 1, -17.67365, -1.026118, -4.294851, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+155, 218313, 369, 1, -17.70562, -7.943435, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+156, 218314, 369, 1, -17.80138, -13.58124, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+157, 208864, 369, 1, -55.16456, -37.43731, -4.297352, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+158, 208864, 369, 1, 21.65013, -15.25156, -4.297355, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+159, 208864, 369, 1, -65.49454, -11.31814, -4.297354, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+160, 208864, 369, 1, -25.81312, -24.38962, -4.297369, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+161, 208864, 369, 1, 16.44149, 46.07506, -4.297347, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+162, 218274, 369, 1, -64.57018, -10.55954, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+163, 218275, 369, 1, -64.24798, -7.221652, -4.29485, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+164, 218276, 369, 1, -64.39702, -3.870082, -4.294851, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+165, 208864, 369, 1, -80.1594, -5.485014, -4.297352, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+166, 218280, 369, 1, -61.45747, -0.5463043, -4.29485, 6.073748, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+167, 218281, 369, 1, -61.65417, -13.84751, -4.294851, 0.07854, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+168, 208864, 369, 1, -62.29871, 0.4384706, -4.297353, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+169, 218284, 369, 1, -80.63712, -7.943434, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+170, 218285, 369, 1, -80.73289, -13.58124, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+171, 218286, 369, 1, -80.60516, -1.026123, -4.294851, 6.204646, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+172, 218289, 369, 1, -80.73289, 18.89098, -4.294851, 0, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+173, 208864, 369, 1, -18.22651, -5.197068, -4.297369, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+174, 218290, 369, 1, 23.58513, -3.829995, -4.29485, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+175, 218291, 369, 1, 23.26293, -7.167885, -4.29485, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+176, 218292, 369, 1, 23.41197, -10.51945, -4.294851, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+177, 218293, 369, 1, 22.82857, 25.08885, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+178, 218294, 369, 1, 22.97761, 21.73728, -4.29485, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+179, 218295, 369, 1, 23.15076, 28.42652, -4.29485, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+180, 218296, 369, 1, 20.47242, -13.84323, -4.29485, 2.932139, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+181, 218297, 369, 1, 20.66912, -0.5420112, -4.29485, 3.220161, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+182, 218298, 369, 1, 20.23477, 31.25052, -4.294851, 3.220161, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+183, 218299, 369, 1, 20.03805, 17.94952, -4.294851, 2.932139, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+184, 218300, 369, 1, 39.66383, -6.266836, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+185, 218301, 369, 1, 39.75959, -0.6290315, -4.294851, 3.141593, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+186, 218302, 369, 1, 39.63186, -13.18415, -4.294851, 3.063024, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Chair (Area: 0) +(@OGUID+187, 208864, 369, 1, 40.01941, -25.9875, -4.297345, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+188, 208864, 369, 1, 14.71833, -37.30925, -4.297353, 0, 0, 0, 0, 1, 7200, 255, 1), -- Rat Trap (Area: 0) +(@OGUID+189, 218226, 369, 1, 112.0717, 21.57919, -0.967929, 6.278823, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Doodad_DwarfSign_Fireworks01 (Area: 0) +(@OGUID+190, 218227, 369, 1, 109.3507, 16.21418, -4.294435, 0.8508465, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Brazier (Area: 0) +(@OGUID+191, 218228, 369, 1, 109.8475, 4.727702, -4.294435, 0.8508465, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Brazier (Area: 0) +(@OGUID+192, 218229, 369, 1, 112.3642, 5.079133, -4.357647, 0.8508465, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Mailbox (Area: 0) +(@OGUID+193, 218224, 369, 1, 146.9395, -6.104181, -3.154193, 2.412915, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Doodad_GnomeSign_Engineer01 (Area: 0) +(@OGUID+194, 218225, 369, 1, 146.4382, 27.88295, -0.142696, 3.878999, 0, 0, 1, -4.371139E-08, 7200, 255, 1), -- Doodad_DwarfSign_Alchemist01 (Area: 0) +(@OGUID+195, 179264, 369, 1, 37.43438, 1316.428, -121.9855, 3.839725, 0, 0, 0, 1, 7200, 255, 1), -- Giant Clam (Area: 0) +(@OGUID+196, 179345, 369, 1, 57.43581, 1206.985, -121.5893, 3.630291, 0, 0, 0, 1, 7200, 255, 1); -- Deeprun Chest (Area: 0) diff --git a/sql/updates/world/6.x/2016_06_23_00_world.sql b/sql/updates/world/6.x/2016_06_23_00_world.sql new file mode 100644 index 00000000000..42f23376051 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_23_00_world.sql @@ -0,0 +1,5 @@ +-- +SET @CGUID := 250016; +DELETE FROM creature WHERE `guid` = @CGUID; +INSERT INTO creature (`guid`, `id`, `map`, `zoneId`, `areaId`, `spawnMask`, `PhaseId`, `PhaseGroup`, `modelid`, `equipment_id`, `position_x`, `position_y`, `position_z`, `orientation`, `spawntimesecs`, `spawndist`, `currentwaypoint`, `curhealth`, `curmana`, `MovementType`, `npcflag`, `unit_flags`, `dynamicflags`, `VerifiedBuild`) VALUES +(@CGUID, 37024, 1, 0, 0, 1, 0, 0, 0, 0, -798.2708, -486.757, -32.19226, 1.623156, 120, 0, 0, 0, 0, 0, 0, 0, 0, 15354); diff --git a/sql/updates/world/6.x/2016_06_23_01_world.sql b/sql/updates/world/6.x/2016_06_23_01_world.sql new file mode 100644 index 00000000000..843ee299caa --- /dev/null +++ b/sql/updates/world/6.x/2016_06_23_01_world.sql @@ -0,0 +1,2 @@ +-- Make both quests 24812 & 24813 available to players: you must complete both quests to take next one, quest 24814. +UPDATE `quest_template_addon` SET `ExclusiveGroup`= -24812 WHERE `id` IN (24812, 24813); diff --git a/sql/updates/world/6.x/2016_06_23_02_world.sql b/sql/updates/world/6.x/2016_06_23_02_world.sql new file mode 100644 index 00000000000..43f2c02dcf2 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_23_02_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_monk_surging_mist'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(116694,'spell_monk_surging_mist'); diff --git a/sql/updates/world/6.x/2016_06_25_00_world.sql b/sql/updates/world/6.x/2016_06_25_00_world.sql new file mode 100644 index 00000000000..b82331b7a19 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_25_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `flags_extra`=64 WHERE `entry` IN(53714, 57873, 58168, 60162, 60931, 65069); diff --git a/sql/updates/world/6.x/2016_06_26_00_world.sql b/sql/updates/world/6.x/2016_06_26_00_world.sql new file mode 100644 index 00000000000..ead8bc25478 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_26_00_world.sql @@ -0,0 +1,3 @@ +DELETE FROM `spell_script_names` WHERE `ScriptName`='spell_monk_surging_mist_glyphed'; +INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES +(123273,'spell_monk_surging_mist_glyphed'); diff --git a/sql/updates/world/6.x/2016_06_28_00_world.sql b/sql/updates/world/6.x/2016_06_28_00_world.sql new file mode 100644 index 00000000000..f56a204ba5c --- /dev/null +++ b/sql/updates/world/6.x/2016_06_28_00_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `npcflag`=`npcflag` &~2 WHERE `entry` IN (15294); diff --git a/sql/updates/world/6.x/2016_06_28_01_world.sql b/sql/updates/world/6.x/2016_06_28_01_world.sql new file mode 100644 index 00000000000..b5414324100 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_28_01_world.sql @@ -0,0 +1,2 @@ +-- +UPDATE `creature_template` SET `npcflag`=`npcflag` &~2 WHERE `entry` IN (15273, 15298); diff --git a/sql/updates/world/6.x/2016_06_30_00_world.sql b/sql/updates/world/6.x/2016_06_30_00_world.sql new file mode 100644 index 00000000000..4684bf97b77 --- /dev/null +++ b/sql/updates/world/6.x/2016_06_30_00_world.sql @@ -0,0 +1,2 @@ +-- +DELETE FROM `creature_queststarter` WHERE `id` IN (3101,16521,16522); diff --git a/sql/updates/world/6.x/2016_07_05_00_world.sql b/sql/updates/world/6.x/2016_07_05_00_world.sql new file mode 100644 index 00000000000..e81a39afd96 --- /dev/null +++ b/sql/updates/world/6.x/2016_07_05_00_world.sql @@ -0,0 +1,33 @@ +-- Dark Siphon +DELETE FROM `conditions` WHERE `SourceTypeOrReferenceId`=13 AND `SourceGroup`=0 AND `SourceEntry`=165059; +INSERT INTO `conditions` (`SourceTypeOrReferenceId`,`SourceGroup`,`SourceEntry`,`SourceId`,`ElseGroup`,`ConditionTypeOrReference`,`ConditionTarget`,`ConditionValue1`,`ConditionValue2`,`ConditionValue3`,`ErrorTextId`,`ScriptName`,`Comment`) VALUES +(13,1,165059,0,0,31,0,3,81556 ,0,0,"","Dark Siphon – Cast only on K'ure."); + +-- Decimatus SAI +SET @ENTRY := 81989; +UPDATE `creature_template` SET `AIName`="SmartAI" WHERE `entry`=@ENTRY; +DELETE FROM `smart_scripts` WHERE `entryorguid`=@ENTRY AND `source_type`=0; +INSERT INTO `smart_scripts` (`entryorguid`,`source_type`,`id`,`link`,`event_type`,`event_phase_mask`,`event_chance`,`event_flags`,`event_param1`,`event_param2`,`event_param3`,`event_param4`,`action_type`,`action_param1`,`action_param2`,`action_param3`,`action_param4`,`action_param5`,`action_param6`,`target_type`,`target_param1`,`target_param2`,`target_param3`,`target_x`,`target_y`,`target_z`,`target_o`,`comment`) VALUES +(@ENTRY,0,0,0,11,0,100,0,0,0,0,0,11,169869,34,0,0,0,0,1,0,0,0,0,0,0,0,"Decimatus - On Respawn - Cast Transformation Sickness on Self (Need Core Handler for Spell)"), +(@ENTRY,0,1,0,0,0,100,0,9000,11000,9000,11000,11,174011,0,0,0,0,0,5,0,0,0,0,0,0,0,"Decimatus - In Combat - Cast Neutralize - Need Core Handler."), +(@ENTRY,0,2,0,0,0,100,0,27000,27000,27000,27000,11,174016,1,0,0,0,0,1,0,0,0,0,0,0,0,"Decimatus - In Combat - Cast Decimate."); + +-- spell_gen_decimatus_transformation_sickness + DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_gen_decimatus_transformation_sickness'; + INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES + (169869,'spell_gen_decimatus_transformation_sickness'); + +-- spell_gen_azgalor_rain_of_fire_hellfire_citadel + DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_gen_azgalor_rain_of_fire_hellfire_citadel'; + INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES + (189549,'spell_gen_azgalor_rain_of_fire_hellfire_citadel'); + +-- spell_gen_mark_of_kazrogal_hellfire + DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_gen_mark_of_kazrogal_hellfire'; + INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES + (189512,'spell_gen_mark_of_kazrogal_hellfire'); + +-- spell_gen_anetheron_summon_towering_infernal + DELETE FROM `spell_script_names` WHERE `ScriptName` = 'spell_gen_anetheron_summon_towering_infernal'; + INSERT INTO `spell_script_names` (`spell_id`,`ScriptName`) VALUES + (189491,'spell_gen_anetheron_summon_towering_infernal'); |