PDA

View Full Version : New 'Zone" field for databases


wize_one
01-29-2004, 02:50 PM
here it is after all day working.. all safe points are set, no more zoneing under worlds or zoneing into a bad loc via the #zone command.

GoD zones not included in this.


#
# Table structure for table zone
#

DROP TABLE IF EXISTS `zone`;

CREATE TABLE `zone` (
`short_name` varchar(16) NOT NULL default '',
`file_name` varchar(16) default NULL,
`long_name` text,
`safe_x` float NOT NULL default '0',
`safe_y` float NOT NULL default '0',
`safe_z` float NOT NULL default '0',
`minium_level` tinyint(3) unsigned NOT NULL default '0',
`minium_status` tinyint(3) unsigned NOT NULL default '0',
`zoneidnumber` int(4) NOT NULL default '0',
`timezone` int(5) NOT NULL default '0',
`maxclients` int(5) NOT NULL default '0',
`weather` smallint(6) NOT NULL default '1',
PRIMARY KEY (`short_name`),
UNIQUE KEY `zoneidnumber` (`zoneidnumber`)
) TYPE=MyISAM;


#
# Dumping data for table zone
#
-- Begin Old World
INSERT INTO `zone` VALUES ('qeynos',NULL,'South Qeynos',186.46,14.29,3.75,0,0,1,0,0,1);
INSERT INTO `zone` VALUES ('qeynos2',NULL,'North Qeynos',114,678,4,0,0,2,0,0,1);
INSERT INTO `zone` VALUES ('qrg',NULL,'Surefall Glade',152,-105,4,0,0,3,0,0,1);
INSERT INTO `zone` VALUES ('qeytoqrg',NULL,'Qeynos Hills',-1330,1301,19,0,0,4,0,0,1);
INSERT INTO `zone` VALUES ('highpass',NULL,'Highpass Hold',-104,-14,4,0,0,5,0,0,1);
INSERT INTO `zone` VALUES ('highkeep',NULL,'High Keep',88,-16,4,0,0,6,0,0,1);
INSERT INTO `zone` VALUES ('freportn',NULL,'North Freeport',211,-296,4,0,0,8,0,0,1);
INSERT INTO `zone` VALUES ('freportw',NULL,'West Freeport',181,335,-24,0,0,9,0,0,1);
INSERT INTO `zone` VALUES ('freporte',NULL,'East Freeport',-670.9,-622.68,-52.22,0,0,10,0,0,1);
INSERT INTO `zone` VALUES ('runnyeye',NULL,'Runnyeye Citadel',-21.85,-108.88,3.75,0,0,11,0,0,1);
INSERT INTO `zone` VALUES ('qey2hh1',NULL,'Western Plains of Karana',-638,12,-4,0,0,12,0,0,1);
INSERT INTO `zone` VALUES ('northkarana',NULL,'Northern Plains of Karana',-382,-284,-7,0,0,13,0,0,1);
INSERT INTO `zone` VALUES ('southkarana',NULL,'Southern Plains of Karana',1293.66,2346.69,-5.77,0,0,14,0,0,1);
INSERT INTO `zone` VALUES ('eastkarana',NULL,'Eastern Plains of Karana',-382.05,-284.08,-7.5,0,0,15,0,0,1);
INSERT INTO `zone` VALUES ('beholder',NULL,'Gorge of King Xorbb',-21.44,-512.23,45.13,0,0,16,0,0,1);
INSERT INTO `zone` VALUES ('blackburrow',NULL,'Blackburrow',38.92,-158.97,3.75,0,0,17,0,0,1);
INSERT INTO `zone` VALUES ('paw',NULL,'Lair of the Splitpaw',63,-122,4,0,0,18,0,0,4);
INSERT INTO `zone` VALUES ('rivervale',NULL,'Rivervale',45.3,1.6,3.8,0,0,19, 0,0,1);
INSERT INTO `zone` VALUES ('kithicor',NULL,'Kithicor Woods',3828,1889,459,0,0,20,0,0,1);
INSERT INTO `zone` VALUES ('commons',NULL,'West Commonlands',-1334.24,209.57,-51.47,0,0,21,0,0,1);
INSERT INTO `zone` VALUES ('ecommons',NULL,'East Commonlands',4947.05,7.86,-70.33,0,0,22,0,0,1);
INSERT INTO `zone` VALUES ('erudnint',NULL,'Erudin Palace',642.87,799.92,4.75,0,0,23,0,0,1);
INSERT INTO `zone` VALUES ('erudnext',NULL,'Erudin',-309.75,109.64,23.75,0,0,24,0,0,1);
INSERT INTO `zone` VALUES ('nektulos',NULL,'Nektulos Forest',-258.77,-1198.27,-5.67,0,0,25,0,0,1);
INSERT INTO `zone` VALUES ('cshome',NULL,'Sunset Home',100,0,-5,0,0,26,0,0,1);
INSERT INTO `zone` VALUES ('lavastorm',NULL,'Lavastorm Mountains',154.13,-1833.08,-15.75,0,0,27,0,0,1);
INSERT INTO `zone` VALUES ('halas',NULL,'Halas',0,0,3.75,0,0,29,0,0,1);
INSERT INTO `zone` VALUES ('everfrost',NULL,'Everfrost',682.74,3139.01,-60.16,0,0,30,0,0,1);
INSERT INTO `zone` VALUES ('soldunga',NULL,'Solusek\'s Eye',-485.77,-476.04,73.72,0,0,31,0,0,1);
INSERT INTO `zone` VALUES ('soldungb',NULL,'Nagafen\'s Lair',-262.7,-423.99,-108.22,0,0,32,0,0,1);
INSERT INTO `zone` VALUES ('misty',NULL,'Misty Thicket',0,0,2.43,0,0,33,0,0,1);
INSERT INTO `zone` VALUES ('nro',NULL,'Northern Desert of Ro',299.12,3537.9,-24.5,0,0,34,0,0,1);
INSERT INTO `zone` VALUES ('sro',NULL,'Southern Desert of Ro',286,1265,79,0,0,35,0,0,1);
INSERT INTO `zone` VALUES ('befallen',NULL,'Befallen',35.22,-75.27,2.19,0,0,36,0,0,1);
INSERT INTO `zone` VALUES ('oasis',NULL,'Oasis of Marr',903.98,490.03,6.4,0,0,37,0,0,1);
INSERT INTO `zone` VALUES ('tox',NULL,'Toxxulia Forest',203,2295,-45,0,0,38,0,0,1);
INSERT INTO `zone` VALUES ('hole',NULL,'The Hole',-1049.98,640.04,-77.22,0,0,39,0,0,1);
INSERT INTO `zone` VALUES ('neriaka',NULL,'Neriak Foreign Quarter',156.92,-2.94,31.75,0,0,40,0,0,1);
INSERT INTO `zone` VALUES ('neriakb',NULL,'Neriak Commons',-499.91,2.97,-10.25,0,0,41,0,0,1);
INSERT INTO `zone` VALUES ('neriakc',NULL,'Neriak Third Gate',-968.96,891.92,-52.22,0,0,42,0,0,1);
-- these 2 zones are not valid
INSERT INTO `zone` VALUES ('neriakd',NULL,'Neriak Neriak Palace',0,0,0,0,0,43,0,0,1);
INSERT INTO `zone` VALUES ('nektropos',NULL,'Nektropos',0,0,0,0,0,28,0,0,1);
--
INSERT INTO `zone` VALUES ('najena',NULL,'Najena',858,-76,4,0,0,44,0,0,1);
INSERT INTO `zone` VALUES ('qcat',NULL,'Qeynos Aqueduct System',-315,214,-38,0,0,45,0,0,4);
INSERT INTO `zone` VALUES ('innothule',NULL,'Innothule Swamp',-588,-2192,-25,0,0,46,0,0,1);
INSERT INTO `zone` VALUES ('feerrott',NULL,'The Feerrott',905,1050.96,25.76,0,0,47,0,0,1);
INSERT INTO `zone` VALUES ('cazicthule',NULL,'Lost Temple of CazicThule',-80,80,5.5,0,0,48,0,0,1);
INSERT INTO `zone` VALUES ('oggok',NULL,'Oggok',-99,-345,4,0,0,49,0,0,1);
INSERT INTO `zone` VALUES ('rathemtn',NULL,'Rathe Mountains',1831,3825,29.03,0,0,50,0,0,1);
INSERT INTO `zone` VALUES ('lakerathe',NULL,'Lake Rathetear',1213,4183,4,0,0,51,0,0,1);
INSERT INTO `zone` VALUES ('gukta',NULL,'Gukta',0,-100,4,0,0,52,0,0,1);
INSERT INTO `zone` VALUES ('gfaydark',NULL,'Greater Faydark',10,-20,0,0,0,54,0,0,1);
INSERT INTO `zone` VALUES ('akanon',NULL,'Ak\'Anon',-35,47,4,0,0,55,0,0,1);
INSERT INTO `zone` VALUES ('steamfont',NULL,'Steamfont Mountains',-272.86,159.86,-21.4,0,0,56,0,0,1);
INSERT INTO `zone` VALUES ('lfaydark',NULL,'Lesser Faydark',-1769.93,-108.08,-1.11,0,0,57,0,0,1);
INSERT INTO `zone` VALUES ('crushbone',NULL,'Crushbone',158,-644,4,0,0,58,0,0,1);
INSERT INTO `zone` VALUES ('mistmoore',NULL,'Castle Mistmoore',123,-295,-177,0,0,59,0,0,1);
INSERT INTO `zone` VALUES ('kaladima',NULL,'South Kaladim',-2,-18,3.75,0,0,60,0,0,1);
INSERT INTO `zone` VALUES ('felwithea',NULL,'Northern Felwithe',94,-25,3.75,0,0,61,0,0,1);
INSERT INTO `zone` VALUES ('felwitheb',NULL,'Southern Felwithe',-790,320,-10.25,0,0,62,0,0,1);
INSERT INTO `zone` VALUES ('unrest',NULL,'Estate of Unrest',52,-38,3.75,0,0,63,0,0,1);
INSERT INTO `zone` VALUES ('kedge',NULL,'Kedge Keep',99.96,14.02,31.75,0,0,64,0,0,1);
INSERT INTO `zone` VALUES ('guktop',NULL,'Guk',7,-36,4,0,0,65,0,0,1);
INSERT INTO `zone` VALUES ('gukbottom',NULL,'Ruins of Old Guk',-217,1197,-81.78,0,0,66,0,0,1);
INSERT INTO `zone` VALUES ('kaladimb',NULL,'North Kaladim',-267,414,3.75,0,0,67,0,0,1);
INSERT INTO `zone` VALUES ('butcher',NULL,'Butcherblock Mountains',-700,2550,2.9,0,0,68,0,0,1);
INSERT INTO `zone` VALUES ('oot',NULL,'Ocean of Tears',-9200,390,6,0,0,69,0,0,1);
INSERT INTO `zone` VALUES ('cauldron',NULL,'Dagnor\'s Cauldron',320,2815,473,0,0,70,0,0,1);
INSERT INTO `zone` VALUES ('airplane',NULL,'Plane of Air',-872.42,-951.23,1087.94,46,0,71,0,0,1);
INSERT INTO `zone` VALUES ('fearplane',NULL,'Plane of Fear',1282.09,-1139.03,1.67,46,0,72,0,0,1);
INSERT INTO `zone` VALUES ('permafrost',NULL,'Permafrost Caverns',0,0,3.75,0,0,73,0,0,1);
INSERT INTO `zone` VALUES ('kerraridge',NULL,'Kerra Isle',-859.97,474.96,23.75,0,0,74,0,0,1);
INSERT INTO `zone` VALUES ('paineel',NULL,'Paineel',200,800,3.39,0,0,75,0,0, 1);
INSERT INTO `zone` VALUES ('hateplane',NULL,'Plane of Hate',-353.08,-374.8,3.75,46,0,76,0,0,1);
INSERT INTO `zone` VALUES ('arena',NULL,'The Arena',460.9,-41.4,24.6,0,0,77,0,0,1);
INSERT INTO `zone` VALUES ('arena2',NULL,'The Arena Two',460.9,-41.4,24.6,0,0,180,0,0,1);
--this zone not valid
INSERT INTO `zone` VALUES ('aviak',NULL,'Aviak Village',0,0,0,0,0,53,0,0,1);
--

