Delete users that are using ICQ

[ViPeRR]

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

 

[ViPeRR]

also delete users that have 0 post count.

 

[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?

 

[killer123]

I meant for the inactive users.

 

[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.

"[COLOR=#000000][COLOR=#0000bb]delete from user where icq [/COLOR][COLOR=#007700]!= [/COLOR][COLOR=#dd0000]''[/COLOR][/COLOR]

Shouldn't that be:

[COLOR=#000000][COLOR=#0000bb]delete * from user where icq ![/COLOR][COLOR=#007700]= [/COLOR][COLOR=#dd0000]''[/COLOR][/COLOR]

 

[JGM]

also delete users that have 0 post count.

AdminCP>Users>Prune / Move Users.

[slide]http://minimages.com/images/95325418497313400896.png[/slide]

JGM.

 

[ViPeRR]

oh thanks.

 

[JGM]

No worries

Stoner.

 

[Lock Down]

"[COLOR=#000000][COLOR=#0000bb]delete from user where icq [/COLOR][COLOR=#007700]!= [/COLOR][COLOR=#dd0000]''[/COLOR][/COLOR]

Shouldn't that be:

[COLOR=#000000][COLOR=#0000bb]delete * from user where icq ![/COLOR][COLOR=#007700]= [/COLOR][COLOR=#dd0000]''[/COLOR][/COLOR]

Nope.