vb.org Archive - Mini Mods - Email reminder for inactive users

Page 24 of 36

Show 40 post(s) from this thread on one page

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)

Zia	10-11-2007 01:38 AM

Helo...

Quote:

55216 Inactive User Reminder Emails 01:03, 11th Oct 2007 Emails sent to:sreshto GKing rizz HonestBoy gontobboheen Chonchola Horini moharaj noman_auleek maria Amski arifbarbhuiya mhasan . We tried to email the following users, but their email address was invalid:

its really weired
the nick Gking- we always use to same mail id (even this morning) i got mail from his id- why it says invalid mail id?

we are using v 1.1.1
whats the probs?

djbaxter

10-11-2007 02:04 AM

Quote:

Originally Posted by Zia (Post 1357331)

the nick Gking- we always use to same mail id (even this morning) i got mail from his id- why it says invalid mail id? whats the probs?

What version are you using? Does this help?:

Quote:

Originally Posted by djbaxter (Post 1357063)

As I have said many times, I personally consider version 1.11 to be a beta version. I know Chris was trying to work on this but my guess is real life got in the way to delay it.

Uninstall version 1.11 and install version 1.09.

IRCMedya

10-12-2007 02:51 PM

thank you, installed

bazzup

10-12-2007 05:11 PM

@zia and redtailboa

when it reports like this

Code:

55216 Inactive User Reminder Emails 01:03, 11th Oct 2007 Emails sent to:sreshto GKing rizz HonestBoy gontobboheen Chonchola Horini moharaj noman_auleek maria Amski arifbarbhuiya mhasan . We tried to email the following users, but their email address was invalid:

that means all the users got the email and there were no invalid emails

the bit you are looking for in the message is this

Code:

We tried to email the following users, but their email address was invalid:username

note on the posts you have made nobodys email was invalid because there where no usernames after the invalid bit

hope this makes sense

PinkLiquorice

10-13-2007 06:04 AM

Why is the footer text so big?! Do we have to have the copyright for a mod on it as it doesnt match the rest of the site... cant I make it smaller at least?!

djbaxter

10-13-2007 12:26 PM

Quote:

Originally Posted by sw1 (Post 1358782)

Why is the footer text so big?!

Quote:

Originally Posted by sw1 (Post 1358782)

cant I make it smaller at least?!

I don't think Chris cares how big it is as long as you leave the active link.

Quote:

Originally Posted by sw1 (Post 1358782)

Do we have to have the copyright for a mod on it as it doesnt match the rest of the site...

Read the instructions in post #1.

PinkLiquorice

10-13-2007 02:17 PM

Ok will make it smaller. thank you

vbuser99

10-17-2007 04:16 PM

Recently I have installed version 1.11.

I have 150K members, installing this add-on for the first time may put server on its knees as it may try to send lots of emails at once. This also may cause your site marked as email spammer (or something like that) due to high number of emails per batch.

I figured I needed more options, like maximum number of emails per batch (cron) and maximum number of reminder emails per user, so users do not continue getting reminders after X number of reminders.

So I added said new options and optimized and corrected SQL code (there were some bugs) in the add-on, and now it is working great!

I would love to share this updated add-on but I do not really know where/how to post it.

Shall I post it as a new add-on on a new thread, or ...???

BadgerDog

10-17-2007 04:28 PM

Quote:

Originally Posted by vbuser99 (Post 1362425)

Recently I have installed version 1.11.

You actually got v1.11 to work ... :eek:

Congratulations.... :D

I've stuck with v1.09 and it has been working fine, but your addtional options would be nice to add.

I'd love to see your fixes posted and tried by folks who couldn't get v1.11 to function. If it works, I might just upgrade to it with your mods.

Thanks for your work.... :up:

Regards,
Badger

vbuser99

10-17-2007 04:45 PM

Quote:

Originally Posted by BadgerDog (Post 1362437)

Yes, it works and it is great, as SQL is optimized, it is fast too.

