{"id":288,"date":"2005-04-18T00:00:09","date_gmt":"2005-04-17T21:00:09","guid":{"rendered":"http:\/\/www.all-things-me.net\/blog\/archives\/2005\/04\/18\/tweaking-alex-kings-since-last-visit-hack"},"modified":"2005-04-28T23:33:14","modified_gmt":"2005-04-28T20:33:14","slug":"tweaking-since-last-visit-hack","status":"publish","type":"post","link":"https:\/\/www.all-things-me.net\/blog\/2005\/04\/18\/tweaking-since-last-visit-hack","title":{"rendered":"Tweaking Since Last Visit hack"},"content":{"rendered":"

I don’t use the JavaScript version<\/a> of Alex King’s Since Last Visit hack\/plugin because I don’t like to depend on JS. And I didn’t even get it working back when I tried it out \":laugh:\"<\/p>\n

After keeping the comment referred to in my I noticed that the targetted post was showing new comments. So, I added a requirement to the database query in function ak_new_comments: and comment_approved not like 'spam'<\/code> making it say<\/p>\n

if (isset($ak_last_visit)) {
\n $last_visit = date(“Y-m-d H:i:s”, $ak_last_visit);
\n $comment_date = $wpdb->get_var(“SELECT MAX(comment_date)”
\n .”FROM $tablecomments ”
\n .”WHERE comment_post_ID = ‘$post_id’ and comment_approved not like ‘spam’<\/strong>”
\n );
\n if ($comment_date > $last_visit) {
\n  echo $html;
\n }
\n}<\/p><\/blockquote>\n

around line 178. No more ghost comments.<\/p>\n

(Database studies came in handy, yet again.)<\/p>\n","protected":false},"excerpt":{"rendered":"

I don’t use the JavaScript version of Alex King’s Since Last Visit hack\/plugin because I don’t like to depend on JS. And I didn’t even get it working back when I tried it out After keeping the comment referred to in my I noticed that the targetted post was showing new comments. So, I added […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15,18],"tags":[],"class_list":["post-288","post","type-post","status-publish","format-standard","hentry","category-tweaks","category-wordpress"],"_links":{"self":[{"href":"https:\/\/www.all-things-me.net\/blog\/wp-json\/wp\/v2\/posts\/288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.all-things-me.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.all-things-me.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.all-things-me.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.all-things-me.net\/blog\/wp-json\/wp\/v2\/comments?post=288"}],"version-history":[{"count":0,"href":"https:\/\/www.all-things-me.net\/blog\/wp-json\/wp\/v2\/posts\/288\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.all-things-me.net\/blog\/wp-json\/wp\/v2\/media?parent=288"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.all-things-me.net\/blog\/wp-json\/wp\/v2\/categories?post=288"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.all-things-me.net\/blog\/wp-json\/wp\/v2\/tags?post=288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}