Difference between revisions of "IPhone change calendar colors"

From wiki.breedveld.net
Jump to: navigation, search
Line 6: Line 6:
 
  sqlite3 Calendar.sqlitedb
 
  sqlite3 Calendar.sqlitedb
 
On the sqlite prompt:
 
On the sqlite prompt:
−
  select title,color_r,color_g,color_b from Calendar;
+
  select store_id,title, external_id_tag,color_r,color_g,color_b from Calendar;
  
 
In my case the output is:
 
In my case the output is:
−
Default|-1|-1|-1
+
1|Default||-1|-1|-1
−
Birthdays|68|167|3
+
2|Birthdays||47|141|0
−
BreedveldCalendar|185|14|40
+
1|Calendar||15|77|140
−
Calendar|246|79|0
+
6|Calendar||15|77|140
−
Roland Breedveld|190|109|0
+
11|Tasks|/dav/roland@breedveld.net/Tasks/|245|120|2
 +
11|Calendar|/dav/roland@breedveld.net/Calendar/|132|130|132
  
 
Change the colors, on the sqlite prompt:
 
Change the colors, on the sqlite prompt:
−
  update Calendar set color_r=47, color_g=141, color_b=0 where title = 'Birthdays';
+
.header on
−
  update Calendar set color_r=181, color_g=0, color_b=13 where title = 'BreedveldCalendar';
+
  update Calendar set color_r=15, color_g=77, color_b=140 where store_id = '6';
−
update Calendar set color_r=103, color_g=10, color_b=108 where title = 'Roland Breedveld';
+
  update Calendar set color_r=181, color_g=0, color_b=13 where store_id = '11';
−
update Calendar set color_r=15, color_g=77, color_b=140 where title = 'Calendar';
+
 
  .
 
  .
 
  .exit
 
  .exit

Revision as of 10:50, 22 April 2011

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 store_id,title, external_id_tag,color_r,color_g,color_b from Calendar;

In my case the output is: 1|Default||-1|-1|-1 2|Birthdays||47|141|0 1|Calendar||15|77|140 6|Calendar||15|77|140 11|Tasks|/dav/roland@breedveld.net/Tasks/|245|120|2 11|Calendar|/dav/roland@breedveld.net/Calendar/|132|130|132

Change the colors, on the sqlite prompt: 

.header on
update Calendar set color_r=15, color_g=77, color_b=140 where store_id = '6';
update Calendar set color_r=181, color_g=0, color_b=13 where store_id = '11';
.
.exit

Colors should be effective immediatley

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 "https://wiki.breedveld.net/index.php?title=IPhone_change_calendar_colors&oldid=6846"