Zoning z coord issues in 5.9 DR2 Rev 1.7

[sdabbs65]

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

[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

[cavedude]

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.

[sdabbs65]

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....

[Edgar1898]

yah try to set the zone underworld coords for that zone, let me know if you guys have any more problems with that

[cavedude]

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.

[finwe]

can u explain better how you repare that problem i have the same problen and can t understand this solution... tks

[sotonin]

nevermind I fixed it by resourceing ZONECFG.sql.

What more is there to explain?

[finwe]

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

[RangerDown]

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:

[finwe]

i got the zone.sql and zonecfg.sql from http://cvs.sourceforge.net/viewcvs.py/eqemulator/EQEmuCVS/SQL-Files/

source zone.sql;
source zonecfg.sql;

And i got this problem :(
Anybody knows what can be happen? tks

[Speedz]

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.

[finwe]

same problem :(
I can t fix it

[sotonin]

get 6.0 WR when its out. It's on CVS now. but some files are missing til LE updates them. should solve this.

[finwe]

i can t find the file :( can u give me the link to it pls... tk you

[sotonin]

read the news

[finwe]

where can i find them... pls help me i m a newbie and can t find them...

nothing in http://www.projecteq.net/
nothing in http://sourceforge.net/cvs/?group_id=88515

or at least i can t find them...

tks

I currently running 5.9DR2 server with classic PEQ 85 data base and having the zoneing problem :( (tryed to resource zone.sql and zonecfg.sql with no luck )

[sdabbs65]

where can i find them... pls help me i m a newbie and can t find them...

nothing in http://www.projecteq.net/
nothing in http://sourceforge.net/cvs/?group_id=88515

or at least i can t find them...

tks

I currently running 5.9DR2 server with classic PEQ 85 data base and having the zoneing problem :( (tryed to resource zone.sql and zonecfg.sql with no luck )

try here

http://cvs.sourceforge.net/viewcvs.py/eqemulator/EQEmuCVS/

[finwe]

yep i read all the files in this link tons of times but can t find any news or wr6.0 ...
can you give me the exact name of the file or files pls?

tk u and sorry u can be sure i m trying it )

[sotonin]

http://www.eqemulator.net/forums

again, read the news