Global Admin Control

[Kathleen Chute]

I Have to Get My Members Notified. They  haven't clicked The board Button. My Members are asking for me to do it. I need a Selection In My Admin  controls  panel to do this. In Members List ,Select all  by checkbox and Use The Drop Down menu to choose Boards for Notifications.
PLEASE , This is So Fundamental , How can I do It. There is No Other way for Me to get my members Notified without being logged in Under their names  , manually one  by one, There must be a back door .
Kathleen

[kat]

Would it be too much like hard work for your members to go to their profiles>notifications and check "Turn notification on when you post or reply to a topic."?

[Illori]

Admin -> Current Theme -> Member Options -> Change current options for all members using this theme
Admin -> Current Theme -> Member Options -> Configure guest and new user options for this theme

turn notifications on when you post or reply to a topic

other then that you will not get too far with this request, it has been made before and no one did anything with it as the users should have a choice and not forced to get all those emails.

[Kathleen Chute]

Admin -> Current Theme -> Member Options -> Change current options for all members using this theme
Admin -> Current Theme -> Member Options -> Configure guest and new user options for this theme

turn notifications on when you post or reply to a topic

other then that you will not get too far with this request, it has been made before and no one did anything with it as the users should have a choice and not forced to get all those emails.

In This Case ,with My Members , they Want it, But Don't have the time to fool with the site.
My Members are telling me, PLEASE DO IT> I would have to change everyone's passwords , to do it myself. It  would be so time consuming . It This Case  PLEZ  , I would Pay for this, . My Gosh, I have to select it not just for Boards By Sub cats too. This is Not Forcing anyone, Im being re quested to do it. I don't have a standard Forum. People want to participate but have no time to look.
I Cant even select One Board with alll The Sub cats Included.
:(Kathleen

[Illori]

if you want it so bad post a paid request and see where it gets you, posting in coding discussion will not get you a mod or paid help.

[IchBin™]

Don't have time to code anything up, but you could probably just run a query for this in MySQL.

INSERT INTO smf_log_notify values (id_member, id_topic, id_board, sent);

For user 1 to get notified for board id 1:
INSERT INTO smf_log_notify values (1, 0, 1, 0);

[Kathleen Chute]

Don't have time to code anything up, but you could probably just run a query for this in MySQL.

INSERT INTO smf_log_notify values (id_member, id_topic, id_board, sent);

For user 1 to get notified for board id 1:
INSERT INTO smf_log_notify values (1, 0, 1, 0);

I would Be Happy to Pay to get this Done, I have my Boards numbered, My Board number 3 Members Activities is what People Need to be notified Of. I relay should Have Posted This as Paid, Most certainly I am happy to pay to have this Done as a Mod. I want my new members to have this Notification for Board 3 and all Subs defaulted¬. My Gosh, I spoke to a Legal Professional yesterday and she told me I Need to get this Fixed, because my Members are Not Computer savvy and need to come back for the right topic . all My other boards are just Informational and resources to sift through.
This is the Strangest Forum ever Made, I didn't  make it for hanging out, It is a Supportive group for Legal service providers and investigators. All free,

[Kathleen Chute]

In Admin /view Members/ there are Check boxes. If selected I have Only one choice, delete. I would like to select all Members  to receive Notifications for selected boards. And Make it defaulted to Be subscribed to That Board 3 with Sub cats Defaulted
Everyone has a option to opt out of any email
Thanks  for all Your responses  Kathleen

[Kathleen Chute]

Don't have time to code anything up, but you could probably just run a query for this in MySQL.

INSERT INTO smf_log_notify values (id_member, id_topic, id_board, sent);

For user 1 to get notified for board id 1:
INSERT INTO smf_log_notify values (1, 0, 1, 0);

My Board ID is 24, Is There somewhere, some instructions on how to do this Will this include all
sub cats ??
I want to Learn
If I do this , Than I will manually set notifications , by resetting pass words and Logging in Under Peoples accounts , But This is awful.
but I can live with it.

Thanks Kathleen

[IchBin™]

Make a backup of your database before you do anything like this.

For every board (even child-boards) you want them to be notified in, you'd have to do a separate query. I'm no SQL guru, so maybe there's a way to do a query with multiple boards, but I don't know how off the top of my head. If you want to do it in one swoop I'd put all the queries you are going to need into one file. Name it notify.sql. Then in that file put as many lines as you need. For example the queries below would add boards 1,2,3,4,5 to notify user number 1 and 2.

Code Select Expand


INSERT INTO smf_log_notify values (1, 0, 1, 0);
INSERT INTO smf_log_notify values (1, 0, 2, 0);
INSERT INTO smf_log_notify values (1, 0, 3, 0);
INSERT INTO smf_log_notify values (1, 0, 4, 0);
INSERT INTO smf_log_notify values (1, 0, 5, 0);
INSERT INTO smf_log_notify values (2, 0, 1, 0);
INSERT INTO smf_log_notify values (2, 0, 2, 0);
INSERT INTO smf_log_notify values (2, 0, 3, 0);
INSERT INTO smf_log_notify values (2, 0, 4, 0);
INSERT INTO smf_log_notify values (2, 0, 5, 0);

Once you have your notify.sql file ready, you go into phpMyAdmin and import the file into your database by clicking on the database in the left column, then clicking on the import tab across the top. Click the button to browse to the notify.sql file and submit. That should update everyone you put into the queries to be notified I believe.

[Kathleen Chute]

Biting Nails, Ill Have to Look at all of this to see if I can do it.
Thank you so far , SooOo Much
Kathleen

[Kathleen Chute]

Make a backup of your database before you do anything like this.

For every board (even child-boards) you want them to be notified in, you'd have to do a separate query. I'm no SQL guru, so maybe there's a way to do a query with multiple boards, but I don't know how off the top of my head. If you want to do it in one swoop I'd put all the queries you are going to need into one file. Name it notify.sql. Then in that file put as many lines as you need. For example the queries below would add boards 1,2,3,4,5 to notify user number 1 and 2.

Code Select Expand


INSERT INTO smf_log_notify values (1, 0, 1, 0);
INSERT INTO smf_log_notify values (1, 0, 2, 0);
INSERT INTO smf_log_notify values (1, 0, 3, 0);
INSERT INTO smf_log_notify values (1, 0, 4, 0);
INSERT INTO smf_log_notify values (1, 0, 5, 0);
INSERT INTO smf_log_notify values (2, 0, 1, 0);
INSERT INTO smf_log_notify values (2, 0, 2, 0);
INSERT INTO smf_log_notify values (2, 0, 3, 0);
INSERT INTO smf_log_notify values (2, 0, 4, 0);
INSERT INTO smf_log_notify values (2, 0, 5, 0);

Once you have your notify.sql file ready, you go into phpMyAdmin and import the file into your database by clicking on the database in the left column, then clicking on the import tab across the top. Click the button to browse to the notify.sql file and submit. That should update everyone you put into the queries to be notified I believe.

before I mess things Up, What is th (0) for ? So It would Be User id Board id ?? RiGHT
Thanks Kathleen

[IchBin™]

The first zero is if you are marking a topic to notify. Since you aren't doing that, just leaving zero is fine. The second zero is for marking whether the notification has been sent. Inserting all 4 values is necessary. The only ones you need to change are the member_id and the board_id.

The first value is the member_id.
The second value is the topic_id.
The third value is the board_id
The last value is to mark if notification has been sent.

The first and third values are the only ones you need to change. The second and last value need to be zero's.

[Kathleen Chute]

Thank you , Biting Nails, ask Kat, Ive done good before .LOL
Kathleen

[Kathleen Chute]

I did It and Found No effect

[IchBin™]

What do you mean you found no affect?

[Kathleen Chute]

 I Ran it , and it didnt do a Thing , No Help No Hurt
Thanks  Kathleen

[Justin se]

i also tried to take you advice, but it's still doesn't work for me.
it didn't effect the Members List.

[IchBin™]

I Ran it , and it didnt do a Thing , No Help No Hurt
Thanks  Kathleen

Well according to your image you attached it showed that the rows were inserted. That should mean that users should now get notified. What were you expecting to happen?

[Kathleen Chute]

I was expecting notification ( If I Did it right) But Nothing was updated . Nothing Happened. No Notifications . didn't work Thanks  Kathleen