View Single Post
  #1  
Old 06-19-2009, 03:20 AM
Davood
Discordant
 
Join Date: Jan 2005
Posts: 488
Default 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`;
__________________
----------
Demon Overlord of Alakamin
skype @ davoodinator
Reply With Quote