[CDB] PhpBB IUM (Inactive User Manager/reminder)

A place for Extension Authors to post and receive feedback on Extensions still in development. No Extensions within this forum should be used within a live environment!
Anti-Spam Guide
Forum rules
READ: phpBB.com Board-Wide Rules and Regulations

IMPORTANT: Extensions Development rules

IMPORTANT FOR NEEDED EVENTS!!!
If you need an event for your extension please read this for the steps to follow to request the event(s)
Locked
andreask
Registered User
Posts: 752
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

[CDB] PhpBB IUM (Inactive User Manager/reminder)

Post by andreask »

Extension Name: Inactive User Manager (reminder)
Author: Andreas

Extension Description:
Sends e-mails reminder to users that are inactive for a certain amount of time (set by admin).

Extension Version: Image Image Image

Requirements: Image Image

Features: EXT sends e-mail reminders to users that are inactive for a certain amount of time. If user will not wake up after the 3d reminder user will be enabled for (auto) purging. After 3 reminders the ext stops sending reminders to user and admin will be able to delete that user.
Also user can self delete his account (with or without the approval of the administrator)
  • List of inactive users and their reminders status
  • Automatically send reminders to inactive users
  • Two different templates depending on user's status
  • Define by admin interval of days to consider a user as "sleeper"
  • Define by admin how many reminders (mails) per day to send
  • Option to include user's/forums top active topics in mail
  • Exclude/Include forums for the e-mail reminder.
  • Option to self delete for a user. (with or without admins approval)
  • Ignore users. List of users that the ext should not send reminders
  • Admin is able to send reminders to individual inactive users
Screenshots:

Image
Image
Image

Demo URL: Not available.
Demo Username: Not available.
Demo Password: Not available.
Extension Download: https://github.com/andreaskou/PHPBB_IUM ... 1.8-RC.zip
How to install:
  • In your phpbb/ext create directory andreask and there create directory ium
  • Download zip file and extract content of PHPBB_IUM-maste to phpbb/ext/andreask/ium/
  • Go to ACP- >Customise->Extensions and enable the Inactive User Manager extension.
EXT will send e-mail to users that fit the criteria.
This template is for inactive users

Code: Select all

Subject: Was there a problem?

Hello, {USERNAME}

We see that you have registered at : {REG_DATE}
But since then there have been no activity.

In case you have lost your credentials you can retrieve them from the following link.

{FORGOT_PASS}

If you never received the activation e-mail then please click on the following link to send a new activation mail.

{SEND_ACT_AG}

Else, you can always contact the administrator of the forum {ADMIN_MAIL}.

We hope that we will see you again soon.

{EMAIL_SIG}
This template is for sleepers

Code: Select all

Subject: We've missed you!

Hello, {USERNAME}

We see that your last visit on our forum {SITENAME}, was on "{LAST_VISIT}".
It's been a while, and we would like you to know that we hope to see you again soon!

In case you have forgot your credentials you can always retrieve them using the following link.

{FORGOT_PASS}

Else, you can always contact the administrator of the forum on this e-mail "{ADMIN_MAIL}".
Hope to see you back again.

{USR_TPC_LIST}

{USR_FRM_LIST}


{EMAIL_SIG}
Please let me know your ideas/thoughts.
If anyone is willing to help (morally or by any other mean he/she is welcome and I thank him/her for that.)

Please note that this has nothing to do with this.
https://www.phpbb.com/customise/db/mod/user_reminder/

github: https://github.com/andreaskou/PHPBB_IUM
Last edited by andreask on Tue Oct 13, 2020 12:18 pm, edited 36 times in total.
Here is what I am working on right now...
Inactive User Manager for phpBB
Give it a try...
If you would like to buy me a bier ;) for my work I will drink it on a hot summer day and thank you!!!
User avatar
RomaamoR
Registered User
Posts: 256
Joined: Tue Feb 24, 2015 4:45 pm
Location: Ukraine
Name: Roman
Contact:

Re: [DEV] PhpBB IUM (Inavtive User Manager)

Post by RomaamoR »

Code: Select all

