feedwordpress / syndicationdataqueries.class.php

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

116 lines 3.5 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	// NOOP
15	}
16
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) {
34	if ($query->get('fields') == '_synfresh') :
35	FeedWordPress::diagnostic('feed_items:freshness:sql', "SQL: ".$sql);
36	endif;
37	return $sql;
38	}
39
40	function posts_search ($search, $query) {
41	global $wpdb;
42	if ($guid = $query->get('guid')) :
43	if (strlen(trim($guid)) > 0) :
44	$seek = array($guid);
45
46	// MD5 hashes
47	if (preg_match('/^[0-9a-f]{32}$/i', $guid)) :
48	$seek[] = SyndicatedPost::normalize_guid_prefix().$guid;
49	$seek[] = SyndicatedPost::alternative_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	$seek[] = SyndicatedPost::alternative_guid($guid);
58	endif;
59
60	// Escape to prevent frak-ups, injections, etc.
61	$seek = array_map('esc_sql', $seek);
62
63	// Assemble
64	$guidMatch = "(guid = '".implode("') OR (guid = '", $seek)."')";
65	$search .= " AND ($guidMatch)";
66	endif;
67	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	return $search;
77	} /* SyndicationDataQueries::posts_search () */
78
79	function posts_where ($where, $q) {
80	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	if ($f = $query->get('fields')) :
99	switch ($f) :
100	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";
105	break;
106	default :
107	// Do nothing.
108	endswitch;
109	endif;
110	return $fields;
111	} /* SyndicationDataQueries::posts_fields () */
112	}
113
114	$SDQ = new SyndicationDataQueries;
115
116