IPhone change calendar colors: Difference between revisions

From wiki.breedveld.net
Jump to navigationJump to search
← Older editNewer edit →
No edit summary
No edit summary
Line 1: Line 1:
$ cd /var/mobile/Library/Calendar
sqlite3 should be installed by Cydia, or from command prompt:
  $ sqlite3 Calendar.sqlitedb
  apt-get install sqlite3


  sqlite> select title,color_r,color_g,color_b from Calendar; — List calendars and current colors
Query your current config:
Default|-1|-1|-1
cd /var/mobile/Library/Calendar
Michael Ansel|181|0|13
  sqlite3 Calendar.sqlitedb
School-Important|47|141|0
On the sqlite prompt:
School-Studying|15|77|140
select title,color_r,color_g,color_b from Calendar;
School-Class|229|98|0


sqlite> update Calendar set color_r=181, color_g=0, color_b=13 where title = ‘School-Important’; — Red
In my case the output is:
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
  Default|-1|-1|-1
  Michael Ansel|15|77|140
  Birthdays|68|167|3
  School-Important|181|0|13
  BreedveldCalendar|185|14|40
  School-Studying|229|98|0
  Calendar|246|79|0
  School-Class|103|10|108
  Roland Breedveld|190|109|0
 
sqlite> .quit
 
$ exit
 
###################


  RGB Values for the Standard Colors
Change the colors, on the sqlite prompt:
update Calendar set color_r=47, color_g=141, color_b=0 where title = 'Birthdays';
  update Calendar set color_r=181, color_g=0, color_b=13 where title = 'BreedveldCalendar';
update Calendar set color_r=103, color_g=10, color_b=108 where title = 'Calendar';
update Calendar set color_r=15, color_g=77, color_b=140 where title = 'Roland Breedveld';
.exit


RGB Values for the Standard Colors
  Red = (181,0,13)
  Red = (181,0,13)
  Orange = (229,98,0)
  Orange = (229,98,0)

Revision as of 15:35, 12 October 2010

sqlite3 should be installed by Cydia, or from command prompt: 

apt-get install sqlite3

Query your current config: 

cd /var/mobile/Library/Calendar
sqlite3 Calendar.sqlitedb

On the sqlite prompt: 

select title,color_r,color_g,color_b from Calendar;

In my case the output is: 

Default|-1|-1|-1
Birthdays|68|167|3
BreedveldCalendar|185|14|40
Calendar|246|79|0
Roland Breedveld|190|109|0

Change the colors, on the sqlite prompt: 

update Calendar set color_r=47, color_g=141, color_b=0 where title = 'Birthdays';
update Calendar set color_r=181, color_g=0, color_b=13 where title = 'BreedveldCalendar';
update Calendar set color_r=103, color_g=10, color_b=108 where title = 'Calendar';
update Calendar set color_r=15, color_g=77, color_b=140 where title = 'Roland Breedveld';
.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)
Retrieved from "http://wiki.breedveld.net/index.php?title=IPhone_change_calendar_colors&oldid=6810"