{"id":508,"date":"2009-04-22T17:20:49","date_gmt":"2009-04-22T08:20:49","guid":{"rendered":"http:\/\/www.white-room.jp\/blog\/?p=508"},"modified":"2009-08-06T06:43:49","modified_gmt":"2009-08-05T21:43:49","slug":"wp-click-tracker","status":"publish","type":"post","link":"https:\/\/www.white-room.jp\/blog\/?p=508","title":{"rendered":"WP-Click-Tracker"},"content":{"rendered":"<p>\u30ea\u30f3\u30af\u306e\u30af\u30ea\u30c3\u30af\u3092\u8a18\u9332\u3059\u308b\u3001<a href=\"http:\/\/blog.ericlamb.net\/wp-click-track\/\" target=\"_blank\" title=\"\">wp-click-tracker<\/a>\u3067\u3059\u304c\u3001\u306a\u304b\u306a\u304b\u697d\u3057\u3044\u3067\u3059\u3002<\/p>\n<p>a-blog\uff80\uff9d\u3082\u63a1\u7528\u3057\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u3069\u306e\u30ea\u30f3\u30af\u304c\u30af\u30ea\u30c3\u30af\u3055\u308c\u305f\u304b\u304c\u308f\u304b\u3063\u3066\u3001\u3044\u3044\u5869\u6885\u3067\u3059\u3002\u4f55\u306e\u5f79\u306b\u7acb\u3064\u3063\u3066\u308f\u3051\u3067\u3082\u306a\u3044\u3093\u3067\u3059\u304c\u2026\u2026\u3002<\/p>\n<p>\u3068\u3063\u3066\u3082\u7acb\u6d3e\u306awp-click-tracker\u3067\u3059\u304c\u3001\u3061\u3087\u3063\u3068\u30cf\u30fc\u30c9\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u304c\u76ee\u7acb\u3061\u307e\u3059\u3002<\/p>\n<p>0.4.2\u3067\u4fee\u6b63\u3055\u308c\u307e\u3057\u305f\u304c\u3001admin.inc.php\u306e\u30c0\u30c3\u30b7\u30e5\u30dc\u30fc\u30c9\u306e\u30a6\u30a3\u30b8\u30a7\u30c3\u30c8\u304b\u3089\u306e\u30ea\u30f3\u30af\u304c\u30c8\u30c3\u30d7\u30ec\u30d9\u30eb\u306b\u8a2d\u7f6e\u3059\u308b\u306e\u3092\u524d\u63d0\u306b\u30cf\u30fc\u30c9\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3055\u308c\u3066\u3044\u3066\u3001\u8a2d\u7f6e\u5834\u6240\u3092\u5909\u66f4\u3059\u308b\u3068\uff08http:\/\/example.com\/ \u304b\u3089http:\/\/example.com\/example\/\u3078\uff09\u30ea\u30f3\u30af\u5148\u304c\u5909\u308f\u3063\u3066\u3001\u8868\u793a\u3055\u308c\u306a\u304f\u306a\u308a\u307e\u3057\u305f\u3002<\/p>\n<p>\u540c\u3058\u3088\u3046\u306a\u306e\u304c\u30010.4.2\u3067\u3082\u6b8b\u3063\u3066\u3044\u307e\u3059\u3002SQL\u3092\u767a\u884c\u3059\u308b\u3068\u3053\u308d\u3067\u3001\u30c6\u30fc\u30d6\u30eb\u540d\u304cwordpress\u306e\u30c7\u30d5\u30a9\u30eb\u30c8\u540d\u3067\u30cf\u30fc\u30c9\u30b3\u30fc\u30c7\u30a3\u30f3\u30b0\u3055\u308c\u3066\u3044\u307e\u3059\u3002<\/p>\n<pre class=\"brush: php; title: ; notranslate\" title=\"\">\r\n\/* admin.inc.php 593line *\/\r\n$sql = &quot;SELECT weekday(click_date) AS Day,COUNT(weekday(click_date)) AS CLICKCOUNT FROM `wp_tracking_clicks` WHERE link_id = &#039;&quot;.$wpdb-&gt;escape($link_id).&quot;&#039; GROUP BY Day ORDER BY Day&quot;;\r\n\r\n\/* admin.inc.php line 634 *\/\r\n\t$sql = &quot;SELECT HOUR(click_date) AS Hour,COUNT(HOUR(click_date)) AS Clicks FROM `wp_tracking_clicks` WHERE link_id = &#039;&quot;.$wpdb-&gt;escape($link_id).&quot;&#039; GROUP BY Hour ORDER BY Hour&quot;;\r\n\r\n\/* admin.inc.php  line 799 *\/\r\n\t$sql = &quot;SELECT COUNT(tc.link_id) AS click_count, date_format(click_date,\\&quot;%Y-%m-%d\\&quot;) AS click_date_f FROM wp_tracking_clicks tc, wp_tracking_links tl WHERE tc.link_id = tl.link_id AND date_format(click_date,\\&quot;%Y-%m-%d\\&quot;) &gt;= &#039;$date&#039; GROUP BY click_date_f ORDER BY click_date &quot;;\r\n\r\n\/* admin.inc.php  line 841 *\/\r\n\t$sql = &quot;SELECT COUNT(tc.link_id) AS click_count, date_format(click_date,\\&quot;%Y-%m-%d\\&quot;) AS click_date_f FROM wp_tracking_clicks tc, wp_tracking_links tl WHERE tc.link_id = tl.link_id AND date_format(click_date,\\&quot;%Y-%m-%d\\&quot;) &gt;= &#039;$date&#039; GROUP BY click_date_f ORDER BY click_date &quot;;\r\n\r\n\/* admin.inc.php  line 882 *\/\r\n\t\t$sql = &quot;SELECT COUNT(click_id) AS click_count,wp_tracking_clicks.link_id AS link_id, date_format(click_date,\\&quot;%Y-%m-%d\\&quot;) AS click_date, link_title, link_destination, click_refer FROM wp_tracking_links,wp_tracking_clicks WHERE wp_tracking_links.link_id = wp_tracking_clicks.link_id AND date_format(click_date,\\&quot;%Y-%m-%d\\&quot;) = &#039;$date&#039; AND click_refer != &#039;&#039; GROUP BY wp_tracking_clicks.link_id ORDER BY click_count LIMIT 8&quot;;\r\n\r\n\/*\r\n$wpdb-&gt;prefix.&quot;tracking_clicks\r\n$wpdb-&gt;prefix.&quot;tracking_links\r\n\u3068\u3001\u3057\u305f\u307b\u3046\u304c\u3044\u3044\u6240\u304c\u3001\u305d\u308c\u305e\u308c\u3001wp_tracking_clicks\u3001wp_tracking_links\u306b\u306a\u3063\u3066\u3044\u308b\u3002\r\n*\/\r\n<\/pre>\n<p>\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u4f7f\u3063\u3066\u3044\u308c\u3070\u3001\u306a\u3093\u306e\u554f\u984c\u3082\u306a\u3044\u306e\u3067\u3059\u304c\u3001wordpress\u306f\u30a4\u30f3\u30b9\u30c8\u30fc\u30eb\u6642\u306b\u30c6\u30fc\u30d6\u30eb\u306e\u30d7\u30ec\u30d5\u30a3\u30c3\u30af\u30b9\u3092\u5909\u66f4\u3067\u304d\u308b\u3088\u3046\u306b\u306a\u3063\u3066\u3044\u308b\u306e\u3067\u3001\u3053\u3053\u306f\u5909\u6570\u3067\u62fe\u3063\u3066\u304f\u308b\u3079\u304d\u3067\u3057\u3087\u3046\u3002\u3063\u3066\u3044\u3046\u304b\u3001click-tracker.php\u306e\u307b\u3046\u306f\u305d\u3046\u306a\u3063\u3066\u308b\u3057\u2026\u2026\u3002<\/p>\n<p>\u3068\u3001\u3044\u3063\u305f\u3088\u3046\u306a\u3053\u3068\u3092\u3001\u6a5f\u68b0\u7ffb\u8a33\u3067\u4f5c\u8005\u306e\u30d6\u30ed\u30b0\u306b\u30b3\u30e1\u30f3\u30c8\u3057\u305f\u3089\u3001SPAM\u3068\u5224\u65ad\u3055\u308c\u305f\u3089\u3057\u304f\u3001\u6d88\u3055\u308c\u3061\u3083\u3044\u307e\u3057\u305fw\u3002<\/p>\n<p>\u82f1\u8a9e\u3082\u3067\u304d\u306a\u3044\u306e\u306b\u3001\u7121\u7406\u3057\u306a\u3044\u3067\u3001\u4ee5\u524d\u3001\u3088\u305d\u3067\u30d0\u30b0\u3092\u6307\u6458\u3057\u305f\u3068\u304d\u307f\u305f\u3044\u306b\u3001\u52d5\u304b\u306a\u3044\u539f\u56e0\u306e\u30b3\u30fc\u30c9\u306b\u2190\u3044\u307e\u3053\u3053\u307f\u305f\u3044\u306a\u611f\u3058\u3067\u6307\u6458\u3059\u308b\u306e\u304c\u7121\u96e3\u304b\u3082\u2026\u2026\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u30ea\u30f3\u30af\u306e\u30af\u30ea\u30c3\u30af\u3092\u8a18\u9332\u3059\u308b\u3001wp-click-tracker\u3067\u3059\u304c\u3001\u306a\u304b\u306a\u304b\u697d\u3057\u3044\u3067\u3059\u3002 a-blog\uff80\uff9d\u3082\u63a1\u7528\u3057\u3066\u3044\u307e\u3057\u305f\u304c\u3001\u3069\u306e\u30ea\u30f3\u30af\u304c\u30af\u30ea\u30c3\u30af\u3055\u308c\u305f\u304b\u304c\u308f\u304b\u3063\u3066\u3001\u3044\u3044\u5869\u6885\u3067\u3059\u3002\u4f55\u306e\u5f79\u306b\u7acb\u3064\u3063\u3066\u308f\u3051\u3067\u3082\u306a\u3044\u3093\u3067\u3059\u304c\u2026 [&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-508","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\/508","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=508"}],"version-history":[{"count":0,"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=\/wp\/v2\/posts\/508\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=508"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=508"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.white-room.jp\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=508"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}