TXT to SQL?

[megablox]

Hi, I noticed that I don't have a sql version of my item and mob database, so the CP isn't working fully.

How can I convert the TXT version to a sql version?

[Dinze]

https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/tools/ run item_db.pl and mob_db.pl.

[megablox]

Thanks ;]

Hey, while running the generated script for item_db, I stumbled upon a syntax error. Apparently this line of the item_db is causing some errors.

I looked at the line, and I found out there's a colon (70:105). I think that may be the cause

item_db.txt line

1231,Bazerald,Bazerald,4,20,,500,70:105,,1,0,0x028F5EEE,7,2,2,4,36,1,1,{ bonus bAtkEle,Ele_Fire; bonus bInt,5; },{},{}

MySQL error

0	21:23:04	REPLACE INTO `item_db` VALUES (1231,'Bazerald','Bazerald',4,20,NULL,500,70:105,NULL,1,0,0x028F5EEE,7,2,2,4,36,1,1,' bonus bAtkEle,Ele_Fire; bonus bInt,5; ',NULL,NULL)	Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':105,NULL,1,0,0x028F5EEE,7,2,2,4,36,1,1,' bonus bAtkEle,Ele_Fire; bonus bInt,5; ' at line 1

How can I fix that?

Edited June 14, 2012 by megablox

[GreenBox]

It was a problem with the item_db tool, I fixed it in r16299.

[megablox]

I updated it, seems to work now. Thanks !

Stumbled upon another problem: it appears it's putting double backslashes (\) when it should be a single one.

This happens near " 's ", and causes a syntax error.

Edited June 14, 2012 by megablox

[Haeru]

https://rathena.svn....na/trunk/tools/ run item_db.pl and mob_db.pl.

can i use this script to automatically read all line in my item_db.txt?

if yes how to? what is the command?

im using windows and strawberry perl