Context Navigation

Back to Ticket #10964

Ticket #10964: query.2.php

File query.2.php, 70.0 KB (added by buch0090, 14 years ago)

Line
1	<?php
2	/**
3	* WordPress Query API
4	*
5	* The query API attempts to get which part of WordPress to the user is on. It
6	* also provides functionality to getting URL query information.
7	*
8	* @link http://codex.wordpress.org/The_Loop More information on The Loop.
9	*
10	* @package WordPress
11	* @subpackage Query
12	*/
13
14	/**
15	* Retrieve variable in the WP_Query class.
16	*
17	* @see WP_Query::get()
18	* @since 1.5.0
19	* @uses $wp_query
20	*
21	* @param string $var The variable key to retrieve.
22	* @return mixed
23	*/
24	function get_query_var($var) {
25	global $wp_query;
26
27	return $wp_query->get($var);
28	}
29
30	/**
31	* Set query variable.
32	*
33	* @see WP_Query::set()
34	* @since 2.2.0
35	* @uses $wp_query
36	*
37	* @param string $var Query variable key.
38	* @param mixed $value
39	* @return null
40	*/
41	function set_query_var($var, $value) {
42	global $wp_query;
43
44	return $wp_query->set($var, $value);
45	}
46
47	/**
48	* Setup The Loop with query parameters.
49	*
50	* This will override the current WordPress Loop and shouldn't be used more than
51	* once. This must not be used within the WordPress Loop.
52	*
53	* @since 1.5.0
54	* @uses $wp_query
55	*
56	* @param string $query
57	* @return array List of posts
58	*/
59	function &query_posts($query) {
60	unset($GLOBALS['wp_query']);
61	$GLOBALS['wp_query'] =& new WP_Query();
62	return $GLOBALS['wp_query']->query($query);
63	}
64
65	/**
66	* Destroy the previous query and setup a new query.
67	*
68	* This should be used after {@link query_posts()} and before another {@link
69	* query_posts()}. This will remove obscure bugs that occur when the previous
70	* wp_query object is not destroyed properly before another is setup.
71	*
72	* @since 2.3.0
73	* @uses $wp_query
74	*/
75	function wp_reset_query() {
76	unset($GLOBALS['wp_query']);
77	$GLOBALS['wp_query'] =& $GLOBALS['wp_the_query'];
78	global $wp_query;
79	if ( !empty($wp_query->post) ) {
80	$GLOBALS['post'] = $wp_query->post;
81	setup_postdata($wp_query->post);
82	}
83	}
84
85	/*
86	* Query type checks.
87	*/
88
89	/**
90	* Whether the current request is in WordPress admin Panel
91	*
92	* Does not inform on whether the user is an admin! Use capability checks to
93	* tell if the user should be accessing a section or not.
94	*
95	* @since 1.5.1
96	*
97	* @return bool True if inside WordPress administration pages.
98	*/
99	function is_admin () {
100	if ( defined('WP_ADMIN') )
101	return WP_ADMIN;
102	return false;
103	}
104
105	/**
106	* Is query requesting an archive page.
107	*
108	* @since 1.5.0
109	* @uses $wp_query
110	*
111	* @return bool True if page is archive.
112	*/
113	function is_archive () {
114	global $wp_query;
115
116	return $wp_query->is_archive;
117	}
118
119	/**
120	* Is query requesting an attachment page.
121	*
122	* @since 2.0.0
123	* @uses $wp_query
124	*
125	* @return bool True if page is attachment.
126	*/
127	function is_attachment () {
128	global $wp_query;
129
130	return $wp_query->is_attachment;
131	}
132
133	/**
134	* Is query requesting an author page.
135	*
136	* If the $author parameter is specified then the check will be expanded to
137	* include whether the queried author matches the one given in the parameter.
138	* You can match against integers and against strings.
139	*
140	* If matching against an integer, the ID should be used of the author for the
141	* test. If the $author is an ID and matches the author page user ID, then
142	* 'true' will be returned.
143	*
144	* If matching against strings, then the test will be matched against both the
145	* nickname and user nicename and will return true on success.
146	*
147	* @since 1.5.0
148	* @uses $wp_query
149	*
150	* @param string\|int $author Optional. Is current page this author.
151	* @return bool True if page is author or $author (if set).
152	*/
153	function is_author ($author = '') {
154	global $wp_query;
155
156	if ( !$wp_query->is_author )
157	return false;
158
159	if ( empty($author) )
160	return true;
161
162	$author_obj = $wp_query->get_queried_object();
163
164	$author = (array) $author;
165
166	if ( in_array( $author_obj->ID, $author ) )
167	return true;
168	elseif ( in_array( $author_obj->nickname, $author ) )
169	return true;
170	elseif ( in_array( $author_obj->user_nicename, $author ) )
171	return true;
172
173	return false;
174	}
175
176	/**
177	* Whether current page query contains a category name or given category name.
178	*
179	* The category list can contain category IDs, names, or category slugs. If any
180	* of them are part of the query, then it will return true.
181	*
182	* @since 1.5.0
183	* @uses $wp_query
184	*
185	* @param string\|array $category Optional.
186	* @return bool
187	*/
188	function is_category ($category = '') {
189	global $wp_query;
190
191	if ( !$wp_query->is_category )
192	return false;
193
194	if ( empty($category) )
195	return true;
196
197	$cat_obj = $wp_query->get_queried_object();
198
199	$category = (array) $category;
200
201	if ( in_array( $cat_obj->term_id, $category ) )
202	return true;
203	elseif ( in_array( $cat_obj->name, $category ) )
204	return true;
205	elseif ( in_array( $cat_obj->slug, $category ) )
206	return true;
207
208	return false;
209	}
210
211	/**
212	* Whether the current page query has the given tag slug or contains tag.
213	*
214	* @since 2.3.0
215	* @uses $wp_query
216	*
217	* @param string\|array $slug Optional. Single tag or list of tags to check for.
218	* @return bool
219	*/
220	function is_tag( $slug = '' ) {
221	global $wp_query;
222
223	if ( !$wp_query->is_tag )
224	return false;
225
226	if ( empty( $slug ) )
227	return true;
228
229	$tag_obj = $wp_query->get_queried_object();
230
231	$slug = (array) $slug;
232
233	if ( in_array( $tag_obj->slug, $slug ) )
234	return true;
235
236	return false;
237	}
238
239	/**
240	* Whether the current page query has the given taxonomy slug or contains taxonomy.
241	*
242	* @since 2.5.0
243	* @uses $wp_query
244	*
245	* @param string\|array $slug Optional. Slug or slugs to check in current query.
246	* @return bool
247	*/
248	function is_tax( $slug = '' ) {
249	global $wp_query;
250
251	if ( !$wp_query->is_tax )
252	return false;
253
254	if ( empty($slug) )
255	return true;
256
257	$term = $wp_query->get_queried_object();
258
259	$slug = (array) $slug;
260
261	if ( in_array( $term->slug, $slug ) )
262	return true;
263
264	return false;
265	}
266
267	/**
268	* Whether the current URL is within the comments popup window.
269	*
270	* @since 1.5.0
271	* @uses $wp_query
272	*
273	* @return bool
274	*/
275	function is_comments_popup () {
276	global $wp_query;
277
278	return $wp_query->is_comments_popup;
279	}
280
281	/**
282	* Whether current URL is based on a date.
283	*
284	* @since 1.5.0
285	* @uses $wp_query
286	*
287	* @return bool
288	*/
289	function is_date () {
290	global $wp_query;
291
292	return $wp_query->is_date;
293	}
294
295	/**
296	* Whether current blog URL contains a day.
297	*
298	* @since 1.5.0
299	* @uses $wp_query
300	*
301	* @return bool
302	*/
303	function is_day () {
304	global $wp_query;
305
306	return $wp_query->is_day;
307	}
308
309	/**
310	* Whether current page query is feed URL.
311	*
312	* @since 1.5.0
313	* @uses $wp_query
314	*
315	* @return bool
316	*/
317	function is_feed () {
318	global $wp_query;
319
320	return $wp_query->is_feed;
321	}
322
323	/**
324	* Whether current page query is the front of the site.
325	*
326	* @since 2.5.0
327	* @uses is_home()
328	* @uses get_option()
329	*
330	* @return bool True, if front of site.
331	*/
332	function is_front_page () {
333	// most likely case
334	if ( 'posts' == get_option('show_on_front') && is_home() )
335	return true;
336	elseif ( 'page' == get_option('show_on_front') && get_option('page_on_front') && is_page(get_option('page_on_front')) )
337	return true;
338	else
339	return false;
340	}
341
342	/**
343	* Whether current page view is the blog homepage.
344	*
345	* @since 1.5.0
346	* @uses $wp_query
347	*
348	* @return bool True if blog view homepage.
349	*/
350	function is_home () {
351	global $wp_query;
352
353	return $wp_query->is_home;
354	}
355
356	/**
357	* Whether current page query contains a month.
358	*
359	* @since 1.5.0
360	* @uses $wp_query
361	*
362	* @return bool
363	*/
364	function is_month () {
365	global $wp_query;
366
367	return $wp_query->is_month;
368	}
369
370	/**
371	* Whether query is page or contains given page(s).
372	*
373	* Calls the function without any parameters will only test whether the current
374	* query is of the page type. Either a list or a single item can be tested
375	* against for whether the query is a page and also is the value or one of the
376	* values in the page parameter.
377	*
378	* The parameter can contain the page ID, page title, or page name. The
379	* parameter can also be an array of those three values.
380	*
381	* @since 1.5.0
382	* @uses $wp_query
383	*
384	* @param mixed $page Either page or list of pages to test against.
385	* @return bool
386	*/
387	function is_page ($page = '') {
388	global $wp_query;
389
390	if ( !$wp_query->is_page )
391	return false;
392
393	if ( empty($page) )
394	return true;
395
396	$page_obj = $wp_query->get_queried_object();
397
398	$page = (array) $page;
399
400	if ( in_array( $page_obj->ID, $page ) )
401	return true;
402	elseif ( in_array( $page_obj->post_title, $page ) )
403	return true;
404	else if ( in_array( $page_obj->post_name, $page ) )
405	return true;
406
407	return false;
408	}
409
410	/**
411	* Whether query contains multiple pages for the results.
412	*
413	* @since 1.5.0
414	* @uses $wp_query
415	*
416	* @return bool
417	*/
418	function is_paged () {
419	global $wp_query;
420
421	return $wp_query->is_paged;
422	}
423
424	/**
425	* Whether the current page was created by a plugin.
426	*
427	* The plugin can set this by using the global $plugin_page and setting it to
428	* true.
429	*
430	* @since 1.5.0
431	* @global bool $plugin_page Used by plugins to tell the query that current is a plugin page.
432	*
433	* @return bool
434	*/
435	function is_plugin_page() {
436	global $plugin_page;
437
438	if ( isset($plugin_page) )
439	return true;
440
441	return false;
442	}
443
444	/**
445	* Whether the current query is preview of post or page.
446	*
447	* @since 2.0.0
448	* @uses $wp_query
449	*
450	* @return bool
451	*/
452	function is_preview() {
453	global $wp_query;
454
455	return $wp_query->is_preview;
456	}
457
458	/**
459	* Whether the current query post is robots.
460	*
461	* @since 2.1.0
462	* @uses $wp_query
463	*
464	* @return bool
465	*/
466	function is_robots() {
467	global $wp_query;
468
469	return $wp_query->is_robots;
470	}
471
472	/**
473	* Whether current query is the result of a user search.
474	*
475	* @since 1.5.0
476	* @uses $wp_query
477	*
478	* @return bool
479	*/
480	function is_search () {
481	global $wp_query;
482
483	return $wp_query->is_search;
484	}
485
486	/**
487	* Whether the current page query is single page.
488	*
489	* The parameter can contain the post ID, post title, or post name. The
490	* parameter can also be an array of those three values.
491	*
492	* This applies to other post types, attachments, pages, posts. Just means that
493	* the current query has only a single object.
494	*
495	* @since 1.5.0
496	* @uses $wp_query
497	*
498	* @param mixed $post Either post or list of posts to test against.
499	* @return bool
500	*/
501	function is_single ($post = '') {
502	global $wp_query;
503
504	if ( !$wp_query->is_single )
505	return false;
506
507	if ( empty( $post) )
508	return true;
509
510	$post_obj = $wp_query->get_queried_object();
511
512	$post = (array) $post;
513
514	if ( in_array( $post_obj->ID, $post ) )
515	return true;
516	elseif ( in_array( $post_obj->post_title, $post ) )
517	return true;
518	elseif ( in_array( $post_obj->post_name, $post ) )
519	return true;
520
521	return false;
522	}
523
524	/**
525	* Whether is single post, is a page, or is an attachment.
526	*
527	* @since 1.5.0
528	* @uses $wp_query
529	*
530	* @return bool
531	*/
532	function is_singular() {
533	global $wp_query;
534
535	return $wp_query->is_singular;
536	}
537
538	/**
539	* Whether the query contains a time.
540	*
541	* @since 1.5.0
542	* @uses $wp_query
543	*
544	* @return bool
545	*/
546	function is_time () {
547	global $wp_query;
548
549	return $wp_query->is_time;
550	}
551
552	/**
553	* Whether the query is a trackback.
554	*
555	* @since 1.5.0
556	* @uses $wp_query
557	*
558	* @return bool
559	*/
560	function is_trackback () {
561	global $wp_query;
562
563	return $wp_query->is_trackback;
564	}
565
566	/**
567	* Whether the query contains a year.
568	*
569	* @since 1.5.0
570	* @uses $wp_query
571	*
572	* @return bool
573	*/
574	function is_year () {
575	global $wp_query;
576
577	return $wp_query->is_year;
578	}
579
580	/**
581	* Whether current page query is a 404 and no results for WordPress query.
582	*
583	* @since 1.5.0
584	* @uses $wp_query
585	*
586	* @return bool True, if nothing is found matching WordPress Query.
587	*/
588	function is_404 () {
589	global $wp_query;
590
591	return $wp_query->is_404;
592	}
593
594	/*
595	* The Loop. Post loop control.
596	*/
597
598	/**
599	* Whether current WordPress query has results to loop over.
600	*
601	* @see WP_Query::have_posts()
602	* @since 1.5.0
603	* @uses $wp_query
604	*
605	* @return bool
606	*/
607	function have_posts() {
608	global $wp_query;
609
610	return $wp_query->have_posts();
611	}
612
613	/**
614	* Whether the caller is in the Loop.
615	*
616	* @since 2.0.0
617	* @uses $wp_query
618	*
619	* @return bool True if caller is within loop, false if loop hasn't started or ended.
620	*/
621	function in_the_loop() {
622	global $wp_query;
623
624	return $wp_query->in_the_loop;
625	}
626
627	/**
628	* Rewind the loop posts.
629	*
630	* @see WP_Query::rewind_posts()
631	* @since 1.5.0
632	* @uses $wp_query
633	*
634	* @return null
635	*/
636	function rewind_posts() {
637	global $wp_query;
638
639	return $wp_query->rewind_posts();
640	}
641
642	/**
643	* Iterate the post index in the loop.
644	*
645	* @see WP_Query::the_post()
646	* @since 1.5.0
647	* @uses $wp_query
648	*/
649	function the_post() {
650	global $wp_query;
651
652	$wp_query->the_post();
653	}
654
655	/*
656	* Comments loop.
657	*/
658
659	/**
660	* Whether there are comments to loop over.
661	*
662	* @see WP_Query::have_comments()
663	* @since 2.2.0
664	* @uses $wp_query
665	*
666	* @return bool
667	*/
668	function have_comments() {
669	global $wp_query;
670	return $wp_query->have_comments();
671	}
672
673	/**
674	* Iterate comment index in the comment loop.
675	*
676	* @see WP_Query::the_comment()
677	* @since 2.2.0
678	* @uses $wp_query
679	*
680	* @return object
681	*/
682	function the_comment() {
683	global $wp_query;
684	return $wp_query->the_comment();
685	}
686
687	/*
688	* WP_Query
689	*/
690
691	/**
692	* The WordPress Query class.
693	*
694	* @link http://codex.wordpress.org/Function_Reference/WP_Query Codex page.
695	*
696	* @since 1.5.0
697	*/
698	class WP_Query {
699
700	/**
701	* Query string
702	*
703	* @since 1.5.0
704	* @access public
705	* @var string
706	*/
707	var $query;
708
709	/**
710	* Query search variables set by the user.
711	*
712	* @since 1.5.0
713	* @access public
714	* @var array
715	*/
716	var $query_vars = array();
717
718	/**
719	* Holds the data for a single object that is queried.
720	*
721	* Holds the contents of a post, page, category, attachment.
722	*
723	* @since 1.5.0
724	* @access public
725	* @var object\|array
726	*/
727	var $queried_object;
728
729	/**
730	* The ID of the queried object.
731	*
732	* @since 1.5.0
733	* @access public
734	* @var int
735	*/
736	var $queried_object_id;
737
738	/**
739	* Get post database query.
740	*
741	* @since 2.0.1
742	* @access public
743	* @var string
744	*/
745	var $request;
746
747	/**
748	* List of posts.
749	*
750	* @since 1.5.0
751	* @access public
752	* @var array
753	*/
754	var $posts;
755
756	/**
757	* The amount of posts for the current query.
758	*
759	* @since 1.5.0
760	* @access public
761	* @var int
762	*/
763	var $post_count = 0;
764
765	/**
766	* Index of the current item in the loop.
767	*
768	* @since 1.5.0
769	* @access public
770	* @var int
771	*/
772	var $current_post = -1;
773
774	/**
775	* Whether the loop has started and the caller is in the loop.
776	*
777	* @since 2.0.0
778	* @access public
779	* @var bool
780	*/
781	var $in_the_loop = false;
782
783	/**
784	* The current post ID.
785	*
786	* @since 1.5.0
787	* @access public
788	* @var int
789	*/
790	var $post;
791
792	/**
793	* The list of comments for current post.
794	*
795	* @since 2.2.0
796	* @access public
797	* @var array
798	*/
799	var $comments;
800
801	/**
802	* The amount of comments for the posts.
803	*
804	* @since 2.2.0
805	* @access public
806	* @var int
807	*/
808	var $comment_count = 0;
809
810	/**
811	* The index of the comment in the comment loop.
812	*
813	* @since 2.2.0
814	* @access public
815	* @var int
816	*/
817	var $current_comment = -1;
818
819	/**
820	* Current comment ID.
821	*
822	* @since 2.2.0
823	* @access public
824	* @var int
825	*/
826	var $comment;
827
828	/**
829	* Amount of posts if limit clause was not used.
830	*
831	* @since 2.1.0
832	* @access public
833	* @var int
834	*/
835	var $found_posts = 0;
836
837	/**
838	* The amount of pages.
839	*
840	* @since 2.1.0
841	* @access public
842	* @var int
843	*/
844	var $max_num_pages = 0;
845
846	/**
847	* The amount of comment pages.
848	*
849	* @since 2.7.0
850	* @access public
851	* @var int
852	*/
853	var $max_num_comment_pages = 0;
854
855	/**
856	* Set if query is single post.
857	*
858	* @since 1.5.0
859	* @access public
860	* @var bool
861	*/
862	var $is_single = false;
863
864	/**
865	* Set if query is preview of blog.
866	*
867	* @since 2.0.0
868	* @access public
869	* @var bool
870	*/
871	var $is_preview = false;
872
873	/**
874	* Set if query returns a page.
875	*
876	* @since 1.5.0
877	* @access public
878	* @var bool
879	*/
880	var $is_page = false;
881
882	/**
883	* Set if query is an archive list.
884	*
885	* @since 1.5.0
886	* @access public
887	* @var bool
888	*/
889	var $is_archive = false;
890
891	/**
892	* Set if query is part of a date.
893	*
894	* @since 1.5.0
895	* @access public
896	* @var bool
897	*/
898	var $is_date = false;
899
900	/**
901	* Set if query contains a year.
902	*
903	* @since 1.5.0
904	* @access public
905	* @var bool
906	*/
907	var $is_year = false;
908
909	/**
910	* Set if query contains a month.
911	*
912	* @since 1.5.0
913	* @access public
914	* @var bool
915	*/
916	var $is_month = false;
917
918	/**
919	* Set if query contains a day.
920	*
921	* @since 1.5.0
922	* @access public
923	* @var bool
924	*/
925	var $is_day = false;
926
927	/**
928	* Set if query contains time.
929	*
930	* @since 1.5.0
931	* @access public
932	* @var bool
933	*/
934	var $is_time = false;
935
936	/**
937	* Set if query contains an author.
938	*
939	* @since 1.5.0
940	* @access public
941	* @var bool
942	*/
943	var $is_author = false;
944
945	/**
946	* Set if query contains category.
947	*
948	* @since 1.5.0
949	* @access public
950	* @var bool
951	*/
952	var $is_category = false;
953
954	/**
955	* Set if query contains tag.
956	*
957	* @since 2.3.0
958	* @access public
959	* @var bool
960	*/
961	var $is_tag = false;
962
963	/**
964	* Set if query contains taxonomy.
965	*
966	* @since 2.5.0
967	* @access public
968	* @var bool
969	*/
970	var $is_tax = false;
971
972	/**
973	* Set if query was part of a search result.
974	*
975	* @since 1.5.0
976	* @access public
977	* @var bool
978	*/
979	var $is_search = false;
980
981	/**
982	* Set if query is feed display.
983	*
984	* @since 1.5.0
985	* @access public
986	* @var bool
987	*/
988	var $is_feed = false;
989
990	/**
991	* Set if query is comment feed display.
992	*
993	* @since 2.2.0
994	* @access public
995	* @var bool
996	*/
997	var $is_comment_feed = false;
998
999	/**
1000	* Set if query is trackback.
1001	*
1002	* @since 1.5.0
1003	* @access public
1004	* @var bool
1005	*/
1006	var $is_trackback = false;
1007
1008	/**
1009	* Set if query is blog homepage.
1010	*
1011	* @since 1.5.0
1012	* @access public
1013	* @var bool
1014	*/
1015	var $is_home = false;
1016
1017	/**
1018	* Set if query couldn't found anything.
1019	*
1020	* @since 1.5.0
1021	* @access public
1022	* @var bool
1023	*/
1024	var $is_404 = false;
1025
1026	/**
1027	* Set if query is within comments popup window.
1028	*
1029	* @since 1.5.0
1030	* @access public
1031	* @var bool
1032	*/
1033	var $is_comments_popup = false;
1034
1035	/**
1036	* Set if query is part of administration page.
1037	*
1038	* @since 1.5.0
1039	* @access public
1040	* @var bool
1041	*/
1042	var $is_admin = false;
1043
1044	/**
1045	* Set if query is an attachment.
1046	*
1047	* @since 2.0.0
1048	* @access public
1049	* @var bool
1050	*/
1051	var $is_attachment = false;
1052
1053	/**
1054	* Set if is single, is a page, or is an attachment.
1055	*
1056	* @since 2.1.0
1057	* @access public
1058	* @var bool
1059	*/
1060	var $is_singular = false;
1061
1062	/**
1063	* Set if query is for robots.
1064	*
1065	* @since 2.1.0
1066	* @access public
1067	* @var bool
1068	*/
1069	var $is_robots = false;
1070
1071	/**
1072	* Set if query contains posts.
1073	*
1074	* Basically, the homepage if the option isn't set for the static homepage.
1075	*
1076	* @since 2.1.0
1077	* @access public
1078	* @var bool
1079	*/
1080	var $is_posts_page = false;
1081
1082	/**
1083	* Resets query flags to false.
1084	*
1085	* The query flags are what page info WordPress was able to figure out.
1086	*
1087	* @since 2.0.0
1088	* @access private
1089	*/
1090	function init_query_flags() {
1091	$this->is_single = false;
1092	$this->is_page = false;
1093	$this->is_archive = false;
1094	$this->is_date = false;
1095	$this->is_year = false;
1096	$this->is_month = false;
1097	$this->is_day = false;
1098	$this->is_time = false;
1099	$this->is_author = false;
1100	$this->is_category = false;
1101	$this->is_tag = false;
1102	$this->is_tax = false;
1103	$this->is_search = false;
1104	$this->is_feed = false;
1105	$this->is_comment_feed = false;
1106	$this->is_trackback = false;
1107	$this->is_home = false;
1108	$this->is_404 = false;
1109	$this->is_paged = false;
1110	$this->is_admin = false;
1111	$this->is_attachment = false;
1112	$this->is_singular = false;
1113	$this->is_robots = false;
1114	$this->is_posts_page = false;
1115	}
1116
1117	/**
1118	* Initiates object properties and sets default values.
1119	*
1120	* @since 1.5.0
1121	* @access public
1122	*/
1123	function init () {
1124	unset($this->posts);
1125	unset($this->query);
1126	$this->query_vars = array();
1127	unset($this->queried_object);
1128	unset($this->queried_object_id);
1129	$this->post_count = 0;
1130	$this->current_post = -1;
1131	$this->in_the_loop = false;
1132
1133	$this->init_query_flags();
1134	}
1135
1136	/**
1137	* Reparse the query vars.
1138	*
1139	* @since 1.5.0
1140	* @access public
1141	*/
1142	function parse_query_vars() {
1143	$this->parse_query('');
1144	}
1145
1146	/**
1147	* Fills in the query variables, which do not exist within the parameter.
1148	*
1149	* @since 2.1.0
1150	* @access public
1151	*
1152	* @param array $array Defined query variables.
1153	* @return array Complete query variables with undefined ones filled in empty.
1154	*/
1155	function fill_query_vars($array) {
1156	$keys = array(
1157	'error'
1158	, 'm'
1159	, 'p'
1160	, 'post_parent'
1161	, 'subpost'
1162	, 'subpost_id'
1163	, 'attachment'
1164	, 'attachment_id'
1165	, 'name'
1166	, 'hour'
1167	, 'static'
1168	, 'pagename'
1169	, 'page_id'
1170	, 'second'
1171	, 'minute'
1172	, 'hour'
1173	, 'day'
1174	, 'monthnum'
1175	, 'year'
1176	, 'w'
1177	, 'category_name'
1178	, 'tag'
1179	, 'cat'
1180	, 'tag_id'
1181	, 'author_name'
1182	, 'feed'
1183	, 'tb'
1184	, 'paged'
1185	, 'comments_popup'
1186	, 'meta_key'
1187	, 'meta_value'
1188	, 'preview'
1189	);
1190
1191	foreach ($keys as $key) {
1192	if ( !isset($array[$key]))
1193	$array[$key] = '';
1194	}
1195
1196	$array_keys = array('category__in', 'category__not_in', 'category__and', 'post__in', 'post__not_in',
1197	'tag__in', 'tag__not_in', 'tag__and', 'tag_slug__in', 'tag_slug__and');
1198
1199	foreach ( $array_keys as $key ) {
1200	if ( !isset($array[$key]))
1201	$array[$key] = array();
1202	}
1203	return $array;
1204	}
1205
1206	/**
1207	* Parse a query string and set query type booleans.
1208	*
1209	* @since 1.5.0
1210	* @access public
1211	*
1212	* @param string\|array $query
1213	*/
1214	function parse_query ($query) {
1215	if ( !empty($query) \|\| !isset($this->query) ) {
1216	$this->init();
1217	if ( is_array($query) )
1218	$this->query_vars = $query;
1219	else
1220	parse_str($query, $this->query_vars);
1221	$this->query = $query;
1222	}
1223
1224	$this->query_vars = $this->fill_query_vars($this->query_vars);
1225	$qv = &$this->query_vars;
1226
1227	if ( ! empty($qv['robots']) )
1228	$this->is_robots = true;
1229
1230	$qv['p'] = absint($qv['p']);
1231	$qv['page_id'] = absint($qv['page_id']);
1232	$qv['year'] = absint($qv['year']);
1233	$qv['monthnum'] = absint($qv['monthnum']);
1234	$qv['day'] = absint($qv['day']);
1235	$qv['w'] = absint($qv['w']);
1236	$qv['m'] = absint($qv['m']);
1237	$qv['paged'] = absint($qv['paged']);
1238	$qv['cat'] = preg_replace( '\|[^0-9,-]\|', '', $qv['cat'] ); // comma separated list of positive or negative integers
1239	$qv['pagename'] = trim( $qv['pagename'] );
1240	$qv['name'] = trim( $qv['name'] );
1241	if ( '' !== $qv['hour'] ) $qv['hour'] = absint($qv['hour']);
1242	if ( '' !== $qv['minute'] ) $qv['minute'] = absint($qv['minute']);
1243	if ( '' !== $qv['second'] ) $qv['second'] = absint($qv['second']);
1244
1245	// Compat. Map subpost to attachment.
1246	if ( '' != $qv['subpost'] )
1247	$qv['attachment'] = $qv['subpost'];
1248	if ( '' != $qv['subpost_id'] )
1249	$qv['attachment_id'] = $qv['subpost_id'];
1250
1251	$qv['attachment_id'] = absint($qv['attachment_id']);
1252
1253	if ( ('' != $qv['attachment']) \|\| !empty($qv['attachment_id']) ) {
1254	$this->is_single = true;
1255	$this->is_attachment = true;
1256	} elseif ( '' != $qv['name'] ) {
1257	$this->is_single = true;
1258	} elseif ( $qv['p'] ) {
1259	$this->is_single = true;
1260	} elseif ( ('' !== $qv['hour']) && ('' !== $qv['minute']) &&('' !== $qv['second']) && ('' != $qv['year']) && ('' != $qv['monthnum']) && ('' != $qv['day']) ) {
1261	// If year, month, day, hour, minute, and second are set, a single
1262	// post is being queried.
1263	$this->is_single = true;
1264	} elseif ( '' != $qv['static'] \|\| '' != $qv['pagename'] \|\| !empty($qv['page_id']) ) {
1265	$this->is_page = true;
1266	$this->is_single = false;
1267	} elseif ( !empty($qv['s']) ) {
1268	$this->is_search = true;
1269	} else {
1270	// Look for archive queries. Dates, categories, authors.
1271
1272	if ( '' !== $qv['second'] ) {
1273	$this->is_time = true;
1274	$this->is_date = true;
1275	}
1276
1277	if ( '' !== $qv['minute'] ) {
1278	$this->is_time = true;
1279	$this->is_date = true;
1280	}
1281
1282	if ( '' !== $qv['hour'] ) {
1283	$this->is_time = true;
1284	$this->is_date = true;
1285	}
1286
1287	if ( $qv['day'] ) {
1288	if (! $this->is_date) {
1289	$this->is_day = true;
1290	$this->is_date = true;
1291	}
1292	}
1293
1294	if ( $qv['monthnum'] ) {
1295	if (! $this->is_date) {
1296	$this->is_month = true;
1297	$this->is_date = true;
1298	}
1299	}
1300
1301	if ( $qv['year'] ) {
1302	if (! $this->is_date) {
1303	$this->is_year = true;
1304	$this->is_date = true;
1305	}
1306	}
1307
1308	if ( $qv['m'] ) {
1309	$this->is_date = true;
1310	if (strlen($qv['m']) > 9) {
1311	$this->is_time = true;
1312	} else if (strlen($qv['m']) > 7) {
1313	$this->is_day = true;
1314	} else if (strlen($qv['m']) > 5) {
1315	$this->is_month = true;
1316	} else {
1317	$this->is_year = true;
1318	}
1319	}
1320
1321	if ('' != $qv['w']) {
1322	$this->is_date = true;
1323	}
1324
1325	if ( empty($qv['cat']) \|\| ($qv['cat'] == '0') ) {
1326	$this->is_category = false;
1327	} else {
1328	if (strpos($qv['cat'], '-') !== false) {
1329	$this->is_category = false;
1330	} else {
1331	$this->is_category = true;
1332	}
1333	}
1334
1335	if ( '' != $qv['category_name'] ) {
1336	$this->is_category = true;
1337	}
1338
1339	if ( !is_array($qv['category__in']) \|\| empty($qv['category__in']) ) {
1340	$qv['category__in'] = array();
1341	} else {
1342	$qv['category__in'] = array_map('absint', $qv['category__in']);
1343	$this->is_category = true;
1344	}
1345
1346	if ( !is_array($qv['category__not_in']) \|\| empty($qv['category__not_in']) ) {
1347	$qv['category__not_in'] = array();
1348	} else {
1349	$qv['category__not_in'] = array_map('absint', $qv['category__not_in']);
1350	}
1351
1352	if ( !is_array($qv['category__and']) \|\| empty($qv['category__and']) ) {
1353	$qv['category__and'] = array();
1354	} else {
1355	$qv['category__and'] = array_map('absint', $qv['category__and']);
1356	$this->is_category = true;
1357	}
1358
1359	if ( '' != $qv['tag'] )
1360	$this->is_tag = true;
1361
1362	$qv['tag_id'] = absint($qv['tag_id']);
1363	if ( !empty($qv['tag_id']) )
1364	$this->is_tag = true;
1365
1366	if ( !is_array($qv['tag__in']) \|\| empty($qv['tag__in']) ) {
1367	$qv['tag__in'] = array();
1368	} else {
1369	$qv['tag__in'] = array_map('absint', $qv['tag__in']);
1370	$this->is_tag = true;
1371	}
1372
1373	if ( !is_array($qv['tag__not_in']) \|\| empty($qv['tag__not_in']) ) {
1374	$qv['tag__not_in'] = array();
1375	} else {
1376	$qv['tag__not_in'] = array_map('absint', $qv['tag__not_in']);
1377	}
1378
1379	if ( !is_array($qv['tag__and']) \|\| empty($qv['tag__and']) ) {
1380	$qv['tag__and'] = array();
1381	} else {
1382	$qv['tag__and'] = array_map('absint', $qv['tag__and']);
1383	$this->is_category = true;
1384	}
1385
1386	if ( !is_array($qv['tag_slug__in']) \|\| empty($qv['tag_slug__in']) ) {
1387	$qv['tag_slug__in'] = array();
1388	} else {
1389	$qv['tag_slug__in'] = array_map('sanitize_title', $qv['tag_slug__in']);
1390	$this->is_tag = true;
1391	}
1392
1393	if ( !is_array($qv['tag_slug__and']) \|\| empty($qv['tag_slug__and']) ) {
1394	$qv['tag_slug__and'] = array();
1395	} else {
1396	$qv['tag_slug__and'] = array_map('sanitize_title', $qv['tag_slug__and']);
1397	$this->is_tag = true;
1398	}
1399
1400	if ( empty($qv['taxonomy']) \|\| empty($qv['term']) ) {
1401	$this->is_tax = false;
1402	foreach ( $GLOBALS['wp_taxonomies'] as $taxonomy => $t ) {
1403	if ( $t->query_var && isset($qv[$t->query_var]) && '' != $qv[$t->query_var] ) {
1404	$qv['taxonomy'] = $taxonomy;
1405	$qv['term'] = $qv[$t->query_var];
1406	$this->is_tax = true;
1407	break;
1408	}
1409	}
1410	} else {
1411	$this->is_tax = true;
1412	}
1413
1414	if ( empty($qv['author']) \|\| ($qv['author'] == '0') ) {
1415	$this->is_author = false;
1416	} else {
1417	$this->is_author = true;
1418	}
1419
1420	if ( '' != $qv['author_name'] ) {
1421	$this->is_author = true;
1422	}
1423
1424	if ( ($this->is_date \|\| $this->is_author \|\| $this->is_category \|\| $this->is_tag \|\| $this->is_tax) )
1425	$this->is_archive = true;
1426	}
1427
1428	if ( '' != $qv['feed'] )
1429	$this->is_feed = true;
1430
1431	if ( '' != $qv['tb'] )
1432	$this->is_trackback = true;
1433
1434	if ( '' != $qv['paged'] )
1435	$this->is_paged = true;
1436
1437	if ( '' != $qv['comments_popup'] )
1438	$this->is_comments_popup = true;
1439
1440	// if we're previewing inside the write screen
1441	if ('' != $qv['preview'])
1442	$this->is_preview = true;
1443
1444	if ( is_admin() )
1445	$this->is_admin = true;
1446
1447	if ( false !== strpos($qv['feed'], 'comments-') ) {
1448	$qv['feed'] = str_replace('comments-', '', $qv['feed']);
1449	$qv['withcomments'] = 1;
1450	}
1451
1452	$this->is_singular = $this->is_single \|\| $this->is_page \|\| $this->is_attachment;
1453
1454	if ( $this->is_feed && ( !empty($qv['withcomments']) \|\| ( empty($qv['withoutcomments']) && $this->is_singular ) ) )
1455	$this->is_comment_feed = true;
1456
1457	if ( !( $this->is_singular \|\| $this->is_archive \|\| $this->is_search \|\| $this->is_feed \|\| $this->is_trackback \|\| $this->is_404 \|\| $this->is_admin \|\| $this->is_comments_popup \|\| $this->is_robots ) )
1458	$this->is_home = true;
1459
1460	// Correct is_* for page_on_front and page_for_posts
1461	if ( $this->is_home && ( empty($this->query) \|\| $qv['preview'] == 'true' ) && 'page' == get_option('show_on_front') && get_option('page_on_front') ) {
1462	$this->is_page = true;
1463	$this->is_home = false;
1464	$qv['page_id'] = get_option('page_on_front');
1465	}
1466
1467	if ( '' != $qv['pagename'] ) {
1468	$this->queried_object =& get_page_by_path($qv['pagename']);
1469	if ( !empty($this->queried_object) )
1470	$this->queried_object_id = (int) $this->queried_object->ID;
1471	else
1472	unset($this->queried_object);
1473
1474	if ( 'page' == get_option('show_on_front') && isset($this->queried_object_id) && $this->queried_object_id == get_option('page_for_posts') ) {
1475	$this->is_page = false;
1476	$this->is_home = true;
1477	$this->is_posts_page = true;
1478	}
1479	}
1480
1481	if ( $qv['page_id'] ) {
1482	if ( 'page' == get_option('show_on_front') && $qv['page_id'] == get_option('page_for_posts') ) {
1483	$this->is_page = false;
1484	$this->is_home = true;
1485	$this->is_posts_page = true;
1486	}
1487	}
1488
1489	if ( !empty($qv['post_type']) )
1490	$qv['post_type'] = sanitize_user($qv['post_type'], true);
1491
1492	if ( !empty($qv['post_status']) )
1493	$qv['post_status'] = preg_replace('\|[^a-z0-9_,-]\|', '', $qv['post_status']);
1494
1495	if ( $this->is_posts_page && ( ! isset($qv['withcomments']) \|\| ! $qv['withcomments'] ) )
1496	$this->is_comment_feed = false;
1497
1498	$this->is_singular = $this->is_single \|\| $this->is_page \|\| $this->is_attachment;
1499	// Done correcting is_* for page_on_front and page_for_posts
1500
1501	if ('404' == $qv['error'])
1502	$this->set_404();
1503
1504	if ( !empty($query) )
1505	do_action_ref_array('parse_query', array(&$this));
1506	}
1507
1508	/**
1509	* Sets the 404 property and saves whether query is feed.
1510	*
1511	* @since 2.0.0
1512	* @access public
1513	*/
1514	function set_404() {
1515	$is_feed = $this->is_feed;
1516
1517	$this->init_query_flags();
1518	$this->is_404 = true;
1519
1520	$this->is_feed = $is_feed;
1521	}
1522
1523	/**
1524	* Retrieve query variable.
1525	*
1526	* @since 1.5.0
1527	* @access public
1528	*
1529	* @param string $query_var Query variable key.
1530	* @return mixed
1531	*/
1532	function get($query_var) {
1533	if (isset($this->query_vars[$query_var])) {
1534	return $this->query_vars[$query_var];
1535	}
1536
1537	return '';
1538	}
1539
1540	/**
1541	* Set query variable.
1542	*
1543	* @since 1.5.0
1544	* @access public
1545	*
1546	* @param string $query_var Query variable key.
1547	* @param mixed $value Query variable value.
1548	*/
1549	function set($query_var, $value) {
1550	$this->query_vars[$query_var] = $value;
1551	}
1552
1553	/**
1554	* Retrieve the posts based on query variables.
1555	*
1556	* There are a few filters and actions that can be used to modify the post
1557	* database query.
1558	*
1559	* @since 1.5.0
1560	* @access public
1561	* @uses do_action_ref_array() Calls 'pre_get_posts' hook before retrieving posts.
1562	*
1563	* @return array List of posts.
1564	*/
1565	function &get_posts() {
1566	global $wpdb, $user_ID;
1567
1568	do_action_ref_array('pre_get_posts', array(&$this));
1569
1570	// Shorthand.
1571	$q = &$this->query_vars;
1572
1573	$q = $this->fill_query_vars($q);
1574
1575	// First let's clear some variables
1576	$distinct = '';
1577	$whichcat = '';
1578	$whichauthor = '';
1579	$whichmimetype = '';
1580	$where = '';
1581	$limits = '';
1582	$join = '';
1583	$search = '';
1584	$groupby = '';
1585	$fields = "$wpdb->posts.*";
1586	$post_status_join = false;
1587	$page = 1;
1588
1589	if ( !isset($q['caller_get_posts']) )
1590	$q['caller_get_posts'] = false;
1591
1592	if ( !isset($q['suppress_filters']) )
1593	$q['suppress_filters'] = false;
1594
1595	if ( !isset($q['post_type']) ) {
1596	if ( $this->is_search )
1597	$q['post_type'] = 'any';
1598	else
1599	$q['post_type'] = 'post';
1600	}
1601	$post_type = $q['post_type'];
1602	if ( !isset($q['posts_per_page']) \|\| $q['posts_per_page'] == 0 )
1603	$q['posts_per_page'] = get_option('posts_per_page');
1604	if ( isset($q['showposts']) && $q['showposts'] ) {
1605	$q['showposts'] = (int) $q['showposts'];
1606	$q['posts_per_page'] = $q['showposts'];
1607	}
1608	if ( (isset($q['posts_per_archive_page']) && $q['posts_per_archive_page'] != 0) && ($this->is_archive \|\| $this->is_search) )
1609	$q['posts_per_page'] = $q['posts_per_archive_page'];
1610	if ( !isset($q['nopaging']) ) {
1611	if ($q['posts_per_page'] == -1) {
1612	$q['nopaging'] = true;
1613	} else {
1614	$q['nopaging'] = false;
1615	}
1616	}
1617	if ( $this->is_feed ) {
1618	$q['posts_per_page'] = get_option('posts_per_rss');
1619	$q['nopaging'] = false;
1620	}
1621	$q['posts_per_page'] = (int) $q['posts_per_page'];
1622	if ( $q['posts_per_page'] < -1 )
1623	$q['posts_per_page'] = abs($q['posts_per_page']);
1624	else if ( $q['posts_per_page'] == 0 )
1625	$q['posts_per_page'] = 1;
1626
1627	if ( !isset($q['comments_per_page']) \|\| $q['comments_per_page'] == 0 )
1628	$q['comments_per_page'] = get_option('comments_per_page');
1629
1630	if ( $this->is_home && (empty($this->query) \|\| $q['preview'] == 'true') && ( 'page' == get_option('show_on_front') ) && get_option('page_on_front') ) {
1631	$this->is_page = true;
1632	$this->is_home = false;
1633	$q['page_id'] = get_option('page_on_front');
1634	}
1635
1636	if (isset($q['page'])) {
1637	$q['page'] = trim($q['page'], '/');
1638	$q['page'] = absint($q['page']);
1639	}
1640
1641	// If a month is specified in the querystring, load that month
1642	if ( $q['m'] ) {
1643	$q['m'] = '' . preg_replace('\|[^0-9]\|', '', $q['m']);
1644	$where .= " AND YEAR($wpdb->posts.post_date)=" . substr($q['m'], 0, 4);
1645	if (strlen($q['m'])>5)
1646	$where .= " AND MONTH($wpdb->posts.post_date)=" . substr($q['m'], 4, 2);
1647	if (strlen($q['m'])>7)
1648	$where .= " AND DAYOFMONTH($wpdb->posts.post_date)=" . substr($q['m'], 6, 2);
1649	if (strlen($q['m'])>9)
1650	$where .= " AND HOUR($wpdb->posts.post_date)=" . substr($q['m'], 8, 2);
1651	if (strlen($q['m'])>11)
1652	$where .= " AND MINUTE($wpdb->posts.post_date)=" . substr($q['m'], 10, 2);
1653	if (strlen($q['m'])>13)
1654	$where .= " AND SECOND($wpdb->posts.post_date)=" . substr($q['m'], 12, 2);
1655	}
1656
1657	if ( '' !== $q['hour'] )
1658	$where .= " AND HOUR($wpdb->posts.post_date)='" . $q['hour'] . "'";
1659
1660	if ( '' !== $q['minute'] )
1661	$where .= " AND MINUTE($wpdb->posts.post_date)='" . $q['minute'] . "'";
1662
1663	if ( '' !== $q['second'] )
1664	$where .= " AND SECOND($wpdb->posts.post_date)='" . $q['second'] . "'";
1665
1666	if ( $q['year'] )
1667	$where .= " AND YEAR($wpdb->posts.post_date)='" . $q['year'] . "'";
1668
1669	if ( $q['monthnum'] )
1670	$where .= " AND MONTH($wpdb->posts.post_date)='" . $q['monthnum'] . "'";
1671
1672	if ( $q['day'] )
1673	$where .= " AND DAYOFMONTH($wpdb->posts.post_date)='" . $q['day'] . "'";
1674
1675	if ('' != $q['name']) {
1676	$q['name'] = sanitize_title($q['name']);
1677	$where .= " AND $wpdb->posts.post_name = '" . $q['name'] . "'";
1678	} else if ('' != $q['pagename']) {
1679	if ( isset($this->queried_object_id) )
1680	$reqpage = $this->queried_object_id;
1681	else {
1682	$reqpage = get_page_by_path($q['pagename']);
1683	if ( !empty($reqpage) )
1684	$reqpage = $reqpage->ID;
1685	else
1686	$reqpage = 0;
1687	}
1688
1689	$page_for_posts = get_option('page_for_posts');
1690	if ( ('page' != get_option('show_on_front') ) \|\| empty($page_for_posts) \|\| ( $reqpage != $page_for_posts ) ) {
1691	$q['pagename'] = str_replace('%2F', '/', urlencode(urldecode($q['pagename'])));
1692	$page_paths = '/' . trim($q['pagename'], '/');
1693	$q['pagename'] = sanitize_title(basename($page_paths));
1694	$q['name'] = $q['pagename'];
1695	$where .= " AND ($wpdb->posts.ID = '$reqpage')";
1696	$reqpage_obj = get_page($reqpage);
1697	if ( is_object($reqpage_obj) && 'attachment' == $reqpage_obj->post_type ) {
1698	$this->is_attachment = true;
1699	$this->is_page = true;
1700	$q['attachment_id'] = $reqpage;
1701	}
1702	}
1703	} elseif ('' != $q['attachment']) {
1704	$q['attachment'] = str_replace('%2F', '/', urlencode(urldecode($q['attachment'])));
1705	$attach_paths = '/' . trim($q['attachment'], '/');
1706	$q['attachment'] = sanitize_title(basename($attach_paths));
1707	$q['name'] = $q['attachment'];
1708	$where .= " AND $wpdb->posts.post_name = '" . $q['attachment'] . "'";
1709	}
1710
1711	if ( $q['w'] )
1712	$where .= " AND WEEK($wpdb->posts.post_date, 1)='" . $q['w'] . "'";
1713
1714	if ( intval($q['comments_popup']) )
1715	$q['p'] = absint($q['comments_popup']);
1716
1717	// If an attachment is requested by number, let it supercede any post number.
1718	if ( $q['attachment_id'] )
1719	$q['p'] = absint($q['attachment_id']);
1720
1721	// If a post number is specified, load that post
1722	if ( $q['p'] ) {
1723	$where .= " AND {$wpdb->posts}.ID = " . $q['p'];
1724	} elseif ( $q['post__in'] ) {
1725	$post__in = implode(',', array_map( 'absint', $q['post__in'] ));
1726	$where .= " AND {$wpdb->posts}.ID IN ($post__in)";
1727	} elseif ( $q['post__not_in'] ) {
1728	$post__not_in = implode(',', array_map( 'absint', $q['post__not_in'] ));
1729	$where .= " AND {$wpdb->posts}.ID NOT IN ($post__not_in)";
1730	}
1731
1732	if ( is_numeric($q['post_parent']) )
1733	$where .= $wpdb->prepare( " AND $wpdb->posts.post_parent = %d ", $q['post_parent'] );
1734
1735	if ( $q['page_id'] ) {
1736	if ( ('page' != get_option('show_on_front') ) \|\| ( $q['page_id'] != get_option('page_for_posts') ) ) {
1737	$q['p'] = $q['page_id'];
1738	$where = " AND {$wpdb->posts}.ID = " . $q['page_id'];
1739	}
1740	}
1741
1742	// If a search pattern is specified, load the posts that match
1743	if ( !empty($q['s']) ) {
1744	// added slashes screw with quote grouping when done early, so done later
1745	$q['s'] = stripslashes($q['s']);
1746	if ( !empty($q['sentence']) ) {
1747	$q['search_terms'] = array($q['s']);
1748	} else {
1749	preg_match_all('/".*?("\|$)\|((?<=[\\s",+])\|^)[^\\s",+]+/', $q['s'], $matches);
1750	$q['search_terms'] = array_map(create_function('$a', 'return trim($a, "\\"\'\\n\\r ");'), $matches[0]);
1751	}
1752	$n = !empty($q['exact']) ? '' : '%';
1753	$searchand = '';
1754	foreach( (array) $q['search_terms'] as $term) {
1755	$term = addslashes_gpc($term);
1756	$search .= "{$searchand}(($wpdb->posts.post_title LIKE '{$n}{$term}{$n}') OR ($wpdb->posts.post_content LIKE '{$n}{$term}{$n}'))";
1757	$searchand = ' AND ';
1758	}
1759	$term = $wpdb->escape($q['s']);
1760	if (empty($q['sentence']) && count($q['search_terms']) > 1 && $q['search_terms'][0] != $q['s'] )
1761	$search .= " OR ($wpdb->posts.post_title LIKE '{$n}{$term}{$n}') OR ($wpdb->posts.post_content LIKE '{$n}{$term}{$n}')";
1762
1763	if ( !empty($search) ) {
1764	$search = " AND ({$search}) ";
1765	if ( !is_user_logged_in() )
1766	$search .= " AND ($wpdb->posts.post_password = '') ";
1767	}
1768	}
1769
1770	// Category stuff
1771
1772	if ( empty($q['cat']) \|\| ($q['cat'] == '0') \|\|
1773	// Bypass cat checks if fetching specific posts
1774	$this->is_singular ) {
1775	$whichcat = '';
1776	} else {
1777	$q['cat'] = ''.urldecode($q['cat']).'';
1778	$q['cat'] = addslashes_gpc($q['cat']);
1779	$cat_array = preg_split('/[,\s]+/', $q['cat']);
1780	$q['cat'] = '';
1781	$req_cats = array();
1782	foreach ( (array) $cat_array as $cat ) {
1783	$cat = intval($cat);
1784	$req_cats[] = $cat;
1785	$in = ($cat > 0);
1786	$cat = abs($cat);
1787	if ( $in ) {
1788	$q['category__in'][] = $cat;
1789	$q['category__in'] = array_merge($q['category__in'], get_term_children($cat, 'category'));
1790	} else {
1791	$q['category__not_in'][] = $cat;
1792	$q['category__not_in'] = array_merge($q['category__not_in'], get_term_children($cat, 'category'));
1793	}
1794	}
1795	$q['cat'] = implode(',', $req_cats);
1796	}
1797
1798	if ( !empty($q['category__in']) ) {
1799	$join = " INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ";
1800	$whichcat .= " AND $wpdb->term_taxonomy.taxonomy = 'category' ";
1801	$include_cats = "'" . implode("', '", $q['category__in']) . "'";
1802	$whichcat .= " AND $wpdb->term_taxonomy.term_id IN ($include_cats) ";
1803	}
1804
1805	if ( !empty($q['category__not_in']) ) {
1806	if ( $wpdb->has_cap( 'subqueries' ) ) {
1807	$cat_string = "'" . implode("', '", $q['category__not_in']) . "'";
1808	$whichcat .= " AND $wpdb->posts.ID NOT IN ( SELECT tr.object_id FROM $wpdb->term_relationships AS tr INNER JOIN $wpdb->term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy = 'category' AND tt.term_id IN ($cat_string) )";
1809	} else {
1810	$ids = get_objects_in_term($q['category__not_in'], 'category');
1811	if ( !is_wp_error($ids) && is_array($ids) && count($ids) > 0 )
1812	$whichcat .= " AND $wpdb->posts.ID NOT IN ('" . implode("', '", $ids) . "')";
1813	}
1814	}
1815
1816	// Category stuff for nice URLs
1817	if ( '' != $q['category_name'] && !$this->is_singular ) {
1818	$q['category_name'] = implode('/', array_map('sanitize_title', explode('/', $q['category_name'])));
1819	$reqcat = get_category_by_path($q['category_name']);
1820	$q['category_name'] = str_replace('%2F', '/', urlencode(urldecode($q['category_name'])));
1821	$cat_paths = '/' . trim($q['category_name'], '/');
1822	$q['category_name'] = sanitize_title(basename($cat_paths));
1823
1824	$cat_paths = '/' . trim(urldecode($q['category_name']), '/');
1825	$q['category_name'] = sanitize_title(basename($cat_paths));
1826	$cat_paths = explode('/', $cat_paths);
1827	$cat_path = '';
1828	foreach ( (array) $cat_paths as $pathdir )
1829	$cat_path .= ( $pathdir != '' ? '/' : '' ) . sanitize_title($pathdir);
1830
1831	//if we don't match the entire hierarchy fallback on just matching the nicename
1832	if ( empty($reqcat) )
1833	$reqcat = get_category_by_path($q['category_name'], false);
1834
1835	if ( !empty($reqcat) )
1836	$reqcat = $reqcat->term_id;
1837	else
1838	$reqcat = 0;
1839
1840	$q['cat'] = $reqcat;
1841
1842	$join = " INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ";
1843	$whichcat = " AND $wpdb->term_taxonomy.taxonomy = 'category' ";
1844	$in_cats = array($q['cat']);
1845	$in_cats = array_merge($in_cats, get_term_children($q['cat'], 'category'));
1846	$in_cats = "'" . implode("', '", $in_cats) . "'";
1847	$whichcat .= "AND $wpdb->term_taxonomy.term_id IN ($in_cats)";
1848	$groupby = "{$wpdb->posts}.ID";
1849	}
1850
1851	// Tags
1852	if ( '' != $q['tag'] ) {
1853	if ( strpos($q['tag'], ',') !== false ) {
1854	$tags = preg_split('/[,\s]+/', $q['tag']);
1855	foreach ( (array) $tags as $tag ) {
1856	$tag = sanitize_term_field('slug', $tag, 0, 'post_tag', 'db');
1857	$q['tag_slug__in'][] = $tag;
1858	}
1859	} else if ( preg_match('/[+\s]+/', $q['tag']) \|\| !empty($q['cat']) ) {
1860	$tags = preg_split('/[+\s]+/', $q['tag']);
1861	foreach ( (array) $tags as $tag ) {
1862	$tag = sanitize_term_field('slug', $tag, 0, 'post_tag', 'db');
1863	$q['tag_slug__and'][] = $tag;
1864	}
1865	} else {
1866	$q['tag'] = sanitize_term_field('slug', $q['tag'], 0, 'post_tag', 'db');
1867	$q['tag_slug__in'][] = $q['tag'];
1868	}
1869	}
1870
1871	if ( !empty($q['category__in']) \|\| !empty($q['meta_key']) \|\| !empty($q['tag__in']) \|\| !empty($q['tag_slug__in']) ) {
1872	$groupby = "{$wpdb->posts}.ID";
1873	}
1874
1875	if ( !empty($q['tag__in']) && empty($q['cat']) ) {
1876	$join = " INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) ";
1877	$whichcat .= " AND $wpdb->term_taxonomy.taxonomy = 'post_tag' ";
1878	$include_tags = "'" . implode("', '", $q['tag__in']) . "'";
1879	$whichcat .= " AND $wpdb->term_taxonomy.term_id IN ($include_tags) ";
1880	$reqtag = is_term( $q['tag__in'][0], 'post_tag' );
1881	if ( !empty($reqtag) )
1882	$q['tag_id'] = $reqtag['term_id'];
1883	}
1884
1885	if ( !empty($q['tag_slug__in']) && empty($q['cat']) ) {
1886	$join = " INNER JOIN $wpdb->term_relationships ON ($wpdb->posts.ID = $wpdb->term_relationships.object_id) INNER JOIN $wpdb->term_taxonomy ON ($wpdb->term_relationships.term_taxonomy_id = $wpdb->term_taxonomy.term_taxonomy_id) INNER JOIN $wpdb->terms ON ($wpdb->term_taxonomy.term_id = $wpdb->terms.term_id) ";
1887	$whichcat .= " AND $wpdb->term_taxonomy.taxonomy = 'post_tag' ";
1888	$include_tags = "'" . implode("', '", $q['tag_slug__in']) . "'";
1889	$whichcat .= " AND $wpdb->terms.slug IN ($include_tags) ";
1890	$reqtag = get_term_by( 'slug', $q['tag_slug__in'][0], 'post_tag' );
1891	if ( !empty($reqtag) )
1892	$q['tag_id'] = $reqtag->term_id;
1893	}
1894
1895	if ( !empty($q['tag__not_in']) ) {
1896	if ( $wpdb->has_cap( 'subqueries' ) ) {
1897	$tag_string = "'" . implode("', '", $q['tag__not_in']) . "'";
1898	$whichcat .= " AND $wpdb->posts.ID NOT IN ( SELECT tr.object_id FROM $wpdb->term_relationships AS tr INNER JOIN $wpdb->term_taxonomy AS tt ON tr.term_taxonomy_id = tt.term_taxonomy_id WHERE tt.taxonomy = 'post_tag' AND tt.term_id IN ($tag_string) )";
1899	} else {
1900	$ids = get_objects_in_term($q['tag__not_in'], 'post_tag');
1901	if ( !is_wp_error($ids) && is_array($ids) && count($ids) > 0 )
1902	$whichcat .= " AND $wpdb->posts.ID NOT IN ('" . implode("', '", $ids) . "')";
1903	}
1904	}
1905
1906	// Tag and slug intersections.
1907	$intersections = array('category__and' => 'category', 'tag__and' => 'post_tag', 'tag_slug__and' => 'post_tag', 'tag__in' => 'post_tag', 'tag_slug__in' => 'post_tag');
1908	$tagin = array('tag__in', 'tag_slug__in'); // These are used to make some exceptions below
1909	foreach ($intersections as $item => $taxonomy) {
1910	if ( empty($q[$item]) ) continue;
1911	if ( in_array($item, $tagin) && empty($q['cat']) ) continue; // We should already have what we need if categories aren't being used
1912
1913	if ( $item != 'category__and' ) {
1914	$reqtag = is_term( $q[$item][0], 'post_tag' );
1915	if ( !empty($reqtag) )
1916	$q['tag_id'] = $reqtag['term_id'];
1917	}
1918
1919	if ( in_array( $item, array('tag_slug__and', 'tag_slug__in' ) ) )
1920	$taxonomy_field = 'slug';
1921	else
1922	$taxonomy_field = 'term_id';
1923
1924	$q[$item] = array_unique($q[$item]);
1925	$tsql = "SELECT p.ID FROM $wpdb->posts p INNER JOIN $wpdb->term_relationships tr ON (p.ID = tr.object_id) INNER JOIN $wpdb->term_taxonomy tt ON (tr.term_taxonomy_id = tt.term_taxonomy_id) INNER JOIN $wpdb->terms t ON (tt.term_id = t.term_id)";
1926	$tsql .= " WHERE tt.taxonomy = '$taxonomy' AND t.$taxonomy_field IN ('" . implode("', '", $q[$item]) . "')";
1927	if ( !in_array($item, $tagin) ) { // This next line is only helpful if we are doing an and relationship
1928	$tsql .= " GROUP BY p.ID HAVING count(p.ID) = " . count($q[$item]);
1929	}
1930	$post_ids = $wpdb->get_col($tsql);
1931
1932	if ( count($post_ids) )
1933	$whichcat .= " AND $wpdb->posts.ID IN (" . implode(', ', $post_ids) . ") ";
1934	else {
1935	$whichcat = " AND 0 = 1";
1936	break;
1937	}
1938	}
1939
1940	// Taxonomies
1941	if ( $this->is_tax ) {
1942	if ( '' != $q['taxonomy'] ) {
1943	$taxonomy = $q['taxonomy'];
1944	$tt[$taxonomy] = $q['term'];
1945	$terms = get_terms($q['taxonomy'], array('slug'=>$q['term']));
1946	} else {
1947	foreach ( $GLOBALS['wp_taxonomies'] as $taxonomy => $t ) {
1948	if ( $t->query_var && '' != $q[$t->query_var] ) {
1949	$terms = get_terms($taxonomy, array('slug'=>$q[$t->query_var]));
1950	if ( !is_wp_error($terms) )
1951	break;
1952	}
1953	}
1954	}
1955	if ( is_wp_error($terms) \|\| empty($terms) ) {
1956	$whichcat = " AND 0 ";
1957	} else {
1958	foreach ( $terms as $term )
1959	$term_ids[] = $term->term_id;
1960	$post_ids = get_objects_in_term($term_ids, $taxonomy);
1961	if ( !is_wp_error($post_ids) && count($post_ids) ) {
1962	$whichcat .= " AND $wpdb->posts.ID IN (" . implode(', ', $post_ids) . ") ";
1963	$post_type = 'any';
1964	$q['post_status'] = 'publish';
1965	$post_status_join = true;
1966	} else {
1967	$whichcat = " AND 0 ";
1968	}
1969	}
1970	}
1971
1972	// Author/user stuff
1973
1974	if ( empty($q['author']) \|\| ($q['author'] == '0') ) {
1975	$whichauthor='';
1976	} else {
1977	$q['author'] = ''.urldecode($q['author']).'';
1978	$q['author'] = addslashes_gpc($q['author']);
1979	if (strpos($q['author'], '-') !== false) {
1980	$eq = '!=';
1981	$andor = 'AND';
1982	$q['author'] = explode('-', $q['author']);
1983	$q['author'] = '' . absint($q['author'][1]);
1984	} else {
1985	$eq = '=';
1986	$andor = 'OR';
1987	}
1988	$author_array = preg_split('/[,\s]+/', $q['author']);
1989	$whichauthor .= " AND ($wpdb->posts.post_author ".$eq.' '.absint($author_array[0]);
1990	for ($i = 1; $i < (count($author_array)); $i = $i + 1) {
1991	$whichauthor .= ' '.$andor." $wpdb->posts.post_author ".$eq.' '.absint($author_array[$i]);
1992	}
1993	$whichauthor .= ')';
1994	}
1995
1996	// Author stuff for nice URLs
1997
1998	if ('' != $q['author_name']) {
1999	if (strpos($q['author_name'], '/') !== false) {
2000	$q['author_name'] = explode('/',$q['author_name']);
2001	if ($q['author_name'][count($q['author_name'])-1]) {
2002	$q['author_name'] = $q['author_name'][count($q['author_name'])-1];#no trailing slash
2003	} else {
2004	$q['author_name'] = $q['author_name'][count($q['author_name'])-2];#there was a trailling slash
2005	}
2006	}
2007	$q['author_name'] = sanitize_title($q['author_name']);
2008	$q['author'] = $wpdb->get_var("SELECT ID FROM $wpdb->users WHERE user_nicename='".$q['author_name']."'");
2009	$q['author'] = get_user_by('slug', $q['author_name']);
2010	if ( $q['author'] )
2011	$q['author'] = $q['author']->ID;
2012	$whichauthor .= " AND ($wpdb->posts.post_author = ".absint($q['author']).')';
2013	}
2014
2015	// MIME-Type stuff for attachment browsing
2016
2017	if ( isset($q['post_mime_type']) && '' != $q['post_mime_type'] )
2018	$whichmimetype = wp_post_mime_type_where($q['post_mime_type']);
2019
2020	$where .= $search.$whichcat.$whichauthor.$whichmimetype;
2021
2022	if ( empty($q['order']) \|\| ((strtoupper($q['order']) != 'ASC') && (strtoupper($q['order']) != 'DESC')) )
2023	$q['order'] = 'DESC';
2024
2025	// Order by
2026	if ( empty($q['orderby']) ) {
2027	$q['orderby'] = "$wpdb->posts.post_date ".$q['order'];
2028	} elseif ( 'none' == $q['orderby'] ) {
2029	$q['orderby'] = '';
2030	} else {
2031	// Used to filter values
2032	$allowed_keys = array('author', 'date', 'title', 'modified', 'menu_order', 'parent', 'ID', 'rand');
2033	if ( !empty($q['meta_key']) ) {
2034	$allowed_keys[] = $q['meta_key'];
2035	$allowed_keys[] = 'meta_value';
2036	}
2037	$q['orderby'] = urldecode($q['orderby']);
2038	$q['orderby'] = addslashes_gpc($q['orderby']);
2039	$orderby_array = explode(' ',$q['orderby']);
2040	if ( empty($orderby_array) )
2041	$orderby_array[] = $q['orderby'];
2042	$q['orderby'] = '';
2043	for ($i = 0; $i < count($orderby_array); $i++) {
2044	// Only allow certain values for safety
2045	$orderby = $orderby_array[$i];
2046	switch ($orderby) {
2047	case 'menu_order':
2048	break;
2049	case 'ID':
2050	$orderby = "$wpdb->posts.ID";
2051	break;
2052	case 'rand':
2053	$orderby = 'RAND()';
2054	break;
2055	case $q['meta_key']:
2056	case 'meta_value':
2057	$orderby = "$wpdb->postmeta.meta_value";
2058	break;
2059	default:
2060	$orderby = "$wpdb->posts.post_" . $orderby;
2061	}
2062	if ( in_array($orderby_array[$i], $allowed_keys) )
2063	$q['orderby'] .= (($i == 0) ? '' : ',') . $orderby;
2064	}
2065	// append ASC or DESC at the end
2066	if ( !empty($q['orderby']))
2067	$q['orderby'] .= " {$q['order']}";
2068
2069	if ( empty($q['orderby']) )
2070	$q['orderby'] = "$wpdb->posts.post_date ".$q['order'];
2071	}
2072
2073	if ( 'any' == $post_type ) {
2074	$where .= " AND $wpdb->posts.post_type != 'revision'";
2075	} elseif ( $this->is_attachment ) {
2076	$where .= " AND $wpdb->posts.post_type = 'attachment'";
2077	} elseif ($this->is_page) {
2078	$where .= " AND $wpdb->posts.post_type = 'page'";
2079	} elseif ($this->is_single) {
2080	$where .= " AND $wpdb->posts.post_type = 'post'";
2081	} else {
2082	$where .= " AND $wpdb->posts.post_type = '$post_type'";
2083	}
2084
2085	if ( isset($q['post_status']) && '' != $q['post_status'] ) {
2086	$statuswheres = array();
2087	$q_status = explode(',', $q['post_status']);
2088	$r_status = array();
2089	$p_status = array();
2090	if ( in_array( 'draft' , $q_status ) )
2091	$r_status[] = "$wpdb->posts.post_status = 'draft'";
2092	if ( in_array( 'pending', $q_status ) )
2093	$r_status[] = "$wpdb->posts.post_status = 'pending'";
2094	if ( in_array( 'future' , $q_status ) )
2095	$r_status[] = "$wpdb->posts.post_status = 'future'";
2096	if ( in_array( 'inherit' , $q_status ) )
2097	$r_status[] = "$wpdb->posts.post_status = 'inherit'";
2098	if ( in_array( 'private', $q_status ) )
2099	$p_status[] = "$wpdb->posts.post_status = 'private'";
2100	if ( in_array( 'publish', $q_status ) )
2101	$r_status[] = "$wpdb->posts.post_status = 'publish'";
2102
2103	if ( empty($q['perm'] ) \|\| 'readable' != $q['perm'] ) {
2104	$r_status = array_merge($r_status, $p_status);
2105	unset($p_status);
2106	}
2107
2108	if ( !empty($r_status) ) {
2109	if ( !empty($q['perm'] ) && 'editable' == $q['perm'] && !current_user_can("edit_others_{$post_type}s") )
2110	$statuswheres[] = "($wpdb->posts.post_author = $user_ID " . "AND (" . join( ' OR ', $r_status ) . "))";
2111	else
2112	$statuswheres[] = "(" . join( ' OR ', $r_status ) . ")";
2113	}
2114	if ( !empty($p_status) ) {
2115	if ( !empty($q['perm'] ) && 'readable' == $q['perm'] && !current_user_can("read_private_{$post_type}s") )
2116	$statuswheres[] = "($wpdb->posts.post_author = $user_ID " . "AND (" . join( ' OR ', $p_status ) . "))";
2117	else
2118	$statuswheres[] = "(" . join( ' OR ', $p_status ) . ")";
2119	}
2120	if ( $post_status_join ) {
2121	$join .= " LEFT JOIN $wpdb->posts AS p2 ON ($wpdb->posts.post_parent = p2.ID) ";
2122	foreach ( $statuswheres as $index => $statuswhere )
2123	$statuswheres[$index] = "($statuswhere OR ($wpdb->posts.post_status = 'inherit' AND " . str_replace($wpdb->posts, 'p2', $statuswhere) . "))";
2124	}
2125	foreach ( $statuswheres as $statuswhere )
2126	$where .= " AND $statuswhere";
2127	} elseif ( !$this->is_singular ) {
2128	$where .= " AND ($wpdb->posts.post_status = 'publish'";
2129
2130	if ( is_admin() )
2131	$where .= " OR $wpdb->posts.post_status = 'future' OR $wpdb->posts.post_status = 'draft' OR $wpdb->posts.post_status = 'pending'";
2132
2133	if ( is_user_logged_in() ) {
2134	$where .= current_user_can( "read_private_{$post_type}s" ) ? " OR $wpdb->posts.post_status = 'private'" : " OR $wpdb->posts.post_author = $user_ID AND $wpdb->posts.post_status = 'private'";
2135	}
2136
2137	$where .= ')';
2138	}
2139
2140	// postmeta queries
2141	if ( ! empty($q['meta_key']) \|\| ! empty($q['meta_value']) )
2142	$join .= " JOIN $wpdb->postmeta ON ($wpdb->posts.ID = $wpdb->postmeta.post_id) ";
2143	if ( ! empty($q['meta_key']) )
2144	$where .= $wpdb->prepare(" AND $wpdb->postmeta.meta_key = %s ", $q['meta_key']);
2145	if ( ! empty($q['meta_value']) ) {
2146	if ( ! isset($q['meta_compare']) \|\| empty($q['meta_compare']) \|\| ! in_array($q['meta_compare'], array('=', '!=', '>', '>=', '<', '<=')) )
2147	$q['meta_compare'] = '=';
2148
2149	$where .= $wpdb->prepare("AND $wpdb->postmeta.meta_value {$q['meta_compare']} %s ", $q['meta_value']);
2150	}
2151
2152	// Apply filters on where and join prior to paging so that any
2153	// manipulations to them are reflected in the paging by day queries.
2154	if ( !$q['suppress_filters'] ) {
2155	$where = apply_filters('posts_where', $where);
2156	$join = apply_filters('posts_join', $join);
2157	}
2158
2159	// Paging
2160	if ( empty($q['nopaging']) && !$this->is_singular ) {
2161	$page = absint($q['paged']);
2162	if (empty($page)) {
2163	$page = 1;
2164	}
2165
2166	if ( empty($q['offset']) ) {
2167	$pgstrt = '';
2168	$pgstrt = ($page - 1) * $q['posts_per_page'] . ', ';
2169	$limits = 'LIMIT '.$pgstrt.$q['posts_per_page'];
2170	} else { // we're ignoring $page and using 'offset'
2171	$q['offset'] = absint($q['offset']);
2172	$pgstrt = $q['offset'] . ', ';
2173	$limits = 'LIMIT ' . $pgstrt . $q['posts_per_page'];
2174	}
2175	}
2176
2177	// Comments feeds
2178	if ( $this->is_comment_feed && ( $this->is_archive \|\| $this->is_search \|\| !$this->is_singular ) ) {
2179	if ( $this->is_archive \|\| $this->is_search ) {
2180	$cjoin = "JOIN $wpdb->posts ON ($wpdb->comments.comment_post_ID = $wpdb->posts.ID) $join ";
2181	$cwhere = "WHERE comment_approved = '1' $where";
2182	$cgroupby = "$wpdb->comments.comment_id";
2183	} else { // Other non singular e.g. front
2184	$cjoin = "JOIN $wpdb->posts ON ( $wpdb->comments.comment_post_ID = $wpdb->posts.ID )";
2185	$cwhere = "WHERE post_status = 'publish' AND comment_approved = '1'";
2186	$cgroupby = '';
2187	}
2188
2189	if ( !$q['suppress_filters'] ) {
2190	$cjoin = apply_filters('comment_feed_join', $cjoin);
2191	$cwhere = apply_filters('comment_feed_where', $cwhere);
2192	$cgroupby = apply_filters('comment_feed_groupby', $cgroupby);
2193	$corderby = apply_filters('comment_feed_orderby', 'comment_date_gmt DESC');
2194	$climits = apply_filters('comment_feed_limits', 'LIMIT ' . get_option('posts_per_rss'));
2195	}
2196	$cgroupby = ( ! empty( $cgroupby ) ) ? 'GROUP BY ' . $cgroupby : '';
2197	$corderby = ( ! empty( $corderby ) ) ? 'ORDER BY ' . $corderby : '';
2198
2199	$this->comments = (array) $wpdb->get_results("SELECT $distinct $wpdb->comments.* FROM $wpdb->comments $cjoin $cwhere $cgroupby $corderby $climits");
2200	$this->comment_count = count($this->comments);
2201
2202	$post_ids = array();
2203
2204	foreach ($this->comments as $comment)
2205	$post_ids[] = (int) $comment->comment_post_ID;
2206
2207	$post_ids = join(',', $post_ids);
2208	$join = '';
2209	if ( $post_ids )
2210	$where = "AND $wpdb->posts.ID IN ($post_ids) ";
2211	else
2212	$where = "AND 0";
2213	}
2214
2215	$orderby = $q['orderby'];
2216
2217	// Apply post-paging filters on where and join. Only plugins that
2218	// manipulate paging queries should use these hooks.
2219	if ( !$q['suppress_filters'] ) {
2220	$where = apply_filters('posts_where_paged', $where);
2221	$groupby = apply_filters('posts_groupby', $groupby);
2222	$join = apply_filters('posts_join_paged', $join);
2223	$orderby = apply_filters('posts_orderby', $orderby);
2224	$distinct = apply_filters('posts_distinct', $distinct);
2225	$limits = apply_filters( 'post_limits', $limits );
2226
2227	$fields = apply_filters('posts_fields', $fields);
2228	}
2229
2230	// Announce current selection parameters. For use by caching plugins.
2231	do_action( 'posts_selection', $where . $groupby . $orderby . $limits . $join );
2232
2233	// Filter again for the benefit of caching plugins. Regular plugins should use the hooks above.
2234	if ( !$q['suppress_filters'] ) {
2235	$where = apply_filters('posts_where_request', $where);
2236	$groupby = apply_filters('posts_groupby_request', $groupby);
2237	$join = apply_filters('posts_join_request', $join);
2238	$orderby = apply_filters('posts_orderby_request', $orderby);
2239	$distinct = apply_filters('posts_distinct_request', $distinct);
2240	$fields = apply_filters('posts_fields_request', $fields);
2241	$limits = apply_filters( 'post_limits_request', $limits );
2242	}
2243
2244	if ( ! empty($groupby) )
2245	$groupby = 'GROUP BY ' . $groupby;
2246	if ( !empty( $orderby ) )
2247	$orderby = 'ORDER BY ' . $orderby;
2248	$found_rows = '';
2249	if ( !empty($limits) )
2250	$found_rows = 'SQL_CALC_FOUND_ROWS';
2251
2252	//////// BELOW CODE MODIFIED BY DAVE BUCHANAN, SPLIT INTO TWO QUERIES /////////////////////
2253	/// FIRST SELECT JUST IDs
2254	$tmp = " SELECT $distinct $wpdb->posts.id FROM $wpdb->posts $join WHERE 1=1 $where $groupby $orderby $limits";
2255	$tmp_q = $wpdb->get_col($tmp);
2256	$tmp_ids = implode($tmp_q,',');
2257
2258	/// NOW NORMAL SELECT WHERE ID IS IN FIRST QUERY LIST
2259	$this->request = " SELECT $found_rows $distinct $fields FROM $wpdb->posts $join WHERE $wpdb->posts.id IN ($tmp_ids) $groupby $orderby ";
2260
2261	////OLD ONE ///$this->request = " SELECT $found_rows $distinct $fields FROM $wpdb->posts $join WHERE 1=1 $where $groupby $orderby $limits";
2262
2263	if ( !$q['suppress_filters'] )
2264	$this->request = apply_filters('posts_request', $this->request);
2265
2266	$this->posts = $wpdb->get_results($this->request);
2267	// Raw results filter. Prior to status checks.
2268	if ( !$q['suppress_filters'] )
2269	$this->posts = apply_filters('posts_results', $this->posts);
2270
2271	if ( !empty($this->posts) && $this->is_comment_feed && $this->is_singular ) {
2272	$cjoin = apply_filters('comment_feed_join', '');
2273	$cwhere = apply_filters('comment_feed_where', "WHERE comment_post_ID = '{$this->posts[0]->ID}' AND comment_approved = '1'");
2274	$cgroupby = apply_filters('comment_feed_groupby', '');
2275	$cgroupby = ( ! empty( $cgroupby ) ) ? 'GROUP BY ' . $cgroupby : '';
2276	$corderby = apply_filters('comment_feed_orderby', 'comment_date_gmt DESC');
2277	$corderby = ( ! empty( $corderby ) ) ? 'ORDER BY ' . $corderby : '';
2278	$climits = apply_filters('comment_feed_limits', 'LIMIT ' . get_option('posts_per_rss'));
2279	$comments_request = "SELECT $wpdb->comments.* FROM $wpdb->comments $cjoin $cwhere $cgroupby $corderby $climits";
2280	$this->comments = $wpdb->get_results($comments_request);
2281	$this->comment_count = count($this->comments);
2282	}
2283
2284	if ( !empty($limits) ) {
2285	////OLD ONE///$found_posts_query = apply_filters( 'found_posts_query', 'SELECT FOUND_ROWS()' );
2286	////Dave Buchanan Changed below
2287	$found_posts_query = " SELECT $distinct count($wpdb->posts.id) FROM $wpdb->posts $join WHERE 1=1 $where";
2288	$this->found_posts = $wpdb->get_var( $found_posts_query );
2289	$this->found_posts = apply_filters( 'found_posts', $this->found_posts );
2290	$this->max_num_pages = ceil($this->found_posts / $q['posts_per_page']);
2291	}
2292
2293	// Check post status to determine if post should be displayed.
2294	if ( !empty($this->posts) && ($this->is_single \|\| $this->is_page) ) {
2295	$status = get_post_status($this->posts[0]);
2296	//$type = get_post_type($this->posts[0]);
2297	if ( ('publish' != $status) ) {
2298	if ( ! is_user_logged_in() ) {
2299	// User must be logged in to view unpublished posts.
2300	$this->posts = array();
2301	} else {
2302	if (in_array($status, array('draft', 'pending')) ) {
2303	// User must have edit permissions on the draft to preview.
2304	if (! current_user_can('edit_post', $this->posts[0]->ID)) {
2305	$this->posts = array();
2306	} else {
2307	$this->is_preview = true;
2308	$this->posts[0]->post_date = current_time('mysql');
2309	}
2310	} else if ('future' == $status) {
2311	$this->is_preview = true;
2312	if (!current_user_can('edit_post', $this->posts[0]->ID)) {
2313	$this->posts = array ( );
2314	}
2315	} else {
2316	if (! current_user_can('read_post', $this->posts[0]->ID))
2317	$this->posts = array();
2318	}
2319	}
2320	}
2321
2322	if ( $this->is_preview && current_user_can( "edit_{$post_type}", $this->posts[0]->ID ) )
2323	$this->posts[0] = apply_filters('the_preview', $this->posts[0]);
2324	}
2325
2326	// Put sticky posts at the top of the posts array
2327	$sticky_posts = get_option('sticky_posts');
2328	if ( $this->is_home && $page <= 1 && is_array($sticky_posts) && !empty($sticky_posts) && !$q['caller_get_posts'] ) {
2329	$num_posts = count($this->posts);
2330	$sticky_offset = 0;
2331	// Loop over posts and relocate stickies to the front.
2332	for ( $i = 0; $i < $num_posts; $i++ ) {
2333	if ( in_array($this->posts[$i]->ID, $sticky_posts) ) {
2334	$sticky_post = $this->posts[$i];
2335	// Remove sticky from current position
2336	array_splice($this->posts, $i, 1);
2337	// Move to front, after other stickies
2338	array_splice($this->posts, $sticky_offset, 0, array($sticky_post));
2339	// Increment the sticky offset. The next sticky will be placed at this offset.
2340	$sticky_offset++;
2341	// Remove post from sticky posts array
2342	$offset = array_search($sticky_post->ID, $sticky_posts);
2343	array_splice($sticky_posts, $offset, 1);
2344	}
2345	}
2346
2347	// Fetch sticky posts that weren't in the query results
2348	if ( !empty($sticky_posts) ) {
2349	$stickies__in = implode(',', array_map( 'absint', $sticky_posts ));
2350	$stickies = $wpdb->get_results( "SELECT * FROM $wpdb->posts WHERE $wpdb->posts.ID IN ($stickies__in)" );
2351	/** @todo Make sure post is published or viewable by the current user */
2352	foreach ( $stickies as $sticky_post ) {
2353	if ( 'publish' != $sticky_post->post_status )
2354	continue;
2355	array_splice($this->posts, $sticky_offset, 0, array($sticky_post));
2356	$sticky_offset++;
2357	}
2358	}
2359	}
2360
2361	if ( !$q['suppress_filters'] )
2362	$this->posts = apply_filters('the_posts', $this->posts);
2363
2364	update_post_caches($this->posts);
2365
2366	$this->post_count = count($this->posts);
2367	if ($this->post_count > 0) {
2368	$this->post = $this->posts[0];
2369	}
2370
2371	return $this->posts;
2372	}
2373
2374	/**
2375	* Setup the next post and iterate current post index.
2376	*
2377	* @since 1.5.0
2378	* @access public
2379	*
2380	* @return object Next post.
2381	*/
2382	function next_post() {
2383
2384	$this->current_post++;
2385
2386	$this->post = $this->posts[$this->current_post];
2387	return $this->post;
2388	}
2389
2390	/**
2391	* Sets up the current post.
2392	*
2393	* Retrieves the next post, sets up the post, sets the 'in the loop'
2394	* property to true.
2395	*
2396	* @since 1.5.0
2397	* @access public
2398	* @uses $post
2399	* @uses do_action_ref_array() Calls 'loop_start' if loop has just started
2400	*/
2401	function the_post() {
2402	global $post;
2403	$this->in_the_loop = true;
2404
2405	if ( $this->current_post == -1 ) // loop has just started
2406	do_action_ref_array('loop_start', array(&$this));
2407
2408	$post = $this->next_post();
2409	setup_postdata($post);
2410	}
2411
2412	/**
2413	* Whether there are more posts available in the loop.
2414	*
2415	* Calls action 'loop_end', when the loop is complete.
2416	*
2417	* @since 1.5.0
2418	* @access public
2419	* @uses do_action_ref_array() Calls 'loop_end' if loop is ended
2420	*
2421	* @return bool True if posts are available, false if end of loop.
2422	*/
2423	function have_posts() {
2424	if ($this->current_post + 1 < $this->post_count) {
2425	return true;
2426	} elseif ($this->current_post + 1 == $this->post_count && $this->post_count > 0) {
2427	do_action_ref_array('loop_end', array(&$this));
2428	// Do some cleaning up after the loop
2429	$this->rewind_posts();
2430	}
2431
2432	$this->in_the_loop = false;
2433	return false;
2434	}
2435
2436	/**
2437	* Rewind the posts and reset post index.
2438	*
2439	* @since 1.5.0
2440	* @access public
2441	*/
2442	function rewind_posts() {
2443	$this->current_post = -1;
2444	if ($this->post_count > 0) {
2445	$this->post = $this->posts[0];
2446	}
2447	}
2448
2449	/**
2450	* Iterate current comment index and return comment object.
2451	*
2452	* @since 2.2.0
2453	* @access public
2454	*
2455	* @return object Comment object.
2456	*/
2457	function next_comment() {
2458	$this->current_comment++;
2459
2460	$this->comment = $this->comments[$this->current_comment];
2461	return $this->comment;
2462	}
2463
2464	/**
2465	* Sets up the current comment.
2466	*
2467	* @since 2.2.0
2468	* @access public
2469	* @global object $comment Current comment.
2470	* @uses do_action() Calls 'comment_loop_start' hook when first comment is processed.
2471	*/
2472	function the_comment() {
2473	global $comment;
2474
2475	$comment = $this->next_comment();
2476
2477	if ($this->current_comment == 0) {
2478	do_action('comment_loop_start');
2479	}
2480	}
2481
2482	/**
2483	* Whether there are more comments available.
2484	*
2485	* Automatically rewinds comments when finished.
2486	*
2487	* @since 2.2.0
2488	* @access public
2489	*
2490	* @return bool True, if more comments. False, if no more posts.
2491	*/
2492	function have_comments() {
2493	if ($this->current_comment + 1 < $this->comment_count) {
2494	return true;
2495	} elseif ($this->current_comment + 1 == $this->comment_count) {
2496	$this->rewind_comments();
2497	}
2498
2499	return false;
2500	}
2501
2502	/**
2503	* Rewind the comments, resets the comment index and comment to first.
2504	*
2505	* @since 2.2.0
2506	* @access public
2507	*/
2508	function rewind_comments() {
2509	$this->current_comment = -1;
2510	if ($this->comment_count > 0) {
2511	$this->comment = $this->comments[0];
2512	}
2513	}
2514
2515	/**
2516	* Sets up the WordPress query by parsing query string.
2517	*
2518	* @since 1.5.0
2519	* @access public
2520	*
2521	* @param string $query URL query string.
2522	* @return array List of posts.
2523	*/
2524	function &query($query) {
2525	$this->parse_query($query);
2526	return $this->get_posts();
2527	}
2528
2529	/**
2530	* Retrieve queried object.
2531	*
2532	* If queried object is not set, then the queried object will be set from
2533	* the category, tag, taxonomy, posts page, single post, page, or author
2534	* query variable. After it is set up, it will be returned.
2535	*
2536	* @since 1.5.0
2537	* @access public
2538	*
2539	* @return object
2540	*/
2541	function get_queried_object() {
2542	if (isset($this->queried_object)) {
2543	return $this->queried_object;
2544	}
2545
2546	$this->queried_object = NULL;
2547	$this->queried_object_id = 0;
2548
2549	if ($this->is_category) {
2550	$cat = $this->get('cat');
2551	$category = &get_category($cat);
2552	if ( is_wp_error( $category ) )
2553	return NULL;
2554	$this->queried_object = &$category;
2555	$this->queried_object_id = (int) $cat;
2556	} else if ($this->is_tag) {
2557	$tag_id = $this->get('tag_id');
2558	$tag = &get_term($tag_id, 'post_tag');
2559	if ( is_wp_error( $tag ) )
2560	return NULL;
2561	$this->queried_object = &$tag;
2562	$this->queried_object_id = (int) $tag_id;
2563	} else if ($this->is_tax) {
2564	$tax = $this->get('taxonomy');
2565	$slug = $this->get('term');
2566	$term = &get_terms($tax, array('slug'=>$slug));
2567	if ( is_wp_error($term) \|\| empty($term) )
2568	return NULL;
2569	$term = $term[0];
2570	$this->queried_object = $term;
2571	$this->queried_object_id = $term->term_id;
2572	} else if ($this->is_posts_page) {
2573	$this->queried_object = & get_page(get_option('page_for_posts'));
2574	$this->queried_object_id = (int) $this->queried_object->ID;
2575	} else if ($this->is_single) {
2576	$this->queried_object = $this->post;
2577	$this->queried_object_id = (int) $this->post->ID;
2578	} else if ($this->is_page) {
2579	$this->queried_object = $this->post;
2580	$this->queried_object_id = (int) $this->post->ID;
2581	} else if ($this->is_author) {
2582	$author_id = (int) $this->get('author');
2583	$author = get_userdata($author_id);
2584	$this->queried_object = $author;
2585	$this->queried_object_id = $author_id;
2586	}
2587
2588	return $this->queried_object;
2589	}
2590
2591	/**
2592	* Retrieve ID of the current queried object.
2593	*
2594	* @since 1.5.0
2595	* @access public
2596	*
2597	* @return int
2598	*/
2599	function get_queried_object_id() {
2600	$this->get_queried_object();
2601
2602	if (isset($this->queried_object_id)) {
2603	return $this->queried_object_id;
2604	}
2605
2606	return 0;
2607	}
2608
2609	/**
2610	* PHP4 type constructor.
2611	*
2612	* Sets up the WordPress query, if parameter is not empty.
2613	*
2614	* @since 1.5.0
2615	* @access public
2616	*
2617	* @param string $query URL query string.
2618	* @return WP_Query
2619	*/
2620	function WP_Query ($query = '') {
2621	if (! empty($query)) {
2622	$this->query($query);
2623	}
2624	}
2625	}
2626
2627	/**
2628	* Redirect old slugs to the correct permalink.
2629	*
2630	* Attempts to find the current slug from the past slugs.
2631	*
2632	* @since 2.1.0
2633	* @uses $wp_query
2634	* @uses $wpdb
2635	*
2636	* @return null If no link is found, null is returned.
2637	*/
2638	function wp_old_slug_redirect () {
2639	global $wp_query;
2640	if ( is_404() && '' != $wp_query->query_vars['name'] ) :
2641	global $wpdb;
2642
2643	$query = "SELECT post_id FROM $wpdb->postmeta, $wpdb->posts WHERE ID = post_id AND meta_key = '_wp_old_slug' AND meta_value='" . $wp_query->query_vars['name'] . "'";
2644
2645	// if year, monthnum, or day have been specified, make our query more precise
2646	// just in case there are multiple identical _wp_old_slug values
2647	if ( '' != $wp_query->query_vars['year'] )
2648	$query .= " AND YEAR(post_date) = '{$wp_query->query_vars['year']}'";
2649	if ( '' != $wp_query->query_vars['monthnum'] )
2650	$query .= " AND MONTH(post_date) = '{$wp_query->query_vars['monthnum']}'";
2651	if ( '' != $wp_query->query_vars['day'] )
2652	$query .= " AND DAYOFMONTH(post_date) = '{$wp_query->query_vars['day']}'";
2653
2654	$id = (int) $wpdb->get_var($query);
2655
2656	if ( !$id )
2657	return;
2658
2659	$link = get_permalink($id);
2660
2661	if ( !$link )
2662	return;
2663
2664	wp_redirect($link, '301'); // Permanent redirect
2665	exit;
2666	endif;
2667	}
2668
2669	/**
2670	* Setup global post data.
2671	*
2672	* @since 1.5.0
2673	*
2674	* @param object $post Post data.
2675	* @uses do_action_ref_array() Calls 'the_post'
2676	* @return bool True when finished.
2677	*/
2678	function setup_postdata($post) {
2679	global $id, $authordata, $day, $currentmonth, $page, $pages, $multipage, $more, $numpages;
2680
2681	$id = (int) $post->ID;
2682
2683	$authordata = get_userdata($post->post_author);
2684
2685	$day = mysql2date('d.m.y', $post->post_date, false);
2686	$currentmonth = mysql2date('m', $post->post_date, false);
2687	$numpages = 1;
2688	$page = get_query_var('page');
2689	if ( !$page )
2690	$page = 1;
2691	if ( is_single() \|\| is_page() \|\| is_feed() )
2692	$more = 1;
2693	$content = $post->post_content;
2694	if ( strpos( $content, '<!--nextpage-->' ) ) {
2695	if ( $page > 1 )
2696	$more = 1;
2697	$multipage = 1;
2698	$content = str_replace("\n<!--nextpage-->\n", '<!--nextpage-->', $content);
2699	$content = str_replace("\n<!--nextpage-->", '<!--nextpage-->', $content);
2700	$content = str_replace("<!--nextpage-->\n", '<!--nextpage-->', $content);
2701	$pages = explode('<!--nextpage-->', $content);
2702	$numpages = count($pages);
2703	} else {
2704	$pages[0] = $post->post_content;
2705	$multipage = 0;
2706	}
2707
2708	do_action_ref_array('the_post', array(&$post));
2709
2710	return true;
2711	}
2712
2713	?>

Trac UI Preferences

Download in other formats:

Original Format

Make WordPress Core

Context Navigation

Ticket #10964: query.2.php

Download in other formats: