6 /* private */ var $mId, $mTitle;
8 function LinksUpdate( $id, $title )
11 $this->mTitle
= $title;
12 $this->mTitleEnc
= wfStrencode( $title );
17 global $wgUseBetterLinksUpdate, $wgLinkCache, $wgDBtransactions;
21 /* Update link tables with outgoing links from an updated article */
22 /* Relies on the 'link cache' to be filled out */
24 if ( !$wgUseBetterLinksUpdate ) {
25 $this->doDumbUpdate();
29 $fname = "LinksUpdate::doUpdate";
30 wfProfileIn( $fname );
35 if( $wgDBtransactions ) {
37 wfQuery( $sql, $fname );
40 #------------------------------------------------------------------------------
43 if ( $wgLinkCache->incrementalSetup( LINKCACHE_GOOD
, $del, $add ) ) {
44 # Delete where necessary
45 $baseSql = "DELETE FROM links WHERE l_from='{$this->mTitleEnc}'";
46 foreach ($del as $title => $id ) {
47 wfDebug( "Incremental deletion from {$this->mTitleEnc} to $title\n" );
48 $sql = $baseSql . " AND l_to={$id}";
49 wfQuery( $sql, $fname );
53 wfDebug( "Complete deletion from {$this->mTitleEnc}\n" );
54 $sql = "DELETE FROM links WHERE l_from='{$this->mTitleEnc}'";
55 wfQuery( $sql, $fname );
57 # Get the addition list
58 $add = $wgLinkCache->getGoodLinks();
63 if ( 0 != count( $add ) ) {
64 $sql = "INSERT INTO links (l_from,l_to) VALUES ";
66 foreach( $add as $lt => $lid ) {
67 wfDebug( "Inserting from {$this->mTitleEnc} to $lt\n" );
69 if ( ! $first ) { $sql .= ","; }
72 $sql .= "('{$this->mTitleEnc}',{$lid})";
75 if ( "" != $sql ) { wfQuery( $sql, $fname ); }
77 #------------------------------------------------------------------------------
80 if ( $wgLinkCache->incrementalSetup( LINKCACHE_BAD
, $del, $add ) ) {
81 # Delete where necessary
82 $baseSql = "DELETE FROM brokenlinks WHERE bl_from={$this->mId}";
83 foreach ( $del as $title ) {
84 $sql = $baseSql . " AND bl_to={$title}";
85 wfQuery( $sql, $fname );
89 $sql = "DELETE FROM brokenlinks WHERE bl_from={$this->mId}";
90 wfQuery( $sql, $fname );
93 $add = $wgLinkCache->getBadLinks();
98 if ( 0 != count ( $add ) ) {
99 $sql = "INSERT INTO brokenlinks (bl_from,bl_to) VALUES ";
101 foreach( $add as $blt ) {
102 $blt = wfStrencode( $blt );
103 if ( ! $first ) { $sql .= ","; }
106 $sql .= "({$this->mId},'{$blt}')";
109 if ( "" != $sql ) { wfQuery( $sql, $fname ); }
111 #------------------------------------------------------------------------------
113 if ( $wgLinkCache->incrementalSetup( LINKCACHE_IMAGE
, $del, $add ) ) {
114 # Delete where necessary
115 $sql = "DELETE FROM imagelinks WHERE il_from='{$this->mTitleEnc}'";
116 foreach ($del as $title ) {
117 $sql = $baseSql . " AND il_to={$title}";
118 wfQuery( $sql, $fname );
122 $sql = "DELETE FROM imagelinks WHERE il_from='{$this->mTitleEnc}'";
123 wfQuery( $sql, $fname );
126 $add = $wgLinkCache->getImageLinks();
131 if ( 0 != count ( $add ) ) {
132 $sql = "INSERT INTO imagelinks (il_from,il_to) VALUES ";
134 foreach( $add as $iname => $val ) {
135 $iname = wfStrencode( $iname );
136 if ( ! $first ) { $sql .= ","; }
139 $sql .= "('{$this->mTitleEnc}','{$iname}')";
142 if ( "" != $sql ) { wfQuery( $sql, $fname ); }
144 $this->fixBrokenLinks();
146 if( $wgDBtransactions ) {
148 wfQuery( $sql, $fname );
153 function doDumbUpdate()
155 # Old update function. This can probably be removed eventually, if the new one
156 # proves to be stable
157 global $wgLinkCache, $wgDBtransactions;
158 $fname = "LinksUpdate::doDumbUpdate";
159 wfProfileIn( $fname );
161 if( $wgDBtransactions ) {
163 wfQuery( $sql, $fname );
166 $sql = "DELETE FROM links WHERE l_from='{$this->mTitleEnc}'";
167 wfQuery( $sql, $fname );
169 $a = $wgLinkCache->getGoodLinks();
171 if ( 0 != count( $a ) ) {
172 $sql = "INSERT INTO links (l_from,l_to) VALUES ";
174 foreach( $a as $lt => $lid ) {
175 if ( ! $first ) { $sql .= ","; }
178 $sql .= "('{$this->mTitleEnc}',{$lid})";
181 if ( "" != $sql ) { wfQuery( $sql, $fname ); }
183 $sql = "DELETE FROM brokenlinks WHERE bl_from={$this->mId}";
184 wfQuery( $sql, $fname );
186 $a = $wgLinkCache->getBadLinks();
188 if ( 0 != count ( $a ) ) {
189 $sql = "INSERT INTO brokenlinks (bl_from,bl_to) VALUES ";
191 foreach( $a as $blt ) {
192 $blt = wfStrencode( $blt );
193 if ( ! $first ) { $sql .= ","; }
196 $sql .= "({$this->mId},'{$blt}')";
199 if ( "" != $sql ) { wfQuery( $sql, $fname ); }
201 $sql = "DELETE FROM imagelinks WHERE il_from='{$this->mTitleEnc}'";
202 wfQuery( $sql, $fname );
204 $a = $wgLinkCache->getImageLinks();
206 if ( 0 != count ( $a ) ) {
207 $sql = "INSERT INTO imagelinks (il_from,il_to) VALUES ";
209 foreach( $a as $iname => $val ) {
210 $iname = wfStrencode( $iname );
211 if ( ! $first ) { $sql .= ","; }
214 $sql .= "('{$this->mTitleEnc}','{$iname}')";
217 if ( "" != $sql ) { wfQuery( $sql, $fname ); }
219 $this->fixBrokenLinks();
221 if( $wgDBtransactions ) {
223 wfQuery( $sql, $fname );
228 function fixBrokenLinks() {
229 /* Update any brokenlinks *to* this page */
230 /* Call for a newly created page, or just to make sure state is consistent */
232 $sql = "SELECT bl_from FROM brokenlinks WHERE bl_to='{$this->mTitleEnc}'";
233 $res = wfQuery( $sql, $fname );
234 if ( 0 == wfNumRows( $res ) ) { return; }
236 $sql = "INSERT INTO links (l_from,l_to) VALUES ";
237 $now = wfTimestampNow();
238 $sql2 = "UPDATE cur SET cur_touched='{$now}' WHERE cur_id IN (";
240 while ( $row = wfFetchObject( $res ) ) {
241 if ( ! $first ) { $sql .= ","; $sql2 .= ","; }
243 $nl = wfStrencode( Article
::nameOf( $row->bl_from
) );
245 $sql .= "('{$nl}',{$this->mId})";
246 $sql2 .= $row->bl_from
;
249 wfQuery( $sql, $fname );
250 wfQuery( $sql2, $fname );
252 $sql = "DELETE FROM brokenlinks WHERE bl_to='{$this->mTitleEnc}'";
253 wfQuery( $sql, $fname );