private function InstapageCmsPluginWPConnector::getTermSlugs in Instapage plugin 8.3

Same name and namespace in other branches

1. 7.3 core/connectors/InstapageCmsPluginWPConnector.php \InstapageCmsPluginWPConnector::getTermSlugs()

Gets the list of slugs used by WP terms.

Return value

array List of slugs used by terms.

1 call to InstapageCmsPluginWPConnector::getTermSlugs()

InstapageCmsPluginWPConnector::getProhibitedSlugs in core/connectors/InstapageCmsPluginWPConnector.php

get list of slugs that can't be used to publish a landing page.

File

core/connectors/InstapageCmsPluginWPConnector.php, line 1009

Class

InstapageCmsPluginWPConnector

Class that utilizes native WordPress functions to perform actions like remote requests and DB operations.

Code

private function getTermSlugs() {
  $editUrl1 = $this
    ->getSiteURL() . '/wp-admin/edit-tags.php?action=edit&post_type=post&taxonomy=';
  $editUrl2 = '&tag_ID=';
  $dbPrefix = $this
    ->getDBPrefix();
  $sql = 'SELECT t.term_id AS id, t.slug AS slug, CONCAT(\'' . $editUrl1 . '\', tt.taxonomy, \'' . $editUrl2 . '\', t.term_id) AS editUrl ' . 'FROM ' . $dbPrefix . 'terms t LEFT JOIN ' . $dbPrefix . 'term_taxonomy tt ON t.term_id = tt.term_id ' . 'WHERE (tt.taxonomy = \'category\' OR tt.taxonomy = \'post_tag\')' . 'AND t.slug <> \'\'';
  $results = $this
    ->getResults($sql);
  return $results;
}