unhide content

[n.karshev]

Hello,

I managed to hide all content from a certain user. Now user changed his mind and wants to return to our community and wants to unhide his content. I cannot see UNhide all content options.

Is there a way to do that.

 

Thnaks in advance

[Marc Stridgen]

There isn't a way to simply unhide all unfortunately. You can however select large numbers of items from the hidden content section in your moderator CP, which may make it somewhat faster to achieve. 

[n.karshev]

Thanks, but user have like 8k posts 😞

 

[Miss_B]

3 hours ago, n.karshev said:

Thanks, but user have like 8k posts 😞

 

I think that you can unhide them with a couple sql queries. Should you be interested in this method, I can post the revelant queries.

[n.karshev]

That will be great, thanks!

[Miss_B]

On 8/6/2020 at 10:59 AM, n.karshev said:

That will be great, thanks!

First of all, make a backup of your forums_posts table, then run the following sql query at the SQL box of your phpmyadmin for the database that you have used to install your forum.

UPDATE forums_posts SET queued = 0 WHERE author_id = x;

Replace x with the actual id of the member whose posts you want to make visible/unhide again. 

I hope it helps.  Please let me know if you will have any additional questions. 

[n.karshev]

Thank you, worked like a charm! 🙂

[Miss_B]

2 hours ago, n.karshev said:

Thank you, worked like a charm! 🙂

You are welcome. I am glad to have been of help :)

[bfarber]

That query won't cover the search index fyi