Difference between revisions of "IPhone change calendar colors"

From wiki.breedveld.net
Jump to: navigation, search
m (Protected "IPhone change calendar colors" [edit=autoconfirmed:move=autoconfirmed])
Line 1: Line 1:
$ cd /var/mobile/Library/Calendar
+
$ cd /var/mobile/Library/Calendar
$ sqlite3 Calendar.sqlitedb
+
$ sqlite3 Calendar.sqlitedb
  
sqlite> select title,color_r,color_g,color_b from Calendar; — List calendars and current colors
+
sqlite> select title,color_r,color_g,color_b from Calendar; — List calendars and current colors
Default|-1|-1|-1
+
Default|-1|-1|-1
Michael Ansel|181|0|13
+
Michael Ansel|181|0|13
School-Important|47|141|0
+
School-Important|47|141|0
School-Studying|15|77|140
+
School-Studying|15|77|140
School-Class|229|98|0
+
School-Class|229|98|0
  
sqlite> update Calendar set color_r=181, color_g=0, color_b=13 where title = ‘School-Important’; — Red
+
sqlite> update Calendar set color_r=181, color_g=0, color_b=13 where title = ‘School-Important’; — Red
sqlite> update Calendar set color_r=229, color_g=98, color_b=0 where title = ‘School-Studying’; — Orange
+
sqlite> update Calendar set color_r=229, color_g=98, color_b=0 where title = ‘School-Studying’; — Orange
sqlite> update Calendar set color_r=103, color_g=10, color_b=108 where title = ‘School-Class’; — Purple
+
sqlite> update Calendar set color_r=103, color_g=10, color_b=108 where title = ‘School-Class’; — Purple
sqlite> update Calendar set color_r=15, color_g=77, color_b=140 where title = ‘Michael Ansel’; — Blue
+
sqlite> update Calendar set color_r=15, color_g=77, color_b=140 where title = ‘Michael Ansel’; — Blue
  
sqlite> select title,color_r,color_g,color_b from Calendar; — List calendars and current colors
+
sqlite> select title,color_r,color_g,color_b from Calendar; — List calendars and current colors
Default|-1|-1|-1
+
Default|-1|-1|-1
Michael Ansel|15|77|140
+
Michael Ansel|15|77|140
School-Important|181|0|13
+
School-Important|181|0|13
School-Studying|229|98|0
+
School-Studying|229|98|0
School-Class|103|10|108
+
School-Class|103|10|108
  
sqlite> .quit
+
sqlite> .quit
  
$ exit
+
$ exit
  
###################
+
###################
  
RGB Values for the Standard Colors
+
RGB Values for the Standard Colors
  
Red = (181,0,13)
+
Red = (181,0,13)
Orange = (229,98,0)
+
Orange = (229,98,0)
Green = (47,141,0)
+
Green = (47,141,0)
Blue = (15,77,140)
+
Blue = (15,77,140)
Purple = (103,10,108)
+
Purple = (103,10,108)

Revision as of 12:32, 12 October 2010

$ cd /var/mobile/Library/Calendar
$ sqlite3 Calendar.sqlitedb
sqlite> select title,color_r,color_g,color_b from Calendar; — List calendars and current colors
Default|-1|-1|-1
Michael Ansel|181|0|13
School-Important|47|141|0
School-Studying|15|77|140
School-Class|229|98|0
sqlite> update Calendar set color_r=181, color_g=0, color_b=13 where title = ‘School-Important’; — Red
sqlite> update Calendar set color_r=229, color_g=98, color_b=0 where title = ‘School-Studying’; — Orange
sqlite> update Calendar set color_r=103, color_g=10, color_b=108 where title = ‘School-Class’; — Purple
sqlite> update Calendar set color_r=15, color_g=77, color_b=140 where title = ‘Michael Ansel’; — Blue
sqlite> select title,color_r,color_g,color_b from Calendar; — List calendars and current colors
Default|-1|-1|-1
Michael Ansel|15|77|140
School-Important|181|0|13
School-Studying|229|98|0
School-Class|103|10|108
sqlite> .quit
$ exit
###################
RGB Values for the Standard Colors
Red = (181,0,13)
Orange = (229,98,0)
Green = (47,141,0)
Blue = (15,77,140)
Purple = (103,10,108)