Here's some LoY work for PEQ

John Adams · #1 08-03-2006, 09:45 AM

Quote:

Originally Posted by hayward6

but if you use egress while inside or you use #zone to get there your stuck in solid rock.

I've actually seen that in a lot of zones. Once I get myself to a safe place, I reset the zsafecoords and zoning in is no longer a problem.

**hayward6** · #2 08-03-2006, 10:09 AM

Quote:

Originally Posted by John Adams

I've actually seen that in a lot of zones. Once I get myself to a safe place, I reset the zsafecoords and zoning in is no longer a problem.

I guess thats my question... how?

Angelox · #3 08-03-2006, 10:09 AM

I have a program I use a lot, it's called "MySQL Query Browser", You can get it from http://www.mysql.com/downloads/ , and its free - small stuff like putting in or changing to new zone coords are easy and quick with this as it gives you a "visual" on what you are doing. It also has a great "tutorial" on the bottom right hand corner.

or if you don't want to get into it, this should fix it;

Code:

REPLACE INTO zone VALUES ("nadox","","Crypt of Nadox",-643.06,-1349.17,-40.87,45,0,227,0,0,1,"",-2030,1500,2000,500,2000,0,0,0,0,255,0.75,0.4,2,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,0,0,0,500,2000,"",1);

Also on the grids for this zone; if you see they are not right, I think I had fixed a few of the old ones, aside from the new ones I made (mobs were walking through the walls and all), you might have to use REPLACE instead of INSERT

I still haven't figured out how to place the POK book in the Gulf of Gunthak - I just put in two translocator GMs (one in gunthak and one in POK, where the stone is supposed to be) - if you want the quests, I'll post them too.

**hayward6** · #4 08-03-2006, 10:15 AM

theres an error in that statement somewhere, this is where I suck at this project I know nothing about sql and its really starting to hurt.

**hayward6** · #5 08-03-2006, 11:35 AM

well, I got the x,y,z set but it still places me in the same bad spot.

**hayward6** · #6 08-03-2006, 12:37 PM

Quote:

Originally Posted by hayward6

well, I got the x,y,z set but it still places me in the same bad spot.

zoning in and using #zone works fine, I only get stuck in the wall when I use egress now... maybe thats adjusted somewhere else?

Angelox · #7 08-03-2006, 12:53 PM

Quote:

Originally Posted by hayward6

zoning in and using #zone works fine, I only get stuck in the wall when I use egress now... maybe thats adjusted somewhere else?

Whats egress?

**hayward6** · #8 08-03-2006, 09:48 PM

Quote:

Originally Posted by Angelox

Whats egress?

Druid spell that teleports you to the safe spot in a zone and clears agro.

The only real strong point I have with this project is the fact that I have been playing eq live for 7 years and I still do. So I know whats suposed to be for most zones.

jeffpuff · #9 08-10-2006, 11:46 AM

Thanks for adding your database to you website Angelox! I am at work now but hope to grab it when I get home, just have a couple questions...

1. Are you using Peq Luclin RC1 as your base?
2. Have you included Thristams PoK and Tranq work? (Thank you too Thristam)
3. I have done some work on spawn rates in Fungus Grove and added some missing named spawns ( such as Assassin in lguk... bards and thier needs to turn into dark elfs... ) is there an easy way to keep this work I have done and upgrade to your database? or by chance have you already taken care of these issues?

Just wanted to pick your brain for a second, as I am always looking for ways to upgrade my database with info from people smarter than me ; )

Jeff

Angelox · #10 08-10-2006, 12:22 PM

Quote:

Originally Posted by jeffpuff

Thanks for adding your database to you website Angelox! I am at work now but hope to grab it when I get home, just have a couple questions...

1. Are you using Peq Luclin RC1 as your base?
2. Have you included Thristams PoK and Tranq work? (Thank you too Thristam)
3. I have done some work on spawn rates in Fungus Grove and added some missing named spawns ( such as Assassin in lguk... bards and thier needs to turn into dark elfs... ) is there an easy way to keep this work I have done and upgrade to your database? or by chance have you already taken care of these issues?

Just wanted to pick your brain for a second, as I am always looking for ways to upgrade my database with info from people smarter than me ; )

Jeff

Hi, I'm using what ever came with the "Setup Guide For 0.7.0" which probably is still the newest one put up for download, and it is the PEQ database. But if you already have some work done and like to do your own work too, you'd be better off going through my web and sourcing in everything I posted. I just did that "backup-post" for anyone who had a new install. It does have Thristam's and a few others work in it also.
It's not hard to do, and once sourced, I'll always post whatever else I do, aside from the database-backup thing.
One thing I would ask of you is, to try an learn how to extract/post your work for us to share also.
And, I ain't that smart! these guys here are light years ahead of me. I'm just determined and stubborn

Angelox · #11 08-03-2006, 12:51 PM

Quote:

Originally Posted by hayward6

theres an error in that statement somewhere, this is where I suck at this project I know nothing about sql and its really starting to hurt.

The statement is corrrect, but didn't go in the forum properly - there are some zeros that get spread out, and make the error - go back to my site , I posted the SQL file there, or click here;
http://www.nahunta.org/~angelox/files/NadoxZone.sql

Don't let SQL scare you, it's not that hard.