I just released a major update for my SQL Reports plugin. The new version, 3.06.14, has a lot of exiting new features like automatic scheduled backups of your database, and the ability to save archives of your DB and have them emailed to you. You can also retore these backups directly into your native WP DB or to an external database. The plugin uses the WordPress CRON API to schedule hourly and/or daily DB backups.
I also added a quick and easy shortcode for displaying a single variable from an SQL query. Just wrap your SQL query in the sqlgetvar short code like this:
[sqlgetvar]SELECT COUNT(*) FROM wp_users[/sqlgetvar]
Have fun with these new features and let me know if you have any ideas or suggestions for improvements.
I went ahead and released this Widget as is. I was hoping to get a sponsor for it’s release but it looks like it will just be another free plugin that I work on in my “spare” time.
You can download the plugin from the WordPress Repository here:
If you like this widget, want to support the Hawaiian Language Revitalization movement, or want me to make improvements to this plugin, send me a donation and tell me what you want to me to do with it.
Less than a month in the WordPress Repository and already over 1,400 downloads. There is definitely an unmet need for a Plugin like this. Despite the instant popularity and success of my Malware Removal techniques, even with all the great comments and thanks that I am getting for actively fighting back against these defacement and redirection hacks, I have just come under some criticism from the “Half-Elf” Plugin Monitor, Ipstenu. Though I feel that my strategy in fighting infections is efficient, effective, and easy to implement, she seems to think it is too risky to actually do something about the infected files and suggested I just notify the user of infections like some other security plugins do. To me, it is that very fact that my Plugin can automatically fix the problems it finds that sets it apart from the others. I wrote this software for myself, so that I could easily remove widespread infections on a shared server with one click. Then I made the code available as a WordPress Plugin to be really helpful to those that could not otherwise clear up their infected servers. This Plugin actually removes “Known Threats” from a file, keeping the rest of the file intact, and it even makes a backup of the file before making changes. How cool is that? I’m not one to brag but I must admit I am quite proud of this accomplishment.
I wonder how many people have broken there whole site, by removing a file that was needed by WordPress, because some would-be helpful plugin told them it was infected but couldn’t or wouldn’t fix it. Or, how many people paid Securi to fix their infestation of malicious scripts when my Plugin might have done it for them. I’m not saying this Plugin I wrote is a fix-all for any infection, but what it does, it does well. I wrote it for a specific type of infection and continue to expand it’s range and capabilities as more information comes in from my users.
I am dedicated to seeing this project though and maintaining a successful front line against these malicious infection. With continually growing support from the WordPress community I know that I can grow this program to meet more and more needs and combat new threats as they are discovered.
A big thanks to all those who have commented and rated this Plugin and even more thanks to those who have Donated! You are all keeping this effort alive and letting WordPress know that this Plugin is appreciated.
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.
Impact of Google Blocking Keyword Data with SSL Search
I just created a small Widget for the SHH Blog that runs a simple query to find posts posted around the same time last year.
I just released my new Anti-Malware plugin for WordPress. It is still in BETA but I think it will be very helpful in removing malicious scripts and patching security vulnerabilities.
An example scan that found some threats
Please leave feedback and donate whenever possible.
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 like having my podCasts in the sidebar but I don’t like the play-list widget that comes with podPress. So I made this Widget that lists all my podCasts as links to the pop-out player. I plan on adding more features when I have more time but this is it for now.
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…
Download my latest version (1.2.01.18) and you can customize the placement of the Menu Item. Plus, I’ve made the Tag and Category headings in the Tree View widget link to that Tag or Category. With over 4,000 downloads I’m finally starting to get some good feedback too. Keep it coming!