Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Bug Reports

Development::Bug Reports Post detailed bug reports and what you would like to see next in the emu here.

Reply
 
Thread Tools Display Modes
  #1  
Old 10-10-2004, 01:04 AM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default Zoning z coord issues in 5.9 DR2 Rev 1.7

seems no matter what zone your in you get stuck and can't move
safecoords are 0 0 0 but that location is beneath the world.
even tho it's really not.

world
Zoneserver SetZone: 6.21.24.15:8780 gfaydark (54)
Received unknown opcode: 0x0376 size:0 bytes

Zone
Unknown opcode: 0x037b size:12 Client:bob
0: DA 01 00 00 00 00 00 00 - 00 00 00 00 | ............
Unknown opcode: 0x01e5 size:8 Client:bob
0: 0A 00 00 00 5A C9 FD B3 | ....Z...
[Status] Zoning 'Kobobbit' to: steamfont (56) x=0.000000, y=0.000000, z=0.000000
Reply With Quote
  #2  
Old 10-10-2004, 04:22 AM
Edgar1898
Senior Member
Former EQEmu Developer
Current EQ2Emu Lead Developer
 
Join Date: Dec 2002
Posts: 1,065
Default

get stuck? I never got stuck in any zone, how are you getting stuck? Also the safe coords for steamfont are:
(x,y,z) -273, 160, -21

and the underworld is -222. All your current problems might be db related. Try sourcing the zone.sql file below:

http://www.eqemulator.net/zone.sql
__________________
Lethal Encounter
Reply With Quote
  #3  
Old 10-10-2004, 04:42 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

I have this same problem, except for me its only a couple of zones so I don't really pay it much attention. What I have found is that the safe coords are correct in the database, and you do indeed zone into the right spot, at least according to /loc, and my observation. However, you can't move, and the screen scrolls Player is underworld at 0,0,0 (which is odd becuase /loc tells you that you are not at 0,0,0) moving to safe coords (not word for word of course) I have found that as you attempt to move (which you cannot) the coords that scroll with the underworld message changes. #goto, #zone with the coords, and #flymode do not move you, and the old jump free method does not move you. The only way out of the zone is to #zone.
Reply With Quote
  #4  
Old 10-10-2004, 04:57 AM
sdabbs65
Dragon
 
Join Date: Dec 2003
Location: Earth
Posts: 818
Default your right

Quote:
Originally Posted by Edgar1898
get stuck? I never got stuck in any zone, how are you getting stuck? Also the safe coords for steamfont are:
(x,y,z) -273, 160, -21

and the underworld is -222. All your current problems might be db related. Try sourcing the zone.sql file below:

http://www.eqemulator.net/zone.sql
nevermind I fixed it by resourceing ZONECFG.sql.

wierd....
Reply With Quote
  #5  
Old 10-10-2004, 05:02 AM
Edgar1898
Senior Member
Former EQEmu Developer
Current EQ2Emu Lead Developer
 
Join Date: Dec 2002
Posts: 1,065
Default

yah try to set the zone underworld coords for that zone, let me know if you guys have any more problems with that
__________________
Lethal Encounter
Reply With Quote
  #6  
Old 10-10-2004, 06:33 AM
cavedude's Avatar
cavedude
The PEQ Dude
 
Join Date: Apr 2003
Location: -
Posts: 1,988
Default

Ah ha! That worked. Thanks, LE. The few zones I had problems with had underworld set at 0, and safe Z of 0. I made the underworld negative and the zones all work fine now.
Reply With Quote
  #7  
Old 10-12-2004, 08:51 AM
finwe
Sarnak
 
Join Date: Oct 2004
Posts: 42
Default

can u explain better how you repare that problem i have the same problen and can t understand this solution... tks
Reply With Quote
  #8  
Old 10-12-2004, 09:18 AM
sotonin
Demi-God
 
Join Date: May 2004
Posts: 1,177
Default

