{"id":83,"date":"2006-09-20T18:58:33","date_gmt":"2006-09-20T09:58:33","guid":{"rendered":"http:\/\/www.kaz.bz\/wp\/2006-09-20_120\/"},"modified":"2006-09-20T18:58:33","modified_gmt":"2006-09-20T09:58:33","slug":"%e6%89%bf%e8%aa%8d%e5%89%8d%e3%81%af%e3%82%b3%e3%83%a1%e3%83%b3%e3%83%88%e6%8a%95%e7%a8%bf%e6%9c%ac%e4%ba%ba%e3%81%ab%e3%82%82%e8%a1%a8%e7%a4%ba%e3%81%97%e3%81%aa%e3%81%84","status":"publish","type":"post","link":"https:\/\/wp.kaz.bz\/tech\/2006\/09\/20\/83.html","title":{"rendered":"\u627f\u8a8d\u524d\u306f\u30b3\u30e1\u30f3\u30c8\u6295\u7a3f\u672c\u4eba\u306b\u3082\u8868\u793a\u3057\u306a\u3044"},"content":{"rendered":"<p>wp-includes\/comment-functions.php<\/p>\n<p>comments_template\u95a2\u6570\u306e\u5b9a\u7fa9\u5185\u306b\u3042\u308b<\/p>\n<p>\tif ( empty($comment_author) ) {<br \/>\n\t\t$comments = $wpdb->get_results(\"SELECT * FROM $wpdb->comments WHERE comment_post_ID = '$post->ID' AND comment_approved = '1' ORDER BY comment_date\");<br \/>\n\t} else {<br \/>\n\t\t$author_db = $wpdb->escape($comment_author);<br \/>\n\t\t$email_db  = $wpdb->escape($comment_author_email);<br \/>\n\t\t$comments = $wpdb->get_results(\"SELECT * FROM $wpdb->comments WHERE comment_post_ID = '$post->ID' AND ( comment_approved = '1' OR ( comment_author = '$author_db' AND comment_author_email = '$email_db' AND comment_approved = '0' ) ) ORDER BY comment_date\");<br \/>\n\t}<\/p>\n<p>\u3092\u3001<\/p>\n<p>\/\/\tif ( empty($comment_author) ) {<br \/>\n\t\t$comments = $wpdb->get_results(\"SELECT * FROM $wpdb->comments WHERE comment_post_ID = '$post->ID' AND comment_approved = '1' ORDER BY comment_date\");<br \/>\n\/*\t} else {<br \/>\n\t\t$author_db = $wpdb->escape($comment_author);<br \/>\n\t\t$email_db  = $wpdb->escape($comment_author_email);<br \/>\n\t\t$comments = $wpdb->get_results(\"SELECT * FROM $wpdb->comments WHERE comment_post_ID = '$post->ID' AND ( comment_approved = '1' OR ( comment_author = '$author_db' AND comment_author_email = '$email_db' AND comment_approved = '0' ) ) ORDER BY comment_date\");<br \/>\n\t}<br \/>\n*\/<\/p>\n<p>\u3068\u30b3\u30e1\u30f3\u30c8\u30a2\u30a6\u30c8\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>wp-includes\/comment-functions.php comments_template\u95a2\u6570\u306e\u5b9a\u7fa9\u5185\u306b\u3042\u308b if ( empty($comment_author) ) { $comments = $wpdb [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[19],"tags":[],"class_list":["post-83","post","type-post","status-publish","format-standard","hentry","category-wordpress"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":416,"url":"https:\/\/wp.kaz.bz\/tech\/2010\/10\/22\/416.html","url_meta":{"origin":83,"position":0},"title":"\u5225\u306eDB\u30b5\u30fc\u30d0\u306b\u3042\u308b\u65e2\u5b58DB\u306e\u7ba1\u7406\u3092Plesk\u3067\u3084\u308b\u65b9\u6cd5\u3002","author":"kaz. Suenaga","date":"2010\/10\/22","format":false,"excerpt":"Plesk\u306e\u78ba\u304b Ver.8 \u3042\u305f\u308a\u304b\u3089\u3001\u5225\u30b5\u30fc\u30d0\u306b\u3042\u308bDB\u3092\u7ba1\u7406\u3059\u308b\u3053\u3068\u304c\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u3002\u2026","rel":"","context":"Plesk","block_context":{"text":"Plesk","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/plesk"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":50,"url":"https:\/\/wp.kaz.bz\/tech\/2008\/03\/13\/50.html","url_meta":{"origin":83,"position":1},"title":"PostgreSQL\u306eARRAY\u95a2\u6570\u3002","author":"kaz. Suenaga","date":"2008\/03\/13","format":false,"excerpt":"SQL\u5b9f\u884c\u3059\u308b\u969b\u306b\u3001ARRAY()\u95a2\u6570\u3092\u5229\u7528\u3059\u308b\u3068\u914d\u5217\u3067\u7d50\u679c\u30bb\u30c3\u30c8\u304c\u5f97\u3089\u308c\u308b\u3002 \u4f8b\uff09 SELECT \u2026","rel":"","context":"PostgreSQL","block_context":{"text":"PostgreSQL","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/db\/postgresql"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":8,"url":"https:\/\/wp.kaz.bz\/tech\/2009\/09\/17\/8.html","url_meta":{"origin":83,"position":2},"title":"vpgsql.c \u306e\u30d0\u30b0\u3002","author":"kaz. Suenaga","date":"2009\/09\/17","format":false,"excerpt":"vpopmail-5.4.28 \u3067\u3001 \u30fbDB\u306bPostgreSQL\u3092\u5229\u7528 \u30fbvalias \u3092DB\u3067\u5229\u2026","rel":"","context":"qmail \/ vpopmail","block_context":{"text":"qmail \/ vpopmail","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/djb\/qmail-vpopmail"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1380,"url":"https:\/\/wp.kaz.bz\/tech\/2012\/10\/03\/1380.html","url_meta":{"origin":83,"position":3},"title":"ucspi-tcp \u306eSSL\u5bfe\u5fdc\uff08\u3064\u3044\u3067\u306b\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\uff09\u3002","author":"kaz. Suenaga","date":"2012\/10\/03","format":false,"excerpt":"\u65b9\u91dd http:\/\/www.nrg4u.com\/ \u306b\u3042\u308b\u300ctcpserver SSL\/TLS pat\u2026","rel":"","context":"ucspi-tcp","block_context":{"text":"ucspi-tcp","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/djb\/ucspi-tcp"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":109,"url":"https:\/\/wp.kaz.bz\/tech\/2006\/05\/29\/109.html","url_meta":{"origin":83,"position":4},"title":"WordPress \u30d7\u30e9\u30b0\u30a4\u30f3\u4f5c\u6210\u65b9\u6cd5\u3000\u305d\u306e1\u7ba1\u7406\u30da\u30fc\u30b8\u306e\u30d7\u30e9\u30b0\u30a4\u30f3\u30ea\u30b9\u30c8\u3078\u306e\u8868\u793a","author":"kaz. Suenaga","date":"2006\/05\/29","format":false,"excerpt":"\u30d7\u30e9\u30b0\u30a4\u30f3\u30ea\u30b9\u30c8\u3078\u306e\u8868\u793a\u306f\u3001wp-contents\/plugins\u3000\u4ee5\u4e0b\u306b\u4e0b\u8a18\u306e\u66f8\u5f0f\u306e\u30b3\u30e1\u30f3\u30c8\u304c\u3042\u308b\u2026","rel":"","context":"WordPress","block_context":{"text":"WordPress","link":"https:\/\/wp.kaz.bz\/tech\/category\/web\/wordpress"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":59,"url":"https:\/\/wp.kaz.bz\/tech\/2007\/07\/02\/59.html","url_meta":{"origin":83,"position":5},"title":"pg_dump\u306a\u3069\u3067\u81ea\u52d5\u30d1\u30b9\u30ef\u30fc\u30c9\u8a2d\u5b9a","author":"kaz. Suenaga","date":"2007\/07\/02","format":false,"excerpt":"http:\/\/www.postgresql.jp\/document\/current\/html\/lib\u2026","rel":"","context":"PostgreSQL","block_context":{"text":"PostgreSQL","link":"https:\/\/wp.kaz.bz\/tech\/category\/servers\/db\/postgresql"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/83","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/comments?post=83"}],"version-history":[{"count":0,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/posts\/83\/revisions"}],"wp:attachment":[{"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/media?parent=83"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/categories?post=83"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/wp.kaz.bz\/tech\/wp-json\/wp\/v2\/tags?post=83"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}