Posted on: 05/25/08 06:43pm
By: ScurvyDawg
I just updated a really old install of GL.
I ended up with gobs and gobs of spammy users in my DB.
To remove these manually will be a trying task.
What is the correct SQL to safely remove these users and all their settings.
Thanks so much
:chestslam:
Re: SQL to correctly delete users
Posted on: 05/25/08 06:50pm
By: ScurvyDawg
want to delete
UID 329 to UID 13170
thought some clarity might help.
Re: SQL to correctly delete users
Posted on: 05/26/08 01:50am
By: Dirk
Since this involves several tables, there is no single SQL statement for that.
Did you see the "Batch Admin" option in the admin's Users panel? You can mass-delete users from there.
bye, Dirk
Re: SQL to correctly delete users
Posted on: 05/26/08 10:36am
By: ScurvyDawg
I had not noticed the batch admin stuff.
Just what I needed, thank much.
:banana: