How to: Ban Everyone is ICQ UIN

[14kvision]

Hi,

I am in the mists of cleaning up my board from thousands of spam accounts and messages. I think I've managed to clear out all the messages but now I'm left with a ton of spam accounts. I noticed that the majority of these spam accounts have an ICQ UIN in their profile and none of my legitimate users have an ICQ.

SO....

Is it possible to move any account which has an ICQ entry in their profile to the banned users group?

Thanks!

[TheLastSuperman]

You can run a SQL Query:

UPDATE user SET usergroupid = '8'
WHERE icq != '';

However that will change everyone who has anything entered into ICQ into the banned usergroup (defaulted to usergroup id #8) so be careful OR add in a AND as so:

UPDATE user SET usergroupid = '8'
WHERE icq != '' AND usergroupid != '6';

So now it should run through all of the users and place them into the banned group IF they are not in the admin usergroup.

When your done w/ the query you decide to go with don't forget to update your counters in admincp so their usertitles are also updated .

[14kvision]

Is that done somewhere in the cpanel? Or do I do that in PHP my admin?

[TheLastSuperman]

^ phpMyAdmin and check my post above once more I just finished editing .

[14kvision]

Seems to have worked like a charm! Thank you very much!!!

[TheLastSuperman]

Originally Posted by 14kvision

Seems to have worked like a charm! Thank you very much!!!

Your welcome .

[Boofo]

You should be able to run the query in the Run Queries in the Admin CP, shouldn't you?

[TheLastSuperman]

Originally Posted by Boofo

You should be able to run the query in the Run Queries in the Admin CP, shouldn't you?

Should unless your not listed as having permission in the config file to run queries remember .

[djjeffa]

is there anyway to do this with members with 0 post and a icq username?

[djjeffa]

Originally Posted by djjeffa

is there anyway to do this with members with 0 post and a icq username?

bump?