MyBBHacks.com Plugins for  MyBB

Thread Rating:
  • 1 Vote(s) - 5 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Comments
#1
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.
Reply
#2
Quick way would be delete if from the comments database table
Code:
DELETE FROM mybb_gallery_comment;
Like what I do? Support me at https://www.patreon.com/vbgamer45/
Reply
#3
(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.
Reply
#4
You would need to run that SQL query on the database using something like phpmyadmin to delete the comment.
Like what I do? Support me at https://www.patreon.com/vbgamer45/
Reply
#5
Sorted with your code in MySQL using phpmyadmin as suggested.

Many thanks.

Denis.
Reply
#6
Glad to help.
Like what I do? Support me at https://www.patreon.com/vbgamer45/
Reply
#7
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.
Reply
#8
One more SQL is needed to be run on the database
Code:
UPDATE mybb_gallery_pic set commenttotal  = 0
Like what I do? Support me at https://www.patreon.com/vbgamer45/
Reply
#9
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)