List of all SQL mentioned in the code..
| Value | Count | File:Line |
|---|---|---|
| 'Select a template to try or build up from or if you are experienced user - start "From scratch".' | 1 |
|
| "SELECT source_path FROM {$wpdb->prefix}" . MPG_Constant::MPG_PROJECTS_TABLE . " WHERE id=%d" | 1 |
|
| "SELECT `cache_type` FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '" . $mpg_projects_table . "' AND column_name = 'cache_type'" | 1 |
|
| "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '$mpg_logs_table'" | 1 |
|
| "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '$mpg_cache_table'" | 1 |
|
| "SELECT `block_id` FROM INFORMATION_SCHEMA.COLUMNS WHERE table_name = '" . $mpg_spintax_table . "' AND column_name = 'block_id'" | 1 |
|
| "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '$mpg_spintax_table'" | 1 |
|
| "SELECT COUNT(*) FROM information_schema.tables WHERE table_schema = '$mpg_projects_table'" | 1 |
|
| "SELECT COUNT('id') FROM `$table` WHERE project_id = '$project_id'" | 1 |
|
| "SELECT `cached_string` FROM {$wpdb->prefix}" . MPG_Constant::MPG_CACHE_TABLE . " WHERE `project_id`=%d AND url=%s" | 1 |
|
| "SELECT `cache_type` FROM {$wpdb->prefix}" . MPG_Constant::MPG_PROJECTS_TABLE . " WHERE id=%d" | 1 |
|
| "SELECT id, template_id, urls_array FROM " . $wpdb->prefix . MPG_Constant::MPG_PROJECTS_TABLE | 1 |
|
| "SELECT template_id FROM " . $wpdb->prefix . MPG_Constant::MPG_PROJECTS_TABLE | 1 |
|
| 'SELECT * FROM ' . $wpdb->prefix . MPG_Constant::MPG_LOGS_TABLE . ' WHERE project_id=' . $project_id | 1 |
|
| 'SELECT `spintax_string` FROM ' . $table_name . ' WHERE `url` = "' . $requested_url . '" and `block_id` = "' . $block_id . '"' | 1 |
|
| "SELECT COUNT( DISTINCT `url` ) FROM {$wpdb->prefix}" . MPG_Constant::MPG_SPINTAX_TABLE . " WHERE `project_id` = " . $project_id | 1 |
|
| "SELECT id, template_id, cache_type FROM {$wpdb->prefix}" . MPG_Constant::MPG_PROJECTS_TABLE | 1 |
|
| 'Select the entity you wish to use as a template for the generated content. MPG will replace any shortcodes when accessing the site through generated URL accordingly to your source file.' | 1 |
|
| 'Select the type of content for your template. MPG supports all entity types in your Wordpress installation, including posts and pages.' | 1 |
|
| 'Delete template' | 1 |
|
| 'Update your template page with shortcodes from source file. Generate sitemap and upload it in addition to your regular sitemap via Google Search Console.' | 1 |
|
| 'Select header' | 1 |
|
| "SELECT * FROM {$wpdb->prefix}" . MPG_Constant::MPG_PROJECTS_TABLE . " WHERE id=%d" | 1 |
|
| "SELECT id, name FROM {$wpdb->prefix}" . MPG_Constant::MPG_PROJECTS_TABLE | 3 |
|