Jump to content
  • 0
Sign in to follow this  
Samuel

R> Txt 2 SQL Converter

Question

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. :)

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0

maybe we could use of this converter from rathena, xD

 

I just don't understand perl. :D

 

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.. :)

 

Share this post


Link to post
Share on other sites

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.   Restore formatting

  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.

Loading...
Sign in to follow this  

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.