Differential D9431 Diff 22523 resources/sql/patches/102.heraldcleanup.php

Changeset View

Standalone View

	Show All 18 Lines
	$clause = '';			$clause = '';
	if ($rules) {			if ($rules) {
	$clause = qsprintf(			$clause = qsprintf(
	$conn_w,			$conn_w,
	'WHERE ruleID NOT IN (%Ld)',			'WHERE ruleID NOT IN (%Ld)',
	mpull($rules, 'getID'));			mpull($rules, 'getID'));
	}			}

	echo "This may take a moment";			echo 'This may take a moment';
	do {			do {
	queryfx(			queryfx(
	$conn_w,			$conn_w,
	'DELETE FROM %T %Q LIMIT 1000',			'DELETE FROM %T %Q LIMIT 1000',
	HeraldRule::TABLE_RULE_APPLIED,			HeraldRule::TABLE_RULE_APPLIED,
	$clause);			$clause);
	echo ".";			echo '.';
	} while ($conn_w->getAffectedRows());			} while ($conn_w->getAffectedRows());

	$table->endReadLocking();			$table->endReadLocking();
	$table->saveTransaction();			$table->saveTransaction();
	echo "\nDone.\n";			echo "\nDone.\n";