[3.3][RC] [3.1][3.2][RC] 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)
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21059
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

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

Post by RMcGirr83 »

and DATE_SUB is specific to MySQL.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
andreask
Registered User
Posts: 608
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

3Di wrote:
Tue Mar 07, 2017 2:28 am
https://github.com/andreaskou/PHPBB_IUM ... r.php#L221

Those group IDs shouldn't be hard-coded, may vary from installations, especially upgrades or conversions. ;)
Yes I know! I am planning for a group selection anyway, so this will be changed.
BTW what is the best way to recognize the groups? (who is who)
RMcGirr83 wrote:
Tue Mar 07, 2017 2:32 am
and DATE_SUB is specific to MySQL.
I was thinking another approach, maybe I do it via php... :roll:
Do you have any other suggestions perhaps?

Thank you both for the help! :)
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
3Di
Former Team Member
Posts: 15510
Joined: Mon Apr 04, 2005 11:09 pm
Location: Milan (IT) Frankfurt (DE)
Name: Marco
Contact:

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

Post by 3Di »

AND p.group_id NOT IN (1,4,5,6) ..I am assumning you want to exclude:

GUESTS group 1
GLOBAL_MODERATORS group 4
ADMINISTRATORS group 5
BOTS group 6

The related group IDs of a vanilla phpBB.

You are not excluding Founders. Here we go, it doesn't matter if those IDs changed
on a per installation basis, we will catch them in any case:

AND (p.user_type <> ' . USER_FOUNDER . ') // no FOUNDERS
AND (p.user_type <> ' . USER_IGNORE . ') // no BOTS Group 6
AND (p.user_id > ' . ANONYMOUS . ') // no GUESTS Group 1

Add to your SELECT this bit , p.user_type.

Now you need to find AND p.group_id NOT IN (4,5) (Glob. Moderators, Admins).

You can have a look on how the teampage is handled in memberlist.php, I used a snippet
from an extension of RMcGirr83 (Top Five) instead, to eclude those (a catch all, every user with administrative or moderative permissions), have a look here:
https://github.com/3D-I/tpotm/blob/1.0. ... p#L95-L107
And the array inclusion into the query:
https://github.com/3D-I/tpotm/blob/1.0. ... r.php#L154

You need to add the Auth object to your constructor in in order to use that snippet
https://github.com/3D-I/tpotm/blob/1.0. ... hp#L22-L24
https://github.com/3D-I/tpotm/blob/1.0. ... hp#L51-L53

Once done you can remove AND p.group_id NOT IN (1,4,5,6).

The above extension (TPOTM) will shed some light also about the use of PHP instead of DATE_SUB.
I am managing gaps of time this way.. but it can be done in different ways, PHP offers the date_sub function, not explored though.
https://github.com/3D-I/tpotm/blob/1.0. ... r.php#L156

This function is redundant I guess
https://github.com/andreaskou/PHPBB_IUM ... #L383-L396
Board's default language lies into $config['default_lang'].

Have fun. :)
Please PM me only to request paid works. Thx.
Want to compensate me for my interest? Donate
My development's activity º PhpStorm's proud user
Extensions, Scripts, MOD porting, Update/Upgrades
:studio_microphone: Premium extensions @ The Studio
User avatar
Hartenheer
Registered User
Posts: 780
Joined: Fri Jan 23, 2015 12:23 pm
Location: The Netherlands
Name: Willem Hartman
Contact:

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

Post by Hartenheer »

Small problem ,It says last reminder sent > 1

No reminder sent
Why not sent?

Image
Sorry English is not my native language :oops:
regards: Willem

https://bierfijnproevers.nl/bierforum
andreask
Registered User
Posts: 608
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

3Di wrote:
Wed Mar 08, 2017 1:01 am
AND p.group_id NOT IN (1,4,5,6) ..I am assumning you want to exclude:

GUESTS group 1
GLOBAL_MODERATORS group 4
ADMINISTRATORS group 5
BOTS group 6

The related group IDs of a vanilla phpBB.
...............

