How to clean up the guestbook mess?

I removed guestbook.php from my server.

Now I need to clean up all the spam entries left in my database, and remove the link from the profile sub-nav menu.

Can someone please explaing how I can do these two things?

Thanks,

Bill

You can clean up the mess that was created by the guestbook by logging into your cPanel or control panel. go to phpmyadmin. select the database name where your dolphin suite is installed. the set of tables will drop down on the left side of the page. select the Guestbook table. the table opens in the center of the page. now you can click on the browse button to see all the entries on your guestbook.

over to the right of browse, there is a tab that say SQL, hit that tab. the query area will open  up. there will  be a query statement already listed in there, just delete what is in there and add the following line to your sql statement:

Delete * FROM `Guestbook` WHERE `ID` >0;

you may or may not have to remove the wildcard to remove the records. so if you dont get any results with the statement with the wildcard then just run this sql statement:

Delete FROM `Guestbook` WHERE `ID` >0;

it will of course ask you if you are sure that you wish to remove the records, hit yes, and proceed. you should see a result set immediately after hitting the yes button. it should say something to the effect of how many records were affected.

run your mouse over the browse tab again, if you see a red X then the table is clear of records and there is nothing to browse.

let me know if this works out for you.

Regards,

DosDawg