XF 1.2 Set Forum Watch Notification Limit For All Nodes?

[Divvens]

I used to use my webhosts e-mail service, and due to that I limited all forum watch notifications to "New Threads", but now I've shifted to Mandrill and I want to set all nodes Forum Watch Notification Limit to "New Messages"

I have too many nodes to do it manually for each node, is there a quick way of doing it?

 

[Rob]

Phpmyadmin will help.

 

[Paul B]

UPDATE xf_forum SET allowed_watch_notifications = 'all'

Take a backup first.

 

[imthebest]

Got it, forget this please.

 

[viper357]

UPDATE xf_forum SET allowed_watch_notifications = 'all'

Could I modify that to change all my current nodes to have 'New Threads' option selected?

 

[Paul B]

No, because it requires an entry per member/node in the xf_forum_watch table.

 

[kushal]

No, because it requires an entry per member/node in the xf_forum_watch table.

I need help sir . I am facing problem . I need on all threads notification 1 time . I want that all users got notification for all new+old post post (if they don't visit anyday also) . They even don't know how to on watch notification in thread section .