Help with spam and update

Hi... I'm running a 7.0.0 website.

After a year it became full of spam and fake user (5000+) and the database was starting to be slow.

So with php my admin I emptyed "categories", "sys_profile_views_track", and other tables,

and I also deleted blogs and so on, and all profiles that was clearly spammers (it took me 2 hours to do that).

Now I ask you: is there some tool to remove other orphanscontents from users that no longer exists?

How the hell are this spammers activating their own profile by email link? Isn't there a working antispam filter?

Also, is there a SIMPLER way to keep my dolphin updated?

I'll try and answer each of your questions:

1. There isn't a tool to remove orphaned content. That's why it's import to delete the actual member from the Dolphin admin panel. If you do it that way all the content associated with them gets deleted too.

2. The spammers are a pain for everyone. They know how to use Google to get a list of Dolphin sites and then they go nuts posting garbage. There are several tricks that have been listed on the forums. Make sure you have everything set up to moderate. You can also limit what the base membership can access. If your on a VPS or dedicated server you can install mod_security and stop them once and for all by blocking link posting. After I did this I haven't had one spammer sign up.

3. No... as of right now the only way to update Dolphin is manually. Maybe 8 will be different?

1.

Unfortunately the dolphin admin panel handling of profiles is crap, because the limit of members you see in one time is maximum 80, with geeky style.

That is useless because I had 5000 users to delete, so I did that on php my admin.

2.

I would like to update dolphin, but it's too much work for me, I think I will abandon it and I'll not use it anymore.

Actually I have 1 website with dolphin and 45 websites with wordpress, the second is so much better and easyer to keep updated.

Probably I made a mistake, it was better to try to find Wordpress community plugins instead of using dolphin, and I also bought a licence...