AI Search
Classic Search
 Search Phrase:
 Search Type:
Advanced search options
 Search in Forums:
 Search in date period:

 Sort Search Results by:

AI Assistant
Notifications
Clear all

[Closed] Removing multiple topics

3 Posts
2 Users
0 Reactions
5,381 Views
Sybar
Posts: 18
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@sybar)
Eminent Member
Joined: 10 years ago
[#229]

Hi,

My forum got spammed and the offender created multiple topics across all sections.

I know that spam prevention is one thing but if something slips through the cracks we need tools to deal with it. On bbpress it was possible to see list of all topics across all categories. I can't find a similar thing in wpForo.

What I need if spam happens is to go to the said list, check all spam topics and do a bulk action of removing them all.

On this occasion I had to go to every single category -> topic and remove spam manually, one-by-one.

Would it be possible to add a function to remove multiple topics in one go?

Or perhaps ban an user and automatically remove all content he created?

Thanks 🙂


2 Replies
Robert
Posts: 10749
Admin
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@robert)
Support Team
Joined: 3 months ago

Sure we're working on this, also we're working on wpForo built-in anti-spam solutions.

Currently you can use Hosting Service cPanel - phpMyAdmin to remove all spam topics and posts. Just find the spammer user ID and execute these two SQLs:

DELETE FROM `wp_wpforo_posts` WHERE `userid` = X;
DELETE FROM `wp_wpforo_topics` WHERE `userid` = X;

Change X to spammer user ID. Also make sure your tables prefix is correct, I use wp_ .

phpMyAdmin SQL query screenshots:

Posts Table:

Topics Table:


Sybar
Posts: 18
Topic starter
Translate
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
(@sybar)
Eminent Member
Joined: 10 years ago

Great, good to hear that you're also looking into spam-prevention.

Also, thank you for the suggested workaround 🙂

Cheers

 

 


Share: