Chris Carey

Author: Chris Carey

  • Using PHP to create a MySQL datetime

    For reference

    $datetime = date(‘Y-m-d H:i:s’);

  • Changing Calendar Colors on a Jailbroken iPhone running iOS 5

    iOS 5 changed the database that deals with Calendar colors. The value is now a hex value just like CSS uses (something like #fe6548)

    – Install sqlite3 via Cydia (you must have Cydia in “Developer” mode so it lists the command-line utilities)

    – ssh to your iPhone (as user mobile)

    – Run sqlite3 and open the calendar database

    iPhone:~ mobile$ sqlite3 /var/mobile/Library/Calendar/Calendar.sqlitedb

    – Issue the SQL commands to change the calendar colors:

    sqlite> UPDATE Calendar SET color=’#9FC6E7′ WHERE title = ‘Chris Carey’;
    sqlite> UPDATE Calendar SET color=’#FF7537′ WHERE title = ‘Work’;
    sqlite> UPDATE Calendar SET color=’#D06B64′ WHERE title = ‘Important’;
    sqlite> UPDATE Calendar SET color=’#B3DC6C’ WHERE title = ‘School’;
    sqlite> UPDATE Calendar SET color=’#4986E7′ WHERE title = ‘Chris & Nasique’;
    sqlite> UPDATE Calendar SET color=’#AC725E’ WHERE title = ‘Health’;

    -Quit sqlite3

    .quit

    -Quit ssh

    exit

    If needed, kill the calendar app or reboot the phone to get it to reload the new colors

  • Twitter API, PHP precision and scientific notation

    If you use PHP and the Twitter API, be on the lookout for this issue.

    Twitter IDs are up to 141 quadrillion (141 million billion). These Twitter IDs exceed PHP’s default precision of 14. So your Twitter IDs could be converted to scientific notation by PHP.

    A Twitter ID of 141675395434037249 will be stored as 1.41675395434037249E+17 once PHP gets it’s hands on it.

    This could cause code that has been working great for a while to stop working.

    Edit your php.ini and set precision to 20, or use
    ini_set(‘precision’, 20);

  • Debian squeeze libmysqlclient.so.15

    Here is what you need if you have some binary on Debian squeeze which wants libmysqlclient.so.15

    wget http://ftp.nl.debian.org/debian/pool/main/m/mysql-dfsg-5.0/libmysqlclient15off_5.0.51a-24+lenny5_i386.deb
    sudo dpkg -i libmysqlclient15off_5.0.51a-24+lenny5_i386.deb

  • mBuzz Maintenance Page

    mBuzz Maintenance page. The ‘Like’ and ‘Comment’ buttons both function. It sent the Likes and Comments into an IRC channel that could be seen during the upgrade process.

  • Show or Hide hidden files in Finder OS X

    Here is how it’s done via the Terminal:

    defaults write com.apple.finder AppleShowAllFiles TRUE
    killall Finder

    How to Hide Hidden Files:

    defaults write com.apple.finder AppleShowAllFiles FALSE
    killall Finder

    Thanks Brooks Andrus

  • Google Search Globe

    Google is working on this open source data visualization project Search Globe, check it out. I’m a big fan of creative data visualization.

  • MacBook Air 2010 Faces of Death

    My MacBook Air 2010 has been crashing a lot. Here is a sampling of some of the screens of death I’ve experienced over the past 3 days.

    I’ve read that this is an issue with the Macbook Air’s when attached to an external monitor (link). It certainly does seem more common when connected to a monitor. However, I’ve got the crash when using the laptop without connector as well.

    Also, when connected to some monitors with VGA, there is a wavyness to the screen image which look like jagged vertical saw blades.

    Blue screen of death (no external monitor):

    20110504-070101.jpg
    (more…)

  • Google Buzz link inside GMail

    The location of Google Buzz within GMail does not make sense to me.

    Currently Google Buzz is inside of GMail, along with Inbox, etc:

    Here is how it should look. Google Buzz should be it’s own section up with Mail:

  • Firesheep netmask error solved

    When using Firesheep on MacOSX you get:

    “Couldn’t get netmask for device en1: en1: no IPv4 address assigned.”

    Open up terminal and type “ifconfig” to see if your ethernet cart is indeed on en1. My Mac Air has the wireless card as en0, not en1.

    Go to the url “about:config” in Firefox. This opens up extra configuration options for Firefox. Search for ‘firesheep’ and there will be an option to change the Firesheep interface.