global $wgOut, $wgArticle, $wgUser;
global $wgMessageCache, $wgMemc, $wgDBname, $wgUseMemCached;
+ # Initialise $wgOut and $wgUser for a command line script
+ $wgOut->disable();
+
+ $wgUser = new User;
+ $wgUser->setLoaded( true ); # Don't load from DB
+ $wgUser->setName( 'MediaWiki default' );
+
# Don't try to draw messages from the database we're initialising
$wgMessageCache->disable();
- $fname = "initialiseMessages";
+ $fname = 'initialiseMessages';
$ns = NS_MEDIAWIKI;
# cur_user_text responsible for the modifications
# Don't change it unless you're prepared to update the DBs accordingly, otherwise the
# default messages won't be overwritte
- $username = "MediaWiki default";
+ $username = 'MediaWiki default';
$timestamp = wfTimestampNow();
$invTimestamp = wfInvertTimestamp( $timestamp );
- $mwMsg =& MagicWord::get( MAG_MSG );
- $navText = str_replace( "$1", "allmessagestext", $mwMsg->getSynonym( 0 ) );
+ $navText = '{{int:allmessagestext}}';
$navText .= "
<table border=1 width=100%><tr><td>
</td></tr>";
print "Initialising \"MediaWiki\" namespace...\n";
- $sql = "SELECT cur_title,cur_is_new,cur_user_text FROM cur WHERE cur_namespace=$ns AND cur_title IN(";
+
+
+ $dbr =& wfGetDB( DB_SLAVE );
+ $dbw =& wfGetDB( DB_MASTER );
+ $cur = $dbr->tableName( 'cur' );
+
+ $sql = "SELECT cur_title,cur_is_new,cur_user_text FROM $cur WHERE cur_namespace=$ns AND cur_title IN(";
# Get keys from $wgAllMessagesEn, which is more complete than the local language
$first = true;
if ( $messageArray ) {
- $sortedArray = $wgAllMessagesEn;
+ $sortedArray = $messageArray;
} else {
$sortedArray = $wgAllMessagesEn;
}
ksort( $sortedArray );
-
+
# SELECT all existing messages
+ # Can't afford to be locking all rows for update, this script can take quite a long time to complete
foreach ( $sortedArray as $key => $enMsg ) {
- if ( $key == "" ) {
+ if ( $key == '' ) {
continue; // Skip odd members
}
if ( $first ) {
$first = false;
} else {
- $sql .= ",";
+ $sql .= ',';
}
$titleObj = Title::newFromText( $key );
- $enctitle = wfStrencode($titleObj->getDBkey());
+ $enctitle = $dbr->strencode($titleObj->getDBkey());
$sql .= "'$enctitle'";
}
- $sql .= ")";
- $res = wfQuery( $sql, DB_READ );
- $row = wfFetchObject( $res );
+ $sql .= ')';
+ $res = $dbr->query( $sql );
+ $row = $dbr->fetchObject( $res );
# Read the results into an array
# Decide whether or not each one needs to be overwritten
$existingTitles = array();
while ( $row ) {
- if ( !$row->cur_is_new || $row->cur_user_text != $username ) {
- $existingTitles[$row->cur_title] = "keep";
+ if ( $row->cur_user_text != $username ) {
+ $existingTitles[$row->cur_title] = 'keep';
} else {
- $existingTitles[$row->cur_title] = "chuck";
+ $existingTitles[$row->cur_title] = 'chuck';
}
- $row = wfFetchObject( $res );
+ $row = $dbr->fetchObject( $res );
}
# Insert queries are done in one multi-row insert
# Here's the start of it:
- $sql = "INSERT INTO cur (cur_namespace, cur_title, cur_text,
+ $sql = "INSERT INTO $cur (cur_namespace, cur_title, cur_text,
cur_user_text, cur_timestamp, cur_restrictions,
cur_is_new, inverse_timestamp, cur_touched) VALUES ";
$first = true;
- $mwObj =& MagicWord::get( MAG_MSGNW );
- $msgnw = $mwObj->getSynonym( 0 );
$talk = $wgLang->getNsText( NS_TALK );
$mwtalk = $wgLang->getNsText( NS_MEDIAWIKI_TALK );
# Process each message
foreach ( $sortedArray as $key => $enMsg ) {
- if ( $key == "" ) {
+ if ( $key == '' ) {
continue; // Skip odd members
}
# Get message text
}
$titleObj = Title::newFromText( $key );
$title = $titleObj->getDBkey();
- $dbencMsg = wfStrencode( $message );
+ $dbencMsg = $dbw->strencode( $message );
# Update messages which already exist
- # Note: UPDATE is now used instead of DELETE/INSERT to avoid wiping cur_restrictions
if ( array_key_exists( $title, $existingTitles ) ) {
- if ( $existingTitles[$title] == "chuck" || $overwrite) {
- wfQuery( "UPDATE cur
- SET
- cur_text='$dbencMsg',
- cur_user=0,
- cur_user_text='$username',
- cur_timestamp='$timestamp',
- cur_touched='$timestamp',
- inverse_timestamp='$invTimestamp'
- WHERE cur_namespace=8 and cur_title='$title'", DB_WRITE
- );
+ if ( $existingTitles[$title] == 'chuck' || $overwrite) {
+ # print "$title\n";
+ $mwTitleObj = Title::makeTitle( NS_MEDIAWIKI, $title );
+ $article = new Article( $mwTitleObj );
+ $article->quickEdit( $message );
}
$doInsert = false;
} else {
if ( $first ) {
$first = false;
} else {
- $sql .= ",";
+ $sql .= ',';
}
$sql .=
"($ns,
}
# Make table row for navigation page
- $mw = str_replace( "$1", $key, $msgnw );
-
$message = wfEscapeWikiText( $message );
$navText .=
"<tr><td>
</td><td>
$message
</td><td>
-$mw
+{{int:$title}}
</td></tr>";
}
# Perform the insert query
if ( !$first ) {
- wfQuery( $sql, DB_WRITE, $fname );
+ $dbw->query( $sql, $fname );
}
# Write the navigation page
- $navText .= "</table>";
- $title = wfMsgNoDB( "allmessages" );
- $titleObj = Title::makeTitle( NS_MEDIAWIKI, $title );
+ $navText .= '</table>';
+ $title = wfMsgNoDB( 'allmessages' );
+ $titleObj = Title::makeTitle( NS_WIKIPEDIA, $title );
$wgArticle = new Article( $titleObj );
$wgOut->disable();
$wgUser = User::newFromName( 'MediaWiki default' );
# Clear the relevant memcached key
if( $wgUseMemCached ) {
- print "Clearing message cache...";
- $wgMemc->delete( "$wgDBname:messages" );
+ print 'Clearing message cache...';
+ $wgMemc->delete( $wgDBname.':messages' );
print "Done.\n";
}
}
-function loadArrayFromFile( $filename )
+function loadLanguageFile( $filename )
{
$contents = file_get_contents( $filename );
+ # Remove header line
+ $p = strpos( $contents, "\n" ) + 1;
+ $contents = substr( $contents, $p );
+ # Unserialize
return unserialize( $contents );
}
+function doUpdates() {
+ global $wgDeferredUpdateList;
+ foreach ( $wgDeferredUpdateList as $up ) { $up->doUpdate(); }
+}
+
?>