From yesterday till today a user is now from registered to unregistered. Is there a way to prune his old posts to a new member?
In the posts he made still there is his name but under his name it say's unregistered.
below SQL queries might help
assuming that
database prefix is
mybb,
user is newly registered as
newNAME,
earlier user name is
oldNAME &
new user ID is
userID
UPDATE mybb_posts SET uid = 'userID', username = 'newNAME' WHERE username = 'oldNAME' AND uid = '0';
UPDATE mybb_threads SET uid= 'userID', username = 'newNAME' WHERE username = 'oldNAME' AND uid = '0';
UPDATE mybb_threads SET lastposteruid = 'userID', lastposter = 'newNAME' WHERE lastposter = 'oldNAME' AND lastposteruid = '0';
see
Common SQL queries guidance if required. And run
Recount & Rebuild tools after executing the SQL Queries
admin panel >>
tools & maintenance >>
Recount & Rebuild >> run the
first three tools and the
last tool
Many thanks .m. that works like a charme.