Changeset 3032743
- Timestamp:
- 02/07/2024 02:03:10 PM (6 months ago)
- Location:
- rvg-optimize-database/trunk
- Files:
-
- 6 edited
Legend:
- Unmodified
- Added
- Removed
-
rvg-optimize-database/trunk/classes/odb-displayer.php
r3029714 r3032743 191 191 <br> 192 192 <p> 193 <input class="button odb-normal" type="button" name="change_options" value="'.__('Change Settings', 'rvg-optimize-database').'" onclick="self.location=\'options-general.php?page=odb_settings_page\'"> 194 <br><br> 193 <a href="' . esc_url( add_query_arg( array( 'page' => 'odb_settings_page' ), admin_url( 'options-general.php' ) ) ) . '">' . __( 'Change Settings', 'rvg-optimize-database' ) . '</a> 195 194 '; 196 195 … … 212 211 "; 213 212 } // if(file_exists($this->odb_plugin_path.'logs/rvg-optimize-db-log.html')) 213 214 215 214 216 215 217 if($action != 'run') { … … 217 219 if($odb_class->odb_logger_obj->odb_log_count() > 0) { 218 220 echo ' 219 <input class="button odb-normal" type="button" name="view_log" value="'.__('View Log', 'rvg-optimize-database').'" onclick="self.location=\'tools.php?page=rvg-optimize-database&action=view_log&_wpnonce=' . $nonce . '\'"> 220 221 <input class="button odb-normal" type="button" name="clear_log" value="'.__('Clear Log', 'rvg-optimize-database').'" onclick="return odb_confirm_delete();"> 221 <a href="' . esc_url( add_query_arg( array( 'page' => 'rvg-optimize-database&action', 'action' => 'view_log', '_wpnonce' => $nonce, ), admin_url( 'tools.php' ) ) ) . '">' . __( 'View Log', 'rvg-optimize-database' ) . '</a> 222 222 <br><br> 223 223 '; -
rvg-optimize-database/trunk/classes/odb-logger.php
r3031949 r3032743 90 90 global $odb_class, $wpdb; 91 91 92 93 92 94 $this->sql = " 93 95 SELECT * FROM `" . $odb_class->odb_logtable_name . "` ORDER BY odb_id ASC … … 158 160 function odb_confirm_delete() { 159 161 if(confirm('<?php echo $msg?>')) { 160 self.location = 'tools.php?page=rvg-optimize-database&action=clear_log '162 self.location = 'tools.php?page=rvg-optimize-database&action=clear_log' 161 163 return; 162 164 } … … 164 166 </script> 165 167 <br> 166 <input class="button odb-normal" type="button" name="change_options" value="<?php _e('Change Settings', 'rvg-optimize-database')?>" onclick="self.location='options-general.php?page=odb_settings_page'" />167 168 168 <input class="button odb-normal" type="button" name="clear_log" value="<?php _e('Clear Log', 'rvg-optimize-database') ?>" onclick="return odb_confirm_delete();" /> 169 170 169 171 <?php 170 172 } // odb_view_log() -
rvg-optimize-database/trunk/classes/odb-utilities.php
r3029714 r3032743 86 86 return $wpdb->get_results(" 87 87 SHOW FULL TABLES 88 FROM `" . $this->odb_sanitize_key( DB_NAME ) . "`89 88 WHERE table_type = 'BASE TABLE' 90 89 ", ARRAY_N); … … 98 97 */ 99 98 function odb_sanitize_key( string $key ) { 100 return preg_replace( '/[^a-z 0-9_\-]/', '', $key );99 return preg_replace( '/[^a-z0-9_\-]/', '', $key ); 101 100 } 102 101 } // ODB_Utilities -
rvg-optimize-database/trunk/includes/settings-page.php
r2577255 r3032743 34 34 if(isset($_POST['rvg_odb_older_than'])) $this->odb_rvg_options['older_than'] = sanitize_text_field($_POST['rvg_odb_older_than']); 35 35 else $this->odb_rvg_options['older_than'] = ''; 36 36 37 37 if(isset($_POST['rvg_odb_keep_revisions'])) 38 38 $this->odb_rvg_options['rvg_revisions'] = sanitize_text_field($_POST['rvg_odb_keep_revisions']); … … 51 51 if(isset($_POST['rvg_clear_tags'])) $this->odb_rvg_options['clear_tags'] = sanitize_text_field($_POST['rvg_clear_tags']); 52 52 else $this->odb_rvg_options['clear_tags'] = 'N'; 53 53 54 54 if(isset($_POST['rvg_clear_transients'])) $this->odb_rvg_options['clear_transients'] = sanitize_text_field($_POST['rvg_clear_transients']); 55 else $this->odb_rvg_options['clear_transients'] = 'N'; 55 else $this->odb_rvg_options['clear_transients'] = 'N'; 56 56 57 57 if(isset($_POST['rvg_clear_pingbacks'])) $this->odb_rvg_options['clear_pingbacks'] = sanitize_text_field($_POST['rvg_clear_pingbacks']); 58 else $this->odb_rvg_options['clear_pingbacks'] = 'N'; 58 else $this->odb_rvg_options['clear_pingbacks'] = 'N'; 59 59 60 60 if(isset($_POST['rvg_clear_oembed'])) $this->odb_rvg_options['clear_oembed'] = sanitize_text_field($_POST['rvg_clear_oembed']); 61 else $this->odb_rvg_options['clear_oembed'] = 'N'; 61 else $this->odb_rvg_options['clear_oembed'] = 'N'; 62 62 63 63 if(isset($_POST['rvg_clear_orphans'])) $this->odb_rvg_options['clear_orphans'] = sanitize_text_field($_POST['rvg_clear_orphans']); … … 66 66 if(isset($_POST['rvg_odb_logging_on'])) $this->odb_rvg_options['logging_on'] = sanitize_text_field($_POST['rvg_odb_logging_on']); 67 67 else $this->odb_rvg_options['logging_on'] = 'N'; 68 68 69 69 if(isset($_POST['rvg_odb_schedule'])) { 70 70 $type_old = $this->odb_rvg_options['schedule_type']; 71 71 $hour_old = $this->odb_rvg_options['schedule_hour']; 72 72 73 73 if(sanitize_text_field($_POST['rvg_odb_schedule'] == '') 74 74 || (sanitize_text_field($_POST['rvg_odb_schedule']) != 'daily' 75 75 && sanitize_text_field($_POST['rvg_odb_schedule']) != 'weekly' && sanitize_text_field($_POST['rvg_odb_schedule']) != 'monthly' )) 76 76 $_POST['rvg_odb_schedulehour'] = ''; 77 77 78 78 $hour = ''; 79 79 if(isset($_POST['rvg_odb_schedulehour'])) $hour = sanitize_text_field($_POST['rvg_odb_schedulehour']); … … 82 82 // SCHEDULE CHANGED 83 83 $this->odb_rvg_options['schedule_type'] = sanitize_text_field($_POST['rvg_odb_schedule']); 84 $this->odb_rvg_options['schedule_hour'] = $hour; 84 $this->odb_rvg_options['schedule_hour'] = $hour; 85 85 if($this->odb_rvg_options['schedule_type'] == '') 86 86 // UN-SCHEDULED … … 102 102 103 103 $this->odb_multisite_obj->odb_ms_update_option('odb_rvg_options', $this->odb_rvg_options); 104 104 105 105 // UPDATE EXCLUDED TABLES 106 106 // EMPTY ARRAY 107 107 $this->odb_rvg_excluded_tabs = array(); 108 108 109 109 // ADD CHECKED TABLES 110 110 foreach ($_POST as $key => $value) … … 112 112 $this->odb_rvg_excluded_tabs[substr($key,3)] = 'Y'; 113 113 // SAVE TO DB 114 $this->odb_multisite_obj->odb_ms_update_option('odb_rvg_excluded_tabs', $this->odb_rvg_excluded_tabs); 114 $this->odb_multisite_obj->odb_ms_update_option('odb_rvg_excluded_tabs', $this->odb_rvg_excluded_tabs); 115 115 116 116 // UPDATED MESSAGE … … 119 119 " - "; 120 120 _e('Click <a href="tools.php?page=rvg-optimize-database" class="odb-bold">HERE</a> to run the optimization',$this->odb_txt_domain); 121 echo "</p></div>"; 121 echo "</p></div>"; 122 122 } // if (isset($_POST['info_update'])) 123 123 ?> … … 160 160 alert('<?php _e("<Delete revisions older than> should be a number", $this->odb_txt_domain)?>'); 161 161 return false; 162 } 162 } 163 163 } // if(jQuery('input[name=rvg_odb_delete_older]:checked').val()) 164 164 165 165 if(jQuery('input[name=rvg_odb_keep_revisions]:checked').val()) { 166 166 if(jQuery("#rvg_odb_number").val() == '') { … … 173 173 alert('<?php _e("<Maximum number of revisions> should be a number", $this->odb_txt_domain)?>'); 174 174 return false; 175 } 175 } 176 176 } // if(jQuery('input[name=rvg_odb_keep_revisions]:checked').val()) 177 177 … … 221 221 222 222 // GET THE DATABASE TABLES 223 $odb_tables = $this->odb_utilities_obj->odb_get_tables(); 223 $odb_tables = $this->odb_utilities_obj->odb_get_tables(); 224 224 225 225 // DISPLAY FORM … … 246 246 foreach ($rel_posttypes as $posttype) { 247 247 248 $cb_checked = ' checked'; 248 $cb_checked = ' checked'; 249 249 if (isset($this->odb_rvg_options['post_types'][$posttype]) && 250 250 $this->odb_rvg_options['post_types'][$posttype] == 'N') { … … 254 254 echo ' 255 255 <tr> 256 <td width="50%" align="right"><span class="odb-bold">' . $posttype . '</span></td> 256 <td width="50%" align="right"><span class="odb-bold">' . $posttype . '</span></td> 257 257 '; 258 258 259 259 echo ' 260 260 <td width="50%" valign="top"> 261 261 <span class="odb-bold"> 262 <input name="rvg_cb_cpt_' . $posttype . '" id="rvg_cb_cpt_' . $posttype . '" type="checkbox" value="Y" ' . $cb_checked . ' /></span> 262 <input name="rvg_cb_cpt_' . $posttype . '" id="rvg_cb_cpt_' . $posttype . '" type="checkbox" value="Y" ' . $cb_checked . ' /></span> 263 263 </td> 264 </tr> 264 </tr> 265 265 '; 266 266 } // foreach ($rel_posttypes as $posttype) 267 268 echo ' 267 268 echo ' 269 269 <tr> 270 270 <td width="50%" align="right"><span class="odb-bold">'. __('Delete revisions older than',$this->odb_txt_domain).'</span></td> … … 277 277 '; 278 278 if($this->odb_rvg_options['delete_older'] == 'Y') echo 'jQuery("#rvg_odb_older").prop("checked", true)'; 279 echo ' 279 echo ' 280 280 jQuery("#rvg_odb_older_than").val("'.$this->odb_rvg_options['older_than'].'"); 281 </script> 281 </script> 282 282 </td> 283 283 </tr> 284 284 </table></td> 285 </tr> 285 </tr> 286 286 <tr> 287 287 <td width="50%" align="right" valign="top"><span class="odb-bold">'.__('Maximum number of - most recent - revisions<br>to keep per post / page',$this->odb_txt_domain).'</span></td> … … 298 298 <td width="50%" align="right" valign="top" class="odb-bold"> </td> 299 299 <td width="50%" valign="top"> </td> 300 </tr> 300 </tr> 301 301 <tr> 302 302 <td width="50%" align="right" valign="top"><span class="odb-bold"> … … 330 330 <option value="A"> 331 331 '.__('DELETE ALL TRANSIENTS',$this->odb_txt_domain).' 332 </option> 332 </option> 333 333 </select> 334 334 <script type="text/javascript"> … … 353 353 </span></td> 354 354 <td width="50%" valign="top"><input name="rvg_clear_orphans" type="checkbox" value="Y" '.$cb_orphans.'></td> 355 </tr> 355 </tr> 356 356 <tr> 357 357 <td align="right" valign="top"><span class="odb-bold"> … … 359 359 </span></td> 360 360 <td valign="top"><input name="rvg_odb_optimize_innodb" type="checkbox" value="Y" '.$cb_optimize_innodb.'></td> 361 </tr> 361 </tr> 362 362 <tr> 363 363 <td width="50%" align="right" valign="top"><span class="odb-bold"> … … 365 365 </span></td> 366 366 <td width="50%" valign="top"><input name="rvg_odb_logging_on" type="checkbox" value="Y" '.$cb_logging.'></td> 367 </tr> 367 </tr> 368 368 <tr> 369 369 <td width="50%" align="right"><span class="odb-bold"> … … 401 401 <td width="50%" align="right"><span class="odb-bold"> 402 402 '.__('Time',$this->odb_txt_domain).' 403 </span></td> 403 </span></td> 404 404 <td> 405 405 <select name="rvg_odb_schedulehour" id="rvg_odb_schedulehour" class="odb-schedulehour-select"> … … 410 410 ?> 411 411 <option value="<?php echo $i?>"><?php echo $i.':00 '.__('hrs',$this->odb_txt_domain)?></option> 412 <?php 412 <?php 413 413 } // for($i=0; $i<=23; $i++) 414 414 415 echo ' 415 echo ' 416 416 </select> 417 417 <script type="text/javascript"> 418 418 jQuery("#rvg_odb_schedulehour").val("'.$this->odb_rvg_options['schedule_hour'].'"); 419 </script> 420 </span> 419 </script> 420 </span> 421 421 </td> 422 422 </tr> 423 <script type="text/javascript">schedule_changed();</script> 423 <script type="text/javascript">schedule_changed();</script> 424 424 <tr> 425 425 <td align="right" valign="top"><span class="odb-bold"> … … 433 433 </span></td> 434 434 <td valign="top"><input name="rvg_odb_adminmenu" type="checkbox" value="Y" '.$cb_adminmenu.'></td> 435 </tr> 435 </tr> 436 436 </table> 437 437 <div align="center"><em>* '.__('change will be visible after loading the next page', $this->odb_txt_domain).'</em></div> 438 438 <br> 439 439 440 440 <div id="odb-options-buttons" align="center"> 441 <p >441 <p> 442 442 <input class="button-primary button-large odb-bold" type="submit" name="info_update" value="'.__('Save Settings',$this->odb_txt_domain).'"> 443 443 444 < input class="button odb-normal" type="button" name="optimizer" value="'.__('Go To Optimizer',$this->odb_txt_domain).'" onclick="self.location=\'tools.php?page=rvg-optimize-database\'">444 <> 445 445 </p> 446 446 </div> 447 <!-- odb-options-buttons --> 447 <!-- odb-options-buttons --> 448 448 <br> 449 449 <div align="center"> … … 474 474 if(substr($odb_tables[$i][0], 0, strlen($this->odb_ms_prefixes[$j])) == $this->odb_ms_prefixes[$j]) $class = ' odb-wp-table'; 475 475 $cb_checked = ''; 476 if(isset($this->odb_rvg_excluded_tabs[$odb_tables[$i][0]])) $cb_checked = ' checked'; 476 if(isset($this->odb_rvg_excluded_tabs[$odb_tables[$i][0]])) $cb_checked = ' checked'; 477 477 ?> 478 478 <div class="odb-options-table<?php echo $class;?>" title="<?php echo $odb_tables[$i][0];?>"> … … 482 482 } 483 483 484 echo ' 484 echo ' 485 485 </div><!-- /odb-options-tables-wrapper --> 486 486 <div id="odb-options-buttons" align="center"> 487 <p>487 > 488 488 <input class="button-primary button-large odb-bold" type="submit" name="info_update" value="'.__('Save Settings',$this->odb_txt_domain).'"> 489 489 490 < input class="button odb-normal" type="button" name="optimizer" value="'.__('Go To Optimizer',$this->odb_txt_domain).'" onclick="self.location=\'tools.php?page=rvg-optimize-database\'">490 <> 491 491 </p> 492 492 </div> 493 <!-- odb-options-buttons --> 493 <!-- odb-options-buttons --> 494 494 </div><!-- /odb-options-tables-container --> 495 </div><!-- /center --> 495 </div><!-- /center --> 496 496 </div><!-- /odb-options-settings --> 497 497 </div><!-- /odb-options-wrap --> -
rvg-optimize-database/trunk/readme.txt
r3031949 r3032743 7 7 Requires PHP: 5.6 8 8 Tested up to: 6.4 9 Stable tag: 5.2. 110 Version: 5.2. 19 Stable tag: 5.2. 10 Version: 5.2. 11 11 License: GPLv2 or later 12 12 One-click database optimization with precise revision cleanup and flexible scheduling. Speeding up sites since 2011! … … 98 98 99 99 == Changelog == 100 101 102 103 104 100 105 = 5.2.1 [02/05/2024] = 101 106 * Add missing nonce on "Optimize DB (1 click)" admin bar link. -
rvg-optimize-database/trunk/rvg-optimize-database.php
r3031949 r3032743 2 2 /** 3 3 * @package Optimize Database after Deleting Revisions 4 * @version 5.2. 14 * @version 5.2. 5 5 */ 6 6 /* … … 10 10 Author URI: https://www..nerdpress.net 11 11 Network: True 12 Version: 5.2. 112 Version: 5.2. 13 13 */ 14 14 … … 48 48 class OptimizeDatabase { 49 49 // VERSION 50 var $odb_version = '5.2. 1';50 var $odb_version = '5.2.'; 51 51 52 52 // PLUGIN OPTIONS
Note: See TracChangeset
for help on using the changeset viewer.