Last modified: 2014-08-03 18:49:48 UTC
For extending one of my tool (bot), i would like to have access to log entries caused by local and global spam-blacklist blocking. On wikipedia these logs are visible to all local admins only. I am admin on dewiki, so i have read access to http://de.wikipedia.org/w/index.php?title=Spezial%3ALogbuch&type=spamblacklist. I need this info to know which articles were affected by a block in the past. With this i can inform affected wikiproject about an ongoing whitelist discussion. Not any part of the log entry itself is reproducible from the created reports. Spamblock log entries are currently hidden from logging table. In mediawiki the code for this log was added in https://gerrit.wikimedia.org/r/#/c/69303/8/SpamBlacklist_body.php Is it possible for my tool to get access to this data on toollabs db?
eMariaDB [enwiki_p]> select * from logging where log_type="spamblacklist" limit 2; +----------+---------------+------------+----------------+----------+---------------+-------------+-------------+--------------------------------------------------------+-------------+---------------+----------+ | log_id | log_type | log_action | log_timestamp | log_user | log_namespace | log_title | log_comment | log_params | log_deleted | log_user_text | log_page | +----------+---------------+------------+----------------+----------+---------------+-------------+-------------+--------------------------------------------------------+-------------+---------------+----------+ | 51115134 | spamblacklist | hit | 20130919184836 | 215845 | 0 | JD_Meatyard | | a:1:{s:6:"4::url";s:27:"http://www.reverbnation.com";} | 0 | Runarb | 40575851 | | 51115150 | spamblacklist | hit | 20130919184909 | 215845 | 0 | JD_Meatyard | | a:1:{s:6:"4::url";s:27:"http://www.reverbnation.com";} | 0 | Runarb | 40575851 | +----------+---------------+------------+----------------+----------+---------------+-------------+-------------+--------------------------------------------------------+-------------+---------------+----------+ 2 rows in set (0.03 sec)