-- End Old World

-- Begin Kunark
INSERT INTO `zone` VALUES ('fieldofbone',NULL,'Field of Bone',1617,-1684,-54.78,0,0,78,0,0,1);
INSERT INTO `zone` VALUES ('warslikswood',NULL,'Warslilks Woods',-467.95,-1428.95,197.31,0,0,79,0,0,1);
INSERT INTO `zone` VALUES ('soltemple',NULL,'Temple of Solusek Ro',36,262,2.75,0,0,80,0,0,1);
INSERT INTO `zone` VALUES ('droga',NULL,'Temple of Droga',294.11,1371.43,3.75,0,0,81,0,0,4);
INSERT INTO `zone` VALUES ('cabwest',NULL,'Cabilis West',790,165,3.75,0,0,82,0,0,1);
INSERT INTO `zone` VALUES ('swampofnohope',NULL,'Swamp Of No Hope',2945,2761,4.27,0,0,83,0,0,1);
INSERT INTO `zone` VALUES ('firiona',NULL,'Firiona Vie',1439.96,-2392.06,-2.65,0,0,84,0,0,1);
INSERT INTO `zone` VALUES ('lakeofillomen',NULL,'Lake of Ill Omen',-5383.07,5747.14,68.27,0,0,85,0,0,1);
INSERT INTO `zone` VALUES ('dreadlands',NULL,'Dreadlands',9565.05,2806.04,10 45.2,0,0,86,0,0,1);
INSERT INTO `zone` VALUES ('burningwood',NULL,'The Burning Wood',-820,-4942,200.31,0,0,87,0,0,1);
INSERT INTO `zone` VALUES ('kaesora',NULL,'Kaesora',40,370,99.72,0,0,88,0,0, 1);
INSERT INTO `zone` VALUES ('sebilis',NULL,'Old Sebilis',0,235,40,0,0,89,0,0,1);
INSERT INTO `zone` VALUES ('citymist',NULL,'The City of Mist',-734,28,3.75,0,0,90,0,0,1);
INSERT INTO `zone` VALUES ('skyfire',NULL,'Skyfire Mountains',-3931.32,-1139.25,39.76,0,0,91,0,0,1);
INSERT INTO `zone` VALUES ('frontiermtns',NULL,'Frontier Mountains',-4262,-633,113.24,0,0,92,0,0,1);
INSERT INTO `zone` VALUES ('overthere',NULL,'The Overthere',-4263,-241,235,0,0,93,0,0,1);
INSERT INTO `zone` VALUES ('emeraldjungle',NULL,'The Emerald Jungle',4648.06,-1222.97,0,0,0,94,0,0,1);
INSERT INTO `zone` VALUES ('trakanon',NULL,'Trakanon\'s Teeth',1485.86,3868.29,-340.59,0,0,95,0,0,1);
INSERT INTO `zone` VALUES ('timorous',NULL,'Timorous Deep',2194,-5392,4,0,0,96,0,0,1);
INSERT INTO `zone` VALUES ('kurn',NULL,'Kurn\'s Tower',77.72,-277.64,3.75,0,0,97,0,0,1);
INSERT INTO `zone` VALUES ('erudsxing',NULL,'Erud\'s Crossing',795,-1766.9,12.36,0,0,98,0,0,1);
-- this zone is not valid
INSERT INTO `zone` VALUES ('erudsxing2',NULL,'Marauder\'s Mire',0,0,0,0,0,130,0,0,1);
--
INSERT INTO `zone` VALUES ('stonebrunt',NULL,'Stonebrunt Mountains',-1643.01,-3427.84,-6.57,0,0,100,0,0,1);
INSERT INTO `zone` VALUES ('warrens',NULL,'Warrens',-930,748,-37.22,0,0,101,0,0,1);
INSERT INTO `zone` VALUES ('karnor',NULL,'Karnor\'s Castle',0,0,4,0,0,102,0,0,1);
INSERT INTO `zone` VALUES ('chardok',NULL,'Chardok',850,115,104,0,0,103,0,0, 1);
INSERT INTO `zone` VALUES ('dalnir',NULL,'Dalnir',90,8,3.75,0,0,104,0,0,1);
INSERT INTO `zone` VALUES ('charasis',NULL,'Howling stones',0,0,-4.25,0,0,105,0,0,1);
INSERT INTO `zone` VALUES ('cabeast',NULL,'Cabilis East',-416,1343,4,0,0,106,0,0,1);
INSERT INTO `zone` VALUES ('nurga',NULL,'Mines of Nurga',150,-1062,-107,0,0,107,0,0,1);
INSERT INTO `zone` VALUES ('veeshan',NULL,'Veeshan\'s Peak',1682,41,28,0,0,108,0,0,1);
INSERT INTO `zone` VALUES ('veksar',NULL,'City of veksar',-1,-488.68,-27.25,0,0,109,0,0,1);
-- End Kunark

