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

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.

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']

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

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).