Last modified: 2014-01-03 16:00:52 UTC
This issue was converted from https://jira.toolserver.org/browse/DBQ-132. Summary: User rights changes log on fawiki from metawiki Issue type: Task - A task that needs to be done. Priority: Major Status: Done Assignee: Hoo man <hoo@online.de> ------------------------------------------------------------------------------- From: Mjbmr <mjbmri@gmail.com> Date: Sat, 26 Mar 2011 17:30:35 ------------------------------------------------------------------------------- Hello, I'd like to have a list of user rights changes log on fawiki that they are changed from metawiki, Thank you.
------------------------------------------------------------------------------- From: Hoo man <hoo@online.de> Date: Sat, 26 Mar 2011 18:58:51 ------------------------------------------------------------------------------- SQL: SELECT DATE_FORMAT(log_timestamp, '%y-%m-%d-%h-%i-%s') as time, user_name as meta_user, REPLACE(log_title, '@fawiki', '') as fa_user, log_comment as comment, log_params as tmp FROM logging INNER JOIN user ON log_user = user_id WHERE log_type = 'rights' AND log_title LIKE '%@fawiki'; (afterwards I had to split the column tmp into two new columns because mediawiki stores both the new and the old flags in log_params ![][1] ) Result: http://toolserver.org/~hoo/dbq/dbq-132.txt [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: hoo@online.de, mjbmri@gmail.com