IP.Board Tutorials

How To Remove Display Name History

Submitted by Oxygen, , Thread ID: 2042

Thread Closed
Oxygen
<div class="postbit-usertitle">
Prime
Level:
0
Reputation:
35
Posts:
608
Likes:
62
Credits:
1.47K
23-03-2015, 06:47 PM
This post was last modified: 23-03-2015, 06:47 PM by Oxygen
#1
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]

Users browsing this thread: 1 Guest(s)