Forgot I Registered Hack

[SamirDarji]

Originally Posted by SirAdrian

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 />";
}



?>

Wow, I didn't expect so quick a reply! Too bad I'm in the middle of changing hosts, and it's a nightmare. My site's down because I have to keep it closed to keep email stuff straight. You might as well release this as a hack. I'm sure others will want to use it.

[o0Hubba0o]

Originally Posted by 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

Who haven't been active for 1 day! Man what a pushy admin! Heh j/k with you, but it is an extremely short time lol.


Thanks for asking for this hack though, this will come in very handy, and thanks for making one up for him too.


Also scroll back up to "Fallens" post, there's still that extra "(" in the script.

[Thug]

mine neva shows in task log,how do i no if its working

[SamirDarji]

Can this be ported to 3.5 or is there already one available? I'm looking to add newer hacks to 3.5 since they'd all be plug-ins, but I'm still waiting for all my currently used hacks to go to 3.5.