_______________________________
From: mediawiki-l-bounces@lists.wikimedia.org on behalf of Rob Church Sent: Fri 13/07/2007 11:46 To: MediaWiki announcements and site admin list Subject: Re: [Mediawiki-l] Change skin for all users
On 13/07/07, Rindler, Andreas andreas.rindler@bearingpoint.com wrote:
b) Hack in the database on table user, field user_options. This is a blog, and I don't know yet how to 1) retrieve, change and save a blog object and 2) how to do this for a couple hundred users.
Er, blob, not blog. You might be able to use the maintenance/userOptions.php script to update the skin preference for all users...it will be present after the upgrade. _______________________________________________
Thanks for the tip. I tried it but this error:
DB connection error: MySQL functions missing, have you compiled PHP with the --w ith-mysql option?
I looked around the included script files but couldn't find anything that would help me debug.
Here is the output from the command line:
D:\Apache2.2\htdocs\wiki110>php -cli maintenance\userOptions.php --list cols : 80 contextchars : 50 contextlines : 5 date : default editsection : 1 editsectiononrightclick: 0 enotifminoredits : 0 enotifrevealaddr : 0 enotifusertalkpages : 1 enotifwatchlistpages : 0 externaldiff : 0 externaleditor : 0 fancysig : 0 highlightbroken : 1 imagesize : 2 language : en math : 1 numberheadings : 0 previewontop : 1 quickbar : 1 rcdays : 7 rclimit : 50 rememberpassword : 0 rows : 25 searchNs0 : 1 searchlimit : 20 showjumplinks : 1 shownumberswatching : 1 showtoc : 1 showtoolbar : 1 skin : stubthreshold : 0 thumbsize : 2 underline : 2 uselivepreview : 0 variant : en watchlistdays : 3 wllimit : 250 Done.
D:\Apache2.2\htdocs\wiki110>php -cli maintenance\userOptions.php
This script pass through all users and change one of their options. The new option is NOT validated.
Usage: php userOptions.php --list php userOptions.php [user option] --usage php userOptions.php [options]?รก<user option> --old <old value> --new <new va lue>
Switchs: --list : list available user options and their default value
--usage : report all options statistics or just one if you specify it.
--old <old value> : the value to look for --new <new value> : new value to update users with
Options: --nowarn: hides the 5 seconds warning --quiet : do not print what is happening --dry : do not save user settings back to database
D:\Apache2.2\htdocs\wiki110>php -cli maintenance\userOptions.php --old skin: --n ew skin:BearingPoint The script is about to change the skin for ALL USERS in the database. Users with option <> = 'skin:' will be made to use 'skin:BearingPoint'.
Abort with control-c in the next five seconds...0 DB connection error: MySQL functions missing, have you compiled PHP with the --w ith-mysql option?
I am running this on: Windows 2003
* MediaWiki http://www.mediawiki.org/ : 1.10.0 * PHP http://www.php.net/ : 5.2.1 (apache2handler) * MySQL http://www.mysql.com/ : 5.0.37-community-nt
==================================
And I tried the option where I manupilate the mySql data. The above options are stored as a blob in user_options. I changed one user's options in the database and logged in. The user prefences did not change. It looks like as if it was ignoring the values in the database?! How is that possible?
-Andi *************************************************************************************************** The information in this email is confidential and may be legally privileged. Access to this email by anyone other than the intended addressee is unauthorized. If you are not the intended recipient of this message, any review, disclosure, copying, distribution, retention, or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. If you are not the intended recipient, please reply to or forward a copy of this message to the sender and delete the message, any attachments, and any copies thereof from your system. ***************************************************************************************************