[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!
Scam Warning
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)
andreask
Registered User
Posts: 655
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

OK, but in this case it's not something that is needed here.
Yes, of course it will be included.
Glad that I was able to 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
nhseacoast
Registered User
Posts: 625
Joined: Sun Sep 22, 2002 10:31 pm
Location: NH, USA
Contact:

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

Post by nhseacoast »

I changed the number of inactive days from the default of 30 days to 14 days, but the inactive list still shows users inactive for 30 days.
http://nhgunforum.com phpBB v3.2.1
http://wtprise.org phpBB v3.3.2
User avatar
Hervé
Registered User
Posts: 160
Joined: Tue Jun 04, 2019 7:51 am
Location: Belgium
Name: Rudy
Contact:

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

Post by Hervé »

Hi,
something else about mails : I've choosen to give the member the possibility to self cancel his account (after administrator approval)
I don't find in the mail any "board_url / ium / {random_key}" to ask cancellation.
andreask
Registered User
Posts: 655
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

Which e-mail?
Test e-mail to you or another account?

The test e-mail will not receive any links to self delete.
I have to fake it and I haven't done any work on this so far.
Perhaps on future releases someday.

Otherwise the user should receive it normally.

@nhseacoast

Where did you change that?
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!!!
Sepp71
Registered User
Posts: 84
Joined: Sat Sep 06, 2008 11:32 pm
Location: Germany

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

Post by Sepp71 »

I like this extension very much and just want to suggest to mention the user-name explicitly in the e-mails sleeper.txt and inactive.txt.
For example like

Code: Select all

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

{FORGOT_PASS}
User name: {USERNAME}
In my board it used to happen quite often that people received the reminder and did not recognise their user name as such from subject and the greeting line; for example because they used their real names or real nicknames. This used to end up in unneccessary questions.
Of course I have already changed my texts in this way, but thought it might be useful for others, too.

Sepp

P.S.: I would still appreciate very much, if i could change the period of time for first reminder an reminder no. 2 and no. 3 for sleepers.
For example 365 days for no. 1 and then 30 days for number 2 and 3.
Is there a point in the code where I might hardcode this (for example 'like +100' ) just for my version?

and:
Somehow I got lost between the versions. My version was quite old (1.0.0. from 2016) and while installing 1.1.8, the old data about sent reminders have been deleted.
Is it possible to simply restore the database table? I found phpbb_ium_reminder in my database, but restoring it seems to have no effect on the list in the acp.
andreask
Registered User
Posts: 655
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

Hello,

But the username is already mentioned in the first line of the email templates.

Code: Select all

Hello, {USERNAME}...
Plus the template is free to modify at your discretion. Just remember to backup before you update the ext because any changes will be overwritten.
Sepp71 wrote:
Mon Jan 04, 2021 8:17 pm
if i could change the period of time for first reminder an reminder no. 2 and no. 3 for sleepers.
This will be scheduled for the next major version update. Probably after the phpbb validation processes.
Sepp71 wrote:
Mon Jan 04, 2021 8:17 pm
Is there a point in the code where I might hardcode this (for example 'like +100' ) just for my version?
I'll have to check, give me some time and I'll get back to you.
Sepp71 wrote:
Mon Jan 04, 2021 8:17 pm
Is it possible to simply restore the database table? I found phpbb_ium_reminder in my database, but restoring it seems to have no effect on the list in the acp.
All the data moved from phpbb_ium_reminder table to phpbb_users table so you'll have to import the missing data from phpbb_ium_reminder to phpbb_users. Please be careful doing this. And good luck! If you need assistance let me know!

All the best,

Andreas
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!!!
Sepp71
Registered User
Posts: 84
Joined: Sat Sep 06, 2008 11:32 pm
Location: Germany

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

Post by Sepp71 »

Hello Andreas,

thank you very much!
andreask wrote:
Fri Jan 08, 2021 4:30 pm
Hello,

But the username is already mentioned in the first line of the email templates.
That is true, but the problem is, that some users do not recognise the greeting as the mentioning of their user name, for example if they use their real name or their common nickname. ("Hello Andreas...")
I have already changed my template, thank you - I just wanted to keep others from the same question/problem.

Reimporting the table to another one looks tricky, I will try that (hoping, that I had not done another update in between that would mean my ium_reminder table is not up to date, but only something left from a previous installation).
Thank you!

Sepp
andreask
Registered User
Posts: 655
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

Hello again Sepp,

I've tried to see if there is way to do what you ask (the quick and dirty way) but unfortunately currently it's not possible.
In the future I'll have to rethink the whole user picking process because right now it's on a very simplistic way. :D
And I already have a headache because of that! :lol:
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!!!
Sepp71
Registered User
Posts: 84
Joined: Sat Sep 06, 2008 11:32 pm
Location: Germany

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

Post by Sepp71 »

andreask wrote:
Sat Jan 09, 2021 8:53 pm
Hello again Sepp,

