Kunena 7.0.4 Released

The Kunena team has announce the arrival of Kunena 7.0.4 [K 7.0.4] in stable which is now available for download as a native Joomla extension for J! 5.4.x/6.0.x. This version addresses most of the issues that were discovered in K 6.2 / K 6.3 / K 6.4 and issues discovered during the last development stages of K 7.0

Topics that are moved into this category are generally considered to be closed. Users may want to add additional information but these topics should not be resurrected in order to discuss new problems or unrelated matters.

Question Bots destroying forum! HELP!

More
16 years 8 months ago #27460 by luvjoomla
I've got 200 messages today from Bots.

1) how do i delete them all?
2) how do i prevent them in the future?

Thanks!

Please Log in or Create an account to join the conversation.

More
16 years 8 months ago #27481 by Matias
1)

This code (use phpMyAdmin or similar) works only for registered users and deletes all messages made by `userid` IN (12345, 23456, 34567) -- that is users 12345, 23456 and 34567 in this case..
Code:
DELETE FROM `jos_fb_messages` WHERE `userid` IN (12345, 23456, 34567); DELETE `jos_fb_messages_text` AS a FROM `jos_fb_messages_text` AS a LEFT JOIN `jos_fb_messages` AS b ON a.mesid=b.id WHERE b.id IS NULL;


2)

If you have enabled anonymous posting, then the only way is to use captcha as you cannot ban someone who hasn't registered.

If bots have registered into your site, you should ban them all (Joomla backend, user administration) and install some kind of captcha system to prevent bots from registering your site.

Please Log in or Create an account to join the conversation.

More
16 years 8 months ago #27543 by luvjoomla
Hi,

They didnt need to register to post on the forum. So I have many spam messages littered throughout the forum. Is there no way in the backend of the system to click and delete messages, or do I have to use the front end to delete each one manually?

Thanks !

Please Log in or Create an account to join the conversation.

More
16 years 8 months ago #27553 by Matias
In frontend you can delete threads from category view. You should enable Spam protection system (CAPTCHA) in Kunena configuration to make posting harder if you're anonymous user.

Maybe the easiest way is to take phpMyAdmin and individually delete messages from there. Then you can run second query to remove message text and recount stats from the backend..

Please Log in or Create an account to join the conversation.

Time to create page: 0.266 seconds