user data

[sabret00the]

sorry for this, i've lost all confidence and knowledge in matters of coding for the night, so again i'm sorry for bothering you all.

but how would i select the data from the user table and userfield table as an array so i could call some of the data i.e.

Age
Location
Occupation
then some of the custom user profile fields

this is for a page powered by vBulletin but not a standard file (i.e. my own one).

[sabret00the]

$profile_info = $DB_site->query_first("SELECT (*)
FROM userfield
LEFT JOIN user ON (user.userid = userfield.userid)
$clause");

$DB_site->fetch_array($profile_info)


and then i can just call it in the templates as $profile_info['field14'] right?
i think is the query (still not good with these left joins

and how do i get the age and website/homepage?

[sabret00the]

*bump*

[AN-net]

the query looks good for profile fields and to get homepage etc. you have to look in the user table(im using vb3)

[sabret00the]

i can't even get the query to work in php my admin :(

[Xenon]

why not just use the fetch_userinfo() function of vb3? :)

[sabret00the]

cos i didn't know it existed :o

how would i go about using the fetch_userinfo() based on a static userid

i.e. fetch_userinfo(userid = $juserid, field24)?

[Xenon]

hmm, what i did was something like this when i need it:

$userid = xx;
$userinfo = fetch_userinfo($userid);

[sabret00the]

sorry to be a pain, just trying to grasp this still

ok so i would apply the above to the file (in php format)

but how would i call the information in the templates?

$userinfo[fieldXX]?

[Xenon]

exactly like that.

the userinfo looks like the bbuserinfo array :)

[sabret00the]

see, i'm getting a better grasp of all this

thank you very much stefan :D

[Xenon]

You're welcome :)

[sabret00the]

stefan you're a god amongst men :D

[Xenon]

*ggg*

thx ;)