'.
t('!title will expire on !date
that is in !daysleft.', array(
'!title' => $node->title,
'!date' => format_date($expire),
'!daysleft' => format_interval($expire - time()))
) .
'
'. t('!title has expired on !date.', array( '!title' => $node->title, '!date' => format_date($expire)) ) . '
', ); } if (time() > $expire - ($warn * 24 * 60 * 60)) { $days = variable_get($code .'_d', AUTO_EXPIRE_DAYS); $form['extendby'] = array( '#value' => ''. format_plural($days, 'You can extend it with 1 day.', 'You can extend it with @count days.') . '
', ); $form['extend'] = array( '#type' => 'submit', '#value' => t('Extend'), '#submit' => array('_auto_expire_expiry_submit'), ); } else { $form['extendwhen'] = array( '#value' => ''. format_plural($warn, 'You will be able to extend this 24 hours before the expiry time.', 'You will be able to extend this @count days before the expiry time.') . ' '. t('You will receive an email notification at that time.') . '
', ); } return $form; } function _auto_expire_expiry_submit($form, &$form_state) { $node = node_load($form_state['values']['nid']); $expire = $form_state['values']['expire']; $days = variable_get(AUTO_EXPIRE_NODE_TYPE . $node->type .'_d', AUTO_EXPIRE_DAYS); $newexpire = max(time(), $expire) + $days * 24 * 60 * 60; db_query('UPDATE {auto_expire} SET expire = %d, extended = extended + 1, warned = 0 WHERE nid = %d', $newexpire, $node->nid); db_query('UPDATE {node} SET status = 1 WHERE nid = %d', $node->nid); watchdog('auto_expire', "Extended node %node by @days days", array('%node' => $node->nid, '@days' => $days), WATCHDOG_NOTICE, l(t('view'), 'node/'.$node->nid)); drupal_set_message(t('Extended for !days more days', array('!days' => $days))); $form_state['redirect'] = "node/$node->nid/expiry"; } function _auto_expire_admin_settings() { $form = array(); foreach (node_get_types() as $type => $name) { $code = AUTO_EXPIRE_NODE_TYPE . $type; $form['nodetypes'][$type] = array( '#type' => 'fieldset', '#title' => $name->name, '#collapsible' => TRUE, '#collapsed' => ! variable_get($code .'_e', 0), ); $form['nodetypes'][$type][$code .'_e'] = array( '#type' => 'checkbox', '#title' => t('Expire'), '#return_value' => 1, '#default_value' => variable_get($code .'_e', 0), ); $form['nodetypes'][$type][$code .'_d'] = array( '#type' => 'textfield', '#title' => t('Days'), '#field_suffix' => t('days'), '#return_value' => 1, '#default_value' => variable_get($code .'_d', AUTO_EXPIRE_DAYS), '#description' => t('Number of days after an item was created when it will be automatically expired.'), ); $form['nodetypes'][$type][$code .'_w'] = array( '#type' => 'textfield', '#title' => t('Warn'), '#field_suffix' => t('days'), '#return_value' => 1, '#default_value' => variable_get($code .'_w', AUTO_EXPIRE_WARN), '#description' => t('Number of days before the items expiration when a warning message is sent to the user. Set to 0 (zero) for no warnings.'), ); $form['nodetypes'][$type][$code .'_p'] = array( '#type' => 'textfield', '#title' => t('Purge'), '#field_suffix' => t('days'), '#return_value' => 1, '#default_value' => variable_get($code .'_p', AUTO_EXPIRE_PURGE), '#description' => t('Number of days after an item has expired when it will be purged from the database. Set to 0 (zero) for no purge.'), ); } $form['email']['warn'] = array( '#type' => 'fieldset', '#title' => t('Expiration Warning Notification Email'), '#collapsible' => TRUE, '#collapsed' => FALSE, '#description' => t("Template of email sent when content is about to expire. You can use the following variables: !type - content type, !title - title of content, !url - URL of content, !days - number of days before items expire, !date - the expiration date of the item, !daysleft - time left until the expiration date, !site - site name, !siteurl - site URL"), ); $form['email']['warn'][AUTO_EXPIRE_EMAIL .'warn_subject'] = array( '#type' => 'textfield', '#title' => t('Email Subject'), '#description' => t('Leave empty to disable Expiration Warning Notifications.'), '#return_value' => 1, '#default_value' => variable_get(AUTO_EXPIRE_EMAIL .'warn_subject', t('!type about to expire')), ); $form['email']['warn'][AUTO_EXPIRE_EMAIL .'warn_body'] = array( '#type' => 'textarea', '#title' => t('Email Body'), '#return_value' => 1, '#default_value' => variable_get(AUTO_EXPIRE_EMAIL .'warn_body', t("Your !type listing '!title' will expire in !daysleft.\n\nPlease visit !site if you want to renew:\n!url")), ); $form['email']['expired'] = array( '#type' => 'fieldset', '#title' => t('Expired Notification Email'), '#collapsible' => TRUE, '#collapsed' => FALSE, '#description' => t("Template of email sent right after the content has expired. You can use the following variables: !type - content type, !title - title of content, !url - URL of content, !days - number of days before items expire, !date - the expiration date of the item, !site - site name, !siteurl - site URL"), ); $form['email']['expired'][AUTO_EXPIRE_EMAIL .'expired_subject'] = array( '#type' => 'textfield', '#title' => t('Email Subject'), '#description' => t('Leave empty to disable Expired Notifications.'), '#return_value' => 1, '#default_value' => variable_get(AUTO_EXPIRE_EMAIL .'expired_subject', t('!type has expired')), ); $form['email']['expired'][AUTO_EXPIRE_EMAIL .'expired_body'] = array( '#type' => 'textarea', '#title' => t('Email Body'), '#return_value' => 1, '#default_value' => variable_get(AUTO_EXPIRE_EMAIL .'expired_body', t("Your !type listing '!title' has expired.\n\nPlease visit !site to add new content:\n!siteurl")), ); $form['email']['cc'][AUTO_EXPIRE_EMAIL .'bcc'] = array( '#type' => 'textfield', '#title' => t('BCC Address'), '#description' => t('An e-mail address to blind carbon copy notifications.'), '#return_value' => 1, '#default_value' => variable_get(AUTO_EXPIRE_EMAIL .'bcc', ''), ); return system_settings_form($form); } /** * Implementation of hook_cron(). */ function auto_expire_cron() { foreach (node_get_types() as $type => $name) { $code = AUTO_EXPIRE_NODE_TYPE . $type; if (variable_get($code .'_e', 0)) { $days = variable_get($code .'_d', AUTO_EXPIRE_DAYS); $warn = variable_get($code .'_w', AUTO_EXPIRE_WARN); $purge = variable_get($code .'_p', AUTO_EXPIRE_PURGE); // Send out expiration warnings. if ($warn > 0) { $subject = variable_get(AUTO_EXPIRE_EMAIL .'warn_subject', ''); $body = variable_get(AUTO_EXPIRE_EMAIL .'warn_body', ''); switch ($GLOBALS['db_type']) { case 'mysql': case 'mysqli': $result = db_query('SELECT n.nid, n.title FROM {auto_expire} e, {node} n WHERE n.nid = e.nid AND n.status = 1 AND e.warned = 0 AND (FROM_UNIXTIME(e.expire) - INTERVAL %d DAY) <= NOW()', $warn); break; case 'pgsql': $result = db_query('SELECT n.nid, n.title FROM {auto_expire} e, {node} n WHERE n.nid = e.nid AND n.status = 1 AND e.warned = 0 AND ((e.expire::ABSTIME::TIMESTAMP) - INTERVAL \'%d DAYS\') <= NOW()', $warn); break; } while ($node = db_fetch_object($result)) { _auto_expire_notify_warning($node->nid, $node->title, $name->name, $days, $subject, $body); db_query('UPDATE {auto_expire} SET warned = 1 WHERE nid = %d', $node->nid); watchdog('auto_expire', 'Auto expire warning for node %node', array('%node' => $node->nid), WATCHDOG_NOTICE, l(t('view'), 'node/'.$node->nid)); } } // Expire $subject = variable_get(AUTO_EXPIRE_EMAIL .'expired_subject', ''); $body = variable_get(AUTO_EXPIRE_EMAIL .'expired_body', ''); switch ($GLOBALS['db_type']) { case 'mysql': case 'mysqli': $result = db_query('SELECT n.nid, n.title FROM {auto_expire} e, {node} n WHERE n.nid = e.nid AND n.status = 1 AND FROM_UNIXTIME(e.expire) <= NOW()'); break; case 'pgsql': $result = db_query('SELECT n.nid, n.title FROM {auto_expire} e, {node} n WHERE n.nid = e.nid AND n.status = 1 AND (e.expire::ABSTIME::TIMESTAMP) <= NOW()'); break; } while ($node = db_fetch_object($result)) { db_query('UPDATE {node} SET status = 0 WHERE nid = %d', $node->nid); _auto_expire_notify_expired($node->nid, $node->title, $name->name, $days, $subject, $body); watchdog('auto_expire', 'Unpublishing node %node', array('%node' => $node->nid), WATCHDOG_NOTICE, l(t('view'), 'node/'.$node->nid)); } // Purge if ($purge > 0) { switch ($GLOBALS['db_type']) { case 'mysql': case 'mysqli': $result = db_query('SELECT e.nid FROM {auto_expire} e, {node} n WHERE n.nid = e.nid AND n.status = 0 AND (FROM_UNIXTIME(e.expire) + INTERVAL %d DAY) <= NOW()', $purge); break; case 'pgsql': $result = db_query('SELECT e.nid FROM {auto_expire} e, {node} n WHERE n.nid = e.nid AND n.status = 0 AND ((e.expire::ABSTIME::TIMESTAMP) + INTERVAL \'%d DAYS\') <= NOW()', $purge); break; } $count_purged = 0; while ($nid = db_result($result)) { $node = node_load($nid); /* copied from node_delete - to bypass node_access - cache_clear_all moved outside the loop */ db_query('DELETE FROM {node} WHERE nid = %d', $nid); db_query('DELETE FROM {node_revisions} WHERE nid = %d', $nid); // Call the node-specific callback (if any): node_invoke($node, 'delete'); node_invoke_nodeapi($node, 'delete'); // Remove this node from the search index if needed. if (function_exists('search_wipe')) { search_wipe($nid, 'node'); } /* end of copy */ watchdog('auto_expire', "Auto expire purged node: %node", array('%node' => $nid), WATCHDOG_NOTICE); $count_purged++; } if ($count_purged > 0) { // Clear the cache so an anonymous poster can see the node being deleted. cache_clear_all(); watchdog('auto_expire', "Auto expire purged %num_purged node(s).", array('%num_purged' => $count_purged), WATCHDOG_NOTICE); } } } } } /** * Implementation of hook_nodeapi(). */ function auto_expire_nodeapi(&$node, $op, $a3 = NULL, $a4 = NULL) { $code = AUTO_EXPIRE_NODE_TYPE . $node->type; if (variable_get($code .'_e', 0)) { switch ($op) { case 'insert': $days = variable_get($code .'_d', 0); db_query('INSERT INTO {auto_expire} (nid, expire) VALUES (%d, %d)', $node->nid, $node->created + $days * 24 * 60 * 60); drupal_set_message(t('This %type will autoexpire in %days days.', array('%type' => node_get_types('name', $node), '%days' => $days))); break; case 'delete': db_query('DELETE FROM {auto_expire} WHERE nid = %d', $node->nid); break; case 'load': $expire = _auto_expire_get_expire($node->nid); $output['auto_expire'] = array( 'timestamp' => $expire, 'date' => format_date($expire), ); return $output; } } } /** * Implementation of hook_node_type(). */ function auto_expire_node_type($op, $info) { switch ($op) { case 'delete': $code = AUTO_EXPIRE_NODE_TYPE . $info->type; variable_del($code .'_e'); variable_del($code .'_d'); variable_del($code .'_w'); variable_del($code .'_p'); break; case 'update': if (!empty($info->old_type) && $info->old_type != $info->type) { $code_old = AUTO_EXPIRE_NODE_TYPE . $info->old_type; $code_new = AUTO_EXPIRE_NODE_TYPE . $info->type; $expire = variable_get($code_old .'_e', 0); $days = variable_get($code_old .'_d', AUTO_EXPIRE_DAYS); $warn = variable_get($code_old .'_w', AUTO_EXPIRE_WARN); $purge = variable_get($code_old .'_p', AUTO_EXPIRE_PURGE); variable_set($code_new .'_e', $expire); variable_set($code_new .'_d', $days); variable_set($code_new .'_w', $warn); variable_set($code_new .'_p', $purge); variable_del($code_old .'_e'); variable_del($code_old .'_d'); variable_del($code_old .'_w'); variable_del($code_old .'_p'); } break; } } function _auto_expire_notify_warning($nid, $title, $type, $days, $subject, $body) { $args = array( '!type' => $type, '!title' => $title, '!url' => url('node/'. $nid, array('absolute' => TRUE)), '!days' => $days, '!date' => format_date(_auto_expire_get_expire($nid)), '!daysleft' => format_interval(_auto_expire_get_expire($nid) - time()), '!site' => variable_get('site_name', ''), '!siteurl' => url('