Server Database Editor

Tokeiburu · Feb 11, 2015

KohakuSan said:
It's working perfectly now, thank you!

EDIT: Actually, I'm trying to add more items now and they're still not being added on the accname or accessoryid.lua

At some point it did actually add 1 item on the accname only, nothing on the other file but I can't make it do it again. It's not even modifying the files when I save.

It's working on all the txt files for displayname, desc and resname, they're edited correctly.

You can't set the accessory lua files without using the "manage view id automatically" option. The table associations get broken otherwise.

Edit : I could add a way to edit the lua files directly from the interface however, but you'd still have to enter them manually.

Wingel said:
I can't download the 1.0.9.4

The link is down?

The links are back up (except for the main page's description). The link on mediafire changed for some reason, this usually doesn't happen!

KohakuSan said:
Found something else, it seems hercules is not recognizing state and target as numbers and I can't find these manually in the file since it doesn't say which line it is...

Alright, tested it with a server and it's indeed causing issues. Use the previous trick I mentionned before, to forcibly rewrite the entire tables.

Select all items in the list (Ctrl-A), copy them in a text format (Ctrl-C) and paste them (Ctrl-V). You can achieve the same from Edit > Add item from raw db lines, and copy your mob_skill_db.txt. Only do this after loading the tables (Edit > Reload databases).

KohakuSan · Feb 11, 2015

Tokeiburu said:
You can't set the accessory lua files without using the "manage view id automatically" option. The table associations get broken otherwise.

Edit : I could add a way to edit the lua files directly from the interface however, but you'd still have to enter them manually.

If you can do it, please. It'd help a lot.

Okay, I think I found a bug, whenever I create a new item on the item_db2 tab and save, I check the txt it's created fine, then I add the item on the Client Item tab and when I save the item disappears from the item_db2 file although it still appears on the item2 tab, it doesn't save as it is and if I reload/reopen SDE the item not there anymore since it reads the txt file which is missing the item.

It works fine if I do it the other way around though, I have to create it on Client Item, save, reopen the program then create it on item2

Waken · Feb 12, 2015

I have a suggestion for this program, when you are in the Client Items section can see what items are not implemented in your Item_db, like a mark in this items for use all resources from ragnarok.

Tokeiburu · Feb 13, 2015

KohakuSan said:
If you can do it, please. It'd help a lot.

Okay, I think I found a bug, whenever I create a new item on the item_db2 tab and save, I check the txt it's created fine, then I add the item on the Client Item tab and when I save the item disappears from the item_db2 file although it still appears on the item2 tab, it doesn't save as it is and if I reload/reopen SDE the item not there anymore since it reads the txt file which is missing the item.

It works fine if I do it the other way around though, I have to create it on Client Item, save, reopen the program then create it on item2

Bug fixed (was introduced in 1.0.9). You'll also have a new option in Tools > Edit accessory tables. It can autocomplete the view IDs to some extent (it doesn't erase values, it only fills the gaps if there are any).

When writing these lua files though, if there are errors it will fix them automatically. For instance, if you have two acc IDs, one of them will be ignored (and replaced by nothing). Negative IDs are ignored.

Bandicoot · Feb 17, 2015

Can someone tell me what to do to see the sprites?

and why does the Meta GRF Explorer stay empty?

shouldn't I be able to choose sprites there?

Tokeiburu · Feb 18, 2015

Bandicoot said:
Unbenannt.png

Can someone tell me what to do to see the sprites?

and why does the Meta GRF Explorer stay empty?

shouldn't I be able to choose sprites there?

It is empty because your resource paths aren't set.

Getting started

Create a new project from File > New project. Go in the settings tab and set the path of your database. If you're using pre-renewal, then drop the pre-re folder in the "Server DB path" box (drop the re folder otherwise). Don't drop your "db" folder, it needs to be a subpath!

...

The last setting is the resource files and it is optional. Simply drag and drop a GRF in the paths list. This will add icons in the items list view (it will also make the application slower when scrolling for that list).

