vb.org Archive

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)

Stefan118 05-16-2011 08:37 PM

Thanks mate!
Update works great. (rated you exellent)
Yesterday it send 261 mails before it "crashed".
Today after the update it send another 89 mails.

Keep up the good work.
I got 11 active members back allready.

TalkVirginia 05-16-2011 09:37 PM

Quote:

Originally Posted by Stefan118 (Post 2196477)
Thanks mate!
Update works great. (rated you exellent)
Yesterday it send 261 mails before it "crashed".
Today after the update it send another 89 mails.

Keep up the good work.
I got 11 active members back allready.

That's great! but... Crashed?! :eek: What happened? Did it send out too many emails at one time? Let me know if I need to tweak something. :up: :)

Stefan118 05-17-2011 03:40 PM

Quote:

Originally Posted by TalkVirginia (Post 2196500)
That's great! but... Crashed?! :eek: What happened? Did it send out too many emails at one time? Let me know if I need to tweak something. :up: :)

No...
With the "crash" i ment the database error i got becouse of the username with the " ' " in it.
After your update it works great!

TalkVirginia 05-17-2011 05:46 PM

Quote:

Originally Posted by Stefan118 (Post 2196792)
No...
With the "crash" i ment the database error i got becouse of the username with the " ' " in it.
After your update it works great!

Awesome! :up: Glad to hear it! :)

Brandon Sheley 05-17-2011 06:04 PM

updated and it looks like it's working

thanks!

doopz 05-18-2011 06:27 AM

Hi!

I was wondering if it's possible to change the FROM: address ?
Right now it seems to be using the site title, but since my site title is rather long it seems to do strange things such as adding quotes and all. Is there an easy way to change the from adres? from: name <name@email.com>

thanks in advance

TalkVirginia 05-18-2011 10:01 AM

Quote:

Originally Posted by doopz (Post 2197072)
Hi!

I was wondering if it's possible to change the FROM: address ?
Right now it seems to be using the site title, but since my site title is rather long it seems to do strange things such as adding quotes and all. Is there an easy way to change the from adres? from: name <name@email.com>

thanks in advance

I'm not sure I understand your example of what you want or are asking.

doopz 05-18-2011 10:29 AM

Quote:

Originally Posted by TalkVirginia (Post 2197098)
I'm not sure I understand your example of what you want or are asking.

Code:

$uheaders .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $webmaster_email .">\r\n";
I don't want the from address to be the bbtitle, but a simple name + email adres.
The bbtitle is messing things up.

Wesley

TalkVirginia 05-18-2011 04:00 PM

Quote:

Originally Posted by doopz (Post 2197104)
Code:

$uheaders .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $webmaster_email .">\r\n";
I don't want the from address to be the bbtitle, but a simple name + email adres.
The bbtitle is messing things up.

Wesley

I'll try, but there seems to be an issue with changing the email headers in vBulletin or atleast I haven't been able to find info on how to do it. That line of code you're showing in the quote I took out for that reason because it wasn't changing it correctly. It was changing it to "From: Site Title <Site Title>" with quotes around the first Site Title. As soon as I removed the uheaders line it started working correctly. I'll try to work on that more.

theoutlawed 05-19-2011 06:59 PM

Thanks for a great mod, just applied the 2.1.5 update.

This is a great tool to pique the interest of people who may have stayed a week and wandered off, or for while your site is growing to remind people to come back and check things out again.

Bravo, job well done.

Merenguista 05-19-2011 07:51 PM

thanks man ..

TalkVirginia 05-19-2011 11:01 PM

You're very welcome! :)

ndut 05-20-2011 01:08 AM

installed, thank you

TalkVirginia 05-20-2011 10:33 AM

What type of email connection to host do most forum admins prefer? IMAP/POP3? SMTP? This is in regards to checking bounced email.

doopz 05-20-2011 10:52 AM

Quote:

Originally Posted by TalkVirginia (Post 2197935)
What type of email connection to host do most forum admins prefer? IMAP/POP3? SMTP? This is in regards to checking bounced email.

I personaly use SMTP as my mail servers are spread among several IP's causing less trouble from providers such as yahoo and hotmail who will block IP's when you're sending large amounts of mail.

But as for bounces I use a pop3 box.

doobiefillin 05-20-2011 01:09 PM

is the latest version 2.1.5 because I got the MySQL Error: 1064 with this version of the plugin.

