Log in

View Full Version : Zone_Point DATABASE fix ~Velious

quax
02-12-2003, 10:45 AM
Zone_Point DATABASE fix
compatible with EQEmu 0.4.2 zone DB.

:!: Use at your own risk.

UPDATE 02/28/2003
022803_Velious_sql.zip

Antonica
Odus
Faydwer
Kunark
Velious

http://zonefix.no-ip.com/tmp/readme.txt
http://zonefix.no-ip.com/tmp/022803_Velious_sql.zip


--z42to43.sql
update zone set safe_z = safe_z*.1;
update zone_points set z = z*.1;
update zone_points set target_z = target_z*.1;
mysql>use *yr dbname*;
mysql>source z42to43.sql;
moonphoenix
02-12-2003, 11:34 AM
I cant access the links you posted :cry:
Mauritius
02-12-2003, 10:59 PM
they work for me :P
moonphoenix
02-13-2003, 01:22 AM
They work for me this morning.


(Note to self: Don't be so impatient and fussy)
Trumpcard
02-13-2003, 02:56 AM
You guys test this out real well, and I'll merge it into the db.sql.
moonphoenix
02-13-2003, 04:24 AM
Is this a global fix or only applies to certain zones?
There seems to be no improvement in Greater Faydark, but I've not had time to test it further.
If anybody wants to verify my opinion, my server is the '[TPCNET] Test Server'
quax
02-20-2003, 12:18 PM
UPDATE 022003-2_Faydwer :D
Drawde
02-21-2003, 08:22 AM
Works really well, great work - most zone points actually work correctly now, rather than putting
you either at the safe point, 200 feet in the air, or in the "safe box". You can now actually get into
Qeynos Catacombs, using any of the wells or secret entrances - unfortunately there are no NPCs as they
all have the wrong Z coordinates - a spawnlog for this zone would be very handy!
Trumpcard
02-21-2003, 08:39 AM
If this is the most up to date version, I'm going to roll it into the db.sql so the next releases will have the proper values.

Thanks for the fix !
quax
02-21-2003, 11:31 PM
SOON.:D
Trumpcard
02-22-2003, 12:11 AM
Awesome quax, do me a favor and when you get them completed, do a mysqldump of the full tables, then I can just replace the structure in db.sql..

Thanks!
quax
02-23-2003, 02:58 AM
UPDATE 022303-Kunark :D
quax
02-27-2003, 02:24 AM
UPDATE 022703-Kunark :D
Drawde
02-28-2003, 07:33 AM
A small bug to report - the Z coordinate for the safe point in Field of Bone should be -55, not -554.
quax
02-28-2003, 04:22 PM
Hi Drawde. :)

It seems that some problems are in the treatment of Z value in safepoint in EQEmu4.2.
I made it Z value which functions normally by #zone command.

Thank you for a report.

P.S.
Sorry. I am not good at English. :wink:

And.

UPDATE 022803-Velious :D
AchTR
03-02-2003, 12:23 AM
Just so you know, a lot of zones were giving errors when I installed your sql. Off the top of my head they were:

veeshan
kaladimb
kael
chardok

I know, not many but I didn't test many either (I was setting up spawn tables and loot tables in these zones)

Installing the default db.sql safe zone points fixes everything immeadiately.