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"); }