Hi,
I'm being plagued by manual spam from our contact info form. The Bad Words filtering is blocking the majority. I would like to know how to import a bad word list I found to block even more.
Thank you
#36157 Bad words import
Posted in ‘Admin Tools for Joomla! 4 & 5’
This is a public ticket
Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Environment Information
Joomla! version
n/a
PHP version
n/a
Admin Tools version
n/a
Latest post by IThypercube on Monday, 15 November 2021 02:24 CST
Sunday, 14 November 2021 19:39 CST
IThypercube
Monday, 15 November 2021 00:45 CST
nicholas
Akeeba Staff
Manager
You can't import directly from the component but you can import directly into the database. The table you are looking for is aptly named #__admintools_badwords where #__ is the common table name prefix of your site (open configuration.php, check the value of the $prefix option).
The only field you need to import is word. The other field is an auto–generated ID which means that you must not, in fact, include it.
I believe that you can convert your words list with Excel or a similar spreadsheet application to CSV format which is supported by phpMyAdmin, Adminer and similar web–based MySQL management tools for importing data to the database.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!
Monday, 15 November 2021 02:24 CST
IThypercube
Thank you Nicholas, much appreciated. I'll give it a try. Maybe a good candidate for a feature request in the future.