emci Posted March 28, 2016 Posted March 28, 2016 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) Quote
0 Poring King Posted March 28, 2016 Posted March 28, 2016 there is another way . You can use your main item_db , but dont skip your problem fix your import file 1 Quote
0 emci Posted March 28, 2016 Author Posted March 28, 2016 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;','',''); Quote
Question
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)
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.