I'm looking to get guidance and solicit a contractor.

Here's the situation:
My friend and I hired a developer to build a site to help christian missionary ESL teachers some years ago. The developer built the site in XOOPS 2.0.14 and it hasn't been maintained in a few years.

Here's the problem:
The site is overrun with SPAM user registerations and the database is BLOATED with users and old comments and forum posts. I've tried to hide and turn off features.

My buddy and I are no longer active in the community of ESL teacher, but we still believe in the mission of the site. So we want to update it and keep it online, without all the spam and security holes.

http://www.christianesl.com

Here is an eLance job project with more detailshttps://www.elance.com/job/27194339/proposals

Here's how you can help:
What is your suggestion to 'clean' or update a XOOPS site?
What 'routine maintenance' do you do to your sites?
Can you recommend a developer to do the work?

Please contact me here or thru the site.

Thanks for your guidance and help,
Newman

PS:I apologize if this is the wrong place to post.

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 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