vb.org Archive

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

robertjandreu 05-20-2008 10:00 PM

Email reminder for inactive users 1.1.3
 
Hey Guys I've been using this mod quite a while and got a bit depressed after not seeing any updates to the mod. So I figured why not making my own modifications and help the people that had requests out a bit. I'm someone that is against spam. This mod becomes fast a annoyance to users that are inactive for a long time. That's why I will be making this mod more functional than before. Look into my to do list for new additions that will come.

Updates:
1 Email Only Function:
This function will limit the total emails send to 1. So if this email is send once they will never get a "miss you" email anymore. So people will get less anoyed and won't rate you as spam right away.

Todo:
Edit number of emails send totally
Not only 1 message but multiple messages possible and chosen with a random

If a user has not posted in x number of days, a HTML email will be sent out with a custom message.

Ive updated the mod so all the settings are editable in the AdminCP

Instructions are included.

I must insist that anyone pre 1.1.2 upgrades asap.

Update 1.1.3 (22/5/08)

* Bugfix for New Registers


Update 1.1.2 (21/5/08)

* Added 1 Email only Function


Update 1.1.1

* Edited default templates
* Added daily report


Update 1.1.0

* Changed the way that emails are sent out by adding the emails to vbulletin's mail queue
* Default cron settings now changed to once per day

To upgrade you need to overwrite the remindermail.php file in the cron directory, and ideally import the product again. The new code will work with the old product file, however I have removed one of the settings in the options as it was no longer needed. as i say it will still run with this there but the quantity setting is now no longer used.

Update 1.0.9

* Cron Log Now Working.
Update by uploading remindermail.php


Update 1.0.8

* Updated code to to exclude users who have chose not to receive admin emails.
Upgrade by uploading PHP file only.

Thanks to djbaxter for help with this.


Update 1.0.7

* Fixed "Sending to new users" bug
* Amended installation code


Update 1.0.6 (14/02/07)

* Added option to turn plugin on or off
* Added option to specify inactivity triggered by lastpost or lastactivity
* Added options to show credit to author or not. (due to some ungrateful, complaining bum squirts that have not made the effort to learn to code themselves and lean on others to make plugins for them)


Uninstall / Reinstall w/ overwrite.

Please note - This plugin adds a link in your footer, however it can be disabled via the AdminCP

Please, if you find this useful, don't disable this option.

robertjandreu 05-21-2008 02:10 PM

this one is mine :P

-=Leb=- 05-21-2008 02:22 PM

No This One Is Mine :) lOl
Thank you robert.

djbaxter 05-21-2008 03:08 PM

Is this based on version 1.11 or 1.09?

webmastersitesi 05-21-2008 04:01 PM

are you sure it work at 3.7

yahoooh 05-21-2008 04:38 PM

thanks

robertjandreu 05-21-2008 04:39 PM

Quote:

Originally Posted by djbaxter (Post 1526949)
Is this based on version 1.11 or 1.09?

its based on version 1.11
Quote:

Originally Posted by webmastersitesi (Post 1527012)
are you sure it work at 3.7

Yes it works with 3.7.0 gold I'm running it myself now :)

M-Tuning 05-21-2008 05:13 PM

Mooi werk Robert :D

Ge?nstalleerd !

robertjandreu 05-21-2008 05:16 PM

<NL>
hahaha Dank je
</NL>

Thank you :)

Mesohu 05-21-2008 06:49 PM

Installed & Nominated .

robertjandreu 05-21-2008 08:01 PM

thank you a new update will come soon. If I can figure it out since I'm kidda stuck on this one :P

projectego 05-22-2008 07:06 AM

[high]* projectego clicks install :)[/high]

KURTZ 05-22-2008 09:41 AM

i use THIS hack by Paul M, so i changed the time when a user goes inactive ... about this is there any trouble?

robertjandreu 05-22-2008 10:29 AM

Quote:

Originally Posted by KURTZ (Post 1527729)
i use THIS hack by Paul M, so i changed the time when a user goes inactive ... about this is there any trouble?

No there shoun't be any trouble. But don't forget to add the userrgroup where the user is moved to in the list of usergroups that get a email.

Everything should work right then :)

-=Leb=- 05-22-2008 11:04 AM

Hi robert, i'm having a problem,i'm getting database error, and now i'm forced to uninstall it.
Would you plz check the problem?
Try to re' register in your forum and see when you click on confirm registration see if you get same error

