$now = time(); $max_date = "date_sub(now(), interval 15 minute)"; $min_date = "date_sub(now(), interval 24 hour)"; echo "STARTING delete non validated users\n"; // Delete not validated users $db->query("delete from users where user_date < date_sub(now(), interval 12 hour) and user_date > date_sub(now(), interval 24 hour) and user_validated_date is null"); echo "STARTING delete old bad links\n"; // Delete old bad links $minutes = intval($globals['draft_time'] / 60); $ids = $db->get_col("select link_id from links where link_status='discard' and link_date > date_sub(now(), interval 24 hour) and link_date < date_sub(now(), interval {$minutes} minute) and link_votes = 0 order by link_id asc"); if ($ids) { $ids_str = implode(',', $ids); echo "Deleting {$ids_str}\n"; $db->query("delete from links where link_id in ({$ids_str})"); } $sites = SitesMgr::get_active_sites(); foreach ($sites as $site) { echo "START SITE: {$site}\n"; SitesMgr::__init($site); $site_info = SitesMgr::get_info($site_id); if ($site_info->owner == 0) { // Only depublish in main subs depublish($site); } if ($site_info->sub) { // Only discard in the subs discard($site); } } punish_comments(); // END