3.2 & 3.3 Extensions Database 3.2 / 3.3Delete Inactive Users

<span class="qte-attr qte_32_33-qte">3.2.x & 3.3.x</span>
User avatar

Topic Author
dmzx Online
Founder
Founder
Posts: 6466
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Delete Inactive Users

Post by dmzx »

stone23 wrote: 29 Oct 2019, 09:33 Hello,
No idea?
will install and check it.

User avatar

Topic Author
dmzx Online
Founder
Founder
Posts: 6466
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Delete Inactive Users

Post by dmzx »

First post updated

User avatar

Exabot
Users
Users
Posts: 46
Joined: 22 Mar 2020, 12:59
    Mac OS X Firefox

Re: Delete Inactive Users

Post by Exabot »

Estonian translation.
et.zip
You do not have the required permissions to view the files attached to this post! Maybe your post count is too low.

User avatar

Bitkiller
Users
Users
Posts: 3
Joined: 13 Dec 2015, 13:52
    Windows 10 Chrome

Re: Delete Inactive Users

Post by Bitkiller »

In my forum, inactive users (zero posters) are deleted by this extension after 7 days.
As I understand it, the inactivity concerns both the day of registration and the day of the last login.
So it is possible that a 0-poster escapes automatic deletion by logging in permanently.
For me, it makes more sense if the 7 days refer exclusively to the day of registration.
What do I have to change so that this works?
Everyone said, it's impossible to do, until someone came who didn't know that and he made it.

User avatar

Topic Author
dmzx Online
Founder
Founder
Posts: 6466
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Delete Inactive Users

Post by dmzx »

Bitkiller wrote: 17 Jan 2021, 13:21 In my forum, inactive users (zero posters) are deleted by this extension after 7 days.
As I understand it, the inactivity concerns both the day of registration and the day of the last login.
So it is possible that a 0-poster escapes automatic deletion by logging in permanently.
For me, it makes more sense if the 7 days refer exclusively to the day of registration.
What do I have to change so that this works?
This line looks at the user last visit time:

https://github.com/dmzx/Delete-Inactive ... ne.php#L74

So do like below:
open: cron/deleteinactiveusers_prune.php
Find This may be a partial find and not the whole line

Code: Select all

				AND u.user_regdate < ' . $inactive_time . '
				AND u.user_lastvisit < ' . $inactive_time;
Replace with Replace the preceding lines with the following

Code: Select all

				AND u.user_regdate < ' . $inactive_time;

I will take a look in next version to add the option in ACP :wink:

grtz

User avatar

Bitkiller
Users
Users
Posts: 3
Joined: 13 Dec 2015, 13:52
    Windows 10 Chrome

Re: Delete Inactive Users

Post by Bitkiller »

I would like to give a quick feedback.
Thanks for the help, I have made the changes and everything is running perfectly now!
I am already looking forward to the new version.
:thumbup:

User avatar

BPanther
Users
Users
Posts: 4
Joined: 20 Jul 2021, 18:44
    unknown Mozilla

Re: Delete Inactive Users

Post by BPanther »

German translation... ;)
You do not have the required permissions to view the files attached to this post! Maybe your post count is too low.

User avatar

John_Smith
Users
Users
Posts: 6
Joined: 08 Mar 2020, 22:17
    Windows 7 Firefox

Re: Delete Inactive Users

Post by John_Smith »

Is there maybe a way to exclude(!) "Zeroposters", and only delete "sleepers" (aka: those that "never connected"/signed up to the forum even once)?

Or am I looking at a possible better User Account Reminder EXT?

User avatar

Topic Author
dmzx Online
Founder
Founder
Posts: 6466
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Delete Inactive Users

Post by dmzx »

First post updated.

User avatar

clight77
Donator
Donator
Posts: 502
Joined: 24 Sep 2015, 16:23
    Windows 10 Chrome

Re: Delete Inactive Users

Post by clight77 »

dmzx wrote: 17 Jan 2021, 14:58
Bitkiller wrote: 17 Jan 2021, 13:21 In my forum, inactive users (zero posters) are deleted by this extension after 7 days.
As I understand it, the inactivity concerns both the day of registration and the day of the last login.
So it is possible that a 0-poster escapes automatic deletion by logging in permanently.
For me, it makes more sense if the 7 days refer exclusively to the day of registration.
What do I have to change so that this works?
This line looks at the user last visit time:

https://github.com/dmzx/Delete-Inactive ... ne.php#L74

So do like below:
open: cron/deleteinactiveusers_prune.php
Find This may be a partial find and not the whole line

Code: Select all

				AND u.user_regdate < ' . $inactive_time . '
				AND u.user_lastvisit < ' . $inactive_time;
Replace with Replace the preceding lines with the following

Code: Select all

				AND u.user_regdate < ' . $inactive_time;

I will take a look in next version to add the option in ACP :wink:

grtz


Going to try this change as my site never seems to delete ZERO posters after 7 days.

THX :)

User avatar

ditch
Users
Users
Posts: 6
Joined: 22 Apr 2023, 14:37
    Windows 10 Chrome

Re: Delete Inactive Users

Post by ditch »

RU Translation
1.0.4-ru_deleteinactiveusers.rar
You do not have the required permissions to view the files attached to this post! Maybe your post count is too low.

User avatar

wonder_wonder
Donator
Donator
Posts: 15
Joined: 14 Apr 2024, 21:41
    Linux Chrome

Re: Delete Inactive Users

Post by wonder_wonder »

I have seen this extension, and I consider it excellent.
I see that the maximum time to select is 1 year, would it be possible to increase this amount?
I recently converted my previous forum to phpbb, it started in 2005, so there are almost 20 years of records and I need to clean up inactive users.
Besides, I would like to give you the option of more than 1 year.

Thanks in advance!

User avatar

Topic Author
dmzx Online
Founder
Founder
Posts: 6466
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Delete Inactive Users

Post by dmzx »

wonder_wonder wrote: 20 Apr 2024, 22:30 I have seen this extension, and I consider it excellent.
I see that the maximum time to select is 1 year, would it be possible to increase this amount?
I recently converted my previous forum to phpbb, it started in 2005, so there are almost 20 years of records and I need to clean up inactive users.
Besides, I would like to give you the option of more than 1 year.

Thanks in advance!
20 years is a long time :wink:
So how many options in years do you need?

User avatar

wonder_wonder
Donator
Donator
Posts: 15
Joined: 14 Apr 2024, 21:41
    Linux Chrome

Re: Delete Inactive Users

Post by wonder_wonder »

dmzx wrote: 24 Apr 2024, 07:21
wonder_wonder wrote: 20 Apr 2024, 22:30 I have seen this extension, and I consider it excellent.
I see that the maximum time to select is 1 year, would it be possible to increase this amount?
I recently converted my previous forum to phpbb, it started in 2005, so there are almost 20 years of records and I need to clean up inactive users.
Besides, I would like to give you the option of more than 1 year.

Thanks in advance!
20 years is a long time :wink:
So how many options in years do you need?
Yes, 20 years is a lot of years...hehehe :eusa_dance:
This is what has happened, I recently converted my previous forum to phpbb, and my previous forum was born in 2005...
During all these years...130k users of which, I have been able to calculate that about 100k are inactive...
How much I need? Good question, hehehe.
Right now, updating it, once it is updated, in my specific case, I would need less.
I am aware that the maximum time right now is 1 year, I want to give you the option of staying longer. When changing the forum system, I sent an email to all the users, and people who registered in 2014, 2014 or even some from 2008 have connected and returned...
In my case, 1 year would be the minimum (I will not use the months option), once cleaning is done it will always use the years option, the months option for me is very short, the years option would be...1,5,10 15 and/or 20 years? I have doubts about the 20...
I am aware that it is not usual, but those of us who have been around for many years...

As always, thanks for your reply and your extensions, I use many of them and they are great!

Post Reply Previous topicNext topic