[horde] Changing prefs globally

[Craig White]

On Tue, 2005-08-23 at 11:47 -0600, Kevin Konowalec wrote:
> On Aug 23, 2005, at 11:39 AM, Jan Schneider wrote:
> 
> > Zitat von Kevin Konowalec <kevin at ualberta.net>:
> >
> >
> >> I got a message from our mailserver admin that the sent mail folder
> >> needs to change.  In the imp/config/prefs.php file there is the
> >> following:
> >>
> >> // sent mail folder
> >> $_prefs['sent_mail_folder'] = array(
> >>     'value' => 'sent-mail',
> >> // For Exchange server uncomment the line below and delete the line
> >> above
> >> //    'value' => 'Sent Items',
> >>     'locked' => false,
> >>     'shared' => false,
> >>     'type' => 'implicit');
> >>
> >>
> >> The way I understand it, this is now set for all my users in their
> >> individual prefs.  If I change it, how do I apply the change across
> >> the whole database (mySQL)?
> >>
> >
> > You need a script for that, because they are stored in the serialized
> > identities.
> >
> > Jan.
> 
> 
> Has anyone written anything like this?  I'd hate to have to reinvent  
> the wheel...  Of course it'd be handy to have a script that could  
> take an attribute name and value and blast it into the serialized  
> identities across the board.... 
----
I got pretty far on it a few months back but I never finished it.

It's really just an sql command - in your case, I would think that you
could simply delete the existing values and then it would go back to the
'prefs.php' for value.

I think something like below should do it for mysql (untested) - the
first statement giving you a clue of what it will find and delete.

mysql> select * from horde_prefs where pref_name = "sent_mail_folder";
mysql> delete all from horde_prefs where pref_name = "sent_mail_folder";

Craig