Author Topic: (re)update image_comments-value in 4images_images-table?  (Read 2568 times)

0 Members and 1 Guest are viewing this topic.

Offline 3dc

  • Pre-Newbie
  • Posts: 1
    • View Profile
(re)update image_comments-value in 4images_images-table?
« on: December 18, 2006, 07:57:35 PM »
Hello,
i had my page running for a long time with an old version of 4images and got many many comment-spam.
So i did a reinstall from scratch because of the captcha-system, but took the tables with the images, categories and so on from the old system.
All works, no problem so far. :)
I added the -by hand- spamcleaned comments-table -this also worked.
But now the value of the comments in the images-table isnt correct.

So this is the question:
Is there a way to update 4images_images.image_comments to the real value?

Many thanks if someone could please help with an small sql-query or some kind of a script to do this,
3dc

PS: I did it by hand because it's thousand times faster to watch and delete more than 3000 spam-comments in a text-editor than doing this by the admin-panel, this would be horror :)