-- Begin Velious
INSERT INTO `zone` VALUES ('iceclad',NULL,'Iceclad Ocean',342,5322,-16,0,0,110,0,0,1);
INSERT INTO `zone` VALUES ('frozenshadow',NULL,'Tower of Frozen Shadow',200,120,2.25,0,0,111,0,0,4);
INSERT INTO `zone` VALUES ('velketor',NULL,'Velketor\'s Labrynth',-65.04,580.81,-152.19,0,0,112,0,0,1);
INSERT INTO `zone` VALUES ('kael',NULL,'Kael Drakael',-632.93,-46.84,123.69,0,0,113,0,0,1);
INSERT INTO `zone` VALUES ('skyshrine',NULL,'Skyshrine',-729.52,-202.09,3.75,0,0,114,0,0,1);
INSERT INTO `zone` VALUES ('thurgadina',NULL,'City of Thurgadin\r\n',0,-1222,-1.25,0,0,115,0,0,1);
INSERT INTO `zone` VALUES ('eastwastes',NULL,'Eastern Wastelands',-4296.12,-5048.85,146.69,0,0,116,0,0,1);
INSERT INTO `zone` VALUES ('cobaltscar',NULL,'Cobalt Scar',894.97,-937.62,318.63,0,0,117,0,0,1);
INSERT INTO `zone` VALUES ('greatdivide',NULL,'Great Divide',-965.13,-7720.07,-554.75,0,0,118,0,0,1);
INSERT INTO `zone` VALUES ('wakening',NULL,'The Wakening Lands',-5000,-673,-195,0,0,119,0,0,1);
INSERT INTO `zone` VALUES ('westwastes',NULL,'Western Wastelands',-3499.16,-4099.14,-15.06,0,0,120,0,0,1);
INSERT INTO `zone` VALUES ('crystal',NULL,'Crystal Caverns',302.98,486.91,-74.22,0,0,121,0,0,1);
INSERT INTO `zone` VALUES ('necropolis',NULL,'Dragon Necropolis',1959.93,-28.64,3.75,0,0,123,0,0,1);
INSERT INTO `zone` VALUES ('templeveeshan',NULL,'Temple of Veeshan',-500,-2086,-36.22,46,0,124,0,0,4);
INSERT INTO `zone` VALUES ('sirens',NULL,'Sirens Grotto',-83.23,194.92,3.75,0,0,125,0,0,1);
INSERT INTO `zone` VALUES ('mischiefplane',NULL,'Plane of Mischief',-395,-1410,115,46,0,126,0,0,1);
INSERT INTO `zone` VALUES ('growthplane',NULL,'Plane of Growth',3043,-2487,-22,46,0,127,0,0,1);
INSERT INTO `zone` VALUES ('sleeper',NULL,'Sleepers Tomb',0,0,3.75,0,0,128,0,0,1);
INSERT INTO `zone` VALUES ('thurgadinb',NULL,'Icewell Keep\r\n',0,250,2.75,0,0,129,0,0,1);
-- End Velious

