Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Sep 2002
Posts: 151
Member
Member
Offline
Joined: Sep 2002
Posts: 151
More winter database cleaning!

According to my 6.4 user stats, I have 1511 users that has never logged in.

How do I delete them? User Magagement only gives the option to delete inactive users.

Sponsored Links
Joined: Apr 2001
Posts: 3,266
Member
Member
Offline
Joined: Apr 2001
Posts: 3,266
DELETE FROM w3t_Users WHERE `U_Laston` = `U_Registered`

Joined: May 2003
Posts: 1,068
Junior Member
Junior Member
Offline
Joined: May 2003
Posts: 1,068
I believe this is what you are looking for, It's for 6.3 but you can probably play around with it and get it to work for 6.4 Beta-[6.3] Delete Inactive Users with a Zero Post Count - By Joshpet

Joined: Sep 2002
Posts: 151
Member
Member
Offline
Joined: Sep 2002
Posts: 151
[]Omegatron said:
DELETE FROM w3t_Users WHERE `U_Laston` = `U_Registered` [/]

Great Omegatron! Just what I needed!

Joined: Aug 2002
Posts: 111
Journeyman
Journeyman
Offline
Joined: Aug 2002
Posts: 111
I've tried to run this command on my board (running 6.4b2), but I get this error message:

Table 'my_forum.w3t_users' doesn't exist row(s) affected by your query.

Is there a particular command I should use for my version of UBBT?

(Do I win the prize for oldest thread resurrected today?!)

Sponsored Links
Joined: May 2001
Posts: 550
Code Monkey
Code Monkey
Offline
Joined: May 2001
Posts: 550
No prize, but you give me the url, and I'm going to log myself in as an admin.

Did you use w3t_Users or w3t_users?

Joined: Oct 2003
Posts: 2,305
Old Hand
Old Hand
Joined: Oct 2003
Posts: 2,305
also did you use w3t_ as your database prefix?

Joined: Aug 2002
Posts: 111
Journeyman
Journeyman
Offline
Joined: Aug 2002
Posts: 111
I used w3t_Users and yes, the board prefix is w3t. I ran the query again, as I may have used a lower-case "users" the first time. The report I got was "1 row(s) affected by your query", and at first it didn't seem as if any users were deleted, but after I'd reloaded the main message board page I can see that about 1000 users were removed. So, thanks for your help


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
Ruben Rocha
Ruben Rocha
Lutz,FL,USA
Posts: 253
Joined: January 2000
Forum Statistics
Forums63
Topics37,570
Posts293,915
Members13,848
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,829
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 81
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2022 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20221129)