Forgot I Registered Hack

[SamirDarji]

We all have numerous forums we've all registered on. But how many do we actually visit? How many have we forgotten about? Not that they weren't good, but we just never had anything to post at the time. Could your forum be forgotten?

How about a hack that emails users that haven't visited in X number of days a default email that could be changed. I've searched for something like this, but mainly all I found was the auto-prune users hacks. I think a lot of those users just forgot they registered.

[Andreas]

I've released a Hack for vBulletin 3.5 that does that (although it was originally meant to prune inactive Users).
But you can use it just as a reminder too if you set the time between notification and deletion very high (eg. won't ever happen).

[Thug]

anything like this for
3.0.7

[G0F0RBR0KE]

Yea, is there a version for 3.0.0 and up

[SamirDarji]

Originally Posted by KirbyDE

I've released a Hack for vBulletin 3.5 that does that (although it was originally meant to prune inactive Users).
But you can use it just as a reminder too if you set the time between notification and deletion very high (eg. won't ever happen).

Not a bad system. As others are asking, how hard would it be to port it to vb3? What about just porting the part that does the reminder email rather than the whole pruning thing?

[Adrian Schneider]

Samir, do you just want it to email users after being inactive for X ammount of days?

I wrote this up pretty quickly, so let me know how it works.
Add it to your scheduled tasks, and only have it run once a day.

PHP Code:

<?php

// #############################################################################
// Email Inactive Users
// #############################################################################

error_reporting(E_ALL & ~E_NOTICE);

// Ensure Connection
if (!is_object($DB_site))
{
    exit;
}

$days = 30;
$time = time();
$xdaysago = $time - ((86400 * ($days - 1));
$ydaysago = $time - (86400 * $days);  

$users = $DB_site->query("
    SELECT userid, username, lastactivity, email
    FROM " . TABLE_PREFIX . "user
    WHERE lastactivity < " . $xdaysago . " AND lastactivity > " . $ydaysago . "
");

while ($user = $DB_site->fetch_array($users))
{
    $message = 'Hello ' . $user['username'] . ', ';
    $message .= "We have noticed that you havn't visited our board in over " . $days . " days.\n";
    $message .= "You may ignore this email, consider it a friendly reminder that you have ";
    $message .= "registered at our board.\n";
    $message .= "Thank you,\n";
    $message .= $vboptions['bbtitle'] . "\n";
    $message .= $vboptions['homeurl'];
    
    vbmail($user['email'], 'Inactivity Notice', $message, true);
    echo "Inactivity email successfully sent to  " . $user['username'] . ".<br />";
}



?>

[Thug]

i got this error on that

PHP Code:


Parse error: parse error, unexpected ';' in /home/ohtwadi/public_html/forum/includes/cron/reminder.php on line 18 


what do i add for this

PHP Code:

line 18

$time = time(); 


also how do i make it email users who have been inactive for 10days and how do i set it to run once a day

[Adrian Schneider]

I fixed the script above.
change the $xdaysago = and $ydaysago = lines to:

PHP Code:

$xdaysago = $time - ((86400 * ($days - 1));
$ydaysago = $time - (86400 * $days); 


to change the days before emailing them, change this line

PHP Code:

$days = 30; 


Call it something like cron_emailinactiveusers.php and place it in ./includes/cron/, then under scheduled tasks add the file.

[Fallback]

Originally Posted by SirAdrian

I fixed the script above.
change the $xdaysago = and $ydaysago = lines to:

PHP Code:

$xdaysago = $time - ((86400 * ($days - 1));
$ydaysago = $time - (86400 * $days); 


I actually had to change that to the following... to get it to work...

PHP Code:

$xdaysago = $time - (86400 * ($days - 1));
$ydaysago = $time - (86400 * $days); 


[Thug]

i did this i ran it worked fine but only emailed abt 8ppl and the ppl it mailed r active anway
how do i get it to email all those who havent been active for 1day since there last post