-- Begin Luclin
INSERT INTO `zone` VALUES ('shadowhaven',NULL,'Shadow Haven',190,-982,-28,0,0,150,0,0,1);
INSERT INTO `zone` VALUES ('bazaar',NULL,'The Bazaar',-172,-821,3.75,0,0,151,0,0,1);
INSERT INTO `zone` VALUES ('nexus',NULL,'The Nexus',0,0,-30,0,0,152,0,0,1);
INSERT INTO `zone` VALUES ('echo',NULL,'Echo Caverns',-800,840,-28,0,0,153,0,0,4);
INSERT INTO `zone` VALUES ('acrylia',NULL,'Acrylia Caverns',-663.85,10.62,3.75,0,0,154,0,0,1);
INSERT INTO `zone` VALUES ('sharvahl',NULL,'Shar Vahl',85,-1135,-188,0,0,155,0,0,1);
INSERT INTO `zone` VALUES ('paludal',NULL,'Paludal Caverns',-240.87,-3720.85,195.75,0,0,156,0,0,4);
INSERT INTO `zone` VALUES ('fungusgrove',NULL,'Fungus Grove',-1004.87,-2140,-305,0,0,157,0,0,1);
INSERT INTO `zone` VALUES ('vexthal',NULL,'Vex Thal',-1179.78,350.83,-39.75,0,0,158,0,0,1);
INSERT INTO `zone` VALUES ('sseru',NULL,'Sanctus Seru',-232,1165,59.75,0,0,159,0,0,1);
INSERT INTO `zone` VALUES ('katta',NULL,'Katta Castellum',-545,645,2.75,0,0,160,0,0,1);
INSERT INTO `zone` VALUES ('netherbian',NULL,'Netherbian Lair',14,1787,-62,0,0,161,0,0,1);
INSERT INTO `zone` VALUES ('ssratemple',NULL,'Ssraeshza Temple',0,0,3.75,0,0,162,0,0,4);
INSERT INTO `zone` VALUES ('griegsend',NULL,'Grieg\'s End',3500,0,-4.25,0,0,163,0,0,1);
INSERT INTO `zone` VALUES ('thedeep',NULL,'The Deepshade',-667.34,-382.26,-60.25,0,0,164,0,0,1);
INSERT INTO `zone` VALUES ('shadeweaver',NULL,'Shadeweavers Thicket',-3570,-2122,-94.41,0,0,165,0,0,1);
INSERT INTO `zone` VALUES ('hollowshade',NULL,'Hollowshade Moor',2420.12,1240.88,43.25,0,0,166,0,0,1);
INSERT INTO `zone` VALUES ('grimling',NULL,'Grimling Forest',1020,-950,18.65,0,0,167,0,0,1);
INSERT INTO `zone` VALUES ('mseru',NULL,'Marus Seru',0,0,-20.37,0,0,168,0,0,1);
INSERT INTO `zone` VALUES ('letalis',NULL,'Mons Letalis',-623,-1249,-29.12,0,0,169,0,0,1);
INSERT INTO `zone` VALUES ('twilight',NULL,'The Twilight Sea',-1858.11,-419.87,-15.22,0,0,170,0,0,1);
INSERT INTO `zone` VALUES ('thegrey',NULL,'The Grey',340,-2000,-30.38,0,0,171,0,0,1);
INSERT INTO `zone` VALUES ('tenebrous',NULL,'The Tenebrous Mountains',1810,55,-36,0,0,172,0,0,1);
INSERT INTO `zone` VALUES ('maiden',NULL,'The Maiden\'s Eye',1485,960,-152.72,0,0,173,0,0,1);
INSERT INTO `zone` VALUES ('dawnshroud',NULL,'Dawnshroud Peaks',-175,2086,87,0,0,174,0,0,1);
INSERT INTO `zone` VALUES ('scarlet',NULL,'The Scarlet Desert',-1678,-1054,-98.75,0,0,175,0,0,1);
INSERT INTO `zone` VALUES ('umbral',NULL,'The Umbral Plains',1901,-473,24,0,0,176,0,0,1);
INSERT INTO `zone` VALUES ('akheva',NULL,'Akheva Ruins',60,-1394.94,22.75,0,0,179,0,0,1);
-- End Luclin

