The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
request is sql to empty fields Profile
Hello
I need the Implementation is the sql Discharge fields Profile to all Members! Is it possible to get this code! Wait |
#2
|
|||
|
|||
Are you saying you want to erase all users profile fields?
|
#3
|
|||
|
|||
Yes, I want to do a dump of all the fields!
|
#4
|
|||
|
|||
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:
Code:
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. |
#5
|
|||
|
|||
How do I do it!
Code:
UPDATE userfield SET field1='', field2='', ... fieldN='' I have 9 fields! Please, clarification |
#6
|
|||
|
|||
Here's what you'd do for 2 fields (including the original fields that come with vbulletin):
Code:
UPDATE userfield SET field1='', field2='' and for 3 fields it would be this: Code:
UPDATE userfield SET field1='', field2='', field3='' so you should be able to extend it to 9 fields and/or include whichever fields you want. |
#7
|
|||
|
|||
Thank you!
Was successful .. I want to need discharge Profile Photos |
#8
|
|||
|
|||
Quote:
Code:
TRUNCATE avatar; |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|