4 $password = `
/home
/wikipedia
/bin
/wikiuser_pass`
;
5 $availableDBs = array_map( 'trim', file( "/home/wikipedia/common/pmtpa.dblist" ) );
6 shuffle( $availableDBs );
11 mysql_connect( 'db4', $user, $password ) ||
myerror();
12 mysql_select_db( 'enwiki' ) ||
myerror();
13 ( $res = mysql_query( 'SELECT 1 FROM job LIMIT 1' ) ) ||
myerror();
14 $enwikiHasJobs = ( mysql_num_rows( $res ) != 0 );
15 mysql_free_result( $res );
20 mysql_connect( 'ixia', $user, $password ) ||
myerror();
22 $sql = "(SELECT '-------------------------------------------')";
23 foreach ( $availableDBs as $db ) {
24 if ( $db == 'enwiki' ) {
30 $sql .= "(SELECT '$db' FROM `$db`.job)";
33 ( $res = mysql_query( $sql ) ) ||
myerror();
34 $row = mysql_fetch_row( $res );
41 mysql_free_result( $res );
45 if ( $enwikiHasJobs ) {
47 # Choose enwiki with arbitrary constant probability
48 if ( mt_rand( 0, 4 ) == 0 ) {
61 $f = fopen( 'php://stderr', 'w' );
62 fwrite( $f, mysql_error() . "\n" );