Zone_Point DATABASE fix ~Velious

quax · #1 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

Code:

--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 · #2 02-12-2003, 11:34 AM

I cant access the links you posted :cry:

Mauritius · #3 02-12-2003, 10:59 PM

they work for me :P

moonphoenix · #4 02-13-2003, 01:22 AM

They work for me this morning.

(Note to self: Don't be so impatient and fussy)

Trumpcard · #5 02-13-2003, 02:56 AM

You guys test this out real well, and I'll merge it into the db.sql.

moonphoenix · #6 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 · #7 02-20-2003, 12:18 PM

UPDATE 022003-2_Faydwer

Drawde · #8 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 · #9 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 · #10 02-21-2003, 11:31 PM

SOON.

Trumpcard · #11 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 · #12 02-23-2003, 02:58 AM

UPDATE 022303-Kunark

quax · #13 02-27-2003, 02:24 AM

UPDATE 022703-Kunark

Drawde · #14 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 · #15 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.

And.

UPDATE 022803-Velious