vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)
-   -   Mini Mods - Email reminder for inactive users (https://vborg.vbsupport.ru/showthread.php?t=138946)

Mrdby 05-21-2007 11:56 PM

How can we test it?

dune3000 05-22-2007 05:26 PM

I have warning from my host saying my forum sent 10000 emails today

Quote:

All these emails were sent via your
public_html/modules/Forums/admin/admin_styles.php script.
I unsuspended your account.
Please note, the account will be suspended if it happens again.
It is possible then this script/MOD sending those emails?
my settings:

Is this product active?: YES
Days of Inactivity: 60
Email Frequency : 60
Inactivity based on last post: NO

Please help,
Thank you

djbaxter 05-22-2007 11:56 PM

Quote:

Originally Posted by djbaxter (Post 1252202)
Prior to version 1.10, emails were sent out in batches with a configurable batch size using a cron job. Starting with version 1.10, all emails were added to the vBulletin mail queue. I think with a mod like this, that's a mistake, and certainly it seems to have caused a number of problems for different forum installations - that's why version 1.09 is still available for download. The author, Chris, is working on the bugs in 1.11 as he gets time but my advice is to consider version 1.10 and 1.11 as Beta versions, with 1.09 as the latest stable release.

Quote:

Originally Posted by C Braithwaite (Post 1252219)
i can understand that emails will be sent out regular with the latest version, and tbh i think 1.09 is the better option.

Quote:

Originally Posted by dune3000 (Post 1252789)
I have warning from my host saying my forum sent 10000 emails today

It is possible then this script/MOD sending those emails?

Uninstall version 1.11. Install version 1.09.

maamon 05-24-2007 11:28 PM

Arabization file has been produced from feeling

pictureboarduk 05-25-2007 02:02 AM

Great Mod!

Just installed, but where do I find where to do it's settings?

Thanks.

djbaxter 05-25-2007 11:24 AM

Go to Admin CP | vBulletin Opetions | vBulletin Options | Inactive User Reminder Emails.

Total666 05-26-2007 06:09 PM

ANy Idea why I would receive around 250 + e-mails like this

Inactive User Reminder Email Report

This email shows that the product is installed and working as it should be.

There were no inactive users at this time.

one every 1 to 3 minutes ?? Ideas .. Thnaks

Total

djbaxter 05-26-2007 10:35 PM

I believe you're using version 1.11 - check the settings in your vBulletin options for Inactive Users.

Total666 05-27-2007 12:19 AM

Quote:

Originally Posted by djbaxter (Post 1255223)
I believe you're using version 1.11 - check the settings in your vBulletin options for Inactive Users.


I checked and I'm using 1.0.9



I don't see any other settings in the inactive user reminder settings area .. Total

djbaxter 05-27-2007 01:31 AM

Quote:

Originally Posted by Total666 (Post 1255256)
I checked and I'm using 1.0.9

I don't see any other settings in the inactive user reminder settings area .. Total

Admin CP | vBulletin Options | Inactive User Reminder Emails

Set:

Days of Inactivity = 90
How many days a user can go without posting before they are considered inactive.

Product Active?
Is this product active? Yes

Email Frequency =30
How often to send a reminder email once a member has become inactive.

Email Quantity = 3-50, depending on available server resources
How many emails to send each time cron runs (Lower means faster board, but longer to send all emails. Higher, vice versa.)

Usergroups = ???
List the usergroups that you wish to send the emails to here. (Seperate by commas) eg. 2,3,4,7

Total666 05-27-2007 01:52 AM

Quote:

Originally Posted by djbaxter (Post 1255282)
Admin CP | vBulletin Options | Inactive User Reminder Emails

Set:

Days of Inactivity = 90
How many days a user can go without posting before they are considered inactive.

Product Active?
Is this product active? Yes

Email Frequency =30
How often to send a reminder email once a member has become inactive.

Email Quantity = 3-50, depending on available server resources
How many emails to send each time cron runs (Lower means faster board, but longer to send all emails. Higher, vice versa.)

Usergroups = ???
List the usergroups that you wish to send the emails to here. (Seperate by commas) eg. 2,3,4,7


The settings are now like you suggested .. I'll let you know .. Thanks .. Total

ComputerVitals 05-27-2007 04:13 AM

I have a question.

If user X has become inactive for lets say 30 days.
I have it set for 30 days.

The addon will send a reminder email on day 31.
How often will this user get an email? will it be every day? or will it be another 30 days before they get an email?

C Braithwaite 05-27-2007 11:19 AM

Quote:

Originally Posted by Total666 (Post 1255095)
ANy Idea why I would receive around 250 + e-mails like this


Inactive User Reminder Email Report

This email shows that the product is installed and working as it should be.


There were no inactive users at this time.


one every 1 to 3 minutes ?? Ideas .. Thnaks

Total

I'm making a guess here that you installed 1.11 then changed to 1.09? did you remember to replace the php file?

C Braithwaite 05-27-2007 11:20 AM

Quote:

Originally Posted by ComputerVitals (Post 1255316)
I have a question.

If user X has become inactive for lets say 30 days.
I have it set for 30 days.

The addon will send a reminder email on day 31.
How often will this user get an email? will it be every day? or will it be another 30 days before they get an email?

depends on the frequency setting.

ComputerVitals 05-27-2007 04:09 PM

Quote:

Originally Posted by C Braithwaite (Post 1255475)
depends on the frequency setting.

Ok, it was set at 3

so does them mean it's sending out emails to that user every 3 days?
I would like it only every 30 days.

djbaxter 05-27-2007 04:29 PM

Quote:

Originally Posted by ComputerVitals (Post 1255598)
Ok, it was set at 3

so does them mean it's sending out emails to that user every 3 days?

Yes, exactly.

Quote:

Originally Posted by ComputerVitals (Post 1255598)
I would like it only every 30 days.

Just change the 3 to 30. :)

