Edit File by line

<?php

[0] Fix | Delete

if (defined('WORDFENCE_VERSION')) {

[1] Fix | Delete

[2] Fix | Delete

class wfActivityReport {

[3] Fix | Delete

const BLOCK_TYPE_COMPLEX = 'complex';

[4] Fix | Delete

const BLOCK_TYPE_BRUTE_FORCE = 'bruteforce';

[5] Fix | Delete

const BLOCK_TYPE_BLACKLIST = 'blacklist';

[6] Fix | Delete

[7] Fix | Delete

/**

[8] Fix | Delete

* @var int

[9] Fix | Delete

[10] Fix | Delete

private $limit = 10;

[11] Fix | Delete

[12] Fix | Delete

/**

[13] Fix | Delete

* @var wpdb

[14] Fix | Delete

[15] Fix | Delete

private $db;

[16] Fix | Delete

[17] Fix | Delete

/**

[18] Fix | Delete

* @param int $limit

[19] Fix | Delete

[20] Fix | Delete

public function __construct($limit = 10) {

[21] Fix | Delete

global $wpdb;

[22] Fix | Delete

$this->db = $wpdb;

[23] Fix | Delete

$this->limit = $limit;

[24] Fix | Delete

}

[25] Fix | Delete

[26] Fix | Delete

/**

[27] Fix | Delete

* Schedule the activity report cron job.

[28] Fix | Delete

[29] Fix | Delete

public static function scheduleCronJob() {

[30] Fix | Delete

self::clearCronJobs();

[31] Fix | Delete

[32] Fix | Delete

if (!wfConfig::get('email_summary_enabled', 1)) {

[33] Fix | Delete

return;

[34] Fix | Delete

}

[35] Fix | Delete

[36] Fix | Delete

if (is_main_site()) {

[37] Fix | Delete

list(, $end_time) = wfActivityReport::getReportDateRange();

[38] Fix | Delete

wp_schedule_single_event($end_time, 'wordfence_email_activity_report');

[39] Fix | Delete

}

[40] Fix | Delete

}

[41] Fix | Delete

[42] Fix | Delete

/**

[43] Fix | Delete

* Remove the activity report cron job.

[44] Fix | Delete

[45] Fix | Delete

public static function disableCronJob() {

[46] Fix | Delete

self::clearCronJobs();

[47] Fix | Delete

}

[48] Fix | Delete

[49] Fix | Delete

public static function clearCronJobs() {

[50] Fix | Delete

wp_clear_scheduled_hook('wordfence_email_activity_report');

[51] Fix | Delete

}

[52] Fix | Delete

[53] Fix | Delete

/**

[54] Fix | Delete

* Send out the report and reschedule the next report's cron job.

[55] Fix | Delete

[56] Fix | Delete

public static function executeCronJob() {

[57] Fix | Delete

if (!wfConfig::get('email_summary_enabled', 1)) {

[58] Fix | Delete

return;

[59] Fix | Delete

}

[60] Fix | Delete

[61] Fix | Delete

$emails = wfConfig::getAlertEmails();

[62] Fix | Delete

if (count($emails)) {

[63] Fix | Delete

$report = new self();

[64] Fix | Delete

$report->sendReportViaEmail($emails);

[65] Fix | Delete

}

[66] Fix | Delete

self::scheduleCronJob();

[67] Fix | Delete

}

[68] Fix | Delete

[69] Fix | Delete

/**

[70] Fix | Delete

* Output a compact version of the email for the WP dashboard.

[71] Fix | Delete

[72] Fix | Delete

public static function outputDashboardWidget() {

[73] Fix | Delete

$report = new self(5);

[74] Fix | Delete

echo $report->toWidgetView();

[75] Fix | Delete

}

[76] Fix | Delete

[77] Fix | Delete

/**

[78] Fix | Delete

* @return array

[79] Fix | Delete

[80] Fix | Delete

public static function getReportDateRange() {

[81] Fix | Delete

$interval = wfConfig::get('email_summary_interval', 'weekly');

[82] Fix | Delete

$offset = get_option('gmt_offset');

[83] Fix | Delete

return self::_getReportDateRange($interval, $offset);

[84] Fix | Delete

}

[85] Fix | Delete

[86] Fix | Delete

/**

[87] Fix | Delete

* Testable code.

[88] Fix | Delete

[89] Fix | Delete

* @param string $interval

[90] Fix | Delete

* @param int $offset

[91] Fix | Delete

* @param null $time

[92] Fix | Delete

* @return array

[93] Fix | Delete

[94] Fix | Delete

public static function _getReportDateRange($interval = 'weekly', $offset = 0, $time = null) {

[95] Fix | Delete

if ($time === null) {

[96] Fix | Delete

$time = time();

[97] Fix | Delete

}

[98] Fix | Delete

[99] Fix | Delete

$day = (int) gmdate('w', $time);

[100] Fix | Delete

$month = (int) gmdate("n", $time);

[101] Fix | Delete

$day_of_month = (int) gmdate("j", $time);

[102] Fix | Delete

$year = (int) gmdate("Y", $time);

[103] Fix | Delete

[104] Fix | Delete

$start_time = 0;

[105] Fix | Delete

$end_time = 0;

[106] Fix | Delete

[107] Fix | Delete

switch ($interval) {

[108] Fix | Delete

// Send a report 4pm every day

[109] Fix | Delete

case 'daily':

[110] Fix | Delete

$start_time = gmmktime(16, 0, 0, $month, $day_of_month, $year) + (-$offset * 60 * 60);

[111] Fix | Delete

$end_time = $start_time + 86400;

[112] Fix | Delete

break;

[113] Fix | Delete

[114] Fix | Delete

// Send a report 4pm every Monday

[115] Fix | Delete

case 'weekly':

[116] Fix | Delete

$start_time = gmmktime(16, 0, 0, $month, $day_of_month - $day + 1, $year) + (-$offset * 60 * 60);

[117] Fix | Delete

$end_time = $start_time + (86400 * 7);

[118] Fix | Delete

break;

[119] Fix | Delete

[120] Fix | Delete

// Send a report at 4pm the first of every month

[121] Fix | Delete

case 'monthly':

[122] Fix | Delete

$start_time = gmmktime(16, 0, 0, $month, 1, $year) + (-$offset * 60 * 60);

[123] Fix | Delete

$end_time = gmmktime(16, 0, 0, $month + 1, 1, $year) + (-$offset * 60 * 60);

[124] Fix | Delete

break;

[125] Fix | Delete

}

[126] Fix | Delete

[127] Fix | Delete

return array($start_time, $end_time);

[128] Fix | Delete

}

[129] Fix | Delete

[130] Fix | Delete

/**

[131] Fix | Delete

* @return int

[132] Fix | Delete

[133] Fix | Delete

public static function getReportDateFrom() {

[134] Fix | Delete

$interval = wfConfig::get('email_summary_interval', 'weekly');

[135] Fix | Delete

return self::_getReportDateFrom($interval);

[136] Fix | Delete

}

[137] Fix | Delete

[138] Fix | Delete

/**

[139] Fix | Delete

* @param string $interval

[140] Fix | Delete

* @param null $time

[141] Fix | Delete

* @return int

[142] Fix | Delete

[143] Fix | Delete

public static function _getReportDateFrom($interval = 'weekly', $time = null) {

[144] Fix | Delete

if ($time === null) {

[145] Fix | Delete

$time = time();

[146] Fix | Delete

}

[147] Fix | Delete

[148] Fix | Delete

// weekly

[149] Fix | Delete

$from = $time - (86400 * 7);

[150] Fix | Delete

switch ($interval) {

[151] Fix | Delete

case 'daily':

[152] Fix | Delete

$from = $time - 86400;

[153] Fix | Delete

break;

[154] Fix | Delete

[155] Fix | Delete

// Send a report at 4pm the first of every month

[156] Fix | Delete

case 'monthly':

[157] Fix | Delete

$from = strtotime('-1 month', $time);

[158] Fix | Delete

break;

[159] Fix | Delete

}

[160] Fix | Delete

[161] Fix | Delete

return $from;

[162] Fix | Delete

}

[163] Fix | Delete

[164] Fix | Delete

/**

[165] Fix | Delete

* @return array

[166] Fix | Delete

[167] Fix | Delete

public function getFullReport() {

[168] Fix | Delete

$start_time = microtime(true);

[169] Fix | Delete

$remainder = 0;

[170] Fix | Delete

$recent_firewall_activity = $this->getRecentFirewallActivity($this->limit, $remainder);

[171] Fix | Delete

return array(

[172] Fix | Delete

'top_ips_blocked' => $this->getTopIPsBlocked($this->limit),

[173] Fix | Delete

'top_countries_blocked' => $this->getTopCountriesBlocked($this->limit),

[174] Fix | Delete

'top_failed_logins' => $this->getTopFailedLogins($this->limit),

[175] Fix | Delete

'recent_firewall_activity' => $recent_firewall_activity,

[176] Fix | Delete

'omitted_firewall_activity'=> $remainder,

[177] Fix | Delete

'recently_modified_files' => $this->getRecentFilesModified($this->limit),

[178] Fix | Delete

'updates_needed' => $this->getUpdatesNeeded(),

[179] Fix | Delete

'microseconds' => microtime(true) - $start_time,

[180] Fix | Delete

);

[181] Fix | Delete

}

[182] Fix | Delete

[183] Fix | Delete

/**

[184] Fix | Delete

* @return array

[185] Fix | Delete

[186] Fix | Delete

public function getWidgetReport() {

[187] Fix | Delete

$start_time = microtime(true);

[188] Fix | Delete

return array(

[189] Fix | Delete

'top_ips_blocked' => $this->getTopIPsBlocked($this->limit),

[190] Fix | Delete

'top_countries_blocked' => $this->getTopCountriesBlocked($this->limit),

[191] Fix | Delete

'top_failed_logins' => $this->getTopFailedLogins($this->limit),

[192] Fix | Delete

'updates_needed' => $this->getUpdatesNeeded(),

[193] Fix | Delete

'microseconds' => microtime(true) - $start_time,

[194] Fix | Delete

);

[195] Fix | Delete

}

[196] Fix | Delete

[197] Fix | Delete

public function getBlockedCount($maxAgeDays = null, $grouping = null) {

[198] Fix | Delete

$maxAgeDays = (int) $maxAgeDays;

[199] Fix | Delete

if ($maxAgeDays <= 0) {

[200] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 7 day)) / 86400)';

[201] Fix | Delete

switch (wfConfig::get('email_summary_interval', 'weekly')) {

[202] Fix | Delete

case 'daily':

[203] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 day)) / 86400)';

[204] Fix | Delete

break;

[205] Fix | Delete

case 'monthly':

[206] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 month)) / 86400)';

[207] Fix | Delete

break;

[208] Fix | Delete

}

[209] Fix | Delete

}

[210] Fix | Delete

else {

[211] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval ' . $maxAgeDays . ' day)) / 86400)';

[212] Fix | Delete

}

[213] Fix | Delete

[214] Fix | Delete

//Possible values for blockType: throttle, manual, brute, fakegoogle, badpost, country, advanced, blacklist, waf

[215] Fix | Delete

$groupingWHERE = '';

[216] Fix | Delete

switch ($grouping) {

[217] Fix | Delete

case self::BLOCK_TYPE_COMPLEX:

[218] Fix | Delete

$groupingWHERE = ' AND blockType IN ("fakegoogle", "badpost", "country", "advanced", "waf")';

[219] Fix | Delete

break;

[220] Fix | Delete

case self::BLOCK_TYPE_BRUTE_FORCE:

[221] Fix | Delete

$groupingWHERE = ' AND blockType IN ("throttle", "brute")';

[222] Fix | Delete

break;

[223] Fix | Delete

case self::BLOCK_TYPE_BLACKLIST:

[224] Fix | Delete

$groupingWHERE = ' AND blockType IN ("blacklist", "manual")';

[225] Fix | Delete

break;

[226] Fix | Delete

}

[227] Fix | Delete

[228] Fix | Delete

$table_wfBlockedIPLog = wfDB::networkTable('wfBlockedIPLog');

[229] Fix | Delete

$count = $this->db->get_var(<<<SQL

[230] Fix | Delete

SELECT SUM(blockCount) as blockCount

[231] Fix | Delete

FROM {$table_wfBlockedIPLog}

[232] Fix | Delete

WHERE unixday >= {$interval}{$groupingWHERE}

[233] Fix | Delete

SQL

[234] Fix | Delete

);

[235] Fix | Delete

return $count;

[236] Fix | Delete

}

[237] Fix | Delete

[238] Fix | Delete

/**

[239] Fix | Delete

* @param int $limit

[240] Fix | Delete

* @return mixed

[241] Fix | Delete

[242] Fix | Delete

public function getTopIPsBlocked($limit = 10, $maxAgeDays = null) {

[243] Fix | Delete

$maxAgeDays = (int) $maxAgeDays;

[244] Fix | Delete

if ($maxAgeDays <= 0) {

[245] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 7 day)) / 86400)';

[246] Fix | Delete

switch (wfConfig::get('email_summary_interval', 'weekly')) {

[247] Fix | Delete

case 'daily':

[248] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 day)) / 86400)';

[249] Fix | Delete

break;

[250] Fix | Delete

case 'monthly':

[251] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 month)) / 86400)';

[252] Fix | Delete

break;

[253] Fix | Delete

}

[254] Fix | Delete

}

[255] Fix | Delete

else {

[256] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval ' . $maxAgeDays . ' day)) / 86400)';

[257] Fix | Delete

}

[258] Fix | Delete

[259] Fix | Delete

$table_wfBlockedIPLog = wfDB::networkTable('wfBlockedIPLog');

[260] Fix | Delete

$query=<<<SQL

[261] Fix | Delete

SELECT IP, countryCode, unixday, blockType,

[262] Fix | Delete

SUM(blockCount) as blockCount

[263] Fix | Delete

FROM {$table_wfBlockedIPLog}

[264] Fix | Delete

WHERE unixday >= {$interval}

[265] Fix | Delete

GROUP BY IP

[266] Fix | Delete

ORDER BY blockCount DESC

[267] Fix | Delete

LIMIT %d

[268] Fix | Delete

SQL;

[269] Fix | Delete

$results = $this->db->get_results($this->db->prepare($query, $limit));

[270] Fix | Delete

if ($results) {

[271] Fix | Delete

foreach ($results as &$row) {

[272] Fix | Delete

$row->countryName = $this->getCountryNameByCode($row->countryCode);

[273] Fix | Delete

}

[274] Fix | Delete

}

[275] Fix | Delete

return $results;

[276] Fix | Delete

}

[277] Fix | Delete

[278] Fix | Delete

/**

[279] Fix | Delete

* @param int $limit

[280] Fix | Delete

* @return array

[281] Fix | Delete

[282] Fix | Delete

public function getTopCountriesBlocked($limit = 10, $maxAgeDays = null) {

[283] Fix | Delete

$maxAgeDays = (int) $maxAgeDays;

[284] Fix | Delete

if ($maxAgeDays <= 0) {

[285] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 7 day)) / 86400)';

[286] Fix | Delete

switch (wfConfig::get('email_summary_interval', 'weekly')) {

[287] Fix | Delete

case 'daily':

[288] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 day)) / 86400)';

[289] Fix | Delete

break;

[290] Fix | Delete

case 'monthly':

[291] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 month)) / 86400)';

[292] Fix | Delete

break;

[293] Fix | Delete

}

[294] Fix | Delete

}

[295] Fix | Delete

else {

[296] Fix | Delete

$interval = 'FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval ' . $maxAgeDays . ' day)) / 86400)';

[297] Fix | Delete

}

[298] Fix | Delete

[299] Fix | Delete

$table_wfBlockedIPLog = wfDB::networkTable('wfBlockedIPLog');

[300] Fix | Delete

$query=<<<SQL

[301] Fix | Delete

SELECT *, COUNT(IP) as totalIPs, SUM(ipBlockCount) as totalBlockCount

[302] Fix | Delete

FROM (SELECT *, SUM(blockCount) AS ipBlockCount FROM {$table_wfBlockedIPLog} WHERE unixday >= {$interval} GROUP BY IP) t

[303] Fix | Delete

GROUP BY countryCode

[304] Fix | Delete

ORDER BY totalBlockCount DESC

[305] Fix | Delete

LIMIT %d

[306] Fix | Delete

SQL;

[307] Fix | Delete

$results = $this->db->get_results($this->db->prepare($query, $limit));

[308] Fix | Delete

if ($results) {

[309] Fix | Delete

foreach ($results as &$row) {

[310] Fix | Delete

$row->countryName = $this->getCountryNameByCode($row->countryCode);

[311] Fix | Delete

}

[312] Fix | Delete

}

[313] Fix | Delete

return $results;

[314] Fix | Delete

}

[315] Fix | Delete

[316] Fix | Delete

/**

[317] Fix | Delete

* @param int $limit

[318] Fix | Delete

* @return mixed

[319] Fix | Delete

[320] Fix | Delete

public function getTopFailedLogins($limit = 10) {

[321] Fix | Delete

$interval = 'UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 7 day))';

[322] Fix | Delete

switch (wfConfig::get('email_summary_interval', 'weekly')) {

[323] Fix | Delete

case 'daily':

[324] Fix | Delete

$interval = 'UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 day))';

[325] Fix | Delete

break;

[326] Fix | Delete

case 'monthly':

[327] Fix | Delete

$interval = 'UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 month))';

[328] Fix | Delete

break;

[329] Fix | Delete

}

[330] Fix | Delete

[331] Fix | Delete

$table_wfLogins = wfDB::networkTable('wfLogins');

[332] Fix | Delete

$failedLogins = $this->db->get_results($this->db->prepare(<<<SQL

[333] Fix | Delete

SELECT wfl.*,

[334] Fix | Delete

sum(wfl.fail) as fail_count

[335] Fix | Delete

FROM {$table_wfLogins} wfl

[336] Fix | Delete

WHERE wfl.fail = 1

[337] Fix | Delete

AND wfl.ctime > $interval

[338] Fix | Delete

GROUP BY wfl.username

[339] Fix | Delete

ORDER BY fail_count DESC

[340] Fix | Delete

LIMIT %d

[341] Fix | Delete

SQL

[342] Fix | Delete

, $limit));

[343] Fix | Delete

[344] Fix | Delete

foreach ($failedLogins as &$login) {

[345] Fix | Delete

$exists = $this->db->get_var($this->db->prepare(<<<SQL

[346] Fix | Delete

SELECT !ISNULL(ID) FROM {$this->db->users} WHERE user_login = '%s' OR user_email = '%s'

[347] Fix | Delete

SQL

[348] Fix | Delete

, $login->username, $login->username));

[349] Fix | Delete

$login->is_valid_user = $exists;

[350] Fix | Delete

}

[351] Fix | Delete

[352] Fix | Delete

return $failedLogins;

[353] Fix | Delete

}

[354] Fix | Delete

[355] Fix | Delete

/**

[356] Fix | Delete

* Returns any updates needs or false if everything is up to date.

[357] Fix | Delete

[358] Fix | Delete

* @return array|bool

[359] Fix | Delete

[360] Fix | Delete

public function getUpdatesNeeded($useCachedValued = true) {

[361] Fix | Delete

$update_check = new wfUpdateCheck();

[362] Fix | Delete

$needs_update = $update_check->checkAllUpdates($useCachedValued)

[363] Fix | Delete

->needsAnyUpdates();

[364] Fix | Delete

if ($needs_update) {

[365] Fix | Delete

return array(

[366] Fix | Delete

'core' => $update_check->getCoreUpdateVersion(),

[367] Fix | Delete

'plugins' => $update_check->getPluginUpdates(),

[368] Fix | Delete

'themes' => $update_check->getThemeUpdates(),

[369] Fix | Delete

);

[370] Fix | Delete

}

[371] Fix | Delete

return false;

[372] Fix | Delete

}

[373] Fix | Delete

[374] Fix | Delete

/**

[375] Fix | Delete

* Returns list of firewall activity up to $limit number of entries.

[376] Fix | Delete

[377] Fix | Delete

* @param int $limit Max events to return in results

[378] Fix | Delete

* @param int $remainder

[379] Fix | Delete

* @return array

[380] Fix | Delete

[381] Fix | Delete

public function getRecentFirewallActivity($limit, &$remainder) {

[382] Fix | Delete

$dateRange = wfActivityReport::getReportDateRange();

[383] Fix | Delete

$recent_firewall_activity = new wfRecentFirewallActivity(null, max(604800, $dateRange[1] - $dateRange[0]));

[384] Fix | Delete

$recent_firewall_activity->run();

[385] Fix | Delete

return $recent_firewall_activity->mostRecentActivity($limit, $remainder);

[386] Fix | Delete

}

[387] Fix | Delete

[388] Fix | Delete

/**

[389] Fix | Delete

* Returns list of files modified within given timeframe.

[390] Fix | Delete

[391] Fix | Delete

* @todo Add option to configure the regex used to filter files allowed in this list.

[392] Fix | Delete

* @todo Add option to exclude directories (such as cache directories).

[393] Fix | Delete

[394] Fix | Delete

* @param string $directory Search for files within this directory

[395] Fix | Delete

* @param int $time_range One week

[396] Fix | Delete

* @param int $limit Max files to return in results

[397] Fix | Delete

* @param int $directory_limit Hard limit for number of files to search within a directory.

[398] Fix | Delete

* @return array

[399] Fix | Delete

[400] Fix | Delete

public function getRecentFilesModified($limit = 300, $directory = ABSPATH, $time_range = 604800, $directory_limit = 20000) {

[401] Fix | Delete

$recently_modified = new wfRecentlyModifiedFiles($directory);

[402] Fix | Delete

$recently_modified->run();

[403] Fix | Delete

return $recently_modified->mostRecentFiles($limit);

[404] Fix | Delete

}

[405] Fix | Delete

[406] Fix | Delete

/**

[407] Fix | Delete

* Remove entries older than a month in the IP log.

[408] Fix | Delete

[409] Fix | Delete

public function rotateIPLog() {

[410] Fix | Delete

$table_wfBlockedIPLog = wfDB::networkTable('wfBlockedIPLog');

[411] Fix | Delete

$this->db->query(<<<SQL

[412] Fix | Delete

DELETE FROM {$table_wfBlockedIPLog}

[413] Fix | Delete

WHERE unixday < FLOOR(UNIX_TIMESTAMP(DATE_SUB(NOW(), interval 1 month)) / 86400)

[414] Fix | Delete

SQL

[415] Fix | Delete

);

[416] Fix | Delete

}

[417] Fix | Delete

[418] Fix | Delete

/**

[419] Fix | Delete

* @param mixed $ip_address

[420] Fix | Delete

* @param int|null $unixday

[421] Fix | Delete

[422] Fix | Delete

public static function logBlockedIP($ip_address, $unixday = null, $type = null) {

[423] Fix | Delete

/** @var wpdb $wpdb */

[424] Fix | Delete

global $wpdb;

[425] Fix | Delete

[426] Fix | Delete

//Possible values for $type: throttle, manual, brute, fakegoogle, badpost, country, advanced, blacklist, waf

[427] Fix | Delete

[428] Fix | Delete

if (wfUtils::isValidIP($ip_address)) {

[429] Fix | Delete

$ip_bin = wfUtils::inet_pton($ip_address);

[430] Fix | Delete

} else {

[431] Fix | Delete

$ip_bin = $ip_address;

[432] Fix | Delete

$ip_address = wfUtils::inet_ntop($ip_bin);

[433] Fix | Delete

}

[434] Fix | Delete

[435] Fix | Delete

$blocked_table = wfDB::networkTable('wfBlockedIPLog');

[436] Fix | Delete

[437] Fix | Delete

$unixday_insert = 'FLOOR(UNIX_TIMESTAMP() / 86400)';

[438] Fix | Delete

if (is_int($unixday)) {

[439] Fix | Delete

$unixday_insert = absint($unixday);

[440] Fix | Delete

}

[441] Fix | Delete

[442] Fix | Delete

if ($type === null) {

[443] Fix | Delete

$type = 'generic';

[444] Fix | Delete

}

[445] Fix | Delete

[446] Fix | Delete

$country = wfUtils::IP2Country($ip_address);

[447] Fix | Delete

[448] Fix | Delete

$ipHex = wfDB::binaryValueToSQLHex($ip_bin);

[449] Fix | Delete

$wpdb->query($wpdb->prepare(<<<SQL

[450] Fix | Delete

INSERT INTO $blocked_table (IP, countryCode, blockCount, unixday, blockType)

[451] Fix | Delete

VALUES ({$ipHex}, %s, 1, $unixday_insert, %s)

[452] Fix | Delete

ON DUPLICATE KEY UPDATE blockCount = blockCount + 1

[453] Fix | Delete

SQL

[454] Fix | Delete

, $country, $type));

[455] Fix | Delete

}

[456] Fix | Delete

[457] Fix | Delete

/**

[458] Fix | Delete

* @param $code

[459] Fix | Delete

* @return string

[460] Fix | Delete

[461] Fix | Delete

public function getCountryNameByCode($code) {

[462] Fix | Delete

static $wfBulkCountries;

[463] Fix | Delete

if (!isset($wfBulkCountries)) {

[464] Fix | Delete

include(dirname(__FILE__) . '/wfBulkCountries.php');

[465] Fix | Delete

}

[466] Fix | Delete

return array_key_exists($code, $wfBulkCountries) ? $wfBulkCountries[$code] : "";

[467] Fix | Delete

}

[468] Fix | Delete

[469] Fix | Delete

/**

[470] Fix | Delete

* @return wfActivityReportView

[471] Fix | Delete

[472] Fix | Delete

public function toView() {

[473] Fix | Delete

return new wfActivityReportView('reports/activity-report', $this->getFullReport() + array(

[474] Fix | Delete

'limit' => $this->getLimit(),

[475] Fix | Delete

));

[476] Fix | Delete

}

[477] Fix | Delete

[478] Fix | Delete

/**

[479] Fix | Delete

* @return wfActivityReportView

[480] Fix | Delete

[481] Fix | Delete

public function toWidgetView() {

[482] Fix | Delete

return new wfActivityReportView('reports/activity-report', $this->getWidgetReport() + array(

[483] Fix | Delete

'limit' => $this->getLimit(),

[484] Fix | Delete

));

[485] Fix | Delete

}

[486] Fix | Delete

[487] Fix | Delete

/**

[488] Fix | Delete

* @return wfActivityReportView

[489] Fix | Delete

[490] Fix | Delete

public function toEmailView() {

[491] Fix | Delete

return new wfActivityReportView('reports/activity-report-email-inline', $this->getFullReport());

[492] Fix | Delete

}

[493] Fix | Delete

[494] Fix | Delete

/**

[495] Fix | Delete

* @param $email_addresses string|array

[496] Fix | Delete

* @return bool

[497] Fix | Delete

[498] Fix | Delete

public function sendReportViaEmail($email_addresses) {

[499] Fix | Delete