MyAlerts - a notification/alert system for MyBB
I just wanted to ask a couple of questions:
1) How do you enable all the options for existing users? Maybe some SQL Query?
EDIT: I've figured this one out for myself, this is the anwer:
insert into mybb_alert_setting_values (user_id, setting_id, value)
select uid, 1, 1
from mybb_users;

insert into mybb_alert_setting_values (user_id, setting_id, value)
select uid, 2, 1
from mybb_users;

insert into mybb_alert_setting_values (user_id, setting_id, value)
select uid, 3, 1
from mybb_users;

insert into mybb_alert_setting_values (user_id, setting_id, value)
select uid, 4, 1
from mybb_users;

insert into mybb_alert_setting_values (user_id, setting_id, value)
select uid, 5, 1
from mybb_users;
2) Could you add a feature that removes the settings of a user once their account is removed, because the entries remain in the database after a user is deleted.

Thanks in advance!


Messages In This Thread
RE: MyAlerts - a notification/alert system for MyBB - by Qub1 - 2013-03-02, 06:27 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)