Announcement

Collapse
No announcement yet.

Set all user profile fields to default?

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

  • Jake Bunce
    replied
    You will need to run a query like this (backup first):

    UPDATE userfield
    SET fieldX = 'default value'
    WHERE fieldX = ''

    Where fieldX is the field identifier of the profile field as shown in your:

    Admin CP -> User Profile Fields -> User Profile Field Manager

    Leave a comment:


  • Freek
    started a topic Set all user profile fields to default?

    Set all user profile fields to default?

    Hey, I have a burning question.

    I have designed a quite extensive system that generates a user signature based on values they enter in their custom profile fields.

    Most of these fields have default values, but these default values only affect new users.

    Is there any way for me to reverse this process so that it updates ALL my users to use these default values? I was thinking that a MySQL query would do the trick, but I have no idea what to enter.

    Any help would be awesome!

    Regards,
    Last edited by Freek; Mon 14 Apr '08, 6:49am.
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Working...
X