string(479) "SELECT p.username, p.user_regdate, p.user_posts, p.user_lastvisit, p.user_inactive_time, p.user_inactive_reason, r.remind_counter, r.previous_sent_date, r.reminder_sent_date, r.dont_send FROM phpbbga_users p LEFT OUTER JOIN phpbbga_ium_reminder r ON (p.user_id = r.user_id) WHERE p.user_id not in (SELECT ban_userid FROM phpbbga_banlist) AND p.group_id not in (1,4,5,6) AND from_unixtime(p.user_lastvisit) < (DATE_SUB(CURDATE(), INTERVAL 30 DAY))"
andreask
Registered User
Posts: 752
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

Re: [DEV] PhpBB IUM (Inavtive User Manager)

Post by andreask »

my bad I forgot to comment my var_dumps...

This ext is still under development
It is still has a lot of work!
Here is what I am working on right now...
Inactive User Manager for phpBB
Give it a try...
If you would like to buy me a bier ;) for my work I will drink it on a hot summer day and thank you!!!
DueLearner
Registered User
Posts: 15
Joined: Tue Jun 07, 2016 12:52 pm

Re: [DEV] PhpBB IUM (Inavtive User Manager)

Post by DueLearner »

This is a great idea and I'd love to use this. Keeping an eye on this ext.
User avatar
spaceace
Registered User
Posts: 1999
Joined: Wed Jan 30, 2008 8:50 pm
Contact:

Re: [DEV] PhpBB IUM (Inactive User Manager)

Post by spaceace »

i know so many people that used the MOD like this and am looking forward to it myself :D

edit:
there is a small correction that needs to be made to language/en/email/template.txt

Code: Select all

Else, you can contact we the administrator of the forum {ADMIN_MAIL}.
shound be

Code: Select all

Else, you can contact the administrator of the forum {ADMIN_MAIL}.
just remove the we
BF79
Registered User
Posts: 499
Joined: Fri Feb 13, 2015 1:28 pm
Name: Fouad B

Re: [DEV] PhpBB IUM (Inactive User Manager)

Post by BF79 »

thanks !!! good luck.. +1
hope to see beta version very soon :)
andreask
Registered User
Posts: 752
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

Re: [DEV] PhpBB IUM (Inactive User Manager)

Post by andreask »

Hello,

whoever wants to test this on his local test environment he is welcome.
I call the latests version 0.5.0 as a pre-beta release.

If someone wants to test the extension I would strongly suggest to use a fake SMTP server such as https://mailtrap.io
To configure mailtrap on phpbb board is rather easy.
Once you register to mailtrap.io (free)

In phpbb board.
ACP->General->client communication->email settings

This is the configuration that worked for me.

enable SMTP settings
SMTP server address: mailtrap.io
SMTP server port: for me worked 2525 but if this will not work for you there are also other ports you can use 25/465
Authentication method for SMTP: CRAM-MD5
username/password as assigned by mailtrap.io

I would like to have some feedback and thoughts.

Thanks!
Here is what I am working on right now...
Inactive User Manager for phpBB
Give it a try...
If you would like to buy me a bier ;) for my work I will drink it on a hot summer day and thank you!!!
andreask
Registered User
Posts: 752
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

Re: [BETA] PhpBB IUM (Inactive User Reminder)

Post by andreask »

Version moved to [BETA]
Also changed title to proper "representation"
Thank you.
Here is what I am working on right now...
Inactive User Manager for phpBB
Give it a try...
If you would like to buy me a bier ;) for my work I will drink it on a hot summer day and thank you!!!
Shazzaky
Registered User
Posts: 2
Joined: Mon May 16, 2016 1:29 pm

Re: [BETA] PhpBB IUM (Inactive User Reminder)

Post by Shazzaky »

This extension is extactly what i need for my board! I will test it soon, and i will let you know how it runs :D

IMHO this extension could be easly turned into a newsletter system, that sends to user each certain days an email with hot topics and other stuff.
User avatar
potku
Registered User
Posts: 980
Joined: Wed Dec 22, 2004 10:26 pm
Location: Tampere, Finland
Contact:

Re: [BETA] PhpBB IUM (Inactive User Reminder)

