private static function _markScanCompleted()
{
$m = __METHOD__ . '() ';
wssLog($m . 'triggered.');
global $wpdb;
$query = $wpdb->prepare("UPDATE " . WsdPlugin::getTableName(WpsSettings::SCANS_TABLE_NAME) . " SET scanEndDate = CURRENT_TIMESTAMP(), scanResult = 1 WHERE scanId = %d", self::$_scanID);
$wpdb->query($query);
wssLog('Scan completed', array('ID' => self::$_scanID));
}
WpsOption::updateOption('WPS_REFRESH_RATE_AJAX_LT', $liveTrafficRefreshRateAjax);
return array($keepNumEntriesLiveTraffic, $liveTrafficRefreshRateAjax);
} else {
exit('Invalid request.');
}
}
// check form
if (isset($_POST['updateSettingsButton'])) {
if (isset($_POST['max_number_live_traffic']) && isset($_POST['refreshRateOption'])) {
$settings = wpsPluginValidateSettingsForm($refreshRates);
} else {
exit('Invalid request.');
}
} elseif (isset($_POST['deleteEntriesButton'])) {
global $wpdb;
$query = "TRUNCATE " . WsdPlugin::getTableName(WpsSettings::LIVE_TRAFFIC_TABLE_NAME);
$res = $wpdb->query($query);
if ($res !== false) {
WpsOption::updateOption(WpsSettings::LIVE_TRAFFIC_ENTRIES, 0);
}
$settings = wpsPluginValidateSettingsForm($refreshRates);
} else {
exit('Invalid request.');
}
}
$keepNumEntriesLiveTraffic = $settings[0];
$liveTrafficRefreshRateAjax = $settings[1];
}
if ($liveTrafficToolEnabled) {
?>
<div class="wrap wsdplugin_content">
public static function uninstall()
{
WpsOption::deleteOption(WpsSettings::LIVE_TRAFFIC_ENTRIES);
WpsOption::deleteOption('WPS_KEEP_NUM_ENTRIES_LT');
WpsOption::deleteOption('WPS_REFRESH_RATE_AJAX_LT');
WpsOption::deleteOption(WpsSettings::PLUGIN_SETTINGS_OPTION_NAME);
global $wpdb;
$wpdb->query("DROP TABLE IF EXISTS " . WsdPlugin::getTableName(WpsSettings::SCAN_TABLE_NAME));
$wpdb->query("DROP TABLE IF EXISTS " . WsdPlugin::getTableName(WpsSettings::SCANS_TABLE_NAME));
$wpdb->query("DROP TABLE IF EXISTS " . WsdPlugin::getTableName(WpsSettings::ALERTS_TABLE_NAME));
$wpdb->query("DROP TABLE IF EXISTS " . WsdPlugin::getTableName(WpsSettings::LIVE_TRAFFIC_TABLE_NAME));
}
public static final function getLastID()
{
global $wpdb;
return $wpdb->get_var("SELECT entryId FROM " . WsdPlugin::getTableName(WpsSettings::LIVE_TRAFFIC_TABLE_NAME) . " ORDER BY entryId DESC");
}
