| 1 |
<?php |
| 2 |
/******************************************************************************************** |
| 3 |
* |
| 4 |
* SETTINGS ('OPTIONS') PAGE |
| 5 |
* |
| 6 |
********************************************************************************************/ |
| 7 |
?> |
| 8 |
<?php |
| 9 |
if (isset($_POST['info_update'])) { |
| 10 |
// SAVE SETTINGS |
| 11 |
check_admin_referer('odb_action', 'odb_nonce'); |
| 12 |
|
| 13 |
$current_datetime = Date('YmdHis'); |
| 14 |
$current_date = substr($current_datetime, 0, 8); |
| 15 |
$current_hour = substr($current_datetime, 8, 2); |
| 16 |
|
| 17 |
// CUSTOM POST TYPES (from v4.4) |
| 18 |
$updated_pts = array(); |
| 19 |
$rel_posttypes = $this->odb_utilities_obj->odb_get_relevant_post_types(); |
| 20 |
// LOOP THROUGH THE RELEVANT POST TYPES |
| 21 |
foreach ($rel_posttypes as $posttype) { |
| 22 |
if (isset($_POST['rvg_cb_cpt_' . $posttype])) { |
| 23 |
$updated_pts[$posttype] = "Y"; |
| 24 |
} else { |
| 25 |
$updated_pts[$posttype] = "N"; |
| 26 |
} // if (isset($_POST['rvg_cb_cpt_' . $posttype])) |
| 27 |
} // foreach ($rel_posttypes as $posttype) |
| 28 |
// UPDATE OPTIONS |
| 29 |
$this->odb_rvg_options['post_types'] = $updated_pts; |
| 30 |
|
| 31 |
if(isset($_POST['rvg_odb_delete_older'])) $this->odb_rvg_options['delete_older'] = sanitize_text_field($_POST['rvg_odb_delete_older']); |
| 32 |
else $this->odb_rvg_options['delete_older'] = 'N'; |
| 33 |
|
| 34 |
if(isset($_POST['rvg_odb_older_than'])) $this->odb_rvg_options['older_than'] = sanitize_text_field($_POST['rvg_odb_older_than']); |
| 35 |
else $this->odb_rvg_options['older_than'] = ''; |
| 36 |
|
| 37 |
if(isset($_POST['rvg_odb_keep_revisions'])) |
| 38 |
$this->odb_rvg_options['rvg_revisions'] = sanitize_text_field($_POST['rvg_odb_keep_revisions']); |
| 39 |
else |
| 40 |
$this->odb_rvg_options['rvg_revisions'] = 'N'; |
| 41 |
|
| 42 |
if(isset($_POST['rvg_odb_number'])) $this->odb_rvg_options['nr_of_revisions'] = sanitize_text_field($_POST['rvg_odb_number']); |
| 43 |
else $this->odb_rvg_options['nr_of_revisions'] = ''; |
| 44 |
|
| 45 |
if(isset($_POST['rvg_clear_trash'])) $this->odb_rvg_options['clear_trash'] = sanitize_text_field($_POST['rvg_clear_trash']); |
| 46 |
else $this->odb_rvg_options['clear_trash'] = 'N'; |
| 47 |
|
| 48 |
if(isset($_POST['rvg_clear_spam'])) $this->odb_rvg_options['clear_spam'] = sanitize_text_field($_POST['rvg_clear_spam']); |
| 49 |
else $this->odb_rvg_options['clear_spam'] = 'N'; |
| 50 |
|
| 51 |
if(isset($_POST['rvg_clear_tags'])) $this->odb_rvg_options['clear_tags'] = sanitize_text_field($_POST['rvg_clear_tags']); |
| 52 |
else $this->odb_rvg_options['clear_tags'] = 'N'; |
| 53 |
|
| 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'; |
| 56 |
|
| 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'; |
| 59 |
|
| 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'; |
| 62 |
|
| 63 |
if(isset($_POST['rvg_clear_orphans'])) $this->odb_rvg_options['clear_orphans'] = sanitize_text_field($_POST['rvg_clear_orphans']); |
| 64 |
else $this->odb_rvg_options['clear_orphans'] = 'N'; |
| 65 |
|
| 66 |
if(isset($_POST['rvg_odb_logging_on'])) $this->odb_rvg_options['logging_on'] = sanitize_text_field($_POST['rvg_odb_logging_on']); |
| 67 |
else $this->odb_rvg_options['logging_on'] = 'N'; |
| 68 |
|
| 69 |
if(isset($_POST['rvg_odb_schedule'])) { |
| 70 |
$type_old = $this->odb_rvg_options['schedule_type']; |
| 71 |
$hour_old = $this->odb_rvg_options['schedule_hour']; |
| 72 |
|
| 73 |
if(sanitize_text_field($_POST['rvg_odb_schedule'] == '') |
| 74 |
|| (sanitize_text_field($_POST['rvg_odb_schedule']) != 'daily' |
| 75 |
&& sanitize_text_field($_POST['rvg_odb_schedule']) != 'weekly' && sanitize_text_field($_POST['rvg_odb_schedule']) != 'monthly' )) |
| 76 |
$_POST['rvg_odb_schedulehour'] = ''; |
| 77 |
|
| 78 |
$hour = ''; |
| 79 |
if(isset($_POST['rvg_odb_schedulehour'])) $hour = sanitize_text_field($_POST['rvg_odb_schedulehour']); |
| 80 |
|
| 81 |
if($type_old != sanitize_text_field($_POST['rvg_odb_schedule']) || $hour_old != $hour) { |
| 82 |
// SCHEDULE CHANGED |
| 83 |
$this->odb_rvg_options['schedule_type'] = sanitize_text_field($_POST['rvg_odb_schedule']); |
| 84 |
$this->odb_rvg_options['schedule_hour'] = $hour; |
| 85 |
if($this->odb_rvg_options['schedule_type'] == '') |
| 86 |
// UN-SCHEDULED |
| 87 |
wp_clear_scheduled_hook('odb_scheduler'); |
| 88 |
else |
| 89 |
// RE-SCHEDULE |
| 90 |
$this->odb_scheduler_obj->odb_reschedule(); |
| 91 |
} // if($type_old != sanitize_text_field($_POST['rvg_odb_schedule']) || $hour_old != $hour) |
| 92 |
} // if(isset($_POST['rvg_odb_schedule'])) |
| 93 |
|
| 94 |
if(isset($_POST['rvg_odb_adminbar'])) $this->odb_rvg_options['adminbar'] = sanitize_text_field($_POST['rvg_odb_adminbar']); |
| 95 |
else $this->odb_rvg_options['adminbar'] = 'N'; |
| 96 |
|
| 97 |
if(isset($_POST['rvg_odb_adminmenu'])) $this->odb_rvg_options['adminmenu'] = sanitize_text_field($_POST['rvg_odb_adminmenu']); |
| 98 |
else $this->odb_rvg_options['adminmenu'] = 'N'; |
| 99 |
|
| 100 |
if(isset($_POST['rvg_odb_optimize_innodb'])) $this->odb_rvg_options['optimize_innodb'] = sanitize_text_field($_POST['rvg_odb_optimize_innodb']); |
| 101 |
else $this->odb_rvg_options['optimize_innodb'] = 'N'; |
| 102 |
|
| 103 |
$this->odb_multisite_obj->odb_ms_update_option('odb_rvg_options', $this->odb_rvg_options); |
| 104 |
|
| 105 |
// UPDATE EXCLUDED TABLES |
| 106 |
// EMPTY ARRAY |
| 107 |
$this->odb_rvg_excluded_tabs = array(); |
| 108 |
|
| 109 |
// ADD CHECKED TABLES |
| 110 |
foreach ($_POST as $key => $value) |
| 111 |
if(substr($key,0,3) == 'cb_') |
| 112 |
$this->odb_rvg_excluded_tabs[substr($key,3)] = 'Y'; |
| 113 |
// SAVE TO DB |
| 114 |
$this->odb_multisite_obj->odb_ms_update_option('odb_rvg_excluded_tabs', $this->odb_rvg_excluded_tabs); |
| 115 |
|
| 116 |
// UPDATED MESSAGE |
| 117 |
echo "<div class='updated odb-bold'><p>". |
| 118 |
__('Optimize Database after Deleting Revisions SETTINGS UPDATED',$this->odb_txt_domain). |
| 119 |
" - "; |
| 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>"; |
| 122 |
} // if (isset($_POST['info_update'])) |
| 123 |
?> |
| 124 |
<script type="text/javascript"> |
| 125 |
function rvg_odb_delete_older_changed() { |
| 126 |
if(!jQuery('input[name=rvg_odb_delete_older]:checked').val()) { |
| 127 |
jQuery("#rvg_odb_older_than").prop('disabled', true); |
| 128 |
jQuery("#rvg_odb_older_than").val(""); |
| 129 |
} else { |
| 130 |
jQuery("#rvg_odb_older_than").prop('disabled', false); |
| 131 |
} |
| 132 |
} // rvg_odb_delete_older_changed() |
| 133 |
|
| 134 |
function rvg_odb_keep_revisions_changed() { |
| 135 |
if(!jQuery('input[name=rvg_odb_keep_revisions]:checked').val()) { |
| 136 |
jQuery("#rvg_odb_number").prop('disabled', true); |
| 137 |
jQuery("#rvg_odb_number").val(""); |
| 138 |
} else { |
| 139 |
jQuery("#rvg_odb_number").prop('disabled', false); |
| 140 |
} |
| 141 |
} // rvg_odb_keep_revisions_changed() |
| 142 |
|
| 143 |
function schedule_changed() { |
| 144 |
if(jQuery("#rvg_odb_schedule").val() == "daily" || jQuery("#rvg_odb_schedule").val() == "weekly" || jQuery("#rvg_odb_schedule").val() == "monthly") |
| 145 |
jQuery("#schedulehour").show(); |
| 146 |
else |
| 147 |
jQuery("#schedulehour").hide(); |
| 148 |
} // schedule_changed() |
| 149 |
|
| 150 |
function rvg_odb_check_form() |
| 151 |
{ |
| 152 |
if(jQuery('input[name=rvg_odb_delete_older]:checked').val()) { |
| 153 |
if(jQuery("#rvg_odb_older_than").val() == '') { |
| 154 |
jQuery("#rvg_odb_older_than").focus(); |
| 155 |
alert('<?php _e("You have to enter: ",$this->odb_txt_domain)?> <'+'<?php _e("Delete revisions older than",$this->odb_txt_domain)?>'+'>'); |
| 156 |
return false; |
| 157 |
} |
| 158 |
if(!jQuery.isNumeric(jQuery("#rvg_odb_older_than").val())) { |
| 159 |
jQuery("#rvg_odb_older_than").focus(); |
| 160 |
alert('<?php _e("<Delete revisions older than> should be a number", $this->odb_txt_domain)?>'); |
| 161 |
return false; |
| 162 |
} |
| 163 |
} // if(jQuery('input[name=rvg_odb_delete_older]:checked').val()) |
| 164 |
|
| 165 |
if(jQuery('input[name=rvg_odb_keep_revisions]:checked').val()) { |
| 166 |
if(jQuery("#rvg_odb_number").val() == '') { |
| 167 |
jQuery("#rvg_odb_number").focus(); |
| 168 |
alert('<?php _e("You have to enter the <Maximum number of revisions>", $this->odb_txt_domain)?>'); |
| 169 |
return false; |
| 170 |
} |
| 171 |
if(!jQuery.isNumeric(jQuery("#rvg_odb_number").val())) { |
| 172 |
jQuery("#rvg_odb_number").focus(); |
| 173 |
alert('<?php _e("<Maximum number of revisions> should be a number", $this->odb_txt_domain)?>'); |
| 174 |
return false; |
| 175 |
} |
| 176 |
} // if(jQuery('input[name=rvg_odb_keep_revisions]:checked').val()) |
| 177 |
|
| 178 |
return true; |
| 179 |
} // function rvg_odb_check_form() |
| 180 |
</script> |
| 181 |
<?php |
| 182 |
// CHECKBOXES |
| 183 |
$c = ' checked'; |
| 184 |
$d = ' disabled'; |
| 185 |
|
| 186 |
if($this->odb_rvg_options['delete_older'] == "Y") { |
| 187 |
// CHECKED |
| 188 |
$cb_delete_older = $c; |
| 189 |
$cb_disabled1 = ''; |
| 190 |
} else { |
| 191 |
// UNCHECKED |
| 192 |
$cb_delete_older = ''; |
| 193 |
$this->odb_rvg_options['older_than'] = ''; |
| 194 |
$cb_disabled1 = $d; |
| 195 |
} |
| 196 |
|
| 197 |
if($this->odb_rvg_options['rvg_revisions'] == "Y") { |
| 198 |
// CHECKED |
| 199 |
$cb_keep_revisions = $c; |
| 200 |
$cb_disabled2 = ''; |
| 201 |
} else { |
| 202 |
// UNCHECED |
| 203 |
$cb_keep_revisions = ''; |
| 204 |
$this->odb_rvg_options['nr_of_revisions'] = ''; |
| 205 |
$cb_disabled2 = $d; |
| 206 |
} // if($this->odb_rvg_options['rvg_revisions'] == "Y") |
| 207 |
|
| 208 |
$cb_trash = ($this->odb_rvg_options['clear_trash'] == "Y") ? $c : ''; |
| 209 |
$cb_spam = ($this->odb_rvg_options['clear_spam'] == "Y") ? $c : ''; |
| 210 |
$cb_tags = ($this->odb_rvg_options['clear_tags'] == "Y") ? $c : ''; |
| 211 |
$cb_ping = ($this->odb_rvg_options['clear_pingbacks'] == "Y") ? $c : ''; |
| 212 |
$cb_oembed = ($this->odb_rvg_options['clear_oembed'] == "Y") ? $c : ''; |
| 213 |
$cb_orphans = ($this->odb_rvg_options['clear_orphans'] == "Y") ? $c : ''; |
| 214 |
$cb_logging = ($this->odb_rvg_options['logging_on'] == "Y") ? $c : ''; |
| 215 |
$cb_adminbar = ($this->odb_rvg_options['adminbar'] == "Y") ? $c : ''; |
| 216 |
$cb_adminmenu = ($this->odb_rvg_options['adminmenu'] == "Y") ? $c : ''; |
| 217 |
$cb_optimize_innodb = ($this->odb_rvg_options['optimize_innodb'] == "Y") ? $c : ''; |
| 218 |
|
| 219 |
// DISPLAY HEADER |
| 220 |
$this->odb_displayer_obj->display_header(); |
| 221 |
|
| 222 |
// GET THE DATABASE TABLES |
| 223 |
$odb_tables = $this->odb_utilities_obj->odb_get_tables(); |
| 224 |
|
| 225 |
// DISPLAY FORM |
| 226 |
echo ' |
| 227 |
<div class="odb-padding-left"> |
| 228 |
<div id="odb-options-form"> |
| 229 |
<form name="options" method="post" action="" onsubmit="return rvg_odb_check_form();"> |
| 230 |
'.wp_nonce_field('odb_action','odb_nonce').' |
| 231 |
<div id="odb-options-wrap"> |
| 232 |
<div id="odb-options-settings"> |
| 233 |
<div class="odb-title-bar"> |
| 234 |
<h2>'.__('Settings',$this->odb_txt_domain) . ' <a href="http://cagewebdev.com/optimize-database-after-deleting-revisions-wordpress-plugin/" target="_blank" title="Help"><img src="' . $this->odb_plugin_url.'images/question.png" align="absmiddle"></a>' . '</h2> |
| 235 |
</div> |
| 236 |
<table border="0" cellspacing="2" cellpadding="5" class="editform" align="center"> |
| 237 |
<tr> |
| 238 |
|
| 239 |
<td align="center" colspan="2"><span class="odb-bold">'. __('Delete revisions for the following (custom) post type(s):',$this->odb_txt_domain).'</span></td> |
| 240 |
</tr>'; |
| 241 |
|
| 242 |
// CUSTOM POST TYPES (from v4.4) |
| 243 |
$rel_posttypes = $this->odb_utilities_obj->odb_get_relevant_post_types(); |
| 244 |
|
| 245 |
// LOOP THROUGH THE RELEVANT POST TYPES |
| 246 |
foreach ($rel_posttypes as $posttype) { |
| 247 |
|
| 248 |
$cb_checked = ' checked'; |
| 249 |
if (isset($this->odb_rvg_options['post_types'][$posttype]) && |
| 250 |
$this->odb_rvg_options['post_types'][$posttype] == 'N') { |
| 251 |
$cb_checked = ''; |
| 252 |
} |
| 253 |
|
| 254 |
echo ' |
| 255 |
<tr> |
| 256 |
<td width="50%" align="right"><span class="odb-bold">' . $posttype . '</span></td> |
| 257 |
'; |
| 258 |
|
| 259 |
echo ' |
| 260 |
<td width="50%" valign="top"> |
| 261 |
<span class="odb-bold"> |
| 262 |
<input name="rvg_cb_cpt_' . $posttype . '" id="rvg_cb_cpt_' . $posttype . '" type="checkbox" value="Y" ' . $cb_checked . ' /></span> |
| 263 |
</td> |
| 264 |
</tr> |
| 265 |
'; |
| 266 |
} // foreach ($rel_posttypes as $posttype) |
| 267 |
|
| 268 |
echo ' |
| 269 |
<tr> |
| 270 |
<td width="50%" align="right"><span class="odb-bold">'. __('Delete revisions older than',$this->odb_txt_domain).'</span></td> |
| 271 |
<td width="50%" valign="top"><table border="0" cellspacing="0" cellpadding="3"> |
| 272 |
<tr> |
| 273 |
<td><span class="odb-bold"> |
| 274 |
<input name="rvg_odb_delete_older" id="rvg_odb_delete_older" type="checkbox" value="Y" '.$cb_delete_older.' onchange="rvg_odb_delete_older_changed();" /></span></td> |
| 275 |
<td><input type="text" size="2" name="rvg_odb_older_than" id="rvg_odb_older_than" value="'.$this->odb_rvg_options['older_than'].'" class="odb-bold odb-blue"'.$cb_disabled1.'> '.__("day(s)", $this->odb_txt_domain).' |
| 276 |
<script type="text/javascript"> |
| 277 |
'; |
| 278 |
if($this->odb_rvg_options['delete_older'] == 'Y') echo 'jQuery("#rvg_odb_older").prop("checked", true)'; |
| 279 |
echo ' |
| 280 |
jQuery("#rvg_odb_older_than").val("'.$this->odb_rvg_options['older_than'].'"); |
| 281 |
</script> |
| 282 |
</td> |
| 283 |
</tr> |
| 284 |
</table></td> |
| 285 |
</tr> |
| 286 |
<tr> |
| 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> |
| 288 |
<td width="50%" valign="top"><table border="0" cellspacing="0" cellpadding="3"> |
| 289 |
<tr> |
| 290 |
<td><span class="odb-bold"> |
| 291 |
<input name="rvg_odb_keep_revisions" id="rvg_odb_keep_revisions" type="checkbox" value="Y" '.$cb_keep_revisions.' onchange="rvg_odb_keep_revisions_changed();" /></span></td> |
| 292 |
<td><input type="text" size="2" name="rvg_odb_number" id="rvg_odb_number" value="'.$this->odb_rvg_options['nr_of_revisions'].'" class="odb-bold odb-blue"'.$cb_disabled2.'> |
| 293 |
<em>'.__('(\'0\' means: delete <u>ALL</u> revisions)',$this->odb_txt_domain).'</em></td> |
| 294 |
</tr> |
| 295 |
</table></td> |
| 296 |
</tr> |
| 297 |
<tr> |
| 298 |
<td width="50%" align="right" valign="top" class="odb-bold"> </td> |
| 299 |
<td width="50%" valign="top"> </td> |
| 300 |
</tr> |
| 301 |
<tr> |
| 302 |
<td width="50%" align="right" valign="top"><span class="odb-bold"> |
| 303 |
'. __('Delete trashed items',$this->odb_txt_domain).' |
| 304 |
</span></td> |
| 305 |
<td width="50%" valign="top"><input name="rvg_clear_trash" type="checkbox" value="Y" '.$cb_trash.'></td> |
| 306 |
</tr> |
| 307 |
<tr> |
| 308 |
<td width="50%" align="right" valign="top"><span class="odb-bold"> |
| 309 |
'. __('Delete spammed items',$this->odb_txt_domain).' |
| 310 |
</span></td> |
| 311 |
<td width="50%" valign="top"><input name="rvg_clear_spam" type="checkbox" value="Y" '.$cb_spam.'></td> |
| 312 |
</tr> |
| 313 |
<tr> |
| 314 |
<td width="50%" align="right" valign="top"><span class="odb-bold"> |
| 315 |
'.__('Delete unused tags',$this->odb_txt_domain).' |
| 316 |
</span></td> |
| 317 |
<td width="50%" valign="top"><input name="rvg_clear_tags" type="checkbox" value="Y" '.$cb_tags.'></td> |
| 318 |
</tr> |
| 319 |
<tr> |
| 320 |
<td width="50%" align="right"><span class="odb-bold"> |
| 321 |
'.__('Delete transients',$this->odb_txt_domain).' |
| 322 |
</span></td> |
| 323 |
<td width="50%" valign="top"><select name="rvg_clear_transients" id="rvg_clear_transients" class="odb-post-type-select"> |
| 324 |
<option selected="selected" value="N"> |
| 325 |
'.__('DO NOT DELETE TRANSIENTS',$this->odb_txt_domain).' |
| 326 |
</option> |
| 327 |
<option value="Y"> |
| 328 |
'.__('DELETE EXPIRED TRANSIENTS',$this->odb_txt_domain).' |
| 329 |
</option> |
| 330 |
<option value="A"> |
| 331 |
'.__('DELETE ALL TRANSIENTS',$this->odb_txt_domain).' |
| 332 |
</option> |
| 333 |
</select> |
| 334 |
<script type="text/javascript"> |
| 335 |
jQuery("#rvg_clear_transients").val("'.$this->odb_rvg_options['clear_transients'].'"); |
| 336 |
</script></td> |
| 337 |
</tr> |
| 338 |
<tr> |
| 339 |
<td width="50%" align="right" valign="top"><span class="odb-bold"> |
| 340 |
'.__('Delete pingbacks and trackbacks',$this->odb_txt_domain).' |
| 341 |
</span></td> |
| 342 |
<td width="50%" valign="top"><input name="rvg_clear_pingbacks" type="checkbox" value="Y" '.$cb_ping.'></td> |
| 343 |
</tr> |
| 344 |
<tr> |
| 345 |
<td width="50%" align="right" valign="top"><span class="odb-bold"> |
| 346 |
'.__('Clear oEmbed cache',$this->odb_txt_domain).' |
| 347 |
</span></td> |
| 348 |
<td width="50%" valign="top"><input name="rvg_clear_oembed" type="checkbox" value="Y" '.$cb_oembed.'></td> |
| 349 |
</tr> |
| 350 |
<tr> |
| 351 |
<td width="50%" align="right" valign="top"><span class="odb-bold"> |
| 352 |
'.__('Clear orphans',$this->odb_txt_domain).' |
| 353 |
</span></td> |
| 354 |
<td width="50%" valign="top"><input name="rvg_clear_orphans" type="checkbox" value="Y" '.$cb_orphans.'></td> |
| 355 |
</tr> |
| 356 |
<tr> |
| 357 |
<td align="right" valign="top"><span class="odb-bold"> |
| 358 |
'. __('Optimize InnoDB tables too',$this->odb_txt_domain).' |
| 359 |
</span></td> |
| 360 |
<td valign="top"><input name="rvg_odb_optimize_innodb" type="checkbox" value="Y" '.$cb_optimize_innodb.'></td> |
| 361 |
</tr> |
| 362 |
<tr> |
| 363 |
<td width="50%" align="right" valign="top"><span class="odb-bold"> |
| 364 |
'.__('Keep a log',$this->odb_txt_domain).' |
| 365 |
</span></td> |
| 366 |
<td width="50%" valign="top"><input name="rvg_odb_logging_on" type="checkbox" value="Y" '.$cb_logging.'></td> |
| 367 |
</tr> |
| 368 |
<tr> |
| 369 |
<td width="50%" align="right"><span class="odb-bold"> |
| 370 |
'.__('Scheduler',$this->odb_txt_domain).' |
| 371 |
</span></td> |
| 372 |
<td width="50%"><select name="rvg_odb_schedule" id="rvg_odb_schedule" class="odb-schedule-select" onchange="schedule_changed();"> |
| 373 |
<option selected="selected" value=""> |
| 374 |
'.__('NOT SCHEDULED',$this->odb_txt_domain).' |
| 375 |
</option> |
| 376 |
<option value="hourly"> |
| 377 |
'.__('run optimization HOURLY',$this->odb_txt_domain).' |
| 378 |
</option> |
| 379 |
<option value="twicedaily"> |
| 380 |
'.__('run optimization TWICE A DAY',$this->odb_txt_domain).' |
| 381 |
</option> |
| 382 |
<option value="daily"> |
| 383 |
'.__('run optimization DAILY',$this->odb_txt_domain).' |
| 384 |
</option> |
| 385 |
<option value="weekly"> |
| 386 |
'.__('run optimization WEEKLY',$this->odb_txt_domain).' |
| 387 |
</option> |
| 388 |
<option value="monthly"> |
| 389 |
'.__('run optimization MONTHLY',$this->odb_txt_domain).' |
| 390 |
</option> |
| 391 |
<!-- <option value="fiveminutes"> |
| 392 |
'.__('run optimization EVERY FIVE MINUTES',$this->odb_txt_domain).' |
| 393 |
</option>--> |
| 394 |
</select> |
| 395 |
<script type="text/javascript"> |
| 396 |
jQuery("#rvg_odb_schedule").val("'.$this->odb_rvg_options['schedule_type'].'"); |
| 397 |
</script> |
| 398 |
</td> |
| 399 |
</tr> |
| 400 |
<tr id="schedulehour"> |
| 401 |
<td width="50%" align="right"><span class="odb-bold"> |
| 402 |
'.__('Time',$this->odb_txt_domain).' |
| 403 |
</span></td> |
| 404 |
<td> |
| 405 |
<select name="rvg_odb_schedulehour" id="rvg_odb_schedulehour" class="odb-schedulehour-select"> |
| 406 |
'; |
| 407 |
|
| 408 |
for($i=0; $i<=23; $i++) { |
| 409 |
if($i < 10) $i = '0'.$i; |
| 410 |
?> |
| 411 |
<option value="<?php echo $i?>"><?php echo $i.':00 '.__('hrs',$this->odb_txt_domain)?></option> |
| 412 |
<?php |
| 413 |
} // for($i=0; $i<=23; $i++) |
| 414 |
|
| 415 |
echo ' |
| 416 |
</select> |
| 417 |
<script type="text/javascript"> |
| 418 |
jQuery("#rvg_odb_schedulehour").val("'.$this->odb_rvg_options['schedule_hour'].'"); |
| 419 |
</script> |
| 420 |
</span> |
| 421 |
</td> |
| 422 |
</tr> |
| 423 |
<script type="text/javascript">schedule_changed();</script> |
| 424 |
<tr> |
| 425 |
<td align="right" valign="top"><span class="odb-bold"> |
| 426 |
'.__('Show \'1-click\' link in Admin Bar',$this->odb_txt_domain).'* |
| 427 |
</span></td> |
| 428 |
<td valign="top"><input name="rvg_odb_adminbar" type="checkbox" value="Y" '.$cb_adminbar.'></td> |
| 429 |
</tr> |
| 430 |
<tr> |
| 431 |
<td align="right" valign="top"><span class="odb-bold"> |
| 432 |
'. __('Show an icon in the Admin Menu',$this->odb_txt_domain).'* |
| 433 |
</span></td> |
| 434 |
<td valign="top"><input name="rvg_odb_adminmenu" type="checkbox" value="Y" '.$cb_adminmenu.'></td> |
| 435 |
</tr> |
| 436 |
</table> |
| 437 |
<div align="center"><em>* '.__('change will be visible after loading the next page', $this->odb_txt_domain).'</em></div> |
| 438 |
<br> |
| 439 |
|
| 440 |
<div id="odb-options-buttons" align="center"> |
| 441 |
<p> |
| 442 |
<input class="button-primary button-large odb-bold" type="submit" name="info_update" value="'.__('Save Settings',$this->odb_txt_domain).'"> |
| 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\'"> |
| 445 |
</p> |
| 446 |
</div> |
| 447 |
<!-- odb-options-buttons --> |
| 448 |
<br> |
| 449 |
<div align="center"> |
| 450 |
<span class="odb-bold"> |
| 451 |
'.__('EXCLUDE DATABASE TABLES FROM OPTIMIZATION:<br><span class="odb-underline-red">CHECKED</span> TABLES <span class="odb-underline-red">WON\'T</span> BE OPTIMIZED!</span>',$this->odb_txt_domain).' |
| 452 |
<br><br> |
| 453 |
'; |
| 454 |
?> |
| 455 |
|
| 456 |
<a href="javascript:;" onclick="jQuery('[id^=cb_]').attr('checked',true);"> |
| 457 |
<?php _e('check all tables', $this->odb_txt_domain);?> |
| 458 |
</a> | <a href="javascript:;" onclick="jQuery('[id^=cb_]').attr('checked',false);"> |
| 459 |
<?php _e('uncheck all tables', $this->odb_txt_domain);?> |
| 460 |
</a> | <a href="javascript:;" onclick="jQuery(':not([id^=cb_<?php echo $this->odb_ms_prefixes[0]; ?>])').filter('[id^=cb_]').attr('checked',true);"> |
| 461 |
<?php _e('check all NON-WordPress tables', $this->odb_txt_domain);?> |
| 462 |
</a> |
| 463 |
|
| 464 |
<?php |
| 465 |
echo ' |
| 466 |
</span> |
| 467 |
<div id="odb-options-tables-container"> |
| 468 |
<div id="odb-options-tables-wrapper"> |
| 469 |
'; |
| 470 |
|
| 471 |
for ($i=0; $i<count($odb_tables); $i++) { |
| 472 |
$class = ''; |
| 473 |
for($j=0; $j<count($this->odb_ms_prefixes); $j++) |
| 474 |
if(substr($odb_tables[$i][0], 0, strlen($this->odb_ms_prefixes[$j])) == $this->odb_ms_prefixes[$j]) $class = ' odb-wp-table'; |
| 475 |
$cb_checked = ''; |
| 476 |
if(isset($this->odb_rvg_excluded_tabs[$odb_tables[$i][0]])) $cb_checked = ' checked'; |
| 477 |
?> |
| 478 |
<div class="odb-options-table<?php echo $class;?>" title="<?php echo $odb_tables[$i][0];?>"> |
| 479 |
<input id="cb_<?php echo $odb_tables[$i][0];?>" name="cb_<?php echo $odb_tables[$i][0];?>" type="checkbox" value="1"<?php echo $cb_checked; ?>> |
| 480 |
<?php echo $odb_tables[$i][0];?></div> |
| 481 |
<?php |
| 482 |
} |
| 483 |
|
| 484 |
echo ' |
| 485 |
</div><!-- /odb-options-tables-wrapper --> |
| 486 |
<div id="odb-options-buttons" align="center"> |
| 487 |
<p> |
| 488 |
<input class="button-primary button-large odb-bold" type="submit" name="info_update" value="'.__('Save Settings',$this->odb_txt_domain).'"> |
| 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\'"> |
| 491 |
</p> |
| 492 |
</div> |
| 493 |
<!-- odb-options-buttons --> |
| 494 |
</div><!-- /odb-options-tables-container --> |
| 495 |
</div><!-- /center --> |
| 496 |
</div><!-- /odb-options-settings --> |
| 497 |
</div><!-- /odb-options-wrap --> |
| 498 |
</form> |
| 499 |
</div><!-- /odb-options-form --> |
| 500 |
</div><!-- /odb-padding-left --> |
| 501 |
'; |
| 502 |
?> |
