Subscribe Change

[valdeztke]

Can you change the default setting so that all persons that register are automatically set to subscribe to instant replies as opposed to once daily?

[minstrel]

Admin CP | Maintenance | Execute SQL Query

From drop-down box:

All users
Instant email notifcation (or any other choice)

Or, using the manual SQL text box:

Do not subscribe: UPDATE user SET autosubscribe = -1
Subscribe without notification: UPDATE user SET autosubscribe = 0
Instant email: UPDATE user SET autosubscribe = 1
Daily email: UPDATE user SET autosubscribe = 2
Weekly email: UPDATE user SET autosubscribe = 3

[valdeztke]

Received message : You are not authorized to execute SQL queries

[minstrel]

Edit your config.php file.

Find:


// ****** USERS WITH QUERY RUNNING PERMISSIONS ******
// The users specified here will be allowed to run queries from the control panel.
// See the above entries for more information on the format.
// Please note that the ability to run queries is quite powerful. You may wish
// to remove all user IDs from this list for security reasons.
$config['SpecialUsers']['canrunqueries'] = 'xx,xx';
except it won't say "xx,xx" - it will have member ID numbers.

Edit that line with your member ID number so you have permission to run the query.

[Joeychgo]

Exactly. You learn fast Minstrel.. :)