Now since i disabled the Email reminder for inactive users 1.1.2 the error is gone.

Here i copied the sourcecode you maybe need to look att it

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>FireWaLL Forums Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<style type="text/css">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="http://www.firewallcs.net/forums/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The FireWaLL Forums database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">www.firewallcs.net</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The www.firewallcs.net forum technical staff have been notified of the error, though you may <a href="mailto:my email address">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>


<!--
Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE user SET emailDate = '1211441635' AND emailSend = '1211441635' WHERE userid = '107';

MySQL Error : Unknown column 'emailSend' in 'field list'
Error Number : 1054
Request Date : Thursday, May 22nd 2008 @ 03:33:54 AM
Error Date : Thursday, May 22nd 2008 @ 03:33:55 AM
Script : http://www.firewallcs.net/forums/reg...p?do=addmember
Referrer : http://www.firewallcs.net/forums/reg...p?do=addmember
IP Address : 213.************
Username : blob
Classname : vb_database
MySQL Version :
-->


</body>
</html>


Or take a look at this

https://vborg.vbsupport.ru/showthread.php?t=180081

robertjandreu 05-22-2008 11:21 AM

Quote:

Originally Posted by Leb (Post 1527784)
Hi robert, i having a problem,i'm getting database error, and now i'm forced to uninstall it.
Would you plz check the problem?
Try to re' register in your forum and see when you click on confirm registration see if you get same error

Now since i disabled the Email reminder for inactive users 1.1.2 the error is gone.

Here i copied the sourcecode you maybe need to look att it

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html>
<head>
<title>FireWaLL Forums Database Error</title>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta name="ROBOTS" content="NOINDEX,NOFOLLOW,NOARCHIVE" />
<style type="text/css">
<!--
body { background-color: white; color: black; }
#container { width: 400px; }
#message { width: 400px; color: black; background-color: #FFFFCC; }
#bodytitle { font: 13pt/15pt verdana, arial, sans-serif; height: 35px; vertical-align: top; }
.bodytext { font: 8pt/11pt verdana, arial, sans-serif; }
a:link { font: 8pt/11pt verdana, arial, sans-serif; color: red; }
a:visited { font: 8pt/11pt verdana, arial, sans-serif; color: #4e4e4e; }
-->
</style>
</head>
<body>
<table cellpadding="3" cellspacing="5" id="container">
<tr>
<td><img src="http://www.firewallcs.net/forums/image.php?type=dberror" alt="Database Error" width="48" height="48" /></td>
<td id="bodytitle" width="100%">Database error</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The FireWaLL Forums database has encountered a problem.</td>
</tr>
<tr>
<td colspan="2"><hr /></td>
</tr>
<tr>
<td class="bodytext" colspan="2">
Please try the following:
<ul>
<li>Load the page again by clicking the <a href="#" onclick="window.location = window.location;">Refresh</a> button in your web browser.</li>
<li>Open the <a href="/">www.firewallcs.net</a> home page, then try to open another page.</li>
<li>Click the <a href="javascript:history.back(1)">Back</a> button to try another link.</li>
</ul>
</td>
</tr>
<tr>
<td class="bodytext" colspan="2">The www.firewallcs.net forum technical staff have been notified of the error, though you may <a href="mailto:my email address">contact them</a> if the problem persists.</td>
</tr>
<tr>
<td class="bodytext" colspan="2">&nbsp;<br />We apologise for any inconvenience.</td>
</tr>
</table>


<!--
Database error in vBulletin 3.7.0:

Invalid SQL:
UPDATE user SET emailDate = '1211441635' AND emailSend = '1211441635' WHERE userid = '107';

MySQL Error : Unknown column 'emailSend' in 'field list'
Error Number : 1054
Request Date : Thursday, May 22nd 2008 @ 03:33:54 AM
Error Date : Thursday, May 22nd 2008 @ 03:33:55 AM
Script : http://www.firewallcs.net/forums/reg...p?do=addmember
Referrer : http://www.firewallcs.net/forums/reg...p?do=addmember
IP Address : 213.************
Username : blob
Classname : vb_database
MySQL Version :
-->


</body>
</html>


Or take a look at this

https://vborg.vbsupport.ru/showthread.php?t=180081

I'm really sorry for this it's fixed now. Really thanks for the bug reply

-=Leb=- 05-22-2008 12:02 PM

thank you too for the update.It tooks many hours for me to figure out why :(
but now i installed the newer version and it seems like its working fine and special thanks to VB staff :)

robertjandreu 05-22-2008 12:12 PM

Quote:

Originally Posted by Leb (Post 1527844)
thank you too for the update.It tooks many hours for me to figure out why :(
but now i installed the newer version and it seems like its working fine and special thanks to VB staff :)

I might be not VB staff but still no problem :)

