[horde] horde_prefs - categories and category_colors

[Craig White]

I am not understanding what is getting written to the horde_prefs
table...

When I cleared out the settings and created them again...

mysql> select * from horde_prefs where pref_uid = 'Administrator' AND
pref_name = "category_colors";

| Administrator | horde      | category_colors |1:Appointment - Out of
Office|2:Company Event|3:Holiday|4:Personal Event|5:Personal Task|6:Task
- Administrative Group|7:Task - IT Group|8:Task - Sales Group|
9:Training|10:Vacation Schedule|11:Vendor Meeting|12:_default_|
13:_unfiled_|14:1|15:2|16:3|17:4|18:5|19:6|20:7|21:8|22:9|23:10|24:11|
25:12|26:13|27:14|28:15|29:16|30:17|31:18|32:19|33:20|34:21|35:22|36:23|
37:24|38:25|39:26|40:27|41:28|42:29|43:30|44:31|45:32|46:33|47:34|48:35|
49:36|50:37|51:38|52:39|53:40|54:41|55:42|56:43|57:44|58:45|59:46|60:47|
61:48|62:49|63:50|64:51|65:52|66:53|67:54|68:55|69:56|70:57|71:58|72:59|
73:60|74:61|75:62|76:63|77:64|78:65|79:66|80:67|81:68|82:69|83:70|84:71|
85:72|86:73|87:74|88:75|89:76|90:77|91:78|92:79|93:80|94:81|95:82|96:83|
97:84|98:85|99:86|100:87|101:88|102:89|103:90|104:91|105:92|106:93|
107:94|108:95|109:96|110:97|111:98|112:99|113:100|114:101|115:102|
116:103|117:104|118:105|119:106|120:107|121:108|122:109|123:110|124:111|
125:112|126:113|127:114|128:115|129:116|130:117|131:118|132:119|133:120|
134:121|135:122|136:123|137:124|138:125|139:126|140:127|141:128|142:129|
143:130|144:131|145:132|146:133|147:134|148:135|149:136|150:137|151:138|
152:139|153:140|154:141|155:142|156:143|157:144|158:145|159:146|160:147|
161:148|162:149|163:150|164:151|165:152|166:153|167:154|168:155|169:156|
170:157|171:158|172:159|173:160|174:161|175:162|176:163|177:164|178:165|
179:166|180:167|181:168|182:169|183:170|184:171|185:172|186:173|187:174|
188:175|189:176|190:177|191:178|192:179|193:180|194:181|195:182|196:183|
197:184|198:185|199:186|200:187|201:188|202:189|203:190|204:191|205:192|
206:193|207:194|208:195|209:208|222:|Appointment - In Office:#0000aa|
Appointment - Out of Office:#0000cc|Company Event:#3333ff|
Holiday:#7d7d7d|Personal Event:#7dff7d|Personal Task:#9dff9d|Task -
Administrative Group:#FF5f5f|Task - IT Group:#FF7f7f|Task - Sales
Group:#FF9f9f|Training:#adadff|Vacation Schedule:#9d9dff|Vendor
Meeting:#7d7dff|_default_:#FFFFFF|_unfiled_:#

mysql> select * from horde_prefs where pref_uid = 'Administrator' AND
pref_name = "categories";

| Administrator | horde      | categories | Appointment - In Office|
Appointment - Out of Office|Company Event|Holiday|Personal Event|
Personal Task|Task - Administrative Group|Task - IT Group|Task - Sales
Group|Training|Vacation Schedule|Vendor Meeting |

I don't understand all of the number pairs in category_colors - where
they came from - what their purpose is.

What I am trying to accomplish (and I basically am already there) is a
complete set of hooks to set users default values to another's uses
saved values and these values (above with all of the strange numbered
pairs) really whack things when these values are 'hooked' into another
user as default.

Is there a purpose for these numbered pairs or is this something buggy
in Horde -> Options -> Categories and Labels ?

Craig