raven3d 05-27-2007 05:54 PM

it was 1.09 and they said a script on my forum was sending hundreds of emails and it was killing the server!

anyway, brilliant mod but sadly on my behalf an over zealous host.

djbaxter 05-27-2007 06:05 PM

Quote:

Originally Posted by raven3d (Post 1255667)
it was 1.09 and they said a script on my forum was sending hundreds of emails and it was killing the server!

anyway, brilliant mod but sadly on my behalf an over zealous host.

Your settings are incorrect. See instructions and this post: https://vborg.vbsupport.ru/showpost....&postcount=650

LordDB 05-27-2007 07:35 PM

Hi there, djbaxter

Got a little problem here...can you kindly advise, plz?

I ran the mod, and got the message below! How can I correct this?

Cheers!:)

Quote:

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM user WHERE lastactivity < '1179088245' AND emailDate < '1179088245' AND options & 16 LIMIT;

MySQL Error : 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 '' at line 1
Error Number : 1064
Date : Sunday, May 27th 2007 @ 09:30:45 PM
Script : http://www.norfolkmanagementrentals....cron&cronid=24
Referrer : http://www.norfolkmanagementrentals.co.uk/forum
IP Address :
Username : Mega Admin
Classname : vb_database

djbaxter 05-27-2007 10:03 PM

Quote:

Originally Posted by daPLAYBOY (Post 1255724)
Hi there, djbaxter

Got a little problem here...can you kindly advise, plz?

I ran the mod, and got the message below! How can I correct this?

Cheers!:)

I'm no MySQL expert but I don't see anything obviuously wrong with that query.

I think the problem may be that you're running vBulletin 3.60, according to that error message. I think Chris developed and tested the add-on on 3.64 and later.

One more reason to upgrade your vBulletin installtion (but certainly not the only one - some of the updates were security fixes).

ComputerVitals 05-28-2007 01:48 AM

Quote:

Originally Posted by djbaxter (Post 1255613)
Yes, exactly.
Just change the 3 to 30. :)

Thanks a bunch!

SCRIPT3R 05-28-2007 05:28 AM

"Inactive User Reminder Email Report",

i'm looking to begin an additonal paragraph between each section of listed emails; will adding the additional \n\n\n (bolded) in the php respectively accomplish this?

