Problem with Zone Geometry/Safe coordinates
I am having an issue with zone geometry.. This is a brand new server build from the lastest svn of projecteqemu, projecteqdb, projecteqquests and eqemumaps. Sourced the rev.sql file and the load_player.sql file into MySQL. Using the Titanium client to connect. When I #zone into most zones, I start suspended above the ground. In others (such as iceclad), It loops saying that I am under the world and says it is putting me to safe coordinates, and then says I am under the world, etc. I then set my own safe coords using #zsafecoords and that usually will get me out of the loop, but: When I turn on flymode, I can travel a bit, but get stopped by invisible walls.
Any ideas how I can solve this problem or what I am doing wrong? Thanks, -Kefka |
Check your eqemu_debug_<ProcessIDNumber>.log file in the $EQEmu-Home-Directory$/server/logs directory - you might find in there a few references to a missing field ("suspendbuffs" field perhaps) on an SQL query in the 'zone' table (apparently the logic fails to the point where it allows a character to zone in, but places them at 0,0,0. So in certain locations like Halas you can move around as long as you don't try to cross an interface like a doorway, a stairway or like the raft and lake between Halas and Everfrost.
Best thing is to review the SQL patches at http://code.google.com/p/projecteqem.../utils/sql/svn and see if you're missing any elements in the zone table. Do this by first stopping your EQEmu server, than Logging to mysql and issuing the following commands: Code:
use <your EQEmu database name>; Code:
ALTER TABLE zone ADD suspendbuffs tinyint(1) unsigned NOT NULL DEFAULT 0; I have to admit, even though some of the set up information is fragmented a slight bit - the install with some searching of these forums to find the remedial actions for the small bugs resulted in a fully working world. I am extremely impressed as to the quality of the in-world experience. It's running virtualized quite nicely in Debian 5.x on one of my 2U servers running a VMWare/ESXi hypervisor. If I get some time later in the year, I might package it up as a ready-to-go EQEmu server VM appliance one could run with VMPlayer or other equivalent VM hypervisor (since VMWare not only provides free VM players/hypervisors, they also provide a free up/down converter for various VM products). |
Thanks
I just wanted to say thank you!
This solved my problem. I was setting up a new server with peqdb_rev1589.sql and I could get everything to work... except when I logged in, I was stuck in place. If I used #zone poknowledge (just an example of a new zone aside from tutorialb), I would then be stuck in that location as well. Thank you again! |
All times are GMT -4. The time now is 07:20 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.