Crescent Reach Lifts... anyone have?

[Thovar]

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

[trevius]

Originally Posted by Thovar

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

[Thovar]

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.

[Tilar]

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.

[Fritzism]

Originally Posted by Tilar

I got an error on line four when I tried importing the one for doors and I still have nothing.

Originally Posted by Secrets

INSERT INTO doors
(`id`, `doorid`, `zone`, `version`, `name`, `pos_y`, `pos_x`, `pos_z`, `heading`, `opentype`, `guild`, `lockpick`, `keyitem`, `nokeyring`, `triggerdoor`, `triggertype`, `doorisopen`, `door_param`, `dest_zone`, `dest_x`, `dest_y`, `dest_z`, `dest_heading`, `invert_state`, `incline`, `size`, `buffer`, `is_ldon_door`)
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, 100, 0, 0);

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.

[Thovar]

@Tilar....

Teleport man code

sub EVENT_SPAWN
{
$x = $npc->GetX();
$y = $npc->GetY();
quest::set_proximity($x - 100, $x + 100, $y - 100, $y + 100);
}

sub EVENT_ENTER
{
quest::movepc(zoneID, x, y, z, heading);
}

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.

[Thovar]

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...

(13220, 4, 'crescent ', 0, 'OBJ_GEARSB ', -1299.59, -1541.26, -93.25, 0, 105, 0, 0, 0, 0, 0, 0, 1, -1, 'NONE ', 0, 0, 0, 0, 0, 1, 184, 100, 0);

so they should all be...

(13220,4,'crescent',0,'OBJ_GEARSB',-1299.59,-1541.26,-93.25,0,105,0,0,0,0,0,0,1,-1,'NONE',0,0,0,0,0,1,184,100,0);

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

Once Again, thank you Trevius AND secrets!!!