djbaxter

10-17-2007 04:58 PM

Quote:

Originally Posted by vbuser99 (Post 1362425)

That's one of the reasons I prefer v1.09.

Quote:

Originally Posted by vbuser99 (Post 1362425)

I figured I needed more options, like maximum number of emails per batch (cron) and maximum number of reminder emails per user, so users do not continue getting reminders after X number of reminders.

So I added said new options and optimized and corrected SQL code (there were some bugs) in the add-on, and now it is working great!

I would love to share this updated add-on but I do not really know where/how to post it.

Shall I post it as a new add-on on a new thread, or ...???

The author is Chris. Could you PM him and ask what his preference are? if you can't get an answer from him, I'd suggest uploading it here as an attachment, with a disclaimer that your version isn't currently supported - caveat emptor. :)

Quote:

Originally Posted by BadgerDog (Post 1362437)

I've stuck with v1.09 and it has been working fine, but your addtional options would be nice to add.

I'd love to see your fixes posted and tried by folks who couldn't get v1.11 to function. If it works, I might just upgrade to it with your mods.

Thanks for your work.... :up:

Indeed. But bear in mind that the author can only support official versions. If you encounter a problem with an unofficial update, uninstall that version and go back to 1.09.

vbuser99

10-17-2007 06:18 PM

This is the unsupported updated version of Email reminder for inactive users add-on.
You need to uninstall previous versions (1.09 or 1.11) before installing version 1.20
Both product-remindermail.xml and remindermail.php has been updated.

Version 1.20 is updated and is the working and improved version of 1.11

Updates:
- Renamed emailDate field to reminderDate (user table) because it was too generic.
- Added reminderCount field (user table)
- Added limitperbatch option to limit number of emails sent to inactive users per batch (per cron run).
- Added limitperuser option to limit number of reminder emails sent to a user.
- Updated email message
- Pull only required data via SQL for better performance.
- This version ensures that updates to user table are done correctly, by updating only processed rows. Previous version was bulk updating user table before process started.

I am in the process of adding requested changes, will upload the finished product soon...

XXP	10-17-2007 07:06 PM

Thanks for these updates (both of you). These look like they're going to be quite helpful.

We installed 1.11 and ran it successfully last week. Have delivered around 5K reminders since.

Because you call for the old Reminder to be removed and because you mention changes to the database mechanism, I need to ask, please:

Will 1.2 honor the reminders already sent -- and thus NOT resend reminders to users who've already been invited to return?

Also:
What do we need to do to preserve our customized message before installing 1.2? Will it be preserved for us or should we explicitly back it up and reinstall it?

Is there a test mechanism in this version -- to send out a test copy of the email message for proofing? (Such as: send a test copy to Admin group only, regardless of activity; OR send a test copy to user(s) in list.)

Thanks again. This is a supper tool.

vbuser99

10-17-2007 07:19 PM

Quote:

Originally Posted by XXP (Post 1362582)

As I am quite new into code releasing, I did not think of this issue.
The attached version 1.20 will NOT preserve any data as UNINSTALL is required.

I will create a seperate upgrade version, which will keep your previous settings and will honor the reminders already sent.

I will also work on a test mechanism...

frostyIntrepid

10-19-2007 02:10 AM

I am sorry but did anyone get this to work on 3.6.8?

Alibass

10-19-2007 02:23 AM

Sure it works fine on 3.6.8 and PL1. I am using it and have been for quite awhile.

lairnoc

10-19-2007 10:18 AM

ok installed it. nou hope it will do its job :P

pitzerwm

10-19-2007 04:17 PM

First, Thanks for taking the time and energy to write this mod. It really provides a needed service.

I don't know if this is functioning right and/or I have it set up right.

I set it email people that hadn't been there in 15 days, 30 days between emails and 10 at a time. I set the schedule for Monday night at 1, looking at the log, on Monday night it started sending the emails and sent about 60 of them, 10 at a time, but then every minute or so, for hours it "cycled" and reported "no emails sent". Although a couple of times during that 22 hour time frame it would send 1 email out.

