function node_limit_interval_node_limit_sql in Node Limit 6

Same name and namespace in other branches

1. 8 old/node_limit_interval/node_limit_interval.module \node_limit_interval_node_limit_sql()
2. 7 node_limit_interval/node_limit_interval.module \node_limit_interval_node_limit_sql()

Implementation of hook_node_limit_sql().

File

node_limit_interval/node_limit_interval.module, line 30

Module to restrict the number of nodes within a time interval.

Code

function node_limit_interval_node_limit_sql($lid) {
  $limit = node_limit_interval_node_limit_load($lid);
  if (empty($limit)) {
    return array();
  }
  if ($limit['node_limit_interval'] != NODE_LIMIT_INTERVAL_MONTHS) {
    $interval = floatval($limit['node_limit_interval']['ninterval']) * intval($limit['node_limit_interval']['unit']);
  }
  else {
    $then = mktime(date('H'), date('i'), date('s'), date('n') - floatval($limit['node_limit_interval']['ninterval']));
    $now = mktime();
    $interval = $now - $then;
  }
  return array(
    'where' => array(
      sprintf('n.created + %d >= %d', $interval, time()),
    ),
  );
}