Page 1 of 1
Zone Descriptions
Posted: Fri Jun 06, 2008 1:34 pm
by John Adams
A question to you good people.
The reason I am asking is, we have a lot of zone descriptions in our current database that do not seem to match the data in the collects... so I am trying to determine which one needs to be changed.
Examples are:
DB: Nettleville Hovel
PacketLog: Nettleville
DB: Thundering Steppes
PacketLog: The Thundering Steppes
And a really far off one:
DB: Cove of Decay
PacketLog: A Treaty for Treasure / The Cove of Decay (this last data is in the zone_key field)
The reason I cannot just "guess" using the file name of the zone is that in some cases, the file is used more than once - like all the qey_tradeskill01. So when parsing the data I have to have a second option to compare to, which is turning out to be a little inconsistent.
So anyway... trust the packets? Rename Nettleville Hovel to Nettleville? Or vice versa?
Thanks for your input,
-J
Posted: Fri Jun 06, 2008 1:42 pm
by John Adams
Btw, here's a list of current Zone Descriptions which I have no idea what they are.
Code: Select all
adv04_dun_drgn_temple
adv04_dun_temple
adv04_tower_cave
exp01_dun_silent_city_epic01_temple
exp01_rgn_pillars_of_flame_epic02_discipline
exp02_rgn_realm_of_dawn_arena
exp03_dun_felwithe_epic01_throne
exp03_dun_hollow_stump
exp03_dun_hollow_stump2
exp03_dun_kaladim_stormguard_hall
fprt_epic01_storeroom01
fprt_epic02_a01_dungeon01
fprt_epic03_a01_dungeon02
fprt_epic04_a04_academy01
fprt_epic05_a02_temple01
fprt_hood_epic01
fprt_hood_epic02
fprt_hood_epic03
fprt_hood_epic04
fprt_sewer_epic01
fprt_sewer_epic02
fprt_sewer_epic03
fprt_sewer_epic05
fprt_sewer_epic06
fprt_sewer_epic07
fprt_sewer_epic08
fprt_sewer_epic09
holdofprexus
lavastorm_epic01_sanctum
obelisk_epic01_vestibule
qey_catacomb_epic04
qey_catacomb_epic05
qey_epic01_p19_cache
qey_epic02_village02_bank
qey_epic03_village03_ph
qey_epic04_village05_bank
qey_epic05_village06_scribe
qey_epic06_p12_irontoes
qey_epic07_p08_sneeds
qey_epic08_p06_voleens
qey_epic09_l02_steel
qey_epic10_p01_bank
qey_epic11_l10_arbor
qey_epic12_l08_sanctum
rivervale_epic01_ph01
rivervale_epic02_ph02
runnyeye_epic02_goblin
thunderdome
There also may be more zone files since this list was compiled. If anyone can identify these or any other zones and/or give valid x,y,z zone-in coords, it would be very helpful.
Posted: Fri Jun 06, 2008 3:01 pm
by Arremis
I voted for the Zone Name fetched from the Collected Packets. It will be much easier for the community to identify these areas from playing on Live.
For example:
And a really far off one:
DB: Cove of Decay
PacketLog: A Treaty for Treasure / The Cove of Decay (this last data is in the zone_key field)
If I understand what you're asking correctly, this makes complete sense to me. The Cove of Decay is a heroic zone, where A Treaty for Treasure is a second instance of that zone accessible for a group of players with the quest A Treaty for Treasure.
EDIT: Just a passing thought: If the quests are LUA-scripted, would we even need the additional instances?
Posted: Sat Jun 07, 2008 6:30 am
by ZexisStryfe
I vote for what the packets say. Oh, and John here is some more zone info for ya:
Code: Select all
adv02_dun_drowned_caverns Drowned Caverns
adv02_dun_sundered_splitpaw Sundered Splitpaw
adv02_dun_sundered_splitpaw_hub Splitpaw Den
adv04_crab_cave Cavern of the Crustacean
adv04_dun_bird_cage Xux'laio's Roost
adv04_dun_drgn_temple Antechamber of Fate
adv04_dun_endless The Forsaken City
adv04_dun_temple The Sepulcher of Zan Fi
adv04_rgn_mystic_lake The Mystic Lake
adv04_rgn_village Village of Shin
adv04_tower_cave Trial of Bo Fen
antonica Antonica
antonica_epic01_vale Shattered Vale
antonica_epic02_firemyst Firemyst Gully
befallen Stormhold
befallen_epic01 The Tomb of Valor
blackburrow Blackburrow
boat_06p_enchanted Maid for the Mist
boat_06p_everfrost The Fanged Sea
boat_06p_feerrott LMS Intruder
boat_06p_freeport Boat FP
boat_06p_hold_of_prexus Hold of Prexus
boat_06p_lavastorm The Burning Cauldron
boat_06p_orcishwastes The Pride of Prexus
boat_06p_qeynos Boat Qeynos
boat_06p_tutorial01 The Far Journey
boat_06p_tutorial02 The Far Journey
cazicthule The Temple of Cazic-Thule
cazicthule_epic01_sanctum The Sanctum Of Fear
character_create Character Creation Screen
cmmn_epic01_orc Blood Skull Valley
cmmn_epic02_mage The Eternal Gorge
commonlands The Commonlands
darklight_wood Darklight Wood
deathfist Deathfist Citadel
design_path_script Describe me in the zones table! :)
drafling_tower Tower of the Drafling
enchanted Enchanted Lands
enchanted_mini01 Cavern of Tangled Weeds
everfrost Everfrost
everfrost_epic01_menagerie Miraguls Menagerie
everfrost_epic02_icespire Forbidden Sepulcher
everfrost_frostfell Frostfell Wonderland Village
exile_city Haven
exp01_cty_majdul MajDul
exp01_cty_majdul_1r01 Maj Dul: 1 Room Apartment
exp01_cty_majdul_1r02 Maj Dul: 1 Room Apartment v2
exp01_cty_majdul_2r01 Maj Dul: 2 Rooms Apartment
exp01_cty_majdul_2r02 Maj Dul: 2 Rooms Apartment v2
exp01_cty_majdul_3r01 Maj Dul: 3 Room Residence
exp01_cty_majdul_3r02 Maj Dul: 3 Room Residence v2
exp01_cty_majdul_arena01 The Arena
exp01_cty_majdul_arena02 The Arena v2
exp01_cty_majdul_blades The Court of the Blades
exp01_cty_majdul_coin The Court of the Coin
exp01_cty_majdul_library The Library of Light
exp01_cty_majdul_moon The Tower of the Moon
exp01_cty_majdul_tears The Court of Tears
exp01_cty_majdul_truth The Court of Truth
exp01_dun_clefts_of_rujark Clefts of Rujark
exp01_dun_living_tombs Living Tombs
exp01_dun_pedestal_of_sky Pedestal of Sky
exp01_dun_poets_palace Poets Palace
exp01_dun_shimmering_citadel Shimmering Citadel
exp01_dun_shimmering_citadel_epic01_bottle An Unusual Bottle
exp01_dun_shimmering_citadel_epic02_prism The Djinn Master's Prism
exp01_dun_silent_city Silent City
exp01_dun_silent_city_epic01_temple Fountain of Life
exp01_rgn_pillars_of_flame Pillars of Flame
exp01_rgn_pillars_of_flame_epic01_cazel Scornfeather Roost
exp01_rgn_pillars_of_flame_epic02_discipline Halls of Discipline
exp01_rgn_sinking_sands Sinking Sands
exp01_rgn_sinking_sands_epic01_lockjaw Vault of Dust
exp02_dun_dragon_necropolis Deathtoll
exp02_dun_halls_of_fate Halls of Fate
exp02_dun_halls_of_fate_epic01_sepulcher The Blackscale Sepulcher
exp02_dun_halls_of_fate_epic02_devourer The Den of the Devourer
exp02_dun_lair_of_scale Sanctum of Scaleborne
exp02_dun_lair_of_scale_epic01_seeing Halls of the Seeing
exp02_dun_lair_of_scale_epic02_hallowed The Lyceum of Abhorrence
exp02_dun_shrines_of_sky Palace of the Awakened
exp02_dun_shrines_of_sky_epic01_vaults The Vaults of El'Arad
exp02_dun_shrines_of_sky_epic02_nest The Nest of the Great Egg
exp02_rgn_realm_of_dawn The Barren Sky (Realm of Dawn)
exp02_rgn_realm_of_dawn_arena Describe me in the zones table! :)
exp02_rgn_realm_of_night The Bonemire (Realm of Night)
exp02_rgn_realm_of_twilight Tenebrous Tangle (Realm of Twilight)
exp03_dun_castle_mistmoore Castle Mistmoore
exp03_dun_castle_mistmoore_epic01_coffinchamber Mistmoore's Inner Sanctum
exp03_dun_crushbone_keep Crushbone Keep
exp03_dun_crushbone_keep_epic01_throne The D'Vinnian Throne
exp03_dun_crushbone_keep_epic02_boss The Acadechism
exp03_dun_estate_of_unrest Unrest
exp03_dun_felwithe New Tunaria
exp03_dun_felwithe_epic01_throne Throne of New Tunaria
exp03_dun_hollow_stump The Grender's Lair
exp03_dun_hollow_stump2 Describe me in the zones table! :)
exp03_dun_kaladim Kaladim
exp03_dun_kaladim_stormguard_hall Stormguard Hall (this zone doesn't actually exist)
exp03_dun_klakanon Klak'Anon
exp03_dun_klakanon_epic01_menace The Clockwork Menace Factory
exp03_dun_klakanon_epic02_court The Court of Innovation
exp03_dun_mistmoore_catacombs Mistmoore Catacombs
exp03_dun_mistmoore_catacombs_epic01_freethinker Freethinker's Hideout
exp03_dun_mistmoore_catacombs_epic02_oldcatacombs Crypt of Valdoon
exp03_dun_obelisk_epic01_blight The Obelisk of Blight
exp03_rgn_butcherblock Butcherblock Mountains
exp03_rgn_emerald_halls Emerald Halls
exp03_rgn_gf_ph_1room Greater Faydark: 1 Room Apartment
exp03_rgn_gf_ph_2room Greater Faydark: 2 Rooms Apartment
exp03_rgn_gf_ph_3room Greater Faydark: 3 Rooms Residence
exp03_rgn_gf_ph_4room Greater Faydark: 4 Rooms Residence
exp03_rgn_greater_faydark Greater Faydark
exp03_rgn_lesser_faydark Lesser Faydark
exp03_rgn_loping_plains The Loping Plains
exp03_rgn_steamfont Steamfont Mountains
exp03_rgn_steamfont_epic01_mines The Mines of Meldrath
exp04_dun_charasis_epic01_queens Tomb of Thuuga
exp04_dun_charasis_north Charasis: Vault of Eternal Sleep
exp04_dun_charasis_south Charasis: Maiden's Chamber
exp04_dun_chardok Chardok
exp04_dun_chardok_epic01_throne Temple of Kor-Sha
exp04_dun_chardok_epic02_prison Court of Korocust
exp04_dun_chelsith The Lost City of Chelsith
exp04_dun_chelsith_epic01_behemoth The Chamber of Destiny
exp04_dun_karnors_castle Karnor's Castle
exp04_dun_karnors_castle_epic01_pawbuster The Execution Throne Room
exp04_dun_sebilis Sebilis
exp04_dun_sebilis_epic01_crypt The Protector's Realm
exp04_dun_sebilis_epic02_venril The Crypt of Agony
exp04_dun_sebilis_quarters Venril Sathir's Lair
exp04_dun_veeshans_peak Veeshan's Peak
exp04_dun_veeshans_peak_epic01_trakanon Trakanon's Lair
exp04_rgn_fens_of_nathsar Fens of Nathsar
exp04_rgn_gorowyn_ph_1room Gorowyn 1 Room Apartment
exp04_rgn_gorowyn_ph_3room Gorowyn 3 Rooms Apartment
exp04_rgn_gorowyn_ph_5room Gorowyn 5 Rooms Apartment
exp04_rgn_jarsath_wastes Jarsath Wastes
exp04_rgn_kunzar_jungle Kunzar Jungle
exp04_rgn_kylong_plains Kylong Plains
exp04_rgn_timorous_deep Timorous Deep
fallengate Fallen Gate
fallengate_epic01_boss The Vault of the Fallen
feerrott Feerrott
feerrott_epic01_temple The Trembling Lagoon
feerrott_epic02_froglok Lost Village of Kugup
fprt_adv01_sunken Sunken City
fprt_adv02_graveyard The Graveyard
fprt_adv03_sprawl The Sprawl
fprt_adv04_ruins The Ruins
fprt_east East Freeport
fprt_epic01_storeroom01 Describe me in the zones table! :)
fprt_epic02_a01_dungeon01 Describe me in the zones table! :)
fprt_epic03_a01_dungeon02 Describe me in the zones table! :)
fprt_epic04_a04_academy01 Academy of Arcane Sciences
fprt_epic05_a02_temple01 Describe me in the zones table! :)
fprt_hood01 Big Bend
fprt_hood02 Stonestair Byway
fprt_hood03 Temple Street
fprt_hood04 Beggars Court
fprt_hood05 Longshadow Alley
fprt_hood06 Scale Yard
fprt_hood_epic01 Describe me in the zones table! :)
fprt_hood_epic02 Describe me in the zones table! :)
fprt_hood_epic03 Describe me in the zones table! :)
fprt_hood_epic04 Describe me in the zones table! :)
fprt_north North Freeport
fprt_ph_1r01 Freeport: 1 Room Apartment
fprt_ph_1r02 Freeport: 1 Room Apartment v2
fprt_ph_2r01 Freeport: 2 Rooms Apartment
fprt_ph_2r02 Freeport: 2 Rooms Apartment v2
fprt_ph_3r01 Freeport: 3 Rooms Residence
fprt_ph_3r02 Freeport: 3 Rooms Residence v2
fprt_ph_3r03 Freeport: 3 Rooms Residence v3
fprt_ph_5r01 Freeport: 5 Rooms Residence
fprt_ph_5r02 Freeport: 5 Rooms Residence
fprt_sewer01 The Thieves Way
fprt_sewer02 The Serpent Sewer
fprt_sewer03 Edgewater Drains
fprt_sewer_epic01 Describe me in the zones table! :)
fprt_sewer_epic02 Describe me in the zones table! :)
fprt_sewer_epic03 Describe me in the zones table! :)
fprt_sewer_epic04 Darkblade Den
fprt_sewer_epic05 Describe me in the zones table! :)
fprt_sewer_epic06 Describe me in the zones table! :)
fprt_sewer_epic07 Describe me in the zones table! :)
fprt_sewer_epic08 Describe me in the zones table! :)
fprt_sewer_epic09 Describe me in the zones table! :)
fprt_south South Freeport
fprt_tradeskill01 Describe me in the zones table! :)
fprt_west West Freeport
fprt_west_militia Freeport Militia
holdofprexus Describe me in the zones table! :)
lavastorm Lavastorm
lavastorm_epic01_sanctum Sanctum of Fire
lavastorm_epic02_gulch Maiden's Gulch
live_epic_mystic
live_haunted_mansion Haunted Mansion
live_irontoes Describe me in the zones table! :)
mod01_dun_crypt_of_thaen Crypt of T'Haen
mod01_dun_tombs_of_night Tombs of Night
nektropos_castle Nektropos Castle
nektulos Nektulos Forest
nektulos_epic01_cauldroncove The Cauldron Hollow
nektulos_mini01 Unearthing
nektulos_mini02 Dire Hollow / Grim Tidings
nektulos_mini03 Underrot Caverns / Moldy Crypt
neriak Neriak
neriak_ph_1room Neriak: 1 Room Apartment
neriak_ph_3room Neriak: 3 Rooms Residence
neriak_ph_5room Neriak: 5 Rooms Residence
obelisk_epic01_vestibule The Vestibule
obelisk_of_lostsouls Obelisk of Lost Souls
orcishwastes Zek, The Orcish Wastes
orcishwastes_mini01 Sullon Mines
permafrost Permafrost
permafrost_epic01_icebound Drayek's Chamber
permafrost_epic02_crypt Crypt of Vox
qey_adv01_oakmyst Oakmyst Forest
qey_adv02_ruins The Forest Ruins
qey_adv03_caves The Caves
qey_adv04_bog The Peat Bog
qey_catacomb01 The Down Below
qey_catacomb02 Vermins Snye
qey_catacomb03 The Crypt of Betrayal
qey_catacomb_epic01 Crows Resting Place
qey_catacomb_epic02 Sepulcher of Jhanda
qey_catacomb_epic03 The Deathly Scarab Hive
qey_catacomb_epic04 Describe me in the zones table! :)
qey_catacomb_epic05 Describe me in the zones table! :)
qey_elddar The Elddar Grove
qey_epic01_p19_cache Describe me in the zones table! :)
qey_epic02_village02_bank Describe me in the zones table! :)
qey_epic03_village03_ph Describe me in the zones table! :)
qey_epic04_village05_bank Describe me in the zones table! :)
qey_epic05_village06_scribe Describe me in the zones table! :)
qey_epic06_p12_irontoes Describe me in the zones table! :)
qey_epic07_p08_sneeds Describe me in the zones table! :)
qey_epic08_p06_voleens Describe me in the zones table! :)
qey_epic09_l02_steel Describe me in the zones table! :)
qey_epic10_p01_bank Describe me in the zones table! :)
qey_epic11_l10_arbor Describe me in the zones table! :)
qey_epic12_l08_sanctum Describe me in the zones table! :)
qey_epic13_l04_towers Mage Tower
qey_harbor Qeynos Harbor
qey_north North Qeynos
qey_ph_1r01 Qeynos: 1 Room Apartment
qey_ph_1r02 Qeynos: 1 Room Apartment
qey_ph_2r01 Qeynos: 2 Rooms Apartment
qey_ph_2r02 Qeynos: 2 Rooms Apartment
qey_ph_3r01 Qeynos: 3 Room Apartment
qey_ph_3r02 Qeynos: 3 Room Apartment
qey_ph_3r03 Qeynos: 3 Room Apartment
qey_ph_5r01 Qeynos: 5 Room Residence
qey_south South Qeynos
qey_tradeskill01 Qeynos Tradeskill Area
qey_village01 Nettleville Hovel
qey_village02 Starcrest Commune
qey_village03 Graystone Yard
qey_village04 Castleview Hamlet
qey_village05 The Willow Wood
qey_village06 The Baubbleshire
rivervale Rivervale
rivervale_epic01_ph01 Describe me in the zones table! :)
rivervale_epic02_ph02 Describe me in the zones table! :)
runnyeye Runnyeye Citadel
runnyeye_epic01_eye Chamber of Rulgax
runnyeye_epic02_goblin Overlord's Throne Room
shard_of_fear The Shard of Fear
shard_of_hate The Shard of Hate
solusekseye Soluseks Eye
solusekseye_epic01_nagafen Nagafen's Lair
solusekseye_epic02_bastion The Bastion Of Flames
solusekseye_epic03_thyr Oratorium of Thyr
steppes Thundering Steppes
steppes_epic01_cove Cove of Decay
steppes_mini01 A Pirates Hidden Stash
thunderdome Describe me in the zones table! :)
tutorial_island02 Outpost of the Overlord
tutorial_island02 Queen's Colony
tutorial_island02_epic01 The Source of Evil
tutorial_island02_epic02 The Tower Basement
varsoon Ruins of Varsoon
vrsn_epic01_boss Chamber of Immortalilty
wailingcaves The Wailing Caves
Posted: Sat Jun 07, 2008 9:21 am
by link2009
Posted: Sat Jun 07, 2008 10:53 am
by John Adams
Arremis wrote:If I understand what you're asking correctly, this makes complete sense to me. The Cove of Decay is a heroic zone, where A Treaty for Treasure is a second instance of that zone accessible for a group of players with the quest A Treaty for Treasure.
Ahh, so when I zoned in there, it really was The Cove of Decay, but because I had the quest "A Treaty for Treasure", the zone was not called Cove of Decay? I'll have to check that out again.
Arremis wrote:EDIT: Just a passing thought: If the quests are LUA-scripted, would we even need the additional instances?
What happens if you have a group in Cove of Decay doing their thing, and someone comes along to do Treaty for Treasure? That would require instancing the zone. Instancing it not going to be as confusing as getting all the names right so when you're zoning in, you think you are going to the right place.
ZexisStryfe wrote:Oh, and John here is some more zone info for ya
Nice, thank you for that info. I'll check it out on my dev server and add them to the update.
Posted: Sat Jun 07, 2008 12:03 pm
by ZexisStryfe
Hey now, I just copied my zone spreadsheet, I never professed to have them all
Posted: Sat Jun 07, 2008 2:54 pm
by John Adams
Going off the current feedback, I have fixed lots of the zone data for those of you who use the 9102 development MySQL update server. Be aware of the changes, mostly to the descriptions only.
I tried to delete zone IDs 266 and 268, but they would not leave. Not sure if LE is blocking "delete from" commands in the updater. Either way, these 2 zones have no "file" so I am assuming they do not exist?
Lastly, I inserted a copy of steppes_epic01_cove to handle data for "A Treaty for Treasure" instance.
For those who like to watch, here's the sql:
Code: Select all
-- create new zone entry for cove of decay - treaty for treasure instance
insert into zones (id,`name`,`file`,description,safe_x,safe_y,safe_z) values (284,'steppes_epic01_treaty','steppes_epic01_cove','A Treaty for Treasure','-196','-15','1087');
-- clean up charasis and city of mist zones without files?
delete from zones where id in (266,268);
update zones set description = 'The Firemyst Gully' where `file` = 'antonica_epic02_firemyst';
update zones set description = 'The Enchanted Lands' where `file` = 'enchanted';
update zones set description = 'The Cauldron Hollow' where `file` = 'nektulos_epic01_cauldroncove';
update zones set description = 'Zek, the Orcish Wastes' where `file` = 'orcishwastes';
update zones set description = 'Vermin\'s Snye' where `file` = 'qey_catacomb02';
update zones set description = 'Nettleville' where `file` = 'qey_village01';
update zones set description = 'Runnyeye' where `file` = 'runnyeye';
update zones set description = 'The Thundering Steppes' where `file` = 'steppes';
update zones set description = 'The Cove of Decay' where `file` = 'steppes_epic01_cove' and id = 250;
update `zones` set `description` = ' A Treaty for Treasure' where `file` = 'steppes_epic01_cove' and id = 284;
update zones set description = 'The Ruins of Varsoon' where `file` = 'varsoon';
-- Zexis zone updates
update `zones` set `description` = 'Sundered Splitpaw' where `file` = 'adv02_dun_sundered_splitpaw';
update `zones` set `description` = 'Antechamber of Fate' where `file` = 'adv04_dun_drgn_temple';
update `zones` set `description` = 'The Sepulcher of Zan Fi' where `file` = 'adv04_dun_temple';
update `zones` set `description` = 'Trial of Bo Fen' where `file` = 'adv04_tower_cave';
update `zones` set `description` = 'Maid for the Mist' where `file` = 'boat_06p_enchanted';
update `zones` set `description` = 'The Fanged Sea' where `file` = 'boat_06p_everfrost';
update `zones` set `description` = 'LMS Intruder' where `file` = 'boat_06p_feerrott';
update `zones` set `description` = 'Hold of Prexus' where `file` = 'boat_06p_hold_of_prexus';
update `zones` set `description` = 'The Burning Cauldron' where `file` = 'boat_06p_lavastorm';
update `zones` set `description` = 'The Pride of Prexus' where `file` = 'boat_06p_orcishwastes';
update `zones` set `description` = 'Boat Qeynos' where `file` = 'boat_06p_qeynos';
update `zones` set `description` = 'The Far Journey' where `file` = 'boat_06p_tutorial01';
update `zones` set `description` = 'The Far Journey' where `file` = 'boat_06p_tutorial02';
update `zones` set `description` = 'The Temple of Cazic-Thule' where `file` = 'cazicthule';
update `zones` set `description` = 'Character Creation Screen' where `file` = 'character_create';
update `zones` set `description` = 'Tower of the Drafling' where `file` = 'drafling_tower';
update `zones` set `description` = 'Fountain of Life' where `file` = 'exp01_dun_silent_city_epic01_temple';
update `zones` set `description` = 'Scornfeather Roost' where `file` = 'exp01_rgn_pillars_of_flame_epic01_cazel';
update `zones` set `description` = 'Halls of Discipline' where `file` = 'exp01_rgn_pillars_of_flame_epic02_discipline';
update `zones` set `description` = 'New Tunaria' where `file` = 'exp03_dun_felwithe';
update `zones` set `description` = 'Throne of New Tunaria' where `file` = 'exp03_dun_felwithe_epic01_throne';
update `zones` set `description` = 'The Grender\'s Lair' where `file` = 'exp03_dun_hollow_stump';
update `zones` set `description` = 'Stormguard Hall (this zone doesn\'t actually exist)' where `file` = 'exp03_dun_kaladim_stormguard_hall';
update `zones` set `description` = 'Klak\'Anon' where `file` = 'exp03_dun_klakanon';
update `zones` set `description` = 'Freethinker\'s Hideout' where `file` = 'exp03_dun_mistmoore_catacombs_epic01_freethinker';
update `zones` set `description` = 'Academy of Arcane Sciences' where `file` = 'fprt_epic04_a04_academy01';
update `zones` set `description` = 'Sanctum of Fire' where `file` = 'lavastorm_epic01_sanctum';
update `zones` set `description` = 'Haunted Mansion' where `file` = 'live_haunted_mansion';
update `zones` set `description` = 'Dire Hollow / Grim Tidings' where `file` = 'nektulos_mini02';
update `zones` set `description` = 'Underrot Caverns / Moldy Crypt' where `file` = 'nektulos_mini03';
update `zones` set `description` = 'The Vestibule' where `file` = 'obelisk_epic01_vestibule';
update `zones` set `description` = 'Qeynos: 3 Room Apartment' where `file` = 'qey_ph_3r01';
update `zones` set `description` = 'Qeynos: 3 Room Apartment' where `file` = 'qey_ph_3r02';
update `zones` set `description` = 'Qeynos: 3 Room Apartment' where `file` = 'qey_ph_3r03';
update `zones` set `description` = 'Qeynos: 5 Room Residence' where `file` = 'qey_ph_5r01';
update `zones` set `description` = 'Overlord\'s Throne Room' where `file` = 'runnyeye_epic02_goblin';
update `zones` set `description` = 'Nagafen\'s Lair' where `file` = 'solusekseye_epic01_nagafen';
update `zones` set `description` = 'Oratorium of Thyr' where `file` = 'solusekseye_epic03_thyr';
update `zones` set `description` = 'The Thundering Steppes' where `file` = 'steppes';
update `zones` set `description` = 'The Tower Basement' where `file` = 'tutorial_island02_epic02';
update `zones` set `description` = 'The Wailing Caves' where `file` = 'wailingcaves';
update `zones` set `description` = 'The Lost City of Chelsith' where `file` = 'exp04_dun_chelsith';
update `zones` set `description` = 'Tomb of Thuuga' where `file` = 'exp04_dun_charasis_epic01_queens';
Zexis, some of your descriptions are off slightly from what I see in the packets. The above scripts should sync you up should you so desire.
Thank you all again for the input and updates so far. Now if we could just get valid x,y,z safe locs for the known zones, we'll be in good shape.
Posted: Fri Jun 13, 2008 9:47 pm
by ZexisStryfe
Hey John,
What zones do you need safe locs for? Let me know and I will see what I can do. I seem to have good luck figuring out safe locs.
Posted: Sat Jun 14, 2008 10:18 am
by John Adams
What I am looking for in safe locs are the standard zone-in locations of many of the zones I have never seen (which honestly is most of them
). When you type /zone {file} and land in a zone, is that where you are supposed to be?
The critical ones are the ones where you are surrounded by blackness. I have about 100 zone that have all 0's for safe_x, safe_y, and safe_z... which in some cases is ok except I am tuning the 'y' (vertical) so you zone in touching the ground.
Run this query to see what zones I am talking about:
Code: Select all
select * from zones where safe_x = 0 and safe_y = 0 and safe_z = 0;
Like I said though, some 0,0,0 are ok... so it really relies on whether or not you feel that is the right place to land - typically.
I understand that some zones have multiple zone-in locations (pillars of fire, for example). What I am after here is a "safe" x,y,z or most common, convenient zone-in point if for any reason the client/server cannot determine the proper locs and needs to guess.
I am not sure if LE intends to use safe locs for anything other than this, but for now let's go on this assumption. I am going through the 100 questionable zones today. I'll post a list later if you want to hold off.
Posted: Sat Jun 14, 2008 10:21 am
by John Adams
Here's a perfect example I just happened to zone in to.
/zone exp01_dun_pedestal_of_sky
Notice where you land (0,0,0) is dead center of this zone. I see no "doors" that you would zone in from - so in this case, is the center of this zone ok? Aside from my 'y' axis, which should be -0.55 so I am not floating when I zone in.
Example of "The Blackness" which I have no idea what locs are valid:
/zone exp01_rgn_pillars_of_flame_epic02_discipline
See what I mean?
Posted: Sat Jun 14, 2008 11:25 am
by John Adams
John Adams wrote:Example of "The Blackness" which I have no idea what locs are valid:
/zone exp01_rgn_pillars_of_flame_epic02_discipline
Hmm. I just went back into this zone accidentally, and this time I was not covered in blackness. Let me finish going through all these myself first, and anything I cannot sort out, I'll make a list. Apparently there is some mysticism going on here as well.
Here's the current list of zones I do not know what their purpose is (no desc).
Code: Select all
id file
86 exp02_rgn_realm_of_dawn_arena
98 exp03_dun_hollow_stump2
129 fprt_epic01_storeroom01
130 fprt_epic02_a01_dungeon01
131 fprt_epic03_a01_dungeon02
133 fprt_epic05_a02_temple01
140 fprt_hood_epic01
141 fprt_hood_epic02
142 fprt_hood_epic03
143 fprt_hood_epic04
157 fprt_sewer_epic01
158 fprt_sewer_epic02
159 fprt_sewer_epic03
161 fprt_sewer_epic05
162 fprt_sewer_epic06
163 fprt_sewer_epic07
164 fprt_sewer_epic08
165 fprt_sewer_epic09
167 fprt_tradeskill01
170 holdofprexus
175 live_irontoes
205 qey_catacomb_epic04
206 qey_catacomb_epic05
208 qey_epic01_p19_cache
209 qey_epic02_village02_bank
210 qey_epic03_village03_ph
211 qey_epic04_village05_bank
212 qey_epic05_village06_scribe
213 qey_epic06_p12_irontoes
214 qey_epic07_p08_sneeds
215 qey_epic08_p06_voleens
216 qey_epic09_l02_steel
217 qey_epic10_p01_bank
218 qey_epic11_l10_arbor
219 qey_epic12_l08_sanctum
240 rivervale_epic01_ph01
241 rivervale_epic02_ph02
252 thunderdome
I am still going through the ones with descriptions and setting valid zone-in points.
I seem to remember some tiny instanced zones that were used for class development (Quest: "Becoming a Crusader" led you to a zone called "Dock Warehouse" etc). I am wondering if that's what some of these are, which (I believe) are no longer used in Live. Is that true?
Thanks again for any additional info you all can provide.
Posted: Sat Jun 14, 2008 2:16 pm
by link2009
John, what you're saying makes sense. I remember a long time ago you would have to zone in and do some quest before actually becoming the class you wanted to.
I'll try zoning into these locations and see if I can come up with anything.
EDIT: While using my app I looked for some of these zones and Sony doesn't seem to have deleted them. So I suspect they're still used in live.