[Mediawiki-l] Urgent: Erase all user options preferences

[Dr JFBurté]

Hi Laurent,
My prehistoric method with blob (if phpMyAdmin accessible on your server):

Export the table ('user') with SQL mode , but don't use hexadecimal for blob 
field (**)
You get a file that is a text format .sql with all the informations ( 
structure, KEY, INSERT, IF NOT EXIST, etc)
At this time the blob field is "translated" to text format (if you get no 
readable text, modify the case/choice for hexadecimal, like **)

So you can open that sql/txt file  with true text processor like pspPad or 
NotePad+
Replace what you want in it , paying attention to format and semicolumn
Reimporting/replace with SQL in the original table
@+ de jfb "0.02$"

(normalement mon franglais doit être compréhensible par un autre franglais 
;O)

----- Original Message ----- 
From: <webmaster at wikimini.org>
To: <mediawiki-l at lists.wikimedia.org>
Sent: Thursday, October 02, 2008 4:08 AM
Subject: [Mediawiki-l] Urgent: Erase all user options preferences


>
> Hi,
>
> Sorry for the "urgent" nature of my question but I have a problem on a
> production wiki.
>
> I need to erase all exisiting user options and replace them with the
> following ones:
>
> "quickbar=1
> underline=0
> cols=4
> rows=4
> searchlimit=20
> contextlines=5
> contextchars=50
> skin=
> math=1
> rcdays=1
> rclimit=50
> wllimit=250
> highlightbroken=0
> stubthreshold=0
> previewontop=0
> editsection=0
> editsectiononrightclick=0
> showtoc=0
> showtoolbar=0
> date=default
> imagesize=0
> thumbsize=0
> rememberpassword=0
> enotifwatchlistpages=0
> enotifusertalkpages=1
> enotifminoredits=0
> enotifrevealaddr=0
> shownumberswatching=0
> fancysig=0
> externaleditor=0
> externaldiff=0
> showjumplinks=0
> numberheadings=0
> uselivepreview=0
> watchlistdays=3
> variant=
> language=fr
> searchNs0=0
> nickname=Admin
> timecorrection=02:00
> searchNs1=0
> searchNs2=0
> searchNs3=0
> searchNs4=0
> searchNs5=0
> searchNs6=0
> searchNs7=0
> searchNs8=0
> searchNs9=0
> searchNs10=0
> searchNs11=0
> searchNs12=0
> searchNs13=0
> searchNs14=0
> searchNs15=0
> disablemail=1
> justify=0
> hideminor=0
> extendwatchlist=0
> usenewrc=0
> editondblclick=0
> editwidth=0
> watchcreations=0
> watchdefault=0
> watchmoves=0
> watchdeletion=0
> minordefault=0
> previewonfirst=0
> nocache=0
> forceeditsummary=0
> watchlisthideown=0
> watchlisthidebots=0
> watchlisthideminor=0
> ccmeonemails=0
> diffonly=0
> riched_disable=0
> riched_disable_ns_main=0
> riched_disable_ns_talk=0
> riched_disable_ns_user=0
> riched_disable_ns_user_talk=0
> riched_disable_ns_project=0
> riched_disable_ns_project_talk=0
> riched_disable_ns_image=0
> riched_disable_ns_image_talk=0
> riched_disable_ns_mediawiki=0
> riched_disable_ns_mediawiki_talk=0
> riched_disable_ns_template=0
> riched_disable_ns_template_talk=0
> riched_disable_ns_help=0
> riched_disable_ns_help_talk=0
> riched_disable_ns_category=0
> riched_disable_ns_category_talk=0
> ajaxsearch=
> searchNs90=0
> searchNs91=0
> searchNs92=0
> searchNs93=0
> lqt_sort_order=3
> disablesuggest=
> showhiddencats=0"
>
>
>
> The user-options field is a blob and I'm not sure what the correct sql
> command would be (I'm not a SQL guru). May I try something like:
>
> UPDATE user SET user_options = "quickbar=1
> underline=0
> cols=4
> rows=4
> searchlimit=20
> contextlines=5
> contextchars=50
> skin=
> math=1
> rcdays=1
> rclimit=50
> wllimit=250
> highlightbroken=0
> stubthreshold=0
> previewontop=0
> editsection=0
> editsectiononrightclick=0
> showtoc=0
> showtoolbar=0
> date=default
> imagesize=0
> thumbsize=0
> rememberpassword=0
> enotifwatchlistpages=0
> enotifusertalkpages=1
> enotifminoredits=0
> enotifrevealaddr=0
> shownumberswatching=0
> fancysig=0
> externaleditor=0
> externaldiff=0
> showjumplinks=0
> numberheadings=0
> uselivepreview=0
> watchlistdays=3
> variant=
> language=fr
> searchNs0=0
> nickname=Admin
> timecorrection=02:00
> searchNs1=0
> searchNs2=0
> searchNs3=0
> searchNs4=0
> searchNs5=0
> searchNs6=0
> searchNs7=0
> searchNs8=0
> searchNs9=0
> searchNs10=0
> searchNs11=0
> searchNs12=0
> searchNs13=0
> searchNs14=0
> searchNs15=0
> disablemail=1
> justify=0
> hideminor=0
> extendwatchlist=0
> usenewrc=0
> editondblclick=0
> editwidth=0
> watchcreations=0
> watchdefault=0
> watchmoves=0
> watchdeletion=0
> minordefault=0
> previewonfirst=0
> nocache=0
> forceeditsummary=0
> watchlisthideown=0
> watchlisthidebots=0
> watchlisthideminor=0
> ccmeonemails=0
> diffonly=0
> riched_disable=0
> riched_disable_ns_main=0
> riched_disable_ns_talk=0
> riched_disable_ns_user=0
> riched_disable_ns_user_talk=0
> riched_disable_ns_project=0
> riched_disable_ns_project_talk=0
> riched_disable_ns_image=0
> riched_disable_ns_image_talk=0
> riched_disable_ns_mediawiki=0
> riched_disable_ns_mediawiki_talk=0
> riched_disable_ns_template=0
> riched_disable_ns_template_talk=0
> riched_disable_ns_help=0
> riched_disable_ns_help_talk=0
> riched_disable_ns_category=0
> riched_disable_ns_category_talk=0
> ajaxsearch=
> searchNs90=0
> searchNs91=0
> searchNs92=0
> searchNs93=0
> lqt_sort_order=3
> disablesuggest=
> showhiddencats=0"
>
> ?
>
> Thank you very much for any advice.
>
> Laurent
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at lists.wikimedia.org
> https://lists.wikimedia.org/mailman/listinfo/mediawiki-l
> ---------------------------------------------------------------------------------------
> Orange vous informe que cet  e-mail a ete controle par l'anti-virus mail.
> Aucun virus connu a ce jour par nos services n'a ete detecte.
>
>
>
>
> -- 
> No virus found in this incoming message.
> Checked by AVG.
> Version: 7.5.526 / Virus Database: 270.7.5/1701 - Release Date: 30/09/2008 
> 19:08
>
>