Delete users that are using ICQ

[ViPeRR]

is there a command in sql i can use that dose that?

ViPeRR Reviewed by ViPeRR on 12th Mar 2011. Delete users that are using ICQ is there a command in sql i can use that dose that? Rating: 5

[ViPeRR]

also delete users that have 0 post count.

[JGM]

also delete users that have 0 post count.

AdminCP>Users>Prune / Move Users.



JGM.

[Lock Down]

ok try these 2 queries. If you have a prefix it will have to be added to the front of user.

select * from user where posts = 0 

select * from user where icq != '' 

If that gives you the results you want then you can use these queries to delete them.

delete from user where posts = 0 

delete from user where icq != '' 

Remember to always backup your user table before performing any sql commands.

Also doing it this way the posts and topics for those with an icq being deleted will look funny.

[ViPeRR]

that delted icq not people using icq

[killer123]

Don't you have a prune option inside VB ACP?

[Lock Down]

No that command says delete from user which means any user that has an ICQ address in that field will get deleted. Not the icq field.

Did you run the select first like I said to see what results would happen?

[plonk]

No that command says delete from user which means any user that has an ICQ address in that field will get deleted. Not the icq field.

"delete from user where icq != ''

Shouldn't that be:

delete * from user where icq != ''

[Lock Down]

"delete from user where icq != ''

Shouldn't that be:

delete * from user where icq != ''

Nope.

[killer123]

I meant for the inactive users.