Changeset 2571402
- Timestamp:
- 07/24/2021 01:43:45 PM (5 years ago)
- Location:
- rvg-optimize-database
- Files:
-
- 6 edited
- 1 copied
-
tags/5.0.7 (copied) (copied from rvg-optimize-database/trunk)
-
tags/5.0.7/includes/settings-page.php (modified) (1 diff)
-
tags/5.0.7/readme.txt (modified) (2 diffs)
-
tags/5.0.7/rvg-optimize-database.php (modified) (7 diffs)
-
trunk/includes/settings-page.php (modified) (1 diff)
-
trunk/readme.txt (modified) (2 diffs)
-
trunk/rvg-optimize-database.php (modified) (7 diffs)
Legend:
- Unmodified
- Added
- Removed
-
rvg-optimize-database/tags/5.0.7/includes/settings-page.php
r2378913 r2571402 388 388 <option value="monthly"> 389 389 '.__('run optimization MONTHLY',$this->odb_txt_domain).' 390 </option> 390 </option> 391 <!-- 392 <option value="fiveminutes"> 393 '.__('run optimization EVERY FIVE MINUTES',$this->odb_txt_domain).' 394 </option> 395 --> 391 396 </select> 392 397 <script type="text/javascript"> -
rvg-optimize-database/tags/5.0.7/readme.txt
r2571000 r2571402 11 11 Requires PHP: 5.0 12 12 Tested up to: 5.8 13 Stable tag: 5.0. 614 Version: 5.0. 613 Stable tag: 5.0.7 14 Version: 5.0.7 15 15 License: GPLv2 or later 16 16 … … 112 112 113 113 == Changelog == 114 = 5.0.7 [07/24/2021] = 115 * BUG FIX: Changed back to v5.0.4 116 114 117 = 5.0.6 [07/23/2021] = 115 118 * BUG FIX: Scheduler fixed -
rvg-optimize-database/tags/5.0.7/rvg-optimize-database.php
r2571000 r2571402 2 2 /** 3 3 * @package Optimize Database after Deleting Revisions 4 * @version 5.0. 64 * @version 5.0.7 5 5 */ 6 6 /* … … 11 11 Author URI: http://cagewebdev.com 12 12 Network: True 13 Version: 5.0. 613 Version: 5.0.7 14 14 */ 15 15 … … 29 29 class OptimizeDatabase { 30 30 // VERSION 31 var $odb_version = '5.0. 6';32 var $odb_release_date = '07/2 3/2021';31 var $odb_version = '5.0.7'; 32 var $odb_release_date = '07/24/2021'; 33 33 34 34 // PLUGIN OPTIONS … … 66 66 // v4.6 67 67 var $odb_logtable_name; 68 69 var $odb_scheduler = false;70 68 71 69 // OBJECTS … … 102 100 // URLS AND DIRECTORIES 103 101 $this->odb_urls_dirs(); 104 102 103 $this->odb_tables = $this->odb_utilities_obj->odb_get_tables(); 104 105 // CREATE LOG TABLE (IF NOT EXISTS) - v4.6 105 106 $this->odb_logtable_name = $wpdb->base_prefix . 'odb_logs'; 106 107 107 $this_page = ''; 108 if(isset($_GET['page'])) $this_page = $_GET['page']; 109 $this_action = ''; 110 if(isset($_GET['action'])) $this_action = $_GET['action']; 111 112 if ($this_page == 'rvg-optimize-database') { 113 if ($this->odb_scheduler || $this_action == 'run_summary' || $this_action == 'run_detail') { 114 $this->odb_tables = $this->odb_utilities_obj->odb_get_tables(); 115 // CREATE LOG TABLE (IF NOT EXISTS) - v4.6 116 $found = false; 117 for($i = 0; $i < count($this->odb_tables); $i++) { 118 if ($this->odb_tables[$i][0] == $this->odb_logtable_name) { 119 $found = true; 120 } 121 } // for($i = 0; $i < count($this->odb_tables); $i++) 122 123 // v5.0.3 124 if (!$found) { 125 $sql = ' 126 CREATE TABLE IF NOT EXISTS `' . $this->odb_logtable_name . '` ( 127 `odb_id` int(11) NOT NULL AUTO_INCREMENT, 128 `odb_timestamp` varchar(20) NOT NULL, 129 `odb_revisions` int(11) NOT NULL, 130 `odb_trash` int(11) NOT NULL, 131 `odb_spam` int(11) NOT NULL, 132 `odb_tags` int(11) NOT NULL, 133 `odb_transients` int(11) NOT NULL, 134 `odb_pingbacks` int(11) NOT NULL, 135 `odb_oembeds` int(11) NOT NULL, 136 `odb_orphans` int(11) NOT NULL, 137 `odb_tables` int(11) NOT NULL, 138 `odb_before` varchar(20) NOT NULL, 139 `odb_after` varchar(20) NOT NULL, 140 `odb_savings` varchar(20) NOT NULL, 141 PRIMARY KEY (`odb_id`) 142 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; 143 '; 144 145 // CREATE TABLE 146 $wpdb->get_results($sql); 147 } // if (!$found) 108 $found = false; 109 for($i = 0; $i < count($this->odb_tables); $i++) { 110 if ($this->odb_tables[$i][0] == $this->odb_logtable_name) { 111 $found = true; 148 112 } 113 } // for($i = 0; $i < count($this->odb_tables); $i++) 114 115 // v5.0.3 116 if (!$found) { 117 $sql = ' 118 CREATE TABLE IF NOT EXISTS `' . $this->odb_logtable_name . '` ( 119 `odb_id` int(11) NOT NULL AUTO_INCREMENT, 120 `odb_timestamp` varchar(20) NOT NULL, 121 `odb_revisions` int(11) NOT NULL, 122 `odb_trash` int(11) NOT NULL, 123 `odb_spam` int(11) NOT NULL, 124 `odb_tags` int(11) NOT NULL, 125 `odb_transients` int(11) NOT NULL, 126 `odb_pingbacks` int(11) NOT NULL, 127 `odb_oembeds` int(11) NOT NULL, 128 `odb_orphans` int(11) NOT NULL, 129 `odb_tables` int(11) NOT NULL, 130 `odb_before` varchar(20) NOT NULL, 131 `odb_after` varchar(20) NOT NULL, 132 `odb_savings` varchar(20) NOT NULL, 133 PRIMARY KEY (`odb_id`) 134 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; 135 '; 136 137 // CREATE TABLE 138 $wpdb->get_results($sql); 149 139 } 150 140 … … 165 155 166 156 // LOAD STYLE SHEET (ONLY ON RELEVANT PAGES) 157 $this_page = ''; 158 if(isset($_GET['page'])) $this_page = $_GET['page']; 167 159 // v4.0.3 168 160 if($this->odb_is_relevant_page()) { … … 649 641 *******************************************************************************/ 650 642 function odb_start_scheduler() { 651 $this->odb_scheduler = true; 652 $this->odb_start($this->odb_scheduler); 643 $this->odb_start(true); 653 644 } // odb_start_scheduler() 654 645 -
rvg-optimize-database/trunk/includes/settings-page.php
r2378913 r2571402 388 388 <option value="monthly"> 389 389 '.__('run optimization MONTHLY',$this->odb_txt_domain).' 390 </option> 390 </option> 391 <!-- 392 <option value="fiveminutes"> 393 '.__('run optimization EVERY FIVE MINUTES',$this->odb_txt_domain).' 394 </option> 395 --> 391 396 </select> 392 397 <script type="text/javascript"> -
rvg-optimize-database/trunk/readme.txt
r2571000 r2571402 11 11 Requires PHP: 5.0 12 12 Tested up to: 5.8 13 Stable tag: 5.0. 614 Version: 5.0. 613 Stable tag: 5.0.7 14 Version: 5.0.7 15 15 License: GPLv2 or later 16 16 … … 112 112 113 113 == Changelog == 114 = 5.0.7 [07/24/2021] = 115 * BUG FIX: Changed back to v5.0.4 116 114 117 = 5.0.6 [07/23/2021] = 115 118 * BUG FIX: Scheduler fixed -
rvg-optimize-database/trunk/rvg-optimize-database.php
r2571000 r2571402 2 2 /** 3 3 * @package Optimize Database after Deleting Revisions 4 * @version 5.0. 64 * @version 5.0.7 5 5 */ 6 6 /* … … 11 11 Author URI: http://cagewebdev.com 12 12 Network: True 13 Version: 5.0. 613 Version: 5.0.7 14 14 */ 15 15 … … 29 29 class OptimizeDatabase { 30 30 // VERSION 31 var $odb_version = '5.0. 6';32 var $odb_release_date = '07/2 3/2021';31 var $odb_version = '5.0.7'; 32 var $odb_release_date = '07/24/2021'; 33 33 34 34 // PLUGIN OPTIONS … … 66 66 // v4.6 67 67 var $odb_logtable_name; 68 69 var $odb_scheduler = false;70 68 71 69 // OBJECTS … … 102 100 // URLS AND DIRECTORIES 103 101 $this->odb_urls_dirs(); 104 102 103 $this->odb_tables = $this->odb_utilities_obj->odb_get_tables(); 104 105 // CREATE LOG TABLE (IF NOT EXISTS) - v4.6 105 106 $this->odb_logtable_name = $wpdb->base_prefix . 'odb_logs'; 106 107 107 $this_page = ''; 108 if(isset($_GET['page'])) $this_page = $_GET['page']; 109 $this_action = ''; 110 if(isset($_GET['action'])) $this_action = $_GET['action']; 111 112 if ($this_page == 'rvg-optimize-database') { 113 if ($this->odb_scheduler || $this_action == 'run_summary' || $this_action == 'run_detail') { 114 $this->odb_tables = $this->odb_utilities_obj->odb_get_tables(); 115 // CREATE LOG TABLE (IF NOT EXISTS) - v4.6 116 $found = false; 117 for($i = 0; $i < count($this->odb_tables); $i++) { 118 if ($this->odb_tables[$i][0] == $this->odb_logtable_name) { 119 $found = true; 120 } 121 } // for($i = 0; $i < count($this->odb_tables); $i++) 122 123 // v5.0.3 124 if (!$found) { 125 $sql = ' 126 CREATE TABLE IF NOT EXISTS `' . $this->odb_logtable_name . '` ( 127 `odb_id` int(11) NOT NULL AUTO_INCREMENT, 128 `odb_timestamp` varchar(20) NOT NULL, 129 `odb_revisions` int(11) NOT NULL, 130 `odb_trash` int(11) NOT NULL, 131 `odb_spam` int(11) NOT NULL, 132 `odb_tags` int(11) NOT NULL, 133 `odb_transients` int(11) NOT NULL, 134 `odb_pingbacks` int(11) NOT NULL, 135 `odb_oembeds` int(11) NOT NULL, 136 `odb_orphans` int(11) NOT NULL, 137 `odb_tables` int(11) NOT NULL, 138 `odb_before` varchar(20) NOT NULL, 139 `odb_after` varchar(20) NOT NULL, 140 `odb_savings` varchar(20) NOT NULL, 141 PRIMARY KEY (`odb_id`) 142 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; 143 '; 144 145 // CREATE TABLE 146 $wpdb->get_results($sql); 147 } // if (!$found) 108 $found = false; 109 for($i = 0; $i < count($this->odb_tables); $i++) { 110 if ($this->odb_tables[$i][0] == $this->odb_logtable_name) { 111 $found = true; 148 112 } 113 } // for($i = 0; $i < count($this->odb_tables); $i++) 114 115 // v5.0.3 116 if (!$found) { 117 $sql = ' 118 CREATE TABLE IF NOT EXISTS `' . $this->odb_logtable_name . '` ( 119 `odb_id` int(11) NOT NULL AUTO_INCREMENT, 120 `odb_timestamp` varchar(20) NOT NULL, 121 `odb_revisions` int(11) NOT NULL, 122 `odb_trash` int(11) NOT NULL, 123 `odb_spam` int(11) NOT NULL, 124 `odb_tags` int(11) NOT NULL, 125 `odb_transients` int(11) NOT NULL, 126 `odb_pingbacks` int(11) NOT NULL, 127 `odb_oembeds` int(11) NOT NULL, 128 `odb_orphans` int(11) NOT NULL, 129 `odb_tables` int(11) NOT NULL, 130 `odb_before` varchar(20) NOT NULL, 131 `odb_after` varchar(20) NOT NULL, 132 `odb_savings` varchar(20) NOT NULL, 133 PRIMARY KEY (`odb_id`) 134 ) DEFAULT CHARSET=utf8 AUTO_INCREMENT=1; 135 '; 136 137 // CREATE TABLE 138 $wpdb->get_results($sql); 149 139 } 150 140 … … 165 155 166 156 // LOAD STYLE SHEET (ONLY ON RELEVANT PAGES) 157 $this_page = ''; 158 if(isset($_GET['page'])) $this_page = $_GET['page']; 167 159 // v4.0.3 168 160 if($this->odb_is_relevant_page()) { … … 649 641 *******************************************************************************/ 650 642 function odb_start_scheduler() { 651 $this->odb_scheduler = true; 652 $this->odb_start($this->odb_scheduler); 643 $this->odb_start(true); 653 644 } // odb_start_scheduler() 654 645
Note: See TracChangeset
for help on using the changeset viewer.