feedwordpress / syndicationdataqueries.class.php

syndicationdataqueries.class.php in FeedWordPress 2016.1213, at syndicationdataqueries.class.php

115 lines 3.3 KB

Raw Download Zip

1	<?php
2
3	class SyndicationDataQueries {
4	public function __construct () {
5	add_action('init', array($this, 'init'));
6	add_action('parse_query', array($this, 'parse_query'), 10, 1);
7	add_filter('posts_search', array($this, 'posts_search'), 10, 2);
8	add_filter('posts_where', array($this, 'posts_where'), 10, 2);
9	add_filter('posts_fields', array($this, 'posts_fields'), 10, 2);
10	add_filter('posts_request', array($this, 'posts_request'), 10, 2);
11	}
12
13	function init () {
14	global $wp;
15	$wp->add_query_var('guid');
16	}
17
18	function parse_query (&$q) {
19	if ($q->get('guid')) :
20	$q->is_single = false; // Causes nasty side-effects.
21	$q->is_singular = true; // Doesn't?
22	endif;
23
24	$ff = $q->get('fields');
25	if ($ff == '_synfresh' or $ff == '_synfrom') :
26	$q->query_vars['cache_results'] = false; // Not suitable.
27	endif;
28	} /* SyndicationDataQueries::parse_query () */
29
30	function pre_get_posts (&$q) {
31	//
32	}
33
34	function posts_request ($sql, &$query) {
35	if ($query->get('fields') == '_synfresh') :
36	FeedWordPress::diagnostic('feed_items:freshness:sql', "SQL: ".$sql);
37	endif;
38	return $sql;
39	}
40
41	function posts_search ($search, &$query) {
42	global $wpdb;
43	if ($guid = $query->get('guid')) :
44	if (strlen(trim($guid)) > 0) :
45	$seek = array($guid);
46
47	// MD5 hashes
48	if (preg_match('/^[0-9a-f]{32}$/i', $guid)) :
49	$seek[] = SyndicatedPost::normalize_guid_prefix().$guid;
50	endif;
51
52	// Invalid URIs, URIs that WordPress just doesn't like, and URIs
53	// that WordPress decides to munge.
54	$nGuid = SyndicatedPost::normalize_guid($guid);
55	if ($guid != $nGuid) :
56	$seek[] = $nGuid;
57	endif;
58
59	// Escape to prevent frak-ups, injections, etc.
60	$seek = array_map('esc_sql', $seek);
61
62	// Assemble
63	$guidMatch = "(guid = '".implode("') OR (guid = '", $seek)."')";
64	$search .= " AND ($guidMatch)";
65	endif;
66	endif;
67
68	if ($query->get('fields')=='_synfresh') :
69	// Ugly hack to ensure we ONLY check by guid in syndicated freshness
70	// checks -- for reasons of both performance and correctness. Pitch:
71	$search .= " -- '";
72	elseif ($query->get('fields')=='_synfrom') :
73	$search .= " AND ({$wpdb->postmeta}.meta_key = '".$query->get('meta_key')."' AND {$wpdb->postmeta}.meta_value = '".$query->get('meta_value')."') -- '";
74	endif;
75	return $search;
76	} /* SyndicationDataQueries::posts_search () */
77
78	function posts_where ($where, &$q) {
79	global $wpdb;
80
81	// Ugly hack to ensure we ONLY check by guid in syndicated freshness
82	// checks -- for reasons of both performance and correctness. Catch:
83	if (strpos($where, " -- '") !== false) :
84	$bits = explode(" -- '", $where, 2);
85	$where = $bits[0];
86	endif;
87
88	if ($psn = $q->get('post_status__not')) :
89	$where .= " AND ({$wpdb->posts}.post_status <> '".esc_sql($psn)."')";
90	endif;
91
92	return $where;
93	} /* SyndicationDataQueries::post_where () */
94
95	function posts_fields ($fields, &$query) {
96	global $wpdb;
97	if ($f = $query->get('fields')) :
98	switch ($f) :
99	case '_synfresh' :
100	$fields = "{$wpdb->posts}.ID, {$wpdb->posts}.guid, {$wpdb->posts}.post_modified_gmt, {$wpdb->posts}.post_name";
101	break;
102	case '_synfrom' :
103	$fields = "{$wpdb->posts}.ID, {$wpdb->posts}.guid, {$wpdb->posts}.post_title, {$wpdb->postmeta}.meta_value";
104	break;
105	default :
106	// Do nothing.
107	endswitch;
108	endif;
109	return $fields;
110	} /* SyndicationDataQueries::posts_fields () */
111	}
112
113	$SDQ = new SyndicationDataQueries;
114
115