New 'Zone" field for databases

[wize_one]

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]

Great Work!

Thanks!

You Rock!

[diolas]

You ,wize-one, are a God.

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]

I havn't tested these yet, but you work is definatly apreciated!
Also the fact that you posted SQL is REQLLY pareciated

[wize_one]

just tested qeynos qeynos2 and qeytoqrg. they all work fine.

[samandhi]

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]

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]

cools glad ya got it working right. i didnt want to put out broken info..

[Celebril]

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]

thx. Nice job.

[wize_one]

any chance of this update being included in the next MWnpcmov

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

[samandhi]

@Scorpious2k or Myra

Is this in the newest release of MyraDB.sql?

[Scorpious2k]

Originally Posted by samandhi

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)