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)

navjotjsingh 08-24-2007 04:15 AM

Quote:

Originally Posted by redtailboa (Post 1319676)
I installed this on another server and confirmed that it will not work if you have SMTP Email set to yes in Vbulletin options.

I use SMTP option and it works fine. For the information I use Gmail SMTP Servers to send mails.

induslady 08-24-2007 01:31 PM

Wanted to know whether this mod works with vB 3.6.3?

ElForro 08-24-2007 04:34 PM

I've checked something else...

When I run the cron [with a Test group] the Cron Log says "No Emails to send". However, the "emailDate" field for that Test Group users change from "0" to "1187976610". So, it is updating the date as if sending the email, but no email is sent...

I've tried both, 1.09 and 1.1.1

I'm using VBulletin 3.6.8

Edit: i've changed "Inactivity based on last post" to YES, and it seems that now it is sending out emails... Must be something wrong with that option...

cubenz 08-27-2007 08:51 AM

Hi,

Great mod :installed:. (1.0.9)

I have modified it slightly to allow the addition of a few 'teasers' from recent, active threads from within the forum. As this is my first vB mod, I'm not sure what to do next with my changes.

What is the protocol here for offering my changes back to the community - do I send them to CB, and he can incorporate them in to the next release, or do I start a new mod?

Thanks

Quentin :)

Delphiprogrammi 08-28-2007 11:44 AM

Quote:

Originally Posted by cubenz (Post 1326590)
What is the protocol here for offering my changes back to the community - do I send them to CB, and he can incorporate them in to the next release, or do I start a new mod?

ask the original author to include it within a next release.Do not start a new mod that's against the rules unless you have the original author permission

raiderlax 08-29-2007 04:47 AM

When I run it I get:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /includes/cron/remindermail.php on line 29

Please how do I fix this?

Tact7626 08-31-2007 01:58 AM

nice and nifty. installed today. easy to understand. i almost feel like testing it by going inactive myself but that's crazy. :p


btw. i'm assuming the instructions don't apply to the new one no more cause the instructions say .php but the file is now .xml. so...you should prolly update the instructions so poeple don't get confused and upload it the old way.

MotMann 08-31-2007 10:47 AM

Why does html not working?

djbaxter 08-31-2007 01:45 PM

Quote:

Originally Posted by MotMann (Post 1329422)
Why does html not working?

1. If you installed version 1.11, uninstall that. Download version 1.09 and install that instead.

2. If you still can't get HTML emails to work, it may not be this add-on. It may be your mail server, or your email client. Can you normally receive HTML email from other sources? Are you able to send out HTML emails through your mail server from other programs like a newsletter?

MotMann 08-31-2007 06:57 PM

2) yes.. yes. yes ;)

djbaxter 08-31-2007 07:16 PM

Okay, if I understand your somewhat laconic reply, you caqn send out HTML emails from your server AND you can receive HTML emails from your server and/or ISP.

What about the version? Are you using version 1.09 of this add-on? If not, uninstall version 1.10 or 1.11 and download and install version 1.09.

induslady 09-01-2007 02:40 AM

Quote:

Originally Posted by induslady (Post 1324750)
Wanted to know whether this mod works with vB 3.6.3?

Does version1.0.9 work with vB 3.6.3?

Please let me know. I am interested in this mod.

djbaxter 09-01-2007 02:44 AM

It was developed when 3.6.4 was out, if I recall correctly, but I see no reason why it wouldn't work with 3.6.3 - give it a try.

MotMann 09-01-2007 08:56 AM

Quote:

Originally Posted by djbaxter (Post 1329683)
Are you using version 1.09 of this add-on? If not, uninstall version 1.10 or 1.11 and download and install version 1.09.

I test it...

vertigo jones 09-02-2007 08:45 PM

Quote:

Originally Posted by cubenz (Post 1326590)
Hi,

Great mod :installed:. (1.0.9)

I have modified it slightly to allow the addition of a few 'teasers' from recent, active threads from within the forum. As this is my first vB mod, I'm not sure what to do next with my changes.

