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(a)lists.wikimedia.org)
https://lists.wikimedia.org/mailman/listinfo/toolserver-l
Posting guidelines for this list:
https://wiki.toolserver.org/view/Mailing_list_etiquette