what nwn (foxpro) database file editor to use?

[Legacy_Calgacus]

               What utility do you use to edit the nwn database files?  What version of foxpro file is used in them?  Is there a free editor for this filetype?  I found some freeware programs that were lacking in or buggy in some features. There are some shareware too but they nag alot and cost too much  ( $40 ) to register. 
I need to make new files, edit them, add records, input/edit data etc
               
               

               
            

[Legacy_GhostOfGod]

               I haven't done much with database editing but I've messed around with DBF Commander. It seems to work pretty good and the best part...It's FREE!

Can find it here: www.elphsoft.com
               
               

               

                     Modifié par GhostOfGod, 06 octobre 2010 - 02:12 .
                     
                  

            

[Legacy_FunkySwerve]

               You should make the switch to NWNX - it allows alternate databasing with MySQL, which is FAR more flexible and much much faster. Linkage:

http://www.nwnx.org/



Funky
               
               

               
            

[Legacy_Calgacus]

               Thanks, I tried that tonight already but found it has a few bugs, still it might have to do.  Does the Foxpro Character type column have a limit of 255?  Another dbf editor allowed me to make larger columns.

PS: Is the visual foxpro format as saved out by this app safe to use?  

I keep getting this error in DBF Commander- tStruct: Cannot perform this operation on a closed dataset.
               
               

               

                     Modifié par Calgacus, 06 octobre 2010 - 03:17 .
                     
                  

            

[Legacy_Calgacus]

               i was thinking of nwnx too but I want this stuff to work in a single player mod too not just on servers and I'm guessing most people who play single player mods won't be interested in installing mysql.
               
               

               
            

[Legacy_tmanfoo]

               NWNX is setup for SQLite by default & works nicely.  You could probably run a single server PW off SQLite w/o any real issues.  So single player would be fine with it.  It's certainly worth the switch if you've got a large number of database calls, that default NWN database is *really* slow.
               
               

               
            

[Legacy_Calgacus]

               if I use it in a single player module how will the player who dls my mod use it?  Will I pack a runnable distro  with my mod so the end user doesn't need to do anything much - maybe just run the distro before starting up the mod in the server - can a player run the server and the player client off the same PC?
               
               

               
            

[Legacy_tmanfoo]

               You can run the dedicated server & NWN client off the same PC.  I'm not entirely sure of the license of NWNX, so you may need to look that part up.  Since you're running single player, is there any reason you can't just set local variables to a cursed/undroppable item on the PC?  I can't remember if you can set a struct to an item, but it's worth a look as well.  You make me curious as to what you're building there.
               
               

               
            

[Legacy_Calgacus]

               oh, I want to be able to swap out some dialog based puzzles without having to rebuild the mod.  The database wlll be read and the NPCs will speak the lines - puzzle introduction and clues.  The  puzzles are made online here: thelogicpuzzles.com

The idea is just really to enhance the replay value of the mod by allowing the addition of new puzzles.  Imagine a murder mystery quest that gets new clues and a new solution every play though - or one of  those "how to kill me" puzzles that changes on each play through.  For example see the Dragon Slayer theme on that website.  

it would be nice if I could add puzzles to the database files in a sort of batch mode rather than manually.  Maybe I can ODBC them from java or php.
               
               

               
            

[Legacy_tmanfoo]

               I like the idea, NWN always goes well with puzzles.  I looked around a bit & it seems like there are very few options for FoxPro at this point.  I did find a tool on the vault that looks like it might be useful.

http://nwvault.ign.c...r.Detail&id=106

I think failing that, writing it all into a struct might be easiest for portability, but you would have to fill in all the data.

Using a custom 2DA may be another option.  They can store 2 dimensional data tables as well.  As long as you follow the formatting you could build the 2DA files with a simple text dump.

http://nwn.bioware.c..._2DA_Format.doc

Running NWNx and a dedicated server seems a bit much for a single player module, and might complicate the usage to the point where people wouldn't bother.

I'd be interested in seeing it whenever you finish.  Thanks for the distraction, that website is helping me be more non-productive today.
               
               

               

                     Modifié par tmanfoo, 07 octobre 2010 - 04:41 .
                     
                  

            

[Legacy_Calgacus]

               For JDBC/ODBC I will try out StelsDBF from http://www.csv-jdbc....ad.htm#StelsDBF  it isn't free but maybe i can use the eval copy for what I need.



Some of the themes on that site aren't finished so some of the puzzles may not make sense, to be safe use the Deductive Detective, I'm pretty sure I finished that one..