No announcement yet.

Set all user profile fields to default?

  • Filter
  • Time
  • Show
Clear All
new posts

  • 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!

    Last edited by Freek; Mon 14 Apr '08, 6:49am.

  • #2
    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


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