{"id":557,"date":"2009-08-06T06:27:09","date_gmt":"2009-08-05T21:27:09","guid":{"rendered":"http:\/\/www.white-room.jp\/blog\/?p=557"},"modified":"2009-08-06T06:42:38","modified_gmt":"2009-08-05T21:42:38","slug":"wp-click-tracker-2","status":"publish","type":"post","link":"https:\/\/www.white-room.jp\/blog\/?p=557","title":{"rendered":"WP-Click-Tracker"},"content":{"rendered":"<p>\u4ee5\u524d\u6307\u6458\u3057\u305f\u3001<a href=\"http:\/\/blog.ericlamb.net\/projects\/wp-click-track\/\" target=\"_blank\" title=\"wp-click-track\">WP-Click-Tracker<\/a>\u306e\u30cf\u30fc\u30c9\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u554f\u984c\u3067\u3059\u304c\u3001\u73fe\u884c\u30d0\u30fc\u30b8\u30e7\u30f3\u306e0.5.1\u306b\u3082\u307e\u3060\u6b8b\u3063\u3066\u3044\u307e\u3057\u305f\u3002<\/p>\n<p>\u30b0\u30e9\u30d5\u3092open flash chart\u306b\u5909\u66f4\u3057\u305f\u30d0\u30fc\u30b8\u30e7\u30f3\u304b\u3089\u5165\u3063\u305f\/wp-content\/plugins\/wp-click-track\/reporting.php \u306eSQL\u3092\u7d44\u307f\u7acb\u3066\u308b\u90e8\u5206\u306eDB\u540d\u306eprefix\u304c\u3059\u3079\u3066Wordpress\u30c7\u30d5\u30a9\u30eb\u30c8\u306ewp_tracking_clicks,wp_tracking_links\u306b\u306a\u3063\u3066\u3044\u3066\u3001prefix\u3092\u30c7\u30d5\u30a9\u30eb\u30c8\u304b\u3089\u5909\u66f4\u3059\u308b\u3068\u3001\u30b0\u30e9\u30d5\u304c\u8868\u793a\u3055\u308c\u307e\u305b\u3093\u3002<\/p>\n<p>\u3082\u3061\u308d\u3093\u3001apache\u306e\u30a8\u30e9\u30fc\u30ed\u30b0\u3092\u898b\u308c\u3070\u3059\u3050\u306b\u5206\u304b\u308b\u3057\u3001prefix\u3092\u30c7\u30d5\u30a9\u30eb\u30c8\u304b\u3089\u5909\u66f4\u3059\u308b\u610f\u5473\u306f\u3042\u3093\u307e\u3057\u306a\u3044\u3093\u3067\u3001\u5b9f\u5bb3\u304c\u7121\u3044\u3063\u3066\u8a00\u3048\u3070\u7121\u3044\u3093\u3067\u3059\u304c\u2026\u2026\u3002<\/p>\n<p>\u4e00\u5fdc\u3001\u3053\u3053\u306f<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n\/* \/wp-content\/plugins\/wp-click-track\/reporting.php *\/\r\n$sql = &quot;some sql &quot;.$wpdb-&gt;prefix.&quot;tracking_clicks&quot;\r\n$sql = &quot;some sql &quot;.$wpdb-&gt;prefix.&quot;tracking_links&quot;\r\n<\/pre>\n<p>\u3068\u3059\u3079\u304d\u3067\u3057\u3087\u3046\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u4ee5\u524d\u6307\u6458\u3057\u305f\u3001WP-Click-Tracker\u306e\u30cf\u30fc\u30c9\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u554f\u984c\u3067\u3059\u304c\u3001\u73fe\u884c\u30d0\u30fc\u30b8\u30e7\u30f3\u306e0.5.1\u306b\u3082\u307e\u3060\u6b8b\u3063\u3066\u3044\u307e\u3057\u305f\u3002 \u30b0\u30e9\u30d5\u3092open flash chart\u306b\u5909\u66f4\u3057\u305f\u30d0\u30fc\u30b8\u30e7\u30f3\u304b\u3089\u5165\u3063\u305f\/wp-conten [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-557","post","type-post","status-publish","format-standard","hentry","category-wordpress"],"_links":{"self":[{"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/557","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=557"}],"version-history":[{"count":0,"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/557\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=557"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=557"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=557"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}