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

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

 
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.

 
breaker7 said:
evilpuncker said:
you can't use them anymore, the emulator dropped them
Click to expand...
 oh, ok thanks for reply

kenik said:
>>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.
Click to expand...
 any idea for conver mob_db for my database on fluxcp?

beause i want to use live mob db for my fluxcp
Click to expand...
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

 
Last edited by a moderator:
evilpuncker said:
you can use SDE to convert anything to SQL easily

http://herc.ws/board/files/file/161-server-database-editor/
Click to expand...
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
 
breaker7 said:
evilpuncker said:
you can use SDE to convert anything to SQL easily

http://herc.ws/board/files/file/161-server-database-editor/
Click to expand...
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
Click to expand...
compile plugin db2sql and run map-server by

map-server --load-plugin db2sql --db2sql
 
^ It will update your mob_db/item_db.sql

 
Dastgir said:
breaker7 said:
evilpuncker said:
you can use SDE to convert anything to SQL easily

http://herc.ws/board/files/file/161-server-database-editor/
Click to expand...
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
Click to expand...
compile plugin db2sql and run map-server by

map-server --load-plugin db2sql --db2sql
 
^ It will update your mob_db/item_db.sql
Click to expand...
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

 
breaker7 said:
Dastgir said:
breaker7 said:
evilpuncker said:
you can use SDE to convert anything to SQL easily

http://herc.ws/board/files/file/161-server-database-editor/
Click to expand...
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
Click to expand...
compile plugin db2sql and run map-server by

map-server --load-plugin db2sql --db2sql
 
^ It will update your mob_db/item_db.sql
Click to expand...
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
Click to expand...
that db2sql will convert item_db and mob_db to sql

 
Dastgir said:
breaker7 said:
Dastgir said:
breaker7 said:
evilpuncker said:
you can use SDE to convert anything to SQL easily

http://herc.ws/board/files/file/161-server-database-editor/
Click to expand...
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
Click to expand...
compile plugin db2sql and run map-server by

map-server --load-plugin db2sql --db2sql
 
^ It will update your mob_db/item_db.sql
Click to expand...
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
Click to expand...
that db2sql will convert item_db and mob_db to sql
Click to expand...

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
 
You must log in or register to reply here.
Back
Top