posts_limit = SQ_Classes_Helpers_Tools::getOption('sq_sitemap_perpage'); add_filter('sq_sitemap_style', array($this, 'getFeedStyle')); add_filter('template_redirect', array($this, 'hookPreventRedirect'), 0); add_filter('user_trailingslashit', array($this, 'untrailingslashit')); add_action('sq_processPing', array($this, 'processCron')); } public function hookPreventRedirect() { global $wp_query; // echo '
' . print_R($_SERVER, true) . '
'; // exit(); if (isset($_SERVER['REQUEST_URI'])) { if (strpos($_SERVER['REQUEST_URI'], 'sq_feed') !== false) { $parseurl = @parse_url($_SERVER['REQUEST_URI']); $sitemap = 'sitemap'; $page = 0; if (isset($parseurl['query'])) { parse_str($parseurl['query'], $query); $sitemap = (isset($query['sq_feed']) ? $query['sq_feed'] : 'sitemap'); $page = (isset($query['page']) ? $query['page'] : 0); } $wp_query->is_404 = false; $wp_query->is_feed = true; $this->feedRequest($sitemap, $page); apply_filters('sq_sitemapxml', $this->showSitemap()); die(); } elseif (strpos($_SERVER['REQUEST_URI'], '.xml') !== false) { $parseurl = @parse_url($_SERVER['REQUEST_URI']); $stemaplist = SQ_Classes_Helpers_Tools::getOption('sq_sitemap'); $page = 0; foreach ($stemaplist as $request => $sitemap) { if (isset($sitemap[0]) && $sitemap[1] && substr($parseurl['path'], (strrpos($parseurl['path'], '/') + 1)) == $sitemap[0]) { $wp_query->is_404 = false; $wp_query->is_feed = true; if (isset($parseurl['query'])) { parse_str($parseurl['query'], $query); $page = (isset($query['page']) ? $query['page'] : 0); } $this->feedRequest($request, $page); apply_filters('sq_sitemapxml', $this->showSitemap()); die(); } } } } } public function refreshSitemap($new_status, $old_status, $post) { if ($old_status <> $new_status && $new_status = 'publish') { if (SQ_Classes_Helpers_Tools::getOption('sq_sitemap_ping')) { wp_schedule_single_event(time() + 5, 'sq_processPing'); } } } /** * Listen the feed call from wordpress * @param string $request * @param integer $page */ public function feedRequest($request = null, $page = 1) { global $sq_query; $sq_query = array(); if (isset($request) && strpos($request, 'sitemap') !== false) { $sq_sitemap = SQ_Classes_Helpers_Tools::getOption('sq_sitemap'); $this->model->type = $request; //reset the previous query wp_reset_query(); if ($request == 'sitemap') { //if sitemapindex, return return; } if ($this->model->type == 'sitemap-news') { $this->posts_limit = $this->news_limit; } remove_all_actions('pre_get_posts'); remove_all_actions('parse_query'); remove_all_actions('posts_where'); //init the query $sq_query = array( 'post_type' => array('post'), 'tax_query' => array(), 'post_status' => 'publish', 'posts_per_page' => $this->posts_limit, 'paged' => $page, 'orderby' => 'date', 'order' => 'DESC', ); //show products if ($this->model->type == 'sitemap-product') { if (SQ_Classes_Helpers_Tools::isEcommerce() && $sq_sitemap[$this->model->type][1] == 2) { $sq_sitemap[$this->model->type][1] = 1; } } if (isset($sq_sitemap[$this->model->type]) && $sq_sitemap[$this->model->type][1]) { add_action('do_feed_' . $this->model->type, array($this, 'showSitemap')); //PREPARE CUSTOM QUERIES switch ($this->model->type) { case 'sitemap-news': case 'sitemap-post': break; case 'sitemap-category': case 'sitemap-post_tag': case 'sitemap-custom-tax': remove_all_filters('terms_clauses'); //prevent language filters add_filter('get_terms_fields', array($this, 'customTaxFilter'), 5, 2); break; case 'sitemap-page': $sq_query['post_type'] = array('page'); break; case 'sitemap-attachment': $sq_query['post_type'] = array('attachment'); $sq_query['post_status'] = array('publish', 'inherit'); break; case 'sitemap-author': add_filter('sq-sitemap-authors', array($this, 'authorFilter'), 5); break; case 'sitemap-custom-post': $types = get_post_types(array('public' => true)); foreach (array('post', 'page', 'attachment', 'revision', 'nav_menu_item', 'product', 'wpsc-product', 'ngg_tag') as $exclude) { if (in_array($exclude, $types)) { unset($types[$exclude]); } } foreach ($types as $type) { $type_data = get_post_type_object($type); if ((isset($type_data->rewrite['publicly_queryable']) && $type_data->rewrite['publicly_queryable'] == 1) || (isset($type_data->publicly_queryable) && $type_data->publicly_queryable == 1)) { continue; } unset($types[$type]); } if (empty($types)) { array_push($types, 'custom-post'); } $sq_query['post_type'] = $types; break; case 'sitemap-product': if (SQ_Classes_Helpers_Tools::isEcommerce()) { $types = array('product', 'wpsc-product'); } else { $types = array('custom-post'); } $sq_query['post_type'] = $types; break; case 'sitemap-archive': add_filter('sq-sitemap-archive', array($this, 'archiveFilter'), 5); break; } } } } public function getFeedStyle() { return 'model->type == 'sitemap' ? 'index' : '') . '.xsl"?>' . "\n"; } /** * Show the Sitemap Header * @param array $include Include schema */ public function showSitemapHeader($include = array()) { @ini_set('memory_limit', apply_filters('admin_memory_limit', WP_MAX_MEMORY_LIMIT)); header('Status: 200 OK', true, 200); header('Content-Type: text/xml; charset=' . get_bloginfo('charset'), true); //Generate header echo '' . "\n"; echo apply_filters('sq_sitemap_style', false); echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; echo '' . "\n"; $schema = array( 'image' => 'xmlns:image="http://www.google.com/schemas/sitemap-image/1.1"', 'video' => 'xmlns:video="http://www.google.com/schemas/sitemap-video/1.1"', 'news' => 'xmlns:news="http://www.google.com/schemas/sitemap-news/0.9"', 'mobile' => 'xmlns:mobile="http://www.google.com/schemas/sitemap-mobile/1.0"', ); if (!empty($include)) $include = array_unique($include); switch ($this->model->type) { case 'sitemap': echo '' . "\n"; break; case 'sitemap-news': array_push($include, 'news'); $include = array_unique($include); default: echo '' . "\n"; break; } } /** * Show the Sitemap Footer */ private function showSitemapFooter() { switch ($this->model->type) { case 'sitemap': echo '' . "\n"; break; default : echo '' . "\n"; break; } } /** * Create the XML sitemap * @return string */ public function showSitemap() { switch ($this->model->type) { case 'sitemap': $this->showSitemapHeader(); $sq_sitemap = SQ_Classes_Helpers_Tools::getOption('sq_sitemap'); if (!empty($sq_sitemap)) foreach ($sq_sitemap as $name => $value) { //force to show products if not preset if ($name == 'sitemap-product' && !SQ_Classes_Helpers_Tools::isEcommerce()) { continue; } if ($name !== 'sitemap' && ($value[1] == 1 || $value[1] == 2)) { echo "\t" . '' . "\n"; echo "\t" . '' . $this->getXmlUrl($name) . '' . "\n"; echo "\t" . '' . mysql2date('Y-m-d\TH:i:s+00:00', get_lastpostmodified('gmt'), false) . '' . "\n"; echo "\t" . '' . "\n"; if ($name == 'sitemap-post' && $count_posts = wp_count_posts()) { if (isset($count_posts->publish) && $count_posts->publish > 0 && $count_posts->publish > $this->posts_limit) { $pages = ceil($count_posts->publish / $this->posts_limit); for ($page = 2; $page <= $pages; $page++) { echo "\t" . '' . "\n"; echo "\t" . '' . $this->getXmlUrl($name, $page) . '' . "\n"; echo "\t" . '' . mysql2date('Y-m-d\TH:i:s+00:00', get_lastpostmodified('gmt'), false) . '' . "\n"; echo "\t" . '' . "\n"; } } } if ($name == 'sitemap-page' && $count_posts = wp_count_posts('page')) { if (isset($count_posts->publish) && $count_posts->publish > 0 && $count_posts->publish > $this->posts_limit) { $pages = ceil($count_posts->publish / $this->posts_limit); for ($page = 2; $page <= $pages; $page++) { echo "\t" . '' . "\n"; echo "\t" . '' . $this->getXmlUrl($name, $page) . '' . "\n"; echo "\t" . '' . mysql2date('Y-m-d\TH:i:s+00:00', get_lastpostmodified('gmt'), false) . '' . "\n"; echo "\t" . '' . "\n"; } } } if ($name == 'sitemap-product' && $count_posts = wp_count_posts('product')) { if (isset($count_posts->publish) && $count_posts->publish > 0 && $count_posts->publish > $this->posts_limit) { $pages = ceil($count_posts->publish / $this->posts_limit); for ($page = 2; $page <= $pages; $page++) { echo "\t" . '' . "\n"; echo "\t" . '' . $this->getXmlUrl($name, $page) . '' . "\n"; echo "\t" . '' . mysql2date('Y-m-d\TH:i:s+00:00', get_lastpostmodified('gmt'), false) . '' . "\n"; echo "\t" . '' . "\n"; } } } } } $this->showSitemapFooter(); break; case 'sitemap-home': $this->showPackXml($this->model->getHomeLink()); break; case 'sitemap-news': $this->showPackXml($this->model->getListNews()); break; case 'sitemap-category': case 'sitemap-post_tag': case 'sitemap-custom-tax': $this->showPackXml($this->model->getListTerms()); break; case 'sitemap-author': $this->showPackXml($this->model->getListAuthors()); break; case 'sitemap-archive': $this->showPackXml($this->model->getListArchive()); break; case 'sitemap-attachment': $this->showPackXml($this->model->getListAttachments()); break; default: $this->showPackXml($this->model->getListPosts()); break; } } /** * Pach the XML for each sitemap * @param array $xml * @return void */ public function showPackXml($xml = array()) { if (empty($xml)) { $xml['contains'] = ''; } if (!isset($xml['contains'])) { $xml['contains'] = ''; } $this->showSitemapHeader($xml['contains']); unset($xml['contains']); foreach ($xml as $row) { echo "\t" . '' . "\n"; if (is_array($row)) { echo $this->getRecursiveXml($row); } echo "\t" . '' . "\n"; } $this->showSitemapFooter(); unset($xml); } public function getRecursiveXml($xml, $pkey = '', $level = 2) { $str = ''; $tab = str_repeat("\t", $level); if (is_array($xml)) { $cnt = 0; foreach ($xml as $key => $data) { if (!is_array($data)) { $str .= $tab . '<' . $key . ($key == 'video:player_loc' ? ' allow_embed="yes"' : '') . '>' . $data . ((strpos($data, '?') == false && $key == 'video:player_loc') ? '' : '') . '' . "\n"; } else { if ($this->getRecursiveXml($data) <> '') { if (!$this->_ckeckIntergerArray($data)) { $str .= $tab . '<' . (!is_numeric($key) ? $key : $pkey) . '>' . "\n"; } $str .= $this->getRecursiveXml($data, $key, ($this->_ckeckIntergerArray($data) ? $level : $level + 1)); if (!$this->_ckeckIntergerArray($data)) { $str .= $tab . '' . "\n"; } } } $cnt++; } } return $str; } private function _ckeckIntergerArray($data) { foreach ($data as $key => $value) { if (is_numeric($key)) { return true; } break; } return false; } /** * Set the query limit * @param integer $limits * @return string */ public function setLimits($limits) { if (isset($this->posts_limit) && $this->posts_limit > 0) { return 'LIMIT 0, ' . $this->posts_limit; } return ''; } /** * Get the url for each sitemap * @param string $sitemap * @param integer $page * @return string */ public function getXmlUrl($sitemap, $page = null) { $sq_sitemap = SQ_Classes_Helpers_Tools::getOption('sq_sitemap'); if (!get_option('permalink_structure')) { $sitemap = '?sq_feed=' . str_replace('.xml', '', $sitemap) . (isset($page) ? '&page=' . $page : ''); } else { if (isset($sq_sitemap[$sitemap])) { $sitemap = $sq_sitemap[$sitemap][0] . (isset($page) ? '?page=' . $page : ''); } if (strpos($sitemap, '.xml') === false) { $sitemap .= '.xml'; } } return esc_url(trailingslashit(home_url())) . $sitemap; } public function processCron() { SQ_Classes_ObjController::getClass('SQ_Classes_Helpers_Tools'); $sq_sitemap = SQ_Classes_Helpers_Tools::getOption('sq_sitemap'); if (!empty($sq_sitemap)) { foreach ($sq_sitemap as $name => $sitemap) { if ($sitemap[1] == 1) { //is the default sitemap $this->SendPing($this->getXmlUrl($name)); } } } } /** * Ping the sitemap to Google and Bing * @param string $sitemapUrl * @return boolean */ protected function SendPing($sitemapUrl) { $success = true; $urls = array( "http://www.google.com/webmasters/sitemaps/ping?sitemap=%s", "http://www.bing.com/webmaster/ping.aspx?siteMap=%s", ); $options = array( 'method' => 'get', 'sslverify' => false, 'timeout' => 10 ); foreach ($urls as $url) { if ($responce = SQ_Classes_ObjController::getClass('SQ_Classes_RemoteController')->sq_wpcall(sprintf($url, $sitemapUrl), $options)) { $success = true; } } return $success; } /** * Delete the fizical file if exists * @return boolean */ public function deleteSitemapFile() { $sq_sitemap = SQ_Classes_Helpers_Tools::getOption('sq_sitemap'); if (isset($sq_sitemap[$this->root])) { if (file_exists(ABSPATH . $sq_sitemap[$this->root])) { @unlink(ABSPATH . $sq_sitemap[$this->root]); return true; } } return false; } /** * Remove the trailing slash from permalinks that have an extension, * such as /sitemap.xml * * @param string $request */ public function untrailingslashit($request) { if (pathinfo($request, PATHINFO_EXTENSION)) { return untrailingslashit($request); } return $request; // trailingslashit($request); } public function postFilter(&$query) { $query->set('tax_query', array()); } /** * Filter the Custom Taxonomy * @param $query * @param $args * @return array */ public function customTaxFilter($query, $args) { global $wpdb; $query[] = "(SELECT UNIX_TIMESTAMP(MAX(p.post_date_gmt)) as _mod_date FROM {$wpdb->posts} p, {$wpdb->term_relationships} r WHERE p.ID = r.object_id AND p.post_status = 'publish' AND p.post_password = '' AND r.term_taxonomy_id = tt.term_taxonomy_id ) as lastmod"; return $query; } public function pageFilter(&$query) { $query->set('post_type', array('page')); $query->set('tax_query', array()); } public function authorFilter() { //get only the author with posts add_filter('pre_user_query', array($this, 'userFilter')); return get_users(); } public function userFilter($query) { $query->query_fields .= ',p.lastmod'; $query->query_from .= ' LEFT OUTER JOIN ( SELECT MAX(post_modified) as lastmod, post_author, COUNT(*) as post_count FROM wp_posts WHERE post_type = "post" AND post_status = "publish" GROUP BY post_author ) p ON (wp_users.ID = p.post_author)'; $query->query_where .= ' AND post_count > 0 '; } public function customPostFilter(&$query) { $types = get_post_types(array('public' => true)); foreach (array('post', 'page', 'attachment', 'revision', 'nav_menu_item', 'product', 'wpsc-product') as $exclude) { if (in_array($exclude, $types)) { unset($types[$exclude]); } } foreach ($types as $type) { $type_data = get_post_type_object($type); if ((isset($type_data->rewrite['feeds']) && $type_data->rewrite['feeds'] == 1) || (isset($type_data->feeds) && $type_data->feeds == 1)) { continue; } unset($types[$type]); } if (empty($types)) { array_push($types, 'custom-post'); } $query->set('post_type', $types); // id of page or post $query->set('tax_query', array()); } public function productFilter(&$query) { if (!$types = SQ_Classes_Helpers_Tools::isEcommerce()) { $types = array('custom-post'); } $query->set('post_type', $types); // id of page or post $query->set('tax_query', array()); } public function archiveFilter() { global $wpdb; $archives = $wpdb->get_results(" SELECT DISTINCT YEAR(post_date_gmt) as `year`, MONTH(post_date_gmt) as `month`, max(post_date_gmt) as lastmod, count(ID) as posts FROM $wpdb->posts WHERE post_date_gmt < NOW() AND post_status = 'publish' AND post_type = 'post' GROUP BY YEAR(post_date_gmt), MONTH(post_date_gmt) ORDER BY post_date_gmt DESC "); return $archives; } }