Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Database update

edited February 2007 in Vanilla 1.0 Help
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


  • Options
    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');
    $PreferencesForm->AddPreference('Notification', 'TellWhenWhisper', 'NotifyOnNewWhisper',0,1);
    but I'm not makin any guarantees :D
  • Options
    Thanks Minisweeper. What's the "notified" row doing in that Lum_user table?
  • Options
    What? I made a mistake also that should have been
    UPDATE `LUM_User` SET `SubscribeOwn` = '1'
  • Options
    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"?
  • Options
    Yeah I was reffering to the typo. I think you should just leave the notified row as it is.
  • Options
    Okay, thanks. I already figured out about the typo, so don't worry. I'm thankful for your help.
  • Options
    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.
  • Options
    Would be sweet to have these kinda options as a simple point and click GUI...
This discussion has been closed.