Auto Email Inactive Ordinary Users

[tusuka]

Need for 2.0.3 :s

[dadaas]

Table 'xxx_xxx.members' doesn't exist
File: /home/xxx/public_html/nationalprepperexchange.com/forum/Packages/temp/2b3-dbmodify.php
Line: 19

FIX IS:
Open that file and around 19 line you will see it mentions "members"
Change to smf_mebers

Code Select Expand

// Upgrade the database if necessary
db_extend('packages');

$smcFunc['db_add_column']('smf_members',
array(
'name' => 'aeiou_email',
'type' => 'int',
'size' => '10',
'null' => false,
'default' => '0'
), array(), 'ignore');

$smcFunc['db_add_column']('smf_members',
array(
'name' => 'aeiou_count',
'type' => 'smallint',
'size' => 1,
'null' => false,
'default' => '0'
), array(), 'ignore');

[shteca]

awesome!

[Arantor]

Actually it should be {db_prefix}members, not smf_members.

[Doug Varrieur]

Is your Mod working in the 1.1.18 version?

[tzora]

anyone got this to work on 2.0.4? if yes, please PM me. would appreciate your help a lot. thx guys

[Nvb]

Actually it should be {db_prefix}members, not smf_members.

Awesome!

[MotRude]

I Would like this for 2.0.4 as well.

[Sakae]

Love to see this working on 2.0.4

[Galaxy Computers]

Has anyone got this to work on the latest version yet?

[bpratt]

seems quite likely none of us will get an update that works with smf 2.xx

Very handy package for those still running v1.x series of smf though.

[Eclipse16V]

Works fine on my 2.0.4

[Galaxy Computers]

Ok,,, when I click install I got this error:


Table 'XXXXXX_mtsupport.members' doesn't exist
File: /home/xxxxxx/public_html/support/Packages/temp/2b3-dbmodify.php
Line: 19

[Galaxy Computers]

I have just look in my Database there is a smf_members I don't know why it this mod won't install.

[Arantor]

Because the code in the database system changed between this mod being written and what is there now. Note the lack of smf_ in the dbmodify.php error

[GZ06]

Has anyone got this to work on the latest version yet?

yes.

Works fine on my 2.0.4

No.

Anybody knows why it sending emails to permanently banned users?
How we can exclude such users from mailing?

[Sandmansa]

I too would love to see this updated to work with 2.0.4

[demlak]

i want to mail the final email again and again and again..

my idea is to change

Code Select Expand

aeiou_count = aeiou_count+1
to:

Code Select Expand

aeiou_count = 1

is this the solution?

btw.. possible german translation:

Code Select Expand

<file name="$languagedir/Modifications.german_informal.php" error="skip">
<operation>
<search position="end" />
<add><![CDATA[
$txt['scheduled_task_email_inactive'] = 'Automatische Email an inaktive Benutzer (AEIOU)';
$txt['scheduled_task_desc_email_inactive'] = 'Sendet eine Erinnerung an Benutzer die bereits min. 21 Tage inaktiv sind. <a href="' . $scripturl. '?action=admin;area=modsettings;sa=aeiou">Optionen.</a>';
$txt['aeiou'] = 'Email inaktive Benutzer';
$txt['aeiou_title'] = 'Automatische Email an inaktive Benutzer (AEIOU)';
$txt['aeiou_status'] = 'AEIOU ist {STATUS}. Einstellungen auf der {PAGE} Seite.';
$txt['aeiou_mail_status'] = 'Die E-Mail Warteschlange ist {STATUS}.<br />Dies kann zu Performanzproblemen führen.<br />Aktiviere sie auf der {PAGE} Seite.';
$txt['aeiou_enabled'] = 'aktiviert';
$txt['aeiou_disabled'] = 'deaktiviert';
$txt['aeiou_settings'] = 'Einstellungen';
$txt['aeiou_initial_subject'] = 'Überschrift der Initial-Email';
$txt['aeiou_initial_message'] = 'Text der Initial-Email';
$txt['aeiou_final_subject'] = 'Überschrift der Final-Email';
$txt['aeiou_final_message'] = 'Text der Final-Email';
$txt['aeiou_email_desc1'] = 'Nur-Text (Kein html, kein bbcode)';
$txt['aeiou_email_desc2'] = 'Erlaubte Variablen sind:';
$txt['aeiou_email_desc3'] = '$username, $displayname, $forum, $link, $lostpassword';
$txt['aeiou_last_emailed'] = 'Die letzten 10 angeschriebenen inaktiven Benutzer';
$txt['aeiou_never'] = 'Nie';
$txt['aeiou_initial'] = 'Initial Email';
$txt['aeiou_final'] = 'Final Email';
$txt['aeiou_default_subject'] = 'Hey $displayname';
$txt['aeiou_default_message'] = 'Hey $displayname, wir vermissen dich im $forum.
Da du schon lange nichtmehr bei uns warst, wollen wir dich hiermit einladen, mal wieder vorbeizuschauen.

$link

Dein Benutzername ist $username.
Solltest du dein Passwort vergessen haben, kannst du es hier erneut anfordern $lostpassword

Beste Grüße
$forum Staff';]]></add>
</operation>
</file>

and a sumup of bug fixes posted in this thread (and found another one):
in 2b3-dbmodify.php line 12 and 21
change

Code Select Expand

$smcFunc['db_add_column']('members',
to

Code Select Expand

$smcFunc['db_add_column']('{db_prefix}members',

in 2b3-remove-db-settings.php line 12 and 13
change

Code Select Expand

$smcFunc['db_remove_column']('members', 'aeiou_email');
$smcFunc['db_remove_column']('members', 'aeiou_count');
to

Code Select Expand

$smcFunc['db_remove_column']('{db_prefix}members', 'aeiou_email');
$smcFunc['db_remove_column']('{db_prefix}members', 'aeiou_count');

in 2b3-install.xml line 170
change

Code Select Expand

'<a href="' . $scripturl . '?action=admin;area=maintain;sa=tasks">' . $txt['maintain_tasks'] . '</a>'),
to

Code Select Expand

'<a href="' . $scripturl . '?action=admin;area=scheduledtasks">' . $txt['maintain_tasks'] . '</a>'),

[Rain Forest]

Small bump for 2.0.4

[Sandmansa]

The last author has not returned in almost 3 years so how can I ask permission?  I can and have implemented those adjustments into the package installer and confirmed that it installs and works on 2.0.5 .  I made no other modifications then what has been posted here to fix it.  All original credits are still in place.  Now, would I violate any rules here if that is all I did and I attached it?