{"id":874,"date":"2006-05-22T00:05:01","date_gmt":"2006-05-21T15:05:01","guid":{"rendered":"http:\/\/a-tak.com\/xoops2\/modules\/wordpress\/2006\/05\/22\/874"},"modified":"2012-05-12T23:15:01","modified_gmt":"2012-05-12T14:15:01","slug":"rssfitj%e3%81%aewordpress%e3%83%97%e3%83%a9%e3%82%b0%e3%82%a4%e3%83%b3%e3%82%92%e5%b0%91%e3%81%97%e6%94%b9%e9%80%a0","status":"publish","type":"post","link":"https:\/\/a-tak.com\/blog\/2006\/05\/rssfitj%e3%81%aewordpress%e3%83%97%e3%83%a9%e3%82%b0%e3%82%a4%e3%83%b3%e3%82%92%e5%b0%91%e3%81%97%e6%94%b9%e9%80%a0\/","title":{"rendered":"RSSfitJ\u306eWordPress\u30d7\u30e9\u30b0\u30a4\u30f3\u3092\u5c11\u3057\u6539\u9020"},"content":{"rendered":"<div id=\"advads-3236369123\" class=\"advads-before-content-placement advads-entity-placement\" style=\"margin-left: auto;margin-right: auto;text-align: center;\"><div class=\"advads-adlabel\">\u5e83\u544a<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7585646298782746\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px;\" \ndata-ad-client=\"ca-pub-7585646298782746\" \ndata-ad-slot=\"6112122906\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div><p><img data-recalc-dims=\"1\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/a-tak.com\/blog\/wp-content\/uploads\/uploads\/thumbs\/489.png?ssl=1\" alt=\"\" \/><br \/>\n\u4eca\u56de\u601d\u3044\u3063\u304d\u308a\u6280\u8853\u7684\u306a\u304a\u8a71(\u30e1\u30e2)\u3002<br \/>\nXOOPS\u306e\u3044\u308d\u3093\u306a\u30e2\u30b8\u30e5\u30fc\u30eb\u306eRSS\u914d\u4fe1\u3092\u4e00\u624b\u306b\u5f15\u304d\u53d7\u3051\u308b\u305f\u3081\u306e\u30e2\u30b8\u30e5\u30fc\u30ebRSSfitJ\u3002<br \/>\n\u3053\u308c\u306b\u306fRSS\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u30e2\u30b8\u30e5\u30fc\u30eb\u3082\u542b\u3081\u3066\u4e00\u3064\u306eRSS\u30d5\u30a3\u30fc\u30c9\u3067\u66f4\u65b0\u60c5\u5831\u3092\u63d0\u4f9b\u3067\u304d\u308b\u3068\u3044\u3046\u5229\u70b9\u304c\u3042\u308b\u306e\u3067\u3059\u304c\u3001WordPress\u306e\u672a\u6765\u306e\u65e5\u4ed8\u3067<span class=\"removed_link\" title=\"https:\/\/a-tak.com\/xoops\/modules\/news\/article.php?storyid=17\">\u4e88\u7d04\u6295\u7a3f\u3057\u3066\u3044\u308b\u3082\u306e\u307e\u3067RSS\u306b\u8868\u793a\u3055\u308c\u308b\u3068\u3044\u3046\u554f\u984c<\/span>\u304c\u3042\u3063\u305f\u306e\u3067\u3001\u3053\u306eA-tak\u65e5\u8a18\u3060\u3051\u306fRSSfitJ\u3092\u4f7f\u308f\u306a\u3044\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3057\u305f\u3002<br \/>\n\u305f\u3060\u3001\u4ed6\u306b\u3082XOOPS\u3067\u30e2\u30b8\u30e5\u30fc\u30eb\u3092\u4f7f\u3044\u59cb\u3081\u305f\u306e\u3067\u305b\u3063\u304b\u304f\u306a\u3089\u30b5\u30a4\u30c8\u5168\u4f53\u306eRSS\u3092\u4f7f\u3063\u3066\u3082\u3089\u3044\u305f\u3044\u306a\u30fc\u3068\u3044\u3046\u6c17\u304c\u3057\u3066\u304d\u305f\u306e\u3067\u3001\u521d\u306ePHP\u30bd\u30fc\u30b9\u6539\u4fee\u3092\u3084\u3063\u3066\u307f\u307e\u3057\u305f\u3002<br \/>\n<!--more--><br \/>\n\u3064\u30fc\u3066\u3082\u3001\u306a\u304a\u3057\u305f\u306e\u306fSQL\u6587\u3060\u3051\u3067\u3088\u304b\u3063\u305f\u3067\u3059\u3002<br \/>\nRSSfitJ\u30e2\u30b8\u30e5\u30fc\u30eb\u306e\u30d5\u30a9\u30eb\u30c0\u306eplugin\u306erssfitj.wordpress.php\u306e174\u884c\u76ee\u306e\u3042\u305f\u308a<\/p>\n<blockquote><p>if ($key==&#8217;wordpress&#8217;) {<br \/>\n$sql = &#8220;SELECT p.ID, p.post_content, p.post_title, p.post_date, p.post_category, c.cat_name FROM &#8220;.$xoopsDB->prefix(&#8220;wp_posts&#8221;).&#8221; p, &#8220;.$xoopsDB->prefix(&#8220;wp_categories&#8221;).&#8221; c, &#8220;.$xoopsDB->prefix(&#8220;wp_post2cat&#8221;).&#8221; r WHERE p.ID=r.post_id AND r.category_id=c.cat_ID AND post_status=&#8217;publish'&#8221;.$add_sql.&#8221; ORDER BY p.post_date DESC&#8221;;<br \/>\n} else {<br \/>\n$sql = &#8220;SELECT p.ID, p.post_content, p.post_title, p.post_date, p.post_category, c.cat_name FROM &#8220;.$xoopsDB->prefix(&#8220;wp&#8221;.substr($key,-1,1).&#8221;_posts&#8221;).&#8221; p, &#8220;.$xoopsDB->prefix(&#8220;wp&#8221;.substr($key,-1,1).&#8221;_categories&#8221;).&#8221; c, &#8220;.$xoopsDB->prefix(&#8220;wp&#8221;.substr($key,-1,1).&#8221;_post2cat&#8221;).&#8221; r WHERE p.ID=r.post_id AND r.category_id=c.cat_ID AND post_status=&#8217;publish'&#8221;.$add_sql.&#8221; ORDER BY p.post_date DESC&#8221;;\n<\/p><\/blockquote>\n<p>\u3053\u3053\u306eWHERE\u306e\u6700\u5f8c\u306b\u300c AND p.post_date <= NOW()\u300d\u3092\u8db3\u3057\u305f\u3060\u3051\u3002\n\n\n<blockquote>if ($key==&#8217;wordpress&#8217;) {<br \/>\n$sql = &#8220;SELECT p.ID, p.post_content, p.post_title, p.post_date, p.post_category, c.cat_name FROM &#8220;.$xoopsDB->prefix(&#8220;wp_posts&#8221;).&#8221; p, &#8220;.$xoopsDB->prefix(&#8220;wp_categories&#8221;).&#8221; c, &#8220;.$xoopsDB->prefix(&#8220;wp_post2cat&#8221;).&#8221; r WHERE p.ID=r.post_id AND r.category_id=c.cat_ID AND post_status=&#8217;publish&#8217; AND p.post_date <= NOW()\".$add_sql.\" ORDER BY p.post_date DESC\";\n} else {\n$sql = \"SELECT p.ID, p.post_content, p.post_title, p.post_date, p.post_category, c.cat_name FROM \".$xoopsDB->prefix(&#8220;wp&#8221;.substr($key,-1,1).&#8221;_posts&#8221;).&#8221; p, &#8220;.$xoopsDB->prefix(&#8220;wp&#8221;.substr($key,-1,1).&#8221;_categories&#8221;).&#8221; c, &#8220;.$xoopsDB->prefix(&#8220;wp&#8221;.substr($key,-1,1).&#8221;_post2cat&#8221;).&#8221; r WHERE p.ID=r.post_id AND r.category_id=c.cat_ID AND post_status=&#8217;publish&#8217; AND p.post_date <= NOW()\".$add_sql.\" ORDER BY p.post_date DESC\";\n<\/p><\/blockquote>\n<p>\u59cb\u3081\u308b\u524d\u306b\u3001\u305a\u3044\u3076\u3093\u524d\u306b\u8cb7\u3063\u3066\u8aad\u3093\u3067\u306a\u304b\u3063\u305fPHP\u5165\u9580\u66f8\u306e\u6587\u6cd5\u306e\u6240\u3060\u3051\u8aad\u3093\u3067\u6539\u9020\u306b\u3042\u305f\u3063\u305f\u306e\u3060\u3051\u3069\u3001\u5168\u7136\u305d\u3093\u306a\u306e\u5fc5\u8981\u3042\u308a\u307e\u305b\u3093\u3067\u3057\u305f\u3002<br \/>\n\u3053\u308c\u3067\u4f55\u304b\u601d\u3044\u3064\u3044\u305f\u30cd\u30bf\u3092\u5c0f\u51fa\u3057\u306b\u51fa\u3057\u3066\u3044\u3051\u308b\u306d!(\u7b11)<\/p><div id=\"advads-2879368768\" class=\"advads-content-placement-after-3rd-paragraph advads-entity-placement\" style=\"margin-left: auto;margin-right: auto;text-align: center;\"><div class=\"advads-adlabel\">\u5e83\u544a<\/div><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-7585646298782746\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:inline-block;width:300px;height:250px;\" \ndata-ad-client=\"ca-pub-7585646298782746\" \ndata-ad-slot=\"6112122906\"><\/ins> \n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u4eca\u56de\u601d\u3044\u3063\u304d\u308a\u6280\u8853\u7684\u306a\u304a\u8a71(\u30e1\u30e2)\u3002 XOOPS\u306e\u3044\u308d\u3093\u306a\u30e2\u30b8\u30e5\u30fc\u30eb\u306eRSS\u914d\u4fe1\u3092\u4e00\u624b\u306b\u5f15\u304d\u53d7\u3051\u308b\u305f\u3081\u306e\u30e2\u30b8\u30e5\u30fc\u30ebRSSfitJ\u3002 \u3053\u308c\u306b\u306fRSS\u306b\u5bfe\u5fdc\u3057\u3066\u3044\u306a\u3044\u30e2\u30b8\u30e5\u30fc\u30eb\u3082\u542b\u3081\u3066\u4e00\u3064\u306eRSS\u30d5\u30a3\u30fc\u30c9\u3067\u66f4\u65b0\u60c5\u5831\u3092\u63d0\u4f9b\u3067\u304d [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5229,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_crdt_document":"","_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[479],"tags":[],"class_list":["post-874","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-xoops"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/a-tak.com\/blog\/wp-content\/uploads\/2012\/06\/4891.png?fit=111%2C59&ssl=1","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/posts\/874","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/comments?post=874"}],"version-history":[{"count":0,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/posts\/874\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/media\/5229"}],"wp:attachment":[{"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/media?parent=874"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/categories?post=874"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/a-tak.com\/blog\/wp-json\/wp\/v2\/tags?post=874"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}