-- Custom Zones?
INSERT INTO `zone` VALUES ('tutorial',NULL,'EverQuest Tutorial',0,0,0,0,100,183,0,0,1);
INSERT INTO `zone` VALUES ('load',NULL,'Loading Zone',-316,5,8.2,0,100,184,0,0,1);
INSERT INTO `zone` VALUES ('load2',NULL,'New Loading Zone',-260,-4,-724,0,100,185,0,0,1);
--

-- Begin PoP
INSERT INTO `zone` VALUES ('codecay',NULL,'Ruins of Ixanvom',-202,-62,-94.25,0,0,200,0,0,1);
INSERT INTO `zone` VALUES ('pojustice',NULL,'Plane of Justice',0,0,3.75,0,0,201,0,0,1);
INSERT INTO `zone` VALUES ('poknowledge',NULL,'Plane of Knowledge',-58,-221,-156,0,0,202,0,0,1);
INSERT INTO `zone` VALUES ('potranquility',NULL,'Plane of Tranquility',-1454,770,-876.16,46,0,203,0,0,4);
INSERT INTO `zone` VALUES ('ponightmare',NULL,'Plane of Nightmare',1563,314,213,0,0,204,0,0,1);
INSERT INTO `zone` VALUES ('podisease',NULL,'Plane of Disease',-1784,-1244,-58,0,0,205,0,0,1);
INSERT INTO `zone` VALUES ('poinnovation',NULL,'Plane of Innovation',264,541,-50,0,0,206,0,0,1);
INSERT INTO `zone` VALUES ('potorment',NULL,'Plane of Torment',-542,1610,-342,0,0,207,0,0,1);
INSERT INTO `zone` VALUES ('povalor',NULL,'Plane of Valor',150,-1720,65,0,0,208,0,0,1);
INSERT INTO `zone` VALUES ('bothunder',NULL,'Torden, The Bastion of Thunder',180,210,-1626,0,0,209,0,0,1);
INSERT INTO `zone` VALUES ('postorms',NULL,'Plane of Storms',-1795,-2016,-460,0,0,210,0,0,1);
INSERT INTO `zone` VALUES ('hohonora',NULL,'Halls of Honor',-2748,0,3.75,0,0,211,0,0,1);
INSERT INTO `zone` VALUES ('solrotower',NULL,'Solusek Ro\'s Tower',223,672,-380,0,0,212,0,0,1);
INSERT INTO `zone` VALUES ('powar',NULL,'Plane of War',-195,-2500,15.31,0,0,213,0,0,1);
INSERT INTO `zone` VALUES ('potactics',NULL,'Drunder, Fortress of Zek',-905,9,-236,0,0,214,0,0,1);
INSERT INTO `zone` VALUES ('poair',NULL,'Eryslai, the Kingdom of Wind',444,710,-90,0,0,215,0,0,1);
INSERT INTO `zone` VALUES ('powater',NULL,'Reef of Coirnav',-159,-1241,4,0,0,216,0,0,1);
INSERT INTO `zone` VALUES ('pofire',NULL,'Doomfire, The Burning Lands',-1381,1130,-178,0,0,217,0,0,1);
INSERT INTO `zone` VALUES ('poeartha',NULL,'Vegarlson, The Earthen Badlands',7,-554,31.75,0,0,218,0,0,1);
INSERT INTO `zone` VALUES ('potimea',NULL,'Plane of Time',-548,-1933,16,0,0,219,0,0,1);
INSERT INTO `zone` VALUES ('hohonorb',NULL,'Temple of Marr',1049,0,397,0,0,220,0,0,1);
INSERT INTO `zone` VALUES ('nightmareb',NULL,'Lair of Terris Thule',1600,31,-324,0,0,221,0,0,1);
INSERT INTO `zone` VALUES ('poearthb',NULL,'Stronghold of the Twelve',512,80,-42,0,0,222,0,0,1);
INSERT INTO `zone` VALUES ('potimeb',NULL,'Plane of Time',-4,1110,501,0,0,223,0,0,1);
INSERT INTO `zone` VALUES ('jaggedpine',NULL,'The Jaggedpine Forest',1800,1319,-13,0,0,181,0,0,1);
-- End PoP

