ajb20
11-14-2004, 02:58 AM
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.
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");
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");