Titanium CD zones from last two expansions

[bufferofnewbies]

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]

Originally Posted by bufferofnewbies

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]

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]

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]

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]

Verified, after adding entirely new zone records as in your original post, restarting "world" seemed to get me in. Thanks again!

[cavedude]

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!