-- Begin LoY
INSERT INTO `zone` VALUES ('hateplaneb',NULL,'The Plane of Hate',-392.7,629.44,3.75,46,0,186,0,0,1);
INSERT INTO `zone` VALUES ('gunthak',NULL,'Gulf of Gunthak',-938.04,1461.89,15,0,0,224,0,0,1);
INSERT INTO `zone` VALUES ('dulak',NULL,'Dulak\'s Harbor',385.53,529,3.75,0,0,225,0,0,1);
INSERT INTO `zone` VALUES ('torgiran',NULL,'Torgiran Mines',-654.45,-312.96,3.25,0,0,226,0,0,1);
INSERT INTO `zone` VALUES ('nadox',NULL,'Crypt of Nadox',-6445,1337,-40,0,0,227,0,0,1);
INSERT INTO `zone` VALUES ('hatesfury',NULL,'Hate\'s Fury,The Scorned Maiden',-1028,106,0,0,0,228,0,0,1);
INSERT INTO `zone` VALUES ('chardokb',NULL,'The Halls of Betrayal',-216.21,299.23,1,0,0,277,0,0,1);
INSERT INTO `zone` VALUES ('soldungc',NULL,'The Caverns of Exile',342.62,-282.94,-13,0,0,278,0,0,1);
-- End LoY

