Shortcode Support Added to SQL Reports

I added a shortcode to my SQL Reports Plugin so you can put a report you’ve created into a Page or Post. Just use the shortcode “SQLREPORT” with the attribute “name” being the name or your desired report. Like this:
[SQLREPORT name="My Report" style="border: 2px solid #CCCCCC; padding: 6px;" /]

The below example is a Report that I make to see the effect that Google’s SSL Search has been having on my Keyword Data. I broke it down by Locale so that I could see the differences between the use of google.com as compared to the other country codes.



The disastrous effect of social inequality on health and social stability

Richard Wilkinson, Professor Emeritus of Social Epidemiology at the University of Nottingham, presented huge amounts of evidence in his book The Spirit Level (co-authored with Kate Pickett) about the disastrous effect of social inequality on health and social stability. This video of his TED Talk gives a summary of some of that research.

Found and fixed a lingering issue with the Related Posts sometimes not showing up

After a lot of reports of an intermittent issue with the Related Posts sometimes not showing up I have finally found and fixed the bug that caused it. Please download this new version 1.2.03.04 which also includes Post dates and Excerpt support. These patches and new features seem to have spawned a new wave of interest as I now have over 10,000 downloads!

Snapshot of my download stats to-date.

The odd thing about these stats is that it seems to show over 600 downloads since I uploaded version 1.2.03, which is about 6% of all downloads, yet the latest versions represented in the pie chat above are 1.2.02 and below. Anyone have any idea when and how these stats are compiled? Please comment.


I’m working on an Anti-Malware plugin for WordPress.

I haven’t posted anything this whole month because one of my servers got hacked and I’ve spent the last three week working on a new plugin to scan and remove malicious software from my server.

It wasn’t enough for me to just remove the hack. I had to make sure it wouldn’t come back and because it was such a widespread exploit I thought it would be good to release a plugin for other website admins to check their site for themselves.

I looks like my infestation of nasty scripts came in through a vulnerability in an older version of timthumb.php. Apparently any version older that 2.0 can be used to place a file on the server. If that file is a back-door of some kind then the person who put it there could have full access to your server.

I’m still testing and working out the kinks in my security scanner but it should be ready soon…


Google announced that signed-in users will, by default, be routed to the SSL version of Google Search

In October of 2011 Google announced that signed-in users will, by default, be routed to the SSL version of Google Search (https://www.google.com).

What is the impact of this change for webmasters?
A web site accessed through organic search results on http://www.google.com (non-SSL) can see both that the user came from google.com and their search query.
However, for organic search results on Google’s SSL search, a web site will only know that the user came from google.com.

This is bad news for anyone who wants to know what keywords were used to find their site on Goggle.

Over two thirds (69%) of my Google Analytics Keywords now show up as “(not provided)”. This completely cripples my ability to tell how people are finding my site.

Here is a good video I found on SEOmoz that goes into more details and explains how it works:

Wistia