Jump to content
  • 0
breaker7

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

Question

14 answers to this question

Recommended Posts

  • 0

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.

Share this post


Link to post
Share on other sites
  • 0

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

 

 

 

i see, thanks

Share this post


Link to post
Share on other sites
  • 0

 

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 by kenik

Share this post


Link to post
Share on other sites
  • 0

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

Share this post


Link to post
Share on other sites
  • 0

 

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

Share this post


Link to post
Share on other sites
  • 0

 

 

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

Share this post


Link to post
Share on other sites
  • 0

 

 

 

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

Share this post


Link to post
Share on other sites
  • 0

 

 

 

 

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.