Pruning users with sql

[kh99]

Originally Posted by John Lester

I don't want to do it half assed and leave crumbs behind. I'll just do it in batches through the acp then

I was wondering if doing a JOIN of those tables would delete the rows from those tables as well. But I don't even know if you can have a join in a delete statement.

I didn't think about it leaving anything behind in the userfield and never even thought about the usertextfield Not sure why

I believe so. I'd have to test it to know for sure.

After posting this I was out going about my business and was thinking that I really should have tested that sql before posting it, because a typo could have ended up deleting all your users or something. You should probably do something like test with a SELECT before doing the delete (if you end up doing it that way).

Another thing you could do is write some php to do it (maybe steal the "delete user" code from the admincp), then set it up as a scheduled task (if it hasn't been done already - I didn't do a search of mods).