PHP Code:

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE user SET rmEmailDate UNIX_TIMESTAMP(), WHERE TIMESTAMPDIFF(DAYFROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND TIMESTAMPDIFF(DAYFROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) = 30 AND options 16 AND usergroupid IN ('6','2','') AND rmoptout 0 LIMIT 10;;

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP(' at line 1
Error Number  
1064
Request Date  
FridayMay 20th 2011 01:30:51 AM
Error Date    
FridayMay 20th 2011 01:30:51 AM
Script        
http://www.xxxxxxxxxx.net/forums/cron.php?rand=1305869449
Referrer      http://www.xxxxxxxxxx.net/forums/showthread.php/1041-official-eurokracy-stache-procces!
IP Address    xx.xx.xx.xx
Username      
Unregistered
Classname     
vB_Database_MySQLi
MySQL Version 



TalkVirginia 05-20-2011 01:55 PM

1 Attachment(s)
Quote:

Originally Posted by doobiefillin (Post 2197979)
is the latest version 2.1.5 because I got the MySQL Error: 1064 with this version of the plugin.

PHP Code:

Database error in vBulletin 4.1.3:

Invalid SQL:
UPDATE user SET rmEmailDate UNIX_TIMESTAMP(), WHERE TIMESTAMPDIFF(DAYFROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP())) >= 30 AND TIMESTAMPDIFF(DAYFROM_UNIXTIME(rmEmailDate), FROM_UNIXTIME(UNIX_TIMESTAMP())) = 30 AND options 16 AND usergroupid IN ('6','2','') AND rmoptout 0 LIMIT 10;;

MySQL Error   You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE TIMESTAMPDIFF(DAY, FROM_UNIXTIME(lastvisit), FROM_UNIXTIME(UNIX_TIMESTAMP(' at line 1
Error Number  
1064
Request Date  
FridayMay 20th 2011 01:30:51 AM
Error Date    
FridayMay 20th 2011 01:30:51 AM
Script        
http://www.xxxxxxxxxx.net/forums/cron.php?rand=1305869449
Referrer      http://www.xxxxxxxxxx.net/forums/showthread.php/1041-official-eurokracy-stache-procces!
IP Address    xx.xx.xx.xx
Username      
Unregistered
Classname     
vB_Database_MySQLi
MySQL Version 



Thank you for the info - I'll look into this and post a fix as soon as I can.

EDIT: AH, Ok.. I see the problem. If you don't mind and feel like you can make the change yourself. Here's how you can do it.

1. Open the <forum>\includes\functions_remindermail.php
2. Find:

Lines 91 and 212.
PHP Code:

"SET rmEmailDate = UNIX_TIMESTAMP(), "

3. Remove the comma at the end of TIMESTAMP() on both lines.

4. Save the file and you should be good to go.

If you decide you don't want to edit it yourself, I've attached a fixed file to this post. Just drop it in your forum includes folder.

Let me know if you have any other issues.

Thanks,
Jim

gamerzhut 05-20-2011 04:07 PM

Installed & rated.

Thank you sir :)

TalkVirginia 05-21-2011 01:11 AM

Quote:

Originally Posted by gamerzhut (Post 2198039)
Installed & rated.

Thank you sir :)

...and thank YOU! :) Hopefully rated well. :up: ;)

gamerzhut 05-21-2011 03:44 AM

Quote:

Originally Posted by TalkVirginia (Post 2198218)
...and thank YOU! :) Hopefully rated well. :up: ;)

RATED ***** :)

TalkVirginia 05-21-2011 01:01 PM

I wanted to post an idea I had for discussion. I was analyzing where inactivity is being based on last post date. Currently there is no other criteria being used so when grace period for inactivity is reached a member will start getting reminders the day after. Granted my plan is to adapt this add-on to something similar to the rules criteria for when notices are displayed, but for now I was thinking that the inactivity criteria should be opened up instead of basing it on one or the other.. (ie. Last Post Date, Last Visit date...) but have the option to base inactivity on last post date if the member's last visit was greater than or equal to whatever number of days you choose. Make sense? I'm open for input and would be interested to hear yours.

Thanks,
Jim

gamerzhut 05-21-2011 03:35 PM

I guess Inactive based on last visit is more than enough. Since it would be bugging out the members if we simply send out the emails. Correct me if i am wrong.

TalkVirginia 05-21-2011 03:56 PM

Quote:

