计算出一个人在MediaWiki上所做的更改的百分比

Work out percentage of change done by one person on MediaWiki

本文关键字：百分比一个人 MediaWiki 计算 | 更新日期: 2023-09-27

我想计算出一个人对一篇文章所做的编辑/修改的百分比，这样我就可以相应地捐款。

编辑历史保存在revision表中。如果您有page-id，您可以获得用户按页面编辑的百分比(只需将1替换为page-id):

SELECT
    rev_user, rev_user_text,
    count(*) as rev_user_count,
    (SELECT count(*) FROM revision WHERE rev_page = 1) as rev_total_count,
    100 * count(*)/(SELECT count(*) FROM revision WHERE rev_page = 1) as rev_percent
FROM revision
WHERE rev_page = 1
GROUP BY rev_user