{"id":140,"date":"2010-03-06T16:39:56","date_gmt":"2010-03-06T07:39:56","guid":{"rendered":"http:\/\/blog.isnext.net\/issy\/?p=140"},"modified":"2010-03-06T16:41:02","modified_gmt":"2010-03-06T07:41:02","slug":"mynets%e3%82%bd%e3%83%bc%e3%82%b7%e3%83%a3%e3%83%ab%e3%83%9e%e3%83%83%e3%83%97%e6%a4%9c%e7%b4%a2%e3%81%ae%e9%ab%98%e9%80%9f%e5%8c%96%ef%bc%88tritonn%e5%af%be%e5%bf%9c%ef%bc%89","status":"publish","type":"post","link":"https:\/\/blog.isnext.net\/issy\/archives\/140","title":{"rendered":"MyNETS\u30bd\u30fc\u30b7\u30e3\u30eb\u30de\u30c3\u30d7\u691c\u7d22\u306e\u9ad8\u901f\u5316\uff08Tritonn\u5bfe\u5fdc\uff09"},"content":{"rendered":"<p>2009\u5e749\u6708\u306bUsagi-project\u306b\u5bc4\u7a3f\u3057\u305f\u3082\u306e\u3002<\/p>\n<p>\u73fe\u72b6\u306eMyNETS\u3067\u30c7\u30fc\u30bf\u91cf\u304c\u5897\u3048\u3066\u51fa\u3066\u304f\u308b\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u3068\u3057\u3066\u3001\u4ee5\u524d\u65e5\u8a18\u691c\u7d22\u304clike\u3067\u884c\u308f\u308c\u3066\u3044\u308b\u72b6\u6cc1\u3092\u6539\u5584\u3059\u308b\u305f\u3081Tritonn\u3092\u4f7f\u3063\u305f\u9ad8\u901f\u5316\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f\u3002<\/p>\n<p>\u3053\u308c\u3067\u3057\u3070\u3089\u304f\u9ad8\u8ca0\u8377\u304c\u767a\u751f\u3059\u308b\u306e\u3092\u9632\u3052\u3066\u3044\u305f\u306e\u3067\u3059\u304c\u3001\u6b21\u306e\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u304c\u767a\u751f\u3057\u3066\u304d\u307e\u3057\u305f\u3002\u305d\u308c\u304c\u500b\u4ebaTOP\u30da\u30fc\u30b8\u306e\u30b5\u30e0\u30cd\u4e0b\u300c\u30bd\u30fc\u30b7\u30e3\u30eb\u30de\u30c3\u30d7\u300d\u306e\u30da\u30fc\u30b8\u306e\u8868\u793a\u3067\u3059\u3002<\/p>\n<p>\u3053\u306e\u30da\u30fc\u30b8\u3092\u958b\u304f\u3068\u5168\u65e5\u8a18\u672c\u6587\uff0b\u30b3\u30e1\u30f3\u30c8\u53ca\u3073\u5168\u30c8\u30d4\u30c3\u30af\u30b3\u30e1\u30f3\u30c8\u304b\u3089GoogleMap\u7528\u306ecmd\u3092like\u691c\u7d22\u3059\u308b\u305f\u3081\u3001\u5927\u304d\u306a\u8ca0\u8377\u304c\u767a\u751f\u3059\u308b\u3053\u3068\u306b\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u305d\u3053\u3067\u3053\u3053\u3082Tritonn\u3067\u5bfe\u7b56\u3057\u305f\u306e\u3067\u3001\u5bfe\u5fdc\u65b9\u6cd5\u3092\u7d39\u4ecb\u3057\u3066\u304a\u304d\u307e\u3059\u3002<\/p>\n<p>\u30fc\u30fc\u30fc<br \/>\n\u25a0\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u306bindex\u8ffd\u52a0<\/p>\n<p>[code]<br \/>\nALTER TABLE c_diary_comment ADD FULLTEXT fullindex USING SENNA,NGRAM,NORMALIZE (body);<br \/>\nALTER TABLE c_commu_topic_comment ADD FULLTEXT fullindex USING SENNA,NGRAM,NORMALIZE (body);<br \/>\n[\/code]<\/p>\n<p>\u25a0webapp\/lib\/db\/read\/gmaps.php\u3092\u4fee\u6b63<\/p>\n<p>[code]<br \/>\nfunction p_h_gmaps_list_all_search_c_diary4c_diary($keyword, $page_size, $page)<br \/>\n{<\/p>\n<p>    \/\/and\u691c\u7d22\u3092\u5b9f\u88c5<br \/>\n    \/\/subject,body \u3092\u691c\u7d22<br \/>\n    if ($keyword) {<br \/>\n        \/\/\u5168\u89d2\u7a7a\u767d\u3092\u534a\u89d2\u306b\u7d71\u4e00<br \/>\n        $keyword = str_replace(&#8216;\u3000&#8217;, &#8216; &#8216;, $keyword);<\/p>\n<p>        $keyword_list = explode(&#8216; &#8216;, $keyword);<br \/>\n        foreach ($keyword_list as $word) {<br \/>\n            $word = check_search_word($word);<br \/>\n            $where_d .= &#8216; AND (&#8216;. MYNETS_PREFIX_NAME .&#8217;c_diary.subject LIKE &#8220;%&#8217;.$word.&#8217;%&#8221; OR &#8216;. MYNETS_PREFIX_NAME .&#8217;c_diary.body LIKE &#8220;%&#8217;.$word.&#8217;%&#8221;)&#8217;;<br \/>\n            $where_dc .= &#8216; AND (&#8216;. MYNETS_PREFIX_NAME .&#8217;c_diary.subject LIKE &#8220;%&#8217;.$word.&#8217;%&#8221; OR &#8216;. MYNETS_PREFIX_NAME .&#8217;c_diary_comment.body LIKE &#8220;%&#8217;.$word.&#8217;%&#8221;)&#8217;;<br \/>\n        }<br \/>\n    }<br \/>\n[\/code]<\/p>\n<p>\u306e\u90e8\u5206\u3092\u4ee5\u4e0b\u306b\u4fee\u6b63\uff08MYNETS_PREFIX_NAME\u306f\u7121\u3057\u3067\u4eee\u5b9a\uff09<\/p>\n<p>[code]<br \/>\nfunction p_h_gmaps_list_all_search_c_diary4c_diary($keyword, $page_size, $page)<br \/>\n{<\/p>\n<p>    \/\/and\u691c\u7d22\u3092\u5b9f\u88c5<br \/>\n    \/\/subject,body \u3092\u691c\u7d22<br \/>\n    if ($keyword) {<br \/>\n        \/\/\u5168\u89d2\u7a7a\u767d\u3092\u534a\u89d2\u306b\u7d71\u4e00<br \/>\n        $keyword = str_replace(&#8216;\u3000&#8217;, &#8216; &#8216;, $keyword);<br \/>\n\t\t\/\/SQL Injection\u5bfe\u7b56<br \/>\n\t\t$keyword = str_replace(&#8216;\\\\&#8217;, &#8221;, $keyword);<br \/>\n\t\t$keyword = str_replace(&#8216;&#8221;&#8216;, &#8221;, $keyword);<br \/>\n\t\t$keyword = str_replace(&#8216;;&#8217;, &#8221;, $keyword);<br \/>\n\t\t$keyword = str_replace(&#8216;)&#8217;, &#8221;, $keyword);<\/p>\n<p>        $keyword_list = explode(&#8216; &#8216;, $keyword);<br \/>\n        foreach ($keyword_list as $word) {<br \/>\n            $word = check_search_word($word);<br \/>\n            $where_d .= &#8216; AND MATCH (c_diary.subject, c_diary.body) AGAINST (&#8220;&#8216; .$keyword. &#8216;&#8221; IN BOOLEAN MODE)&#8217;;<br \/>\n            $where_dc .= &#8216; AND (MATCH (c_diary.subject, c_diary.body) AGAINST (&#8220;&#8216; .$keyword. &#8216;&#8221; IN BOOLEAN MODE) OR MATCH (c_diary_comment.body) AGAINST (&#8220;&#8216; .$keyword. &#8216;&#8221; IN BOOLEAN MODE))&#8217;;<br \/>\n        }<br \/>\n    }<br \/>\n[\/code]<\/p>\n<p>\u4ee5\u4e0b\u306e\u691c\u7d22\u30b3\u30fc\u30c9\u3092\u305d\u308c\u305e\u308c\u7f6e\u63db\u3059\u308b\u3002\u5168\u90e8\u306717\u30ab\u6240\u3002<br \/>\n\uff08MYNETS_PREFIX_NAME\u306f\u7121\u3057\u3067\u4eee\u5b9a\uff09<\/p>\n<p>\u65e5\u8a18\u672c\u6587\u691c\u7d22\u90e8\u5206<br \/>\n[code]<br \/>\n&#8221; WHERE &#8221; . MYNETS_PREFIX_NAME . &#8220;c_diary.body like &#8216;%<cmd src=\\\"gmaps\\\" args=\\\"%,%,%,%,%\\\">%'&#8221; .<br \/>\n[\/code]<br \/>\n\u3000\u2193<br \/>\n[code]<br \/>\n&#8221; WHERE match(c_diary.subject, c_diary.body) against (\\&#8221;<cmd src=\\\\\\\"gmaps\\\\\\\" args=\\\\\\\"\\\")\" .\n[\/code]\n\n\n\u65e5\u8a18\u30b3\u30e1\u30f3\u30c8\u691c\u7d22\u90e8\u5206\n[code]\n\" WHERE \" . MYNETS_PREFIX_NAME . \"c_diary_comment.body like '%<cmd src=\\\"gmaps\\\" args=\\\"%,%,%,%,%\\\">%'&#8221; .<br \/>\n[\/code]<br \/>\n\u3000\u2193<br \/>\n[code]<br \/>\n&#8221; WHERE match(c_diary_comment.body) against (\\&#8221;<cmd src=\\\\\\\"gmaps\\\\\\\" args=\\\\\\\"\\\")\" .\n[\/code]\n\n\n\u30c8\u30d4\u30c3\u30af\u30b3\u30e1\u30f3\u30c8\u691c\u7d22\u90e8\u5206\n[code]\n\" WHERE \" . MYNETS_PREFIX_NAME . \"c_commu_topic_comment.body like '%<cmd src=\\\"gmaps\\\" args=\\\"%,%,%,%,%\\\">%'&#8221; .<br \/>\n[\/code]<br \/>\n\u3000\u2193<br \/>\n[code]<br \/>\n&#8221; WHERE match(c_commu_topic_comment.body) against (\\&#8221;<cmd src=\\\\\\\"gmaps\\\\\\\" args=\\\\\\\"\\\")\" .\n[\/code]\n\n\u4ee5\u4e0a\u3002\n<\/p>\n","protected":false},"excerpt":{"rendered":"<p>2009\u5e749\u6708\u306bUsagi-project\u306b\u5bc4\u7a3f\u3057\u305f\u3082\u306e\u3002 \u73fe\u72b6\u306eMyNETS\u3067\u30c7\u30fc\u30bf\u91cf\u304c\u5897\u3048\u3066\u51fa\u3066\u304f\u308b\u30dc\u30c8\u30eb\u30cd\u30c3\u30af\u3068\u3057\u3066\u3001\u4ee5\u524d\u65e5\u8a18\u691c\u7d22\u304clike\u3067\u884c\u308f\u308c\u3066\u3044\u308b\u72b6\u6cc1\u3092\u6539\u5584\u3059\u308b\u305f\u3081Tritonn\u3092\u4f7f\u3063\u305f\u9ad8\u901f\u5316\u3092\u7d39\u4ecb\u3057\u307e\u3057\u305f &hellip; <a href=\"https:\/\/blog.isnext.net\/issy\/archives\/140\" class=\"more-link\"><span class=\"screen-reader-text\">&#8220;MyNETS\u30bd\u30fc\u30b7\u30e3\u30eb\u30de\u30c3\u30d7\u691c\u7d22\u306e\u9ad8\u901f\u5316\uff08Tritonn\u5bfe\u5fdc\uff09&#8221; \u306e<\/span>\u7d9a\u304d\u3092\u8aad\u3080<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[20,22,23],"class_list":["post-140","post","type-post","status-publish","format-standard","hentry","category-linux","tag-centos","tag-mynets","tag-tritonn"],"_links":{"self":[{"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/posts\/140","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/comments?post=140"}],"version-history":[{"count":2,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/posts\/140\/revisions"}],"predecessor-version":[{"id":142,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/posts\/140\/revisions\/142"}],"wp:attachment":[{"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/media?parent=140"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/categories?post=140"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.isnext.net\/issy\/wp-json\/wp\/v2\/tags?post=140"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}