| ajb20 | 
			11-14-2004 02:58 AM | 
		 
		 
		 
		
			Complete zone listing - MySQL Commands   
		
		
		I was searching and could not find a complete listing of zones, so I decided to take some time and mix and match up different posts and get what I think is a complete listing of zones and zone id's.  This is more for checking against your db to ensure you have all the zones since it only includes short_name, long_name, and zoneidnumber.  Anyway, its 286 zones, if anyone sees anything missing or wrong, let me know. 
	Code: 
	
 INSERT into zone (short_name,long_name,zoneidnumber) values ("qeynos","South Qeynos","1"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("qeynos2","North Qeynos","2"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("qrg","Surefall Glade","3"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("qeytoqrg","Qeynos Hills","4"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("highpass","Highpass Hold","5"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("highkeep","High Keep","6"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("freportn","North Freeport","8"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("freportw","West Freeport","9"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("freporte","East Freeport","10"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("runnyeye","Runnyeye Citadel","11"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("qey2hh1","Western Plains of Karana","12"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("northkarana","Northern Plains of Karana","13"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("southkarana","Southern Plains of Karana","14"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("eastkarana","Eastern Plains of Karana","15"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("beholder","Gorge of King Xorbb","16"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("blackburrow","Blackburrow","17"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("paw","Lair of the Splitpaw","18"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("rivervale","Rivervale","19"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("kithicor","Kithicor Woods","20"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("commons","West Commonlands","21"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("ecommons","East Commonlands","22"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("erudnint","Erudin Palace","23"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("erudnext","Erudin","24"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("nektulos","Nektulos Forest","25"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("cshome","Sunset Home","26"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("lavastorm","Lavastorm Mountains","27"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("halas","Halas","29"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("everfrost","Everfrost","30"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("soldunga","Solusek\\'s Eye","31"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("soldungb","Nagafen\'s Lair","32"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("misty","Misty Thicket","33"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("nro","Northern Desert of Ro","34"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("sro","Southern Desert of Ro","35"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("befallen","Befallen","36"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("oasis","Oasis of Marr","37"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("tox","Toxxulia Forest","38"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("hole","The Hole","39"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("neriaka","Neriak Foreign Quarter","40"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("neriakb","Neriak Commons","41"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("neriakc","Neriak Third Gate","42"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("najena","Najena","44"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("qcat","Qeynos Aqueduct System","45"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("innothule","Innothule Swamp","46"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("feerrott","The Feerrott","47"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("cazicthule","Lost Temple of Cazic Thule","48"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("oggok","Oggok","49"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("rathemtn","Rathe Mountains","50"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("lakerathe","Lake Rathetear","51"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gukta","Gukta","52"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gfaydark","Greater Faydark","54"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("akanon","Ak\'Anon","55"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("steamfont","Steamfont Mountains","56"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("lfaydark","Lesser Faydark","57"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("crushbone","Crushbone","58"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mistmoore","Castle Mistmoore","59"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("kaladima","South Kaladim","60"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("felwithea","Northern Felwithe","61"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("felwitheb","Southern Felwithe","62"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("unrest","Estate of Unrest","63"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("kedge","Kedge Keep","64"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("guktop","Guk","65"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gukbottom","Ruins of Old Guk","66"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("kaladimb","North Kaladim","67"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("butcher","Butcherblock Mountains","68"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("oot","Ocean of Tears","69"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("cauldron","Dagnor\'s Cauldron","70"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("airplane","Plane of Air","71"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("fearplane","Plane of Fear","72"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("permafrost","Permafrost Caverns","73"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("kerraridge","Kerra Isle","74"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("paineel","Paineel","75"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("hateplane","Plane of Hate","76"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("arena","The Arena","77"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("fieldofbone","Field of Bone","78"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("warslikswood","Warslilks Woods","79"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("soltemple","Temple of Solusek Ro","80"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("droga","Temple of Droga","81"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("cabwest","Cabilis West","82"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("swampofnohope","Swamp Of No Hope","83"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("firiona","Firiona Vie","84"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("lakeofillomen","Lake of Ill Omen","85"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dreadlands","Dreadlands","86"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("burningwood","The Burning Wood","87"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("kaesora","Kaesora","88"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("sebilis","Old Sebilis","89"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("citymist","The City of Mist","90"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("skyfire","Skyfire Mountains","91"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("frontiermtns","Frontier Mountains","92"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("overthere","The Overthere","93"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("emeraldjungle","The Emerald Jungle","94"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("trakanon","Trakanon\'s Teeth","95"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("timorous","Timorous Deep","96"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("kurn","Kurn\'s Tower","97"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("erudsxing","Erud\'s Crossing","98"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("stonebrunt","Stonebrunt Mountains","100"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("warrens","Warrens","101"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("karnor","Karnor\'s Castle","102"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("chardok","Chardok","103"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dalnir","Dalnir","104"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("charasis","Howling stones","105"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("cabeast","Cabilis East","106"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("nurga","Mines of Nurga","107"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("veeshan","Veeshan\'s Peak","108"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("veksar","City of veksar","109"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("iceclad","Iceclad Ocean","110"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("frozenshadow","Tower of Frozen Shadow","111"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("velketor","Velketor\'s Labrynth","112"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("kael","Kael Drakael","113"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("skyshrine","Skyshrine","114"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("thurgadina","City of Thurgadin","115"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("eastwastes","Eastern Wastelands","116"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("cobaltscar","Cobalt Scar","117"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("greatdivide","Great Divide","118"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("wakening","The Wakening Lands","119"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("westwastes","Western Wastelands","120"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("crystal","Crystal Caverns","121"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("necropolis","Dragon Necropolis","123"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("templeveeshan","Temple of Veeshan","124"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("sirens","Siren\'s Grotto","125"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mischiefplane","Plane of Mischief","126"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("growthplane","Plane of Growth","127"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("sleeper","Sleeper\'s Tomb","128"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("thurgadinb","Icewell Keep","129"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("shadowhaven","Shadow Haven","150"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("bazaar","The Bazaar","151"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("nexus","The Nexus","152"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("echo","Echo Caverns","153"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("acrylia","Acrylia Caverns","154"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("sharvahl","Shar Vahl","155"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("paludal","Paludal Caverns","156"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("fungusgrove","Fungus Grove","157"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("vexthal","Vex Thal","158"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("sseru","Sanctus Seru","159"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("katta","Katta Castellum","160"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("netherbian","Netherbian Lair","161"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("ssratemple","Ssraeshza Temple","162"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("griegsend","Grieg\'s End","163"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("thedeep","The Deepshade","164"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("shadeweaver","Shadeweavers Thicket","165"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("hollowshade","Hollowshade Moor","166"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("grimling","Grimling Forest","167"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mseru","Marus Seru","168"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("letalis","Mons Letalis","169"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("twilight","The Twilight Sea","170"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("thegrey","The Grey","171"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("tenebrous","The Tenebrous Mountains","172"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("maiden","The Maiden\'s Eye","173"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dawnshroud","Dawnshroud Peaks","174"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("scarlet","The Scarlet Desert","175"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("umbral","The Umbral Plains","176"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("akheva","Akheva Ruins","179"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("arena2","The Arena Two","180"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("jaggedpine","The Jaggedpine Forest","181"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("nedaria","Nedaria\'s Landing","182"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("tutorial","EverQuest Tutorial","183"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("load","Loading Zone","184"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("load2","New Loading Zone","185"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("hateplaneb","The Plane of Hate","186"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("shadowrest","Shadowrest","187"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("tutoriala","The Mines of Gloomingdeep","188"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("tutorialb","The Mines of Gloomingdeep","189"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("codecay","Ruins of Ixanvom","200"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("pojustice","Plane of Justice","201"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("poknowledge","Plane of Knowledge","202"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("potranquility","Plane of Tranquility","203"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("ponightmare","Plane of Nightmare","204"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("podisease","Plane of Disease","205"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("poinnovation","Plane of Innovation","206"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("potorment","Plane of Torment","207"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("povalor","Plane of Valor","208"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("bothunder","Torden, The Bastion of Thunder","209"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("postorms","Plane of Storms","210"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("hohonora","Halls of Honor","211"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("solrotower","Solusek Ro\'s Tower","212"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("powar","Plane of War","213"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("potactics","Drunder, Fortress of Zek","214"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("poair","Eryslai, the Kingdom of Wind","215"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("powater","Reef of Coirnav","216"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("pofire","Doomfire, The Burning Lands","217"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("poeartha","Vegarlson, The Earthen Badlands","218"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("potimea","Plane of Time","219"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("hohonorb","Temple of Marr","220"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("nightmareb","Lair of Terris Thule","221"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("poearthb","Stronghold of the Twelve","222"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("potimeb","Plane of Time","223"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gunthak","Gulf of Gunthak","224"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dulak","Dulak\'s Harbor","225"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("torgiran","Torgiran Mines","226"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("nadox","Crypt of Nadox","227"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("hatesfury","Hate\'s Fury,The Scorned Maiden","228"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("guka","The Cauldron of Lost Souls","229"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("ruja","The Bloodied Quarries","230"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("taka","The Sunken Library","231"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mira","The Silent Gallery","232"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmca","The Forlorn Caverns","233"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gukb","The Drowning Crypt","234"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("rujb","The Halls of War","235"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("takb","The Shifting Tower","236"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mirb","The Maw of the Menagerie","237"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmcb","The Dreary Grotto","238"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gukc","The Ancient Aqueducts","239"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("rujc","The Wind Bridges","240"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("takc","The Fading Temple","241"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mirc","The Spider Den","242"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmcc","The Asylum of Invoked Stone","243"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gukd","The Mushroom Grove","244"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("rujd","The Gladiator Pits","245"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("takd","The Royal Observatory","246"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mird","The Hushed Bankquet","247"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmcd","The Chambers of Eternal Afflictions","248"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("guke","The Foreboding Prison","249"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("ruje","The Drudge Hollows","250"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("take","The River of Recollection","251"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mire","The Frosted Halls","252"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmce","The Sepulcher of the Damned","253"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gukf","The Chapel of the Witnesses","254"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("rujf","The Fortified Lair of the Taskma","255"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("takf","The Sandfall Corridors","256"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mirf","The Forgotten Wastes","257"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmcf","The Ritualistic Summoning Ground","258"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gukg","The Root Garden","259"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("rujg","The Hidden Vale","260"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("takg","The Balancing Chamber","261"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mirg","The Heart of the Menagerie","262"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmcg","The Cesspits of Putrescence","263"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("gukh","The Accursed Sanctuary","264"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("rujh","The Blazing Forge","265"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("takh","The Sweeping Tides","266"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mirh","The Morbid Laboratory","267"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmch","The Aisles of Blood","268"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("ruji","The Arena of Chance","269"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("taki","The Antiquated Palace","270"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("miri","The Theater of Imprisoned Horror","271"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmci","The Halls of Sanguinary Rites","272"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("rujj","The Barracks of War","273"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("takj","The Prismatic Corridors","274"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mirj","The Grand Library","275"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("mmcj","The Infernal Sanctuary","276"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("chardokb","The Halls of Betrayal","277"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("soldungc","The Caverns of Exile","278"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("abysmal","The Abysmal Sea","279"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("natimbi","Natimbi, The Broken Shores","280"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("qinimi","Qinimi, Court of Nihilia","281"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("riwwi","Riwwi, Coliseum of Games","282"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("barindu","Barindu, Hanging Gardens","283"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("ferubi","Ferubi, Forgotten Temple of Taelosia","284"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("snpool","Sewers of Nihilia, Pool of Sludge","285"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("snlair","Sewers of Nihilia, Lair of Trapped Ones","286"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("snplant","Sewers of Nihilia, Purifying Plant","287"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("sncrematory","Sewers of Nihilia, the Crematory","288"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("tipt","Tipt, Treacherous Crags","289"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("vxed","Vxed, The Crumbling Caverns","290"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("yxtta","Yxtta, Pulpit of Exiles","291"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("uqua","Uqua, The Ocean God Chantry","292"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("kodtaz","Kod\'Taz, Sullied Ritual Hall","293"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("ikkinz","Ikkinz, Antechamber of Destruction","294"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("inktuta","Inktu`Ta, The Unmasked Chapel","295"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("txevu","Txevu, Lair of the Elites","296"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("tacvi","Tacvi, Seat of the Slaver","297"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("qvic","Qvic, Prayer Grounds of Calling","298"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("qvicb","Qvic, the Hidden Vault","299"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("wallofslaughter","Wall of Slaughter","300"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("bloodfields","The Bloodfields","301"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("draniksscar","Dranik\'s Scar","302"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("causeway","Nobles\' Causeway","303"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("chambersa","Muramite Proving Grounds","304"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("chambersb","Muramite Proving Grounds","305"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("chambersc","Muramite Proving Grounds","306"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("chambersd","Muramite Proving Grounds","307"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("chamberse","Muramite Proving Grounds","308"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("chambersf","Muramite Proving Grounds","309"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("provinggrounds","Muramite Proving Grounds","316"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("anguish","Asylum of Anguish","317"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dranikhollowsa","Dranik\'s Hollows","318"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dranikhollowsb","Dranik\'s Hollows","319"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dranikhollowsc","Dranik\'s Hollows","320"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dranikcatacombsa","Catacombs of Dranik","328"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dranikcatacombsb","Catacombs of Dranik","329"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dranikcatacombsc","Catacombs of Dranik","330"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("draniksewersa","Sewers of Dranik","331"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("draniksewersb","Sewers of Dranik","332"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("draniksewersc","Sewers of Dranik","333"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("riftseekers","Riftseekers\' Sanctum","334"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("harbingers","Harbingers\' Spire","335"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("dranik","The Ruined City of Dranik","336"); 
INSERT into zone (short_name,long_name,zoneidnumber) values ("arttest","Art Testing Domain","995"); 
  
	 |