wikimedia / mediawiki

		$this->addFieldsIf( 'fa_bits', $fld_bitdepth );

		$this->addFieldsIf( 'fa_archive_name', $fld_archivename );

		if ( !is_null( $params['continue'] ) ) {

			$cont = explode( '|', $params['continue'] );

			$this->dieContinueUsageIf( count( $cont ) != 3 );

			$op = $params['dir'] == 'descending' ? '<' : '>';

			$cont_from = $db->addQuotes( $cont[0] );

			$cont_timestamp = $db->addQuotes( $db->timestamp( $cont[1] ) );

			$cont_id = (int)$cont[2];

			$this->dieContinueUsageIf( $cont[2] !== (string)$cont_id );

			$this->addWhere( "fa_name $op $cont_from OR " .

				"(fa_name = $cont_from AND " .

				"(fa_timestamp $op $cont_timestamp OR " .

				"(fa_timestamp = $cont_timestamp AND " .

				"fa_id $op= $cont_id )))"

			);

		}

		// Image filters

		$dir = ( $params['dir'] == 'descending' ? 'older' : 'newer' );

		$this->addWhereRange( 'pt_namespace', $params['dir'], null, null );

		$this->addWhereRange( 'pt_title', $params['dir'], null, null );

		if ( !is_null( $params['continue'] ) ) {

			$cont = explode( '|', $params['continue'] );

			$this->dieContinueUsageIf( count( $cont ) != 3 );

			$op = ( $params['dir'] === 'newer' ? '>' : '<' );

			$db = $this->getDB();

			$continueTimestamp = $db->addQuotes( $db->timestamp( $cont[0] ) );

			$continueNs = (int)$cont[1];

			$this->dieContinueUsageIf( $continueNs != $cont[1] );

			$continueTitle = $db->addQuotes( $cont[2] );

			$this->addWhere( "pt_timestamp $op $continueTimestamp OR " .

				"(pt_timestamp = $continueTimestamp AND " .

				"(pt_namespace $op $continueNs OR " .

				"(pt_namespace = $continueNs AND " .

				"pt_title $op= $continueTitle)))"

			);

		}

		if ( isset( $prop['user'] ) ) {

			$this->addTables( 'user' );