vb.org Archive - Mini Mods - Email Reminder for inactive users

Page 17 of 18

« First

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)

- - Mini Mods - Email Reminder for inactive users (https://vborg.vbsupport.ru/showthread.php?t=237531)

rob01

12-07-2012 01:43 AM

do this work with vb 4.2?

Alibass

12-07-2012 01:59 AM

yes...

tanyeri24

12-17-2012 10:33 PM

what time is it beginning to sending emails?

Alibass

12-17-2012 11:10 PM

around 1:30am local time

Live_Bait

12-22-2012 10:46 AM

Hi, I am wondering because i am testing this on my test site... My test site is turned off so i didn't get the reminder email I set to send to myself... so this means if your site is set to off the emails will not send ??

smirkley

12-22-2012 09:26 PM

Testing this out,... tested unsubscribe feature, after clicking on the link in email for optout, get this error...

"Could not find phrase 'error_unsubscribe_done'."

smirkley

12-22-2012 09:32 PM

Quote:

Originally Posted by smirkley (Post 2392310)

Testing this out,... tested unsubscribe feature, after clicking on the link in email for optout, get this error...

"Could not find phrase 'error_unsubscribe_done'."

found fix and updated xml

https://vborg.vbsupport.ru/showpost....&postcount=595

Mark4865

12-30-2012 12:05 PM

Looks like a great mod, installed in my test site environment.

How do I add my website logo and disclaimer into the email

justicechick

01-10-2013 01:35 PM

When I attempt to install the XML file I get this :

Importing Product, Please Wait...

[:]

Thats how is has been stuck for over 20 mins...Is this normal?

UPDATED: Its been over 2 hrs and it still says Importing *sigh*

dirkji

01-14-2013 08:58 AM

I installed version 2.2.1 and got this error:

Invalid SQL:
SELECT * FROM user WHERE rmEmailDate > 0 AND rmEmailCount > 0 AND userid = 0;
MySQL Error : Unknown column 'rmEmailDate' in 'where clause'
Error Number : 1054

Any idea what causes this error?

Thanks,
Dirk

ikorolis

02-21-2013 04:56 PM

Quote:

Originally Posted by djbaxter (Post 2321661)

I'm using the newest version: 2.21

See optout-reminder.php lines 66-74:

PHP Code:


		
			
if ($result == null)

{

    eval(standard_error(fetch_error('error_unsubscribed_already',$vbulletin->options['contactuslink'])));  

} 

else

{

   $db->query_write("UPDATE " . TABLE_PREFIX . "user SET rmoptout = 1 WHERE userid = '$userid' AND email = '$email'");

   eval(standard_error(fetch_error('error_unsubscribe_done')));    

}

Added:

I fixed it, I think, by editing the product-remindermail.xml file:

At lines 216-217, FIND:

Code:

                <phrasetype name="Error Messages" fieldname="error">

                        <phrase name="error_unsubscribed_already" date="1269327058" username="administrator" version="2.0.1"><![CDATA[Our records indicate that your subscription to our mailing list has already been cancelled. Please <a href="{1}" rel="nofollow">contact an Administrator</a> if you believe you've reached this message in error.]]></phrase>

Add AFTER:

Code:

                        <phrase name="error_unsubscribe_done" date="1269327058" username="administrator" version="2.0.1"><![CDATA[You have been unsubscribed from future reminder emails.]]></phrase>

Does this look correct?

Thanks
Fixed this error

wait to new release.

smirkley

03-12-2013 02:44 AM

Like this mod, but would LOVE to figure out how to add a checkbox in user cp settings to opt-in, with the opt-out link in the email un-checking the desire to get these reminders.

Anyone got an idea?

markhendo1986

04-15-2013 03:09 PM

Having uninstalled this mod, I have been greeted with the following errors:

Database error in vBulletin 4.2.0:

Invalid SQL:
SELECT * FROM user WHERE rmEmailDate > 0 AND rmEmailCount > 0 AND userid = 0;

MySQL Error : Unknown column 'rmEmailDate' in 'where clause'
Error Number : 1054

Any ideas how to fix it?

kartheekb

04-17-2013 10:59 AM

Does this sents a BULK Mails?

As i am on shared hosting only 500 allowed for hr.

I have 1200 Inactive users around?

smirkley

04-17-2013 12:18 PM

Yes it does send bulk

Recommended with using mailqueue system.

Easy5s.net

07-25-2013 11:49 PM

work with 4.2.1???

djbaxter

07-26-2013 12:18 AM

Quote:

Originally Posted by Easy5s.net (Post 2435388)

work with 4.2.1???

Yes it does.

kandhro

09-07-2013 05:37 AM

Hello Talkvirginia
thanks for a very important mod
installed and Voted also
totally works fine , here is one thing i want get some guide about
while receiving email to a inactive user there is a unsubscription link , clicking on that shows this "Could not find phrase 'error_unsubscribe_done'."

it will be great if i can get some guide for editing this to some decent message
hope to have a guide .
Best Regards

Jokermixer

09-27-2013 03:20 PM

In vbulletin 4.2.1 it doesn't work! there are the error.

djbaxter

09-27-2013 04:13 PM

Quote:

Originally Posted by Jokermixer (Post 2448363)

In vbulletin 4.2.1 it doesn't work! there are the error.

It works fine in 4.21.

What error are you getting?

Jokermixer

09-27-2013 06:19 PM

Quote:

Originally Posted by djbaxter (Post 2448380)

It works fine in 4.21.

What error are you getting?

Warning: require_once([path]/includes/functions_remindermail.php) [function.require-once]: failed to open stream: No such file or directory in [path]/includes/adminfunctions_plugin.php(1199) : eval()'d code on line 2

Fatal error: require_once() [function.require]: Failed opening required '/home/joker/public_html/includes/functions_remindermail.php' (include_path='.:/usr/lib/php:/usr/local/lib/php') in /home/joker/public_html/includes/adminfunctions_plugin.php(1199) : eval()'d code on line 2

there are this error.

djbaxter

09-27-2013 06:42 PM

Quote:

Originally Posted by Jokermixer (Post 2448403)

You haven't uploaded all the files for this update or you uploaded them to the wrong locations.

Jokermixer

09-28-2013 06:55 AM

Quote:

Originally Posted by djbaxter (Post 2448406)

You haven't uploaded all the files for this update or you uploaded them to the wrong locations.

i have upload the file in the right locations: admincp in admincp- images in images and so on....how can i do?

djbaxter

09-28-2013 12:52 PM

Quote:

Originally Posted by Jokermixer (Post 2448519)

i have upload the file in the right locations: admincp in admincp- images in images and so on....how can i do?

The error message above is specifically telling you that it cannot find /includes/functions_remindermail.php which is part of this add-on. Therefore, you have not uploaded all the files to the correct locations because at least that one is missing.

Check with an FTP program like FileZilla.

Make sure you transfer using Auto or ASCII for .php files.

If the file is actually there, check the file permissions which should be 0640

Jokermixer

09-28-2013 01:20 PM

Quote:

Originally Posted by djbaxter (Post 2448570)

I upload always with filezilla, but i'm sure that i have uploaded all files, i don't know...can you explain me precisely all the steps? thank you very much.

ozzy47

09-28-2013 01:25 PM

Can you check in FTP if the file functions_remindermail.php is indeed in the /includes folder?

Jokermixer

09-28-2013 02:00 PM

Quote:

Originally Posted by ozzy47 (Post 2448580)

Can you check in FTP if the file functions_remindermail.php is indeed in the /includes folder?

I have resolved thank you.

ozzy47

09-28-2013 02:05 PM

How so? Just in case someone else runs into the issue.

jjohns12

10-04-2013 06:11 PM

Works great for me Thanks

DemOnstar

10-05-2013 03:34 AM

Installed today...
Trying it for size...:up:

usefee

10-06-2013 06:15 PM

work with 4.2.1?

DemOnstar

10-06-2013 06:21 PM

Hopefully I will get a result in less than 13 days...

Loki12

10-06-2013 07:30 PM

Quote:

Originally Posted by usefee (Post 2450489)

work with 4.2.1?

Yes it does, works fine. And, it has already boosted my active membership. Indispensable mod.

usefee

10-09-2013 07:21 AM

Quote:

Originally Posted by Loki12 (Post 2450499)

Yes it does, works fine. And, it has already boosted my active membership. Indispensable mod.

thanks
download the original file from first post or modified it with this thread posts!?

usefee

10-14-2013 10:13 AM

nobody!?

rhody401

10-15-2013 01:16 PM

The one from the author works great with 4.2.1 and youll have no trouble with the instructions.

DemOnstar

10-20-2013 04:00 PM

This one seems to work! 4.2.1.

:up:

honda208

11-09-2013 08:42 PM

Is this still a working add-on? I have 4.2.2, thanks.

thernus

02-02-2014 09:02 PM

After I install the hack I get this error message via mail:

Quote:

Invalid SQL:
SELECT userid, username, email, usergroupid, FROM_UNIXTIME(lastvisit) lastvisit, FROM_UNIXTIME(lastactivity) lastactivity, CASE WHEN lastpost = 0 THEN '' ELSE FROM_UNIXTIME(lastpost) END AS lastpost, CASE WHEN rmEmailDate = 0 THEN '' ELSE FROM_UNIXTIME(rmEmailDate) END AS lastreminder, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastvisit, TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_lastactivity, CASE WHEN lastpost = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastpost), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastpost, CASE WHEN rmEmailDate = 0 THEN 0 ELSE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) END AS days_since_lastemail, rmoptout FROM vb3_user WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastactivity), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND usergroupid IN ('3','18','22','23','21') AND rmEmailCount = 0 AND options & 16 AND rmoptout = 0 LIMIT 0, 50;;

MySQL-Fehler : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) days_since_last' at line 1
Fehler-Nr. : 1064

Is there a way to fix it?

THX
th

M.C.	03-08-2014 08:31 AM

It's working but gives me error in AdminCP -> Settings:
Warning: trim() expects parameter 1 to be string, array given in [path]/includes/adminfunctions_options.php on line 1032

All times are GMT. The time now is 09:15 PM.

Page 17 of 18

« First

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02172 seconds Memory Usage 1,831KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_php_printable (13)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: