The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Help needed to mass reset usertitles
Hello,
I'm a very beginner user in mysql and phpmyadmin. I changed the options of my board . Now the user can no longer use a custom title. Though, all the customtitles (that were before possible) are still there. I saw in phpmyadmin that the titles are in the field "usertitle" and that there is another field named "customtitle" that seems to have a connection with the other one. What is the exact syntax I have to enter in phpmyadmin to reset the usertitles to the default ones ? I believe it's an easy job but I don't want to make any mistake. I know I have to save the whole database before everything. :-) If someone could guide me.... (please speak to me just like I am very stupid) Thanks Michel |
#2
|
||||
|
||||
UPDATE user SET customtitle=0
after that you have to update the userstuff from within your acp (update counter section) be carefull, ALL custom titles are gone after that, also yours |
#3
|
|||
|
|||
Thanks very very much, Xenon, it worked ok :-)))
|
#4
|
||||
|
||||
you're welcome |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|