UBB.Developers Forums UBB.threads 7 Development How Do I? Setting some default options

Hi,

I want to set the following options for all of my users via MySQL Command. Can someone please tell me what to do?

Show what forum/post this user is looking at in who's online
Yes

Accept Private Messages
Yes

Email notifications for private messages?
Yes

Email all replies to posts made?
Yes

Receive admin emails when the mass mailer is used:
Yes

Receive emails in HTML format or plain text
Plain Text

Thanks in advance...

[6.2.2]

UPDATE w3t_Users
SET U_Visible='yes', U_OnlineFormat='yes', U_AcceptPriv='yes', U_Notify='On', U_EReplies='On', U_AdminEmails='On', U_EmailFormat='plaintext'

I recommend backing up your database first.

P.S. I wish Rick would make these columns char(1) NOT NULL, and use the values 0 and 1 for these flags. Some of the names could be better too.

Who's Rich?

I wish I were Rich.

Richie Rich? No way man! You are Mr. Bug LOL!!