Help with dm_set Leto functions

[issacjr]

Hello I am Having a bit of Trouble getting the Simtools dm_setstr, dm_setcha, ect commands to work i will not make any assumptions as to why but i'm also having trouble with my APS however i belive the two problems are unrelated.

This is the nwnx-odbc log, it's saying i have a table error for my persistant location script, but i belive this has nothing to do with the leto.

NWNX ODBC2 plugin V.0.9.2.4
(c) 2005 by Ingmar Stieger (Papillon) and Jeroen Broekhuizen
visit us at http://www.nwnx.org

o Logfile maximum size limit is: 524288 bytes
o Log level: Everything will be logged.
o Using SQLite connection.
o Hooking SCO....hooked at 5d3560
o Hooking RCO....hooked at 5d3440
o Connect successful.
o Got request: SELECT val FROM pwdata WHERE player='issacjr' AND tag='AAwerewolf Chick' AND name=''
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='waterdeep' AND name='FKY_CHT_BANSHOUTQYUPQKRT'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='waterdeep' AND name='FKY_CHT_BANPLAYERQYUPQKRT'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT name, val FROM pwdata WHERE player = 'issacjr' AND tag = 'AAwerewolf Chick' AND name LIKE 'FKY_CHAT_~';
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT player FROM pwdata WHERE player='issacjr' AND tag='AAwerewolf Chick' AND name='FKY_CHAT_LANG9'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('issacjr','AAwerewolf Chick','FKY_CHAT_LANG9','1',0)
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='issacjr' AND tag='AAwerewolf Chick' AND name='FKY_CHAT_LANGBASE'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('issacjr','AAwerewolf Chick','FKY_CHAT_LANGBASE','1',0)
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='~' AND tag='' AND name=''
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('~','','','',10)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='issacjr' AND tag='AAwerewolf Chick' AND name=''
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='waterdeep' AND name='FKY_CHT_BANSHOUTQYUPQKRT'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='waterdeep' AND name='FKY_CHT_BANPLAYERQYUPQKRT'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT name, val FROM pwdata WHERE player = 'issacjr' AND tag = 'AAwerewolf Chick' AND name LIKE 'FKY_CHAT_~';
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT player FROM pwdata WHERE player='issacjr' AND tag='AAwerewolf Chick' AND name='FKY_CHAT_LANG9'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('issacjr','AAwerewolf Chick','FKY_CHAT_LANG9','1',0)
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='issacjr' AND tag='AAwerewolf Chick' AND name='FKY_CHAT_LANGBASE'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('issacjr','AAwerewolf Chick','FKY_CHAT_LANGBASE','1',0)
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='~' AND tag='' AND name=''
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('~','','','',10)
! SQL Error: no such table: pwdata
o Got request: SELECT val FROM pwdata WHERE player='issacjr' AND tag='AAwerewolf Chick' AND name=''
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='waterdeep' AND name='FKY_CHT_BANSHOUTQYUPQKRT'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT val FROM pwdata WHERE player='~' AND tag='waterdeep' AND name='FKY_CHT_BANPLAYERQYUPQKRT'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT name, val FROM pwdata WHERE player = 'issacjr' AND tag = 'AAwerewolf Chick' AND name LIKE 'FKY_CHAT_~';
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: SELECT player FROM pwdata WHERE player='issacjr' AND tag='AAwerewolf Chick' AND name='FKY_CHAT_LANG9'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('issacjr','AAwerewolf Chick','FKY_CHAT_LANG9','1',0)
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='issacjr' AND tag='AAwerewolf Chick' AND name='FKY_CHAT_LANGBASE'
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('issacjr','AAwerewolf Chick','FKY_CHAT_LANGBASE','1',0)
! SQL Error: no such table: pwdata
o Got request: SELECT player FROM pwdata WHERE player='~' AND tag='' AND name=''
! SQL Error: no such table: pwdata
o Sent response (0 bytes):
o Got request: INSERT INTO pwdata (player,tag,name,val,expire) VALUES('~','','','',10)
! SQL Error: no such table: pwdata
o Disconnecting from database.


this is my Leto log


NWNX-Leto module (build 03 - FF)
(c) 2004 by David Frauzel (dragonsong), [e-mail]
Information and support: http://weathersong.infopop.cc

* Loading LetoScript.dll...
* LetoScript metamodule activated (13.37ms).
<681.9µs> Req:"SCRIPT", Param:"print q<C:/NeverwinterNights/NWN/servervault/issacjr/> + FindNewestBic q<C:/NeverwinterNights/NWN/servervault/issacjr/>;"


this is my serverlog1

