$body = $body . "<H4>STAFF SERVICES</H4>Number of Wikis Auto-Adopted: " . $output;
$res = $dbr->query("select count(*) as count from city_list_log where cl_text like '%.wikia.com added.' and cl_timestamp>{$lastmonth} and cl_timestamp<{$thismonth}");
while ($row = $dbr->fetchObject($res)) {
$output = $row->count;
}
$body = $body . "<br />Number of Wikis With URLs Added: " . $output;
$res = $dbr->query("select count(*) as count from city_list_log where cl_text like 'Variable wgServer changed value%' and cl_timestamp>{$lastmonth} and cl_timestamp<{$thismonth}");
while ($row = $dbr->fetchObject($res)) {
$output = $row->count;
}
$body = $body . "<br/>Number of Wikis With Primary URLs changed: " . $output;
$res = $dbr->query("select count(*) as count from city_list_log where cl_text like 'Variable wgServer changed value%' and cl_timestamp>{$lastmonth} and cl_timestamp<{$thismonth}");
while ($row = $dbr->fetchObject($res)) {
$output = $row->count;
}
$body = $body . "<br />Number of Wikis Closed this Month: " . $output;
global $wgExternalDatawareDB;
$dbw = wfGetDB(DB_SLAVE, array(), $wgExternalDatawareDB);
$res = $dbw->query("select count(*) as count from wikiastaff_log where slog_comment like '%started to rename%' and slog_timestamp>{$lastmonth} and slog_timestamp<{$thismonth}");
while ($row = $dbw->fetchObject($res)) {
$output = $row->count;
}
$body = $body . "<br />Number of User Accounts Renamed This Month: " . $output;
$res = $dbr->query("select count(*) as count from user where user_real_name=\"Account Disabled\" and user_touched>{$lastmonth} and user_touched<{$thismonth}");
while ($row = $dbr->fetchObject($res)) {
$output = $row->count;
}
$body = $body . "<br />Number of User Accounts Closed this Month: " . $output;
$bodyHTML = $body;
UserMailer::sendHTML($to, $from, $subject, $body, $bodyHTML);
