Patching More Custom Items

[Deewad]

Here is a easy way to patch custom items, Just simply add this SQL To World Database, Fill in the columns when making a new item, Then Export it, And save it as, Example.csv, Then take ur DBC Editor and open Item.dbc and import that CSV.

Hope it helps

DROP TABLE IF EXISTS `aa_item_dbc`;
CREATE TABLE `aa_item_dbc` (
  `id` INT(11) NOT NULL DEFAULT '0',
  `class` INT(11) NOT NULL DEFAULT '0',
  `subclass` INT(11) NOT NULL DEFAULT '0',
  `SoundOverrideSubclass` INT(11) NOT NULL DEFAULT '0',
  `material` INT(11) NOT NULL DEFAULT '0',
  `displayid` INT(11) NOT NULL DEFAULT '0',
  `inventorytype` INT(11) NOT NULL DEFAULT '0',
  `sheath` INT(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
);

ALTER TABLE `aa_item_dbc`   
  CHANGE `id` `id` VARCHAR(255) DEFAULT '0'   NOT NULL,
  CHANGE `class` `class` VARCHAR(255) DEFAULT '0'   NOT NULL,
  CHANGE `subclass` `subclass` VARCHAR(255) DEFAULT '0'   NOT NULL,
  CHANGE `SoundOverrideSubclass` `SoundOverrideSubclass` VARCHAR(255) DEFAULT '0'   NOT NULL,
  CHANGE `material` `material` VARCHAR(255) DEFAULT '0'   NOT NULL,
  CHANGE `displayid` `displayid` VARCHAR(255) DEFAULT '0'   NOT NULL,
  CHANGE `inventorytype` `inventorytype` VARCHAR(255) DEFAULT '0'   NOT NULL,
  CHANGE `sheath` `sheath` VARCHAR(255) DEFAULT '0'   NOT NULL, 
  DROP PRIMARY KEY;

INSERT INTO `aa_item_dbc` VALUES ('int','int','int','int','int','int','int','int');

INSERT INTO `aa_item_dbc`
SELECT
`item_template`.entry,
`item_template`.class,
`item_template`.subclass,
`item_template`.SoundOverrideSubclass,
`item_template`.Material,
`item_template`.displayid,
`item_template`.InventoryType,
`item_template`.sheath 
FROM `item_template` WHERE `item_template`.entry = `item_template`.entry;

Credits: Anthony-Toolbox

 

[AlexeWarr]

thx for share didnt knew the last part with insert

 

[Deewad]

Yeah, No prob, Thanks for the reply

 

[Tommy]

Thanks for the share!

 

[ToxicDev]

Could least give credits to anthony toolbox. But ty for the share i suppose.

 

[Deewad]

Sorry, Didn't realize this was his release, I've had this script for a long time, Sorry Anthony

 

[Selik]

This should be helpful. Thanks!