5 * @subpackage Maintenance
9 define( "REPORTING_INTERVAL", 100 );
10 #define( "REPORTING_INTERVAL", 1 );
12 function refreshLinks( $start, $newOnly = false, $maxLag = false, $end = 0 ) {
13 global $wgUser, $wgParser, $wgUseImageResize, $wgUseTidy;
15 $fname = 'refreshLinks';
16 $dbr =& wfGetDB( DB_SLAVE );
17 $start = intval( $start );
19 # Don't generate TeX PNGs (lack of a sensible current directory causes errors anyway)
20 $wgUser->setOption('math', MW_MATH_SOURCE);
22 # Don't generate extension images (e.g. Timeline)
23 $wgParser->mTagHooks = array();
25 # Don't generate thumbnail images
26 $wgUseImageResize = false;
30 print "Refreshing links from ";
31 $res = $dbr->select( 'page',
38 $num = $dbr->numRows( $res );
39 print "$num new articles...\n";
42 while ( $row = $dbr->fetchObject( $res ) ) {
43 if ( !( ++$i % REPORTING_INTERVAL ) ) {
45 wfWaitForSlaves( $maxLag );
48 fixLinksFromArticle( $row->page_id );
51 print "Refreshing link table.\n";
53 $end = $dbr->selectField( 'page', 'max(page_id)', false );
55 print("Starting from page_id $start of $end.\n");
57 for ($id = $start; $id <= $end; $id++) {
59 if ( !($id % REPORTING_INTERVAL) ) {
61 wfWaitForSlaves( $maxLag );
63 fixLinksFromArticle( $id );
68 function fixLinksFromArticle( $id ) {
69 global $wgTitle, $wgParser;
71 $wgTitle = Title::newFromID( $id );
72 $dbw =& wfGetDB( DB_MASTER );
74 $linkCache =& LinkCache::singleton();
77 if ( is_null( $wgTitle ) ) {
82 $revision = Revision::newFromTitle( $wgTitle );
87 $options = new ParserOptions;
88 $parserOutput = $wgParser->parse( $revision->getText(), $wgTitle, $options, true, true, $revision->getId() );
89 $update = new LinksUpdate( $wgTitle, $parserOutput, false );
91 $dbw->immediateCommit();
94 function deleteLinksFromNonexistent( $maxLag = 0 ) {
95 $fname = 'deleteLinksFromNonexistent';
97 wfWaitForSlaves( $maxLag );
99 $dbw =& wfGetDB( DB_WRITE );
101 $linksTables = array(
102 'pagelinks' => 'pl_from',
103 'imagelinks' => 'il_from',
104 'categorylinks' => 'cl_from',
105 'templatelinks' => 'tl_from',
106 'externallinks' => 'el_from',
109 $page = $dbw->tableName( 'page' );
112 foreach ( $linksTables as $table => $field ) {
113 if ( !$dbw->ping() ) {
114 print "DB disconnected, reconnecting...";
115 while ( !$dbw->ping() ) {
122 $pTable = $dbw->tableName( $table );
123 $sql = "DELETE $pTable FROM $pTable LEFT JOIN $page ON page_id=$field WHERE page_id IS NULL";
125 print "Deleting $table from non-existent articles...";
126 $dbw->query( $sql, $fname );
127 print " fixed " .$dbw->affectedRows() . " row(s)\n";