What is the protocol here for offering my changes back to the community - do I send them to CB, and he can incorporate them in to the next release, or do I start a new mod?

Thanks

Quentin :)

Could you PM this to me? I'd love it. Thanks.

Fungsten 09-02-2007 08:52 PM

Quote:

Originally Posted by vertigo jones (Post 1330991)
Could you PM this to me? I'd love it. Thanks.

Me too!

cubenz 09-03-2007 08:05 PM

Quote:

Originally Posted by Fungsten (Post 1330994)
Me too!

Will do - I'll need a couple of days to update the documentation :o

A number of the recipients of the e-mails have commented that the HTML tags are visible, even using 1.0.9.

My testing does not show this, using Outlook Express, Outlook 2000, Gmail and Yahoo clients.

Of the ones that have been highlighted to me, the common thread seems to be that the message has been forwarded from the address to which it was sent to another address. Has anyone else experienced this, and is there anyway of making the headers robust enough to preserve the formatting even on forwarding.

Note that I have NOT been able to reproduce this problem, so it will need an e-mail guru to diagnose, IMO.

Thanks

Quentin

djbaxter 09-03-2007 08:41 PM

Quote:

Originally Posted by cubenz (Post 1326590)
Hi,

Great mod :installed:. (1.0.9)

I have modified it slightly to allow the addition of a few 'teasers' from recent, active threads from within the forum. As this is my first vB mod, I'm not sure what to do next with my changes.

What is the protocol here for offering my changes back to the community - do I send them to CB, and he can incorporate them in to the next release, or do I start a new mod?

Thanks

Quentin :)

Quote:

Originally Posted by Delphiprogrammi (Post 1327310)
ask the original author to include it within a next release.Do not start a new mod that's against the rules unless you have the original author permission

Quote:

Originally Posted by vertigo jones (Post 1330991)
Could you PM this to me? I'd love it. Thanks.

Quote:

Originally Posted by Fungsten (Post 1330994)
Me too!

Quote:

Originally Posted by cubenz (Post 1331665)
Will do - I'll need a couple of days to update the documentation

Nothing wrong with customizing a mod for your own use or even passing along information about how it was done to others.

However, as has been noted, it's not good form to publish the changes as a new add-on, except where attempts to contact the original author have failed for some reason, and that6 doesn't apply in this case.

As a courtesy, I would suggest you also pass the information along to Chris in case it might be helpful to him in developing future versions.

raiderlax 09-03-2007 09:45 PM

Quote:

Originally Posted by raiderlax (Post 1327863)
When I run it I get:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /includes/cron/remindermail.php on line 29

Please how do I fix this?

anyone know the reason of this?

cubenz 09-03-2007 10:06 PM

Quote:

Originally Posted by raiderlax (Post 1331705)
anyone know the reason of this?

Hi,

It means that your query has failed for some reason, and no 'handle' to the query result has been returned.

If you haven't made any changes, then the most likely reasons are:

MySQL DB connection is not being made correctly (in which case, nothing would work)

Mod has not been installed correctly, and a new field emaildate is not present on the user table.

Quentin

cubenz 09-03-2007 10:07 PM

Quote:

Originally Posted by djbaxter (Post 1331678)
Nothing wrong with customizing a mod for your own use or even passing along information about how it was done to others.

However, as has been noted, it's not good form to publish the changes as a new add-on, except where attempts to contact the original author have failed for some reason, and that6 doesn't apply in this case.

As a courtesy, I would suggest you also pass the information along to Chris in case it might be helpful to him in developing future versions.

Hear what you say - I'll send to CB as well.

Quentin

cubenz 09-04-2007 08:06 AM

Here's an example of what is happening:

The email is coming out with no 'from', but the real 'from' is showing below the headers
Headers are included in message
HTML tags displayed.

Any clues appreciated!

Quote:

-----Original Message-----
From:
Sent: Tuesday, 4 September 2007 8:33 p.m.
To: <removed for privacy>
Subject: campfire! We miss you!

Content-type: text/html; charset=iso-8859-1

To: campfire <removed>
From: PropertyTalk.com Reminder Service <removed>


<p>Hello, campfire!</p>