Have fun. :)
WOW! thanks!!!!
Hartenheer wrote:
Wed Mar 08, 2017 9:38 am
Small problem ,It says last reminder sent > 1

No reminder sent
Why not sent?
Willem,

Have you checked spam on e-mail?
Also check error log in phpbb maybe there is something.
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
Hartenheer
Registered User
Posts: 780
Joined: Fri Jan 23, 2015 12:23 pm
Location: The Netherlands
Name: Willem Hartman
Contact:

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

Post by Hartenheer »

Willem,

Have you checked spam on e-mail?
Also check error log in phpbb maybe there is something.

It was not sent to me

In the picture you can see
Reminder number one
Then it says: No posted
Sorry English is not my native language :oops:
regards: Willem

https://bierfijnproevers.nl/bierforum
andreask
Registered User
Posts: 608
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

Willem,

In the screenshot I see that there was a reminder sent on 20/02/2017
Did you received this reminder then?
This was 2 weeks ago maybe it was deleted?

Have you tried sending you a test reminder from "IUM configuration" page?
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
Hartenheer
Registered User
Posts: 780
Joined: Fri Jan 23, 2015 12:23 pm
Location: The Netherlands
Name: Willem Hartman
Contact:

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

Post by Hartenheer »

The memory should be sends to a forum member ,not to me
But find it strange that there is no message sent
This is shown here

Image
Sorry English is not my native language :oops:
regards: Willem

https://bierfijnproevers.nl/bierforum
User avatar
Hartenheer
Registered User
Posts: 780
Joined: Fri Jan 23, 2015 12:23 pm
Location: The Netherlands
Name: Willem Hartman
Contact:

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

Post by Hartenheer »

The test messages are tight. Only the automatic messages not
Sorry English is not my native language :oops:
regards: Willem

https://bierfijnproevers.nl/bierforum
andreask
Registered User
Posts: 608
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

This is right...

Image

Red circle is the amount of the reminders that have been sent.
If the number is one then this means that there have been sent only one reminder thus there is no previous reminder sent yet!
When there will be sent a new reminder to the same user the number of red circle will increase.
And there will be a change of dates for the latest reminder on LAST REMINDER
AND the PREVIOUS REMINDER will be populated with the LAST REMINDER of number 1 reminder.

I hope I was clear.
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
Hartenheer
Registered User
Posts: 780
Joined: Fri Jan 23, 2015 12:23 pm
Location: The Netherlands
Name: Willem Hartman
Contact:

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

Post by Hartenheer »

andreask wrote:
Wed Mar 08, 2017 2:10 pm
This is right...

Image

Red circle is the amount of the reminders that have been sent.
If the number is one then this means that there have been sent only one reminder thus there is no previous reminder sent yet!
When there will be sent a new reminder to the same user the number of red circle will increase.
And there will be a change of dates for the latest reminder on LAST REMINDER
AND the PREVIOUS REMINDER will be populated with the LAST REMINDER of number 1 reminder.

I hope I was clear.
Yes it is clear
Not sent any members yet, made me confused

Thanks
Sorry English is not my native language :oops:
regards: Willem

https://bierfijnproevers.nl/bierforum
Bullseye!
Registered User
Posts: 170
Joined: Sun Mar 21, 2010 11:42 pm

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

Post by Bullseye! »

Is there an ETA on this extension?
andreask
Registered User
Posts: 608
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

I am hopping that next week there will be a RC release.
But it all depends on how my time and will is going to be.

You can still use it, if you want. For a beta it's stable.
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!!!
Bullseye!
Registered User
Posts: 170
Joined: Sun Mar 21, 2010 11:42 pm

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

Post by Bullseye! »

Ok then.. I'll give it a go :)
User avatar
OmkePom
Registered User
Posts: 205
Joined: Tue Jul 15, 2014 8:38 am
Name: IJsbrand Nijboer

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

Post by OmkePom »

I use it,

but i think reminders arent sent yet?

He also doesn't send test e-mail ?

:ugeek:
You got Brains like a Peanut, OMG i insulted a Peanut!
Post Reply

Return to “Extensions in Development”