Quote:
nevermind I fixed it by resourceing ZONECFG.sql.
What more is there to explain?
Reply With Quote
  #9  
Old 10-12-2004, 09:24 AM
finwe
Sarnak
 
Join Date: Oct 2004
Posts: 42
Default

well i did it and i got:


mysql> source zonecfg.sql;
ERROR 1060: Duplicate column name 'underworld'
ERROR 1060: Duplicate column name 'minclip'
ERROR 1060: Duplicate column name 'maxclip'
ERROR 1060: Duplicate column name 'fog_minclip'
ERROR 1060: Duplicate column name 'fog_maxclip'
ERROR 1060: Duplicate column name 'fog_blue'
ERROR 1060: Duplicate column name 'fog_red'
ERROR 1060: Duplicate column name 'fog_green'
ERROR 1060: Duplicate column name 'sky'
ERROR 1060: Duplicate column name 'ztype'
ERROR 1060: Duplicate column name 'zone_exp_multiplier'
ERROR 1060: Duplicate column name 'walkspeed'
ERROR 1060: Duplicate column name 'time_type'
Query OK, 0 rows affected (0.02 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

Query OK, 0 rows affected (0.00 sec)
Rows matched: 1 Changed: 0 Warnings: 0

and have the same problem :(

any clue?
tks
Reply With Quote
  #10  
Old 10-12-2004, 09:34 AM
RangerDown
Demi-God
 
Join Date: Mar 2004
Posts: 1,066
Default

Ignore the duplicate column name errors. That file assumes you never had the table and tries to create the columns. The statistics after the errors (1 rows affected) mean that stuff is being changed. Hopefully for the better :lol:
__________________
<idleRPG> Rogean ate a plate of discounted, day-old sushi. This terrible calamity has slowed them 0 days, 15:13:51 from level 48.
Reply With Quote
  #11  
Old 10-12-2004, 09:44 AM
finwe
Sarnak
 
Join Date: Oct 2004
Posts: 42
Default

i got the zone.sql and zonecfg.sql from http://cvs.sourceforge.net/viewcvs.p...CVS/SQL-Files/

source zone.sql;
source zonecfg.sql;

And i got this problem :(
Anybody knows what can be happen? tks
Reply With Quote
  #12  
Old 10-14-2004, 02:29 PM
Speedz's Avatar
Speedz
Hill Giant
 
Join Date: Oct 2004
Location: Ocean Park, WA
Posts: 186
Default

I have had issues with zoneing ever since I started my 5.9dr2 server...


But oddly enough, I did something that totally corrupted my zone and item sections in my database, I wasn't fully paying attn. as I couldn't get my server to load properly and was in haste trying to get it back on.

I removed those 2 sections and sourced the zone and item sections seperatly (one at a time each)

Now I zone fine.

So what I am thinking is maybe if you use a full database sql file like barebones, 5.8 classic, etc...... then load a zones database for whatever reason, like to update for new zones or whatever. Somehow the second load might either corrupt the zone values or add double entries.

Not totally sure what fixed it, as I was in a rush, but it works great now.

I am useing the 5.9dr2 alpha 1 database that was just made.recently if that helps anyone.

Good luck and if all else fails backup and start over lol :-P.
__________________
Just another face in the crowd..
Reply With Quote
  #13  
Old 10-15-2004, 01:40 AM
finwe
Sarnak
 
Join Date: Oct 2004
Posts: 42
Default

same problem :(
I can t fix it
Reply With Quote
  #14  
Old 10-15-2004, 01:41 AM
sotonin
Demi-God
 
Join Date: May 2004
Posts: 1,177
Default

get 6.0 WR when its out. It's on CVS now. but some files are missing til LE updates them. should solve this.
Reply With Quote
  #15  
Old 10-15-2004, 02:28 AM
finwe
Sarnak
 
Join Date: Oct 2004
Posts: 42
Default

i can t find the file :( can u give me the link to it pls... tk you
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 05:33 AM.


 

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 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3