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

[Davood]

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


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`;

[Davood]

whoops forgot

`heroic_svcorrup` smallint(6) NOT NULL default '0',
`healamt` smallint(6) NOT NULL default '0',
`spelldmg` smallint(6) NOT NULL default '0',
`clairvoyance` smallint(6) NOT NULL default '0',
`backstabdmg` smallint(6) NOT NULL default '0',