preferences in users table

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

preferences in users table

soumitri@iitk.ac.in
Hello All,

Can some one give me some light on the preferences column and if i want
to modify how should i do it.

I tried following command, but failed(no error, but no result too).

# ./moduserprefs.sh --user='xyz' plugin.hotkeys.mapping_list --delete
--type=string

# ./moduserprefs.sh --user='xyz' plugin.hotkeys.mapping_list --delete

Although i guess a brief structure from the below layout from preference
column, but not in exact. Any reference document for this. Thanks for
this nice OSS and any help.

============================

preferences:
a:18:
{s:27:"plugin.hotkeys.mapping_list";a:92:
{i:0;a:7:
{s:7:"profile";s:10:"cor.bosman";s:7:"command";s:23:"plugin.hotkeys.activate";s:7:"context";s:3:"any";s:7:"comment";s:30:"activate
hotkeys plugin
dialog";s:6:"script";s:0:"";s:3:"key";s:7:"shift+/";s:6:"source";s:8:"external";}

i:91;a:7:
{s:7:"profile";s:16:"andrei.pozolotin";s:7:"command";s:16:"#compose-subject";s:7:"context";s:9:"mail_edit";s:7:"comment";s:23:"focus:
select
'subject'";s:6:"script";s:23:"top.$(command).focus();";s:3:"key";s:5:"alt+3";s:6:"source";s:6:"custom";}
}

s:16:"message_sort_col";
s:4:"date";
s:18:"message_sort_order";
s:4:"DESC";
s:9:"lastlogin";
a:4:{s:4:"from";s:12:"172.27.17.45";s:4:"date";s:10:"1567942038";s:3:"geo";s:12:"IITK
network";s:7:"timeout";i:10;}
s:44:"plugin.contextmenu_folder.collect_predefined";
a:2:{s:10:"INBOX/Sort";
  a:3:{s:4:"mbox";s:10:"INBOX/Sort";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}
  s:9:"Sent/Sort";a:3:{s:4:"mbox";s:9:"Sent/Sort";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}}

s:41:"plugin.contextmenu_folder.collect_special";
a:5:{s:5:"INBOX";a:3:{s:4:"mbox";s:5:"INBOX";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}s:12:"INBOX.Drafts";a:3:{s:4:"mbox";s:12:"INBOX.Drafts";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}s:10:"INBOX.Sent";a:3:{s:4:"mbox";s:10:"INBOX.Sent";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}s:10:"INBOX.Junk";a:3:{s:4:"mbox";s:10:"INBOX.Junk";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}s:11:"INBOX.Trash";a:3:{s:4:"mbox";s:11:"INBOX.Trash";s:6:"action";s:7:"default";s:12:"created_msec";i:0;}}

s:22:"plugin.hotkeys.profile";s:5:"linux";
s:15:"per_folder_sort";a:2:{s:5:"INBOX";s:9:"date_DESC";s:12:"INBOX.Drafts";s:9:"date_DESC";}
s:11:"search_mods";a:4:{s:1:"*";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}s:10:"INBOX.Sent";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:12:"INBOX.Drafts";a:2:{s:7:"subject";i:1;s:2:"to";i:1;}s:5:"INBOX";a:2:{s:7:"subject";i:1;s:4:"from";i:1;}}

s:9:"list_cols";a:10:{i:0;s:7:"threads";i:1;
s:5:"chbox";i:2;
s:7:"subject";i:3;
s:4:"date";i:4;
s:4:"size";i:5;
s:6:"status";i:6;
s:4:"flag";i:7;
s:10:"attachment";i:8;
s:4:"from";i:9;s:2:"to";}

s:31:"plugin.hotkeys.reset_to_default";b:0;
s:11:"client_hash";
s:32:"badfa0036e5cdedeffa0aa2b0f341011";
s:11:"drafts_mbox";
s:12:"INBOX.Drafts";
s:9:"junk_mbox";
s:10:"INBOX.Junk";
s:9:"sent_mbox";
s:10:"INBOX.Sent";
s:10:"trash_mbox";
s:11:"INBOX.Trash";
s:15:"namespace_fixed";b:1;
s:7:"filters"; a:1:
{i:0;a:4:
{s:10:"whatfilter";s:7:"subject";s:12:"searchstring";s:6:"[SPAM]";s:10:"destfolder";s:10:"INBOX.Junk";s:8:"messages";s:3:"all";}
}

=====================

--
Sincerely,
Soumitri Mishra
_______________________________________________
Roundcube Development discussion mailing list
[hidden email]
http://lists.roundcube.net/mailman/listinfo/dev
Reply | Threaded
Open this post in threaded view
|

Re: preferences in users table

A.L.E.C
On 9/19/19 1:33 PM, [hidden email] wrote:

> I tried following command, but failed(no error, but no result too).
>
> # ./moduserprefs.sh --user='xyz' plugin.hotkeys.mapping_list --delete --type=string
>
> # ./moduserprefs.sh --user='xyz' plugin.hotkeys.mapping_list --delete

You don't need --type to delete an option. Also, I think option name should be last, i.e.

./moduserprefs.sh --user='xyz' --delete plugin.hotkeys.mapping_list

> Although i guess a brief structure from the below layout from preference column, but not
> in exact. Any reference document for this. Thanks for this nice OSS and any help.

This is an array (hash) serialized using https://www.php.net/manual/en/function.serialize.php

--
Aleksander 'A.L.E.C' Machniak
Kolab Groupware Developer         [http://kolab.org]
Roundcube Webmail Developer   [http://roundcube.net]
----------------------------------------------------
PGP: 19359DC1 # Blog: https://kolabian.wordpress.com
_______________________________________________
Roundcube Development discussion mailing list
[hidden email]
http://lists.roundcube.net/mailman/listinfo/dev
Reply | Threaded
Open this post in threaded view
|

Re: preferences in users table

soumitri@iitk.ac.in
Thanks for the quick reply.
On 19/09/19 17:19, A.L.E.C wrote:

> On 9/19/19 1:33 PM,[hidden email]  wrote:
>
>> I tried following command, but failed(no error, but no result too).
>>
>> # ./moduserprefs.sh --user='xyz' plugin.hotkeys.mapping_list --delete --type=string
>>
>> # ./moduserprefs.sh --user='xyz' plugin.hotkeys.mapping_list --delete
> You don't need --type to delete an option. Also, I think option name should be last, i.e.
>
> ./moduserprefs.sh --user='xyz' --delete plugin.hotkeys.mapping_list
  I tried, but it did not work(same as before).
>> Although i guess a brief structure from the below layout from preference column, but not
>> in exact. Any reference document for this. Thanks for this nice OSS and any help.
> This is an array (hash) serialized usinghttps://www.php.net/manual/en/function.serialize.php
>
Thanks again. Any kind suggestions how to delete that pref-name element
from that array using mysql prompt. The entry is bit big in length.
_______________________________________________
Roundcube Development discussion mailing list
[hidden email]
http://lists.roundcube.net/mailman/listinfo/dev