• 0
Sign in to follow this  
BrOgBr

How convert txt to sql

Question

Someone can help me?

How convert item_db.txt to item_db.sql, like the rAthena's github does with the "SQL synchronization"?

Share this post


Link to post
Share on other sites

6 answers to this question

Recommended Posts

  • 1

Just download a perl runtime or w/e it is then execute the file. You don’t have to know Perl to use the tool. For Windows install StrawberryPerl or ActivePerl.

  • Upvote 1

Share this post


Link to post
Share on other sites
  • 0

There are scripts in the tools directory, I think it's something like convert_sql.pl

  • Upvote 1

Share this post


Link to post
Share on other sites
  • 0
1 hour ago, Nitrous said:

There are scripts in the tools directory, I think it's something like convert_sql.pl

I found it.
But I need download Perl?
I don't know how to use perl :(

Share this post


Link to post
Share on other sites
  • 0

Thank you Secrets and Nitrous.
I'll try here.

@Edit 

@Secrets I need change something at convert_sql.pl?

I tried click in it but nothing happened... (choosing execute Perl Program)

It opens the cmd but closes instantly.

I checked the item_db_re.sql but nothing changed.

Help please.
 

Edited by BrOgBr

Share this post


Link to post
Share on other sites
  • 0
1 hour ago, BrOgBr said:

Thank you Secrets and Nitrous.
I'll try here.

@Edit 

@Secrets I need change something at convert_sql.pl?

I tried click in it but nothing happened... (choosing execute Perl Program)

It opens the cmd but closes instantly.

I checked the item_db_re.sql but nothing changed.

Help please.
 

You need to run the file in command line because it needs some additional command line parameters.

  • Love 1

Share this post


Link to post
Share on other sites
  • 0
55 minutes ago, Secrets said:

You need to run the file in command line because it needs some additional command line parameters.

I tried but I got this error:

ERROR: Filename_in and Filename_out are required to continue.

It worked!
I edited the convert_sql.pl, now I've learned.

Thank you very much @Secrets :wub:

Edited by BrOgBr

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this