ROM DB Editor

Page 1 of 8 12345678 LastLast
Results 1 to 15 of 111
  1. #1
    Member MunkyCS is offline
    MemberRank
    Jul 2014 Join Date
    RussiaLocation
    58Posts

    config ROM DB Editor

    I`m developing the Runes Of Magic DataBase Editor. Obviously, it will help you to edit things in data.fdb.

    This tool allows you to explore/edit many kind of entities in RoM.

    Here you can download it (Requires .NET 4.5):
    (v 0.4.6) https://mega.nz/file/mcc1GIbL#p-CqVb...5u4oM5SwzdK1Nw (reupload)
    [STRIKE]https://drive.google.com/file/d/0B3WYkjrc1GHab2libk1Eb1NlLWs[/STRIKE]
    Old versions:


    Sources: GITLAB (also you may use issue tracker there)

    If you want to save things, make sure you press SAVE button where it exists.
    And also, don`t forget to go File->Save All (Ctrl+S in main window) when you want to fix your changes to your hard drive. To make things work, you need to save everything to C:\Runewaker\Client\data, then copy everything from there to C:\Runewaker\Resources\data.

    Planned features:

    • [v0.4.7] Recipes, titles
    • [v0.5+] Image objects (?)
    • [v0.6+] Quest support
    • [???] ? SQL In-game shop editor in admin panel
    • [???] Patches (save only changed data to apply to different fdb versions)
    • [unlikely] C# 6.0 Support for scripts
    • [unlikely] C# IntelliSence for scripts


    In case you have found bugs, or if you want to ask for some feature or whatever - feel free to post it here or privately.

    PS: Если вы владеете русским, лучше использовать его (в привате).

    Big thanks to McBen, Turmalin, and other guys, helped me in that or other way.

    ==== Usage ===================================
    First time usage [optional, but higly recommended to avoid problems]:
    1. Launch the tool
    2. It should show you Setting dialog, if you have no romdb.ini (you should not at the first time)
      • Set all 3 paths (first one is directory, that should contain data.fdb, the second one will contain *.db files , third should be a path to any of your Global.ini files)
      • If you want to work with server files (6.0.7): setup path to your server like c:\runewaker\resource\fdb and c:\runewaker\resource\data.
      • Otherwise, for client: c:\runewaker\client\fdb and c:\runewaker\client\data.
      • You may select either variant, it`s just for convenience if you got your server running on a different machine from your client`s one.
      • If you don`t have that data folders - simply create them manualy.

    3. Press save button there.
    4. ... (Normal usage)

    After all that, you may use tool as you used it before. Now the program will ask you on load and save wether to use default paths or to select different. If you select default way, it will save/load things as they should be without asking you any more questions (except localization loading).

    If tool cannot find some file, launch log_romdb.bat (or just 'romdb_editor.exe /v'), load data.fdb and close program. Then send me your log file with your problem description privately, and I will see what I can do.

    Note: To make admin panel work - specify Global.ini path in settings!!! Ensure Global.ini has correct SQL value set up

    ==== About Stats & Treasures =====================
    If you want to make an item with one random stat for example, you have to use treasures for that. Just create a treasure with stats you need, or use existing. Then set item`s one of the stats field so, that it`s id == tresure guid and rate == 100% (100000). If you want 1 of n random stats, simply pushing them to stats of an item with rates like 1/n won`t give you desired result. Allso be carefull not to mix up RuneObjects and Stats, while using treasures. I haven`t tested setting rune as a stat, I suppose that nothing neither interesting nor usefull would happen.

    Also, to make TreasureObject have more/less slots for items:
    1. Set desired count.
    2. Re-find this treasure
    3. Re-open this treasure.

    Note: max count is 100.

    === SCRIPTS About (RoM DB Editor v0.3.2+) ==========
    You now can run scripts within editor.
    These are for searching or editing things in database and showing any kind of information in HTML (4) format.
    Scripts should be written using C# language (.NET v4.0 - 4.5). (C# 6 is not yet supported)
    Any of your script would be actualy just a body for a method in a following code:
    Code:
    using System;
    using System.Linq;
    using System.Collections.Generic;
    using RunesDataBase.TableObjects;
    using RunesDataBase.SubScript;
    using Runes.Net.Shared;
    public class Main
    {
        public static void Run(RunesDataBase.SubScript.RunesDataBase db)
        {
        // YOUR CODE HERE
        }
    }
    Anyway, if you`d like to use scripts, please take a look on script.cs inside the archive first!
    To get info about fields/types/methods/... just use Microsoft`s VisualStudio (I`d suggest you to use VS2013 or newer + ReSharper)
    Create a C# DLL project, add references to "romdb_editor.exe", "Runes.Net.Shared.dll" and "Runes.Net.Db.dll".
    Then paste code written above in Class1.cs and now you can write code.
    Note you are only writing a body for that method.
    However, you can also hack it using code like following:
    Code:
    // SOME CODE - Run method`s body
    }
    static void RETURN_TYPE FUNC_NAME(ARGS){//other method`s body
    }
    and so on.
    Please, do not use things that can cause any kind of unhandled exception too easily. Debuging could be not simple at all.
    If you hadn`t got it yet - you shouldn`t compile anything, just copy method`s body to editor and click Run.
    Last edited by MunkyCS; 22-12-21 at 06:03 PM.


  2. #2
    Member Reaperman is offline
    MemberRank
    Jan 2015 Join Date
    89Posts

    Re: ROM DB Editor

    Hey MunkyCS,
    thank you very much for this release. I download it an load a FDB File and can search for locas and npcs....save thimgs i will test!!!

    THX

  3. #3
    Account Upgraded | Title Enabled! Elssair is offline
    MemberRank
    Dec 2013 Join Date
    334Posts

    Re: ROM DB Editor

    Thanks you so much MunkyCS but for me don't work :(

    Attachment 152108

    I'm using 6.3 data.fdb.

    Thanks for your share, best regards,
    Elssair.

  4. #4
    Member Reaperman is offline
    MemberRank
    Jan 2015 Join Date
    89Posts

    Re: ROM DB Editor

    Quote Originally Posted by Elssair View Post
    Thanks you so much MunkyCS but for me don't work :(

    Attachment 152108

    I'm using 6.3 data.fdb.

    Thanks for your share, best regards,
    Elssair.
    Write something into the Search field and click on search.....


  5. #5
    Account Upgraded | Title Enabled! Elssair is offline
    MemberRank
    Dec 2013 Join Date
    334Posts

    Re: ROM DB Editor

    Quote Originally Posted by Reaperman View Post
    Write something into the Search field and click on search.....

    Wow thanks ajaja... now works without problems, sorry ;)

  6. #6
    Member MunkyCS is offline
    MemberRank
    Jul 2014 Join Date
    RussiaLocation
    58Posts

    Re: ROM DB Editor

    Quote Originally Posted by Reaperman View Post
    click on search.....
    It`s also possible just to press Enter.

    I will release a bit upgraded version (v 0.1.1) in a few moments.

    Changes:
    + Clone items button (it is not supposed to be used for anything else but NPC`s, cause everything else is not supported by now)
    + New editable fields for NPC (Str, Dex, Sta, ..., Spell list, Brave(?),...)
    + GUID field for all objects (readonly)
    * Races are now enum, (however, I haven`t found anything except Undead and None mentioned in client sources)
    * Added gnome classes to classes enum

    As for clone button - it will generate ids like 109999, 109998, ... while they`re free. 109xxx is instead of 102xxx or 103xxx is for compatibility with futher releases of data.fdb (it`s not yet enough, you will also need some merge tool). Clone button may look like it does not work, but pay attention to your Guid field, it should change its value. To name new object - search for this new guid, you should see then new Sysnames for it and for every language you have loaded. So you can edit some (or all) of them. Note that search results (in all tabs) will not update until you search again, however save button works immediately, so that you can save all as soon as pressed save.

  7. #7
    Member Reaperman is offline
    MemberRank
    Jan 2015 Join Date
    89Posts

    Re: ROM DB Editor

    Quote Originally Posted by MunkyCS View Post
    It`s also possible just to press Enter.

    I will release a bit upgraded version (v 0.1.1) in a few moments.
    Hey MunkyCS,

    thanx for your Update of the editor....

  8. #8
    Proficient Member Turmalin is offline
    MemberRank
    Jul 2014 Join Date
    168Posts

    Re: ROM DB Editor

    Also, remember, that those *.db can be updated in future, so you would lose all your changes. So, it would be good idea to save change list somewhere with editable guid, so you would can use it on future patches. Got some troubles on prev. versions of editor. That's why I had stop on code-only editor, where editable logic would be saved.

  9. #9
    Member MunkyCS is offline
    MemberRank
    Jul 2014 Join Date
    RussiaLocation
    58Posts

    Re: ROM DB Editor

    Released v 0.2.0
    + Spells support (magiccollectobject.db)
    + Adding new string feature (with an arbitary key in the main menu, or _title/_shortnote at object tab)
    (+) Zone zupport (just for fun, there`s no point to use until I`ll know how to add new zones from A to z)

  10. #10
    Member Reaperman is offline
    MemberRank
    Jan 2015 Join Date
    89Posts

    Re: ROM DB Editor

    Quote Originally Posted by MunkyCS View Post
    Released v 0.2.0
    + Spells support (magiccollectobject.db)
    Thx for release. I changed something on a spell and it works!!!

    Good work Munky

  11. #11
    Enthusiast roflkarto is offline
    MemberRank
    Nov 2013 Join Date
    30Posts

    thumbs up Re: ROM DB Editor

    Really awesome work, thanks a lot for this nice tool

  12. #12
    Member MunkyCS is offline
    MemberRank
    Jul 2014 Join Date
    RussiaLocation
    58Posts

    thumbs up Re: ROM DB Editor

    v 0.2.1 Released
    (Buf support is delayed until 0.2.2)
    * fixed zones (thx Turmalin) (You can only change max players + zone .wdb file as well as cloning them. Minimaps and other things will be avaliable later)
    * Optimized loading - faster load from FDB
    * Optimized search by string
    * Default language selection
    * Searching in a separate thread.
    * Some new fields have been added for spell objects

    ===================== Zone cloning mini-tutorial =========
    To clone existing zones (particulary dungeons):
    - Clone template in the editor, save all (zoneobject.db)
    - (Clone file to make it present both on client(Client\data\) and server(Resource\data\))
    - Add new .ini for your zone at (\Server\Realm_01_Zone\) : like Zone_999.ini, where 999 - your zone`s guid (without 750xxx)
    As for it contents - take any similar ini for any dungeon there as an example.
    - Add string to your server controller setiings ini file (just clone one there and change zone id`s) (make sure not to copy "disabled" option :D)
    - [Restart server controller]

    Note that teleporting to a dungeon zone with a gm command ? zone will make you unable to leave zone with a party break. However it`s seams the only correct way to enter zone for adding/modifying objects there. If you enter zone normally (you should add triggers first) - your new objects will not be saved after you leave zone, even if you reform your party and even if you check checkbox "Save" with a Gm Tool.
    Last edited by MunkyCS; 02-06-15 at 10:07 AM.

  13. #13
    Proficient Member Turmalin is offline
    MemberRank
    Jul 2014 Join Date
    168Posts

    Re: ROM DB Editor

    For more details: when you create NPC via ? createobj, it would be created in current room(party instance(dungeon) instance XDD). Also, it wouldn't be created in some locations, not sure, which.
    But you can create script via createobj + addtopartition functions, which would add your NPC to all rooms at time(addtopartition 0 or -1, not sure, didn't check it for a while).

  14. #14
    Valued Member kalle101 is offline
    MemberRank
    Jun 2014 Join Date
    133Posts

    Re: ROM DB Editor

    Great Tool, thanks for that.
    Can you please make a short tutorial how to edit spells for example?
    When I open my data.fdb I can only select Strings. How can I open the magiccollectobject.db?

    Thanks

  15. #15
    Member MunkyCS is offline
    MemberRank
    Jul 2014 Join Date
    RussiaLocation
    58Posts

    Re: ROM DB Editor

    Quote Originally Posted by kalle101 View Post
    Great Tool, thanks for that.
    Can you please make a short tutorial how to edit spells for example?
    When I open my data.fdb I can only select Strings. How can I open the magiccollectobject.db?

    Thanks
    Most of other *.db are opened automaticly after you select which localizations to load. There`re no need to choose other .db files, this program works with all of them at once. So that you can find anything by it`s ID (or almost anything), however you will see much info about them only for supported classes of objects.
    Just search for any spell by it`s name or GUID. For example, you can search for Flame - Runes of Magic Skill - runesdatabase.com - the official database so it has 491150 guid. You can either filter thing using Flame keyword or just enter 491150.
    Then double click one you want to edit. You are able to change any supported field unless it`s in System category.
    As for fields - they have description. Most of them.
    To make AOE from a normal spell just set it`s range, change target type to BadCircle, increase the target count value.
    Also you can make spell to cast series of impacts instead of one. Spell count is number of impacts, Next spell time - is a delay between them.

    - - - Updated - - -
    As for room number -
    I think that should be 0, because -1 is seams to be used for automatic room selection. Also when ? zone XXX is used without anything else I suppose that should mean that your room == 0. When you enter zone via trigger (via lua script) - the script have room == -1
    ============ UPD ==============
    I have found a bug that it is generating a bit wrong guid for spells (50xxxx instead of 49xxxx or 49xxxxx). I`m not sure is it critical but .... I`ve fixed that and uploaded (version has not changed). Please, redownload [v 0.2.1]. Thx
    Last edited by MunkyCS; 03-06-15 at 05:32 AM.



Page 1 of 8 12345678 LastLast

Advertisement