View Single Post
  #6  
Old 11-26-2003, 03:24 AM
Edgar1898
Senior Member
Former EQEmu Developer
Current EQ2Emu Lead Developer
 
Join Date: Dec 2002
Posts: 1,065
Default

for those of you with outdated dbs run the following sql queries:

Code:
alter table character_ add timelaston int(11) unsigned default '0';
alter table character_ add publicnote varchar(100) NOT NULL default '';


CREATE TABLE ground_spawns (
  id int(11) unsigned NOT NULL auto_increment,
  zoneid int(10) unsigned NOT NULL default '0',
  max_x float NOT NULL default '2000',
  max_y float NOT NULL default '2000',
  max_z float NOT NULL default '10000',
  min_x float NOT NULL default '-2000',
  min_y float NOT NULL default '-2000',
  heading float NOT NULL default '0',
  name varchar(16) NOT NULL default '',
  item int(10) unsigned NOT NULL default '0',
  max_allowed int(10) unsigned NOT NULL default '1',
  respawn_timer bigint(20) unsigned NOT NULL default '300000',
  comment varchar(255) NOT NULL default '',
  PRIMARY KEY  (id)
) TYPE=MyISAM;



#
# Dumping data for table 'ground_spawns'
#

INSERT INTO ground_spawns VALUES("1", "54", "2400", "2400", "10000", "-2400", "-2400", "0", "IT403_ACTORDEF", "22119", "50", "Evergreen Leaves for Gfay");
INSERT INTO ground_spawns VALUES("2", "68", "3000", "3000", "10000", "-3000", "-3000", "0", "IT403_ACTORDEF", "16490", "50", "Oak Bark For Butcherblock");
That should fix any issues you have with an outdated db. As always with a new release you need to update your database with the new tables and definitions released with the emu. Look on sourceforge for the table definitions for each release.
__________________
Lethal Encounter
Reply With Quote