{"id":734,"date":"2006-11-23T18:28:48","date_gmt":"2006-11-23T09:28:48","guid":{"rendered":"http:\/\/zone.maple4ever.net\/blog\/archives\/734\/"},"modified":"2006-11-27T02:00:10","modified_gmt":"2006-11-26T17:00:10","slug":"akismet-de-spam-view-hack","status":"publish","type":"post","link":"http:\/\/zone.maple4ever.net\/blog\/archives\/734\/","title":{"rendered":"Akismet de-spam view Hack"},"content":{"rendered":"<p>\u3082\u30fc\u3069\u3046\u3057\u3088\u3046\u3082\u306a\u304f\u3001Akimet \u304f\u3093\u304c\u30b9\u30d1\u30e0\u3058\u3083\u306a\u3044\u30b3\u30e1\u30f3\u30c8\u3092\u6355\u7372\u3057\u3066\u304f\u308c\u307e\u3059\u3002\u3000\u3069\u3046\u3057\u3088\u3046\u304b\u3068\u601d\u6848&#8230;\u3002<\/p>\n<p>\u3068\u308a\u3042\u3048\u305a\u3001\u3046\u3061\u306e\u30b5\u30a4\u30c8\u306e\u5834\u5408\u57fa\u672c\u306f\u65e5\u672c\u8a9e\u3060\u3063\u305f\u3089\u305f\u3044\u3066\u3044\u5927\u4e08\u592b\u3068\u3044\u3046\u6761\u4ef6\u304c\u3064\u3051\u3089\u308c\u307e\u3059\u3002\u3000\u3068\u3044\u3046\u308f\u3051\u3067\u3001\u65e5\u672c\u8a9e\u3060\u3063\u305f\u3089\u3001Akismet \u306e\u30a2\u30af\u30b7\u30e7\u30f3\/\u30d5\u30a3\u30eb\u30bf\u30fc \u3092\u5148\u306b\u52d5\u3044\u3066\u30cf\u30ba\u3057\u3061\u3083\u3046\u30d7\u30e9\u30b0\u30a4\u30f3\u3068\u3044\u3046\u306e\u3092\u8003\u3048\u307e\u3057\u305f\u3002<\/p>\n<p>\u3057\u304b\u3057\u306a\u304c\u3089\u3001\u3053\u306e\u65b9\u5f0f\u3060\u3068 Akismet \u306e spam ham (\u9593\u9055\u3048\u30b9\u30d1\u30e0\uff09\u306e\u5b66\u7fd2\u306b\u8ca2\u732e\u3067\u304d\u307e\u305b\u3093\u3002\u3000 Akismet \u306f\u30b5\u30fc\u30d0\u30b5\u30a4\u30c9\u3067\u30b9\u30d1\u30e0\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u52d5\u3044\u3066\u3044\u308b\u306e\u3067\u3001\u3069\u306e\u3088\u3046\u306a\u65b9\u5f0f\u3067\u5224\u5b9a\u3057\u3066\u3044\u308b\u306e\u304b\u306f\u77e5\u308b\u3088\u3057\u3082\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u3068\u308a\u3042\u3048\u305a de-spam \u3059\u308b\u3068\u5b66\u7fd2\u306f\u3057\u3088\u3046\u3068\u3057\u3066\u3044\u308b\u306e\u3067 Akismet \u3092\u4f7f\u3046\u306e\u306a\u3089\u3070\u3001\u672c\u6765\u7684\u306b\u306f\u3053\u308c\u3092\u5229\u7528\u3057\u305f\u307b\u3046\u304c\u4eca\u5f8c\u306e\u305f\u3081\u306b\u306a\u308a\u305d\u3046\u3067\u3059\u3002<\/p>\n<p>\u3058\u3083\u30fc\u3042\u3068\u306f\u4f55\u304c\u554f\u984c\u304b\u3068\u3044\u3046\u3068\u3001<\/p>\n<p><img decoding=\"async\" loading=\"lazy\" src=\"http:\/\/zone.maple4ever.net\/blog\/wp-content\/plugins\/wp-tegaki\/wp-tegaki-img.php?tegaki_id=734-0\" alt=\"\u30b9\u30d1\u30e0\u304d\u3059\u304e\u3002orz\" width=\"250\" height=\"34\" \/><\/p>\n<p>\u8981\u306f\u7ba1\u7406\u753b\u9762\u3067 de-spam \u3057\u3088\u3046\u306b\u3082\u6570\u304c\u591a\u3059\u304e\u3066\u6b63\u898f\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u63a2\u3057\u51fa\u305b\u306a\u3044\u306e\u3067\u3059\u3002\u3000\u3061\u3087\u3063\u3068\u773c\u3092\u96e2\u3057\u305f\u3059\u304d\u306b 6000 \u304f\u3089\u3044\u306b\u306a\u3063\u3066\u3044\u308b\u3057&#8230;\u3002 100\u30da\u30fc\u30b8\u4ee5\u4e0a\u3002\u3002<\/p>\n<p>\u3068\u3044\u3046\u3053\u3068\u3067\u3001\u7ba1\u7406\u753b\u9762\u306e de-spam \u9078\u629e\u753b\u9762\u3092\u300c\u65e5\u672c\u8a9e\uff08\u30de\u30eb\u30c1\u30d0\u30a4\u30c8\uff09\u3092\u542b\u3080\u306e\u30b3\u30e1\u30f3\u30c8\/\u30c8\u30e9\u30c3\u30af\u30d0\u30c3\u30af\u300d\u3060\u3051\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u6539\u9020\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n<div class=\"hl-surround\" ><ol class=\"hl-main\" start=272><li>&nbsp;<span class=\"hl-var\">$comments<\/span><span class=\"hl-default\"> = <\/span><span class=\"hl-var\">$wpdb<\/span><span class=\"hl-default\">-&gt;<\/span><span class=\"hl-identifier\">get_results<\/span><span class=\"hl-brackets\">(<\/span><span class=\"hl-quotes\">&quot;<\/span><span class=\"hl-string\">SELECT * FROM <\/span><span class=\"hl-var\">$wpdb<\/span><span class=\"hl-string\">-&gt;comments WHERE comment_approved = 'spam' AND LENGTH(comment_content) &lt;&gt; CHAR_LENGTH(comment_content) ORDER BY comment_date DESC LIMIT <\/span><span class=\"hl-var\">$start<\/span><span class=\"hl-string\">, <\/span><span class=\"hl-var\">$end<\/span><span class=\"hl-quotes\">&quot;<\/span><span class=\"hl-brackets\">)<\/span><span class=\"hl-default\">;\r<\/span><\/li>\n<li>&nbsp;<span class=\"hl-default\"><\/span><span class=\"hl-var\">$total<\/span><span class=\"hl-default\"> = <\/span><span class=\"hl-var\">$wpdb<\/span><span class=\"hl-default\">-&gt;<\/span><span class=\"hl-identifier\">get_var<\/span><span class=\"hl-brackets\">( <\/span><span class=\"hl-quotes\">&quot;<\/span><span class=\"hl-string\">SELECT COUNT(*) FROM <\/span><span class=\"hl-var\">$wpdb<\/span><span class=\"hl-string\">-&gt;comments WHERE comment_approved = 'spam'&nbsp; AND LENGTH(comment_content) &lt;&gt; CHAR_LENGTH(comment_content) <\/span><span class=\"hl-quotes\">&quot; <\/span><span class=\"hl-brackets\">)<\/span><span class=\"hl-default\">;<\/span><\/li><\/ol><\/div>\n<p>\u5b8c\u819a\u7121\u304d\u307e\u3067\u306e\u30cf\u30c3\u30af\u30b3\u30fc\u30c9\u3067\u3059\u304c\u3001\u52d5\u3044\u3066\u3044\u308b\u6c17\u306f\u3057\u307e\u3059\u3002 \ud83d\ude42<\/p>\n<p>\u306a\u3093\u304b\u5909\u3060\u3063\u305f\u3089\u304a\u3057\u3048\u3066\u304f\u3060\u3055\u3044\u3002<\/p>\n<p>\u8ffd\u8a18<\/p>\n<p>\u307c\u306e\u3055\u3093\u304c\u3001\u3055\u3089\u306b\u6539\u9020\u3057\u3066\u304f\u3060\u3055\u308a\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u306b\u4ef6\u6570\u304c\u3060\u305b\u308b\u3088\u3046\u306b\u306a\u308a\u307e\u3057\u305f\u3002\u3000\u3082\u3057\u304b\u3059\u308b\u3068\u3001\u30d5\u30a3\u30eb\u30bf\u30fc\u3082\u5207\u308b\u30dc\u30bf\u30f3\u304c\u3064\u304f\u304b\u3082&#8230;?!<\/p>\n<blockquote><p>\n<a href=\"http:\/\/bono.s201.xrea.com\/2006\/11\/275-de-spam_view_hack2\/\">power source* \u226b WP: \uff08\u7d9a\uff09Akismet de-spam view Hack<\/a><\/p>\n<p>\u5148\u65e5\u306e\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u4fee\u6b63\u306b\u3088\u308a\u3001Akismet \u7d2f\u8a08\u30b9\u30d1\u30e0\u6570\u3067\u306f\u306a\u304f\u3001\u73fe\u5728\u306e\u6355\u7372\u6570\u3092\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u3057\u3066\u3042\u3063\u305f\u3002<br \/>\n\u4eca\u56de\u306f\u3001\u8aa4\u6355\u7372\u306e\u53ef\u80fd\u6027\u304c\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u3067\u5206\u304b\u308b\u3088\u3046\u306b\u3001\u30de\u30eb\u30c1\u30d0\u30a4\u30c8\u3082\u306e\u306e\u6355\u7372\u6570\u3092\u4f75\u8a18\u3057\u3066\u307f\u308b\u3002\n<\/p><\/blockquote>\n<p>\u3042\u308a\u304c\u3068\u3046\u3054\u3056\u3044\u307e\u3057\u305f!\u3002 \ud83d\ude42<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3082\u30fc\u3069\u3046\u3057\u3088\u3046\u3082\u306a\u304f\u3001Akimet \u304f\u3093\u304c\u30b9\u30d1\u30e0\u3058\u3083\u306a\u3044\u30b3\u30e1\u30f3\u30c8\u3092\u6355\u7372\u3057\u3066\u304f\u308c\u307e\u3059\u3002\u3000\u3069\u3046\u3057\u3088\u3046\u304b\u3068\u601d\u6848&#8230;\u3002 \u3068\u308a\u3042\u3048\u305a\u3001\u3046\u3061\u306e\u30b5\u30a4\u30c8\u306e\u5834\u5408\u57fa\u672c\u306f\u65e5\u672c\u8a9e\u3060\u3063\u305f\u3089\u305f\u3044\u3066\u3044\u5927\u4e08\u592b\u3068\u3044\u3046\u6761\u4ef6\u304c\u3064\u3051\u3089\u308c\u307e\u3059\u3002\u3000\u3068\u3044\u3046\u308f\u3051\u3067\u3001\u65e5\u672c\u8a9e\u3060\u3063\u305f\u3089\u3001Akismet \u306e\u30a2\u30af\u30b7\u30e7\u30f3\/\u30d5\u30a3\u30eb\u30bf\u30fc \u3092\u5148\u306b\u52d5\u3044\u3066\u30cf\u30ba\u3057\u3061\u3083\u3046\u30d7\u30e9\u30b0\u30a4\u30f3\u3068\u3044\u3046\u306e\u3092\u8003\u3048\u307e\u3057\u305f\u3002 \u3057\u304b\u3057\u306a\u304c\u3089\u3001\u3053\u306e\u65b9\u5f0f\u3060\u3068 Akismet \u306e spam ham (\u9593\u9055\u3048\u30b9\u30d1\u30e0\uff09\u306e\u5b66\u7fd2\u306b\u8ca2\u732e\u3067\u304d\u307e\u305b\u3093\u3002\u3000 Akismet \u306f\u30b5\u30fc\u30d0\u30b5\u30a4\u30c9\u3067\u30b9\u30d1\u30e0\u30d5\u30a3\u30eb\u30bf\u30fc\u304c\u52d5\u3044\u3066\u3044\u308b\u306e\u3067\u3001\u3069\u306e\u3088\u3046\u306a\u65b9\u5f0f\u3067\u5224\u5b9a\u3057\u3066\u3044\u308b\u306e\u304b\u306f\u77e5\u308b\u3088\u3057\u3082\u3042\u308a\u307e\u305b\u3093\u304c\u3001\u3068\u308a\u3042\u3048\u305a de-spam \u3059\u308b\u3068\u5b66\u7fd2\u306f\u3057\u3088\u3046\u3068\u3057\u3066\u3044\u308b\u306e\u3067 Akismet \u3092\u4f7f\u3046\u306e\u306a\u3089\u3070\u3001\u672c\u6765\u7684\u306b\u306f\u3053\u308c\u3092\u5229\u7528\u3057\u305f\u307b\u3046\u304c\u4eca\u5f8c\u306e\u305f\u3081\u306b\u306a\u308a\u305d\u3046\u3067\u3059\u3002 \u3058\u3083\u30fc\u3042\u3068\u306f\u4f55\u304c\u554f\u984c\u304b\u3068\u3044\u3046\u3068\u3001 \u8981\u306f\u7ba1\u7406\u753b\u9762\u3067 de-spam \u3057\u3088\u3046\u306b\u3082\u6570\u304c\u591a\u3059\u304e\u3066\u6b63\u898f\u306e\u30b3\u30e1\u30f3\u30c8\u3092\u63a2\u3057\u51fa\u305b\u306a\u3044\u306e\u3067\u3059\u3002\u3000\u3061\u3087\u3063\u3068\u773c\u3092\u96e2\u3057\u305f\u3059\u304d\u306b 6000 \u304f\u3089\u3044\u306b\u306a\u3063\u3066\u3044\u308b\u3057&#8230;\u3002 100\u30da\u30fc\u30b8\u4ee5\u4e0a\u3002\u3002 \u3068\u3044\u3046\u3053\u3068\u3067\u3001\u7ba1\u7406\u753b\u9762\u306e de-spam \u9078\u629e\u753b\u9762\u3092\u300c\u65e5\u672c\u8a9e\uff08\u30de\u30eb\u30c1\u30d0\u30a4\u30c8\uff09\u3092\u542b\u3080\u306e\u30b3\u30e1\u30f3\u30c8\/\u30c8\u30e9\u30c3\u30af\u30d0\u30c3\u30af\u300d\u3060\u3051\u8868\u793a\u3059\u308b\u3088\u3046\u306b\u6539\u9020\u3057\u3066\u307f\u307e\u3057\u305f\u3002 &nbsp;$comments = $wpdb-&gt;get_results(&quot;SELECT * FROM $wpdb-&gt;comments WHERE comment_approved = &#8216;spam&#8217; AND LENGTH(comment_content) &lt;&gt; CHAR_LENGTH(comment_content) ORDER BY comment_date DESC LIMIT $start, $end&quot;); &nbsp;$total = $wpdb-&gt;get_var( &quot;SELECT COUNT(*) FROM $wpdb-&gt;comments [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"_links":{"self":[{"href":"http:\/\/zone.maple4ever.net\/blog\/wp-json\/wp\/v2\/posts\/734"}],"collection":[{"href":"http:\/\/zone.maple4ever.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/zone.maple4ever.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/zone.maple4ever.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/zone.maple4ever.net\/blog\/wp-json\/wp\/v2\/comments?post=734"}],"version-history":[{"count":0,"href":"http:\/\/zone.maple4ever.net\/blog\/wp-json\/wp\/v2\/posts\/734\/revisions"}],"wp:attachment":[{"href":"http:\/\/zone.maple4ever.net\/blog\/wp-json\/wp\/v2\/media?parent=734"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/zone.maple4ever.net\/blog\/wp-json\/wp\/v2\/categories?post=734"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/zone.maple4ever.net\/blog\/wp-json\/wp\/v2\/tags?post=734"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}