thank you Deepak, I learn a lot from your participations in xoops.org ,thanks to giving me this chance to help you in something.
try the module , I think you will find it useful

Hi Everyone,

This post is closest to what I need to do, so I'll reply here in hopes of a response.

Question: Can you delete ALL comments on a XOOPS site using the phpMyAdmin module?

Background: My XOOPS sitehttp://www.christianesl.com is overrun with SPAM comments. I disabled comments, so users can't see them. But, I was banned from Google Adsense because of the content of the SPAM.

I need to delete all of the comments. Can you help? Is there a tutorial?

thanks for the help,
newman

Hi Everyone,

because I didn't want to save any comments, I used the 'Flush' command in phpmyadmin.

It was easy. I used the tutorial / help doc here:http://www.siteground.com/tutorials/phpmyadmin/phpmyadmin_database_management.htm

I saw in the comments section of the Admin there are 0(zero) comments.

The site still shows there is a number of comments, but I figure that will change when the cache refreshes.

cheers,
n

hi guys, try this.

In the forum (i'm using newbb), to delete the entries go to PHPMYADMIN, choose your DB and click on the SQL tab. Type this in. Replace [THE USER ID] with the spammer's user id. Do not delete his account yet. Do it last.

Delete xoops_bb_posts_text.*, xoops_bb_posts.*
FROM xoops_bb_posts, xoops_bb_posts_text
WHERE xoops_bb_posts.post_id = xoops_bb_posts_text.post_id
AND xoops_bb_posts.uid =[THE USER ID]

Delete xoops_bb_topics . *
FROM xoops_bb_posts, xoops_bb_topics
WHERE xoops_bb_topics.topic_id = xoops_bb_posts.topic_id
AND xoops_bb_posts.uid =[THE USER ID]

To delete the comments

Delete xoops_xoopscomments.* FROM xoops_users, xoops_xoopscomments WHERE xoops_xoopscomments.com_uid = xoops_users.uid && xoops_users.uid = [THE USER ID]

Finally go and delete the user account.