How To Remove Display Name History

by Oxygen - 23-03-2015, 06:47 PM
<div class="postbit-usertitle">
Posts:
646
Joined:
Feb 2015
Likes:
44
Credits:
1,142
Reputation:
33
2 Years of Service
#1
OP
Posted: 23-03-2015, 06:47 PM (This post was last modified: 23-03-2015, 06:47 PM by Oxygen.)
Hi guys,
 
Just a quick tutorial on how to delete display name history on IP.Board 3.4.x.
 
Step 1: Navigate to: ACP  >  SQL Management  >  SQL Tools
 
Step 2: Scroll to the bottom of the page
 
Step 3: Enter the following coding into the text box:
Code:
DELETE FROM dnames_change WHERE dname_member_id = x
x = Member ID - You may find this in the URL of a users profile. 
Eg: If the username was 'Plum' and it was the 4th account to sign up to my website then the following would be it's profile ID: http://www.<WEBSITE>.com/user/4-Plum/
 
 
To delete all display name history from every user type in:
 
Code:
TRUNCATE dnames_change
Step 4: Hit 'Run Query'
 
Step 5: If done correctly it should say "Query executed successfully"
 
 
Thanks,

I do not take any credit for the coding provided in this tutorial.
[Image: UeTXrZ5.png]
The last reply on this thread is older than a month. Please do not unnecessarily bump it.
Register an account or login to reply
Create an account
Create a free account today and start posting right away. It only takes a few seconds.
Login
Log into an existing account.
1 Guest(s)