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

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)

Hello,

Code:

This email shows that the product is installed and working as it should be. There were no inactive users at this time.

But 2 weeks ,no email send. why?
What i do?

Uninstalled this mod, because after removal of the Footer addition, which showed ad links to other Sites (no copyright) , the mod began to cause problems with Profile of the Bpard (memberprofile).

Can you please try to disable the footer addition and make it working anyway?
Would be nice.

Quote:

I must insist that anyone pre 1.1.2 upgrades asap.

Why do you say this as the one I have works just fine and no need to upgrade to the latest one. Works perfect and no problems

sweet, ill give it a whirl

thaniks for this, is installed now i will test it.

you will upgrade this to 3.8??

Thank You.Great Mod.

Thanks.Tried And Installed Later :)

I would love to see this for 3.8 and eventually 4.0. :)

Quote:

Originally Posted by Jedric (Post 1749376)

I would love to see this for 3.8 and eventually 4.0. :)

Any one tested on 3.8.x :eek:

Hi,
excuse me for my bad english...

the cron report me an error for mysql_num_rows if use in config mysqli

the error solved with this code.

PHP Code:


		
			
    // Patched by u Killer Bestia
    if($vbulletin->config['Database']['dbtype']=='mysqli' OR $vbulletin->config['Database']['dbtype']=='mysqli_slave')
        $usercount = mysqli_num_rows($result);
    else
        $usercount = mysql_num_rows($result);
        
    // End Patch
        
    print("Found " . $usercount . " Inactive Users.<br/><br/>");

line 44 in file remindermail.php in cron folder.

tnx

I dont think this works with 3.8? No emails getting sent out ... does this work for anyone on 3.8?

Request for 3.8 version! Please I love this mod ... but it stopped working when I upgraded.

im using 3.8.1pl1, works fine

i got a request tho, have a way to set it to NOT email me each night, all i need is 1 email to know it is working, then after that i dont need any, gets annoying

works fine for me vb3.8.1pl1.

would like to repeat the above poster's request to be able to turn off e-mails nightly. a log file or report file accessible through admincp (like the vbseo sitemap generator reports) would be just as accessible and much less annoying.

By me, dont works on Version: 3.8.1 Patch Level 1 :-(

regards

Thanks again! Works great on VB 3.8.1PL1.

Mark

Do you know where can I edit the email template?
Or do I have to use this along with the previous mod?

Hello Everyone. I installed this MOD and it's great.

A few pointers

1. Works absolutely perfectly with VB 3.8.1 PL1
2. For those who are complaining about the author's links, there is an option in AdminCP where you can turn links off..
3. You can make this MOD to send emails through the webmaster's email instead of the site's mail address. This is what you need to do.

Open remindermail.php in any editor.

Find the following CODE

Code:

if(is_valid_email($toemail)){                                

        $sentlist .= "$username ";

        vbmail($toemail, $subject, $message, $notsubscription = false, $from = $vbulletin->options['bbtitle'], $uheaders = '', $username = '');

Replace it by

Code:

if(is_valid_email($toemail)){                                

        $sentlist .= "$username ";

        vbmail($toemail, $subject, $message, $notsubscription = false, $from = $vbulletin->options['webmasteremail'], $uheaders = '', $username = '');

So basically instead of $from = $vbulletin->options['bbtitle'], you have to use $from = $vbulletin->options['webmasteremail']. This will sent email from the Webmaster's email address instead of the site/host email.

4. Some people were bothered by the daily mails it sends to the webmaster when it has mailed the inactive users. To prevent this MOD from emailing the webmaster every time, again open remindermail.php.

There at the end you will find an if-else condition:

Code:

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 = '');

        }

In the code above you have to comment out the vbmail function. So replace above code by

Code:

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 = '');*/

        }

You can still see whom the MOD has emailed by going to AdminCP-->Scheduled Task-->Scheduled Task Log and selecting "Inactive User reminder Emails" from the drop down, since this MOD still is logging.