Post by potku »

This looks like a useful EXT-to-be. :)

*bookmarked*
Potku.net

"Before I speak, I have something important to say."

- Groucho Marx
Anuj Dhawan
Registered User
Posts: 378
Joined: Sat Aug 10, 2013 6:44 pm

Re: [BETA] PhpBB Inactive User Reminder

Post by Anuj Dhawan »

Great extension, appreciate your effort! :)

Have installed it on a test board and the installation was slick. I've couple of observations, might interest you:

1. Can the email templates for "inactive users" and "sleepers" be available in the ACP for edit, please? This might not be that significant however, it'd give more control and would avoid to 'edit the files', just in case.

2. The extension shows "inactive user list", can we please show the "sleeper's list" too? If the admin is considering someone 'sleeper', admin would like to see the user name, I believe, before allowing extension to send an email.

3. Being nitpicky here - the screen shots shown use the word "Manager" and acronym "IUM" as in "Inactive User Manager", while when I install the extension it says, "IUR" where "R is for 'Reminder' ". The confusion is - there, in the first post, are two links to download the extension as well - one is direct link to .zip file and other is to the repository on github. Looking at two links and "IUR" and "IUM", it looked like there are two versions of the same extension. Installed "both" and realized it was the same extension actually. May be you'd like to align it all. :)
Last edited by Anuj Dhawan on Tue Sep 13, 2016 1:04 pm, edited 1 time in total.
Thanks,
andreask
Registered User
Posts: 752
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

Re: [BETA] PhpBB Inactive User Reminder

Post by andreask »

Hi Anuj,

Thanks for your feedback.
About the e-mail templates I'll think about it. But for now at least ill stick with this. I want first to complete the project as described and then if there is something I can improve or add I will do it.

The list contains all users, inactive & sleepers. Perhaps if you filter the users by setting interval to 30 days (minimum amount of days) and by last visit would help you? Of course if you have a suggestions I'm all ears.
And perhaps I should change the description.

Yes, that is because when I started developing the project I named it "Inactive User Manager" but then I decided to rename it to "Inactive User Reminder". The easiest thing for me to do is to rename it back to it's original name.
Which I probably will do because at the end it kinda is a manager and not just a reminder. But then it will loose the "reminder" word and I'm afraid that this may cause misinterpretation. Anyway on my next release I will update the name and every language back to its originals. (that is IUM and NOT IUR)

I would suggest you and anyone else to download the zip file which I am pointing on my first post (download section) and not go to my github repository (for now at least), Because the repository will most probably contain an unstable version of the EXT where in the download link I post here points to a release where I know is "stable".

Once again thanks for your feedback.
Here is what I am working on right now...
Inactive User Manager for phpBB
Give it a try...
If you would like to buy me a bier ;) for my work I will drink it on a hot summer day and thank you!!!
andreask
Registered User
Posts: 752
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

Re: [BETA] PhpBB IUM (Inactive User Manager/reminder)

Post by andreask »

Hello new beta version...

Again any feedback is welcome.
You can download from here.
Please submit your bugs/problems here or in github

Thanks.
Here is what I am working on right now...
Inactive User Manager for phpBB
Give it a try...
If you would like to buy me a bier ;) for my work I will drink it on a hot summer day and thank you!!!
ghost1313
Registered User
Posts: 80
Joined: Sat Aug 27, 2016 7:47 pm

Re: [BETA] PhpBB IUM (Inactive User Manager/reminder)

Post by ghost1313 »

Sweet, very interested - Good job and thanks!!!!!!!
User avatar
donsenilo
Registered User
Posts: 359
Joined: Wed Oct 08, 2014 6:23 pm
Name: Markus
Contact:

Re: [BETA] PhpBB IUM (Inactive User Manager/reminder)

Post by donsenilo »

Hi

I've installed your ext, but I'm a little bit confused :roll:

When starts your ext to send out the mails ?
I have a few members that are inactive for over 30 days but shown in the "Inactive User List" as active.

And btw. ...
It would be very useful if there could be an option to the the mail function (send a test mail to xxx).
Locked

Return to “Extensions in Development”