Is this the way it works? Is it working its way through the members 10 at a time, every minute or so? I have about 400 members.

Thanks

Zia	10-23-2007 05:07 AM

where to download v1.2 .

---
we are on v 1.11-- i just want to be sure its working-
in schedule task log its showing - No emails to send

any one can pls help me out

jags2ooo

10-31-2007 09:50 AM

I get a error when i attempt to run the task.

Fatal error: Maximum execution time of 30 seconds exceeded in /home2/ZZZZZ/public_html/XXXXXX/forums/includes/class_core.php on line 660

Overall Great mod i couldn't have gotten this in a better time.. 60k + users 13k active >.<

birdie

11-04-2007 02:10 AM

Installed 1.1.1 and set it up and got this error when went to scheduled tasks and hit run now:

Quote:

Inactive User Reminder Emails
Found 3927 Inactive Users.
Sent To: <removed name>

Fatal error: Call to a member function on a non-object in /home/po/pod/<forum name>/public/www/<forum name>/includes/class_mail.php(266) : eval()'d code on line 12

Anyone know what it means. I do note the previous posts re 1.1.1 v 1.09 ...

Phongvanlau

11-04-2007 04:44 AM

Hi,

Sorry to ask this kind of question here, please fogive me, I am new to all of this. Do have have to change this $bbtitle, $homeurl, $forumurl/login.php?do=lostpw to anything.

walidaly

11-04-2007 06:07 AM

thanks for the hack
please do not use short php tags <? instead use the default <?php
thanks again ;)

shepherdblake

11-06-2007 12:00 AM

I have this installed on vbulletin 2.6.8 SP1. It runs fine (even manually), but doesn't actually send an email.

My scheduled task log looks like this:

658 Inactive User Reminder Emails 18:48, 5th Nov 2007 Emails sent to:John Hartsel . We tried to email the following users, but their email address was invalid:

that is my test user and I know I have his email address correct. that email account is able to receive other emails from the board.

How can I start troubleshooting this?

thanks!

brvheart

11-06-2007 01:55 AM

I get the below as well on 3.6.8, I have tried both versions....can someone help me please?

Quote:

Originally Posted by Greivog View Post
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.

brvheart

11-07-2007 12:08 PM

Anyone?? This is a great mod, very useful...if I could just get it to work...

mask31

11-12-2007 12:30 PM

hi, on the email body, how do we skip lines?

when i receive the email everything is on one line, there's no line break. how do we do that?

thanks for your help

djbaxter

11-12-2007 12:52 PM

Quote:

Originally Posted by mask31 (Post 1380962)

hi, on the email body, how do we skip lines?

when i receive the email everything is on one line, there's no line break. how do we do that?

thanks for your help

Use <p> and <br> or <br /> tags to separate paragraphs and insert line breaks respectively - standard HTML.

Here's a sample:

Code:

Hello, $username!



<p>You are receiving this email because you previously registered at {name of forum} 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://{your forum URL}/login.php?do=lostpw">http://{your forum URL}/login.php?do=lostpw</a>.</p>



<p>You can now keep up to date with new topics at $bbtitle by subscribing to the Forum Newsletter. Click on your UserCP link (<a href="http://{your forum URL}/usercp.php">http://{your forum URL}/usercp</a>) in the top navigation bar of any forum page and select Edit Options ( <a href="http://{your forum URL}/profile.php?do=editoptions">http://{your forum URL}/profile.php?do=editoptions</a> ). Then scroll down to the Messaging & Notification section and check the box next to Subscribe to Forum Newsletter.</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://{your forum URL}/profile.php?do=editoptions">http://{your forum URL}/profile.php?do=editoptions</a> and uncheck the box next to Receive Email from Administrators.</p>



<p>Administrator<br>

<a href="http://{your forum URL}">Name of Your Forum</a><br>

http://{your forum URL}</p>

mask31

11-12-2007 01:26 PM

thanks mate :)

