← All changes | syndicationdataqueries.class.php +24 -70 trunk → 2011.0531 View file →

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