If you are using the 5.2 builds and mw_052_053_alpha1.sql there is a problem in the zone_points table. It looks like the layout in dq.sql is very different than the layout in mw_052_053_alpha1.sql.
All of the fields are there but they are layed out differently. I was having the same problems with unknown opcodes untill i compared the databases and changed the zone_points table layout to match the db.sql layout. Once i did that most of the unkown opcode errors went away. I compared all of the tables and there are a few other tables with minor differences that i think are responsible for the few unknown opcodes i am still getting. The following tables had minor changes.
Start_Zones had the fields bind_id and player_choice missing in db.sql.
Tradeskillrecipe had the field product set as indexed with no duplicates in db.sql.
sharedbank had the field color missing in db.sql.
npc_types had a new field lastname in db.sql.
ground_spawns had the field respawn_timer missing in db.sql.
altadv_vars had the skill_id field set to not indexed in db.sql.
All the rest of the tables appeared to have the same structure and layout. And once i changed the zone_points table most of the unknown opcodes and crashes ended.
|