EQEmulator Forums - Zone_Point DATABASE fix ~Velious

Page 1 of 2

Show 40 post(s) from this thread on one page

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - Zone_Point DATABASE fix ~Velious (https://www.eqemulator.org/forums/showthread.php?t=5157)

quax	02-12-2003 10:45 AM

Zone_Point DATABASE fix ~Velious

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

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

All times are GMT -4. The time now is 10:38 AM.

Page 1 of 2

Show 40 post(s) from this thread on one page