Last modified: 2014-01-03 16:05:44 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-156. Summary: List of 100 Users and sysops that have most revisions in a wiki with counting of their contributions in each name spaces in month period Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: reza <reza.energy@gmail.com> Date: Fri, 23 Sep 2011 11:30:42 ------------------------------------------------------------------------------- List of 100 Users and sysops that have most revisions in a wiki with counting of their contributions in each name spaces in month period
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 23 Sep 2011 17:50:54 ------------------------------------------------------------------------------- Sorry, but I can't do that with so few information, please redefine your needs. (On which wiki? 100 non-sysops and 100 sysops? What format? ...)
------------------------------------------------------------------------------- From: DaB. <dab@ts.wikimedia.org> Date: Fri, 23 Sep 2011 17:52:07 ------------------------------------------------------------------------------- and which time-span?
------------------------------------------------------------------------------- From: reza <reza.energy@gmail.com> Date: Fri, 23 Sep 2011 18:03:30 ------------------------------------------------------------------------------- thank your for reply we want to charts 1- with bot 2- no bot * for fa.wiki *for any user group (normal or sysops or bot) who had any contributions in fa.wiki sorted with most editions *time-span= one month * all of name spaces * for 100 most contributed users for example: :r user ns0 ns10 ns14 .... user group :1 rezabot 12000 234 0 bot :2-reza2 545 444 4 user :3-reza3 344 33 2 sysops :4- rewa 22 2 1 user :. . .100 ......................................... 2-second query without bot contributions
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Fri, 23 Sep 2011 22:37:44 ------------------------------------------------------------------------------- SQL: http://toolserver.org/~hoo/dbq/dbq-156.sh Result: http://toolserver.org/~hoo/dbq/dbq-156.txt (sysops, bots and user) http://toolserver.org/~hoo/dbq/dbq-156_2.txt (sysops and users) Hope this is what you wanted, cause it was quite some work to build the queries ![][1] I used August 2011 as month, btw [1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif
------------------------------------------------------------------------------- From: reza <reza.energy@gmail.com> Date: Sat, 24 Sep 2011 11:12:08 ------------------------------------------------------------------------------- thank you very much.it is perfect In edits_all, it has bug because if you add all of namespaces contributions it is not equal
------------------------------------------------------------------------------- From: reza <reza.energy@gmail.com> Date: Sat, 24 Sep 2011 11:35:25 ------------------------------------------------------------------------------- for example http://toolserver.org/~soxred93/pcount/index.php?name=reza1615&lang=fa&wiki=wikipedia reza1615 edits in 08/2011 was 1175 but in report is 4700.
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sat, 24 Sep 2011 12:53:10 ------------------------------------------------------------------------------- bah ![][1] ... I had a slight mistake within the queries. I've fixed the queries and re executed them, the results should be fine now ![][2] [1]: https://jira.toolserver.org/images/icons/emoticons/tongue.gif [2]: https://jira.toolserver.org/images/icons/emoticons/wink.gif
------------------------------------------------------------------------------- From: reza <reza.energy@gmail.com> Date: Sat, 24 Sep 2011 14:25:08 ------------------------------------------------------------------------------- thank it is fine! i have other request is it possible to add user's total contribution in last column? excuse me i wast your time. this is the result in fa.wiki http://fa.wikipedia.org/wiki/%D9%88%DB%8C%DA%A9%DB%8C%E2%80%8C%D9%BE%D8%AF%DB%8C%D8%A7:%DA%AF%D8%B2%D8%A7%D8%B1%D8%B4_%D8%AF%DB%8C%D8%AA%D8%A7%D8%A8%DB%8C%D8%B3/%D9%81%D8%B9%D8%A7%D9%84%DB%8C%D8%AA_%DA%A9%D8%A7%D8%B1%D8%A8%D8%B1%D9%87%D8%A7/%D8%A8%D8%A7_%D8%B1%D8%A8%D8%A7%D8%AA/%DA%98%D9%88%D8%A6%DB%8C%D9%87_%DB%B2%DB%B0%DB%B1%DB%B1
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sat, 24 Sep 2011 19:20:06 ------------------------------------------------------------------------------- Done as well ![][1] [1]: https://jira.toolserver.org/images/icons/emoticons/wink.gif
This bug was imported as RESOLVED. The original assignee has therefore not been set, and the original reporters/responders have not been added as CC, to prevent bugspam. If you re-open this bug, please consider adding these people to the CC list: Original assignee: hoo@online.de CC list: reza.energy@gmail.com, hoo@online.de, wikimedia-bugzilla@dabpunkt.eu