inkserious wrote:I would like to go back and change the default settings from 0 to 2 for all old users. I know the instructions said to run a query:
UPDATE phpbb_users
SET user_boardwatchb = 2
WHERE 1 = 1;
I'm unfamiliar with databases, so I don't know how to go about running the query, or where to find the file. I have phpMyAdmin installed on my local machine.
I'm not sure what you are asking (and there is no file to find because you are working with databases, not files). If you have phpmyadmin access to your database, then:
- run phpmyadmin
- select your database
- click the SQL tab
- type or paste that query into the SQL query window
- click the "go" button that appears to the left of the SQL query window
That should do it, but make sure to run a query for boardwatchf and boardwatcht as well, to set those to whatever setting you want for existing users.
I gather you continue to want the default for brand new users to be for boardwatch to be on, correct?
Finally, decide what permissions you want to grant to users or groups to change their own individual boardwatch settings.