View Full Version : Subscribe Change
10-05-2006, 05:51 PM
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?
10-05-2006, 06:10 PM
Admin CP | Maintenance | Execute SQL Query
From drop-down box:
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
10-05-2006, 06:20 PM
Received message : You are not authorized to execute SQL queries
10-05-2006, 06:28 PM
Edit your config.php file.
// ****** 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.
10-05-2006, 06:45 PM
Exactly. You learn fast Minstrel.. :)
Powered by vBulletin® Version 4.2.1 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.