[Forum] Force email notifications for imported users?

[orangeade]

I just imported my phpBB database to vBulletin. I want to globally change default settings for ALL users to achieve the following:

1) Instant email notification on private messages

2) Instant email subscription to an old thread they started/replied to in phpBB

3) Intant email subscription to any new threads they start/reply to.

[Riasat]

You can do these from admincp > maintenance > execute sql query >
You might need to give yourself sql query execution permission from config.php

Please make a back up of your database first.

#2 is not possible with default code I think. You will need quite a bit of custom codes/sql queries for that.

[orangeade]

OK thanks - thought it would probably be an sql query.

What queries should I run to do #1 and #3? Sorry but I don't have clue!

[Riasat]

• Yes - Send Notification Email When a Private Message is Received
• Instant email notification

[orangeade]

I changed config.php to add my username so I can sun sql queries.

Still doesn't allow me to. Do I need to refresh something?

[Riasat]

you need to add your userid. not username.

[orangeade]

Thanks very much. Worked nicely!

[Panthro]

sorry for bringing it alive, but I'd like to ask if you figured out a way of doing the #2

2) Instant email subscription to an old thread they started/replied to in phpBB