This email shows that the product is installed and working as it should be.\n\n\nEmails sent to:" . $sentlist . ".\n\n\nWe tried to email the following users...

SnitchSeeker 05-28-2007 06:09 AM

Quote:

Originally Posted by djbaxter (Post 1214955)
Read the thread!

Set your email frequency to something longer than 1. At that setting, it will try to send out emails to every inactive user every day.

Set it to something reasonable like 30, or 60, or 90 (days). Or longer if you wish.

It would be really nice if there was a way to set it to send out ONLY ONE e-mail and then stop. Like if setting it to "0" would make it only send out one mail.

I had it set to "3" thinking it would send out three mails and then stop, but it was sending mails out every three days FOR EVER until users deleted their accounts. Not at all cool and not making us popular with the members.

Thanks for considering this! :)

(For now, I have changed it to send out only once every 120 days, but would prefer to set it to zero, meaning no-repeat.)

SCRIPT3R 05-28-2007 06:22 AM

Quote:

Originally Posted by SnitchSeeker (Post 1256004)
It would be really nice if there was a way to set it to send out ONLY ONE e-mail and then stop. Like if setting it to "0" would make it only send out one mail.

I had it set to "3" thinking it would send out three mails and then stop, but it was sending mails out every three days FOR EVER until users deleted their accounts. Not at all cool and not making us popular with the members.

Thanks for considering this! :)

(For now, I have changed it to send out only once every 120 days, but would prefer to set it to zero, meaning no-repeat.)

i actually like that aspect of this hack... who cares what your INACTIVE users think; they're INACTIVE. ;)

djbaxter 05-28-2007 11:34 AM

Quote:

Originally Posted by SnitchSeeker (Post 1256004)
It would be really nice if there was a way to set it to send out ONLY ONE e-mail and then stop. Like if setting it to "0" would make it only send out one mail.

I had it set to "3" thinking it would send out three mails and then stop, but it was sending mails out every three days FOR EVER until users deleted their accounts. Not at all cool and not making us popular with the members.

Thanks for considering this! :)

(For now, I have changed it to send out only once every 120 days, but would prefer to set it to zero, meaning no-repeat.)

You can include instructions in your email about how to set an account to NOT receive emails from Admins. Or you can set it to something like 365 or even 3650 days.

Quote:

Originally Posted by GearTripper (Post 1256011)
i actually like that aspect of this hack... who cares what your INACTIVE users think; they're INACTIVE. ;)

I agree, sort of - I wouldn't want to annoy active users (after all, the intent is to remind them about the forum and invite them back) but I also like the fact that I can send out a reminder every 30, 60, 90 days or whatever.

eNforce 05-28-2007 06:57 PM

Does this hack send an email soon after you install it, or does it need to wait for the time specified in Email Frequency?

SCRIPT3R 05-28-2007 09:44 PM

Quote:

Originally Posted by djbaxter (Post 1256112)
I agree, sort of - I wouldn't want to annoy active users (after all, the intent is to remind them about the forum and invite them back) but I also like the fact that I can send out a reminder every 30, 60, 90 days or whatever.

but, that's just it... you wouldn't be annoying ACTIVE users, just the INACTIVE ones. ;)

djbaxter 05-28-2007 11:28 PM

Quote:

Originally Posted by GearTripper (Post 1256482)
Quote:

Originally Posted by djbaxter
I agree, sort of - I wouldn't want to annoy active users (after all, the intent is to remind them about the forum and invite them back)

but, that's just it... you wouldn't be annoying ACTIVE users, just the INACTIVE ones. ;)

:o That was a typo. I meant I don't want to annoy any users, even the inactive ones, if I can get them to rteturn. :)

C Braithwaite 05-29-2007 07:53 AM

Quote:

Originally Posted by daPLAYBOY (Post 1255724)
Hi there, djbaxter

Got a little problem here...can you kindly advise, plz?

I ran the mod, and got the message below! How can I correct this?

Cheers!:)

Can you post your settings - I can see the problem, just gotta figure out why..

