Universal Cron Job Clean up (collective work from vb.org programmers)

[tnguy3n]

However, you can work around to avoid these mysql errors, i think.

this vbcronjob would delete and clean up all article, posts, subscriptions, and stuffs related to the users who have 0 posts. It's configurable btw.

PHP Code:

<?php

error_reporting(E_ALL & ~E_NOTICE);

if (!is_object($DB_site))
{
    exit;
}

// ############## cronjob settings ##############
$vbarticle = 'yes'; // delete users articles
$vbjournal = 'yes'; // delete users journal
$photopost = 'yes';
$lastactivity = '30'; // days since the user last visited forums
$totalpost = '0'; // delete users that has XX or less than XX post

// ############## start main script ##############
// no longer editting necessary below this

$getusers = $DB_site->query("
    SELECT * FROM " . TABLE_PREFIX . "user
    WHERE posts <= '" . $totalpost . "'
    AND lastactivity <= '" . intval(TIMENOW - ($lastactivity * 86400)) . "'
");

while ($users = $DB_site->fetch_array($getusers))
{
    $userid = $users['userid'];

    // clean all subscription, log, text, info of the user
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "user WHERE userid=$userid"); flush();
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "userfield WHERE userid=$userid"); flush();
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "usertextfield WHERE userid=$userid"); flush();
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "subscribeforum WHERE userid=$userid"); flush();
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "subscribethread WHERE userid=$userid"); flush();
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "event WHERE userid=$userid"); flush();
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "customavatar WHERE userid=$userid");
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "access WHERE userid=$userid"); flush();
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "pm WHERE userid=$userid"); 
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "pmreceipt WHERE userid=$userid"); flush();
    $DB_site->query("DELETE FROM " . TABLE_PREFIX . "session WHERE userid=$userid"); flush();
    if($vbarticle == 'yes'){$DB_site->query("DELETE FROM " . TABLE_PREFIX . "vbarticle WHERE userid=$userid");}
    if($vbjournal == 'yes'){$DB_site->query("DELETE FROM " . TABLE_PREFIX . "journal WHERE userid=$userid");}
    if($photopost == 'yes'){$DB_site->query("DELETE FROM " . TABLE_PREFIX . "photopost WHERE userid=$userid");}

}

// log actions
log_cron_action('Universal Cronjob Cleanup.', $nextitem);

?>

you can add email feature to email users before delete them as you like. You can read more of this thread, https://vborg.vbsupport.ru/showthrea...threadid=75740 for ref.