Status: offline

ScurvyDawg

Forum User
Full Member
Registered: 06/11/02
Posts: 523
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:

Status: offline

ScurvyDawg

Forum User
Full Member
Registered: 06/11/02
Posts: 523
want to delete

UID 329 to UID 13170

thought some clarity might help.

Status: offline

Dirk

Site Admin
Admin
Registered: 12/01/02
Posts: 13073
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

Status: offline

ScurvyDawg

Forum User
Full Member
Registered: 06/11/02
Posts: 523
I had not noticed the batch admin stuff.

Just what I needed, thank much.

:banana: