help with script

[DM_Vecna]

I am not sure how to write this yet as I am still gettign used to scripting with NWNX. I was hoping someone could give me a hand.

/////////////////////////////////////////////////////////////////////////////////
string sSQL = "SELECT " + sFactionFocus + " FROM tbl_factions WHERE faction_name='" + sTargetFocus + "'";

SQLExecDirect(sSQL);

int nAdjustRep = StringToInt(sSQL);

fDelay = 2.0 * AWE_LOAD_FACTOR;

DelayCommand(fDelay, AdjustReputation(oTargetFocus, oFactionFocus, nAdjustRep));

I am trying to pull nAdjustRep from the table tbl_factions but I am not sure if this is the correct way.

thanks for the help!

[Gryphyn]

[Fireboar]

[DM_Vecna]

I am still having problems with the script in mention. It compiles but maybe someone can check the MySQL syntax and make sure I am using it correctly?

I am not sure how to post scripts here within a boxed text format but here it goes.

////////////////////////////////////////////////////////////////////////////

void PRR_LoadModule()
{
AWA_DEBUG( "Loading faction information...");
int nNth = 0;
object oTargetFocus = GetObjectByTag("FACTION_FOCUS", nNth);
while(oTargetFocus != OBJECT_INVALID)
{
//int nAdjustRep = 0;
int i = 0;
object oFactionFocus = GetObjectByTag("FACTION_FOCUS", i);
float fDelay;
while(oFactionFocus != OBJECT_INVALID)
{
//string sPlayerID = GetLocalString(oPC,"ID");
string sTargetFocus = SQLEncodeSpecialChars(GetStringLowerCase(GetName(oTargetFocus)));
string sFactionFocus = SQLEncodeSpecialChars(GetStringLowerCase(GetName(oFactionFocus)));

SQLExecDirect("SELECT " + sFactionFocus + " FROM tbl_factions WHERE tbl_player_player_character='" + sTargetFocus + "'");
if (SQLFetch())
{
int nAdjustRep = StringToInt(SQLGetData(1));
//float fDelay = 2.0 * AWA_LOAD_FACTOR;
fDelay += 0.10;
DelayCommand(fDelay*AWA_LOAD_FACTOR, AdjustReputation(oTargetFocus, oFactionFocus, nAdjustRep));
//DelayCommand(fDelay*AWA_LOAD_FACTOR, AWA_DEBUG("Setting how "+GetName(oFactionFocus)+" feels about "+GetName(oTargetFocus)+" to "+ IntToString(nAdjustRep) +" a t"+ FloatToString(fDelay,10,5)));
int nNewRep = GetReputation(oTargetFocus, oFactionFocus);
DelayCommand(fDelay*AWA_LOAD_FACTOR, AWA_DEBUG("New results "+GetName(oFactionFocus)+" feels about "+GetName(oTargetFocus)+" = "+IntToString(nNewRep)));
}
else
{
AWA_DEBUG("PRR ERROR: could not SELECT "+GetName(oFactionFocus)+" FROM tbl_factions WHERE tbl_player_player_character= "+GetName(oTargetFocus));
}
i++;
oFactionFocus = GetObjectByTag("FACTION_FOCUS", i);
}
nNth++;
oTargetFocus = GetObjectByTag("FACTION_FOCUS", nNth);
}
DelayCommand(0.8, AWA_DEBUG("Finished loading all factions."));
}

[Fireboar]

At a glance, tbl_player_player_character - does this field actually exist in tbl_factions? Seems like an odd name for a field. It might be helpful if you listed your database structure.

[DM_Vecna]

Is there a quick way to print out database structure or a preferred method for you to review it or should I just wing it?

Thanks!

ALso that is a real column. It was renamed when MySQL WOrkbench make the one to many connection.

[ShaDoOoW]

Not exactly sure what you want to see but im using MySQLAdministration tool and its wonderfull. I can view table structure and change it manually, no need to do it via script. Also I can view table data and change them manually...

You can found it at mysql download page.
_________________
Community Patch / NWNX Patch / NWNX Files / NWNX Connect

[Argonn]

Maby a little late,

But from reading you code... oFactionFocus and oTargetFocus are the same object.

Both are objects with the tag "FACTION_FOCUS" that you loop 2times trough.

For every "FACTION_FOCUS" object you loop trough all "FACTION_FOCUS" objects again.. Weird code

And if you Tablename is 'tbl_factions' and your Column name is 'tbl_player_player_character', your code looks good ( SQL wise )

[Lokey]

Since it's bumped already...