IPhone change calendar colors - Revision history

Roland at 10:50, 22 April 2011

2011-04-22T10:50:47Z

← Older revision		Revision as of 10:50, 22 April 2011
Line 17:		Line 17:

	Change the colors, on the sqlite prompt:		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=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';		update Calendar set color_r=181, color_g=0, color_b=13 where store_id = '11';

Roland at 10:50, 22 April 2011

2011-04-22T10:50:28Z

← Older revision		Revision as of 10:50, 22 April 2011
Line 9:		Line 9:

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

	Change the colors, on the sqlite prompt:		Change the colors, on the sqlite prompt:

Roland at 10:50, 22 April 2011

2011-04-22T10:50:12Z

← Older revision		Revision as of 10:50, 22 April 2011
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

Roland at 15:44, 12 October 2010

2010-10-12T15:44:00Z

← Older revision		Revision as of 15:44, 12 October 2010
Line 18:		Line 18:
	update Calendar set color_r=47, color_g=141, color_b=0 where title = 'Birthdays';		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=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=103, color_g=10, color_b=108 where title = 'Roland Breedveld';
	update Calendar set color_r=15, color_g=77, color_b=140 where title = '~~Roland Breedveld~~';		update Calendar set color_r=15, color_g=77, color_b=140 where title = 'Calendar';
			.
	.exit		.exit

			Colors should be effective immediatley<br>
			<br>
	RGB Values for the Standard Colors		RGB Values for the Standard Colors
	Red = (181,0,13)		Red = (181,0,13)

Roland at 15:35, 12 October 2010

2010-10-12T15:35:36Z

← Older revision		Revision as of 15:35, 12 October 2010
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)

Roland at 12:32, 12 October 2010

2010-10-12T12:32:23Z

← Older revision		Revision as of 12:32, 12 October 2010
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)

Roland: Protected "IPhone change calendar colors" [edit=autoconfirmed:move=autoconfirmed]

2010-10-12T12:31:42Z

Protected "IPhone change calendar colors" [edit=autoconfirmed:move=autoconfirmed]

← Older revision	Revision as of 12:31, 12 October 2010
(No difference)

Roland: New page: $ 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 An...

2010-10-12T12:31:33Z

New page: $ 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 An...

New page

$ 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)

← Older revision		Revision as of 10:50, 22 April 2011
Line 9:		Line 9:

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

	Change the colors, on the sqlite prompt:		Change the colors, on the sqlite prompt: