Last modified: 2014-01-03 16:08:41 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-174. Summary: Emijrp/List of Wikipedians by number of edits Issue type: Task - A task that needs to be done. Priority: Minor Status: Done Assignee: madman <madman@ferretproductions.com> ------------------------------------------------------------------------------- From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com> Date: Mon, 23 Jan 2012 21:20:14 ------------------------------------------------------------------------------- The "Emijrp/List of Wikipedians by number of edits" is not working from last 2 months. We want a list of top 100 wikipedians on mr.wikipedia.org by number of edits. The list should show the difference between active and inactive users and also update every 15 days (2wice in month).
------------------------------------------------------------------------------- From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com> Date: Mon, 23 Jan 2012 21:23:41 ------------------------------------------------------------------------------- http://mr.wikipedia.org/wiki/%E0%A4%B8%E0%A4%A6%E0%A4%B8%E0%A5%8D%E0%A4%AF:Emijrp/List_of_Wikipedians_by_number_of_edits
------------------------------------------------------------------------------- From: madman <madman@ferretproductions.com> Date: Mon, 23 Jan 2012 23:30:32 ------------------------------------------------------------------------------- SELECT DISTINCT `user_name`, `user_editcount`, MAX(`rev_timestamp`) FROM `user` LEFT JOIN `user_groups` ON `user_id` = `ug_user` LEFT JOIN `revision` ON `user_id` = `rev_user` WHERE (`ug_group` IS NULL OR ug_group != 'bot') GROUP BY `rev_user` ORDER BY `user_editcount` DESC LIMIT 100;
------------------------------------------------------------------------------- From: madman <madman@ferretproductions.com> Date: Tue, 24 Jan 2012 02:16:59 ------------------------------------------------------------------------------- Rahuldeshmukh101, please see http://mr.wikipedia.org/wiki/%E0%A4%B8%E0%A4%A6%E0%A4%B8%E0%A5%8D%E0%A4%AF:Emijrp/List_of_Wikipedians_by_number_of_edits, which I have copied from https://toolserver.org/~madman/dbq-results/dbq-174.txt. If the output looks satisfactory, I can set it up to run on the 1st and 15th of every month; if not, let me know and I'll be happy to change it. Thanks! -[[wikipedia:en:User:Madman]]
------------------------------------------------------------------------------- From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com> Date: Tue, 24 Jan 2012 05:33:53 ------------------------------------------------------------------------------- The output is satisfactory you can set it up to run on the 1st and 15th of every month; Thanks ~~~
------------------------------------------------------------------------------- From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com> Date: Sat, 04 Feb 2012 17:49:54 ------------------------------------------------------------------------------- As requested please schedule the job on 1st and 15th of month to update. For Feb 2012 it did not updated the data. Also if possible please filter out the inter wiki bot from appearing on the list as may bots without local bot flag work on mr.wiki and are appearing in the list. Thanks Rahul
------------------------------------------------------------------------------- From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com> Date: Sat, 04 Feb 2012 17:58:45 ------------------------------------------------------------------------------- The schedule bot is not working. The update which was expected on 1st and 15th of a month is not updated.
------------------------------------------------------------------------------- From: madman <madman@ferretproductions.com> Date: Sat, 04 Feb 2012 18:16:23 ------------------------------------------------------------------------------- I did set it up to run on the 1st and 15th, and in fact ran a manual update yesterday to test something. I'll add a comment in the output that indicates when it was last updated. -Madman
------------------------------------------------------------------------------- From: madman <madman@ferretproductions.com> Date: Sat, 04 Feb 2012 18:20:48 ------------------------------------------------------------------------------- Done. https://toolserver.org/~madman/dbq-results/dbq-174.txt Will get e-mail when the job runs again on the 15th and will see why if not. -Madman
------------------------------------------------------------------------------- From: Rahuldeshmukh101 <rahuldeshmukh101@rediffmail.com> Date: Sun, 05 Feb 2012 04:19:26 ------------------------------------------------------------------------------- Thanks. madman for the support. * Rahul
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: madman.enwiki@gmail.com CC list: madman.enwiki@gmail.com, rahuldeshmukh101@rediffmail.com