Le 23 févr. 2012 à 02:01, phoebe ayers a écrit :

> On Wed, Feb 22, 2012 at 4:24 AM, Nicolas Brouard <brou...@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





_______________________________________________
Wikitech-l mailing list
Wikitech-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikitech-l

Reply via email to