You can also drop a data folder.

Bandicoot · Feb 18, 2015

Awesome now I got it!

But I can't just drag and drop it to the path like you said..

I edited the Project info and added the path there, like:

[server database editor - Resources]=C:Users...ROdata.grf

Can I add more paths? How?

Tokeiburu · Feb 18, 2015

Bandicoot said:
Unbenannt.png

Awesome now I got it!

But I can't just drag and drop it to the path like you said..

I edited the Project info and added the path there, like:

[server database editor - Resources]=C:Users...ROdata.grf

Can I add more paths? How?

If you can't drag and drop, it means you have issues with privileges (you should not start the application with admin privileges - all you have to do is open the executable/project shortcut normally). Anyway, if you still can't drag and drop, separate the paths with comas to add more.

[server database editor - Resources]=C:ROdata,C:ROserver.grf,C:ROdata.grf

Bandicoot · Feb 18, 2015

Thank you very much!!

Adding customs is so damn easy now

Awesome tool!

Waken · Mar 3, 2015

Hi, i got this lua error because the ragnarok client don't support especial characters for accessoryId :S

Tokeiburu · Mar 3, 2015

Wingel said:
Hi, i got this lua error because the ragnarok client don't support especial characters for accessoryId :S

Fixed in 1.1.2.2 : http://www.mediafire.com/download/p0zhcc8ipa6cjt3

Only letters and numbers will be used. Resaving will fix your issues.

Waken · Mar 3, 2015

Oh god, i love you, thx!!

Klutz · Mar 3, 2015

Import from SQL can be great.

How can i convert my SQL db to txt?

Tokeiburu · Mar 4, 2015

Klutz said:
Import from SQL can be great.

How can i convert my SQL db to txt?

I'm afraid this feature won't be implemented unless someone gives me a good reason or advantage for it. The SQL database files are generated from the text files, it shouldn't be the other way around. Such a feature is also prone to errors and it is discouraged :

Code:

-- NOTE: This file was auto-generated and should never be manually edited,--       as it will get overwritten. If you need to modify this file,--       please consider modifying the corresponding .conf file inside--       the db folder, and then re-run the db2sql plugin.---- Table structure for table `item_db`--

Angelmelody · Mar 4, 2015

Tokeiburu said:
Klutz said:

Import from SQL can be great.

How can i convert my SQL db to txt?

Click to expand...

I'm afraid this feature won't be implemented unless someone gives me a good reason or advantage for it. The SQL database files are generated from the text files, it shouldn't be the other way around. Such a feature is also prone to errors and it is discouraged :

-- NOTE: This file was auto-generated and should never be manually edited,-- as it will get overwritten. If you need to modify this file,-- please consider modifying the corresponding .conf file inside-- the db folder, and then re-run the db2sql plugin.---- Table structure for table `item_db`--

v 1.1.2.2 got warnings but 1.0.9 worked fine

Waken · Mar 4, 2015

Tokeiburu said:
Wingel said:

Hi, i got this lua error because the ragnarok client don't support especial characters for accessoryId :S

Click to expand...

Fixed in 1.1.2.2 : http://www.mediafire.com/download/p0zhcc8ipa6cjt3

Only letters and numbers will be used. Resaving will fix your issues.

Srry Tokei, the same problem with monsters ><

Tokeiburu · Mar 4, 2015

Wingel said:
Srry Tokei, the same problem with monsters ><

Totally forgot about the NPC's tables! Fixed in 1.1.2.3 : http://www.mediafire.com/download/p0zhcc8ipa6cjt3

Angelmelody said:
v 1.1.2.2 got warnings but 1.0.9 worked fine

I'm using a new encoding system in 1.1.2.3, so please update to this version. If you're still having the issue, use "Copy exception" and paste the output here or on pastebin. Also, check your database path; it hasn't been able to find any files, which is somewhat suspicious!

Angelmelody · Mar 4, 2015

Tokeiburu said:
Wingel said:

Srry Tokei, the same problem with monsters ><

Click to expand...

