import/item_db.txt not working?

[emci]

Hi guys,

 

I need some help making my server read db/import/item_db.txt to install custom items.

 

I'm not sure but it could be because I'm using packet version 53? or is there other way to implement my custom items?

 

(Using latest rAthena, Hex client 2015-09-16aRagexe.exe = packet 53)

 

 

[Poring King]

there is another way . You can use your main item_db , but dont skip your problem fix your import file

[emci]

any suggestion on how to fix the import file??

is there a txt file that listss all what it reads?

Sorry nevermind solved:

 

Only way to fix this is by going to SQL DB and creating your own script. I had nothing in my item_db2 so that's where I added my items

 

Here is the code if you need it Example custom shinobi hat.

 

 

DROP TABLE IF EXISTS `item_db2`;

CREATE TABLE `item_db2` (

  `id` smallint(5) unsigned NOT NULL DEFAULT '0',

  `name_english` varchar(50) NOT NULL DEFAULT '',

  `name_japanese` varchar(50) NOT NULL DEFAULT '',

  `type` tinyint(2) unsigned NOT NULL DEFAULT '0',

  `price_buy` mediumint(8) unsigned DEFAULT NULL,

  `price_sell` mediumint(8) unsigned DEFAULT NULL,

  `weight` smallint(5) unsigned NOT NULL DEFAULT '0',

  `attack` smallint(5) unsigned DEFAULT NULL,

  `defence` smallint(5) unsigned DEFAULT NULL,

  `range` tinyint(2) unsigned DEFAULT NULL,

  `slots` tinyint(2) unsigned DEFAULT NULL,

  `equip_jobs` int(10) unsigned DEFAULT NULL,

  `equip_upper` tinyint(2) unsigned DEFAULT NULL,

  `equip_genders` tinyint(1) unsigned DEFAULT NULL,

  `equip_locations` mediumint(7) unsigned DEFAULT NULL,

  `weapon_level` tinyint(1) unsigned DEFAULT NULL,

  `equip_level` tinyint(3) unsigned DEFAULT NULL,

  `refineable` tinyint(1) unsigned DEFAULT NULL,

  `view` smallint(5) unsigned DEFAULT NULL,

  `script` text,

  `equip_script` text,

  `unequip_script` text,

  PRIMARY KEY (`id`),

  UNIQUE INDEX `UniqueAegisName` (`name_english`)

) ENGINE=MyISAM;

 

REPLACE INTO `item_db2` VALUES (9200,'_shinobihat','Shinobi Hat',5,20,NULL,500,NULL,4,NULL,1,0xFFFFFFFF,31,2,256,NULL,0,1,1043,'bonus bAllStats,10; bonus2 bSubRace,RC_DemiHuman,15; bonus2 bAddRace,RC_DemiHuman,5;','','');