View Single Post
  #8  
Old 02-26-2004, 03:41 AM
smogo
Discordant
 
Join Date: Jan 2004
Location: 47
Posts: 339
Default

Quote:
NPCs loaded - using old database format
this is from update_invis.sql not being sourced. You will also need the quest_globals.sql


Quote:
Error in FinishConnState2(): !dbaq[1]->GetAnswer(): #1054: Unknown column 'revok
ed' in 'field list'
you need to update your account table. Look at http://www.eqemulator.net/forums/vie...hlight=revoked


Quote:
[Error] Error Loading Objects from DB: #1054: Unknown column 'zoneid' in 'field
list'
Not sure what source you need, but the following works fine for me
Code:
CREATE TABLE object (
  id int(11) NOT NULL auto_increment,
  zoneid int(11) unsigned NOT NULL default '0',
  xpos float NOT NULL default '0',
  ypos float NOT NULL default '0',
  zpos float NOT NULL default '0',
  heading float NOT NULL default '0',
  itemid int(11) NOT NULL default '0',
  charges tinyint(3) unsigned NOT NULL default '0',
  objectname varchar(16) NOT NULL default '',
  type int(11) NOT NULL default '0',
  icon int(11) NOT NULL default '0',
  linked_list_addr_01 int(11) NOT NULL default '0',
  linked_list_addr_02 int(11) NOT NULL default '0',
  unknown08 mediumint(5) NOT NULL default '0',
  unknown10 mediumint(5) NOT NULL default '0',
  unknown20 int(11) NOT NULL default '0',
  unknown24 int(11) NOT NULL default '0',
  unknown60 int(11) NOT NULL default '0',
  unknown64 int(11) NOT NULL default '0',
  unknown68 int(11) NOT NULL default '0',
  unknown72 int(11) NOT NULL default '0',
  unknown76 int(11) NOT NULL default '0',
  unknown84 int(11) NOT NULL default '0',
  unknown88 int(11) NOT NULL default '0',
  PRIMARY KEY  (id)
) TYPE=MyISAM;
check if it is the same for you, and update as needed.


'hope this helps.