Go Back   EQEmulator Home > EQEmulator Forums > Archives > Archive::Development > Archive::Database/World Building

Archive::Database/World Building Archive area for General Discussion's posts that were moved here after an inactivity period of 90 days.

Reply
 
Thread Tools Display Modes
  #1  
Old 02-12-2003, 10:45 AM
quax
Fire Beetle
 
Join Date: Feb 2003
Posts: 6
Default 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;
Reply With Quote
  #2  
Old 02-12-2003, 11:34 AM
moonphoenix
Sarnak
 
Join Date: Feb 2003
Posts: 81
Default

I cant access the links you posted :cry:
Reply With Quote
  #3  
Old 02-12-2003, 10:59 PM
Mauritius
Sarnak
 
Join Date: Mar 2002
Location: Neriak
Posts: 61
Default

they work for me :P
Reply With Quote
  #4  
Old 02-13-2003, 01:22 AM
moonphoenix
Sarnak
 
Join Date: Feb 2003
Posts: 81
Default

They work for me this morning.


(Note to self: Don't be so impatient and fussy)
Reply With Quote
  #5  
Old 02-13-2003, 02:56 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

You guys test this out real well, and I'll merge it into the db.sql.
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
Reply With Quote
  #6  
Old 02-13-2003, 04:24 AM
moonphoenix
Sarnak
 
Join Date: Feb 2003
Posts: 81
Default

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'
Reply With Quote
  #7  
Old 02-20-2003, 12:18 PM
quax
Fire Beetle
 
Join Date: Feb 2003
Posts: 6
Default

UPDATE 022003-2_Faydwer
Reply With Quote
  #8  
Old 02-21-2003, 08:22 AM
Drawde
Dragon
 
Join Date: Jan 2002
Posts: 521
Default

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!
Reply With Quote
  #9  
Old 02-21-2003, 08:39 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

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 !
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
Reply With Quote
  #10  
Old 02-21-2003, 11:31 PM
quax
Fire Beetle
 
Join Date: Feb 2003
Posts: 6
Default

SOON.
Reply With Quote
  #11  
Old 02-22-2003, 12:11 AM
Trumpcard
Demi-God
 
Join Date: Jan 2002
Location: Charlotte, NC
Posts: 2,614
Default

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!
__________________
Quitters never win, and winners never quit, but those who never win and never quit are idiots.
Reply With Quote
  #12  
Old 02-23-2003, 02:58 AM
quax
Fire Beetle
 
Join Date: Feb 2003
Posts: 6
Default

UPDATE 022303-Kunark
Reply With Quote
  #13  
Old 02-27-2003, 02:24 AM
quax
Fire Beetle
 
Join Date: Feb 2003
Posts: 6
Default

UPDATE 022703-Kunark
Reply With Quote
  #14  
Old 02-28-2003, 07:33 AM
Drawde
Dragon
 
Join Date: Jan 2002
Posts: 521
Default

A small bug to report - the Z coordinate for the safe point in Field of Bone should be -55, not -554.
Reply With Quote
  #15  
Old 02-28-2003, 04:22 PM
quax
Fire Beetle
 
Join Date: Feb 2003
Posts: 6
Default

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
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 11:50 PM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3