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.
