Titanium CD zones from last two expansions
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: 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, '', 1); |
Thats the problem I have.
without the map files you get hung in a state of suspension. Code:
player is below world moveing to safeloc 0 0 0. |
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. |
..
Quote:
ahh I see what you mean by it defaults to 0 maybe a global setting of -2030 would be better ? Code:
underworld` float NOT NULL default '0', |
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. |
This might work too. Thanks for this update. I was wondering what the hell was going on :)
First: Code:
DELETE FROM `zone` WHERE zoneidnumber IN (295,296,297,298); Code:
INSERT INTO `zone` VALUES 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. |
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. :) |
Verified, after adding entirely new zone records as in your original post, restarting "world" seemed to get me in. Thanks again!
|
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!
|
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...
|
anyone able to direct me to a link that will tell me how to get these 2 expansions working on my server? :o
|
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); |
All times are GMT -4. The time now is 11:41 PM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.