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
· Blue Host
· Interserver.net
Visit us on Facebook
Member Spotlight
drkknght
drkknght
rob's pad -- where it takes skin, to win!
Posts: 1,271
Joined: November 2000
Show All Member Profiles 
Forum Statistics
Forums64
Topics37,499
Posts293,666
Members13,824
Most Online1,498
Mar 17th, 2017
Top Posters(All Time)
AllenAyres 21,084
JoshPet 10,370
LK 7,395
Lord Dexter 6,709
Gizmo 5,786
Greg Hard 4,625
Top Posters(30 Days)
isaac 26
driv 16
Gizmo 5
Morgan 2
Today's Statistics
Currently Online 928
Topics Created 0
Posts Made 0
Users Online 1
Birthdays 16
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2019 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 7.7.3
(Snapshot build 20190709.dev)
PHP: 5.4.45 Page Time: 0.042s Queries: 15 (0.012s) Memory: 3.2608 MB (Peak: 3.4459 MB) Data Comp: Zlib Server Time: 2019-07-16 10:05:08 UTC
Valid HTML 5 and Valid CSS