On Tue, Jul 22, 2008 at 6:37 PM, vyznev@svn.wikimedia.org wrote:
Log Message:
Make Special:Recentchangeslinked display changes to transcluded pages (templatelinks table) and embedded images (imagelinks table). This should help a bit against the recent spate of template vandalism on enwiki. Also make the "Show changes to pages linked" button work for categories.
Remaining issues / things to do:
- Test performance of the UNION query on a larger dataset than my test wiki.
- Add some checkboxes to allow filtering the results like on Special:Whatlinkshere.
- Try to think of some way to make the behavior for categories less klugy.
. . .
// need to resort and relimit after union$sql = "(" . implode( ") UNION (", $subsql ) . ") ORDER BY rc_timestamp DESC LIMIT {$limit}";
Does this actually work in MySQL 4? I think you need to retrieve them all and do the ordering in PHP, the way it's done in WhatLinksHere.