I've tried to see if there is way to do what you ask (the quick and dirty way) but unfortunately currently it's not possible.
In the future I'll have to rethink the whole user picking process because right now it's on a very simplistic way. :D
And I already have a headache because of that! :lol:
Thank you very much for trying! If you did not get it to run, I won't try because I don't want to end up with my users table mixed up. I will set it on a period that should be acceptable at least for a single clean up.
One question s left:
Is the thable phpbb_ium_reminder still necessary when 1.1.8-RC is installed and running or can I delete it (as an accidental leftover from former installations)?
I am confused because evne my highest user-id seems to be part of ium_reminder-table, so it cannot be too old?
Maybe I did not understand you correctly?

Sepp
PowerIdeas
Registered User
Posts: 40
Joined: Sat Jan 06, 2018 12:14 am

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

Post by PowerIdeas »

Hi, thanks a lot for this extension! On our board with PHPBB 3.3.2 and PHP 7.2, IUM configuration works but Inactive users list gives this message:

SQL ERROR [ mysqli ]

Unknown column 'ium_remind_counter' in 'field list' [1054]

SQL

SELECT user_id, username, user_regdate, user_posts, user_lastvisit, user_inactive_time, user_inactive_reason, ium_remind_counter, ium_previous_sent_date, ium_reminder_sent_date, ium_dont_send, ium_request_date, ium_random, ium_type, ium_request_type FROM phpbb_users WHERE user_id not in (SELECT ban_userid FROM phpbb_banlist) AND user_type NOT IN (3, 2) AND user_id NOT IN (49, 2) AND user_inactive_reason <> 3 AND user_id > 1 AND user_regdate < 1608018244 AND user_lastvisit < 1608018244 ORDER BY user_regdate LIMIT 20

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 296
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 337
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/andreask/ium/acp/main_module.php
LINE: 719
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/andreask/ium/acp/main_module.php
LINE: 559
CALL: andreask\ium\acp\main_module->inactive_users()

FILE: [ROOT]/ext/andreask/ium/acp/main_module.php
LINE: 238
CALL: andreask\ium\acp\main_module->get_inactive_users()

FILE: [ROOT]/includes/functions_module.php
LINE: 676
CALL: andreask\ium\acp\main_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

Ignore/Delete Approval list gives similar error.
andreask
Registered User
Posts: 655
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

@PowerIdeas please reinstall (delete files and upload again) and let me know if it happens again.

@Sepp71 I was referring to your request about the extra days on the first reminder.
As for the old->new transfer of data give me a couple of days and I'll have you an sql statement that you can run and it will copy the data from ium table to the users table.
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!!!
Sepp71
Registered User
Posts: 84
Joined: Sat Sep 06, 2008 11:32 pm
Location: Germany

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

Post by Sepp71 »

andreask wrote:
Thu Jan 14, 2021 1:43 pm
@Sepp71 I was referring to your request about the extra days on the first reminder.
As for the old->new transfer of data give me a couple of days and I'll have you an sql statement that you can run and it will copy the data from ium table to the users table.
@andreask: Please don't bother! I have alread reinstalled your extension and now it's my user's problems (First 700 reminders have already been sent ;) 111 Mails could not be delivered in the first run...)
Sepp
User avatar
wads24
Registered User
Posts: 613
Joined: Fri Jun 10, 2005 4:44 am
Name: James

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

Post by wads24 »

wads24 wrote:
Sat Jul 11, 2020 7:59 pm
dimetrius wrote:
Tue Nov 12, 2019 8:06 pm
Hello,

please fix this issue:

When i send email with standart forum equipments, i am receive into email post from:
From: "=?UTF-8?B?0KTQvtGA0YPQvCDQm9GD0LPQsHNhdA==?=" <forum@domain.net>
It look like "My Forums <forum@domain.net>".

But if i send reminder from your extension, i have only email address into "From:"
From: forum@domain.net
And it look like "forum@domain.net"

without forum name.

Thanks
I was wondering about this issue also. Is this an easy fix?
andreask wrote:
Sun Jul 12, 2020 4:39 pm
Hi thanks for reminding me this.
I'll try to fix it for RC3 which I'm working on currently.
Hi andreask

Welcome to Gboard clipboard, any text you copy will be saved here.
I just installed the new version, but I do not see this corrected yet. Are there instructions you can give me to correct it?
Thanks in advance for a reply.
andreask
Registered User
Posts: 655
Joined: Fri Feb 27, 2009 6:13 pm
Name: Andreas

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

Post by andreask »

Hi wads24,

Some days ago I've sent you a message.
Have you received it? Because I can't find it in my outbox.
If you did can you tell me if it worked for 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!!!
User avatar
wads24
Registered User
Posts: 613
Joined: Fri Jun 10, 2005 4:44 am
Name: James

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

Post by wads24 »

andreask wrote:
Sun Jan 31, 2021 3:11 pm
Hi wads24,

Some days ago I've sent you a message.
Have you received it? Because I can't find it in my outbox.
If you did can you tell me if it worked for you?
Nope, I never got the PM. Can you please send again?
Thanks in advance for a reply.
Post Reply

Return to “Extensions in Development”