LordDB 05-29-2007 02:48 PM

Quote:

Originally Posted by C Braithwaite (Post 1256707)
Can you post your settings - I can see the problem, just gotta figure out why..

I switched over to v1.09, and still encountered the DB error!

I've since uninstalled it until a solution can be found, so waiting on you my friend!

Thx!

BBI-Ross 05-29-2007 05:11 PM

I've updated to 3.6.7 and it doesn't seem to send emails anymore... Any ideas?

C Braithwaite 05-29-2007 06:48 PM

Quote:

Originally Posted by daPLAYBOY (Post 1256923)
I switched over to v1.09, and still encountered the DB error!

I've since uninstalled it until a solution can be found, so waiting on you my friend!

Thx!

I need your settings that you used before I can come up with a solution.
Try re-install and use the default settings, then let me know if you get the same problem?

Quote:

Originally Posted by BBI-Ross (Post 1256996)
I've updated to 3.6.7 and it doesn't seem to send emails anymore... Any ideas?


as soon as i upgrade to 3.6.7 ill be fxing it.

Iceman62 05-29-2007 08:16 PM

Quote:

Originally Posted by C Braithwaite
as soon as i upgrade to 3.6.7 ill be fxing it.

That's what I'm waiting on. I'd really like this hack. Cheers to making it!

wrang 05-29-2007 11:17 PM

I haved put the 1.11 in my system but i get some mail like this
Is it something wrong or has the mail been sent?

Quote:

This email shows that the product is installed and working as it should be.


Emails sent to:Anna-Karin Manks situla . We tried to email the following users, but their email address was invalid:

I run vBulletin? Version 3.6.7

v12kid 05-30-2007 01:20 AM

Quote:

Originally Posted by wrang (Post 1257214)
I haved put the 1.11 in my system but i get some mail like this
Is it something wrong or has the mail been sent?



I run vBulletin? Version 3.6.7


that is normal, thats the report you get. Looks to be working fine :)

C Braithwaite 05-30-2007 05:14 AM

Quote:

Originally Posted by Iceman62 (Post 1257107)
That's what I'm waiting on. I'd really like this hack. Cheers to making it!

Quote:

Originally Posted by wrang (Post 1257214)
I haved put the 1.11 in my system but i get some mail like this
Is it something wrong or has the mail been sent?



I run vBulletin? Version 3.6.7

That's runing normal - 3.6.7 you say? so obviously it does work on that version.. hmmm

Iceman - what gives you the indication that it's not working? any error messages or anything? what happens when you run the cron manually?

letsjoy 06-02-2007 10:36 PM

nice mod thanks for it

Iceman62 06-03-2007 01:28 AM

Quote:

Originally Posted by C Braithwaite (Post 1257376)
Iceman - what gives you the indication that it's not working? any error messages or anything? what happens when you run the cron manually?

I just wasn't sure if it would work on 3.6.7. I've got it installed now. ;)

ElForro 06-03-2007 10:58 AM

I'm a little confused... In the report I get everyday, I see 10/20 users who received the mail... I checked that users and of course, they are inactive since 60 days (that's my setting)... However, if i search users who where active AFTER 60 days ago and BEFORE 59 days ago (inactive for 60 days) i have tons of them (100/150)... I don't understand how this hack gets the "inactivity"... My forum has over 40.000 registered users, and I'm sure that there are a lot more than 10/20 users who reach every day the "60 day" inactivity...

I've tried searching users wich were last active 60 days ago, AND have 1 or more posts.. And that results are more like the sent emails (20/30)... But even like that, I found users who where not emailed (checking the log)... I checked that users to see if it could be something with the "receive E-Mail from administrators" but it's not that either... So, I really don't know wich parameter take this script to send out the emails...

Any clue?

daemon_ 06-03-2007 11:17 AM

Hello there, very nice hack. Im wondering if you can alternate it a bit and be able to send the most viewed threads, most replied etc during the user's absence or a specified timeframe.


All times are GMT. The time now is 08:50 PM.

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.02846 seconds
  • Memory Usage 1,855KB
  • 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
  • (33)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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