Page 1 of 65 1 2 3 4 5 6 7 8 9 10 11 26 51 ... LastLast
Results 1 to 20 of 1298

Thread: PFM 3.2 - DB schema improvements

  1. #1
    daniu's Avatar 比你才牛
    Join Date
    Mar 2009
    Posts
    6,385
    Tournaments Joined
    0
    Tournaments Won
    0

    Default PFM 3.2 - DB schema improvements

    This is the Pack File Manager with Rome 2 supported starting from version 3.

    Download Current Version 3.2.1
    Unzip to install.
    Don't unzip as Administrator if you're planning on running it as a normal user later or you won't be able to use the automatic update.


    I'll post schemas for Rome II betas in this place, but there's none on right now.



    There is an autoupdate under the Help menu; if it doesn't work for some reason,
    - all software releases always available here.
    - newest (and older) DB schemas here.


    As usual: if you any issues, let us know.


    To get started with modding in general, here's my Warscape Modding Primer.
    Also, join the PFM Steam user group. I'll try and put up update notifications there.


    Release 3.2 notes I just finally uploaded the new PFM version 3.2.
    This contains some pretty massive under-the-hood changes which you shouldn't even realized happened.
    It makes the whole schema handling a lot smoother by only reading a single schema file (master_schema.xml) for all WS games and only maintains the maximum version per game/table to be able to paint the yellow tree node for tables in need of an update.
    It also should make updates more reliable by not "guessing" that columns at the end of the table will be new, but bases its update on column names.
    I did also introduce a new feature that you can now also subscribe to beta schema versions, so no more need for manual downloading those.

    The bad news is that this makes schema file updates useless for previous releases, so you pretty much need to update to 3.2 if you want to continue receiving schema updates for later patches.

    I also worked on the gamedir.txt problems people were having, with the AssemblyKit installation creating an empty Rome install at C: which PFM erroneously always took for the proper install location.


    Changelist:
    - Fixed TSV import
    - Fixed schema lookup
    - Automatically puts imported TSV files into the correct db subdirectory


    Previous versions:
    Version 3.2.0

    - schema handling update to greatly make opening db files more flexible
    - fixed PFM handling for game directory file
    - added "subscribe to beta schema" to the options
    - set db editor to read only if table contains a "list" column


    Version 3.1.8
    DB fixes (Jinarik):
    - Fixed column filters resetting visually on scroll
    - Fixed filter values not being accepted properly
    - Fixed null reference exception when adding rows
    - Fixed numerical column sorting
    General changes (daniu):
    - Allow adding directories from other packs


    Version 3.1.7
    DB fixes (Jinarik):
    - Implemented Column filter
    - Fixed Apply Expressions not rounding integer columns
    - Fixed Filter names not updating after edit
    - Fixed Delete/Rename DB tables causing problems
    - Added "Check Table for Errors" feature
    - Rewrote DB config read/write
    General (daniu):
    - Improved AutoUpdate some more
    - Fixed saving Shader bit
    - Added setting/clearing Shader bit (previously in Pack Type)


    Version 3.1.6
    DBE (Jinarik):
    - fix for row insert appending row
    - expanded keyboard shortcuts
    - fixed minimize DB file compatability with DBE
    - DB string mass edit
    - DBE undo/redo/revert
    - expanded data validation
    PackFileManager general (daniu):
    - using field names for DB table update
    - improved suggested path for new MyMod
    - handling MyMod containing spaces (for new MyMod and install)
    - fixed DBRow access error preventing combo boxes
    ESF editing (daniu):
    - fixed bug not allowing empty array nodes
    - setting all child nodes of duplicated nodes as changed so save will be applied properly
    PfmCL (daniu):
    - added verbose flag for additional output
    - regarding no parameter as "all files" for extract


    Version 3.1.5
    DBE (Jinarik):
    - IndexOutOfRangeException fixed
    - Rows validated before pasting
    - Error handling improved when Paste Row fails
    - Key columns moved to leftmost position in table

    General (daniu):
    - schema 38 integrated
    - PFM size and location now restored upon restart
    - Autoupdate improved (preventing infinite loop, not extracting AutoUpdate itself, allowing message during extract, now waiting for user key press before restart)
    - pfm command line tool now allows extraction of directories


    Version 3.1.4

    - Fix for changing to a table with fewer rows crashing the PFM
    - Fix for value changes in ESF optimized nodes not being applied


    Version 3.1.3
    DBE (jinarik):
    - added filter for DBE columns
    - fixed problem copying full row
    - enable paste at certain row position
    - some things he forgot to document in the proper place:
    - Added row header context menu for inserting row(s).
    - Fixed Renumber Cells bug when interacting with sorted columns
    - Possible fix for Clipboard race event
    - Added tooltip for modified cells showing original cell value
    - Fixed Apply Expression crash when trying to force floats into int columns
    general (daniu):
    - Added array editing in ESF files
    - Automatically creating MyMod folder if the chosen one doesn't exist
    - Internal improvement allowing for several patch levels to be included in schema (beta)
    - Handling non-existent game directories more gracefully


    Version 3.1.2
    DBE (jinarik):
    - Fixed tables showing as modified after save
    - Fixed table not updating modified status to PFM until user moves away from table
    - Fix for tree view not updating changed db files until user selects another node.
    - Fix for table caching issues
    General (daniu):
    - Fixed Remove MyMod
    - Improved DBE load fail error message
    - Added referenced table info in DbSql help output
    - Added "script" command in DbSql script
    - Allowing empty lines in DbSql script


    Version 3.1.1
    DBE (jinarik):
    - Added find and replace
    - Added cell context menu
    - Fixed unwanted scrolling on paste
    - Fixed problem with read only tables
    - Removed freeze key columns ability
    General (daniu):
    - Add bookmarks feature for integrated ESF editor
    - Fixed "failed to load DBE dll" (serialized assembly setting)
    - Restructured PackType/Precedence to allow all possible values
    - Load all game files fixed
    - Using application folder to save MyMod data (mod list, current mod)
    - Fixed create Row in legacy editor


    Version 3.1
    - Integrated DBEditor to edit database table
    - Added "Import from Pack" feature (no need to export/import)
    - "Search for Updated" moved to Help menu
    - Made suffix list for text files externals (i.e., users can now add their own entries)
    - Allows setting of all Pack Types
    - Command Line SQL client added (experimental)
    - Added formula editing for non-DBE table editor (fallback)
    - Handling invalid packs in game data folder more defensively
    - Disallowing any editing for CA files instead of notification when trying to save


    Version 3.0.3
    - Added option to have csv import replace current data instead of appending
    - Added automatic update for first PFM start (there seem to be many people not knowing about the update feature)
    - Added Renumber column values feature back in
    - Added copy/paste to integrated text editor
    - Fixed referenced version for the Zip library (for autoupdate issues)


    Version 3.0.2
    - Added Rome 2 icon for PFM
    - Display of empty db tables now in blue
    - Fixed Autoupdate to not abort when trying to overwrite itself
    - Fixed creating field instances from new encoding (for clone rows)


    Version 3.0.1
    - Re-enabled autoupdate


    Version 3.0
    - Support for Rome 2 pack files
    Last edited by daniu; May 29, 2014 at 08:32 AM. Reason: Version 3.1.8 uploaded
    Tools: PFM 3 - EditSF 1.1.2

    Warscape Modding Guide
    Join the PFM User Group on Steam to receive PackFileManager update notifications.

    Don't need your Steam Trading Cards?
    I give you games for them.


    Respecto Patronum

  2. #2
    Tiro
    Join Date
    Feb 2011
    Posts
    60
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Thank you very much, thank god i been waiting for this, THank you man!


    Bad News:

    It doesn't work, or is it just me?

    Last edited by AlexDragon; September 05, 2013 at 04:50 AM.

  3. #3
    Indefinitely Banned
    Join Date
    Nov 2011
    Location
    The western part of an Island They thought a kind of Coffee...
    Posts
    1,933
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Is The Decode Tool come with it, so some of us here can help decode more tables for you?

    http://www.twcenter.net/forums/showt...B-Tables-(PFM)

  4. #4
    Sharp's Avatar Tiro
    Join Date
    Aug 2009
    Posts
    53
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Quote Originally Posted by AlexDragon View Post
    Thank you very much, thank god i been waiting for this, THank you man!
    Bad News:
    It doesn't work, or is it just me?
    Me too
    Last edited by Sharp; September 05, 2013 at 05:04 AM.

  5. #5
    Radious's Avatar I came, I saw, I modded
    Join Date
    Mar 2009
    Location
    Czech Republic
    Posts
    7,779
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Same error i guess:




    I puth there proper path for rome 2, but no luck, cant start it.

    Winner of the 2011 award: [Shogun 2] Favourite Unit Pack - Radious Unit Pack 1
    Winner of the 2012 mod awards: [Shogun 2] Favourite Overhaul, Unit Pack, Campaign AI and Submod
    Winner of the 2012 modder awards: [Shogun 2] Favourite Modder and DB Editor

  6. #6
    aiantas's Avatar Libertus
    Join Date
    Feb 2010
    Location
    GREECE
    Posts
    20
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    It does not work for me either!

  7. #7
    Splenyi's Avatar Sagittarius
    Join Date
    Mar 2012
    Location
    South Australia
    Posts
    3,423
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Nope, me either. Keep trying Daniu, we still love you either way!

    | IMPERIA ANTIQUITATIS - A REALISTIC REPRESENTATION OF ANCIENT WARFARE
    |
    | BETTER CAMPAIGN CAMERA | REALISTIC UNIT NAMES | USEFUL WEBSITES |
    | TJ08-E, 4670K, Gryphon Z87, 8GB DDR3, GTX 780, AX760i, NH-U12S, 250GB 840 SSD, WD 1TB Black |

  8. #8
    Libertus
    Join Date
    Jan 2012
    Posts
    4
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Works for me, captain, but can't edit too much in it. Nor does it make sense to me (casual observer here - messed around a bit with Shogun 2). Keep it up!

  9. #9
    adeno1's Avatar Munifex
    Join Date
    May 2013
    Posts
    47
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Works for me , thanks!
    [IMG]<a href="http://www.bildupload.com/index.php?image=6d8e66dbdee549421aa15dfc229764b3" target="_blank"><img src="http://thumbs1.bildupload.com/6d8e66dbdee549421aa15dfc229764b3.jpg" border="0"></a>[/IMG]

  10. #10
    adeno1's Avatar Munifex
    Join Date
    May 2013
    Posts
    47
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta


  11. #11
    Libertus
    Join Date
    May 2013
    Posts
    21
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    how do you get it work?

  12. #12
    Radious's Avatar I came, I saw, I modded
    Join Date
    Mar 2009
    Location
    Czech Republic
    Posts
    7,779
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    For me only errors, no clue whats wrong......

    Does it support all pack types? Cause Mitchs first version didnt worked for me aswell, but his V2 starts without issues.
    Last edited by Radious; September 05, 2013 at 06:03 AM.

    Winner of the 2011 award: [Shogun 2] Favourite Unit Pack - Radious Unit Pack 1
    Winner of the 2012 mod awards: [Shogun 2] Favourite Overhaul, Unit Pack, Campaign AI and Submod
    Winner of the 2012 modder awards: [Shogun 2] Favourite Modder and DB Editor

  13. #13
    husserlTW's Avatar Artifex
    Join Date
    Mar 2009
    Posts
    6,968
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    It shows db. Table names are colored black and red but all of them have blank content. Is it just a mutter of adjusting the R2 schema xml? Can you please upload the source code as well?
    Last edited by husserlTW; September 05, 2013 at 06:27 AM.




  14. #14
    JaM's Avatar Empire Realism
    Join Date
    Nov 2004
    Location
    Slovakia
    Posts
    11,679
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    what about these ones?

    1. _kv_fatigue_tables
    2. _kv_morale_tables
    3. _kv_naval_morale_tables
    4. _kv_experience_bonuses_tables
    5. _kv_rules_tables



    and also Battle_entities - its THE TABLE that controls unit running and charging speeds and many more...
    Last edited by JaM; September 05, 2013 at 06:17 AM.

  15. #15
    Ziuk's Avatar Cornicularius
    Join Date
    Oct 2008
    Location
    PL
    Posts
    287
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Keep up the good work and you will be deified during life

  16. #16
    daniu's Avatar 比你才牛
    Join Date
    Mar 2009
    Posts
    6,385
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    I uploaded a beta2 which I hope fixes the issue - it's one that only appears when you have the game installed which I don't have here right now.
    Updated OP.

    JaM, the _kv_tables look like they're all supported (the ones in crossed out in the OP didn't need any schema changes).
    I also started working on some table schemata (the ones in green).

    Husserl, I'll check in the files as soon as people can somehow run it or at about 3 pm CET, whichever is earlier.
    Tools: PFM 3 - EditSF 1.1.2

    Warscape Modding Guide
    Join the PFM User Group on Steam to receive PackFileManager update notifications.

    Don't need your Steam Trading Cards?
    I give you games for them.


    Respecto Patronum

  17. #17
    adeno1's Avatar Munifex
    Join Date
    May 2013
    Posts
    47
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Quote Originally Posted by mamang View Post
    how do you get it work?
    I just installed and started it , maybe u need visual c++ ? I also installed xna framework and framework 4.5 but i dont if it helps.

  18. #18
    husserlTW's Avatar Artifex
    Join Date
    Mar 2009
    Posts
    6,968
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    I've edited my previous post before reading your answer so I post again my question: Is it just a mutter of adjusting the R2 schema xml because it reads the tables but none of the tables content shown is shown .

    EDIT: changes must be done in both master and R2 schema xml or only to R2?
    Last edited by husserlTW; September 05, 2013 at 06:47 AM.




  19. #19
    Libertus
    Join Date
    May 2013
    Posts
    21
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    Quote Originally Posted by adeno1 View Post
    I just installed and started it , maybe u need visual c++ ? I also installed xna framework and framework 4.5 but i dont if it helps.
    i tried installing all of them.. not working. i will wait for fully working version. thanks anyway

  20. #20
    daniu's Avatar 比你才牛
    Join Date
    Mar 2009
    Posts
    6,385
    Tournaments Joined
    0
    Tournaments Won
    0

    Default Re: [TOOL] PFM 3.0 beta

    No, the strings in the database use ASCII instead of Unicode now (not a particularly bad move considering it takes half the space, but does mess up my trying to support all TWs a bit).
    I checked in now, might as well do more often.

    But yes, once you got the PFM running, the DecodeTool is available and we can work on the schemata.
    There seems to be a lot of splitting up to have been done, looks like I'll not be able to that by myself in a reasonable time.
    I'll go through the list in the OP, if anybody starts working on other tables, probably best to post that so nobody else needs to do double work.

    When you've finished a schema, press the "Show" button in the DecodeTool and copy/paste that here.
    Note that both the "entries" and "bytes read" on the bottom needs to fit.
    Last edited by daniu; September 05, 2013 at 06:51 AM.
    Tools: PFM 3 - EditSF 1.1.2

    Warscape Modding Guide
    Join the PFM User Group on Steam to receive PackFileManager update notifications.

    Don't need your Steam Trading Cards?
    I give you games for them.


    Respecto Patronum

Page 1 of 65 1 2 3 4 5 6 7 8 9 10 11 26 51 ... LastLast

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •