Crescent Reach Lifts... anyone have?
 

Anyone have lifts in crescent reach actually working? if so, any chance of posting the table info for them? I can't seem to get them to even show up, which is sad. Hoping someone was succesful already in this venture and is kind enough to share.

Got lifts to show up, but...
 

Seems I figured out why I couldnt get them to show up. new problems...

1. using opentypes 60+ make the lift visible but you are not able to step on it. if I use opentype 54, 58 or 59 I can step on it, but it doesnt raise the right amount.
2. what does version do? if I use anything other than 0 it makes it invisible.

While writing this I got distracted, came back and forgot I was asking for help. turns out i figured it out.

I use version 0, opentype 59 and doorparam I set to something larger than 0 (the amount I want the lift to raise to be exact) and I have them working.

the beautiful things that happen when you step away for a minute and come back. hope this helps other people who where doing trial and error like i was. when I get the crescent reach lifts 100% correct, I will probably post them for all.

For you to get all of the stuff in the doors table to get Crescent Reach 100% accurate would be nearly impossible to do manually :P

Luckily, I took the time a while back to collect the door packets from Live in Crescent and manually convert each packet into a database entry.

I don't have the actual MySQL handy for you to run, but you should be able to use this info to get your doors all running 100% perfectly:

Doors Table:
Objects Table:
If we had the packet collectors working, it would have made easy work of getting this info into the database. Unfortunately since they don't work yet, I had to convert each one by hand. Luckily between using notepad++ and textpad macros, I was able to automate a good portion of the process. Then, I still had to convert each loc using winhex. After that, it just took some minor testing and adjustments where needed to tie triggers to lifts, and to get the waterwheels to rotate properly and such.

I meant to post these for you when you first asked the question, but had read it from work and wanted to post the actual MySQL to make it easier, and I don't have access to that from work. At work again, so I still don't have the mysql, but this info shouldn't be too hard for you to get into your tables if you use Navicat.

I have been waiting to see if PEQ ever starts work on SoF to post more of the zones I have done this for. It is only a few so far anyway.

Objects:

Doors

You both kick so much Arse right now.

1. for you Trev posting that, which is 100% usable by me since I understand mysql very well.

2. for you secrets of posting the sql parts.

That is much more than I expected, I was only trying to get the two lifts inside and the two lifts outside, but the fact you gave me the doors and objects is just amazing!!! If I could give you a high five, this would be the time!

You guys really made my day coming home from a 10.5 hour shift at work dealing with customers at my tech support job by saving me so much time, those doors and objects was next on my list since I noticed random fire in the middle of the room and other missing items.

Again, thank you both SO MUCH.

p.s. when I get some really cool stuff done with the TSS zones I am working with I will get them posted (I have two more zone lines to get to work properly for TSS zones, but for the most part they are 96% complete and ready to use by anyone. Stonehive zone line is giving me a rough time, cant get it to work, think I might be using an invis 240 race guy as a teleporter when someone enters his proximity, when I get that done I'll post.)

Yeah, I couldn't figure out Stone Hive zone line either, so I just had to use an invis guy with a proximity to simulate it just like you are saying.

Also, you do know that there are doors and lifts in Stone Hive as well, right? :P

Hrmm, wasn't aware of any lifts in stone hive, never ventured too far in since I couldnt get the zone line to work... great LOL. I hope getting doors and lifts in wont be impossible like the stupid zone line.

Luckily I have a script for the teleport man so all hope is not lost. I did get the door to vergalids mine to work both ways and since I found out how to do lifts in crescent reach I will be adding in the one in the mine as well and the one(s) in stonehive if I can get them to work. thanks for the heads up on stonehive. Looks like the Super Ultra Mega Bixie Queen of the Stone will have to wait to be spawned.

I got an error on line four when I tried importing the one for doors and I still have nothing. I am learning but my knowledge of this is still very limited so I wasnt surprised when I couldnt find anything wrong. =)

Found a script for the inviz zone line guy... I should put something like that in neriak because my nektulos forest is apparently fubared.

I see a missing '0' in here, should be :

VALUES
(13252, 36, 'crescent ', 0, 'OBJ_CRDOOR ', -1634.56, -1550.82, -90.255, 126, 0, 0, 0, 0, 0, 0, 0, 0, -1, 'NONE ', 0, 0, 0, 0, 0, 0, 100, 0, 0);

I think.

@Tilar....

Teleport man code

its that easy. just name it the NPCID.pl... so example would be 100999.pl put in the right zone for that NPC. Also for nektulos being fubared... make sure you have the right client map being used when playing in EQ. find nektulos.egq and rename it to .bak instead. that is the usual fix.

Error in SQL.
 

Well not a "real" error, but each of the line you made Secrets all have an extra space in them, which in turn makes mysql think the name of the object and zone is "OBJ_LIFT_" instead of just "OBJ_LIFT" so if anyone is going to copy and paste the above, take out the spaces in all the names. I still say "thank you" for making these easy for everyone to input into their own DB's

Notice all the spaces...

so they should all be...

They will work if you take out the spaces. in ALL of them.

Once Again, thank you Trevius AND secrets!!!

Thanks Thovar, I appreciate that!

I did get into a strange version of Nek forest before I got the old one working. I started playing EQ back in 99 within a couple weeks
of release and have never seen this version of Nektulos. Very small zone, probably less than 1/3 the size of the regular zone.
Anyone see any of this before?


http://i64.photobucket.com/albums/h1.../NekBridge.jpg
http://i64.photobucket.com/albums/h1.../NekForest.jpg
http://i64.photobucket.com/albums/h1...emu/Neriak.jpg

So should it look like this? I have a "notepad" replacement that I use that makes this easy.

Object

Doors

Yes!!! that is perfect! and yes... that version is the strange version, shaped kinda odd... looks like the hidden forest hub zone, although, they use an instance that was directly off that zone before they revamped nek for the 3rd time and took out that monster mission from DODH

Here are the doors for StoneHive:

I don't recall there being any objects in the zone. Oh, BTW, I think the objects in Crescent that I posted have 2 PoKBooks that are not actually in the official zone. I added those in later for some custom travel stuff I was working on. So, you can remove those easy enough if you don't need them..