where are the sql queries
 

help a newb...
where are the sql queries? let's say u want to include users.field2 in the 'welcome back' text...

all i see is $username so i can understand the necessity for an inner join with the userfield table on userid=userid.

but where are the queries???

well i seem to have found them!

index.php, global.php... so where is the $bbuserinfo being populated with the fields in its array? i'm trying to find this in the global.php file.

seems to me that all i'd have to do is inner join it with the userfield table on userid and it would get inserted in the array automatically.

i'm concerned if i populate this array with another field that i may effect something else in the software.

any comments/suggestions?

The $bbuserinfo array is populated inside admin/sessions.php..

But you don't need to hack it to achieve your aim because what you are trying to achieve is already built-in in default vb code.

You can use $bbuserinfo[fieldX] variable to access visitor's userfield values like
$bbuserinfo[field1] $bbuserinfo[field2] etc.

you rock, thanks man!

i was well-geared up for an assualt on the code!

irons down!