https://www.mediawiki.org/wiki/Special:Code/MediaWiki/114967
Revision: 114967
Author: catrope
Date: 2012-04-19 18:11:39 +0000 (Thu, 19 Apr 2012)
Log Message:
-----------
Followup r114966: add forgotten file
Added Paths:
-----------
branches/wmf/1.19wmf1/extensions/ArticleFeedbackv5/sql/fix_logs.sql
Added: branches/wmf/1.19wmf1/extensions/ArticleFeedbackv5/sql/fix_logs.sql
===================================================================
--- branches/wmf/1.19wmf1/extensions/ArticleFeedbackv5/sql/fix_logs.sql
(rev 0)
+++ branches/wmf/1.19wmf1/extensions/ArticleFeedbackv5/sql/fix_logs.sql
2012-04-19 18:11:39 UTC (rev 114967)
@@ -0,0 +1,22 @@
+-- move oversight items into suppress log
+UPDATE logging SET log_type = 'suppress' WHERE log_type = 'articlefeedbackv5'
AND log_action IN ('oversight', 'unoversight', 'decline', 'request',
'unrequest');
+
+-- update counts for feedback - note this might run awhile
+UPDATE aft_article_feedback
+ INNER JOIN page ON af_page_id=page_id
+ SET af_activity_count = COALESCE((SELECT COUNT(*) FROM logging
+ WHERE log_type = 'articlefeedbackv5'
+ AND log_namespace = -1
+ AND log_title =
CONCAT('ArticleFeedbackv5/', page_title, '/', af_id)
+ GROUP BY log_title), 0)
+ WHERE page_namespace = 0;
+
+UPDATE aft_article_feedback
+ INNER JOIN page ON af_page_id=page_id
+ SET af_suppress_count = COALESCE((SELECT COUNT(*) FROM logging
+ WHERE log_type = 'suppress'
+ AND log_action IN ('oversight',
'unoversight', 'decline', 'request', 'unrequest')
+ AND log_namespace = -1
+ AND log_title =
CONCAT('ArticleFeedbackv5/', page_title, '/', af_id)
+ GROUP BY log_title), 0)
+ WHERE page_namespace = 0;
Property changes on:
branches/wmf/1.19wmf1/extensions/ArticleFeedbackv5/sql/fix_logs.sql
___________________________________________________________________
Added: svn:eol-style
+ native
_______________________________________________
MediaWiki-CVS mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/mediawiki-cvs
