Comments - Printable Version

Comments - Printable Version

+- MyBBHacks.com Plugins for MyBB (https://www.mybbhacks.com)
+-- Forum: ezGallery Pro for MyBB (https://www.mybbhacks.com/forumdisplay.php?fid=8)
+--- Forum: Support (https://www.mybbhacks.com/forumdisplay.php?fid=10)
+--- Thread: Comments (/showthread.php?tid=2718)

Comments - denisg - 02-10-2015

Hello everyone.
After using ezGallery on my forum for sometime now I have just realized that comments were allowed by guests! This means some photo's have hundreds of comments on them from spammers. Can anyone tell me if there is a bulk way to delete the existing comments and to turn it off altogether. I don't fancy doing it one at a time Angry

Denis.

RE: Comments - MyBBHacks - 02-10-2015

Quick way would be delete if from the comments database table

Code:
DELETE FROM mybb_gallery_comment;

RE: Comments - denisg - 02-10-2015

(02-10-2015, 04:39 AM)MyBBHacks Wrote: Quick way would be delete if from the comments database table

Code:
DELETE FROM mybb_gallery_comment;

Thanks for that but could you be a little more explicit please?.

Denis.

RE: Comments - MyBBHacks - 02-10-2015

You would need to run that SQL query on the database using something like phpmyadmin to delete the comment.

RE: Comments - denisg - 02-10-2015

Sorted with your code in MySQL using phpmyadmin as suggested.

Many thanks.

Denis.

RE: Comments - MyBBHacks - 02-10-2015

Glad to help.

RE: Comments - denisg - 02-12-2015

Geez, this is madness. I seem to have 2 choices, turn comments off or delete ezgallery all together. Just a few days after following the above instructions there are already over 1m spam comments. Help!!

Further exploration shows that the above file, mybb_gallery_comment, is empty. Permissions have been adjusted to add comments as admin only. I was sure that all showed 0 comments after deleting all but this morning some photo's are showing as follows:
[Image: Comments.jpg]

The MySQL file still shows as empty. Any ideas?

Denis.

RE: Comments - MyBBHacks - 02-12-2015

One more SQL is needed to be run on the database

Code:
UPDATE mybb_gallery_pic set commenttotal  = 0

RE: Comments - denisg - 02-13-2015

Thank you for that. I guess I really should learn MySQL but I think it's a bit beyond me these days. Your help is much appreciated.

Denis.