Spam Review Messages - 5000+ how to delete?

4 Apr 2012, 3:54 AM

#1

creamcrackers

Zen Follower

Join Date:: May 2009
Posts:: 228
Plugin Contributions:: 1

Spam Review Messages - 5000+ how to delete?

Hi
I just noticed ive got 5000 unapproved reviews messages.

I want to mass delete these

Also i want to remove reviews completely from zen cart

How can i do this thanks

4 Apr 2012, 4:14 AM

#2

nigelt74

Totally Zenned

Join Date:: Sep 2005
Location:: Waikato, New Zealand
Posts:: 1,558
Plugin Contributions:: 1

Re: Spam Review Messages - 5000+ how to delete?

To turn it off read this thread there are 3 things you need to do

http://www.zen-cart.com/forum/showthread.php?t=119837

Make sure you remove the link from the sitemap

To mass delete them, you may be able to truncate the tables in the database:
there are 2 tables effected

reviews
reviews description,

if there are no reviews you want to keep, truncate (ie: click "Empty" on) both tables via phpadmin

Webzings Design
Semi retired from Web Design

4 Apr 2012, 5:21 AM

#3

creamcrackers

Zen Follower

Join Date:: May 2009
Posts:: 228
Plugin Contributions:: 1

Re: Spam Review Messages - 5000+ how to delete?

OK
Thanks.. ive done all of that.

Im still worried it might be possible for these spam bots to write more reviews even though i took the review links out they may still be able to call the write a review link?

4 Apr 2012, 5:35 AM

#4

drbyte

Sensei

Join Date:: Jan 2004
Posts:: 63,515
Plugin Contributions:: 176

Re: Spam Review Messages - 5000+ how to delete?

Just like any other page, if you want to prevent everyone from accessing a page you're not using, then simply delete or rename the corresponding (ie: /includes/modules/pages/product_reviews_write/ ) folder and then any visitor or search engine who tries to visit the page (ie: index.php?main_page=product_reviews_write ) will get a nice ugly 404 NOT FOUND response (or whatever you've configured your site to deliver).

.
Zen Cart - putting the dream of business ownership within reach of anyone!
Donate to: DrByte directly or to the Zen Cart team as a whole

Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

4 Apr 2012, 6:19 AM

#5

creamcrackers

Zen Follower

Join Date:: May 2009
Posts:: 228
Plugin Contributions:: 1

Re: Spam Review Messages - 5000+ how to delete?

Cheers
If i get any more ill rename that page

Thank you

24 Apr 2012, 3:55 PM

#6

creamcrackers

Zen Follower

Join Date:: May 2009
Posts:: 228
Plugin Contributions:: 1

Re: Spam Review Messages - 5000+ how to delete?

Just to confirm i deleted everything in reviews and reviews descpription. Im not sure what "truncate them" means... assume that means delete which is what i have done and seems to have worked.