Jump to content
  • 0

import/item_db.txt not working?


Question

Posted

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)

 

 

2 answers to this question

Recommended Posts

  • 0
Posted

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;','','');

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...