EQEmulator Forums - read this if you are using heavily customized items and 669 nudes your players

use this to update the item table structure , check after UNK129 to see what is missing and modify as needed.

Code:

ALTER TABLE `items` 



ADD COLUMN `clickname` varchar(64) NOT NULL default '0' AFTER `UNK129`,

ADD COLUMN `procname` varchar(64) NOT NULL default '0' AFTER `clickname`,

ADD COLUMN `wornname` varchar(64) NOT NULL default '0' AFTER `procname`,

ADD COLUMN `focusname` varchar(64) NOT NULL default '0' AFTER `wornname`,

ADD COLUMN `scrollname` varchar(64) NOT NULL default '0' AFTER `focusname`,

ADD COLUMN `dsmitigation` smallint(6) NOT NULL default '0' AFTER `scrollname`,

ADD COLUMN `heroic_str` smallint(6) NOT NULL default '0' AFTER `dsmitigation`,

ADD COLUMN `heroic_int` smallint(6) NOT NULL default '0' AFTER `heroic_str`,

ADD COLUMN `heroic_wis` smallint(6) NOT NULL default '0' AFTER `heroic_int`,

ADD COLUMN `heroic_agi` smallint(6) NOT NULL default '0' AFTER `heroic_wis`,

ADD COLUMN `heroic_dex` smallint(6) NOT NULL default '0' AFTER `heroic_agi`,

ADD COLUMN `heroic_sta` smallint(6) NOT NULL default '0' AFTER `heroic_dex`,

ADD COLUMN `heroic_cha` smallint(6) NOT NULL default '0' AFTER `heroic_sta`,

ADD COLUMN `heroic_pr` smallint(6) NOT NULL default '0' AFTER `heroic_cha`,

ADD COLUMN `heroic_dr` smallint(6) NOT NULL default '0' AFTER `heroic_pr`,

ADD COLUMN `heroic_fr` smallint(6) NOT NULL default '0' AFTER `heroic_dr`,

ADD COLUMN `heroic_cr` smallint(6) NOT NULL default '0' AFTER `heroic_fr`,

ADD COLUMN `heroic_mr` smallint(6) NOT NULL default '0' AFTER `heroic_cr`,

ADD COLUMN `heroic_svcorrup` smallint(6) NOT NULL default '0' AFTER `heroic_mr`;