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


Posted

in

by

Tags:

Comments

10 responses to “Changing Calendar Colors on a Jailbroken iPhone running iOS 5”

  1. CapitalC Avatar
    CapitalC

    I stumbled at step one — I couldn’t find sqlite3 (or sql) in any repository within Cydia. Google didn’t yield any current results either. Help!

    1. Chris Carey Avatar

      Try again. It’s in there!

      1. CapicalC Avatar
        CapicalC

        Hrm, had no love on either the iPad or the iPhone. Will try again. Which repo source is it located in?

        1. Chris Carey Avatar

          I just found it on my iPhone and iPad. Search: sqlite – brings up SQLite 3.x package

          Source Information: Cydia/Telephoreo repo. Note: I did not add any repos from the default which ships with Cydia.

          1. CapicalC Avatar
            CapicalC

            Weiiird … I tried again and still find nothing, yet all my repos are up to date. 🙁 I’m running Cydia 1.1.4. The “All Packages” list goes:
            – SpyPhoto
            – Sqoare
            – sQuare

            I’m puzzled! I even tried changing to hacker mode but no love.

          2. Chris Carey Avatar

            Ahhh, you probably have to be in “Developer” mode since it is a command line only utility. I always pick that option on my Cydia and did not think of that.

          3. CapitalC Avatar
            CapitalC

            That was it, should have tried that too! I see you’ve added that to your instructions. Glad I could help! lol

            Cheers for the help Chris.

  2. David Avatar
    David

    I can SSH to the correct file, but when I enter a command in sqllite3, all it shows is “…>” and won’t accept any commands. “.help” works once, and then it won’t do anything either.

    Does anybody know what I am doing wrong?

    1. David Avatar
      David

      I figured it out. I wasn’t adding the “;”.

Leave a Reply

Your email address will not be published. Required fields are marked *