Originally Posted by gamerzhut (Post 2198391)
I guess Inactive based on last visit is more than enough. Since it would be bugging out the members if we simply send out the emails. Correct me if i am wrong.

You are correct. That being said, is there anyone basing inactivity on lastpost date? Would anyone like to see more criteria added similar to the notices? ... or would anyone like me to take lastpost date out all together.

S_E_A 05-21-2011 05:19 PM

Quote:

Originally Posted by TalkVirginia (Post 2197992)
Thank you for the info - I'll look into this and post a fix as soon as I can.

EDIT: AH, Ok.. I see the problem. If you don't mind and feel like you can make the change yourself. Here's how you can do it.

1. Open the <forum>\includes\functions_remindermail.php
2. Find:

Lines 91 and 212.
PHP Code:

"SET rmEmailDate = UNIX_TIMESTAMP(), "

3. Remove the comma at the end of TIMESTAMP() on both lines.

4. Save the file and you should be good to go.

If you decide you don't want to edit it yourself, I've attached a fixed file to this post. Just drop it in your forum includes folder.

Let me know if you have any other issues.

Thanks,
Jim

TalkVirginia, should we all make the suggested amendment?

Thank you for an excellent mod.

TalkVirginia 05-21-2011 05:28 PM

Quote:

Originally Posted by S_E_A (Post 2198423)
TalkVirginia, should we all make the suggested amendment?

Thank you for an excellent mod.

Yes, everyone that has v2.15 installed will need to do this.

S_E_A 05-21-2011 06:02 PM

Thank you :)

Alan_SP 05-21-2011 11:01 PM

Quote:

Originally Posted by TalkVirginia (Post 2198395)
You are correct. That being said, is there anyone basing inactivity on lastpost date? Would anyone like to see more criteria added similar to the notices? ... or would anyone like me to take lastpost date out all together.

I use it by last activity, but someone might (maybe even I) use it for both things. If you could as 2 in one, to remind those who didn't log in and didn't write anything in set period. With different messages, what would make it a very long list of settings.

Don't know, bothering users isn't best strategy. Maybe having last activity is enough?

TalkVirginia 05-22-2011 08:09 AM

Quote:

Originally Posted by Alan_SP (Post 2198526)
I use it by last activity, but someone might (maybe even I) use it for both things. If you could as 2 in one, to remind those who didn't log in and didn't write anything in set period. With different messages, what would make it a very long list of settings.

Don't know, bothering users isn't best strategy. Maybe having last activity is enough?

Good points. Thank you for your input. :)

Stefan118 05-22-2011 09:18 AM

An other point.

I have set the inactivity to 60 days (2 months), and last night an user who has last signed in at april 8th got the reminder mail.
An other user has last logd in march 27, and also got an email last night.

Not that I bother, but how comes?

TalkVirginia 05-22-2011 07:38 PM

Quote:

Originally Posted by Stefan118 (Post 2198625)
An other point.

I have set the inactivity to 60 days (2 months), and last night an user who has last signed in at april 8th got the reminder mail.
An other user has last logd in march 27, and also got an email last night.


Not that I bother, but how comes?

What year? :)

CharlieDelta 05-22-2011 08:17 PM

Quote:

Originally Posted by TalkVirginia (Post 2198395)
You are correct. That being said, is there anyone basing inactivity on lastpost date? Would anyone like to see more criteria added similar to the notices? ... or would anyone like me to take lastpost date out all together.

Yes. I would like to see more criteria. We would make great use out of both at our forums.

Stefan118 05-22-2011 09:11 PM

Quote:

Originally Posted by TalkVirginia (Post 2198810)
What year? :)

Member since december 18 2010 at 21:45
Last activety march 27 2011 at 00:51
last post: december 18 2010 at 22:01

And the other one:
Member since march 4 2011 at 18:45
last activety april 8 2011 at 18:40
last post april 8 2011 at 18:39

This is the setting I have:
Inactivity Grace Period
How many days before a user is considered inactive?
Default: 30 --> manualy set to 60

TalkVirginia 05-23-2011 05:16 AM

Quote:

Originally Posted by Stefan118 (Post 2198854)
Member since december 18 2010 at 21:45
Last activety march 27 2011 at 00:51
last post: december 18 2010 at 22:01

And the other one:
Member since march 4 2011 at 18:45
last activety april 8 2011 at 18:40
last post april 8 2011 at 18:39

