[ASK] How use mob, item db in SQL ?

[breaker7 1]

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

[evilpuncker 504]

you can't use them anymore, the emulator dropped them

[kenik 12]

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.

[evilpuncker 504]

look at this commit 

[breaker7 1]

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

[kenik 12]

 

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

[evilpuncker 504]

you can use SDE to convert anything to SQL easily

 

http://herc.ws/board/files/file/161-server-database-editor/

[kenik 12]

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.

[breaker7 1]

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

[Dastgir 1246]

 

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

[breaker7 1]

 

 

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

[Dastgir 1246]

 

 

 

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

[breaker7 1]

 

 

 

 

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

[breaker7 1]

up..

 

i need to convert mob_skill_db.conf to mob_skill_db.sql 

[kenik 12]

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