Titanium CD zones from last two expansions

John Adams · #7 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.

Code:

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);