function seotools_cache_set in Drupal SEO Tools 6

Same name and namespace in other branches

1. 7 seotools.report.inc \seotools_cache_set()

5 calls to seotools_cache_set()

seotools_dashboard_analytics_box in ./seotools.report.inc

seotools_dashboard_map_box in ./seotools.report.inc

seotools_dashboard_referrers_box in ./seotools.report.inc

seotools_dashboard_sources_box in ./seotools.report.inc

seotools_generate_report_top_and_trends in ./seotools.report.inc

valid ids: keywords

File

./seotools.report.inc, line 318

Code

function seotools_cache_set($cid, $data, $date_range = NULL) {
  $where = "cid = '%s'";
  $args[] = $cid;
  if ($date_range['start_date']) {
    $fields .= ", start_date";
    $values .= ", '%s'";
    $where .= " AND start_date = '%s'";
    $args[] = $date_range['start_date'];
  }
  if ($date_range['end_date']) {
    $fields .= ", end_date";
    $values .= ", '%s'";
    $where .= " AND end_date = '%s'";
    $args[] = $date_range['end_date'];
  }
  $sql = "\n    DELETE FROM {seotools_cache}\n    WHERE {$where}\n  ";
  db_query($sql, $args);
  if (is_array($data)) {
    $fields .= ", records";
    $values .= ", %d";
    $args[] = count($data);
  }
  $args[] = serialize($data);
  $sql = "\n    INSERT INTO {seotools_cache}\n    (cid{$fields}, data)\n    VALUES\n    ('%s'{$values},'%s')\n  ";
  db_query($sql, $args);
  return TRUE;
}