[Mediawiki-l] Setting user preferences at global level

[Paul Coghlan]

Jack

I use PHPMyAdmin too and can see the BLOB details.

Use something like:

SELECT user_options from user WHERE user_id=1;

Just export the result to CSV and you will see the values.

Fastest way to get all the values in there, I think, is to save each page in
Special:Preferences. This will write default values into user_options from
where you can analyze them and decide upon the values you want.

You have to remember that what I am doing in the database in atypical and
that the norm is to let the users use Special:Preferences.

Paul


On 6/14/07 9:56 AM, "Jack Eapen C" <jackec at suntecgroup.com> wrote:

> 
> Thanks Jim and Paul for the quick replies. I'm new to MW. Where can I
> see all the user options like enotifwatchlistpages,enotifusertalkpages,
> etc.?
> 
> Also, from Paul's email I understood how to replace the values. But as
> Jim said, options like watchcreations is not there in the table by
> default and I need to insert?
> 
> What's the SQL for that? I'm using phpmyadmin and I cant see values in
> blob columns :(
> 
> Regards,
>  
> Jack
>  
> 
> -----Original Message-----
> From: mediawiki-l-bounces at lists.wikimedia.org
> [mailto:mediawiki-l-bounces at lists.wikimedia.org] On Behalf Of Jim Wilson
> Sent: Thursday, June 14, 2007 5:52 PM
> To: MediaWiki announcements and site admin list
> Subject: Re: [Mediawiki-l] Setting user preferences at global level
> 
> Hello Jack,
> 
> That information you require is stored in the 'user_options' column of
> the
> 'user' table in your database.  It's a blob containing a newline
> separated
> list of keyword/value pairs.  It looks something like this (lines
> removed
> for brevity):
> 
> -----------------------------
> quickbar=1
> underline=2
> ...
> enotifwatchlistpages=0
> enotifusertalkpages=1
> enotifminoredits=0
> enotifrevealaddr=0
> ...
> language=en
> searchNs0=1
> -----------------------------
> 
> Regarding "Email me when watchlist pages change": the particular field
> you're looking for (I believe) is 'enotifwatchlistpages', which you'd
> want
> to set to 1 for all users.
> 
> Regarding "Add pages I create to my watchlist": the field you want is
> 'watchcreations', which should also be set to 1.  Unlike
> 'enotifwatchlistpages', this value is not in the auto-generated
> user_options
> blobs by default - so you'll need to add a line for it.
> 
> Hope this helps!
> 
> -- Jim R. Wilson (jimbojw)
> 
> On 6/14/07, Jack Eapen C <jackec at suntecgroup.com> wrote:
>> 
>> 
>> Hi
>> 
>> Our wiki is running over the intranet. Authentication is done via LDAp
>> plugin.
>> How can we set the preferences for all users at one go- like "Add
> pages I
>> create to my watchlist", "Email me when pages in my watchlist
> changes", etc.
>> to true for all users at one go?
>> 
>> Also I want to treat all emailids as verified, without the
> verification
>> process. How can that be achieved?
>> 
>> Regards,
>> 
>> Jack Eapen C
>> SunTec Knowledge Centre
>> 
>> 
> ------------------------------------------------------------------------
> ------------
>> 
>> 
>> 
>> 
>> This electronic mail (including any attachment thereto) may be
>> confidential and privileged and is intended only for the individual or
>> entity named above. Any unauthorized use, printing, copying,
> disclosure or
>> dissemination of this communication may be subject to legal
> restriction or
>> sanction. Accordingly, if you are not the intended recipient, please
> notify
>> the sender by replying to this email immediately and delete this email
> (and
>> any attachment thereto) from your computer system...Thank You
>> 
>> _______________________________________________
>> MediaWiki-l mailing list
>> MediaWiki-l at lists.wikimedia.org
>> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>> 
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> 
> 
> This electronic mail (including any attachment thereto) may be confidential
> and privileged and is intended only for the individual or entity named above.
> Any unauthorized use, printing, copying, disclosure or dissemination of this
> communication may be subject to legal restriction or sanction. Accordingly, if
> you are not the intended recipient, please notify the sender by replying to
> this email immediately and delete this email (and any attachment thereto) from
> your computer system...Thank You
> 
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
>