NWNX Problem?

[earlsignet]

Hi,
Iv been working with NWNX for a while and iv only recently run into a problem.

I wasnt sure where to post this as I believe it covers both scripting, nwnx and nwnx4 development.

My question is about how NWNX deals with results and queries. If i were to make a function that checks the database for a result and returns true or false, and then embeded that function within a while statement which loops through a different set of records, does NWNX return incorrect or incomplete results.

I dont think im explaining this properly so ill try and make an expample:-

[Grinning Fool]

You are correct, in that queries cannot be nested. There's no simple way to resolve this that I know of through NWNX.

However in many cases, a join can be performed in the SQL statement that will have the same effect (and will run faster, since it uses the SQL engine to do the work).

In your example:

SELECT resource_id FROM storage WHERE player_id=x and resource_type'W'
SELECT resource_name FROM resources WHERE player_id=X AND resource_id=Y

Can be combined to:
SELECT b.resource_id, b.resource_name
FROM storage a, resources b
WHERE a.player_id = x
AND a.resource_type = 'W'
AND b.player_id = a.player_id
AND b.resource_id = a.resource_id

This will return a list of resource(skills?) that the PC has, instead of requiring you to loop through it in script.
_________________
Khalidine, a NWN2 persistent world

Looking for volunteers.

[earlsignet]

Thats a good point.

Whenever coding with NWNX i always forget im dealing with the MYSQL database and dont always remember i can do similar database query's that i would use in PHP.

That seems to be a much better way of doing it, thanks for the suggestion. I will do some models and see if your solution is viable in the system it is required it.

[earlsignet]

Thankyou very much.

I managed to sort my database out to I can make better use of it with more common MySQL statements. Seems to be working fantasticly.

I do have one question though.

In working with MySQL i'v never tried a statement that looks up multiple rows returned in one resultset.

Say the skills table for example contained entries for skills and one column was called "NAMES" and there were two rowes i need to return in one resultset that related to two seperate values from one record in another table. Is there a way of doing this without referencing to the same table twice:

SELECT b.resource_id, b.resource_name, c.resource_name
FROM storage a, resources b, resources c
WHERE a.player_id = x
AND a.resource_type = 'W'
AND b.player_id = a.player_id
AND b.resource_id = a.resource_id
AND c.resource_id = a.resource_id

Iv got a function like the above working but im not sure if thats the only way of doing it.

[Grinning Fool]

You're looking to get values from two different rows in the same table, as two different columns in the resultset? If that's correct, then the only way I know of is to reference the table twice.
_________________
Khalidine, a NWN2 persistent world

Looking for volunteers.

[earlsignet]

Thats correct and thats what I have.

I thought it made sense.

Thankyou for the confirmation.