[Bug 59387] DBQ-132 User rights changes log on fawiki from metawiki

[bugzilla-daemon]

https://bugzilla.wikimedia.org/show_bug.cgi?id=59387

--- Comment #1 from Bugzilla Bug Importer (valhallasw) 
 ---
---
From: Hoo man 
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

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

[Bug 59387] DBQ-132 User rights changes log on fawiki from metawiki

[bugzilla-daemon]

https://bugzilla.wikimedia.org/show_bug.cgi?id=59387

Bugzilla Bug Importer (valhallasw)  changed:

   What|Removed |Added

 Status|NEW |RESOLVED
 Resolution|--- |FIXED

--- Comment #2 from Bugzilla Bug Importer (valhallasw) 
 ---

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: h...@online.de
CC list: h...@online.de, mjb...@gmail.com

-- 
You are receiving this mail because:
You are on the CC list for the bug.
___
Wikibugs-l mailing list
Wikibugs-l@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l