-- Begin LDoN
INSERT INTO `zone` VALUES ('guka',NULL,'The Cauldron of Lost Souls',61.91,-835.63,1.75,0,0,229,0,0,1);
INSERT INTO `zone` VALUES ('gukb',NULL,'The Drowning Crypt',678.64,57.7,-14.25,0,0,234,0,0,1);
INSERT INTO `zone` VALUES ('gukc',NULL,'The Ancient Aqueducts',16.09,8.85,3.75,0,0,239,0,0,1);
INSERT INTO `zone` VALUES ('gukd',NULL,'The Mushroom Grove',-745.23,153.56,-24.25,0,0,244,0,0,1);
INSERT INTO `zone` VALUES ('guke',NULL,'The Foreboding Prison',734.72,-1030.84,59.75,0,0,249,0,0,1);
INSERT INTO `zone` VALUES ('gukf',NULL,'The Chapel of the Witnesses',34.61,3.74,3.75,0,0,254,0,0,1);
INSERT INTO `zone` VALUES ('gukg',NULL,'The Root Garden',149.4,-315.04,51.75,0,0,259,0,0,1);
INSERT INTO `zone` VALUES ('gukh',NULL,'The Accursed Sanctuary',805.63,-673.71,-92.25,0,0,264,0,0,1);
INSERT INTO `zone` VALUES ('mira',NULL,'The Silent Gallery',655.75,484.64,-112.25,0,0,232,0,0,1);
INSERT INTO `zone` VALUES ('mirb',NULL,'The Maw of the Menagerie',636.58,1432.33,7.75,0,0,237,0,0,1);
INSERT INTO `zone` VALUES ('mirc',NULL,'The Spider Den',75.4,2.71,-23.73,0,0,242,0,0,1);
INSERT INTO `zone` VALUES ('mird',NULL,'The Hushed Bankquet',239.23,-445.15,3.75,0,0,247,0,0,1);
INSERT INTO `zone` VALUES ('mire',NULL,'The Frosted Halls',1016.56,525.36,3.75,0,0,252,0,0,1);
INSERT INTO `zone` VALUES ('mirf',NULL,'The Forgotten Wastes',-71.76,333.48,4.75,0,0,257,0,0,1);
INSERT INTO `zone` VALUES ('mirg',NULL,'The Heart of the Menagerie',504.58,-85.51,51.75,0,0,262,0,0,1);
INSERT INTO `zone` VALUES ('mirh',NULL,'The Morbid Laboratory',1302.35,39.07,7.75,0,0,267,0,0,1);
INSERT INTO `zone` VALUES ('miri',NULL,'The Theater of Imprisoned Horror',666.2,1320.18,7.75,0,0,271,0,0,1);
INSERT INTO `zone` VALUES ('mirj',NULL,'The Grand Library',0,0,4.25,0,0,275,0,0,1);
INSERT INTO `zone` VALUES ('mmca',NULL,'The Forlorn Caverns',-589.47,-383.94,8.12,0,0,233,0,0,1);
INSERT INTO `zone` VALUES ('mmcb',NULL,'The Dreary Grotto',-525.11,-26.12,23.74,0,0,238,0,0,1);
INSERT INTO `zone` VALUES ('mmcc',NULL,'The Asylum of Invoked Stone',1229.65,510.52,-3.21,0,0,243,0,0,1);
INSERT INTO `zone` VALUES ('mmcd',NULL,'The Chambers of Eternal Afflictions',-228.62,-589.27,1,0,0,248,0,0,1);
INSERT INTO `zone` VALUES ('mmce',NULL,'The Sepulcher of the Damned',-578.07,330.4,1,0,0,253,0,0,1);
INSERT INTO `zone` VALUES ('mmcf',NULL,'The Ritualistic Summoning Ground',-167.81,400,-12.75,0,0,258,0,0,1);
INSERT INTO `zone` VALUES ('mmcg',NULL,'The Cesspits of Putrescence',425.31,405.59,3.75,0,0,263,0,0,1);
INSERT INTO `zone` VALUES ('mmch',NULL,'The Aisles of Blood',-340.44,-331.99,20.25,0,0,268,0,0,1);
INSERT INTO `zone` VALUES ('mmci',NULL,'The Halls of Sanguinary Rites',592.96,-283.7,3.75,0,0,272,0,0,1);
INSERT INTO `zone` VALUES ('mmcj',NULL,'The Infernal Sanctuary',227.92,538.84,3.75,0,0,276,0,0,1);
INSERT INTO `zone` VALUES ('ruja',NULL,'The Bloodied Quarries',811,-122,-95,0,0,230,0,0,1);
INSERT INTO `zone` VALUES ('rujb',NULL,'The Halls of War',243.08,-970.86,-12.75,0,0,235,0,0,1);
INSERT INTO `zone` VALUES ('rujc',NULL,'The Wind Bridges',173.68,46.4,-23.25,0,0,240,0,0,1);
INSERT INTO `zone` VALUES ('rujd',NULL,'The Gladiator Pits',-362.05,1279.76,-95.25,0,0,245,0,0,1);
INSERT INTO `zone` VALUES ('ruje',NULL,'The Drudge Hollows',455.85,-1787.06,-220.5,0,0,250,0,0,1);
INSERT INTO `zone` VALUES ('rujf',NULL,'The Fortified Lair of the Taskma',-409.44,-1298.15,-458.25,0,0,255,0,0,1);
INSERT INTO `zone` VALUES ('rujg',NULL,'The Hidden Vale',-510.62,-964.18,132,0,0,260,0,0,1);
INSERT INTO `zone` VALUES ('rujh',NULL,'The Blazing Forge',597.84,-1263.69,-14.25,0,0,265,0,0,1);
INSERT INTO `zone` VALUES ('ruji',NULL,'The Arena of Chance',920.21,-1782.93,-220.5,0,0,269,0,0,1);
INSERT INTO `zone` VALUES ('rujj',NULL,'The Barracks of War',755.12,-119.7,27.75,0,0,273,0,0,1);
INSERT INTO `zone` VALUES ('taka',NULL,'The Sunken Library',-108.26,483.95,3.75,0,0,231,0,0,1);
INSERT INTO `zone` VALUES ('takb',NULL,'The Shifting Tower',433,-565,7.75,0,0,236,0,0,1);
INSERT INTO `zone` VALUES ('takc',NULL,'The Fading Temple',244.76,21.71,3.75,0,0,241,0,0,1);
INSERT INTO `zone` VALUES ('takd',NULL,'The Royal Observatory',66.94,-1.16,5.75,0,0,246,0,0,1);
INSERT INTO `zone` VALUES ('take',NULL,'The River of Recollection',424.5,-411.78,19.75,0,0,251,0,0,1);
INSERT INTO `zone` VALUES ('takf',NULL,'The Sandfall Corridors',78.87,-4.24,3.75,0,0,256,0,0,1);
INSERT INTO `zone` VALUES ('takg',NULL,'The Balancing Chamber',-225.75,227.94,21.75,0,0,261,0,0,1);
INSERT INTO `zone` VALUES ('takh',NULL,'The Sweeping Tides',-222.71,409.63,-2.25,0,0,266,0,0,1);
INSERT INTO `zone` VALUES ('taki',NULL,'The Antiquated Palace',618.13,119.74,-2.25,0,0,270,0,0,1);
INSERT INTO `zone` VALUES ('takj',NULL,'The Prismatic Corridors',-144.11,623.51,-20.25,0,0,274,0,0,1);
INSERT INTO `zone` VALUES ('arttest',NULL,'Art Testing Domain',0,0,0,0,0,995,0,0,1);
-- End LDoN

