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@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@lists.wikimedia.org [mailto:mediawiki-l-bounces@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@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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@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@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/mediawiki-l