[Tue Jan 29 12:02:07] Loading Module: City of Splendors
[Tue Jan 29 12:02:07]---- Server Options ----
Max Players: 6
Char Levels: (1-40)
Player Password: NO
DM Login Enabled: YES
Server Admin Login Enabled: YES
Post Game To Internet: YES
Game Type: Action
Difficulty: 1
PVP Setting: PARTY
Vault: LOCAL
Only One Party: YES
Enforce Legal Characters: YES
Item Level Restrictions: NO
Player pausing: DISABLED
Auto Save: Enabled
Saving Characters in Saved Game
---- End Server Options ----
GENERIC SCRIPT DEBUG STRING ********** NW_ORCAClass 1 100
GENERIC SCRIPT DEBUG STRING ********** NW_ORCAClass 2 100
GENERIC SCRIPT DEBUG STRING ********** NW_ORCAClass 3 100
GENERIC SCRIPT DEBUG STRING ********** D100 Roll 82
**DESIGN***
******1book007 is an invalid item template. Please report as bug to Brent.
*******
Connection Attempt made by issacjr (QYUPQKRT)
[Tue Jan 29 12:03:16] issacjr (QYUPQKRT) Joined as Player 1
[Tue Jan 29 12:04:26] issacjr Left as a Player (0 players left)
Connection Attempt made by issacjr (QYUPQKRT)
[Tue Jan 29 12:05:21] issacjr (QYUPQKRT) Joined as Player 1
**DESIGN***
******0book016 is an invalid item template. Please report as bug to Brent.
*******
SIMTools leto edit: $RealFile = q<C:/NeverwinterNights/NWN/servervault/issacjr/aawerewolfchick.bic>;$EditFile = $RealFile + '.utc';FileRename $RealFile, $EditFile;%bic = $EditFile or die;/Str = 45;%bic = '>';close %bic;FileRename $EditFile, $RealFile;
[Tue Jan 29 12:06:35] issacjr Left as a Player (0 players left)
Connection Attempt made by issacjr (QYUPQKRT)
[Tue Jan 29 12:07:06] issacjr (QYUPQKRT) Joined as Player 1
[Tue Jan 29 12:08:09] issacjr Left as a Player (0 players left)
[Tue Jan 29 12:08:21] Server Shutting Down


i think that is all the logs you shuld need to see, I did set my path in fky_constants and my other simtools functions seem to be working, also my account is set up with dm acces.

Please take a look and tell me what you think
Issac

[FunkySwerve]

Are you using the version of Leto that came with SIMTools?

Funky

[FunkySwerve]

Anyway, I see a few issues.

First, you're getting a table error because you didn't follow the readme instructions:
"Now login. You may experiment to your heart's content, but there is one thing you will have to do: click the sign named "Database - Read Me!" (read the warning just below if you are already using NWNX for other datqabase applications). That will set up the SQLite database to accept the data that SIMTools will be sending it."

To fix the table error:
1) Load SIMTools_Test module instead of the module you plan to run, on the computer you plan to run your module on, using nwnx to load it.
2) Login with player or dm client anc click on the Database sign to create the database.
3) Success!

With regard to your leto problem, it looks like the edit is never hitting the leto module. Do you have reset module when empty turned on? If so, and you are testing solo, this will cause the letoscript to abort, because the mod shuts down before it can edit the bic.

Failing that, your configuration settings are probably wrong. You need to change them in fky_chat_config, not the const script. You say your account is set up with dm access. Make sure that const int LETO_FOR_ADMINS_ONLY = FALSE; and that const string VAULTPATH_CHAT is set to your vaultpath, and not left blank.

Please let me know if that fixes it. If not, I'll see what else I can think of.

Funky

[issacjr]

Just to be Certain I Re-downloaed the installer and tried the test again and it was to no further result. I Export the characters on Cl exit could that be it?

Issac

[FunkySwerve]

If you reinstalled, make sure to go through the readme steps again. I'll post them here for you:

I am writing this how-to for Windows users. I assume that Linux users are generally savvy enough to manage installation on their own, and get what information they need from this readme. By default SIMTools uses the standard Bioware database. With a flip of a switch in the fky_cht_config script, however, it is ready for use with he built-in database that comes with NWNX. If you have no idea what that means, and this is the first time you will be using NWNX, don't worry. If you are a Linux user, or are already using the old version of Letoscript, or you want to use another database program, this will not work for you. If that is the case, or if you are curious about other uses of NWNX (it is amazingly versatile), you may find help here:

http://www.nwnx.org/   (NWNX homepage - links to their forum)

I'm including a slightly long-winded explanation first, and then a checklist below that. Setup consists of 2 parts, software installation, and Scripting. This means that you must have NWNX installed in your NWN folder (Software), and the correct scripts installed in your module (Scripting).

Detailed Explanation
=========

