function kwresearch_clear_site_keywords in Keyword Research 7

Same name and namespace in other branches

1. 6 kwresearch.module \kwresearch_clear_site_keywords()

Deletes all site keyword db entries if not set as a site keyword or used as a page keyword

File

./kwresearch.module, line 362

Code

function kwresearch_clear_site_keywords() {
  $sql = '
    DELETE FROM {kwresearch_keyword}
    WHERE page_count = 0
      AND (priority IS NULL || priority = 0)
  ';
  db_query($sql);
  drupal_set_message(t('Unused keywords have been cleared.'));
  return t('OK');
}