request is sql to empty fields Profile

[faris_0555]

Hello
I need the Implementation is the sql Discharge fields Profile to all Members!
Is it possible to get this code!

Wait

[kh99]

Are you saying you want to erase all users profile fields?

[faris_0555]

Yes, I want to do a dump of all the fields!

[kh99]

OK, so you want to reset the values, not remove the fields themselves (you'd do that through the profile field manager in the admincp). Anyway, it would be something like:

UPDATE userfield SET field1='', field2='', ... fieldN=''

where you'd list the fields you want to erase, of course. Use with caution! If there's any doubt, you should make a backup of your database first.

[faris_0555]

How do I do it!

UPDATE userfield SET field1='', field2='', ... fieldN=''

I enter the command full or what?

I have 9 fields!
Please, clarification

[kh99]

Here's what you'd do for 2 fields (including the original fields that come with vbulletin):

UPDATE userfield SET field1='', field2=''

and for 3 fields it would be this:

UPDATE userfield SET field1='', field2='', field3=''

so you should be able to extend it to 9 fields and/or include whichever fields you want.

[faris_0555]

Thank you!
Was successful ..
I want to need
discharge Profile Photos

[ahmed-samara]

Originally Posted by faris_0555

Thank you!
Was successful ..
I want to need
discharge Profile Photos

discharge Profile avatar

TRUNCATE avatar;

If you mean photos Another does not advise you of this!