Yahoo! Answers WordPress Widgets Plugin

A plugin for WordPress that gives you two widgets to show your Yahoo! Answers Questions and Starred / Favorites. These widgets have a few more options than a typical RSS feed simply loaded by an RSS widget. The statuses are reduced so they aren’t redundant (e.g. “Resolved Question:” is rewritten “Resolved:”) amung other options to toggle such as:

  • Show status.
  • Show category.
  • Show answer count.
  • Show comment count.

These are hidden by default when you create a new instance of the widget.

The widgets are built and tested on 2.9.2 with the WP_Widget class introduced for 2.8 and above.

Download at GitHub:
http://github.com/drale/wp-ya-widgets

Screenshots: (actual appearance depends on your theme)

Yahoo! Answers Widget slimmed display
Slimmed Display
Yahoo! Answers Widget full options
Full Options

MySQL PHP Table Viewer with Pagination and Sorting

Basic PHP MySQL table viewer. Just tell it the table you want to view and it does all the rest! Automatically lists all your fields and values for specified table; providing ASC and DESC sorting for each. Also has prevnext and number paging.

Options include:

  • Nice fields (on/off) – “field_name” gets changed to “Field Name”
  • Page numbers (on/off)
  • Prev / Next (on/off)
  • Limit per page

Demo / Download:
http://blog.drale.com/tableview/

GitHub:
http://github.com/drale/DBTableViewer

Screenshot:
screenshot

Panasonic SC-HT900 freezing picture fix.

I bought a SC-HT900 couple years ago and not long after having it, video began to (if I remember correctly) freeze up when playing movies. I did some research and found out it is the decoder chip overheating. There are no fans or top ventilation in the disc player (SA-HT900) (although there is some vents on the bottom, lol what?). So I cut a hole in the top (this was a chore) above the decoder chip, which is on the green circuit board and says DTS, and put a 12 volt fan on it. Looked for a place on the circuit board providing the proper voltage and connected the negative to a screw for ground. The location to solder the positive wire to is (going by this picture I forgot to write it down) J328. There is C750 above that towards the back. The bottom of this picture is facing the front.

sc-ht900_2

sc-ht900_3

sc-ht900_1

It is pretty quiet. I’ve been using it for years now, maybe a couple times a month without problems. There is supposedly another issue with a fan in the subwoofer that causes popping noises in the speakers. But I haven’t had this problem. I could probably fix it the same way. Here is how one person fixed it.

I doubt this is going to be of help to anyone since this system is so old, but I thought I would share. You never know.

Here is some detailed troubleshooting information about a freezing issue.

Best Buy (and others?) selling non-GOTY Left4Dead for less.

At Best Buy today I noticed there is now new Left 4 Dead packaging as Game of The Year edition, which includes the new DLC (Survivor and the rest of the versus maps, and Last Stand) one the disc. This may be a great purchase for those new to Left 4 Dead, it will save you some updates download time, but probably not much. Look again you will see that Left 4 Dead is has now been dropped to $39.99 on Steam and in stores. However, the older package is being sold for $29.99. Buy this instead and then you will get all the content and updates through Steam for free that is in the GOTY box, and you will save $10. Hopefully you figured that on your own, but for those new to Left4Dead be aware.

beft-buy-left-4-dead-prices

It’s obviously a marketing gimmick to get more people excited to buy Left4Dead, but even now on Steam when you buy it, it is considered GOTY edition. The DLC came with the original release later on. It is almost like they are saying they released the DLC because it was game of the year. Would it not be weird if they put TF2 on the shelf with all the latest updates and called it Special Edition or something? Think about it.