Hi Timo,

Op 26-6-2011 2:23, Krinkle schreef:
The public view of user_properties on the Toolserver only contains gender,
nothing else.
Sure?
mysql> select distinct(up_property) from user_properties limit 10;
+----------------+
| up_property    |
+----------------+
| gender         |
| language       |
| nickname       |
| skin           |
| timecorrection |
+----------------+
5 rows in set (19.56 sec)

Let's take a not so random user:

 select * from user_properties JOIN user ON up_user=user_id WHERE user_name='Multichill' limit 10;
+---------+----------------+----------------------------------------------------------------+---------+------------+-------------------+----------------+
| up_user | up_property    | up_value                                                       | user_id | user_name  | user_registration | user_editcount |
+---------+----------------+----------------------------------------------------------------+---------+------------+-------------------+----------------+
|  115072 | gender         | male                                                           |  115072 | Multichill | 20070207171241    |          46493 |
|  115072 | language       | nl                                                             |  115072 | Multichill | 20070207171241    |          46493 |
|  115072 | nickname       | [[User:Multichill|Multichill]] ([[User talk:Multichill|talk]]) |  115072 | Multichill | 20070207171241    |          46493 |
|  115072 | timecorrection | ZoneInfo|60|Europe/Amsterdam                                   |  115072 | Multichill | 20070207171241    |          46493 |
+---------+----------------+----------------------------------------------------------------+---------+------------+-------------------+----------------+
4 rows in set (0.02 sec)

Maarten


In addition to user_properties, Toolserver also features a custom view,
named "user_properties_anonym".

That view contains all (if not, most) preferneces, but without the user-id.
This is were the commons-page got it's information from.

--
Timo

_______________________________________________
Toolserver-l mailing list (Toolserver-l@lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list: https://wiki.toolserver.org/view/Mailing_list_etiquette