This is an incomplete prototype demonstration of an SQL-Like layer for NWN's native Database. It was originally developed for The Linked Module Project in late Summer of 2005. This SQL-Like layer is no longer maintained. However it does exist in a mostly functional state.
This module uses Knat's NBDE and will create NWN database entries called TLMP_LINKMANAGER. This is not a ready-to-use system. This contains many flaws and bugs. It is only provided as is, as a theoretical study of a inter-module, individually player instanced, queryable database system. Documentation is not provided.
cb_inc_querypars and cb_inc_queryrout are the principle scripts for the parsing engine and search routines.
Placeables is the only available table.
Available Commands: SELECT column (or *) FROM Placeables WHERE column=,<,>,<=,>=,!=,LIKErow AND/OR; INSERT INTO Placeables (Tag, Area, Hitpoints, Looted) VALUES ('string', 'string', int, int); DELETE column (or *) FROM Placeables WHERE column =,<,>,<=,>=,!=,LIKE row AND/OR; UPDATE Placeables SET column=value WHERE column =,<,>,<=,>=,!=,LIKE row AND/OR;
multiple ANDs ORs supported
Comments and questions are welcome, but I ask that you refrain from voting. 2/26
Posted by nereng at 2006-02-25 05:12:39 Voted 9.75 on 02/25/06
The only niggling little problem with this is that it was never finished! Does the fact that you posted it here mean that your interest in it has been rekindled? You know, it would make a certain guild leader extremely happy if his two little demo modules were to be made persistent somehow... ;)
Cheers!
Posted by Knat ( 84.172.xxx.xxx ) at 2006-02-23 00:08:51
Very interesting ! i will try this out once i come home from work today.
i currently try to implement an external database viewer (coded in C#, .NET 2.0) for NBDE with the possibility to retrieve, manipulate and store nwn database objects in a user friendly fashion.
i will give you guys more feedback soon...
like "delete all variables with a reference to player XY"
You must be Logged In to post comments in this section.
Site