brvheart

11-17-2007 08:11 PM

Quote:

Originally Posted by brvheart (Post 1376716)

I get the below as well on 3.6.8, I have tried both versions....can someone help me please?

Anyone help me on 3.6.8 please?

djbaxter

11-17-2007 08:34 PM

Quote:

Originally Posted by brvheart (Post 1384596)

Anyone help me on 3.6.8 please?

What happens when you try to install and/or run it? If you're getting an error message, what does it say?

brvheart

11-17-2007 08:59 PM

sorry, I posted it, and forgot to reference it:

https://vborg.vbsupport.ru/showpost....&postcount=945

Quote:

djbaxter

11-17-2007 09:05 PM

You get all that? When? When you try to install it?

brvheart

11-17-2007 09:11 PM

When I run the cron job, that is what it shows...

And no emails are sent....

brvheart

11-19-2007 01:16 AM

fixed, well the jiberish cron page that I was getting, the email still has not sent to the test user even though it said it did

in reminderemail.php find (first line at top:

PHP Code:

<?

Change to:

PHP Code:


		
			
<?php

djbaxter

11-19-2007 01:25 AM

I'll be damned. Sharp eyes!

By the way, my apologies. I wasn't ignoring you - I didn't get a notification that you had replied to my last question. Strange, because I got the notification for your latest post. :confused:

brvheart

11-19-2007 01:42 AM

no worries :)

And it did send the email, jsut delayed, all works perfect now!!! Clicking installed :)

You might want to update the zip file ;)

djbaxter

11-19-2007 02:00 AM

Only Chris can do that but I'll add them as attachments here.

Additionally, if you use the great EZBounce add-on for invalid (bounced) emails, you will find the lines to add the EZBounce headers in the attached remindermail.php files, commented out and ready for uncommenting at lines 51-54:

Code:

// add EZBounce headers - uncomment the following if you use EZBounce

//                        $bounceurl                = $vbulletin->options['ezb_admincpurl'] . "/ezbounce.php?u=" . $userid;

//                        $bouncestring        = "<a href=\"$bounceurl\" target=\"_blank\">$bounceurl</a>";

//                        $headers .= 'X-EZbouncer: ' . $bouncestring . $delimiter;

Please note that I have uploaded the files for version 1.09 and 1.11. Before uploading these to your ./includes/cron/ folder, make sure you rename the file to simply remindermail.php for the version you have installed.

popowich

11-19-2007 10:07 AM

Quote:

From: Discuss New York <"Discuss New York"@mail.wnypoker.com>,
Discuss New York Reminder Service <fake-for-this-post@discussny.com>
To: fake-for-this-post@discussny.com
Subject: Inactive User Reminder Email Report

Hello,

I am getting duplicate from: links. Other e-mails directly from my server are OK. I have two sites with this product and only one of them has this behavior. For the Discuss New York it puts the title of my site @ the name of the mail server (it's tagged to my first domain). It's not like I'm trying to reply, but I'd like to know where it is looking or if it's on my end how to fix this. I'm also wondering if they are going out to inactive members that way or if it's just my report.

-Raymond

BadgerDog

11-19-2007 10:28 AM

Quote:

Originally Posted by djbaxter (Post 1385279)

I'll be damned. Sharp eyes!

I'm a little confused.... :confused:

I'm running v1.09 without any problems on v3.6.7pl1 of vBulletin....

My reminder.php says this on top two lines:

Code:

<?

if (!is_object($vbulletin->db))

Should I be changing it to:

Code:

<?php

if (!is_object($vbulletin->db))

Thanks ... :)

Regards,
Badger

All times are GMT. The time now is 08:09 AM.

Page 24 of 36

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02730 seconds Memory Usage 1,914KB 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 (6)bbcode_code_printable (2)bbcode_php_printable (20)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
Messages: