NWN-FF is the fastest solution available on NWN to access data into a MySQL DataBase, and it also provides many additionnal unique features.
NWN-FF 4.1.0 is a set of complementary projects with all sources included. An erf and a demo module are also provided. It's fully compatible with APS/NWNX 2 and can use NWNX 2 plugin.
It is very easy to start with NWN-FF: the documentation has been rethought, and you don't need to worry about database or table creation; NWN-FF will handle that for you.
If you want to use a real database in you NWN module, then take this: it's fast,it's easy to use, and it's free :)
I hope you'll like it.
FF
Please share your experience on NWN-FF Bioware guild: http://nwn.bioware.com/guilds_registry/viewguild.html?gid=7729
Hello i run a PW with persisten access to MYSQL database. I used NWNX2 and i try this NWN-FF. FastFrench you made a good work: Server monitor tool is much better than NWNX2 and NWN-FF is really faster. But i have found some bugs and i have some ideas. 1) you profiler need an option to limit result file txt size (like nwnx2). This txt become 100 mb in few hours in my server. 2) your profiler reports only script times not area and npc timings like nwnx2 profiler (nwnx2 uses @ and $ characters for npc and area times) It is very important because pathfinding of areas is very CPU intensive in NWN, and if you have an area with many o bad placed placeables and npcs, your cpu is drained and you profiler does not say this to me. 3) I install all using instructions but for me all PC ff functions dont work. ff_GetPCpersistentInt does not work, but ff_GEtPersistentInt works. I dont known why, i had no time to investigate) 4) I find a bug (i think). In your ff_ functions you dont Sqlencode the valuename so if i write for example ff_getpersistentint("bla ' bla") i create an sql syntax error. Insted in customized aps_include, all is ok. 5) In your html istruction file when you write about conversion from nwnx2 to nwn-ff you don mention new Sqlencode function. SO initially my old tables dont work (then i see that i must convert tables in new format,adding in ff_buildtable) Honestly i think that new encode/decode function are NOT a good idea. Encode is not faster at all. Decode is used ONLY when i getpersistentstring and it is faster ONLY when i have a "'" in string i retrieve from database. I think it is a very very minimal speed gain for breaking nwnx2 tables compatibility and to make addizional functions in ff_buidtable to convert all tables. But it is only a my idea.
Posted by Fleshmelter at on10/27/05
@scott1uol If you still check in on this board, you need to have Mysql running inorder to avoid the freeze at the player screen. Ya prolly already got the answer, but eh...maybe someone else needs it :) _________________________ PW Action Server: | Chaosgate |
Posted by Fleshmelter at on10/27/05
@scott1uol If you still check in on this board, you need to have Mysql running inorder to avoid the freeze at the player screen. Ya prolly already got the answer, but eh...maybe someone else needs it :) _________________________ PW Action Server: | Chaosgate |
Posted by Fleshmelter at on10/27/05
First off I've never posted on your contribution to the NWN community, I shall remedy that now. I've always had trouble trying to implement a Mysql database, but through alot of trial and error and your very well written document I was able to thumb it out. Mysql tables was still a problem, and then you solved that with the buildtables script in your system. No slight to NWNX, but i truly found your system very user friendly. After I had my issues with Bioware database(lags like the devil) I pretty much gave up on my PW. You have given me back my love for building cause now I can use the very fast Mysql database, and that I truly thank you for. I'm not a scripting genius, but definetly I can pick up things or two by looking at other peoples work and you made it that much easier, cause the installment of your system was almost hands free. Well I guess thats enough from me on how I love this NWN-FF, so I'll just say thanks again for putting out this wonderful tool. PS. You might want to work on the persistent chest though, it has a ridiculous dupe bug.....put an item in close chest it saves, open chest take it out....open chest again and hey! its there again. I did this with a stack of 9 potions, didn't really try anything else. Just thought i'd report it...although you prolly know already. _________________________ PW Action Server: | Chaosgate |
Posted by FastFrench at 2005-10-2009:49:53
18.10.2005: v 4.1.0 With this version 4.1.0, NWN-FF now supports saving and retrieving objects from a MySQL database (RCO/SCO). This new feature is an adaptation of NWNx/APS equivalent, with of course some additional optimizations. All rarely used parts of NWN-FF have been removed: mainly all ODBC stuff, so now NWN-FF only works either with MySQL or no database. Also FF_translator.exe and the archaic versions of Speech support (only NWNx_FFSpeech is now provided and supported). In this version, I?ve mainly integrated all the interesting points from NWNX/APS into NWN-FF, the same way NWNX/APS included several features first introduced into NWN-FF. Thanks to Papillon, Xildjian, Dazzle, Isilweo for their work. I?ve also added the several functions from NWNX/APS into NWNX_Functions plug-in : SetDescription (only usable for items and placeables) and SetName (Item, placeables and MapNotes). I?ve also included many new functions, written by different NWN community member (thanks to Xildjian, xildjian@comcast.net for DeleteChar, Isilweo for SetName / SetDescription, Dazzle and NWNx team for most of the other functions). I?ve also included in the package (both demo module and erf importation file), a ready-to-use persistent chest. All you have to do is to get it from the palette (magical chest) and put it on the map. If you want to have several chests, better give a unique tag for each one. As I?ve found it convenient, I?ve also included Papillon?s NWNx_Resman.dll. This is the exact original, I?ve done no adaptation on this one. Like all NWNx plugins, it works with no trouble on NWN-FF. Here is the list of all new functions coming with NWN-FF: Database related functions, dealing with objects // Store an object for that PC on a specific Placable (chest...) void ff_SetPersistentObject(object oOwner, object oObject, object oPlacable=OBJECT_INVALID, string sTable = "RCO_SCO"); // Retrieve the first object for that PC on a specific Placable (chest...) object ff_GetPersistentObjectFirst(object oOwner, object oPlacable=OBJECT_INVALID, string sTable = "RCO_SCO"); // Retrieve the next objects ('til return NULL) object ff_GetPersistentObjectNext(object oOwner, object oPlacable=OBJECT_INVALID); // Remove all objects associated with that player on a given placable void ff_CleanPersistentObject(object oOwner, object oPlacable=OBJECT_INVALID, string sTable = "RCO_SCO"); //And the following functions are provided for NWNx/APS compatibility: object GetPersistentObject(object oObject, string sVarName, object oOwner = OBJECT_INVALID, string sTable = "pwobjdata"); void SetPersistentObject(object oOwner, string sVarName, object oObject, int iExpiration = 0, string sTable = "pwobjdata"); //Plus this bonus function, very useful to handle persistent inventories (chests?) void DeleteAllPersistentObject(object oObject, string sTable = "pwobjdata"); New helper set of functions, coming with NWNx functions plugin. void ff_SetGoldPieceValue(object oObject, int iValue); void ff_SetName(object oObject, string NewName); void ff_SetDescription(object oObject, string NewDescription); string ff_GetDescription(object oObject); void ff_SetBodyPart(object oPlayer, int nPart, int nType); int ff_GetBodyPart(object oPlayer, int nPart); void SetLockDC(object oChest, int DC); void ff_ChangePlayerAppearance(object oPlayer, int nPart, int nType); void ff_ChangePlayerAppearance(object oPlayer, int nPart, int nType); void ff_DeleteThisChar(object oPC);
Posted by kenpo_kid31 at 2005-09-0909:13:35
help i need to use a database for the crafting sys on my server but i dont know how can any help me plz time_spacekenpo@msn.com or post here really need help have no idea where to start.... _________________________ Time is the Fre in Which we Burn
Posted by scott1uol at 2005-08-0812:17:57
I installed NWN-FF following the instructions carefully, was able to pull up the sample module, however when I try to test the module or to play it, it gets to the player select screen and then freezes. Has anyone else encountered this? All I am looking to do is create, drop, maintain and retrieve data from SQL tables in my modules.
Posted by red at 2005-07-1014:07:41
French I love this system thanks for this it is fast and reliable and pretty easy to set up. I wondering if you would be able to help me with a script adaptation I am working on. it is under "Help needed in adapting a script please" in the fast french forum. Thanks.
Posted by FastFrench at 2005-06-2102:04:54
Recipes? You should tell me more about your mod to get some help. Depends what kind of recipes you're talking about. Your problem doesn't seem to be very database-related.
Posted by Moradin at 2005-06-1207:48:32
I've been trying to figure out a way to leverage this system to make racial and subrace based recipes...so far the best I've come up with is recipes that require a tool only usable by the race or subrace... any idea for a more elegant solution? Perhaps adding the race/subrace info to a table?
Site
