Troubles calling data back into nwn

[Der Phobos]

I'm using the basic scripts supplied with nwnx, trying to call a speakstring of what I exported, however its not calling it back into the module. I built a php page to verify that the data is correct and that I am brining in proper data. The page displays the results I wrote just as they should be, however nwn cant call back the string. Anyone have any ideas of where to begin debuging, or any tricks?

[Urlord]

[Der Phobos]

string sVar = GetPersistentString(oPC, "Highland Saga");
SpeakString(sVar, TALKVOLUME_SHOUT);

string GetPersistentString(object oObject, string sVarName, string sTable = "pwdata")
{
string sPlayer;
string sTag;

if (GetIsPC(oObject))
{
sPlayer = SQLEncodeSpecialChars(GetPCPlayerName(oObject));
sTag = SQLEncodeSpecialChars(GetName(oObject));
}
else
{
sPlayer = "~";
sTag = GetTag(oObject);
}

sVarName = SQLEncodeSpecialChars(sVarName);

string sSQL = "SELECT val FROM " + sTable + " WHERE player='" + sPlayer +
"' AND tag='" + sTag + "' AND name='" + sVarName + "'";
SQLExecDirect(sSQL);

if (SQLFetch() == SQL_SUCCESS)
return SQLDecodeSpecialChars(SQLGetData(1));
else
{
return "";
// If you want to convert your existing persistent data to SQL, this
// would be the place to do it. The requested variable was not found
// in the database, you should
// 1) query it's value using your existing persistence functions
// 2) save the value to the database using SetPersistentString()
// 3) return the string value here.
}
}
_________________
Highland Saga: Black Dawn

[Papillon]

The easiest way to find problems like this is to enable full logging (level 2) in nwnx.ini and then have a look at the generated SQL statements. You can easily compare the SELECT to the actual data in the database, and see why no data is coming back.
_________________
Papillon

[Der Phobos]

I figured it out, thanks though.
_________________
Highland Saga: Black Dawn

[caloup]

You should call the function AFTER the define of this function, i think :

[Der Phobos]

first off they were in two diffrent scripts, one with an include of the sql_include.

Second the problem was something I tried setting up before I remembered that nwn doesnt realy have array objects. A script I thought I had removed but had not and was goofing everything up.
_________________
Highland Saga: Black Dawn