Robert Waanders 05-22-2008 04:53 PM

Hmm... seems like a nice mod, wil implement it asap, thanks!

Robert (jaja, nog een)

goddess_dix 05-22-2008 05:27 PM

Quote:

Originally Posted by robertjandreu (Post 1527050)
its based on version 1.11

Yes it works with 3.7.0 gold I'm running it myself now :)

i was under the impression from the old mod thread that 1.11 was pretty unstable and couldn't send email in html. did you recode to fix the issues? i've been watching that mod some time now because i like the idea, but the ongoing issues and lack of updates concerned me and therefore i didn't install it.

redraider 05-22-2008 05:44 PM

installed ...thanks!

robertjandreu 05-22-2008 06:57 PM

Hmmm I don't know about the email in HTML function but thanks it's a good idea if it needs to be implemented. Could you explain me how exacly you want it in html ?

EDIT:
About the stability. In my opinion this mod always has been stable. I ran version 1.11 for like 3 months and never had problems with it. Most instabilities come from misconfigurations and other plugins. As I can't test for those instabilities I can't help you. The only thing you can do is or test yourself or post the errorcode here and the plugins youre using and I could find out what the problem could be.

RedTrinity 05-23-2008 08:55 AM

I can't get this feature working properly after just downloading/installing tonight on 3.7.

Settings are set as 30 days inactivity, 90 day email frequency and only send once is off. Have several usergroups listed, many of which have inactive users (we have over 800 members and only around 200 are currently active within the last month), but whenever I run the schedule manually I always get the following response:

Quote:

Inactive User Reminder Emails
Makes no use of the reminder Count

Found 0 Inactive Users.

Done
Have tried turning "inactivity based on last post" to either setting as well as changing other settings, but it still does the same thing :confused: I can't quite work out what the problem is.

Would appreciate some support.

Cheers,

Nikki.

robertjandreu 05-23-2008 10:28 AM

First try version 1.1.1 and check if it works. If it doesn't there is or a plugin that has a conflict. Or you didn't uninstall the last on properly. Uninstall it and try installing it again.
Else you will need to give me the password of your admin account Database and FTP so I can check it :)

It also could be that you did install a previous version that send the mails if so it will not send any mails till it hits 90 days later :). It doesn't mean it will send mails every time you click the button.

RedTrinity 05-24-2008 11:49 PM

Quote:

Originally Posted by robertjandreu (Post 1528814)
First try version 1.1.1 and check if it works. If it doesn't there is or a plugin that has a conflict. Or you didn't uninstall the last on properly. Uninstall it and try installing it again.
Else you will need to give me the password of your admin account Database and FTP so I can check it :)

It also could be that you did install a previous version that send the mails if so it will not send any mails till it hits 90 days later :). It doesn't mean it will send mails every time you click the button.

Hi,

Which 1.1.1 are you referring to? I only see a link for 1.13 :confused: I did try the latest version of this one which did work, but wouldn't stop sending out multiple copies of the emails to members within a small timeframe so I uninstalled/removed it. I'm very reluctant to reinstall it after that, especially when I know I had the settings right.

I have tried uninstalling and reinstalling this version, but its still not working. I set it to just one usergroup, yet it came up the following when I ran the schedule manually:

Inactive User Reminder Emails
Makes use of the reminder Count

Found 689 Inactive Users.

Done


The group I set only had 33 members in it :confused: And it didn't send any emails out to anybody anyway, even after displaying this.

I only sent out reminder emails to one other usergroup with the previous version by the other author, yet it refuses to send out anything even with other groups for this one. So its definitely not the 90 days later issue either.

Cheers :)

-=Leb=- 05-26-2008 02:01 PM

Hi robert, it seems like this version is not working correct.
it keep sayin invalid email address on all members in my forum.
Take a look here.
Quote:

This email shows that the product is installed and working as it should be. Emails sent to:Rohlik dinkoman cobra405 PlayBoy . We tried to email the following users, but their email address was invalid:
Any idea why or if theres a way to fix the problem.