Software Installation, Setup and Configuration
---------
I have included 9 files in the self-extracting file named NWNX2 and plugins.rar.exe. Double click it, and put all 9 in your NWN folder. The normal path to the NWN folder in a default installation is C:\NeverwinterNights\NWN. The files are named:
NWNX2.exe
NWNX.INI
nwnx-module.dll
madCHook.dll
nwnx_chat.dll
nwnx_odbc.dll
nwnx_resetplugin.dll
LetoScript.dll
nwnx_leto.dll

Normally to host a server you would use nwnserver.exe, and select the module to host, player limit, and so on, from there. To use NWNX and nwnx_chat, however, you MUST launch NWNX2.exe. It will load nwnserver for you, and will restart it most of the time if it crashes. You can still make most changes like player limit directly in nwserver, but you will need to choose the module you are going to load beforehand, in the NWNX.ini file. The NWNX.ini file included it setup to launch the SIMTools_Test.mod. Double click the NWNX2.exe to start up NWNX. You'll see the NWNX box pop up, and a few moments later nwnserver will load. Note that the module name shows as unselectable, because you must set it in the ini (I will explain how next). Now login. You may experiment to your heart's content, but there is one thing you will have to do: click the sign named "Database - Read Me!" (read the warning just below if you are already using NWNX for other datqabase applications). That will set up the SQLite database to accept the data that SIMTools will be sending it.

//////////////
ADVANCED USERS: If you are already using nwnx for other applications, BEFORE YOU CLICK THAT DATABASE SIGN, verify that you are not using the default database table 'pwdata' for anything else. If you are, and you click the sign, ALL YOUR DATA WILL BE LOST. If you are using the default nwnx pwdata table, you are already set up to use SIMTools and SHOULD NOT TOUCH THAT SIGN!!!
\\\\\\\\\\\\\\

The only necessary aspects of the system in the demo mod are the scripts, though there are two items included that list all the possible commands for easy reference. They also list the !list commands, !list emotes, and dm_listcommands commands, which will pull up identical lists in your combat log.

To run your own module using NWNX:
Double click on NWNX.ini to edit it. Find the line that reads:
ModuleName = "SIMTools_Test"

Change the name in the quotes to the name of your module. For instance, if your mod's filename is UberFastLevelling.mod, the line should look like:
ModuleName = "UberFastLevelling"

That's it, save the file and you're set. Clicking on NWNX2.exe will now load your module with NWNX running. All NWNx plugins that you have installed will run correctly (though if you are following this tutorial exactly the only plugins installed are ODBC and nwnx_chat - don't worry about what ODBC is, you can read more on the NWNX page if you like, it handles the database).

//////////////
ADVANCED USERS: If you are already using nwnx for other applications, simply add the dlls you don't have to your NWN folder (making sure you are using Letoscript 24, or another recent version), and add the following 4 lines at the bottom of NWNX.ini:

[CHAT]
chat_script=fky_chat
server_script=fky_chat_srv

\\\\\\\\\\\\\\


Scripting
---------
Once your software is set up to use NWNX, you must still put the scripting commands in your module that will tell NWNX what to do. This is just like importing any other script into your module.  There are only two files needed for NWNX to hook into your module:

aps_include
aps_onload

Aps_include is included in the SIMTools.erf file, and aps_onload was merged into fky_chat_modload, which is also included in that erf. Unzip SIMTools.zip. Put the SIMTools_Test.mod in your modules folder in the NWN folder, and the SIMTools.erf in the erf folder in the NWN folder. Import* the Legendary_Levels.erf into your module. Ignore any missing resources warnings. Save your module, then build** it, then save again.

Now that all the scripts you need are in your module, you need to add a few scripts to the module events. With your module still open in the toolset, click the Edit tab, and select Module Properties. In the events tab, put the following scripts in the following events:

Event Script
----- ------
OnActivateItem  x2_mod_def_act (Or whatever script you use for tag-based scripts, this is just the Bioware default for tag-based scripts. If you do not use tag-based scripts, you should put the fky_chat_notbs script in this event, or merge it with your existing OnActivateItem script if you have one.)
OnClientEnter fky_chat_clenter
OnClientLeave fky_chat_clexit
OnModuleLoad fky_chat_modload
OnPlayerLevelUp fky_chat_levelup

If you already use your own custom scripts in those events, you will need to merge the scripts. Telling you how is beyond the scope of this tutorial, so if you find yourself in this situation, simply post the two scripts on the Bioware scripting forum and ask for help combining them. The address of the scripting forum:

http://nwn.bioware.com/forums/viewforum.html?forum=47

You're almost done! All you need to do is make some changes to the fky_chat_config script. Open the script editor, and open fky_chat_config. Most of the changes are explained in detail in that script. Two, however, are very important and worth mentioning here:
1) First, you need to select or create three waypoints at locations you want players to be sent when dms use the dm_porthell, dm_portjail, and dm_porttown. The waypoints need not be in 'hell', a jail, or a town; you can set them them whereever you like. Once you have created them, ensure that their tags are descriptive enough to be unique, and then enter those tags in the DM_PORT DESTINATIONS section of fky_chat_config.
2) Second, you must set the VAULTPATH_CHAT const string to your servervault path, if you want the !delete commmand and the dm ability and save setting commands to work. There are sample default paths shown in the config file.
3) Third, you must enter the cdkeys of everyone you want treated as a dm in this system into the VerifyDMKey function. If you do not, none of the dm commands or message routing will function for dms.
4) Fourth, you must enter the cdkeys of everyone you want treated as an admin in this system into the VerifyDMKey function. If you do not, none of the dm commands or message routing will function for admins.
5) Fifth, you must enter the names of your subraces in the SubraceSpeaks functions, designating which of your subraces speak what languages. If you do not, only class and race languages will work.
//////////////
IF YOU DO NOT KNOW THE CD KEYS of the people you need tagged as dms, simply skip the cd key entry steps for the time being. When you run the module, you will be able to use the !playerinfo command on anyone whose cdkey you need. Please note that these cdkeys are the PUBLIC versions of the private keys, readily available on any server. There is no security threat in being able to see them. Once you have the needed keys, return to this script and enter them. You will have to build the module again and save it again for the change to take.
\\\\\\\\\\\\\\

After entering in the waypoints and cd keys, save the script, exit the script editor. Save the module, then build it again, then save a final time. You're done!

Footnotes:
---------
*How to import: Open your module in the toolset. Click the File tab, and select Import. This will pull up a window allowing you to choose what erf to import. By default, it starts in the erf folder in NWN. Select the Legendary_Levels.erf, click Open. You should ignore any missing resource errors, as they are not really missing. These errors improperly fire for includes that do not have compiled versions, even though they do not need compiled versions.

**How to build the module: Click the Build tab, and select Build Module. Because you only need to build the scripts for this, to save time you can build only the scripts. Click the Advanced Controls box, and make sure tat only Compile has a check in it, and only Scripts is selected below it. Click the Build button. You should not get any errors, and if you do, you should fix them. Scripts that do not properly compile use their last successful compile, and any changes made to them are ineffective.



Checklist
=========
Software
1) Double click NWNX2andNWNX_chat.exe, and put all 9 files in your NWN folder.
2) Load the SIMTools_Test.mod from nwnx.exe and click the sign named "Database - Read Me!" if you do not already have a nwnx SQLite database set up. First time NWNX users should click the sign.
3) Double click on NWNX.ini to edit it. Find the line that reads:
ModuleName = "SIMTools_Test"
and change it to the name of your mod (leave off the .mod extension)

Scripting
1) SIMTools.zip. Put the SIMTools_Test.mod in your modules folder in the NWN folder, and the SIMTools.erf in the erf folder in the NWN folder.
2) Import SIMTools.erf into your module. Ignore the missing resources warnings. Save  your module, then build it, then save again.
3) In Edit/Module Properties/Events, set the OnClientEnter event to fky_chat_clenter, the OnClientLeave event to fky_chat_clexit, the OnModuleLoad event to fky_chat_modload, the OnPlayerLevelUp event to fky_chat_levelup, and either the x2_mod_def_act script or the fky_chat_notbs script in the OnActivateItem event.
4) Configure the fky_cht_config script for the settings that you want. You must designate 3 waypoints in that file for 3 of the dm-port commands, enter your servervault path, list the cd keys of everyone that you want the system to treat as a DM or Admin, and designate what languages your subraces speak if any.

Running the module once NWNX is installed in your NWN folder and the SIMTools system is installed in your module:
1) Double click NWNX2.exe to start NWNX. A few moments later nwnserver will load.


I'll be gone for the next 4 hours, but will check this thread when I get back.

Funky

[issacjr]

Thanks for the help Funky, I did do a full reinstall and used the SIMTools_Test module and clicked the sign, and that has completely fixed the "pwdata" table errors. I also attempted to use the dm_set commands in the test module and they work fine. So I went back to my module doublechecked the includes saved did a build compile and the set commands did not work !@! then i played with the config a few times trying different settings and still had no luck, so I coppied the scripts from the Simtools mod into my mod with an .erf did a complie build and saved and still the command isn't cutting it. Howevver whatever it is it's something in my module not the Simtools So it's just a matter of elimination from here out.

Once again thanks for your help i would have never fixed that table error on my own.

Issac