Welcome to Geeklog, Anonymous Thursday, March 28 2024 @ 02:07 pm EDT

Geeklog Forums

SQL to correctly delete users


Status: offline

ScurvyDawg

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

Status: offline

ScurvyDawg

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

UID 329 to UID 13170

thought some clarity might help.
 Quote

Status: offline

Dirk

Site Admin
Admin
Registered: 01/12/02
Posts: 13073
Location:Stuttgart, Germany
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
 Quote

Status: offline

ScurvyDawg

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

Just what I needed, thank much.

:banana:
 Quote

All times are EDT. The time is now 02:07 pm.

  • Normal Topic
  • Sticky Topic
  • Locked Topic
  • New Post
  • Sticky Topic W/ New Post
  • Locked Topic W/ New Post
  •  View Anonymous Posts
  •  Able to post
  •  Filtered HTML Allowed
  •  Censored Content