(Question) DB --> SQL

[Elysium]

Hello, Good day :3 i just wanna ask if there is any converter out there that can convert item_db2.txt to item_db2.sql
since i have lots of modifications from item_db2.txt and i want to convert them to SQL version if any tools please let me know.

Thank you (-:

[Emistry]

https://github.com/rathena/rathena/blob/master/tools/convert_sql.pl

[Elysium]

https://github.com/rathena/rathena/blob/master/tools/convert_sql.pl

 

Thanks for the link. how can i use this file? any guide?

is this vice-versa? TXT to SQL and SQL to TXT?

[Emistry]

perl script ...

#!/usr/bin/perl

# Item Database:
#     --i=../db/pre-re/item_db.txt --o=../sql-files/item_db.sql --t=pre --m=item --table=item_db
#     --i=../db/re/item_db.txt --o=../sql-files/item_db_re.sql --t=re --m=item --table=item_db_re
#
# Mob Database:
#     --i=../db/pre-re/mob_db.txt --o=../sql-files/mob_db.sql --t=pre --m=mob --table=mob_db
#     --i=../db/re/mob_db.txt --o=../sql-files/mob_db_re.sql --t=re --m=mob --table=mob_db_re
#
# Mob Skill Database:
#     --i=../db/pre-re/mob_skill_db.txt --o=../sql-files/mob_skill_db.sql --t=pre --m=mob_skill --table=mob_skill_db
#     --i=../db/re/mob_skill_db.txt --o=../sql-files/mob_skill_db_re.sql --t=re --m=mob_skill --table=mob_skill_db_re

use command prompt to navigate to the directory and execute the command...