How To Change User Title en masse by Group ID?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Destee
    Senior Member
    • Feb 2001
    • 186

    How To Change User Title en masse by Group ID?

    I want to replace whatever personal titles they have and make everyone go to default titles i select.

    How do i change all of the registered Members at one time?

    How do i change all of the Mods at one time?

    etc.

    Thanks.

    Destee
    destee.com
  • SmartGnome
    Member
    • Mar 2003
    • 89
    • 4.2.x

    #2
    Admincp -- > usergroup manager -- ) edit moderators group

    User Tiltle (any name)

    Can have custom title -- > no

    Save settings


    Hope this is what you ment.

    Comment

    • Destee
      Senior Member
      • Feb 2001
      • 186

      #3
      Thank you SmartGnome. I've done the above, but those Members who had already added personal titles, don't change.

      I think i need a query to run, to change them all from what it is, to what i want it to be (by Group ID).

      Destee
      destee.com

      Comment

      • SmartGnome
        Member
        • Mar 2003
        • 89
        • 4.2.x

        #4
        Admincp -- > update counters

        Update usertitles

        This should work

        Comment

        • SmartGnome
          Member
          • Mar 2003
          • 89
          • 4.2.x

          #5
          If the above is not working use the following query


          UPDATE user SET usertitle=' ' WHERE usergroupid=7;


          Comment

          • Destee
            Senior Member
            • Feb 2001
            • 186

            #6
            Thank you SmartGnome!!!

            The first option didn't work, but the 2nd did!

            Thanks Much.

            Destee
            destee.com

            Comment

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