<p>We've noticed that you've not been active on PropertyTalk.com for quite
some time now,

and we miss you!</p>

<p>Could we not tempt you back? Here are a few of the things that have been
discussed on the forum recently....</p>

[snip]

Delphiprogrammi 09-05-2007 11:45 AM

hi,

To send that email you must send the content-type header.vBulletins vbmail(); functions uses plaintext by default(/includes/class_mail.php) so something like this

emailreminder.php find

PHP Code:

$message stripslashes($message); 

add below

PHP Code:

$headers NULL;
$headers  'MIME-Version: 1.0' "\r\n";
$headers .= 'Content-type: text/html; charset=iso-8859-1' "\r\n";
$headers .= 'Content-Transfer-Encoding: 8bit' "\r\n";
$headers .= 'To: $username <$toemail>' "\r\n";
$headers .= 'From: ' $vbulletin->options['bbtitle'] . ' Reminder Service <' $vbulletin->options['webmasteremail'] . '>' "\r\n";
$headers .= 'Reply-to:Webmaster <' $vbulletin->options['webmasteremail'] . '>' "\r\n";
$headers .='Content-Transfer-Encoding: 8bit' "\r\n";
$headers .='X-Priority: 1' "\r\n"

should do it


if it works feel free to use it if not don't yell at me :D

cubenz 09-05-2007 08:30 PM

Thanks

I'm using 1.0.9, which uses mail directly, not vb_mail.

I'll try the new headers, and see what happens.

Quentin

bryanb 09-06-2007 06:58 PM

I've been using this for a couple of months now, and it's been working great.

One problem - I have had a number of AOL spam complaints due to lazy AOL users who would report these mailings as spam instead of letting me know that they'd like to have their accounts deleted. I real PITA.

Is there any way to deselect AOL email addresses (or any email addresses for that matter) using wild cards? That would be great to add as a modification. In the meantime, I've had to shut this off. :(

Codeman05 09-07-2007 12:52 AM

Quote:

Originally Posted by Greivog (Post 1293568)
Hello

When I install, I get the following when I run the script:

Inactive User Reminder Emails

db)) { exit; } error_reporting(E_ALL & ~E_NOTICE); if($vbulletin->options['reminder_active']){ $now = time(); $datetime = array(); $quantity = $vbulletin->options['quantity']; $datetime[lastpost] = $now - (60 * 60 * 24 * $vbulletin->options['inactivity']); $datetime[lastemail] = $now - (60 * 60 * 24 * $vbulletin->options['frequency']); $usergroups = explode(",",$vbulletin->options['usergroups']); if($vbulletin->options['reminder_posts']){ $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastpost < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } else { $result = $vbulletin->db->query_read("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("SELECT * FROM " . TABLE_PREFIX . "user WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); $vbulletin->db->query_write("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16"); //print("UPDATE " . TABLE_PREFIX . "user SET emailDate = '$now' WHERE lastactivity < '$datetime[lastpost]' AND emailDate < '$datetime[lastemail]' AND options & 16
"); } print("Found " . mysql_num_rows($result) . " Inactive Users.

"); while($row = $vbulletin->db->fetch_array($result)){ if(is_member_of($row, $usergroups)){ print("Sent To: $row[username]
"); $username = $row[username]; $toemail = $row[email]; $userid = $row[userid]; $bbtitle = $vbulletin->options['bbtitle']; $homeurl = $vbulletin->options['homeurl']; $forumurl = $vbulletin->options['bburl']; $hometitle = $vbulletin->options['hometitle']; eval('$message = "' . addslashes($vbulletin->options['message']) . '";'); $message = stripslashes($message); //$headers = "MIME-Version: 1.0" . "\r\nContent-type: text/html; charset=iso-8859-1" . "\r\n"; $uheaders .= "To: $username <$email>" . "\r\n"; $uheaders .= "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n"; eval('$subject = "' . addslashes($vbulletin->options['subject']) . '";'); $subject = stripslashes($subject); if($vbulletin->options['reminder_emailfooter']){ $message = $message . "Email Reminder System Provided By Mished.co.uk"; } /*if(@mail($email, $subject, $message, $headers)){ print("mailing $email (done)
"); } else { print("mailing $email (failed)
"); }*/ if(is_valid_email($toemail)){ $sentlist .= "$username "; vbmail($toemail, $subject, $message, $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = '', $username = ''); } else { $failedlist .= "$username "; } } } if($sentlist == ""){ log_cron_action("No Emails to send", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nThere were no inactive users at this time.", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } else { log_cron_action("Emails sent to:$sentlist. We tried to email the following users, but their email address was invalid:$failedlist", $nextitem); vbmail($vbulletin->options['webmasteremail'], "Inactive User Reminder Email Report", "This email shows that the product is installed and working as it should be.\n\n\nEmails sent to:" . $sentlist . ". We tried to email the following users, but their email address was invalid:" . $failedlist . "", $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = "From: " . $vbulletin->options['bbtitle'] . " Reminder Service <" . $vbulletin->options['webmasteremail'] . ">" . "\r\n", $username = ''); } } else { print("Product is inactive at this time!"); } ?>
Done



