Hi there,
I've recently updated my fanfic site https://www.transformersfanfic.com to the latest version of eFiction but I have a lot of spam comments and authors.
Does anyone know the best way to clean up spam? I was planning to use phpMyAdmin and go on a deletion frenzy, but if anyone has cleaned up their spam in a different way, could you please let me know?Β
Regards,
Charl
It's been 3-4 years since the last time but I used to do it via phpmyadmin before I had to disable new registrations because of spammers and spam reviews. I don't believe a better method has been released since then.
When I took over the my archive a few years ago I also had to delete tons of spam and yeah phpmyadmin was the way I had to do it. For future spam, I added a spam test question to the registration page and itβs helped immensely. I posted the coding changes here: https://efiction.org/community/postid/20736/
It's been 3-4 years since the last time but I used to do it via phpmyadmin before I had to disable new registrations because of spammers and spam reviews. I don't believe a better method has been released since then.
Thanks. Do you have any recommendations on how to do it? Just get phpMyAdmin to list all the authors, reviews, and so on. Then delete anything that's spam?
When I took over the my archive a few years ago I also had to delete tons of spam and yeah phpmyadmin was the way I had to do it. For future spam, I added a spam test question to the registration page and itβs helped immensely. I posted the coding changes here: https://efiction.org/community/postid/20736/
This is great! Thank you!
It's been 3-4 years since the last time but I used to do it via phpmyadmin before I had to disable new registrations because of spammers and spam reviews. I don't believe a better method has been released since then.
Thanks. Do you have any recommendations on how to do it? Just get phpMyAdmin to list all the authors, reviews, and so on. Then delete anything that's spam?
My memory isn't what it used to be due to my chronic illnesses, and I don't remember the specifics of what I did, sorry! Only that I had to putter around quite a lot in phpMyAdmin in at least _reviews, _authors, _authorinfo and _authorprefs tables. I don't seem to have notes about the process saved anywhere π I hope someone else can better help you!
Β