Where is the user's 'Location' column stored?

[suttercain]

Hi guys,

I have been looking through most of the tables and cannot find where the user's location is stored. I need it to display on external VB pages. I checked the 'user' table, but no luck...

anyone?

Thanks.

[Farcaster]

By location, do you mean the profile field "location"? If so, that is in the userfield table, and it is generally field number 2. On a vBulletin page, you could access the current user's profile field using: $vbulletin->userinfo['field2']

[zero477]

Hello I also want to post the urser's location but do not know how ...

[kh99]

If you want to show a user his own location, it would be $bbuserinfo[field2]. If you want to put the post author's location in the postbit or postbit_legacy template, it would be $post[field2] (but it's already displayed in the default postbit so I guess that's not what you're trying to do).