Log in

View Full Version : Titanium CD zones from last two expansions

bufferofnewbies
11-07-2006, 03:09 AM
These are most of the zones for the Dragons of Norrath and Depths of Darkhollow expansions, the last two expansions that come with the Titanium CD.
Not sure who does or doesn't have these yet. There are no map files for these yet that I know of, but you can at least zone in to look around if you wish to do so.

Some of these zones you may or may not have, so there might be some errors if you use this w/o removing the ones you have already. I kept the default safe point in all zones except those which fell outside the map areas or too far above the ground. These I moved to the closest place I could find.
Hope it is of use to someone:

INSERT INTO zone VALUES ('guildhall', '', 'Guild Hall', 0, 0, 0, 0, 0, 345, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('guildlobby', '', 'The Guild Lobby', 0, 0, 0, 0, 0, 344, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('thenest', '', 'The Accursed Nest', 0, 0, 0, 0, 0, 343, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('delveb', '', 'Tirranums Lair', 0, 0, 0, 0, 0, 342, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('delvea', '', 'Lavaspinners Lair', -66.7, -389.6, 14, 0, 0, 341, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('thundercrest', '', 'Thundercrest Isles', -3296, -790.5, 143.6, 0, 0, 340, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('stillmoonb', '', 'The Ascent', 171.2, 1151.5, 44, 0, 0, 339, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('stillmoona', '', 'Stillmoon Temple', 0, 0, 0, 0, 0, 338, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('broodlands', '', 'The Broodlands', 1000, 1000, 45, 0, 0, 337, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('fhalls', '', 'The Forgotten Halls', 0, 0, 0, 0, 0, 998, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('illsalin', '', 'Ruins of Illsalin', -1183.7, -1177.8, 110, 0, 0, 347, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('illsalina', '', 'Imperial Bazaar', 0, 0, 0, 0, 0, 348, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('illsalinb', '', 'Temple of Korlach', 0, 0, 0, 0, 0, 349, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('illsalinc', '', 'The Nargilor Pits', 0, 0, 0, 0, 0, 350, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('dreadspire', '', 'Dreadspire Keep', 0, -600, 100.4, 0, 0, 351, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('drachnidhive', '', 'The Hive', 0, 0, 0, 0, 0, 354, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('drachnidhivea', '', 'Living Larder', 0, 0, 0, 0, 0, 355, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('drachnidhiveb', '', 'Coven of the Skinwalkers', 230, 1410, 155.3, 0, 0, 356, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('drachnidhivec', '', 'Queen Sendaiis Lair', -10, -100, -754.6, 0, 0, 357, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('westkorlach', '', 'Stoneroot Falls', 0, 0, 0, 0, 0, 358, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('westkorlacha', '', 'Chambers of Xill', 0, 0, 0, 0, 0, 359, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('westkorlachb', '', 'Caverns of the Lost', 0, 0, 0, 0, 0, 360, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('westkorlachc', '', 'Lair of the Korlach', -50, 330, 86, 0, 0, 361, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('eastkorlach', '', 'Undershore', 0, 0, 0, 0, 0, 362, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('eastkorlacha', '', 'Snarlstone Dens', 0, 0, 0, 0, 0, 363, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('shadowspine', '', 'Shadowspine', 0, 0, 0, 0, 0, 364, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('corathus', '', 'Corathus Creep', 0, 0, 0, 0, 0, 365, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('corathusa', '', 'Sporali Caverns', 0, 0, 0, 0, 0, 366, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('corathusb', '', 'Corathus Lair', 0, 0, 0, 0, 0, 367, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
INSERT INTO zone VALUES ('nektulosa', '', 'Shadowed Grove', 0, 0, 0, 0, 0, 368, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 1);
sdabbs65
11-07-2006, 03:56 AM
Thats the problem I have.
without the map files you get hung in a state of suspension.

player is below world moveing to safeloc 0 0 0.
endless loop.
bufferofnewbies
11-07-2006, 04:47 AM
That isnt a map problem, thats a field error in underworld in the zone table. My setup includes a setting for -2030 as underworld setting, so you do not get a reset to safe point message due a random negative z axis being below a default 0 setting.

With the code I have above, i am able to run around all these zones.
sdabbs65
11-07-2006, 05:26 AM
That isnt a map problem, thats a field error in underworld in the zone table. My setup includes a setting for -2030 as underworld setting, so you do not get a reset to safe point message due a random negative z axis being below a default 0 setting.

With the code I have above, i am able to run around all these zones.

I been looking for that setting for weeks.
ahh I see what you mean by it defaults to 0 maybe a global setting of
-2030 would be better ?

underworld` float NOT NULL default '0',
bufferofnewbies
11-07-2006, 06:20 AM
also, the zones for Qvic, Inktuta, Txevu and Tacvi are listed incorrectly in the zone table. When you #zone into a name, you will actually end up on the wrong map.

They are listed in numberical order as:
295--inktuta
296--txevu
297--tacvi
298--qvic

When they are actually:
295--qvic
296--inktuta
297--txevu
298--tacvi

Simply replace the shortname and the longname fields for the table, as the safe coordinates are set for the zone number, not the name. If you simply swap the numbers around, you will have to go back and fix your safe points for all zones. I would post a replace code for it, but I get errors when i tried to change them in mass.

My suggestion:
1. Put a number 1 behind all names (ie:qvic1). Then save like that.
--This will reset the stored fields to clear the used names from the key fields.
2. Then swap the names to the proper lines.
--This prevents the 'key already in use' error.
John Adams
11-08-2006, 12:39 PM
This might work too. Thanks for this update. I was wondering what the hell was going on :)

First:
DELETE FROM `zone` WHERE zoneidnumber IN (295,296,297,298);
Next:
INSERT INTO `zone` VALUES
('qvic', '', 'Qvic, Prayer Grounds of Calling', -1181.21, -129.49, -379.25, 0, 100, 295, 0, 0, 1, '', 0, 450, 450, 450, 450, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, '', 1),
('inktuta', '', 'Inktu`Ta, The Unmasked Chapel', 0, 0, -2.25, 0, 100, 296, 0, 0, 1, '', 0, 450, 450, 450, 450, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, '', 1),
('txevu', '', 'Txevu, Lair of the Elites', -307.31, -1.67, -420.25, 0, 100, 297, 0, 0, 1, '', 0, 450, 450, 450, 450, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, '', 1),
('tacvi', '', 'Tacvi, Seat of the Slaver', 0, 0, -6.25, 0, 100, 298, 0, 0, 1, '', 0, 450, 450, 450, 450, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, 0, 0, 0, 450, 450, '', 1);

Could be in the same update.sql file to do it in one swoop.

edit: did you have to restart your world after adding these? I just sourced the DoN and DoDH zones in, #reloadzonepoints, and zoned, and still can't get in... I'll reboot just for the heck of it.
bufferofnewbies
11-08-2006, 12:49 PM
Yep, I restarted after i did those. But I was doing a ton of updates on my server at the time. So I needed to restart none the less.
I was never quite sure when you need to restart after changeing things, so I make it a habit of rebooting after any major swap of things anyway.

Thanks for the codeing for the 4 files, I was just tired of doing all the others to actually write anything up. That's why i gave the poor man's version of the change. :)
John Adams
11-08-2006, 01:31 PM
Verified, after adding entirely new zone records as in your original post, restarting "world" seemed to get me in. Thanks again!
cavedude
11-08-2006, 01:47 PM
Excellent, now all we need are some logs of these zones so we can get them popped. It bothers me that we have completely ignored 2 expansions both clients support!
bufferofnewbies
11-08-2006, 02:22 PM
I would be more than happy to help work on building maps and such, but I still have trouble getting azone to work on my system. :( I'm technologically impared...
ChUzZ
11-22-2006, 11:58 PM
anyone able to direct me to a link that will tell me how to get these 2 expansions working on my server? :o
John Adams
09-04-2007, 07:13 PM
I think my new hobby is going to be bumping old, dead threads.

FYI, since the PEQ database is still missing many zones, I will re-post the zones from Bufferofnewbies above, but with the added "canbind" field. Running this against PEQ_DB should insert the missing zones.

INSERT INTO zone VALUES ('guildhall', '', 'Guild Hall', 0, 0, 0, 0, 0, 345, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('guildlobby', '', 'The Guild Lobby', 0, 0, 0, 0, 0, 344, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('thenest', '', 'The Accursed Nest', 0, 0, 0, 0, 0, 343, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('delveb', '', 'Tirranums Lair', 0, 0, 0, 0, 0, 342, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('delvea', '', 'Lavaspinners Lair', -66.7, -389.6, 14, 0, 0, 341, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('thundercrest', '', 'Thundercrest Isles', -3296, -790.5, 143.6, 0, 0, 340, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('stillmoonb', '', 'The Ascent', 171.2, 1151.5, 44, 0, 0, 339, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('stillmoona', '', 'Stillmoon Temple', 0, 0, 0, 0, 0, 338, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('broodlands', '', 'The Broodlands', 1000, 1000, 45, 0, 0, 337, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('fhalls', '', 'The Forgotten Halls', 0, 0, 0, 0, 0, 998, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('illsalin', '', 'Ruins of Illsalin', -1183.7, -1177.8, 110, 0, 0, 347, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('illsalina', '', 'Imperial Bazaar', 0, 0, 0, 0, 0, 348, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('illsalinb', '', 'Temple of Korlach', 0, 0, 0, 0, 0, 349, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('illsalinc', '', 'The Nargilor Pits', 0, 0, 0, 0, 0, 350, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('dreadspire', '', 'Dreadspire Keep', 0, -600, 100.4, 0, 0, 351, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('drachnidhive', '', 'The Hive', 0, 0, 0, 0, 0, 354, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('drachnidhivea', '', 'Living Larder', 0, 0, 0, 0, 0, 355, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('drachnidhiveb', '', 'Coven of the Skinwalkers', 230, 1410, 155.3, 0, 0, 356, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('drachnidhivec', '', 'Queen Sendaiis Lair', -10, -100, -754.6, 0, 0, 357, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('westkorlach', '', 'Stoneroot Falls', 0, 0, 0, 0, 0, 358, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('westkorlacha', '', 'Chambers of Xill', 0, 0, 0, 0, 0, 359, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('westkorlachb', '', 'Caverns of the Lost', 0, 0, 0, 0, 0, 360, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('westkorlachc', '', 'Lair of the Korlach', -50, 330, 86, 0, 0, 361, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('eastkorlach', '', 'Undershore', 0, 0, 0, 0, 0, 362, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('eastkorlacha', '', 'Snarlstone Dens', 0, 0, 0, 0, 0, 363, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('shadowspine', '', 'Shadowspine', 0, 0, 0, 0, 0, 364, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('corathus', '', 'Corathus Creep', 0, 0, 0, 0, 0, 365, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('corathusa', '', 'Sporali Caverns', 0, 0, 0, 0, 0, 366, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('corathusb', '', 'Corathus Lair', 0, 0, 0, 0, 0, 367, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);
INSERT INTO zone VALUES ('nektulosa', '', 'Shadowed Grove', 0, 0, 0, 0, 0, 368, 0, 0, 1, '', -2030, 450, 3000, 450, 3000, 0, 0, 0, 1, 1, 1, 0.4, 2, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, 0, 0, 0, 450, 3000, '', 0, 1);