EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   Doors & stones help please (https://www.eqemulator.org/forums/showthread.php?t=7756)

jdankanyin 06-13-2003 10:42 AM

doors ?
 
:o Hey i already got it but i was saying that the first part worked great but when i added yours it made all my doors be 90 degrees off that was it . Also this is where my servers and desk are for my computers.

IAsoulfood 06-13-2003 03:31 PM

doors 90degrees off
 
jdankanyin,
Sorry about them being off by 90degrees I do not have the know how to fix it. You can use Lurker_005's door_db or hope someone here can help out fixing it. I wish I knew why. Still in Freeport West the portal to POK does not show up on my system, just an FYI kinda thing if its the same for you I am unsure since my doors are not at a 90degree change.
Hoping Lurker_005 see's this one =)
Soulfood.

Lurker_005 06-13-2003 04:21 PM

soulfood I was tired last night and didn't notice that I skiped some posts. I didn't see your doors.zip till today :p

Good news is I was tired from working with doors. Mostly what you had done in your doors file :p Anyhow some of the changes you made I think were causing problems. Specifically changing the doorid field. That has to be unique for each door in the zone. This may be why you had problems with the freport book. As for the doors being 90 deg???? The rest of the files data is identical to mine. I can only guess it has to do with a different CVS version.

Anyhow, I'll post another copy of the doors this weekend with more stuff working. Regarding that, I know there was a request for the Tower of frozen shadow. Someone want to get a list of locs from, and too, also the key item# or at least name.

If someone wants to make the changes and post them that would be great. I would prefer they be in an update format with comments for each section or zone. here is a line from one I have done.
Code:

UPDATE doors SET dest_zone="Tox" ,dest_y=-2344.14 ,dest_x=295.884 ,dest_z=-47 ,dest_heading=371.01 WHERE zone LIKE "PoKnowledge" AND name LIKE "POKPPORT500";
Oh and for when the object is the same as others, it is probably best to add AND doorid=id# to the where part

IAsoulfood 06-13-2003 05:29 PM

EEGAADS I hate doors LMAO
 
Lurker_005,
Sorry about changing the unique door id's I was so tired of Freeport West I was trying alot of things with that zone and forgot to reset the unique door id's I was playing with. Thanks for catching it.
I'll take your doors.zip and add the id's to my database until this weekend.
If I can be of any assistance with this database don't hesitate to point me in a direction or two. I'd love the opportunity.
=)
Keepin it real
Soulfood

Lurker_005 06-13-2003 10:25 PM

Well I worked on the doors some more, give these a try.

http://lurker.eqemu.net/DBFiles/doors-06142003.zip

It has Plane of Knowledge books (to and from) some plane of tranquility ones, a first go at tower of frozen shadow, and 2 non working elevators :(

Let me know what you find. I probably won't be working on this any more today, but perhaps sunday...

Bigpull 06-14-2003 01:11 AM

YAY doors! i've added some Error printing to cvs should help those darn stuborn not wanting to spawn doors some ;)

Quote:

[Status] Loading doors for freportw ...
[Error] Database errror, Not Sending door: i:824 door:0x41965766 db_id:824 zone_name:FreportW zone:freportw door_id:154
[Error] Database errror, Not Sending door: i:825 door:0x419657c8 db_id:825 zone_name:FreportW zone:freportw door_id:153
[Error] Database errror, Not Sending door: i:894 door:0x41967232 db_id:894 zone_name:FreportW zone:freportw door_id:177
894 happens to be that pok book that was giving troubles if you don't recognise the number

Bigpull 06-14-2003 01:53 AM

And yes i fixed the door_id to sint8 -128 to 127 like we've been expecting them /mumble

So tofs mirrors look great and our MovePC() sucks =) can't move thru walls atm.

IAsoulfood 06-14-2003 03:25 AM

Awesome job you two
 
Gonna keep working on finding more of these door and zoning issues. I'll take a look at it tonight. Father's Day tomorrow so I may not get a chance to respond until tomorrow night. =)

WOOOT we're getting closer =) BTW Tradeskills and those forges ovens etc... I click on em and walla when in inventory they actually open now. =) musta had something to do with the objects you put in Lurker_005 Thanks bud.


Soulfood

Lurker_005 06-14-2003 09:57 AM

Quote:

Originally Posted by Bigpull
And yes i fixed the door_id to sint8 -128 to 127 like we've been expecting them /mumble

So tofs mirrors look great and our MovePC() sucks =) can't move thru walls atm.

I thought doorid was sint8... Is the 4.4 release expecting 0-255? I can easily change the data to 0-255 it would make more sense too. Up to you, hate to make you change stuff back and forth. You doing such a great job finding and fixing these little bugs.

As for the MovePC() It works as long as the target loc is "valid" If you would spawn below the world or in a wall/floor it just seems to move you inside the current enclosure. It is wierd how it works though.

Bigpull 06-14-2003 02:26 PM

Yes if you'll notice when i added the error printing that many doors are over 127, That pok book that wouldn't show up was -79, le oops. And honestly they likely are 0-255 actualy, but the code (minus the new door struct) was looking at -128 127.

About door_id, This only needs to be unique to the extend of if you click another door with the same door_id the client sends a click for the first door you sent. So in short you can link two port doors and only have to maintain one dest_ set

About open_type, these really really need documented.

IAsoulfood 06-15-2003 02:17 PM

Lurker_005
 
Lurker_005,
The doors jam bud.
Again http://my.core.com/~tgarland/doors.zip
This time there are two files inside the zip one is doors.sql and other is doors.csv. doors.sql is all my doors except your TOFS which I do not have at this moment and doors.csv makes this step easier for you...it is only the POK and destination portal/doors that I have fixed/updated. Hope that it makes it faster for you since there are less than 30 total =)
The reason is all POK portal/doors are working properly. It is the only thing I have verified. I spent a hell of a long time working on exact locations etc... Because portal/doors that zone somewhere CANNOT have a negative door_id they must be positive or they will not show up in the zone I correctly about 7 of those along with all the corresponding books in the zones your supposed to go to from the POK like Plane of Tranquility and the rest all work back and forth properly =)
Please update this in your doors.sql with the TOFS information as I do not have this info installed yet and it'd be cool to have it all together.
I'm to tired at this point to clean it up and make it a prettier package for ya bud. LMAO
Reply when you have it updated with a URL and I'll download then.
Thanks again,
Soulfood.


All times are GMT -4. The time now is 12:52 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.