The script dosnt sent out any emails if i run it myself or let it run itsself.

Any ideas?


I am having the same error, any thoughts??

Delphiprogrammi 09-07-2007 10:38 AM

phpmailer (http://phpmailer.sourceforge.net) will do just fine to

PHP Code:

require_once(DIR '/includes/class.phpmailer.php');
    
$mail = new PHPMailer();
    
$mail->isSendMail(true);
    
$mail->Priority 1;
    
$mail->isHTML(true);
    
$mail->Encoding "8bit";
    
$mail->CharSet "iso-8859-1";
    
$mail->From "";
    
$mail->FromName "nobody";
    
$mail->AddReplyTo("","webmaster");
    
$mail->AddAddress("$toemail","$username");
    
$mail->Subject "$subject";
    
$mail->Body "$message";
    
$mail->AltBody "";
    
$mail->WordWrap 0;
    if(!
$mail->send());
    {
      echo 
"Mailer Error: " $mail->ErrorInfo;
    } 

will send HTML email easy !

dollster68 09-08-2007 07:03 PM

Thank you, thank you, thank you for this nifty tool. Got it installed with the help of djbaxter (I'm a total novice that needed help with where to upload the .xml file).

Since there are a few versions being run of this mod I would like to suggest a FAQ on the front page. It took a long time to scroll through 50+ pages of this tread only to find that the answer to my question wasn't there. Also, the very first post stated that instructions were included, but I couldn't find any when I downloaded v. 1.09.

bryanb 09-10-2007 08:19 PM

Quote:

Originally Posted by bryanb (Post 1333780)
...Is there any way to deselect AOL email addresses (or any email addresses for that matter) using wild cards? That would be great to add as a modification. In the meantime, I've had to shut this off. :(

Any ideas on how to do this? Thanks in advance!

djbaxter 09-10-2007 09:26 PM

Why did you need to "shut this off" because of AOL? I don't understand the problem. We all know that AOL filters email aggressively but so what?

bryanb 09-11-2007 08:57 AM

Quote:

Originally Posted by djbaxter (Post 1336526)
Why did you need to "shut this off" because of AOL? I don't understand the problem. We all know that AOL filters email aggressively but so what?

Because I have hundreds of newsletter subscribers and forum members who use AOL. If my server is receiving spam complaints from AOL, then that is a big issue for me. My domain could be blocked from AOL and that would not be a good thing.

I am hoping that someone could assist me in coming up with a solution for this. Thanks!

djbaxter 09-11-2007 09:06 AM

Quote:

Originally Posted by bryanb (Post 1336842)
Because I have hundreds of newsletter subscribers and forum members who use AOL. If my server is receiving spam complaints from AOL, then that is a big issue for me. My domain could be blocked from AOL and that would not be a good thing.

I am hoping that someone could assist me in coming up with a solution for this. Thanks!

The solution is to include opt-out instructions in every email. Edit the message from your ACP to do so. Here's a sample:

Quote:

Hello, $username!

<p>You are receiving this email because you previously registered at {name of your forum here} with the following information:</p>

<p>Member name: $username<br>
User number: $userid<br>
Email address: $email</p>

<p>It's been some time since your last visit to our community.</p>

<p>You might be interested in having another look. We have added several features and enhancements to the forums, and many new topics and new members are added every day.</p>

<p>If you don't remember your password, you can request it here: <a href="http://{forum URL here}/login.php?do=lostpw">http://{forum URL here}/login.php?do=lostpw</a>.</p>

<p>We hope to see you back soon.</p>

<p>If you do not wish to receive further emails of this nature, please log into your UserCP at <a href="http://{forum URL here}/profile.php?do=editoptions">http://{forum URL here}/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>

<p>Administrator<br>
<a href="http://{forum URL here}">{forum name here}</a><br></p>
I include opt-out instructions in every email sent out by my forum. I've had notices a few times (I think 3 or 4) about my emails being blocked as spam at the ISP level. Each time, I hjave forwarded a copy of the email pointing out that only registered forum members ever receive the emails and that opt-out instructions are included - I have had the block removed every time.

bryanb 09-11-2007 12:47 PM

Quote:

Originally Posted by djbaxter (Post 1336849)
The solution is to include opt-out instructions in every email. Edit the message from your ACP to do so. Here's a sample:



I include opt-out instructions in every email sent out by my forum. I've had notices a few times (I think 3 or 4) about my emails being blocked as spam at the ISP level. Each time, I hjave forwarded a copy of the email pointing out that only registered forum members ever receive the emails and that opt-out instructions are included - I have had the block removed every time.

Thanks a million! I think that will do the trick :up:

Job4Suprmn 09-12-2007 05:59 PM

Not sure if anyone else experienced this. I saw people saying it sends e-mails to banned users. But on my board, banned users came back...unbanned.

Does this mod inadvertently un-ban people? Maybe when they click the link to change their password? I'm not sure how he got back, he just e-mailed me bragging saying that he got back because of the reminder e-mail.

CMGU 09-12-2007 06:18 PM

great .. thanks

djbaxter 09-12-2007 06:32 PM

Quote:

Originally Posted by Job4Suprmn (Post 1337772)
Not sure if anyone else experienced this. I saw people saying it sends e-mails to banned users. But on my board, banned users came back...unbanned.

Does this mod inadvertently un-ban people? Maybe when they click the link to change their password? I'm not sure how he got back, he just e-mailed me bragging saying that he got back because of the reminder e-mail.

No, it doesn't unban banned members.

1. You can select which member groups to email in the ACP under vBulletin Options | Inactive Users Email | Usergroups:

Code:

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

Make sure that banned members aren't included.

2. How was the member banned? I don't know whether it's yet fixed but in version 3.6.6, I believe, or eerlier, there was a vBulletin bugged where members banned via the infraction system were able to return after one of their infractions expired, even when one of the infractions resulted in a permanent ban.

3. You say he emailed you. Did he return to the forum and post anything? If no, he's probably yanking your chain.

Fungsten 09-12-2007 06:42 PM

I can't get it to work in 3.6.8.

djbaxter 09-12-2007 06:51 PM

Quote:

Originally Posted by Fungsten (Post 1337807)
I can't get it to work in 3.6.8.

It works fine in 3.6.8.

What happens when you install it? Which version are you installing? It helps if you provide a bit more information beyond just "this doesn't work".

Fungsten 09-12-2007 06:54 PM

Quote:

Originally Posted by djbaxter (Post 1337811)
It works fine in 3.6.8.

What happens when you install it? Which version are you installing? It helps if you provide a bit more information beyond just "this doesn't work".

Sorry. Using your latest version. When I ran it no reminders were sent out. Yes all the appropriate usergroups are added.

djbaxter 09-12-2007 07:01 PM

Version 1.11 should be labeled "Beta", in my opinion. Try uninstalling that version and installing 1.09.


All times are GMT. The time now is 10:41 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.02724 seconds
  • Memory Usage 1,894KB
  • 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
  • (1)bbcode_code_printable
  • (3)bbcode_php_printable
  • (26)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