Announcement

Collapse
No announcement yet.

Changing users browsing options together

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Changing users browsing options together

    Hi,

    Quick question - just imported users from my old Invision Power Board, however they all have options like 'Can View Images?', 'Can View Avatars?', 'Can Receive PMs?' etc. set to no - and obviously I'd like to set these to yes, but without having to go through everyone's profiles individually, which would be impossible and time consuming!

    Can someone help me out with a quick mass edit way of doing this - I know the answer must be staring at me in the face but I just can't see it!


    Thanks!!


    - Joe

  • #2
    To reset these and other options for existing users:

    Admin CP -> Import & Maintenance -> Execute SQL Query -> Automatic Query

    Then choose the appropriate query from the drop-down box and click on 'Continue'.

    To run queries you first need to give yourself permission to run queries in the Admin CP. To do this, edit this section of config.php:

    // ****** 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.
    $canrunqueries = 'x';


    ...with x being your userid number (not username).
    Steve Machol, former vBulletin Customer Support Manager (and NOT retired!)
    Change CKEditor Colors to Match Style (for 4.1.4 and above)

    Steve Machol Photography


    Mankind is the only creature smart enough to know its own history, and dumb enough to ignore it.


    Comment

    widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
    Working...
    X