diff options
author | Pierre Schmitz <pierre@archlinux.de> | 2007-05-16 20:58:53 +0000 |
---|---|---|
committer | Pierre Schmitz <pierre@archlinux.de> | 2007-05-16 20:58:53 +0000 |
commit | cecb985bee3bdd252e1b8dc0bd500b37cd52be01 (patch) | |
tree | 17266aa237742640aabee7856f0202317a45d540 /maintenance/updateRestrictions.php | |
parent | 0bac06c301f2a83edb0236e4c2434da16848d549 (diff) |
Aktualisierung auf MediaWiki 1.10.0
Plugins angepasst und verbessert
kleine Korrekturen am Design
Diffstat (limited to 'maintenance/updateRestrictions.php')
-rw-r--r-- | maintenance/updateRestrictions.php | 67 |
1 files changed, 67 insertions, 0 deletions
diff --git a/maintenance/updateRestrictions.php b/maintenance/updateRestrictions.php new file mode 100644 index 00000000..6c8ffb5e --- /dev/null +++ b/maintenance/updateRestrictions.php @@ -0,0 +1,67 @@ +<?php + +/* + * Makes the required database updates for Special:ProtectedPages + * to show all protected pages, even ones before the page restrictions + * schema change. All remaining page_restriction column values are moved + * to the new table. + */ + +define( 'BATCH_SIZE', 100 ); + +require_once 'commandLine.inc'; + +$db =& wfGetDB( DB_MASTER ); +if ( !$db->tableExists( 'page_restrictions' ) ) { + echo "page_restrictions does not exist\n"; + exit( 1 ); +} + +migrate_page_restrictions( $db ); + +function migrate_page_restrictions( $db ) { + + $start = $db->selectField( 'page', 'MIN(page_id)', false, __FUNCTION__ ); + $end = $db->selectField( 'page', 'MAX(page_id)', false, __FUNCTION__ ); + $blockStart = $start; + $blockEnd = $start + BATCH_SIZE - 1; + $encodedExpiry = Block::decodeExpiry(''); + while ( $blockEnd <= $end ) { + $cond = "page_id BETWEEN $blockStart AND $blockEnd AND page_restrictions !=''"; + $res = $db->select( 'page', array('page_id', 'page_restrictions'), $cond, __FUNCTION__ ); + $batch = array(); + while ( $row = $db->fetchObject( $res ) ) { + $oldRestrictions = array(); + foreach( explode( ':', trim( $row->page_restrictions ) ) as $restrict ) { + $temp = explode( '=', trim( $restrict ) ); + if(count($temp) == 1) { + // old old format should be treated as edit/move restriction + $oldRestrictions["edit"] = trim( $temp[0] ); + $oldRestrictions["move"] = trim( $temp[0] ); + } else { + $oldRestrictions[$temp[0]] = trim( $temp[1] ); + } + } + # Update restrictions table + foreach( $oldRestrictions as $action => $restrictions ) { + $batch[] = array( + 'pr_page' => $row->page_id, + 'pr_type' => $action, + 'pr_level' => $restrictions, + 'pr_cascade' => 0, + 'pr_expiry' => $encodedExpiry + ); + } + } + # We use insert() and not replace() as Article.php replaces + # page_restrictions with '' when protected in the restrictions table + if ( count( $batch ) ) { + $db->insert( 'page_restrictions', $batch, __FUNCTION__ ); + } + $blockStart += BATCH_SIZE; + $blockEnd += BATCH_SIZE; + wfWaitForSlaves( 5 ); + } +} + +?> |