This is the setting I have:
Inactivity Grace Period
How many days before a user is considered inactive?
Default: 30 --> manualy set to 60

Is your inactivity grace period based on Last Post or Last Visit?
According to those dates:
If Last Activity is around the same date as Last Post it's been 409 days roughly.
otherwise it's been 56 days.

Stefan118 05-23-2011 04:54 PM

My setting is based on last activity, because my opinion is that you might bother members too often if you set it by last post.

march 27 to may 21 = 55 days
april 8 to may 21 = 43 days

TalkVirginia 05-23-2011 06:35 PM

Quote:

Originally Posted by Stefan118 (Post 2199164)
My setting is based on last activity, because my opinion is that you might bother members too often if you set it by last post.

march 27 to may 21 = 55 days
april 8 to may 21 = 43 days

Agreed. Either Last Visit or Last Activity. Yeah, with 55 days and 43 days, reminders should not be going out that soon. Are you sure you don't have your mod set to be based on Last Post? That's the only way that they would be going out so soon. Make sure you save your mod settings at least once before actually using it. I've noticed that after it's first installed, it will used whatever is in memory at the time it was installed. So I recommend setting it how you want it to operate then click the submit button.

cbiweb 05-25-2011 01:49 PM

My apologies if this issue has already been addressed in this thread, but after reading 10 pages of replies my eyes were glazing over, lol.

I can't tell if it's working because none of my test accounts has received any reminders. They do have valid email addresses. I did receive the following email early this morning:
Quote:

Members who have become inactive based on their last visit date and never received a reminder email:Emails sent to:
Nixon11,the_mask_lover,hithit,drvenom,MrsWrite,
I also ran the cron job manually a few minutes ago, and got this:
Quote:

Inactive User Reminder Emails
Looking for members who have become inactive (based on their last visit date) and never received a reminder email...

5 inactive members(s) found!
Sent To: ManilaGurL
Sent To: meerulfx
Sent To: Kailash
Sent To: surfville
Sent To: whitemusk

Looking for members who have become inactive (based on their last visit date) and
haven't received a reminder email in the last 45 days...

No inactive member(s) found based on last visit date!

Done
Which also generated another email to me that said this:
Quote:

Members who have become inactive based on their last visit date and never received a reminder email:Emails sent to:
ManilaGurL,meerulfx,Kailash,surfville,whitemusk,
None of the above user names are test accounts, and shouldn't those be mentioned as well? How can tell if inactive users themselves are actually getting the reminders?

Stefan118 05-25-2011 05:01 PM

I have set the settings AGAIN to last visit date, and guess what...
last night it send another 4 SPAM mails.
SPAM, because it does not follow the settings i have given it.

This member has got a reminder mail last night!

Member since: march 29, 2010 at 9:01
Last visit: may 16, 2011 at 12:04
Last post: may 16, 2011 at 12:04

I am not crazy, my settings are based on last activety, inactive for 60 days.
I did pressed save again after your last post, just to be sure.
Now i'ts sending mail after 9 days!!!

1 more mistake of this program and i uninstall it.
This is spamming my members!

TalkVirginia 05-25-2011 05:36 PM

Quote:

Originally Posted by Stefan118 (Post 2199865)
I have set the settings AGAIN to last visit date, and guess what...
last night it send another 4 SPAM mails.
SPAM, because it does not follow the settings i have given it.

This member has got a reminder mail last night!

Member since: march 29, 2010 at 9:01
Last visit: may 16, 2011 at 12:04
Last post: may 16, 2011 at 12:04

I am not crazy, my settings are based on last activety, inactive for 60 days.
I did pressed save again after your last post, just to be sure.
Now i'ts sending mail after 9 days!!!

1 more mistake of this program and i uninstall it.
This is spamming my members!

Sounds to me like you've already made up your mind. Sorry I couldn't be of further assistance.

MrAd 05-25-2011 07:38 PM

Great Mod, thanks again Jim, quick question will there be a 3.8.x fo this mod ?

TalkVirginia 05-26-2011 02:12 AM

Quote:

Originally Posted by MrAd (Post 2199933)
Great Mod, thanks again Jim, quick question will there be a 3.8.x fo this mod ?

3.8.x release? Yes, I am planning to release one for 3.8.x. As for when, soon. I was hoping to release something this week. :erm:


All times are GMT. The time now is 10:48 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01991 seconds
  • Memory Usage 1,876KB
  • 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
  • (4)bbcode_php_printable
  • (25)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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