R> Txt 2 SQL Converter

[Samuel]

Hi everyone, just looking for a converter of the txt database of hercules to sql files.

I've already looked at the tools folder, but it seems to be not working the perl file.

This is what it only shows:

#
# Table structure for table `item_db`
#
 
DROP TABLE IF EXISTS `item_db`;
CREATE TABLE `item_db` (
  `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(10) unsigned default NULL,
  `price_sell` mediumint(10) unsigned default NULL,
  `weight` smallint(5) unsigned NOT NULL default '0',
  `attack` smallint(3) unsigned default NULL,
  `defence` tinyint(3) unsigned default NULL,
  `range` tinyint(2) unsigned default NULL,
  `slots` tinyint(2) unsigned default NULL,
  `equip_jobs` int(12) unsigned default NULL,
  `equip_upper` tinyint(8) unsigned default NULL,
  `equip_genders` tinyint(2) unsigned default NULL,
  `equip_locations` smallint(4) unsigned default NULL,
  `weapon_level` tinyint(2) unsigned default NULL,
  `equip_level` tinyint(3) unsigned default NULL,
  `refineable` tinyint(1) unsigned default NULL,
  `view` smallint(3) unsigned default NULL,
  `script` text,
  `equip_script` text,
  `unequip_script` text,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

And I think its really not yet updated, xD

Thanks in advance to anyone.

 

[Samuel]

bump anyone?

any one who knows perl much who can redo the script? xD

 

[Samuel]

maybe we could use of this converter from rathena, xD

I just don't understand perl.

With this converter, we can convert not just item database but also mob db and mob skill db

What I just don't understand is why the item_db of renewal is different with item_db_re.sql when it comes to the column numbers,

in Item_db.txt atk and matk share the same column separated by : 

while in item_db_re.sql atk and matk have different column

Here is the converter:

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/tools/convert_sql.pl

Advance thanks to anyone who can help..