Archive for January, 2009

Warning – Google May Harm Your Computer

Posted on January 31st, 2009 |

googleharm

Careful, according to Google, the site google.com may be harmful to your computer.

2 Comments » | Categories: Uncategorized

Covert UNIX Epoch dates in Microsoft Excel – Including Timezone Examples

Posted on January 22nd, 2009 |

There are many sites out there that will give you a full description of what the UNIX Epoch standard date system is, why it is used, and a thorough understanding of why that’s important to you. You also probably don’t have time for a history/computer science course when all you want to do is convert that time stamp into something that looks nice for your boss in Excel. In that case, here you go:

All examples shown assume that the UNIX time stamp is in column A.

GMT – Greenwich Mean Time – This is the standard example you see across the Internet
=(A1/86400)+25569

EST – Eastern Standard Time (GMT – 5:00)
=((A1-18000)/86400)+25569

CST – Central Standard Time (GMT – 6:00)
=((A1-21600)/86400)+25569

MST – Mountain Standard Time (GMT – 7:00)
=((A1-25200)/86400)+25569

PST – Pacific Standard Time (GMT – 8:00)
=((A1-28800)/86400)+25569

Now set your column format to a Date field to your liking. I use the 3/14/01 13:30 format so I can include the easily sortable military time format.

16 Comments » | Categories: Uncategorized

Don’t set your WordPress address URL to something other than the folder WordPress is installed

Posted on January 22nd, 2009 |

I’ve recently redirected my home page of http://untangible.com to http://untangible.com/blog using Apache’s mod_rewrite functions. This way users coming to the main site are transparently redirected to the blog yet the old Google indexed URLs that are referencing the blog subfolder still work. I wanted my sitemap which is built by a WordPress plugin to reference the URLs without the blog subdirectory since it’s cleaner. Instead of manually changing the xml output (which would have taken all of 10 seconds) I decided to change the WordPress address setting in the control panel. My thought was that it would then just reference untangible.com instead of untangible.com/blog while still redirecting traffic to the proper path due to the mod_rewrite rule in place.

After doing this the website could still be viewed properly and all the links worked but when trying to sign into wp-admin the system would just bring me back to the login page without any error messages. To fix the issue I had to log into my virtual host site and manually change the siteurl field in the options MySQL table back to http://untangible.com/blog.

Lesson learned. Read about what the functions do before making assumptions.

1 Comment » | Categories: Uncategorized