public function getTotalPatrols()
{
$dbr = wfGetDB(DB_SLAVE);
$total = $dbr->selectField('logging', 'count(*)', RCPatrolStandingsIndividual::getOpts());
return $total;
}
<?php
require_once 'commandLine.inc';
$dbr = wfGetDB(DB_SLAVE);
$res = $dbr->select('rctest_users', array('ru_user_id', 'ru_base_patrol_count'), array('ru_next_test_patrol_count' => 2, 'ru_base_patrol_count > 0'));
while ($row = $dbr->fetchObject($res)) {
$u = User::newFromId($row->ru_user_id);
$u->load();
$enabled = RCTest::isEnabled($u->getId()) ? "on" : "off";
$base = $row->ru_base_patrol_count;
$wgUser = $u;
$total = $dbr->selectField('logging', 'count(*)', RCPatrolStandingsIndividual::getOpts());
$adjusted = $total - $base;
if ($adjusted > 4) {
echo "User: "******", preference: {$enabled}, adjusted: {$adjusted}\n";
}
}