The secure CMS.

Welcome to Geeklog, Anonymous Thursday, November 28 2024 @ 04:38 am EST

Geeklog Forums

SQL to correctly delete users

 New Topic  Post Reply
 05/25/08 06:43pm (Read 2,461 times)  
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
 05/25/08 06:50pm  
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
 05/26/08 01:50am  
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
 05/26/08 10:36am  
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
 New Topic  Post Reply
All times are EST. The time is now 04:38 am.
  • 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