{"id":17,"date":"2024-06-18T09:24:36","date_gmt":"2024-06-18T01:24:36","guid":{"rendered":"https:\/\/www.dbyh.top\/?p=17"},"modified":"2024-07-30T08:30:24","modified_gmt":"2024-07-30T00:30:24","slug":"%e5%85%b3%e4%ba%8e520sw%e7%bd%91%e7%ab%99%e9%80%9f%e5%ba%a6%e4%bc%98%e5%8c%96","status":"publish","type":"post","link":"https:\/\/www.dbyh.top\/index.php\/2024\/06\/18\/%e5%85%b3%e4%ba%8e520sw%e7%bd%91%e7%ab%99%e9%80%9f%e5%ba%a6%e4%bc%98%e5%8c%96\/","title":{"rendered":"\u5173\u4e8e520sw***\u7f51\u7ad9\u901f\u5ea6\u4f18\u5316 wordpress"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n

\u4f18\u5316\u524d \u7528\u6237\u9875\u9762\u6253\u5f00\u9700\u89815.49\u79d2 \uff0c\u5e76\u4e14\u4ed6\u4e00\u76f4\u5347\u7ea7\u670d\u52a1\u5668\u5347\u5230\u4e8632\u683864G\u5185\u5b58\u4f9d\u7136\u8fd9\u4e48\u5361\u987f\uff0c\u4f18\u5316\u540e\u670d\u52a1\u5668\u914d\u7f6e\u53ef\u4ee5\u964d\u4f4e \u80fd\u7701\u4e0b\u5f88\u591a\u94b1\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u4f18\u5316\u540e0.43\u79d2<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u5199\u6587\u7ae0\u4f18\u5316\u524d5.62\u79d2<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u7f16\u8f91\u9875\u97624.47\u79d2<\/p>\n\n\n\n

\u8be5\u7f51\u7ad9\u7528\u6237\u8868\u5c31\u670935\u4e07\u6570\u636e\u3002<\/p>\n\n\n\n

\u6162\u8bed\u53e5<\/p>\n\n\n\n

SELECT wp_users.ID,wp_users.user_login,wp_users.display_name<\/p>\n\n\n\n

FROM wp_users<\/p>\n\n\n\n

INNER JOIN wp_usermeta<\/p>\n\n\n\n

ON ( wp_users.ID = wp_usermeta.user_id )<\/p>\n\n\n\n

WHERE 1=1<\/p>\n\n\n\n

AND ( ( ( ( wp_usermeta.meta_key = ‘wp_capabilities’<\/p>\n\n\n\n

AND wp_usermeta.meta_value LIKE ‘%\\”edit\\\\_posts\\”%’ )<\/p>\n\n\n\n

OR ( wp_usermeta.meta_key = ‘wp_capabilities’<\/p>\n\n\n\n

AND wp_usermeta.meta_value LIKE ‘%\\”administrator\\”%’ )<\/p>\n\n\n\n

OR ( wp_usermeta.meta_key = ‘wp_capabilities’<\/p>\n\n\n\n

AND wp_usermeta.meta_value LIKE ‘%\\”editor\\”%’ )<\/p>\n\n\n\n

OR ( wp_usermeta.meta_key = ‘wp_capabilities’<\/p>\n\n\n\n

AND wp_usermeta.meta_value LIKE ‘%\\”author\\”%’ )<\/p>\n\n\n\n

OR ( wp_usermeta.meta_key = ‘wp_capabilities’<\/p>\n\n\n\n

AND wp_usermeta.meta_value LIKE ‘%\\”contributor\\”%’ ) ) ) )<\/p>\n\n\n\n

ORDER BY user_registered desc<\/p>\n\n\n\n

SELECT DISTINCT meta_key<\/p>\n\n\n\n

FROM wp_postmeta<\/p>\n\n\n\n

WHERE meta_key NOT BETWEEN ‘_’<\/p>\n\n\n\n

AND ‘_z’<\/p>\n\n\n\n

HAVING meta_key NOT LIKE ‘\\\\_%’<\/p>\n\n\n\n

ORDER BY meta_key<\/p>\n\n\n\n

LIMIT 30<\/p>\n\n\n\n

SELECT DISTINCT YEAR( post_date ) AS year, MONTH( post_date ) AS month<\/p>\n\n\n\n

FROM wp_posts<\/p>\n\n\n\n

WHERE post_type = ‘attachment’<\/p>\n\n\n\n

ORDER BY post_date DESC<\/p>\n\n\n\n

\u5176\u4ed6\u6162\u8bed\u53e5<\/p>\n\n\n\n

SELECT COUNT(ID)<\/p>\n\n\n\n

FROM wp_users<\/p>\n\n\n\n

WHERE DATE_FORMAT( user_registered,’%Y-%m-%d’) = DATE_FORMAT(NOW(), ‘%Y-%m-%d’)<\/p>\n\n\n\n

SELECT post_id, COUNT(post_id) AS count<\/p>\n\n\n\n

FROM wp_cao_down_tbl<\/p>\n\n\n\n

WHERE 1=1<\/p>\n\n\n\n

GROUP BY post_id<\/p>\n\n\n\n

ORDER BY count DESC<\/p>\n\n\n\n

LIMIT 10<\/p>\n\n\n\n

\u8fd8\u6709\u5176\u4ed6\u6162\u8bed\u53e5\u5c31\u4e0d\u4e00\u4e00\u9648\u5217\u4e86\u3002<\/p>\n\n\n\n

\u5df2\u7ecf\u4f18\u5316\u597d\u4e86 \u90fd\u662f0.\u51e0\u79d2 \u4e0d\u4ec5\u540e\u53f0\u5feb\u4e86\uff0c\u524d\u53f0\u4e5f\u5feb\u4e86\u3002<\/p>\n\n\n\n

 \u795d\u60a8\u751f\u6d3b\u6109\u5feb<\/p>\n\n\n\n

\u5fc3\u8bda\u7f51\u7ad9\u5236\u4f5c<\/p>\n\n\n\n

2024-6-17<\/p>\n\n\n\n

\u6b22\u8fce\u8001\u677f\u4e0b\u5355\u4f18\u5316<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4f18\u5316\u524d \u7528\u6237\u9875\u9762\u6253\u5f00\u9700\u89815.49\u79d2 \uff0c\u5e76\u4e14\u4ed6\u4e00\u76f4\u5347\u7ea7\u670d\u52a1\u5668\u5347\u5230\u4e8632\u683864G\u5185\u5b58\u4f9d\u7136\u8fd9\u4e48\u5361\u987f\uff0c\u4f18\u5316\u540e\u670d\u52a1\u5668\u914d\u7f6e […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[9],"tags":[],"class_list":["post-17","post","type-post","status-publish","format-standard","hentry","category-9"],"_links":{"self":[{"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/posts\/17","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/comments?post=17"}],"version-history":[{"count":5,"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/posts\/17\/revisions"}],"predecessor-version":[{"id":38,"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/posts\/17\/revisions\/38"}],"wp:attachment":[{"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/media?parent=17"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/categories?post=17"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbyh.top\/index.php\/wp-json\/wp\/v2\/tags?post=17"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}