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