Page 4 of 4
Re: Public Database Server
PostPosted: Fri Feb 10, 2012 7:34 pm
by Ephemeral
Close nuff. :<
Re: Public Database Server
PostPosted: Sat Feb 11, 2012 6:42 am
by viper1805
- Code: Select all
UPDATE `spell` SET `Spell_ID`=`Bainshee RR5 Verst` WHERE `SpellID`=`36003`;
Run it, thank me later because there's some odd characters in the Spell_ID of that spell that cause some issues when opening it.
try it with this one, since the upper syntax causes problems if you try to run it
- Code: Select all
UPDATE spell SET Spell_ID = "Bainshee RR5 Verst" WHERE SpellID = 36003;
Thanks, both of you
-> applied to pubdb server
Re: Public Database Server
PostPosted: Sat Mar 24, 2012 7:30 pm
by Tolakram
Fix for Zones, missing realm. This is what Storm is using.
- Code: Select all
# --------------------------------------------------------
# Host: storm
# Database: livedol
# Server version: 5.1.36-community-log
# Server OS: Win32
# HeidiSQL version: 5.0.0.3272
# Date/time: 2012-03-24 15:26:39
# --------------------------------------------------------
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
# Dumping structure for table livedol.zones
CREATE TABLE IF NOT EXISTS `zones` (
`Zones_ID` text,
`ZoneID` int(11) NOT NULL,
`RegionID` smallint(5) unsigned NOT NULL,
`Name` text NOT NULL,
`IsLava` tinyint(1) NOT NULL,
`WaterLevel` int(11) NOT NULL,
`OffsetY` int(11) NOT NULL,
`OffsetX` int(11) NOT NULL,
`Width` int(11) NOT NULL,
`Height` int(11) NOT NULL,
`Experience` int(11) DEFAULT NULL,
`Realmpoints` int(11) DEFAULT NULL,
`Bountypoints` int(11) DEFAULT NULL,
`Coin` int(11) DEFAULT NULL,
`DivingFlag` tinyint(3) unsigned NOT NULL,
`Realm` tinyint(3) unsigned DEFAULT NULL,
PRIMARY KEY (`ZoneID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
# Dumping data for table livedol.zones: 473 rows
/*!40000 ALTER TABLE `zones` DISABLE KEYS */;
REPLACE INTO `zones` (`Zones_ID`, `ZoneID`, `RegionID`, `Name`, `IsLava`, `WaterLevel`, `OffsetY`, `OffsetX`, `Width`, `Height`, `Experience`, `Realmpoints`, `Bountypoints`, `Coin`, `DivingFlag`, `Realm`) VALUES ('28bcf7a6-e3bc-4b3e-9597-d706693bc1b4', 0, 1, 'Camelot Hills', 0, 0, 59, 67, 8, 8, 0, 0, 0, 0, 0, 1), ('e11cd84a-ddba-430c-9b57-6ef8d08ffc91', 1, 1, 'Salisbury Plains', 0, 0, 67, 67, 8, 8, 0, 0, 0, 0, 0, 1), ('1572db0c-80f3-4691-9d46-395416a37489', 2, 1, 'Black Mtns. South', 0, 0, 53, 59, 8, 8, 0, 0, 0, 0, 0, 1), ('6460de31-c8b5-44fc-ba44-141fc1b49046', 3, 1, 'Black Mtns. North', 0, 0, 45, 59, 8, 8, 0, 0, 0, 0, 0, 1), ('fdef1b04-d2a2-46d3-aa5c-512b17c36019', 4, 1, 'Dartmoor', 0, 0, 85, 43, 8, 8, 0, 0, 0, 0, 0, 1), ('5abe0627-71c0-420b-91f7-e77bb4cd5855', 6, 1, 'Cornwall', 0, 0, 77, 43, 8, 8, 0, 0, 0, 0, 0, 1), ('56624899-9770-4c7a-ac01-395d1cb313f9', 7, 1, 'Llyn Barfog', 0, 0, 45, 51, 8, 8, 0, 0, 0, 0, 0, 1), ('16f8379d-9fec-4c2a-8d18-f8172a28e2b4', 8, 1, 'Campacorentin Forest', 0, 0, 71, 59, 8, 8, 0, 0, 0, 0, 0, 1), ('9a170e35-1722-40f1-8af8-187b4fade703', 9, 1, 'Avalon Marsh', 0, 0, 75, 51, 8, 8, 0, 0, 0, 0, 0, 1), ('62520c80-f5ae-4f39-b80c-729f2683a53f', 10, 1, 'Lyonesse', 0, 0, 77, 35, 8, 8, 0, 0, 0, 0, 0, 1), ('15173bc8-e208-49f1-8400-d6f71d54b352', 11, 1, 'Forest Sauvage', 0, 0, 51, 69, 8, 8, 0, 0, 0, 0, 0, 1), ('02fb6d38-7ecd-432f-83f8-d89dc96ea687', 12, 1, 'Snowdonia', 0, 0, 37, 61, 8, 8, 0, 0, 0, 0, 0, 1), ('a2e140ab-c133-4ee4-94f1-d7fef8e89b33', 13, 2, 'Caerwent', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 1), ('dca144bf-8fbc-466e-93e3-cc926a375789', 14, 1, 'Pennine Mountains', 0, 0, 43, 69, 8, 8, 0, 0, 0, 0, 0, 1), ('1c34e731-47c2-40bf-bda0-30b158aa299b', 245, 245, 'Labyrinth', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f4f8a822-1bb4-469f-93ab-1deb20533d53', 15, 1, 'Hadrian\'s Wall', 0, 0, 35, 73, 8, 8, 0, 0, 0, 0, 0, 1), ('69a3452c-d7ce-43af-9cf3-d19f1a663c5d', 16, 2, 'Old Sarum', 0, 0, 72, 64, 8, 8, 0, 0, 0, 0, 0, 1), ('7438fd0d-4eaa-41ab-94b7-3a0a627d501a', 17, 2, 'Rilan', 0, 0, 56, 64, 8, 8, 0, 0, 0, 0, 0, 1), ('422ee218-cba1-4860-8724-6606bfd6e4ee', 18, 2, 'Dalton', 0, 0, 64, 56, 8, 8, 0, 0, 0, 0, 0, 1), ('3dc2018e-9c7c-4755-ac65-512c9a69081d', 19, 20, 'Stonehenge Barrows', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('fc3a81a6-dbc3-4db1-8b33-765bb906b7f8', 20, 2, 'Brisworthy', 0, 0, 56, 56, 8, 8, 0, 0, 0, 0, 0, 1), ('552c458b-7085-46d9-a479-479a125f7a84', 21, 21, 'Tomb of Mithra', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('533124ba-75c7-4a11-9528-627b740b2918', 22, 22, 'Keltoi Fogou', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('c40a0bf1-0faa-452f-872d-3b039b78df37', 23, 23, 'Catacombs of Cardova', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('941dd6b9-4a1d-43f4-bed4-58af3267d044', 24, 24, 'Tepok\'s Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('2f1ad8f9-da66-4f6d-a7a9-4b7159169d8e', 26, 10, 'City of Camelot', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('db45b9d7-a77f-43e7-85b7-16aa7fa69918', 27, 27, 'Constantine\'s Sound', 0, 0, 8, 8, 8, 8, 0, 0, 0, 0, 0, 1), ('133efe78-77f3-42d8-a59f-a3b463b7a407', 28, 27, 'Grenlock\'s Sound', 0, 0, 24, 24, 8, 8, 0, 0, 0, 0, 0, 2), ('587dc6f9-67a2-4876-b59d-16110755d505', 29, 27, 'Lamfhota\'s Sound', 0, 0, 40, 40, 8, 8, 0, 0, 0, 0, 0, 3), ('f77060e9-1f7d-4e3b-8433-9c29458605c0', 30, 30, 'Oceanus Hesperos', 0, 0, 64, 32, 8, 8, 0, 0, 0, 0, 0, NULL), ('20d9089d-f1b5-4745-ac93-43d632f951a9', 31, 30, 'Mesothalassa', 0, 0, 64, 40, 8, 8, 0, 0, 0, 0, 0, NULL), ('aa5907ac-6d7c-4815-a5d6-6988fd8441ee', 32, 30, 'Oceanus Boreal', 0, 0, 56, 40, 8, 8, 0, 0, 0, 0, 0, NULL), ('7efd5900-762b-482e-983d-17a87db50d8b', 33, 30, 'Oceanus Notos', 0, 0, 72, 40, 8, 8, 0, 0, 0, 0, 0, NULL), ('262dbd15-a117-49d0-9fd9-c523999c4aa2', 34, 30, 'Oceanus Anatole', 0, 0, 64, 48, 8, 8, 0, 0, 0, 0, 0, 0), ('cad7ed8c-ee35-4bd2-a838-8a6953bebb79', 35, 35, 'Cetus\' Pit', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('3012b0e2-0a2d-407b-8a75-adf9c93a1f47', 36, 36, 'Sobekite Eternal', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('cf161b02-21ad-4257-b07f-5536626cf390', 37, 37, 'Temple of Twilight', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('bbf100e8-86fb-4755-8870-96af62baacc8', 38, 30, 'Stygian Delta', 0, 0, 48, 36, 8, 8, 0, 0, 0, 0, 0, NULL), ('3f1c3c77-9fd7-4ac1-b4c2-1694b44db0eb', 39, 30, 'Land of Atum', 0, 0, 48, 28, 8, 8, 0, 0, 0, 0, 0, NULL), ('b10c2dc8-aec2-4695-aa60-b5df7ae305be', 40, 40, 'Halls of Ma\'ati', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('33367d2b-1a09-4f6d-927a-deb9d568ae56', 41, 30, 'Typhon\'s Reach', 1, 0, 64, 56, 8, 8, 0, 0, 0, 0, 0, NULL), ('4d56b70e-5075-4663-892e-175a5030c1a4', 42, 30, 'Ashen Isles', 1, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, NULL), ('83f1541b-3200-4c83-a449-eea053272f2d', 43, 30, 'Green Glades', 0, 0, 80, 44, 8, 8, 0, 0, 0, 0, 0, NULL), ('c5d07e61-9cc8-4d94-973c-cf476f6d658c', 44, 30, 'Arbor Glen', 0, 0, 80, 52, 8, 8, 0, 0, 0, 0, 0, NULL), ('b87c14ac-0c2f-4483-88ac-5bfcae14e77d', 45, 45, 'the Great Pyramid of Stygia', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('504b8649-9c41-429c-8179-c363f88d0289', 46, 46, 'Deep Volcanus', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('3144780c-3d9a-457d-baae-30c2d867492e', 47, 47, 'City of Aerus', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('021d0856-5211-48e5-b304-f987c4ae9ffa', 48, 48, 'Unused Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e4d296cf-53d0-41e8-935a-b6e23cf96091', 49, 49, 'Rugnog\'s Haven', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('831f62bc-871e-4dc1-b442-341d0c1a781b', 50, 50, 'Avalon City', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('7596a7b9-f6c9-433d-9f98-bd4d925adfe0', 51, 51, 'Isle of Glass', 0, 0, 60, 60, 8, 8, 0, 0, 0, 0, 0, 1), ('5350f444-76f1-464a-a908-89eeb48268f8', 52, 51, 'Avalon Isle', 0, 0, 54, 52, 8, 8, 0, 0, 0, 0, 0, 1), ('e6f43a98-74a8-4147-b167-5af7c53ba814', 53, 51, 'Dales of Devwy', 0, 0, 46, 46, 8, 8, 0, 0, 0, 0, 0, 1), ('9c5f769f-91cc-4e5d-9851-24caaed6abae', 54, 51, 'Caldey', 0, 0, 44, 38, 8, 8, 0, 0, 0, 0, 0, 1), ('7afc1a7c-6095-4514-b14b-053aa601fa14', 55, 51, 'Gwyddneau', 0, 0, 52, 36, 8, 8, 0, 0, 0, 0, 0, 1), ('f5e10459-f32d-42dd-a5fb-2946fd3ad974', 56, 51, 'Aldland', 0, 0, 58, 44, 8, 8, 0, 0, 0, 0, 0, 1), ('d9a84fc6-2148-4118-be86-652162e8cdc4', 57, 51, 'Inishail Island', 0, 0, 52, 28, 8, 8, 0, 0, 0, 0, 0, 1), ('fd1e6f5a-c1b7-445f-b634-3caef40c348b', 58, 58, 'Midgard\'s Underground Forest', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('ae90a6de-8b7a-4d85-84a9-18b657861f4d', 59, 59, 'Albion\'s Glashtin Forges', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('d90d69d5-4182-4bff-b193-b9b113a59332', 60, 60, 'Caer Sidi', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('279d2ffb-e270-4b13-a519-7095213ce097', 61, 61, 'Krondon', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('a5ad5b30-6f02-483b-8045-ecb147745737', 62, 62, 'Crystal Cave', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('8ecc2d53-c4ad-4a39-addd-a7e5c10ba63d', 63, 63, 'Roman Aqueducts', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('4acc09fd-869e-4cb0-b7a5-3f3d9603cc2b', 64, 2, 'Aylesbury', 0, 0, 72, 56, 8, 8, 0, 0, 0, 0, 0, 1), ('4f87f88b-a546-4621-b919-0c33ceda5f12', 65, 65, 'Inconnu Crypt', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('b5a1350d-8e91-44c9-99e4-6a6140187122', 66, 66, 'Albion\'s Underground Forest', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('3c03de2f-509f-43d5-9d32-e955c46477a3', 67, 67, 'The Deadlands of Annwn', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9608a006-c619-4828-8c96-cc98d7c7592f', 68, 68, 'Lower Crypt', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('a6b16871-99c5-4a60-a55a-d2a8ec8608ff', 69, 69, 'Albion\'s Darkspire', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('9c2320f2-14c5-4a01-aabe-c622e8663dc0', 70, 70, 'Ruins of Atlantis', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 1), ('342c7234-0072-43b5-869c-b2a673c2aac0', 71, 71, 'Ruinerar av Atlantis', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 2), ('7e31df6b-036f-46b7-9fba-24f71be6b1b4', 72, 72, 'Scrios de Atlantis', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 3), ('ed11be13-dfd4-4b68-bc5c-b807ec6ec5de', 73, 73, 'Oceanus Hesperos', 0, 0, 64, 32, 8, 8, 0, 0, 0, 0, 0, NULL), ('c4cec5ac-4287-402d-9dab-0c0ac870c0aa', 74, 73, 'Mesothalassa', 0, 0, 64, 40, 8, 8, 0, 0, 0, 0, 0, NULL), ('5a7f10d6-f077-4ca5-ad67-3d676e42e4b8', 75, 73, 'Oceanus Boreal', 0, 0, 56, 40, 8, 8, 0, 0, 0, 0, 0, NULL), ('cbe00cbc-7e2c-4579-8340-f71cd315e131', 76, 73, 'Oceanus Notos', 0, 0, 72, 40, 8, 8, 0, 0, 0, 0, 0, NULL), ('dec1c331-7eed-435d-8220-94c9ebe73273', 77, 73, 'Oceanus Anatole', 0, 0, 64, 48, 8, 8, 0, 0, 0, 0, 0, 2), ('275aa96a-5796-4946-9c11-b63db8895dff', 78, 78, 'Cetus\' Pit', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e96832a7-2aba-4454-a4c5-f2057df2028d', 79, 79, 'Sobekite Eternal', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e828d78d-b3fe-46b5-baa4-852724a58d89', 80, 80, 'Temple of Twilight', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('eab0933a-6d4e-4070-8f02-97aba062a1b4', 81, 73, 'Stygian Delta', 0, 0, 48, 36, 8, 8, 0, 0, 0, 0, 0, NULL), ('28ec4dbe-c1a1-4104-8d45-0d8357eb7082', 82, 73, 'Land of Atum', 0, 0, 48, 28, 8, 8, 0, 0, 0, 0, 0, NULL), ('0d61a4e6-e23e-40b6-b85e-92d2c3b6eb24', 83, 83, 'Halls of Ma\'ati', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4efed44e-16e0-488d-9b8c-dc2277fe9405', 84, 73, 'Typhon\'s Reach', 1, 0, 64, 56, 8, 8, 0, 0, 0, 0, 0, NULL), ('09c91734-7db3-4e9c-88d1-726aa9e22f61', 85, 73, 'Ashen Isles', 1, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, NULL), ('4f1f8e34-8136-460c-8d24-535ce79ae457', 86, 73, 'Green Glades', 0, 0, 80, 44, 8, 8, 0, 0, 0, 0, 0, NULL), ('fcc25f59-4493-4ef1-be23-03931a123870', 87, 73, 'Arbor Glen', 0, 0, 80, 52, 8, 8, 0, 0, 0, 0, 0, NULL), ('121a80be-1d45-440b-8e83-501fd35311f6', 88, 88, 'the Great Pyramid of Stygia', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('157f9553-1c63-4f73-9f2e-58cc8b603f2d', 89, 89, 'Deep Volcanus', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('8f9d3d8e-0a06-4aff-b415-c4edcfd94551', 90, 90, 'City of Aerus', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d5d7f6fd-265d-4bf8-9eec-de1af86b3530', 91, 91, 'Celestius', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('cb628a73-2762-47c3-8b5a-448bf8aea1db', 92, 92, 'Veil Rift', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('ff6fffbc-9978-4506-a7f1-a5e2d2cb8ae2', 93, 93, 'Shar Labyrinth', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('a9108f8e-ef05-44ae-b08b-ef69b2da4c16', 94, 94, 'The Queen\'s Labyrinth', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('32f061e1-3a35-4114-be5f-3bd44c4056e0', 95, 95, 'Hibernia\'s Frontlines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e66d4563-1cd2-4b60-a497-b689bbbcbac4', 96, 96, 'Hibernia\'s Underground Forest', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('fd1cce89-a97b-4382-927b-7ce128314acc', 97, 97, 'Hibernia\'s Deadlands', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('abbfbd21-c915-494b-a900-e91ec40ca894', 98, 98, 'Hibernia\'s Darkspire', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('73d94b3f-10cb-4781-864e-1ae725e7a2e0', 99, 99, 'Hibernia\'s Glashtin Forge', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('90510afc-045f-480e-a5a4-8c773ced8cf6', 100, 100, 'Vale of Mularn', 0, 0, 82, 92, 8, 8, 0, 0, 0, 0, 0, 2), ('6a55e4b7-08c3-4ef3-81d1-151f9c48670c', 101, 100, 'East Svealand', 0, 0, 90, 88, 8, 8, 0, 0, 0, 0, 0, 2), ('441c5613-6f6f-4e07-a98b-f549b70d8cc9', 102, 100, 'West Svealand', 0, 0, 90, 80, 8, 8, 0, 0, 0, 0, 0, 2), ('9e9276c5-bc16-4292-a0b9-ca9a31a8fb90', 103, 100, 'Gotar', 0, 0, 98, 88, 8, 8, 0, 0, 0, 0, 0, 2), ('7a87aa49-b869-44a0-8e1c-bf86075967c0', 104, 100, 'Muspelheim', 1, 0, 78, 100, 8, 8, 0, 0, 0, 0, 0, 2), ('56e68aea-8eb9-4a5f-b054-88b1d279b015', 105, 100, 'Myrkwood Forest', 0, 0, 106, 92, 8, 8, 0, 0, 0, 0, 0, 2), ('f65d6f20-c936-4788-a706-2dcb58571c98', 106, 100, 'Skona Ravine', 0, 0, 110, 84, 8, 8, 0, 0, 0, 0, 0, 2), ('95d75142-ad87-4c71-a4ef-3153be75e7bc', 107, 100, 'Vanern Swamp', 0, 0, 106, 76, 8, 8, 0, 0, 0, 0, 0, 2), ('add04ef8-e70d-4a83-9f65-5def6e6f288b', 108, 100, 'Raumarik', 0, 0, 90, 72, 8, 8, 0, 0, 0, 0, 0, 2), ('353ec488-48c1-4ea7-9489-0c93a06abb54', 109, 109, 'Albion\'s Frontlines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('86025aed-2abb-4ace-8a7d-5c2950c5060d', 111, 100, 'Uppland', 0, 0, 74, 88, 8, 8, 0, 0, 0, 0, 0, 2), ('cdfce39e-65e1-467e-8ae7-9b069cd62414', 112, 100, 'Yggdra Forest', 0, 0, 82, 80, 8, 8, 0, 0, 0, 0, 0, 2), ('271db863-a4b3-4634-ac2d-8fa3817a205c', 113, 100, 'Jamtland Mountains', 0, 0, 74, 80, 8, 8, 0, 0, 0, 0, 0, 2), ('3ef040f0-83ad-4c3f-bab6-230ca81dbe04', 114, 102, 'Erikstaad', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 2), ('2bfc8387-7e93-447e-81da-fb89acfd8a7d', 115, 100, 'Odin\'s Gate', 0, 0, 70, 72, 8, 8, 0, 0, 0, 0, 0, 2), ('150a5e42-31d9-407c-b346-3c75bb816bde', 116, 100, 'Malmohus', 0, 0, 118, 84, 8, 8, 0, 0, 0, 0, 0, 2), ('109b0392-85ab-406f-8270-173d0eabf6e9', 117, 102, 'Arothi', 0, 0, 56, 64, 8, 8, 0, 0, 0, 0, 0, 2), ('a83d924c-82f5-4245-903b-f258f16618b0', 118, 102, 'Carlingford', 0, 0, 64, 72, 8, 8, 0, 0, 0, 0, 0, 2), ('90893c16-a728-43ae-9223-3952d9c62161', 119, 102, 'Wyndham', 0, 0, 72, 64, 8, 8, 0, 0, 0, 0, 0, 2), ('c095836c-7c45-4c13-8b1d-cb81aa6b353c', 120, 101, 'Jordheim', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('de8f72d2-f346-4ee2-b006-346a72512c0c', 121, 102, 'Frisia', 0, 0, 72, 72, 8, 8, 0, 0, 0, 0, 0, 2), ('f906f122-e825-47fb-9bb9-2b84944f9650', 122, 102, 'Kaupang', 0, 0, 56, 72, 8, 8, 0, 0, 0, 0, 0, 2), ('7f80cd2d-810c-4cf8-95f7-d9f4e946213b', 123, 123, 'Aphophian', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('be71c4cb-a209-4f5b-8d2b-e384e04e9ded', 124, 124, 'Hephaestian', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('7c1ea793-0697-48c2-abf9-fa11254aace0', 125, 125, 'Spindelhalla', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('fc2562c3-f7d9-4eab-a0ba-b8340e330514', 126, 126, 'Vendo Caverns', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('67d8b62b-d8f9-42df-abd7-5e371fc7d80b', 127, 127, 'Varulvhamn', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('f9329c55-c941-4d3e-95d5-baa020d22a4b', 128, 128, 'Cursed Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('95b53986-b6a6-4245-a93d-a446b86ebd1f', 129, 129, 'Nisse\'s Lair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('09ddf2a2-e1cf-4896-9452-85d2e84c2afa', 130, 130, 'Oceanus Hesperos', 0, 0, 64, 32, 8, 8, 0, 0, 0, 0, 0, NULL), ('e97ed821-8c7c-41d4-a33c-49d195304a0e', 131, 130, 'Mesothalassa', 0, 0, 64, 40, 8, 8, 0, 0, 0, 0, 0, NULL), ('d73aa4ae-18cf-433a-bed0-76716af3ee6d', 132, 130, 'Oceanus Boreal', 0, 0, 56, 40, 8, 8, 0, 0, 0, 0, 0, NULL), ('32896012-6e33-4d29-9bd5-cea403f85ce5', 133, 130, 'Oceanus Notos', 0, 0, 72, 40, 8, 8, 0, 0, 0, 0, 0, NULL), ('afd7f091-ff2f-43e2-b085-b53e755e3699', 134, 130, 'Oceanus Anatole', 0, 0, 64, 48, 8, 8, 0, 0, 0, 0, 0, 3), ('7db3ed01-fb51-4a45-911f-fc9f824c24e9', 135, 135, 'Cetus\' Pit', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('19382760-3708-4137-9453-edc0cc822320', 136, 136, 'Sobekite Eternal', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 1, 0), ('3605697e-cdb0-4452-ac64-91420a4bdfc2', 137, 137, 'Temple of Twilight', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('328c7810-ad30-41ab-9563-12c21af54f6b', 138, 130, 'Stygian Delta', 0, 0, 48, 36, 8, 8, 0, 0, 0, 0, 0, NULL), ('1dc0522b-adc2-41bd-83e0-b38cd5eec491', 139, 130, 'Land of Atum', 0, 0, 48, 28, 8, 8, 0, 0, 0, 0, 0, NULL), ('9edf1bcb-71f4-430f-9a93-1f44b448a5f7', 140, 140, 'Halls of Ma\'ati', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4de88ee4-5e42-44a1-bca5-731bb8b0ccea', 141, 130, 'Typhon\'s Reach', 1, 0, 64, 56, 8, 8, 0, 0, 0, 0, 0, NULL), ('cda9a5f1-676b-4884-97c3-4ae334e905e4', 142, 130, 'Ashen Isles', 1, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, NULL), ('f496552e-09ea-40d6-8d6b-ce91fc0ce237', 143, 130, 'Green Glades', 0, 0, 80, 44, 8, 8, 0, 0, 0, 0, 0, NULL), ('be41b462-8d8f-4c45-989c-1aa48e98c4d6', 144, 130, 'Arbor Glen', 0, 0, 80, 52, 8, 8, 0, 0, 0, 0, 0, NULL), ('43055405-d969-46cb-85dc-29e7acf21d67', 145, 145, 'the Great Pyramid of Stygia', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('efe0515f-5cde-4916-a0fd-62bb2c987216', 146, 146, 'Deep Volcanus', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('59820b16-9324-4cbb-989f-2dc140f473ec', 147, 147, 'City of Aerus', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('15913be1-e9a7-43a0-8c41-12262130df1e', 148, 148, 'The Frontlines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1c9fcd59-2531-455a-9437-f43bf2570893', 149, 149, 'Nyttheim', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('f4febfff-012e-4eea-bc34-4e9b782ffc5d', 150, 150, 'Trollheim', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('0c67cb12-fa21-4da9-b420-5c7d7476b91b', 151, 151, 'Aegir\'s Landing', 0, 0, 38, 30, 8, 8, 0, 0, 0, 0, 0, 2), ('06b92b03-d924-42aa-bac1-c80530b4405e', 152, 151, 'Gripklosa Mountains', 0, 0, 30, 34, 8, 8, 0, 0, 0, 0, 0, 2), ('22e2c36a-bb4e-4e4b-8de6-c8176b27dc21', 153, 151, 'Delling Crater', 0, 0, 32, 42, 8, 8, 0, 0, 0, 0, 0, 2), ('5850137d-5f3a-47ff-a34f-50a046e8be73', 154, 151, 'Faraheim', 0, 0, 40, 44, 8, 8, 0, 0, 0, 0, 0, 2), ('caed758f-46c0-4e28-aa32-964b964e7b0f', 155, 151, 'Munin Sound', 0, 0, 46, 36, 8, 8, 0, 0, 0, 0, 0, 2), ('92888a58-9fb5-410c-800a-70bd2ec4880f', 156, 151, 'Iarnwood', 0, 0, 48, 48, 8, 8, 0, 0, 0, 0, 0, 2), ('1ad5990e-8221-44de-aa1e-877b75d151ce', 157, 151, 'Dummy Zone', 0, 0, 22, 34, 8, 8, 0, 0, 0, 0, 0, NULL), ('5b3d035e-29f9-4ddb-8332-c561a8f839a4', 158, 151, 'Modernagrav', 0, 0, 40, 52, 8, 8, 0, 0, 0, 0, 0, 2), ('d8762955-63c3-46e1-ba78-0f257c0ac068', 160, 160, 'Tuscaran Glacier', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('5bf9d96a-1a6e-4226-b893-7f8b90e3721f', 161, 161, 'Iarnvidiur\'s Lair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('aa35a936-29cb-457c-aee3-eb08fd612e4a', 162, 162, 'Midgard\'s Deadlands', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('defe6a71-4b47-4cea-b076-f7021fd2ee93', 163, 163, 'Agramon', 0, 0, 52, 60, 8, 8, 0, 0, 0, 0, 0, NULL), ('f9120359-9301-43a6-8070-e50fa15676b7', 164, 163, 'Irish Sea', 0, 0, 60, 60, 8, 8, 0, 0, 0, 0, 0, NULL), ('12e56d30-b13a-4ca4-a6b9-691729540c71', 165, 165, 'Cathal Valley', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 3), ('b0373269-8e28-4595-a5b3-0ed64175dbd8', 166, 163, 'Unamed Sea 2', 0, 0, 52, 68, 8, 8, 0, 0, 0, 0, 0, NULL), ('e6fa96d7-32d9-477b-ac89-8beab87ffb0c', 167, 163, 'Odin\'s Gate', 0, 0, 44, 64, 8, 8, 0, 0, 0, 0, 0, 2), ('ca4af6b9-679b-482f-bd74-de85e3f4326e', 168, 163, 'Jamtland Mountains', 0, 0, 44, 72, 8, 8, 0, 0, 0, 0, 0, 2), ('29f6b549-671b-4f48-a535-4630f4ae81dc', 169, 163, 'Yggdra Forest', 0, 0, 44, 80, 8, 8, 0, 0, 0, 0, 0, 2), ('e374d0a7-9746-4759-8581-694eb6ac6cbf', 170, 163, 'Uppland', 0, 0, 36, 72, 8, 8, 0, 0, 0, 0, 0, 2), ('e1dec773-f33b-4c00-835c-ebf56174ade7', 171, 163, 'Emain Macha', 0, 0, 60, 52, 8, 8, 0, 0, 0, 0, 0, 3), ('4f69e25d-b134-4032-958f-324b069c9cb6', 172, 163, 'Breifine', 0, 0, 68, 52, 8, 8, 0, 0, 0, 0, 0, 3), ('537f53a7-50da-4ad6-8a86-cb5d5909babd', 173, 163, 'Cruachan Gorge', 0, 0, 68, 44, 8, 8, 0, 0, 0, 0, 0, 3), ('2242e0b9-5c9a-427a-952f-ac1aaae5feb7', 174, 163, 'Mount Collory', 0, 0, 76, 52, 8, 8, 0, 0, 0, 0, 0, 3), ('290db34b-07a4-40d5-be9d-002520f93e0a', 175, 163, 'Snowdonia', 0, 0, 76, 68, 8, 8, 0, 0, 0, 0, 0, 1), ('baddff70-13d3-4c8b-9c43-a6663fc47261', 176, 163, 'Forest Sauvage', 0, 0, 68, 76, 8, 8, 0, 0, 0, 0, 0, 1), ('474bdf57-2070-4e73-9216-9ae934d76b46', 177, 163, 'Pennine Mountains', 0, 0, 68, 68, 8, 8, 0, 0, 0, 0, 0, 1), ('8ac7a29f-0a89-402b-95f8-84527988704c', 178, 163, 'Hadrian\'s Wall', 0, 0, 60, 68, 8, 8, 0, 0, 0, 0, 0, 1), ('048ca7b2-b02d-4715-bdae-b5b4fa770f4c', 180, 180, 'Fomor', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('cbf6bebd-d569-4050-8fa2-cc1de6486b90', 181, 181, 'Domnann', 0, 0, 48, 48, 8, 8, 0, 0, 0, 0, 0, 3), ('c2c19441-17f6-4055-a0d6-4fb003873f1a', 182, 181, 'Caillte Garran', 0, 0, 44, 40, 8, 8, 0, 0, 0, 0, 0, 3), ('49906bd7-6442-4879-a148-8b41c373efe0', 183, 181, 'Vale of Balor', 0, 0, 40, 32, 8, 8, 0, 0, 0, 0, 0, 3), ('53dba293-ac21-40fb-b36a-480155711ce0', 184, 181, 'Cothrom Gorge', 0, 0, 32, 34, 8, 8, 0, 0, 0, 0, 0, 3), ('578fa3a1-4369-48c7-bdee-f79bb9f22fdf', 185, 181, 'World\'s End', 0, 0, 28, 42, 8, 8, 0, 0, 0, 0, 0, 3), ('70da3f9a-0b46-4bd3-9cec-bfe396e7211c', 186, 181, 'Vigilant Rock', 0, 0, 36, 46, 8, 8, 0, 0, 0, 0, 0, 3), ('5f7050db-8c8e-4660-924f-08530edbced7', 187, 181, 'Allta Fearann', 0, 0, 20, 42, 8, 8, 0, 0, 0, 0, 0, 3), ('ce566872-5d11-4ba1-9c7c-a0453facc3eb', 188, 188, 'Midgard\'s Darkspire', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('5bc501fb-1e1a-4ae5-ac4d-063ee76ad88a', 189, 189, 'Midgard\'s Glashtin Forges', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('eb3d0487-f7be-4b86-9ffb-1ebeb6a63410', 190, 190, 'Tur Suil', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('56e6cb85-7365-4b60-9441-7ec1bc37f30f', 191, 191, 'Galladoria', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('c61660cc-6fdf-4be9-a0d0-85eaff47499a', 192, 192, 'Le Sanctuaire Du Haut Consule', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('f6636e64-c75a-4c5a-8408-5c91eb77eae6', 193, 193, 'Le Sanctuaire Du Haut Consule', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4876eac0-6cb1-4a04-86f0-76c1cabeb19d', 194, 194, 'Le Sanctuaire Du Haut Consule', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('c8c4419e-b707-4c19-add7-be6b36a070df', 195, 195, 'Midgard\'s Otherworld', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('5e17fb4b-f8e1-4735-bfda-f2bfe4be6b99', 196, 196, 'Albion\'s Otherworld', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f9c94c44-4aad-46d9-8ed7-e0a85bf5cb72', 197, 197, 'The Otherworld', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('836edf1a-c786-4c49-b5d1-257c189eea7f', 198, 198, 'Shaitan', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('5af26b34-83c3-423c-874e-2de0b526b3fa', 199, 199, 'Volurgon', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('6d2893d1-e48f-43d3-a77a-12ce7e6321f0', 200, 200, 'Lough Derg', 0, 0, 59, 39, 8, 8, 0, 0, 0, 0, 0, 3), ('4375d410-c894-438a-be83-3fe91a7bb174', 201, 200, 'Silvermine Mts.', 0, 0, 67, 39, 8, 8, 0, 0, 0, 0, 0, 3), ('54bbe451-0f89-49cc-896e-a21e60022b1f', 202, 200, 'Shannon Estuary', 0, 0, 75, 35, 8, 8, 0, 0, 0, 0, 0, 3), ('5ebcde22-e424-4d2f-87e9-3f9da48bb4dd', 203, 200, 'Cliffs of Moher', 0, 0, 51, 27, 8, 8, 0, 0, 0, 0, 0, 3), ('cead26b3-32ce-4588-ba08-e427bc4b114c', 204, 200, 'Lough Gur', 0, 0, 83, 35, 8, 8, 0, 0, 0, 0, 0, 3), ('100e2627-c95c-4d87-b299-447291490207', 205, 200, 'Bog of Cullen', 0, 0, 87, 43, 8, 8, 0, 0, 0, 0, 0, 3), ('857bd511-1b3a-4866-80e8-10cb54abc6d4', 206, 200, 'Valley of Bri Leith', 0, 0, 59, 47, 8, 8, 0, 0, 0, 0, 0, 3), ('26f2da9a-e02d-4830-b414-c68d893fe515', 207, 200, 'Connacht', 0, 0, 51, 35, 8, 8, 0, 0, 0, 0, 0, 3), ('9451417c-4dc1-4c0a-8acf-efe25aa1770f', 208, 200, 'Cursed Forest', 0, 0, 59, 55, 8, 8, 0, 0, 0, 0, 0, 3), ('9d9f5172-5182-4cda-a4d8-50041f347e66', 209, 201, 'Tir na Nog', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('8cfdf06b-111c-4b65-b79a-aa2a015687fe', 210, 200, 'Mount Collory', 0, 0, 51, 47, 8, 8, 0, 0, 0, 0, 0, 3), ('60ed9c02-e60b-4583-8c87-48cd5af02256', 211, 200, 'Cruachan Gorge', 0, 0, 43, 39, 8, 8, 0, 0, 0, 0, 0, 3), ('51c4dde1-d791-4937-b1d8-6f5f9ad5f488', 212, 200, 'Breifine', 0, 0, 43, 47, 8, 8, 0, 0, 0, 0, 0, 3), ('eb4ea6f1-7f60-4172-b90b-740cba5faee7', 213, 202, 'Meath', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 3), ('ec1a3d64-a1b4-41ad-bec3-a2d79c4e95d7', 214, 200, 'Emain Macha', 0, 0, 35, 51, 8, 8, 0, 0, 0, 0, 0, 3), ('3506333d-96a6-4fa1-88d9-2a9e2d8ef819', 215, 202, 'Dunshire', 0, 0, 64, 56, 8, 8, 0, 0, 0, 0, 0, 3), ('bf69b9d4-ef70-4bcb-bd6f-b8ad04e46265', 216, 200, 'Sheeroe Hills', 0, 0, 79, 43, 8, 8, 0, 0, 0, 0, 0, 3), ('d9c71149-2392-4018-be0c-ccb2be488e59', 217, 202, 'Torrylin', 0, 0, 72, 64, 8, 8, 0, 0, 0, 0, 0, 3), ('bbdbb49f-565a-4e73-9240-fcf9524925b4', 218, 202, 'Kilcullen', 0, 0, 64, 72, 8, 8, 0, 0, 0, 0, 0, 3), ('ed10ca00-865a-4bd4-a3b2-ead683e03f78', 219, 202, 'Saeranthal', 0, 0, 72, 56, 8, 8, 0, 0, 0, 0, 0, 3), ('7b3fb86a-b804-4caa-b39b-a6dba5fbc912', 220, 220, 'Coruscating Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('671468ca-d069-4fb9-82c6-f91d505b9bbd', 221, 221, 'Muire Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('4ab34dfa-f217-4c06-9b62-fe397924e6ec', 222, 222, 'Spraggon Den', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('f113edaa-1361-4cee-a0f2-5495a2d85cae', 223, 223, 'Koalinth Caverns', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('8b5e20a9-730d-4b9c-89df-2fa98b06bfec', 224, 224, 'Treibh Caillte', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('a67114ae-c54c-4dc6-896b-2dbefa259c02', 225, 202, 'Aberillan', 0, 0, 72, 72, 8, 8, 0, 0, 0, 0, 0, 3), ('32638a12-e87b-431a-a632-00957f916350', 226, 226, 'Midgard\'s Abandoned Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('96f69144-dca6-471f-90b9-d64b621e17d7', 227, 227, 'Albion\'s Abandoned Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('3ee0c442-d677-41cc-8cd3-dc4593a73514', 228, 228, 'Hibernia\'s Abandoned Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('d0c9b360-3cd4-4ba0-9a02-2155784a9584', 229, 229, 'Burial Grounds', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('1a9e6e6f-6bc9-4a73-83de-d57a1a1091a3', 231, 231, 'ArtOutside', 0, 0, 80, 80, 8, 8, 0, 0, 0, 0, 0, NULL), ('84ee1832-779a-46f7-89a5-d9f03a58603f', 232, 232, 'ArtInside', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('0a48c1a6-7090-47c8-8630-32a875382574', 233, 233, 'Summoner\'s Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('55bae8e3-f7aa-4d24-a371-095093c8de58', 234, 234, 'The Proving Grounds', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 1), ('9c395c5e-7bdc-4053-a30d-c2d06123f96d', 235, 235, 'The Lions Den', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 2), ('1205b12f-a866-4ce3-b989-b599c020f679', 236, 236, 'The Hills of Claret', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 3), ('dc97b360-9774-4a38-baef-7ed1b90d2b42', 237, 237, 'Killaloe', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 3), ('af9bacf1-401a-4cc3-a009-663369df6aef', 238, 238, 'Thidranki', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 2), ('529a2754-e26d-45b9-b643-00ddab099eae', 239, 239, 'Braemar', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 3), ('bc606b5d-53d9-40aa-8969-f32f36b4cef8', 240, 240, 'Wilton', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 1), ('89558da0-3907-43ed-9425-39cd7f5461ec', 241, 241, 'Molvik', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, 2), ('09660acb-3171-4cb6-ba88-afba24a7e6a6', 242, 242, 'TestBG', 0, 0, 64, 64, 8, 8, 0, 0, 0, 0, 0, NULL), ('4348dbd5-aa8b-449e-ba39-060dd229b689', 243, 243, 'Kobold Undercity', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('8ec3bd93-d2dc-4758-ab7c-4cb525f34389', 244, 244, 'Passage of Conflict', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9fe4acb5-4e71-4d2a-802b-5bb487f2baba', 249, 249, 'Darkness Falls', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f5781a92-e3bd-49da-a182-b189a00c4dc7', 254, 242, 'Leirvik', 0, 0, 32, 32, 8, 8, 0, 0, 0, 0, 0, 3), ('10f6e160-d651-4579-ac2d-796e6fc849ac', 256, 256, 'Forgotten Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('3c6aad9b-e9c6-48c8-8f18-b5dc8bfa666e', 257, 257, 'Forgotten Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('90943e2c-ce57-44c0-8b74-9cde6a7ab1b5', 258, 258, 'Forgotten Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('cd7b8edc-c393-4fd8-9dbf-13816ae089a5', 260, 2, 'Chiltern', 0, 0, 64, 48, 8, 8, 0, 0, 0, 0, 0, 1), ('d6112e2f-2f93-4c85-a1ce-173466d733af', 261, 2, 'Sherborne', 0, 0, 72, 48, 8, 8, 0, 0, 0, 0, 0, NULL), ('37aada03-93dd-49e6-9d88-1760232515e0', 262, 2, 'Stoneleigh', 0, 0, 56, 48, 8, 8, 0, 0, 0, 0, 0, NULL), ('896439db-57ed-4641-a385-1d9e2fe31f80', 266, 102, 'Holmestrand', 0, 0, 64, 80, 8, 8, 0, 0, 0, 0, 0, NULL), ('cca85731-84b6-4803-b2a8-2b699de66a3a', 267, 102, 'Nittedal', 0, 0, 72, 80, 8, 8, 0, 0, 0, 0, 0, NULL), ('7092cb22-e7a4-4ed0-8976-0a9c0db3d6f9', 268, 102, 'Stavgaard', 0, 0, 56, 80, 8, 8, 0, 0, 0, 0, 0, NULL), ('7076c2d4-4af7-439f-a7ac-038bbd19ae8d', 272, 202, 'Tullamore', 0, 0, 80, 64, 8, 8, 0, 0, 0, 0, 0, NULL), ('d0266515-1640-4ca8-83a9-0e932dee508d', 273, 202, 'Moycullen', 0, 0, 80, 56, 8, 8, 0, 0, 0, 0, 0, NULL), ('323cb5d7-c2d2-4389-a20a-1adf1dfea4df', 274, 202, 'Broughshane', 0, 0, 80, 72, 8, 8, 0, 0, 0, 0, 0, NULL), ('500692a6-7371-4954-add7-30af5160f378', 278, 278, 'Damp Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('2dfbd204-fca2-4318-85f5-ad352405c135', 279, 279, 'Damp Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('700794e9-835e-41c4-89da-16e730645498', 280, 280, 'Damp Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('64c8e208-a4ec-444a-aed8-28dd8783dee2', 281, 281, 'Forgotten Sepulchre', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('3ebff771-f6a6-4428-ba91-ef446dc28c39', 282, 282, 'Forgotten Sepulchre', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('179c53bd-b7a9-488d-bb65-8fb18519dcb7', 283, 283, 'Forgotten Sepulchre', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('93553688-3a27-4c74-be29-1d8ccde40a0c', 284, 284, 'Concealed Guardhouse', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1f9a517b-f445-4a27-a956-d1ee936a1569', 285, 285, 'Concealed Guardhouse', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('5808ecfd-0aa1-4cde-8aea-bd925c0b3429', 286, 286, 'Concealed Guardhouse', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f865fc52-e5a7-4c27-81db-797da7b0199e', 287, 287, 'The Gossamer Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('975a8440-b696-43a8-8d5a-d640934bc1c2', 288, 288, 'The Gossamer Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('cac3cb4f-8601-4dc5-b38d-3e70567969fb', 289, 289, 'The Gossamer Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('5f886481-2de4-4aa4-aada-49c7ca846da4', 290, 290, 'Underground Tunnel', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('02d1a484-5c59-4cd6-96da-750518dc6c35', 291, 291, 'Underground Tunnel', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d731ea73-b35f-4bf5-b488-9693ac05d144', 292, 292, 'Underground Tunnel', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6b81cd3a-6a5a-413f-8543-6c1bd09d9713', 293, 293, 'Burial Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6974f6b6-c4ca-4ff6-a87d-27af1487e3f8', 294, 294, 'Burial Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('37fdda4a-6f65-4720-bb9f-8fc0d92e5c82', 295, 295, 'Burial Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1d6383e4-0e46-4d2e-9afc-36aee1ac7cf4', 296, 296, 'Desecrated Grounds', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('471a84aa-4c93-4281-a77d-02d946669aa0', 297, 297, 'Desecrated Grounds', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d0fc8463-8d38-44bb-a649-a359c2abcc8c', 298, 298, 'Desecrated Grounds', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('111dc85d-3844-4f36-b08e-28daebf62117', 300, 300, 'Damp Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('59689953-fb40-4c0b-a34b-30696f927608', 301, 301, 'Damp Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('c896bc69-6e37-40ce-9e9e-ff6a5e21902c', 302, 302, 'Damp Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('65b71a2e-140c-4860-b970-38c9c6d6029a', 303, 303, 'Damp Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('ff87a2af-e42c-4750-969b-3d19df0127e2', 304, 304, 'Damp Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6d095daa-8c1c-47f4-a2c1-81a5190446bd', 305, 305, 'Forgotten Sepulchre', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4b191861-9e56-47bc-9ecc-4dcb490d23ef', 306, 306, 'Forgotten Sepulchre', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('c107f6b3-9933-4d6b-ba95-bfcf0067302c', 307, 307, 'Forgotten Sepulchre', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('3fc8c6ca-3109-45a4-abb2-96f21aedfce4', 308, 308, 'Forgotten Sepulchre', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e01e4723-d520-496b-9e89-5e60fe6695f5', 309, 309, 'Forgotten Sepulchre', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4d06e493-c5d9-4825-a6bc-95e5d99a499b', 310, 310, 'Concealed Guardhouse', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f329efe0-23ec-4ea2-9c29-14ee695a6ba1', 311, 311, 'Concealed Guardhouse', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('a22d7107-dce4-4916-83e0-2fff4d93e7d5', 312, 312, 'Concealed Guardhouse', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('5e716920-995a-407d-9417-4ee425dd7205', 313, 313, 'Concealed Guardhouse', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6854a3c8-12e5-4dbf-8246-516f535b9841', 314, 314, 'Concealed Guardhouse', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f18d6dca-ba64-4f9a-ba8a-53e4424aabb5', 315, 315, 'The Gossamer Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('90e8bffb-0f66-4bd0-a0cf-c2ac5eb5d8d5', 316, 316, 'The Gossamer Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('da332da2-e5b5-4b09-980d-5715ea7ea473', 317, 317, 'The Gossamer Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('97c47acf-cab4-4ebb-a2f2-e97ed9622e85', 318, 318, 'The Gossamer Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('348e461b-0033-4235-9f48-22a5af8d2b51', 319, 319, 'The Gossamer Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('59bcb495-0f45-4354-8a71-baa6d33b39b4', 320, 320, 'Underground Tunnel', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('391f8ffd-9606-448e-b3e4-5f0423e01946', 321, 321, 'Underground Tunnel', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('59ed8270-a2fd-4595-83e6-edeed03aa599', 322, 322, 'Underground Tunnel', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('fcbf955c-bd3b-420c-a9d9-0628ef2831a8', 323, 323, 'Underground Tunnel', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('13f7ba5c-cf7c-41e9-b569-9376e3ab1b9d', 324, 324, 'Underground Tunnel', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('06040979-3ead-4f49-988a-ca09e4bf8d3e', 325, 325, 'Hib 30 Dungeon', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('ea48383a-7be2-40c0-a826-f52c682c6c68', 326, 326, 'Alb 30 Dungeon', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('8cd9c653-f8bf-4dba-ab16-9fdb44cb13c1', 327, 327, 'Caverns of Madness', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('fc5ae51a-4d66-474c-917c-1ed10d103b5d', 328, 328, 'Mid 30 Dungeon', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1204fa9e-d72c-41f3-a5bd-9ee637eb9ec4', 329, 329, 'Jarlsberg\'s Hideout', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('01381dc8-7267-4892-a9fb-4571236d15ba', 330, 330, 'The Foothills of Albion', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('a5299416-c212-4d84-8d23-f0dc7b2dd05c', 331, 331, 'Thieves Den', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4269a152-c4d9-44af-a3d7-b729600aa312', 332, 332, 'Rebel Half Orc Lair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e3a94166-81b3-4392-80ee-771032ff9694', 333, 333, 'The Haunted Halls', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('414fb5d0-fbdd-42ed-a1f6-fa4d6f79139e', 334, 334, 'The Foothills of Midgard', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('c9f60a3c-ca93-4f0a-bee2-bd69c9c43704', 335, 335, 'The Foothills of Hibernia', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3), ('2fad2b16-83c7-48ed-b147-6986bdb0978c', 336, 336, 'Demonic Prison', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('c38f93a0-1b62-49a3-b35c-fc60aad5b1d5', 337, 337, 'Demonic Prison', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('79936845-223b-420b-9e01-c7d7d140e03c', 338, 338, 'Demonic Prison', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('0c4c8ae1-2348-4cfc-a31a-8ce3fcc3c40c', 339, 339, 'Brimstone Caverns', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('91b93b20-26ab-449b-9bda-30669ed16075', 340, 340, 'Halls of Helgardh', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1745609a-cc8b-4253-b68d-fc5568c0a515', 341, 341, 'Cave of Cruachan', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('94ed26ff-5e92-4c3f-8fd7-d585b073f964', 342, 342, 'Mid Launch 2', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f32d1943-7f1d-4afd-9f26-c44b50601bb7', 343, 343, 'Alb Launch 2', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('171e755f-28d4-4082-b679-b7356a22778f', 344, 344, 'Hib Launch 2', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('aa70d35d-984e-4ba8-ad70-4b4a661f9870', 345, 345, 'Tomte Prison', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('ab85a838-8b9c-4032-857b-8c6e9b133c34', 346, 346, 'Nisse\'s Retreat', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('c90c9731-5618-43c1-b420-0764c5001e8e', 347, 347, 'Lair of the Demon Lord', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d3a52859-e222-4ab7-97db-d38d68e09998', 348, 348, 'The Baron\'s Gaol', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1f52c5dc-f111-4f83-bc69-25d3f50dee8b', 349, 349, 'Lios\'s Eternal Rest', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('157f1292-7425-49e5-802c-97ed430268d8', 350, 350, 'Liche\'s Unrest', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6d9f6e3f-2668-40cc-bf7d-a611c9cd24d4', 351, 351, 'Nephraal\'s Gaol', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('42768c15-cb58-4f9f-b91d-452f19ebc819', 352, 352, 'Morfesa\'s Gaol', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9522fad5-167a-49c9-9469-bc25d7ad914e', 353, 353, 'Den of Bones', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1e0e71c8-9601-408f-8949-5aa86fe17342', 354, 354, 'The Lost Burrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4505e3e9-2fce-43d8-9754-69314b61b34f', 355, 355, 'Hib 45 Dungeon', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1827fb7a-c6fb-49e4-a422-160246829966', 356, 356, 'Alb 45 Dungeon', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('a7643c27-736b-4b5f-85c6-c6fadf907383', 357, 357, 'The Cursed Lair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('19e7f131-36b1-4e84-8492-0e9fcc04d073', 358, 358, 'The Burrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('aa8823b8-9fe2-48d4-a77a-ee6fe9c699fb', 359, 359, 'Mid 45 Dungeon', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('7973942a-426a-4431-92ab-2b617d712f4c', 360, 360, 'King Eirik\'s Throne Room', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9a887234-71d4-4849-9295-a280e8609c44', 361, 361, 'Arachnid\'s Labyrinth', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('de5c88ab-5f18-4869-8d52-aa3ea0db37f9', 362, 362, 'The Master\'s Lair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('cc800449-0584-45e1-90f8-4a9d5361c5c6', 363, 363, 'Anataeus\' Sanctuary', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('b5afd579-ad91-456c-beaf-2c9f48f38ae9', 364, 364, 'Keeper Iraeda\'s Sanctuary', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('fe1fef7b-6f10-489a-9bb0-15f75d9d2ff7', 365, 365, 'Bandit Lair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('7cacdc27-02ae-4680-802c-2ab5438dba28', 366, 366, 'Gnoll Lair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('ed9ef08b-cf5c-4e7f-9140-e9f0dd4eea76', 367, 367, 'Vandr\'s Bane', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('a93c3e84-5169-45e2-bedb-1a9e0a44ee3e', 368, 368, 'Past and Present', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('bcca426e-a973-4379-952f-64a8986463f4', 369, 369, 'Half-Orc Camp', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('cbf24f97-d701-4c5d-8919-fe899025167e', 370, 370, 'Brutal Realization', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('b117f899-3b59-46a7-a6e4-b7cc1dc309d6', 371, 371, 'History Repeats Itself', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9a736b27-39c4-4ac5-aa4d-cc114e4dc9d0', 372, 372, 'Hounds of Arawn', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d3d052e4-b7ef-4943-a91a-55b610698d97', 373, 373, 'Passage of Echoes', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('99ec9544-61ad-41a7-9931-49515716a16a', 374, 374, 'Unrestful Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4e2a2cf6-90e0-4a32-8fcf-c0dcff44b5d6', 375, 375, 'Lost Passages', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9d6e4793-9e04-496a-bed8-650314074de9', 376, 376, 'Goblin\'s Cookery', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('0d46f17b-dd75-4319-a6ca-7f1834906f2e', 377, 377, 'The Beastmaster\'s Den', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d43f6268-1091-48e1-862b-51e4617ed6f1', 378, 378, 'Keeper Garran\'s Sanctuary', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('8b5c2dce-115c-4a32-a711-0bb5b00dc89d', 379, 379, 'The Funerary Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('14beaf5d-e486-47b0-90c1-dcf2fe2bc047', 380, 380, 'Lair of Doom', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('15dd65f7-b1c4-4265-8cf1-6f817200bddd', 381, 381, 'The Arena', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('853508e0-52d8-4727-ae83-099902dcb439', 382, 382, 'The Funerary Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('8fc5a285-21b7-4f70-b24a-192342fed55a', 383, 383, 'The Funerary Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9c3ebd40-d58f-4056-9643-08b6b91fe6d0', 384, 384, 'The Ritual Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('86850332-0169-4189-ba6a-3e3a0ab4ce2a', 385, 385, 'The Betrayer\'s Den', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('52bf7703-db67-430c-b2df-c03f6da9b4ea', 386, 386, 'the Sundered Tombs', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('481a8da0-df58-4d4a-9ddd-a184dce21fbb', 387, 387, 'the Sundered Tombs', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('05311e40-3b34-4781-80b3-0bc9f1ff8342', 388, 388, 'the Sundered Tombs', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('01050642-2b96-48bc-b7eb-5c242c43e02a', 389, 389, 'Shafts of the Tenebrae', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e69088c8-aed7-4b9c-b8fa-84d652ee1ea2', 390, 390, 'Lair of the Exiled', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('c32edbd4-40c7-46a7-bd44-1708f5578670', 391, 391, 'La Tour des Arcanes ALB', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('8d82baa1-793f-46e4-8006-de5d7575874a', 392, 392, 'The Hall of Reawakening', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('b72016c7-ee60-4abe-acba-359b9583154a', 393, 393, 'The Hidden Crypt', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('a3943c4e-1f8d-4724-9ce0-cb68149fe496', 394, 394, 'King Constantine\'s Throne Room', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('673dbadb-84c8-4422-8e51-144f8e761632', 395, 395, 'King Lamfhotas\' Throne Room', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('450e7526-6fc2-465a-9089-dda014b6a9f5', 396, 396, 'Depths of Despair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('b126e0df-fa3f-462d-9d73-01aa35400fe6', 397, 397, 'the Realm of the Damned', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('7cff397e-1745-4504-8485-a04285f0671b', 398, 398, 'La Tour des Arcanes MID', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('fea9bd01-b738-49d6-a917-5df1389ff424', 399, 399, 'La Tour des Arcanes HIB', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('30f23402-330d-47a9-9995-45edcb57c60c', 400, 400, 'Burial Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('ea8794a8-fd2b-4c3b-bafe-476871bdc2d3', 401, 401, 'Burial Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('8cabae8c-84b6-41c8-b746-c5f4c70c46fd', 402, 402, 'Burial Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f48d0076-e7db-4c26-a34c-4a79f167e39d', 403, 403, 'Burial Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9c74d5dd-7036-4a0d-a316-006b271b96ba', 404, 404, 'Burial Tomb', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d36dc169-bf8b-4689-a85a-10a201ef92a7', 405, 405, 'Desecrated Grounds', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('791c82ca-de59-4731-942b-d2d3473c6a5d', 406, 406, 'Desecrated Grounds', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f8eebd43-4ea9-4bf0-b2ff-783f2248eb6c', 407, 407, 'Desecrated Grounds', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f7a2e79d-310e-4d40-9708-9280a983ea9d', 408, 408, 'Desecrated Grounds', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('2d9a9ca7-0309-42d6-9bb7-10711a7257c0', 409, 409, 'Desecrated Grounds', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('647b6631-1434-4e25-8bbe-7af812d42960', 410, 410, 'Forgotten Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('b149c462-c900-4492-9593-c8da8a4362e1', 411, 411, 'Forgotten Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('5c0b7b25-e17c-4904-9ca7-f5ab1121f514', 412, 412, 'Forgotten Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('cc3caec2-5d8d-44b1-b892-25e87e11c945', 413, 413, 'Forgotten Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('246b9a11-8e1d-4eea-8a51-3b4174ef9319', 414, 414, 'Forgotten Mines', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('8805edd0-4e0f-4db5-b5a1-a893b53ca5d3', 415, 415, 'The Funerary Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e5753ef2-c9df-483f-99a6-eb4b358abbf6', 416, 416, 'The Funerary Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('724695f6-4fd3-4139-a97b-e2d309f40f84', 417, 417, 'The Funerary Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('47f8f005-952c-4fcc-a583-7a78c9fa9e2f', 418, 418, 'The Funerary Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1ecf843b-05c5-464e-9edf-5e83442e508b', 419, 419, 'The Funerary Hall', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('c5c61285-8d00-4816-af7d-76fce25be21b', 420, 420, 'the Sundered Tombs', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('28ec6f66-2ef6-42b0-a640-c4659b1b7d29', 421, 421, 'the Sundered Tombs', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e8baec97-ee88-4042-a88e-1c0cd734d0b6', 422, 422, 'the Sundered Tombs', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('69f1efbe-9dd9-4e17-ba23-321aff56dde0', 423, 423, 'the Sundered Tombs', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('420d602b-0836-42dc-a35a-d0f954d58c85', 424, 424, 'the Sundered Tombs', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('065e2ed4-1865-4f74-918a-7d6cb0fbb58a', 425, 425, 'The Lost Wing', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('8dc0edfa-dbe4-4f6e-b286-f5458bbb9267', 426, 426, 'Deliah\'s Sanctuary', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e6b1bbb0-71ec-4b79-8496-a22720e26cd5', 427, 427, 'The Cursed Barrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('0cbeba00-70f4-4951-b79a-732192150387', 428, 428, 'The Cursed Barrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('195d286b-0eff-4660-b7e7-77c3927b0836', 429, 429, 'Snyblem\'s Lair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6d4451e1-d1ed-4d6f-a2aa-57c6ea1bdde4', 430, 430, 'the Plutonian Shore', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('aa95e956-8976-4a6d-9dc4-c77dc9a402d2', 431, 431, 'The Cursed Barrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6340acc7-d5e5-47ad-ab0f-5fc5119bd7e4', 432, 432, 'Dismal Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('92aed724-f49a-4dd1-8cc2-9e66da92b797', 433, 433, 'Snarg\'s Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('b98d9862-3483-40bb-94a1-9afce5bc07f8', 434, 434, 'Maze of Tribulation', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('b6277252-334c-4a5e-b402-ea66e0074dc4', 435, 435, 'The Smelting Pot', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('93c1c5e5-53d3-4c45-89f3-d3391d72437a', 436, 436, 'Forges of Flame', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('a56d4d62-f45b-487c-8e7e-c3638f5d9f6d', 437, 437, 'Hammer Hugak\'s Smithy', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('45721047-aeed-431c-86da-d3e03343ad84', 438, 438, 'the Goblin Workshop', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('35762ee8-c7c7-4daa-9523-e6f5407a5f05', 439, 439, 'Wolak\'s Crucible', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('8895f182-66ed-418a-a2e9-a7965b08d601', 440, 440, 'Marik\'s Workroom', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('42d5147d-94ba-47ae-994b-ac5eac7843fb', 441, 441, 'Dismal Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('7f1bdf2d-4890-488b-9544-e2369a26af7e', 442, 442, 'The Steward\'s Crypt', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('2574863c-dd51-47b4-acb0-632d999011a7', 443, 443, 'Serf\'s Folly', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6d866e65-b893-4fbb-a297-83761555cab8', 444, 444, 'Dismal Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('fb6bbba4-8f08-4903-86b7-ad5bd6edde35', 445, 445, 'Dark Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('a41a7048-a3c6-4fcd-a4e1-d6ff0e7aabf0', 446, 446, 'Blathnait\'s Refuge', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e9099a79-f6a9-43e8-8d2b-185c9b518067', 447, 447, 'Broken Mirrors', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4b16be79-9150-415c-b9d0-50b9c97010d0', 448, 448, 'Dark Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('41112613-0b40-4a4b-ab67-15f54595aa75', 449, 449, 'Dark Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e6293e30-8c86-4173-81ac-bdc0685285d6', 450, 450, 'The Cursed Barrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('12ebbb6e-c034-46f7-b2bb-a6e62acecf64', 451, 451, 'The Cursed Barrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('735dd911-c914-4422-9b11-2b42a4af09a4', 452, 452, 'The Cursed Barrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('058bd156-c121-40fd-bad8-d763605f9c01', 453, 453, 'The Cursed Barrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('32722b04-d632-44cc-a520-906b1b9a20f0', 454, 454, 'The Cursed Barrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6c4666f4-6036-4a46-ae54-671afb52de3c', 455, 455, 'Dismal Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f0db8bd2-9bbf-4158-94a2-73cb753efe1f', 456, 456, 'Dismal Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('de6dacfb-3457-4257-be11-bd00a24370fb', 457, 457, 'Dismal Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('03689a2f-bb88-4e3d-90e7-25352d3a553c', 458, 458, 'Dismal Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('c8b4af8e-27c1-46c1-b718-260a75fef4cf', 459, 459, 'Dismal Grotto', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('5ec3c724-a54b-4f49-b84f-d3d5692e6dc0', 460, 460, 'The Accursed Caves', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d6cf7d54-afa1-4374-ba55-9ab97016ac53', 461, 461, 'The Accursed Caves', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('3b22b08f-e485-424d-a743-4532332caee2', 462, 462, 'The Accursed Caves', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d2c10037-fc90-453f-b34d-bdd81d9e7a3e', 463, 463, 'The Accursed Caves', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f92a9e0d-9264-4762-a0b7-ceed8a6c4f8a', 464, 464, 'The Accursed Caves', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f3bcbfe1-84c7-48a9-af09-93584d014ee6', 465, 465, 'Dark Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('ef304e93-c9c9-4cc7-bab6-bf34b7e8507b', 466, 466, 'Dark Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('92dc91a7-66fb-495e-ad78-50052805ed8c', 467, 467, 'Dark Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('52ea652d-271d-4ace-9d4e-fb35e4d52d9a', 468, 468, 'Dark Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9255d2d2-8d78-4434-ac8b-680927f8f1b8', 469, 469, 'Dark Cavern', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('021da8a8-c553-4fe3-a900-44bbc8187193', 470, 470, 'Half Orc Command Post', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('f77322b3-4aab-4303-846f-8217a93bd204', 471, 471, 'Unused Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('83804703-6917-46f8-a291-144472583b32', 472, 472, 'Unused Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('bb20d6d4-34df-4393-8780-356327fe73ca', 473, 473, 'Unused Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('7e3ac522-d776-418e-b42c-eb548e4edb31', 474, 474, 'Unused Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('4610d7e3-c623-4b1e-bc4e-47f700acb2c0', 475, 475, 'Rise of the Spraggons', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d17774e7-6d6e-4148-afc7-e549ca565147', 476, 476, 'The Warrens', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('de42fba5-c2f5-4920-9369-bf5d31517bcf', 477, 477, 'The Accursed Caves', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('6b969542-626a-493f-820e-dd354f396232', 478, 478, 'The Accursed Caves', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('59d2e6e9-6404-4822-abc5-4d6b9d3c265f', 479, 479, 'The Ancient\'s Retreat', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('23ee00a2-f401-4fab-9b49-82ab1b03c0c0', 480, 480, 'The Shaman\'s Inner Sanctum', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('11b884d7-3ac9-434d-8d93-8792d8e21922', 481, 481, 'The Accursed Caves', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('884072f9-40fc-47db-a4ec-7265698d7801', 482, 482, 'Unused Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('990bb2ea-b512-4eca-b1a5-d40d2982c1f9', 483, 483, 'The Brawler\'s Den', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('10503472-91a3-4e46-8398-3aaaed4f6f58', 484, 484, 'Felena\'s Sorrow', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('496cec00-938c-4c54-82ef-665c075dc361', 485, 485, 'Unused Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('1baf348e-aadc-4d63-805b-34d49620e196', 486, 486, 'Unused Mine', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9413e3e2-edb6-457b-b4ea-8753386be4d2', 487, 487, 'The Pit of Despair', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('edfc1d65-6887-4078-99fc-978b53ba72f4', 488, 488, 'The Forgotten Vein', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('7c317a3a-c021-45f3-b56d-707dd1b5a147', 489, 489, 'Demons breach', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('a3d4277a-e519-46c3-9e43-631280cc2574', 491, 491, 'Maze of Madness', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('7b016af6-9f6c-43dd-a399-81f926568af0', 492, 492, 'the Shattered Lands', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('9f15bf2e-0759-4612-a36f-7f7276fa999d', 494, 494, 'the Gnolls Den', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('d3b3d2d9-9ccf-4c59-be23-fd8f854c0c5f', 495, 495, 'Inner Sanctum', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('856343a4-f076-4ce6-a17b-d2dea771305e', 496, 496, 'the Deep', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, NULL), ('e550eba9-51f1-488e-aea5-237812647751', 497, 497, 'Mid Launch', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 2), ('4b4bc9cd-f2fc-447b-b566-d0cb148bf010', 498, 498, 'Alb Launch', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 1), ('d4ff5de2-a50b-403b-8024-b00a40e73f76', 499, 499, 'Hib Launch', 0, 0, 1, 1, 8, 8, 0, 0, 0, 0, 0, 3);
/*!40000 ALTER TABLE `zones` ENABLE KEYS */;
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
Re: Public Database Server
PostPosted: Sat Mar 24, 2012 7:51 pm
by Etaew
You could be clever and tie in automatic updates and downloads via a script xD
This could push the popularity of public database contributions.
Suggestion:
- Database version is held on a web server
- DOL Server stores a local database version number
- DOL Server runs a script to check local database version number and the remote database version number,
- Database web server sends the DOL Server the file
AUTO UPDATED IS BAD MMKAY
- DOL Server stores the file in some accessible folder
- DOL Server script notices the file in the folder and notifies admins when they are online / loading the server to apply the update.
Various security and implementation issues ensue.
Re: Public Database Server
PostPosted: Sun Mar 25, 2012 9:06 am
by viper1805
Fix for Zones, missing realm. This is what Storm is using.
thanks mark, applied to the server