Le 23 févr. 2012 à 02:01, phoebe ayers a écrit :
On Wed, Feb 22, 2012 at 4:24 AM, Nicolas Brouard brouard@ined.fr wrote:
Thank you for your support. I just submitted a complete patch entitled "Can't authenticate using my mother language username (UNICODE) when I only have (a public) access to Wikipedia with an ASCII (english) keyboard" in about 20 languages on https://bugzilla.wikimedia.org/show_bug.cgi?id=34590
People supporting this idea, please for it.
Cool!
See also: https://bugzilla.wikimedia.org/show_bug.cgi?id=28085, a bug I submitted ages ago based on feedback I've gotten talking to users who only occasionally edited. The idea is that that remembering a username can be a barrier to casual editing (a few tries to remember a username that you don't use much and you might just give up) -- and being able to log in with an email address might help make things smoother
Thank you for pointing me on your older bug that I didn't find on Bugzilla before I submitted this current bug. The aim was different but the solution to be found is the same. I haven't seen a proposed patch neither by yourself nor anyone else, am I wrong?
Concerning the patch submitted, and in order to have an idea of the pertinence of it for other MediaWikis sites than mine and Wikipedia too, I am asking people having access to the standard user database of their wikis to process this next mysql command.
The question is how many people are sharing a unique e-mail with several usernames? mysql -u wikiadmin -p wikidb mysql> select email_freq, COUNT(email_freq) FROM (select user_email, COUNT(user_email) as email_freq FROM prefix_user WHERE user_email <> "NULL" GROUP BY user_email ) AS DISTRIB GROUP BY email_freq;
Here is the result on mine: +------------+-------------------+ | email_freq | COUNT(email_freq) | +------------+-------------------+ | 1 | 3047 | | 2 | 22 | | 3 | 1 | +------------+-------------------+
On the above example, 22 users have 2 usernames having the same e-mail. 1 have 3, and all the others have an e-mail link to a unique username. I suppressed the number of people having no e-mail authenticated (NULL).
The benefit of this patch won't be as good on Wikipedia user table, but I would be happy if you know who I can ask in order to get the results. I was guessing 90% but I am probably pessimistic... -- Nicolas
-- phoebe
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikitech-l