Database update

bytte

Hey guys, I have the whisper notification add-on installed. I'm about to migrate from phpBB to Vanilla. I managed to import all user data in Vanilla. So now I have over 1000 members on a clean Vanilla install. I wondered if it's possible to do a database query that will make these the default settings in each member's account: - Notify me, when comments are posted in my own discussions - Tell me when someone whispers a comment to me

Minisweeper

Try:
UPDATE `LUM_User` SET 1SubscribeOwn1 = '1'
to get everyone notified, as for setting up everyon with whisper notification, I'm not sure. You could try opening up the /whispernotification/default.php file, scrolling down to the bottom, and changing
$PreferencesForm->AddPreference('Notification', 'TellWhenWhisper', 'NotifyOnNewWhisper');
to
$PreferencesForm->AddPreference('Notification', 'TellWhenWhisper', 'NotifyOnNewWhisper',0,1);
but I'm not makin any guarantees

bytte

Thanks Minisweeper. What's the "notified" row doing in that Lum_user table?

Minisweeper

What? I made a mistake also that should have been
UPDATE `LUM_User` SET `SubscribeOwn` = '1'

bytte

Do you mean the notified row should be set to "1" as well? Or are you refering to the type you made? 1SubscribeOwn1 instead of "SubscribeOwn"?

Minisweeper

Yeah I was reffering to the typo. I think you should just leave the notified row as it is.

bytte

Okay, thanks. I already figured out about the typo, so don't worry. I'm thankful for your help.

Minisweeper

Just realised that my second idea for changing that line in the whisper notify file might actually break the extension so I'd suggest you swap it back to the original one if you've changed it.

Stash

Would be sweet to have these kinda options as a simple point and click GUI...