breaker7 1 Posted April 18, 2016 I just install hercules in my pc following this guide http://herc.ws/wiki/Installation_(CentOS) why item db and mob db still reference to db/pre-re/mob_db.conf and db/pre-re/item_db.conf i want to use sql database thanks Quote Share this post Link to post Share on other sites
0 evilpuncker 503 Posted April 18, 2016 you can't use them anymore, the emulator dropped them Quote Share this post Link to post Share on other sites
0 kenik 12 Posted April 18, 2016 You can update your SQL-tables with the help of db2sql plugin. It's included in clean Hercules. For mobs you have to do something yours. db2sql works only with items. Quote Share this post Link to post Share on other sites
0 evilpuncker 503 Posted April 18, 2016 look at this commit Quote Share this post Link to post Share on other sites
0 breaker7 1 Posted April 18, 2016 you can't use them anymore, the emulator dropped them oh, ok thanks for reply You can update your SQL-tables with the help of db2sql plugin. It's included in clean Hercules. For mobs you have to do something yours. db2sql works only with items. any idea for conver mob_db for my database on fluxcp? beause i want to use live mob db for my fluxcp look at this commit i see, thanks Quote Share this post Link to post Share on other sites
0 kenik 12 Posted April 18, 2016 (edited) you can't use them anymore, the emulator dropped them oh, ok thanks for reply >>You can update your SQL-tables with the help of db2sql plugin. It's included in clean Hercules. For mobs you have to do something yours. db2sql works only with items. any idea for conver mob_db for my database on fluxcp? beause i want to use live mob db for my fluxcp Well.. I made simple script which loops mobs and inserts (replaces) values in SQL. It's not the best way, but it works, if you won't run it often. There are a lot of queries. Or you can make libconfig parcer at any programming language you know. And you will have to run this script after any changes in mob_db Edited April 18, 2016 by kenik Quote Share this post Link to post Share on other sites
0 evilpuncker 503 Posted April 18, 2016 you can use SDE to convert anything to SQL easily http://herc.ws/board/files/file/161-server-database-editor/ 1 kenik reacted to this Quote Share this post Link to post Share on other sites
0 kenik 12 Posted April 18, 2016 you can use SDE to convert anything to SQL easily http://herc.ws/board/files/file/161-server-database-editor/ Oh! Nice one thing. It wasn't there when I made my script) Thx. Quote Share this post Link to post Share on other sites
0 breaker7 1 Posted April 18, 2016 you can use SDE to convert anything to SQL easily http://herc.ws/board/files/file/161-server-database-editor/ file: 'SERVER\db\pre-re\mob_db.conf', line: 147, exception: 'Input string was not in a correct format.' -------------- Message -------------- Input string was not in a correct format. -------------- Exception -------------- System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Int32.Parse(String s) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbMobsFunction[TKey](DbDebugItem`1 debug, AttributeList list, String[] elements, Table`2 table) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbCommaLoader[T](DbDebugItem`1 debug, AttributeList list, DbCommaFunctionDelegate`1 function, TextFileHelperGetterDelegate getter, Boolean addAutomatically) i use pure mob_db.conf and i cant load mob db, go that message Quote Share this post Link to post Share on other sites
0 Dastgir 1246 Posted April 18, 2016 you can use SDE to convert anything to SQL easily http://herc.ws/board/files/file/161-server-database-editor/ file: 'SERVER\db\pre-re\mob_db.conf', line: 147, exception: 'Input string was not in a correct format.' -------------- Message -------------- Input string was not in a correct format. -------------- Exception -------------- System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Int32.Parse(String s) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbMobsFunction[TKey](DbDebugItem`1 debug, AttributeList list, String[] elements, Table`2 table) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbCommaLoader[T](DbDebugItem`1 debug, AttributeList list, DbCommaFunctionDelegate`1 function, TextFileHelperGetterDelegate getter, Boolean addAutomatically) i use pure mob_db.conf and i cant load mob db, go that message compile plugin db2sql and run map-server by map-server --load-plugin db2sql --db2sql ^ It will update your mob_db/item_db.sql Quote Share this post Link to post Share on other sites
0 breaker7 1 Posted April 18, 2016 you can use SDE to convert anything to SQL easily http://herc.ws/board/files/file/161-server-database-editor/ file: 'SERVER\db\pre-re\mob_db.conf', line: 147, exception: 'Input string was not in a correct format.' -------------- Message -------------- Input string was not in a correct format. -------------- Exception -------------- System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Int32.Parse(String s) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbMobsFunction[TKey](DbDebugItem`1 debug, AttributeList list, String[] elements, Table`2 table) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbCommaLoader[T](DbDebugItem`1 debug, AttributeList list, DbCommaFunctionDelegate`1 function, TextFileHelperGetterDelegate getter, Boolean addAutomatically) i use pure mob_db.conf and i cant load mob db, go that message compile plugin db2sql and run map-server by map-server --load-plugin db2sql --db2sql ^ It will update your mob_db/item_db.sql can i conver mob_db and mob_skill_db use plugin db2sql ? now i can conver item_db use server database editor, but for mob i got that error message Quote Share this post Link to post Share on other sites
0 Dastgir 1246 Posted April 18, 2016 you can use SDE to convert anything to SQL easily http://herc.ws/board/files/file/161-server-database-editor/ file: 'SERVER\db\pre-re\mob_db.conf', line: 147, exception: 'Input string was not in a correct format.' -------------- Message -------------- Input string was not in a correct format. -------------- Exception -------------- System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Int32.Parse(String s) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbMobsFunction[TKey](DbDebugItem`1 debug, AttributeList list, String[] elements, Table`2 table) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbCommaLoader[T](DbDebugItem`1 debug, AttributeList list, DbCommaFunctionDelegate`1 function, TextFileHelperGetterDelegate getter, Boolean addAutomatically) i use pure mob_db.conf and i cant load mob db, go that message compile plugin db2sql and run map-server by map-server --load-plugin db2sql --db2sql ^ It will update your mob_db/item_db.sql can i conver mob_db and mob_skill_db use plugin db2sql ? now i can conver item_db use server database editor, but for mob i got that error message that db2sql will convert item_db and mob_db to sql Quote Share this post Link to post Share on other sites
0 breaker7 1 Posted April 18, 2016 you can use SDE to convert anything to SQL easily http://herc.ws/board/files/file/161-server-database-editor/ file: 'SERVER\db\pre-re\mob_db.conf', line: 147, exception: 'Input string was not in a correct format.' -------------- Message -------------- Input string was not in a correct format. -------------- Exception -------------- System.FormatException: Input string was not in a correct format. at System.Number.StringToNumber(String str, NumberStyles options, NumberBuffer& number, NumberFormatInfo info, Boolean parseDecimal) at System.Number.ParseInt32(String s, NumberStyles style, NumberFormatInfo info) at System.Int32.Parse(String s) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbMobsFunction[TKey](DbDebugItem`1 debug, AttributeList list, String[] elements, Table`2 table) at SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbCommaLoader[T](DbDebugItem`1 debug, AttributeList list, DbCommaFunctionDelegate`1 function, TextFileHelperGetterDelegate getter, Boolean addAutomatically) i use pure mob_db.conf and i cant load mob db, go that message compile plugin db2sql and run map-server by map-server --load-plugin db2sql --db2sql ^ It will update your mob_db/item_db.sql can i conver mob_db and mob_skill_db use plugin db2sql ? now i can conver item_db use server database editor, but for mob i got that error message that db2sql will convert item_db and mob_db to sql wow really? i don't know that because in http://herc.ws/wiki/Db2sql Files Converted db/pre-re/item_db.conf db/re/item_db.conf db/item_db2.conf thanks for info Quote Share this post Link to post Share on other sites
0 breaker7 1 Posted April 20, 2016 up.. i need to convert mob_skill_db.conf to mob_skill_db.sql Quote Share this post Link to post Share on other sites
0 kenik 12 Posted April 23, 2016 (edited) You can try to use converter from rAthena forum: https://rathena.org/board/topic/56366-tool-perl-converter-txt-sql/ Edited April 23, 2016 by kenik Quote Share this post Link to post Share on other sites
I just install hercules in my pc following this guide
http://herc.ws/wiki/Installation_(CentOS)
why item db and mob db still reference to db/pre-re/mob_db.conf and db/pre-re/item_db.conf
i want to use sql database
thanks
Share this post
Link to post
Share on other sites