4 * Support functions for the deleteOldRevisions script
6 * @addtogroup Maintenance
7 * @author Rob Church <robchur@gmail.com>
10 require_once( 'purgeOldText.inc' );
12 function DeleteOldRevisions( $delete = false ) {
14 # Data should come off the master, wrapped in a transaction
15 $dbw = wfGetDB( DB_MASTER );
18 $tbl_pag = $dbw->tableName( 'page' );
19 $tbl_rev = $dbw->tableName( 'revision' );
21 # Get "active" revisions from the page table
22 echo( "Searching for active revisions..." );
23 $res = $dbw->query( "SELECT page_latest FROM $tbl_pag" );
24 while( $row = $dbw->fetchObject( $res ) ) {
25 $cur[] = $row->page_latest;
29 # Get all revisions that aren't in this set
30 echo( "Searching for inactive revisions..." );
31 $set = implode( ', ', $cur );
32 $res = $dbw->query( "SELECT rev_id FROM $tbl_rev WHERE rev_id NOT IN ( $set )" );
33 while( $row = $dbw->fetchObject( $res ) ) {
34 $old[] = $row->rev_id;
38 # Inform the user of what we're going to do
39 $count = count( $old );
40 echo( "$count old revisions found.\n" );
42 # Delete as appropriate
43 if( $delete && $count ) {
44 echo( "Deleting..." );
45 $set = implode( ', ', $old );
46 $dbw->query( "DELETE FROM $tbl_rev WHERE rev_id IN ( $set )" );
51 # Purge redundant text records
54 PurgeRedundantText( true );