Search and Replace/Delete

[silencio2222]

Hoping someone can assist. I just converted a forum from Snitz to VB4 and in the process found a ton of spam on the old site and it's in most every post and its a lot of content between these tags

<SPAN STYLE="display:none">
spam content
</SPAN>

<!--
spam content
-->

I have tried searching for it in the admincp and it doesn't show up in any searches that I have done...maybe not using the correct link to do this. I have also tried to locate this in the mysql but not very adapt at using phpmyadmin....

Any Suggestions on how to get rid of this spam? Appreciate any suggestions.... Thanks

Charlie

[borbole]

You can delete all the posts made by the spammers with the following query:

DELETE FROM post WHERE userid = 'spammeruid';

And replace the spammeruid with the actual userid number of the spammer.

If the spmammer has been deleted and all their posts appear as guests, try this query instead:

DELETE FROM post WHERE username='spammerusername' ;

And replace the spammerusername with the ex username of the spammer.

Hope it helps.

[silencio2222]

borbole,

Thanks...not sure that will work in this case. The spam was added to posts already existing as opposed to just them posting spam....using their own username.

Sometimes the spam was added to only the first post in a thread and sometimes every post in the thread.

here is an example on the forum if this helps...

Thanks for the reply!

Charlie

[borbole]

Originally Posted by silencio2222

borbole,

Thanks...not sure that will work in this case. The spam was added to posts already existing as opposed to just them posting spam....using their own username.

Sometimes the spam was added to only the first post in a thread and sometimes every post in the thread.

here is an example on the forum if this helps...

Thanks for the reply!

Charlie

That whole post is spam.

[silencio2222]

borbole,

well....no it's not...on the fifth line down on the right side the spam was added starting with <span style='display: none'>

So just like all of the other posts the spam was added to be invisible within the posts under someone else's username.

Thanks again for looking..