Le 23 févr. 2012 à 02:01, phoebe ayers a écrit :
On Wed, Feb 22, 2012 at 4:24 AM, Nicolas Brouard
<brouard(a)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(a)lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l