2014-04-06, 10:32 AM
I'm new in "querying"...
I have a problem i'd like a query that can delete all users that are having BAN reasons: "SPAM" or "Spammer".The problem is that in phpmyadmin db's at banned reasons it's NULL nothing is written there.After 1h i figured that they are moved in another group->"Banned".
And i need 2 querys,maybe 1 in fact:
One that can delete from db and from forum all users that are in Banned group
OR
One that can delete all users with reason "SPAM" or "Spammer".
Please help me
I have a problem i'd like a query that can delete all users that are having BAN reasons: "SPAM" or "Spammer".The problem is that in phpmyadmin db's at banned reasons it's NULL nothing is written there.After 1h i figured that they are moved in another group->"Banned".
And i need 2 querys,maybe 1 in fact:
One that can delete from db and from forum all users that are in Banned group
OR
One that can delete all users with reason "SPAM" or "Spammer".
Please help me