after i sourced in mw_052_053_alpha2.sql and walk into a zone line, client hangs and zone server gives error something about start zone or zone id(had to wipe DB so dont have exact error handy) and trying to send player to arena, simple fix was to use static zones. looking at the db.sql source and the source from mw_052_053_alpha2.sql they are a little diffrent.
Quote:
from db.sql
CREATE TABLE start_zones (
x float NOT NULL default '0',
y float NOT NULL default '0',
z float NOT NULL default '0',
zone_id int(4) NOT NULL default '0',
player_deity int(4) NOT NULL default '0',
player_race int(4) NOT NULL default '0',
player_class int(2) NOT NULL default '0',
player_choice int(2) NOT NULL default '0'
) TYPE=MyISAM;
from mw_052_053_alpha2
CREATE TABLE start_zones (
x float NOT NULL default '0',
y float NOT NULL default '0',
z float NOT NULL default '0',
zone_id int(4) NOT NULL default '0',
bind_id int(4) NOT NULL default '0',
player_choice int(2) NOT NULL default '0',
player_class int(2) NOT NULL default '0',
player_deity int(4) NOT NULL default '0',
player_race int(4) NOT NULL default '0',
start_zone int(4) NOT NULL default '0'
) TYPE=MyISAM;
|
could the restructure of this table be causeing it?