Hope this helps out everyone.

Cheers :)

Does anyone have this working on vB 3.8.2?

Update...

Installed and seems to be working fine on vB 3.8.2.

There's some knowed incompatibility with Cron based Email sending?
https://vborg.vbsupport.ru/showthread.php?t=201318

Nobody support this hack?

I check from time to tiime but I don't offer support anymore since there are already known new versions of this mod.

I was making a new stable version but got sidetracked by my VB --> WP bridge. If someone offers to help me out with this mod I'm open for help.

Robert-Jan de Dreu

What new versions are out there? Where do I find them?

After Install I get the following problem via mail:

-------------------

Database error in vBulletin 3.8.2:

Invalid SQL:
SELECT * FROM user WHERE lastactivity < '0' AND reminder_reminders = 0 AND options & 16 AND usergroupid IN('');

MySQL Error : Unknown column 'reminder_reminders' in 'where clause'
Error Number : 1054
Request Date : Monday, May 4th 2009 @ 04:22:52 PM
Error Date : Monday, May 4th 2009 @ 04:22:52 PM
Script : http://xyz.org/admincp/remindermail.php
Referrer : http://xyz.org/admincp/index.php?do=nav
IP Address : 80.136.94.51
Username : xxxxx
Classname : vB_Database
MySQL Version : 5.0.67-community

-----------------------

Any idea on how to fix that?

I'd like to know about "known new versions" too. This one doesn't seem to work consistently anymore. It worked great for months but I'm thinking the vB versions overtook it, or have all the inactive users tagged us as spam?

anyone know why I am getting this message when an email is trying to be sent to a user?

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

It happens every time, even my own emails.

Quote:

Originally Posted by jejuarez8 (Post 1809903)

Read the thread.

If you see only that phrase, you're fine - it didn't find any invalid addresses. If you see any addresses after that phrase, those users have invalid email addresses and the accounts should be deleted or disabled.

it is possible to send emails to inactive user but in html usin this hack?? On my forum is installed Admin HTML Email hack and does not work with this hack, I'd like to know if ther is a way to send in html

Quote:

Originally Posted by Seb@ (Post 1818254)

not work in 3.8.2

It never worked in 3.7 either.

And it's never been fixed.

So there you go. I got rid of this useless utility long ago.

Peace,
Gene

Quote:

Originally Posted by Gene Steinberg (Post 1818297)

It never worked in 3.7 either.

And it's never been fixed.

So there you go. I got rid of this useless utility long ago.

Peace,
Gene

It works for me just fine in 3.8.2.

Getting this error in 3.8.3
Database error in vBulletin 3.8.3:
Invalid SQL:
SELECT * FROM user WHERE lastactivity < '1250709384' AND emailDate < '1250277384' AND options & 16;

MySQL Error : Unknown column 'emailDate' in 'where clause'
Error Number : 1054
Request Date : Wednesday, August 26th 2009 @ 08:16:24 PM
Error Date : Wednesday, August 26th 2009 @ 08:16:24 PM
Script :/cronadmin.php?do=runcron&cronid=107
Referrer : /cronadmin.php?do=modify
Classname : vB_Database
MySQL Version : 5.0.81-community

tested this in 3.8.3 :up:

will it works on vbulletin 3.8.4

thats interesst me too, will it work on 3.8.4 ?
...maybe answer the creator self

regards

Quote:

Originally Posted by RedPoint (Post 1890969)

thats interesst me too, will it work on 3.8.4 ?
...maybe answer the creator self

regards

It never worked for me in previous versions of vBulletin and the author is apparently not interested in providing meaningful support. I suggest anyone who has managed to make it work should feel lucky.

Peace,
Gene

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01452 seconds Memory Usage 1,833KB 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 (5)bbcode_code_printable (1)bbcode_php_printable (6)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)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
Messages: