Previous Thread
Next Thread
Print Thread
Rate Thread
Delete users that´s never loggeg in #265937 01/02/2004 12:33 PM
Joined: Sep 2002
Posts: 151
Gregori Offline OP
Member
OP Offline
Member
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
Re: Delete users that´s never loggeg in [Re: tubedogg_dup1] #265938 01/02/2004 12:42 PM
Joined: Apr 2001
Posts: 3,266
omegatron Offline
Member
Offline
Member
Joined: Apr 2001
Posts: 3,266
DELETE FROM w3t_Users WHERE `U_Laston` = `U_Registered`

Re: Delete users that´s never loggeg in [Re: tubedogg_dup1] #265939 01/02/2004 12:42 PM
Joined: May 2003
Posts: 1,068
ericgtr Offline
Junior Member
Offline
Junior Member
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

Re: Delete users that´s never loggeg in [Re: sf49rminer] #265940 01/02/2004 1:07 PM
Joined: Sep 2002
Posts: 151
Gregori Offline OP
Member
OP Offline
Member
Joined: Sep 2002
Posts: 151
[]Omegatron said:
DELETE FROM w3t_Users WHERE `U_Laston` = `U_Registered` [/]

Great Omegatron! Just what I needed!

Re: Delete users that´s never loggeg in [Re: tubedogg_dup1] #265941 06/26/2005 5:19 PM
Joined: Aug 2002
Posts: 111
Mudpuppy Offline
Journeyman
Offline
Journeyman
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
Re: Delete users that´s never loggeg in [Re: jbiz] #265942 06/26/2005 5:27 PM
Joined: May 2001
Posts: 550
Anno Offline
Code Monkey
Offline
Code Monkey
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?

Re: Delete users that´s never loggeg in [Re: domain123] #265943 06/26/2005 6:12 PM
Joined: Oct 2003
Posts: 2,305
scroungr Offline
Old Hand
Offline
Old Hand
Joined: Oct 2003
Posts: 2,305
also did you use w3t_ as your database prefix?

Re: Delete users that´s never loggeg in [Re: 234234] #265944 06/26/2005 8:09 PM
Joined: Aug 2002
Posts: 111
Mudpuppy Offline
Journeyman
Offline
Journeyman
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


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
jgeoff
jgeoff
NJ
Posts: 96
Joined: April 2001
Forum Statistics
Forums63
Topics37,490
Posts293,665
Members13,828
Most Online5,166
Sep 15th, 2019
Top Posters(All Time)
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,786
Greg Hard 4,625
Top Posters(30 Days)
isaac 12
Gizmo 1
Today's Statistics
Currently Online 960
Topics Created 0
Posts Made 1
Users Online 1
Birthdays 15
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2019 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Snapshot build 20191013.dev)
Responsive Width:

PHP: 5.4.45 Page Time: 0.041s Queries: 15 (0.016s) Memory: 3.2495 MB (Peak: 3.4384 MB) Data Comp: Zlib Server Time: 2019-10-17 20:09:49 UTC
Valid HTML 5 and Valid CSS