View Single Post
  #2  
Old 03-10-2003, 12:38 AM
TheOne
Sarnak
 
Join Date: Sep 2002
Location: Montreal, QC
Posts: 47
Default yup

yeah there are a few changes with 0.4.3.

Added " minstatus smallint(5) not null default 0, " to guilds
Added " npc_spells_id int(11) unsigned not null default '0', " to npc_types
Removed " usedspells varchar(70) NOT NULL default '', " from Npc_Types
Added " zoneid smallint(5) not null default '0', " to character_

And they added these two tables

Quote:
Create Table npc_spells (
id int(11) unsigned not null auto_increment primary key,
name tinytext,
parent_list int(11) unsigned not null default 0,
attack_proc smallint(5) not null default -1,
proc_chance tinyint(3) not null default 3
);
create table npc_spells_entries (
id int(11) unsigned not null auto_increment primary key,
npc_spells_id int(11) not null,
spellid smallint(5) not null default 0,
type smallint(5) unsigned not null default 0,
minlevel tinyint(3) unsigned not null default 0,
maxlevel tinyint(3) unsigned not null default 255,
manacost smallint(5) not null default '-1',
recast_delay int(11) not null default '-1',
priority smallint(5) not null default 0,
index npc_spells_id (npc_spells_id)
);
I think thats it.
__________________
Good, bad ... I'm the guy with the gun.
Reply With Quote