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

[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:

Requirements:

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:





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

[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]

my bad I forgot to comment my var_dumps...

This ext is still under development
It is still has a lot of work!

[DueLearner]

This is a great idea and I'd love to use this. Keeping an eye on this ext.

[spaceace]

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

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]

thanks !!! good luck.. +1
hope to see beta version very soon

[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!

[andreask]

Version moved to [BETA]
Also changed title to proper "representation"
Thank you.

[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

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.

[potku]

This looks like a useful EXT-to-be.

*bookmarked*

[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.

[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.

[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.

[ghost1313]

Sweet, very interested - Good job and thanks!!!!!!!

[donsenilo]

Hi

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

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).