megablox Posted June 14, 2012 Posted June 14, 2012 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? Quote
Dinze Posted June 14, 2012 Posted June 14, 2012 https://rathena.svn.sourceforge.net/svnroot/rathena/trunk/tools/ run item_db.pl and mob_db.pl. Quote
megablox Posted June 14, 2012 Author Posted June 14, 2012 (edited) 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 Quote
GreenBox Posted June 14, 2012 Posted June 14, 2012 It was a problem with the item_db tool, I fixed it in r16299. 1 Quote
megablox Posted June 14, 2012 Author Posted June 14, 2012 (edited) 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 Quote
Haeru Posted July 31, 2012 Posted July 31, 2012 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 1 Quote
Question
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?
5 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.