Chicomalo
01-31-2004, 06:08 AM
:shock: Great Work!

Thanks!

You Rock! :D

diolas
01-31-2004, 06:21 AM
You ,wize-one, are a God. :shock:

I can break it quicker then you.

Apparently you can fix it faster than me too.

I can now enter Erudin and a few other zones that were crashing the client. However, there are still a few that crash and now (for some reason) I can't enter qeynos. 'qeynos1' and 'qeytoqrg' work fine. I wonder what the reasons for this is.

All the 'working' zone points work zone in at the right spots now thanks to your efforts.

Lurker_005
01-31-2004, 07:58 AM
I havn't tested these yet, but you work is definatly apreciated!
Also the fact that you posted SQL is REQLLY pareciated :)

wize_one
01-31-2004, 08:33 AM
just tested qeynos qeynos2 and qeytoqrg. they all work fine.

samandhi
01-31-2004, 09:54 AM
Wow wize that rocks.. Thanks also for putting it in sql. <leaves his post short so he can get the db and source it in and test it.>

Oh, one question though. Will having a space after every line in this cause undue problems (not totally familiar with SQL yet)?


[edit] nevermind, I answered my own question. Duh, the ';' indicated the end of a line (hey Im still learning hehe).

diolas
02-01-2004, 06:53 AM
It seems you're code was good... I think it just might be my sql editor. For some reason everytime It saw --(whatever line) it skipped logging the zone after. I just deleted them all and ran it again.

wize_one
02-01-2004, 07:02 AM
cools glad ya got it working right. i didnt want to put out broken info..

Celebril
02-25-2004, 09:59 AM
Wow, nice job! I haven't tested all of the zones yet, but every one I've tried has worked flawlessly! Just out of curiosity, any chance of this update being included in the next MWnpcmov?[/i]

smogo
02-25-2004, 10:05 AM
thx. Nice job.

wize_one
02-25-2004, 11:22 AM
any chance of this update being included in the next MWnpcmov


8) it's already there..(with GoD zone info)

samandhi
02-25-2004, 12:21 PM
@Scorpious2k or Myra

Is this in the newest release of MyraDB.sql?

Scorpious2k
02-25-2004, 12:48 PM
Is this in the newest release of MyraDB.sql?

Myra's DB uses the db.sql that comes with the release of eqemu... or did... (I don't want to give any secrets away, yet)