List of all SQL mentioned in the code..
Value | Count | File:Line |
---|---|---|
'Update Overview' | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view($extra_view) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE 1 ' . $where . ' ORDER BY ' . $orderBy | 1 |
|
'SELECT value FROM ' . $this->table_name('wp_options') . ' WHERE wpid = %d AND name = "' . $this->escape($option) . '"' | 1 |
|
'SELECT name, value FROM ' . $this->table_name('wp_options') . ' WHERE wpid = %d AND name IN (' . $options_name . ')' | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view( ) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE 1 ' . $where | 1 |
|
'SELECT wp.* FROM ' . $this->table_name('wp') . ' wp WHERE wp.disable_status_check <> 1 AND ( ( wp.status_check_interval = 0 AND wp.offline_checks_last < ' . intval($last_check) . ' ) OR ( wp.status_check_interval <> 0 AND ( wp.offline_checks_last + wp.status_check_interval * 60 < UNIX_TIMESTAMP() ) ) )' . $where . ' LIMIT 0, ' . intval($count) | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.*, GROUP_CONCAT(gr.name ORDER BY gr.name SEPARATOR ", ") as wpgroups FROM ' . $this->table_name('wp') . ' wp LEFT JOIN ' . $this->table_name('wp_group') . ' wpgr ON wp.id = wpgr.wpid LEFT JOIN ' . $this->table_name('group') . ' gr ON wpgr.groupid = gr.id JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view( ) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE wp.userid = ' . $userid . " $where GROUP BY wp.id ORDER BY " . $orderBy | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view( ) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE wp.userid = ' . $userid . " $where ORDER BY " . $orderBy | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.*, GROUP_CONCAT(gr.name ORDER BY gr.name SEPARATOR ", ") as wpgroups FROM ' . $this->table_name('wp') . ' wp LEFT JOIN ' . $this->table_name('wp_group') . ' wpgr ON wp.id = wpgr.wpid LEFT JOIN ' . $this->table_name('group') . ' gr ON wpgr.groupid = gr.id JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view($extra_view) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE 1 ' . $where . ' GROUP BY wp.id ORDER BY ' . $orderBy | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.*, GROUP_CONCAT(gr.name ORDER BY gr.name SEPARATOR ", ") as wpgroups FROM ' . $this->table_name('wp') . ' wp ' . $join_group . ' LEFT JOIN ' . $this->table_name('wp_group') . ' wpgr ON wp.id = wpgr.wpid LEFT JOIN ' . $this->table_name('group') . ' gr ON wpgr.groupid = gr.id JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view($extra_view) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE 1 ' . $where . $where_group . ' GROUP BY wp.id ' . $orderBy | 1 |
|
'SELECT wp.*,wp_sync.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid WHERE (wp_sync.sync_errors IS NOT NULL) AND (wp_sync.sync_errors <> "") ' . $where | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp ' . $join_group . ' JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view($extra_view) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE 1 ' . $where . $where_group . $orderBy | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.*, GROUP_CONCAT(gr.name ORDER BY gr.name SEPARATOR ", ") as wpgroups FROM ' . $this->table_name('wp') . ' wp LEFT JOIN ' . $this->table_name('wp_group') . ' wpgr ON wp.id = wpgr.wpid LEFT JOIN ' . $this->table_name('group') . ' gr ON wpgr.groupid = gr.id JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view($extra_view) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE wp.id = ' . $id . $where . ' GROUP BY wp.id' | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view($extra_view) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE id = ' . $id . $where | 1 |
|
'SELECT * FROM ' . $this->table_name('wp') . ' WHERE id IN (' . implode(',', $ids) . ')' . (null != $userId ? ' AND userid = ' . $userId : '') . $where | 1 |
|
'SELECT * FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_group') . ' wpgroup ON wp.id = wpgroup.wpid WHERE wpgroup.groupid IN (' . implode(',', $ids) . ') ' . (null != $userId ? ' AND wp.userid = ' . $userId : '') | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.*, GROUP_CONCAT(gr.name ORDER BY gr.name SEPARATOR ", ") as wpgroups FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_group') . ' wpgroup ON wp.id = wpgroup.wpid LEFT JOIN ' . $this->table_name('wp_group') . ' wpgr ON wp.id = wpgr.wpid LEFT JOIN ' . $this->table_name('group') . ' gr ON wpgr.groupid = gr.id JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view( ) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE wpgroup.groupid = ' . $id . ' ' . (null == $where ? '' : ' AND ' . $where) . $where_allowed . $where_search . ' GROUP BY wp.id ORDER BY ' . $orderBy | 1 |
|
'SELECT wp.*,wp_sync.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_group') . ' wpgroup ON wp.id = wpgroup.wpid JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid WHERE wpgroup.groupid = ' . $id . ' ' . $where_allowed . $where_search . (null == $where ? '' : ' AND ' . $where) . ' ORDER BY ' . $orderBy | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp INNER JOIN ' . $this->table_name('wp_group') . ' wpgroup ON wp.id = wpgroup.wpid JOIN ' . $this->table_name('group') . ' g ON wpgroup.groupid = g.id JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view( ) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE g.name="' . $this->escape($groupname) . '"' | 1 |
|
'SELECT COUNT(wp.id) FROM ' . $this->table_name('wp') . ' wp WHERE 1 ' . $where | 1 |
|
'DELETE FROM ' . $this->table_name('client_report_format') . ' WHERE id=%d ' | 1 |
|
'DELETE FROM ' . $this->table_name('wp') . ' WHERE id=%d' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report') . ' rp ' . 'LEFT JOIN ' . $this->table_name('client_report_client') . ' c ' . ' ON rp.client_id = c.clientid ' . ' WHERE 1 = 1 ' . $_order_by | 1 |
|
'UPDATE ' . $this->table_name('client_report_site_token') . 'SET `token_value` = %s WHERE `token_id` = %d AND site_url = %s' | 1 |
|
'DELETE FROM ' . $this->table_name('client_report_site_token') . ' WHERE site_url = %s ' | 1 |
|
'DELETE FROM ' . $this->table_name('client_report_token') . ' WHERE id=%d ' | 1 |
|
'SELECT rp.*, c.* FROM ' . $this->table_name('client_report') . ' rp LEFT JOIN ' . $this->table_name('client_report_client') . ' c ON rp.client_id = c.clientid WHERE `id`=%d ' . $_order_by | 1 |
|
'SELECT rp.*, c.* FROM ' . $this->table_name('client_report') . ' rp LEFT JOIN ' . $this->table_name('client_report_client') . ' c ON rp.client_id = c.clientid WHERE `client_id` = %d ' . $_order_by | 1 |
|
'SELECT rp.*, c.* FROM ' . $this->table_name('client_report') . ' rp LEFT JOIN ' . $this->table_name('client_report_client') . ' c ON rp.client_id = c.clientid WHERE `selected_site` = %d ' . $_order_by | 1 |
|
'SELECT rp.*, c.* FROM ' . $this->table_name('client_report') . ' rp LEFT JOIN ' . $this->table_name('client_report_client') . ' c ON rp.client_id = c.clientid WHERE `title` = %s ' . $_order_by | 1 |
|
'SELECT rp.*, c.* FROM ' . $this->table_name('client_report') . ' rp ' . ' LEFT JOIN ' . $this->table_name('client_report_client') . ' c ' . ' ON rp.client_id = c.clientid ' . ' WHERE rp.is_archived = 0 AND rp.scheduled = 0' . ' AND rp.date_from <= ' . (time( ) - 3600 * 24 * 30) . ' ' . ' AND rp.selected_site != 0 AND c.email IS NOT NULL ' . '' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_format') . ' WHERE `title` =%s AND type = %s' | 1 |
|
'SELECT rp.*, c.* FROM ' . $this->table_name('client_report') . ' rp ' . ' LEFT JOIN ' . $this->table_name('client_report_client') . ' c ' . ' ON rp.client_id = c.clientid ' . " WHERE rp.recurring_schedule != '' AND rp.scheduled = 1" | 1 |
|
'DELETE FROM ' . $this->table_name('client_report') . ' WHERE id=%d ' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_client') . ' WHERE 1 = 1 ORDER BY client ASC' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_client') . ' WHERE `clientid` =%d ' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_client') . ' WHERE `client` = %s ' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_client') . ' WHERE `email` = %s ' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_format') . ' WHERE `type` =%s ORDER BY title' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_format') . ' WHERE `id` =%d ' | 1 |
|
'SELECT ip FROM ' . $this->table_name('request_log') . ' WHERE wpid = %d' | 1 |
|
'DELETE FROM ' . $this->table_name('wp_sync') . ' WHERE wpid=%d' | 1 |
|
'SELECT st.* FROM ' . $this->table_name('client_report_site_token') . ' st WHERE st.token_id = %d' | 1 |
|
'select count(id) from ' . $this->table_name('request_log') . ' where micro_timestamp_stop < micro_timestamp_start and ip = "' . esc_sql($ip) . '"' | 1 |
|
'SELECT * FROM ' . $this->table_name('group') . ' WHERE id= %d' | 1 |
|
'SELECT * FROM ' . $this->table_name('group') . ' gr JOIN ' . $this->table_name('wp_group') . ' wpgr ON gr.id = wpgr.groupid WHERE wpgr.wpid = %d ORDER BY name' | 1 |
|
'SELECT gr.*, COUNT(DISTINCT(wpgr.wpid)) as nrsites FROM ' . $this->table_name('group') . ' gr LEFT JOIN ' . $this->table_name('wp_group') . ' wpgr ON gr.id = wpgr.groupid WHERE 1 ' . $where . ' GROUP BY gr.id ORDER BY gr.name' | 1 |
|
'SELECT DISTINCT(g.id), g.name, count(wp.wpid) FROM ' . $this->table_name('group') . ' g JOIN ' . $this->table_name('wp_group') . ' wp ON g.id = wp.groupid JOIN ' . $this->table_name('wp') . ' wpsite ON wp.wpid = wpsite.id JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.wpid = wp_sync.wpid ' . $where . ' GROUP BY g.id HAVING count(wp.wpid) > 0 ORDER BY g.name' | 1 |
|
'SELECT id FROM ' . $this->table_name('request_log') . ' WHERE wpid = %d ' | 1 |
|
'UPDATE ' . $this->table_name('request_log') . ' SET micro_timestamp_stop = micro_timestamp_start WHERE micro_timestamp_stop < micro_timestamp_start and ' . microtime(true) . ' - micro_timestamp_start > 7' | 1 |
|
'select count(id) from ' . $this->table_name('request_log') . ' where micro_timestamp_stop < micro_timestamp_start' | 1 |
|
'select micro_timestamp_start from ' . $this->table_name('request_log') . ' order by micro_timestamp_start desc limit 1' | 1 |
|
'Select SSL Version. If you are not sure, select "Auto Detect".' | 1 |
|
'SELECT micro_timestamp_start FROM ' . $this->table_name('request_log') . ' WHERE ip = %s order by micro_timestamp_start desc limit 1' | 1 |
|
'DELETE FROM ' . $this->table_name('wp_group') . ' WHERE groupid=' . $groupId | 1 |
|
'DELETE FROM ' . $this->table_name('group') . ' WHERE id=%d' | 1 |
|
'DELETE FROM ' . $this->table_name('wp_group') . ' WHERE groupid=%d' | 1 |
|
'UPDATE ' . $this->table_name('wp') . ' SET note= %s, note_lastupdate = %d WHERE id=%d' | 1 |
|
'UPDATE ' . $this->table_name('group') . ' SET name=%s WHERE id=%d' | 1 |
|
'SELECT user_email FROM ' . $this->table_name('users') . ' WHERE userid = %d' | 1 |
|
'SELECT user_email FROM ' . $this->wpdb->prefix . 'users WHERE id = %d' | 1 |
|
'SELECT * FROM ' . $this->table_name('group') . ' WHERE 1 ' . $where . ' AND name= %s' | 1 |
|
'Update Translations' | 1 |
|
'DELETE FROM ' . $this->table_name('wp_options') . ' WHERE wpid=%d' | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view($extra_view) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE wp.disable_status_check <> 1 AND wp.offline_check_result <> 1 AND wp.offline_check_result <> 0 AND wp.http_code_noticed = 0' . $where | 1 |
|
'DELETE FROM ' . $this->table_name('wp_status') . ' WHERE wpid=%d' | 1 |
|
'UPDATE ' . $this->table_name('wp') . ' SET url="' . $this->escape($url) . '", name="' . $this->escape(wp_strip_all_tags($name)) . '", adminname="' . $this->escape($siteadmin) . '",pluginDir="' . $this->escape($pluginDir) . '",maximumFileDescriptorsOverride = ' . ($maximumFileDescriptorsOverride ? 1 : 0) . ',maximumFileDescriptorsAuto= ' . ($maximumFileDescriptorsAuto ? 1 : 0) . ',maximumFileDescriptors = ' . $maximumFileDescriptors . ', verify_certificate="' . intval($verifyCertificate) . '", ssl_version="' . intval($sslVersion) . '", wpe="' . intval($wpe) . '", uniqueId="' . $this->escape($uniqueId) . '", http_user="' . $this->escape($http_user) . '", http_pass="' . $this->escape($http_pass) . '", disable_status_check="' . $this->escape($disableChecking) . '", status_check_interval="' . $this->escape($checkInterval) . '", disable_health_check="' . $this->escape($disableHealthChecking) . '", health_threshold="' . $this->escape($healthThreshold) . '" WHERE id=%d' | 1 |
|
'UPDATE ' . $this->table_name('wp_settings_backup') . ' SET archiveFormat = "' . $this->escape($archiveFormat) . '" WHERE wpid=%d' | 1 |
|
'SELECT count(wp.id) FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid WHERE ( wp_sync.dtsAutomaticSyncStart = 0 OR wp_sync.dtsAutomaticSyncStart < ' . intval($lasttime_start) . ')' . $where | 1 |
|
'SELECT count(wp.id) FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid WHERE ((wp_sync.dtsAutomaticSync < wp_sync.dtsAutomaticSyncStart) OR (wp_sync.dtsAutomaticSyncStart = 0)) ' . $where | 1 |
|
'SELECT MAX(wp_sync.dtsAutomaticSync) FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid' | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view( ) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE ( wp_sync.dtsAutomaticSync = 0 OR wp_sync.dtsAutomaticSyncStart = 0 OR wp_sync.dtsAutomaticSyncStart < ' . intval($lasttime_start) . ') ' . $where . ' LIMIT 0,' . $limit | 1 |
|
'SELECT * FROM ' . $this->table_name('wp') . ' WHERE (statsUpdate = 0 OR ' . time( ) . ' - statsUpdate >= ' . (60 * 60 * 24 * 7) . ')' . $where . ' ORDER BY statsUpdate ASC' | 1 |
|
'SELECT wp.*,wp_sync.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->table_name('wp_sync') . ' wp_sync ON wp.id = wp_sync.wpid JOIN ' . $this->get_option_view($extra_view) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE wp.disable_health_check <> 1 AND wp.offline_check_result = 1 AND ( ' . $where_global_threshold . ' OR' . $where_site_threshold . ' ) AND wp_sync.health_site_noticed = 0 ' . $where | 1 |
|
'Update WordPress' | 1 |
|
'SELECT wp.*,wp_optionview.* FROM ' . $this->table_name('wp') . ' wp JOIN ' . $this->get_option_view($extra_view) . ' wp_optionview ON wp.id = wp_optionview.wpid WHERE wp.disable_status_check <> 1 AND wp.offline_check_result = -1' . $where | 1 |
|
'update WordPress' | 1 |
|
'update translations' | 1 |
|
'Delete Version 3 Extensions (extensions older than version 4) from your MainWP Dashboard' | 1 |
|
'Update Notification Enabled' | 1 |
|
'Update available' | 1 |
|
'Update Plugins' | 1 |
|
'Update Themes' | 1 |
|
' SELECT st.*, t.token_name FROM ' . $this->table_name('client_report_site_token') . ' st , ' . $this->table_name('client_report_token') . ' t WHERE st.site_url = %s AND st.token_id = t.id' | 1 |
|
'DELETE FROM ' . $this->table_name('client_report_site_token') . ' WHERE token_id = %d ' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_token') . ' WHERE 1 = 1 ORDER BY type DESC, token_name ASC' | 1 |
|
'Update Password' | 1 |
|
'SELECT wpid FROM ' . $this->table_name('wp_sync') . ' WHERE wpid = %d' | 1 |
|
'SELECT id,' . $wpSyncColumn . ' FROM ' . $this->table_name('wp') | 1 |
|
"SHOW TABLES LIKE '" . $this->table_name('wp') . "'" | 1 |
|
'DELETE FROM ' . $this->table_name('wp_status') . ' WHERE event_timestamp < %d ' | 1 |
|
"SELECT `site_url` FROM `{$wpdb->prefix}mainwp_client_report_site_token` WHERE token_id= %d ORDER BY `id` DESC" | 1 |
|
'Update all sites' | 1 |
|
"SELECT `site_url` FROM `{$wpdb->prefix}mainwp_client_report_site_token` WHERE token_id= %d AND token_value=%s ORDER BY `id` DESC" | 1 |
|
"SELECT * FROM {$wpdb->prefix}mainwp_client_report_site_token WHERE token_id=%d AND token_value=%s AND site_url=%s" | 1 |
|
"SELECT `url` FROM {$wpdb->prefix}mainwp_wp WHERE id=%d" | 1 |
|
'Select SSL version. If you are not sure, select "Auto Detect".' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_site_token') . ' WHERE site_url =%s AND token_id = %d' | 1 |
|
'Update All Translations' | 1 |
|
'Show Posts' | 1 |
|
'Select post type' | 1 |
|
'Select categories' | 1 |
|
"SHOW VARIABLES LIKE 'sql_mode'" | 1 |
|
'Show Pages' | 1 |
|
'Update all sites in the group' | 1 |
|
'Update All Groups' | 1 |
|
"SELECT DISTINCT meta_key FROM $wpdb->postmeta WHERE meta_key NOT BETWEEN '_' AND '_z' HAVING meta_key NOT LIKE %s ORDER BY meta_key LIMIT %d" | 1 |
|
'Show updates per ' | 1 |
|
'Select Categories' | 1 |
|
'Show Users' | 1 |
|
'Select role' | 1 |
|
'Show favicons' | 1 |
|
'Select response codes that you want your MainWP Dashboard to ignore.' | 1 |
|
'Update confirmations' | 1 |
|
'Show WordPress language updates' | 1 |
|
'SELECT id,' . $optionColumn . ' FROM ' . $this->table_name('wp') | 1 |
|
'Select if you want to show sidebar with option on left or right.' | 1 |
|
'SELECT * FROM ' . $this->table_name('wp_backup') . ' WHERE id= %d ' | 1 |
|
'SHOW VARIABLES LIKE "version"' | 1 |
|
'delete sites' | 1 |
|
'SELECT * FROM ' . $this->table_name('wp_backup') . ' WHERE paused = 0 AND schedule="monthly" AND ' . time( ) . ' - last_run >= ' . (60 * 60 * 24 * 30) | 1 |
|
'SELECT * FROM ' . $this->table_name('wp_backup') . ' WHERE paused = 0 AND schedule="weekly" AND ' . time( ) . ' - last_run >= ' . (60 * 60 * 24 * 7) | 1 |
|
'Update Schedule Backup' | 1 |
|
'SELECT * FROM ' . $this->table_name('wp_backup') . ' WHERE paused = 0 AND schedule="daily" AND ' . time( ) . ' - last_run >= ' . (60 * 60 * 24) | 1 |
|
'SELECT * FROM ' . $this->table_name('wp_backup') . ' WHERE paused = 0 AND completed < last_run' | 1 |
|
'SELECT * FROM ' . $this->table_name('wp_backup') . ' WHERE ' . (null == $userid ? '' : 'userid= ' . $userid . ' AND ') . ' template = 0 ' . (null != $orderBy ? 'ORDER BY ' . $orderBy : '') | 1 |
|
'DELETE FROM ' . $this->table_name('wp_backup') . ' WHERE id = %d' | 1 |
|
'SELECT * FROM ' . $this->table_name('wp_backup_progress') . ' WHERE wp_id = %d AND dtsFetched > %d ' | 1 |
|
'SELECT * FROM ' . $this->table_name('wp_backup_progress') . ' WHERE task_id= %d AND wp_id = %d ' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_token') . ' WHERE `id`=%d ' | 1 |
|
'SELECT * FROM ' . $this->table_name('wp_settings_backup') . ' WHERE wpid = %d ' | 1 |
|
"SELECT option_name, option_value FROM $wpdb->options WHERE option_name in (" | 1 |
|
'Show Usersnap button' | 1 |
|
'Select widgets that you want to hide in the MainWP Overview page.' | 1 |
|
'Show widgets in 3 columns' | 1 |
|
'Show widgets in 2 columns' | 1 |
|
'Show All Updates' | 1 |
|
'SELECT * FROM ' . $this->table_name('client_report_token') . ' WHERE `token_name` = %s ' | 1 |
|
'Select all websites.' | 1 |
|
'Update all plugins.' | 1 |
|
'Update all themes.' | 1 |
|
'Select primary backup system' | 1 |
|
'Delete the ' | 2 |
|
'Update All Plugins' | 2 |
|
'Show Themes' | 2 |
|
'Select actions' | 2 |
|
'Update Everything' | 2 |
|
'Update all translations' | 2 |
|
'SELECT * FROM ' . $this->table_name('group') . ' WHERE ' . $where . ' ORDER BY name' | 2 |
|
'Update WordPress Core files on all child sites.' | 2 |
|
'Update All Themes' | 2 |
|
'Show Plugins' | 2 |
|
'Update Details' | 2 |
|
'Update failed' | 2 |
|
'update themes' | 2 |
|
'update plugins' | 2 |
|
'Delete Template' | 2 |
|
'Select action' | 2 |
|
'SELECT name FROM ' . $this->table_name('wp_options') . ' WHERE wpid = %d AND name = "' . $this->escape($option) . '"' | 2 |
|
'Show Shortcuts' | 2 |
|
'SELECT * FROM ' . $this->table_name('wp') . ' WHERE url = %s ' . $where | 2 |
|
'Show All' | 2 |
|
'Update successful' | 2 |
|
'Update settings.' | 2 |
|
"SELECT `id`,`name`,`url` FROM `{$wpdb->prefix}mainwp_wp` WHERE `url`=%s" | 2 |
|
'DELETE FROM ' . $this->table_name('wp_group') . ' WHERE wpid=%d' | 2 |
|
'Select none' | 2 |
|
'Select all' | 2 |
|
'Update Admin Password' | 2 |
|
'Select preferred checking interval.' | 2 |
|
'Update all sites.' | 4 |
|
'Select status' | 4 |
|
'Delete permanently' | 4 |
|
'SELECT * FROM ' . $this->table_name('users') . ' WHERE userid= ' . $userid | 4 |
|
'Update All Sites' | 5 |
|
'Select Sites' | 11 |
|
'Update Now' | 17 |
|
'Update All' | 19 |
|