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)

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).


All times are GMT. The time now is 08:37 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.02117 seconds
  • Memory Usage 1,746KB
  • 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
  • (9)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (4)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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