tableNames( 'image','imagelinks' ) ); return 'SELECT img_name as title, img_user, img_user_text, img_timestamp as value, img_description' . ' FROM '.$image.' LEFT JOIN '.$imagelinks.' ON img_name=il_to WHERE il_to IS NULL '; } function formatResult( $skin, $result ) { global $wgLang; $title = Title::makeTitle( NS_IMAGE, $result->title ); $ins = $wgLang->getNsText(NS_IMAGE); $return = # The 'desc' linking to the image page '('.$skin->makeKnownLink( $ins.':'.$result->title, wfMsg('imgdesc') ).') ' # Link to the image itself . ''.$title->getText().'' # Last modified date . ' . . '.$wgLang->timeanddate($result->value) # Link to username . ' . . '.$skin->makeLink($wgLang->getNsText(NS_USER).':'.$result->img_user_text,$result->img_user_text); # If there is a description, show it if($result->img_description != '') { $return .= ' ('.$result->img_description.')'; } return $return; } function getPageHeader() { return wfMsg( "unusedimagestext" ); } } /** * Entry point */ function wfSpecialUnusedimages() { list( $limit, $offset ) = wfCheckLimits(); $uip = new UnusedimagesPage(); return $uip->doQuery( $offset, $limit ); } ?>