thank you

trilogy33 05-26-2008 02:09 PM

Quote:

Originally Posted by Leb (Post 1531856)
Hi robert, it seems like this version is not working correct.
it keep sayin invalid email address on all members in my forum.
Take a look here.


Any idea why or if theres a way to fix the problem.

thank you

The line: "We tried to email the following users, but their email address was invalid:" shows on every report. It merely states, in that case, that no users had invalid email addresses.

When there's a username after that message, then that username is linked to an invalid email address.

Hope that's clear 'ish ;)

goddess_dix 05-26-2008 06:35 PM

Quote:

Originally Posted by robertjandreu (Post 1528225)
Hmmm I don't know about the email in HTML function but thanks it's a good idea if it needs to be implemented. Could you explain me how exacly you want it in html ?

Well, with the plugin you referenced, the eariler version (1.9) sent out HTML emails. I didn't have something specific in mind, other than I'd like to be able to set the emails up to include my site logo and some very simply HTML styling. I know vb's emails are text by default, but have also been watching a mod or two that ads the functionality to any email vb sends.

Quote:

EDIT:
About the stability. In my opinion this mod always has been stable. I ran version 1.11 for like 3 months and never had problems with it. Most instabilities come from misconfigurations and other plugins. As I can't test for those instabilities I can't help you. The only thing you can do is or test yourself or post the errorcode here and the plugins youre using and I could find out what the problem could be.
i haven't run any of them yet, so i don't have an issue myself. i was just going from reading the support thread, pretty much whenever someone had a problem, they were told to dl the older version. just wondered if you had addressed something somehow, but it sounds like it wasn't a problem for you...

robertjandreu 05-26-2008 08:52 PM

Quote:

Originally Posted by GamerGirl27 (Post 1530505)
Hi,

Which 1.1.1 are you referring to? I only see a link for 1.13 :confused: I did try the latest version of this one which did work, but wouldn't stop sending out multiple copies of the emails to members within a small timeframe so I uninstalled/removed it. I'm very reluctant to reinstall it after that, especially when I know I had the settings right.

I have tried uninstalling and reinstalling this version, but its still not working. I set it to just one usergroup, yet it came up the following when I ran the schedule manually:

Inactive User Reminder Emails
Makes use of the reminder Count

Found 689 Inactive Users.

Done


The group I set only had 33 members in it :confused: And it didn't send any emails out to anybody anyway, even after displaying this.

I only sent out reminder emails to one other usergroup with the previous version by the other author, yet it refuses to send out anything even with other groups for this one. So its definitely not the 90 days later issue either.

Cheers :)

I tested the mod here and I'm not having these issues. I gues its some weird problem. Ok I'm going to bugtest it some more if I can find out what it is. But anyway I'm planning to make a complete rewrite in some time so this mod will be changed soon.

JadedSouls 05-26-2008 08:53 PM

Thank you for this..

*installed*

orok 05-26-2008 09:22 PM

Thank YOU :)

2dub 05-28-2008 06:14 PM

Robert,
Can this be set to send an email to those who havent visited in X days vs. those who havent posted in X days?
Thanks.

CurtisK 05-28-2008 10:52 PM

thanks for the update!!!

i love this mod and it shows our inactive members we love them really. haha

robertjandreu 05-29-2008 03:01 PM

Quote:

Originally Posted by 2dub (Post 1534299)
Robert,
Can this be set to send an email to those who havent visited in X days vs. those who havent posted in X days?
Thanks.

yes it6s already in the options. just select the last visit date in place of last post date :)

pal-mgtrb 05-30-2008 09:34 AM

great work
thanx

jpbryan 05-30-2008 07:08 PM

Thanks > INSTALLED!

Skierpetros 06-01-2008 06:31 PM

installed but how can i see that this mode work?

robertjandreu 06-03-2008 07:45 PM

Quote:

Originally Posted by Skierpetros (Post 1538054)
installed but how can i see that this mode work?

by testing it. else you simply can't :P

i13 06-04-2008 06:45 AM

Thanks!
Installed! Now waiting for email to arrive :p

sdavis2702 06-04-2008 07:48 AM

Pretty cool... thanks!


All times are GMT. The time now is 06:04 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.01400 seconds
  • Memory Usage 1,858KB
  • 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
  • (15)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)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