Settings and Options - SQL

[tdeutsch74]

Hi, I'm in the process of syncing our website user info with our vbulletin user info via sql updates and I'm having trouble locating the Settings and Options area in the database. This includes different user permissions and browsing options which are in the admin area. I found some references in the Phrase table but nothing associating them with a User.

Would anyone here know where I can find this info in the database?

Thanks.

[Marco van Herwaarden]

Can you be a bit more specific?

PS If adding users to the database manually, you should at least try to use the DataManagers as they will take care of a lot of householding tasks for you.

[tdeutsch74]

Sure...options like this. I've found a couple in the user, userfield, and usertextfied tables. If you think the Datamanager is helpful, can you point me to some documentation? Right now SQL seems like the easiest options for us being that our main website is a .net windows setup.

Options:
a. Invisible Mode
b. Show Reputation Level
c. All vCard Download

d. Receive Email:

e. Default THread Subscription Mode


f. Private Messaging:

g. Vistor Messaging:

h. Visible Post Elements

i. Thread Display Mode

j. Number of Posts to Show Per Page


k. Default Thread Age Cut Off

l. Date & Time Options

m. Misc Options


Thanks.

--------------- Added [DATE]1249063719[/DATE] at [TIME]1249063719[/TIME] ---------------

Ok, so basically I'm looking for a way to directly update $userdm->user[optionname] via SQL.
Thanks.