Wikipedia talk:Database reports/WikiLove usage

Banned Wikipedians
Anyway to get banned Wikipedians off the list? --LauraHale (talk) 11:06, 5 March 2012 (UTC)
 * Why? --MZMcBride (talk) 13:41, 5 March 2012 (UTC)
 * Because in at least one case, a person appeared on the list after giving themselves about 60 wikiloves and was eventually banned for actions related to that. Not routine blocks, but only indefinite blocks. In a few other cases, you look at the history of contributions some of the people with redlinked names and it doesn't show them making a single contribution for Wikilove. --LauraHale (talk) 21:06, 5 March 2012 (UTC)
 * Sure, manipulation of the data is always going to be possible. I'm not sure that's a reason to compromise the integrity of the report, though. I don't really have an objection to the change, but I'd like to hear some others weigh in first. --MZMcBride (talk) 21:58, 5 March 2012 (UTC)

Recipients
Can a section with the top recipients be added to the page? Allen (talk) 01:45, 3 April 2012 (UTC)


 * Probably easy enough to add. It looks like recipients are tracked in the wikilove_log table as wikilove_log.wll_receiver (cf. https://gerrit.wikimedia.org/r/gitweb?p=mediawiki/extensions/WikiLove.git;a=blob_plain;f=patches/WikiLoveLog.sql;hb=master). It'd have to have some kind of cut-off, otherwise it would be a very long list (long tail!). It also looks like only registered users can receive WikiLove? Not sure if this is actually true, but the schema seems to suggest it is. Or at least IP recipients aren't tracked by IP address in the database (you'll notice wikilove_log.wll_receiver is only int(11); not big enough for an IP address to fit). --MZMcBride (talk) 01:52, 3 April 2012 (UTC)