Totally forgot about the NPC's tables! Fixed in 1.1.2.3 : http://www.mediafire.com/download/p0zhcc8ipa6cjt3

Angelmelody said:

v 1.1.2.2 got warnings but 1.0.9 worked fine

Click to expand...

I'm using a new encoding system in 1.1.2.3, so please update to this version. If you're still having the issue, use "Copy exception" and paste the output here or on pastebin. Also, check your database path; it hasn't been able to find any files, which is somewhat suspicious!

I have updated to v 1.1.2.3 and here are my settings:

it throws an error msg window, saying: 'Object reference not set to an instance of an object'

Code:

--------------		  Message		  --------------並未將物件參考設定為物件的執行個體(Object reference not set to an instance of an object)。--------------	    Stack trace	    --------------   於 GrfToWpfBridge.Application.DefaultErrorHandler._reportAnyManagedExceptions(String message, Exception exception, ErrorLevel errorLevel)   於 GrfToWpfBridge.Application.DefaultErrorHandler.Handle(Exception exception, ErrorLevel errorLevel)   於 SDE.Tools.DatabaseEditor.SdeEditor._reloadDatabase(Boolean alreadyAsync)   於 SDE.Tools.DatabaseEditor.SdeEditor.&lt;ReloadDatabase&gt;b__2()   於 GRF.Threading.GrfThread.&lt;Start&gt;b__3()   於 System.Threading.ThreadHelper.ThreadStart_Context(Object state)   於 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)   於 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)   於 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state)   於 System.Threading.ThreadHelper.ThreadStart()--------------		 Exception		 --------------System.NullReferenceException: 並未將物件參考設定為物件的執行個體(Object reference not set to an instance of an object)。   於 SDE.Tools.DatabaseEditor.Engines.Parsers.TextFileHelper.ReadNextSingle(StreamReader reader)   於 SDE.Tools.DatabaseEditor.Engines.Parsers.TextFileHelper.&lt;GetSingleElement&gt;d__8.MoveNext()   於 SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods._loadCardPostfixes(AbstractDb`1 db, Byte[] data)   於 SDE.Tools.DatabaseEditor.Generic.DbLoaders.DbLoaderMethods.DbClientLoader(DbDebugItem`1 debug, AbstractDb`1 db)   於 SDE.Tools.DatabaseEditor.Generic.Core.DbClientItems._loadDb()   於 SDE.Tools.DatabaseEditor.Generic.Core.AbstractDb`1.LoadDb()   於 SDE.Tools.DatabaseEditor.Engines.DatabaseEngine.GenericDatabase.Reload(IProgress progress)   於 SDE.Tools.DatabaseEditor.SdeEditor._reloadDatabase(Boolean alreadyAsync)  於 = at

Tokeiburu · Mar 5, 2015

Angelmelody said:
I have updated to v 1.1.2.3 and here are my settings:

The settings look fine to me, the error comes from the client text file parser while reading cardpostfixnametable.txt. The end of the file isn't ending properly I'm guessing. That issue *should* be fixed in 1.1.2.4 ( http://www.mediafire.com/download/p0zhcc8ipa6cjt3 ). If not, please send me that file.

Angelmelody · Mar 5, 2015

Tokeiburu said:
Angelmelody said:

I have updated to v 1.1.2.3 and here are my settings:

Click to expand...

The settings look fine to me, the error comes from the client text file parser while reading cardpostfixnametable.txt. The end of the file isn't ending properly I'm guessing. That issue *should* be fixed in 1.1.2.4 ( http://www.mediafire.com/download/p0zhcc8ipa6cjt3 ). If not, please send me that file.

It's working fine now,A million thanks to you!.

Server Database Editor

New member

New member

New member

New member

New member

New member

New member

New member

New member

New member

New member

New member

New member

New member

(&#092; /) ( . .)

New member

New member

(&#092; /) ( . .)

New member

(&#092; /) ( . .)

We value your privacy

(\ /) ( . .)

(\ /) ( . .)

(\ /) ( . .)