Diff -- /var/www/vhosts/3dshawn.com/site1/TEMPLATES/database_monitor_settings.html
Diff
/var/www/vhosts/3dshawn.com/site1/TEMPLATES/database_monitor_settings.html
added on local at 2026-07-10 18:40:41
Added
+124
lines
Removed
-0
lines
Context
0
unchanged
Blobs
from
to 5d0097fbe055
to 5d0097fbe055
Unified diff
Naive LCS-based line diff. Additions in emerald, deletions in rose. Both sides decompressed live from BLOB_STORE.| 1 | <div class="div_area shadow"> | |
| 2 | <div class="div_area_header"> | |
| 3 | <div class="div_area_header_text">MANAGE DATABASE MONITORS</div> | |
| 4 | <div style="position:relative;float:right;top:-21px;padding:0px 5px 0px 0px;"> | |
| 5 | <input type="button" name="" value="add database" class="add_button" onClick="ajax_request('[url:databases]&add_database=1', 'database_monitor_div');success_msg('Database Monitor Added - Ready To Be Configured');"> | |
| 6 | </div> | |
| 7 | </div> | |
| 8 | ||
| 9 | [area:database_monitor_div] | |
| 10 | <div id="database_monitor_div"> | |
| 11 | ||
| 12 | <div class="div_area_content"> | |
| 13 | <div class="div_area_row page_font box_sizing"> | |
| 14 | <table width="100%" cellspacing="0" cellpadding="0" border="0"> | |
| 15 | <tr class="page_font"> | |
| 16 | <td align="left" width="100" title="This turns on and off all monitoring for this database."><b>Database Monitor</b></td> | |
| 17 | <td align="left" width="200"><b>Database Name</b></td> | |
| 18 | <td align="left" width="150"><b>Hostname</b></td> | |
| 19 | <td align="left" width="130"><b>Port</b></td> | |
| 20 | <td align="left" width="130"><b>Username</b></td> | |
| 21 | <td align="left" width="130"><b>Password</b></td> | |
| 22 | <td align="left" width="100"><b>Total Emails</b></td> | |
| 23 | <td align="left" width="100"><b>DB Settings</b></td> | |
| 24 | </tr> | |
| 25 | </table> | |
| 26 | </div> | |
| 27 | ||
| 28 | [loop:@databases] | |
| 29 | <div class="div_area_row page_font box_sizing"> | |
| 30 | <table width="100%" cellspacing="0" cellpadding="0" border="0" style="position:relative;z-index:1;"> | |
| 31 | <tr class="page_font"> | |
| 32 | <td align="left" width="100"> | |
| 33 | <select name="status" class="page_font [if:$status eq '1']switch_on[/if][else]switch_off[/else]" style="width:60px;height:20px;" onChange="if(this.value=='1'){this.className='page_font switch_on';}else{this.className='page_font switch_off';} ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_status=1&status='+encodeURIComponent(this.value)+'', '');success_msg('DB Monitor Status Updated');"> | |
| 34 | <option value="1" [if:$status eq '1']selected="selected"[/if] style="border:1px solid #548235;color:#548235;background: #e2efda;">on</option> | |
| 35 | <option value="0" [if:$status eq '0']selected="selected"[/if] style="border:1px solid #b94441;color:#b94441;background: #ffb1b1;">off</option> | |
| 36 | </select> | |
| 37 | </td> | |
| 38 | <td align="left" width="200"><input type="text" name="" value="$db_name" class="text_field" style="width:95%;height:15px;background:transparent;border:0px;" onKeyPress="if(event.which == 13 || event.keyCode == 13){document.activeElement.blur();}" onBlur="ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_db_name=1&db_name='+encodeURIComponent(this.value)+'', '');success_msg('Database Name Updated!');"></td> | |
| 39 | <td align="left" width="150"><input type="text" name="" value="$hostname" class="text_field" style="width:95%;height:15px;background:transparent;border:0px;" onKeyPress="if(event.which == 13 || event.keyCode == 13){document.activeElement.blur();}" onBlur="ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_hostname=1&hostname='+encodeURIComponent(this.value)+'', '');success_msg('Hostname Updated!');"></td> | |
| 40 | <td align="left" width="130"><input type="text" name="" value="$port" class="text_field" style="width:95%;height:15px;background:transparent;border:0px;" onKeyPress="if(event.which == 13 || event.keyCode == 13){document.activeElement.blur();}" onBlur="ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_port=1&port='+encodeURIComponent(this.value)+'', '');success_msg('Port Number Updated!');"></td> | |
| 41 | <td align="left" width="130"><input type="text" name="" value="$username" class="text_field" style="width:95%;height:15px;background:transparent;border:0px;" onKeyPress="if(event.which == 13 || event.keyCode == 13){document.activeElement.blur();}" onBlur="ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_username=1&username='+encodeURIComponent(this.value)+'', '');success_msg('Username Updated!');"></td> | |
| 42 | <td align="left" width="130"><input type="password" name="" value="$password" class="text_field" style="width:95%;height:15px;background:transparent;border:0px;" onClick="this.type='text';" onKeyPress="if(event.which == 13 || event.keyCode == 13){document.activeElement.blur();}" onBlur="this.type='password';ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_password=1&password='+encodeURIComponent(this.value)+'', '');success_msg('Password Updated!');"></td> | |
| 43 | <td align="left" width="100">$total_emails</td> | |
| 44 | <td align="left" width="100" onClick="if(document.getElementById('db_$database_list_id').style.display=='none'){document.getElementById('db_$database_list_id').style.display='block';}else{document.getElementById('db_$database_list_id').style.display='none';}">view settings</td> | |
| 45 | </tr> | |
| 46 | </table> | |
| 47 | <div id="db_$database_list_id" style="position:relative;z-index:2;display:none;height:auto;"> | |
| 48 | <div class="div_area" style="width:calc(100% - 30px);"> | |
| 49 | <div class="div_area_header2"> | |
| 50 | <div class="div_area_header_text2">DB SETTINGS</div> | |
| 51 | </div> | |
| 52 | <div class="div_area_content2" style="width:calc(100% - 20px);"> | |
| 53 | <table width="100%" cellspacing="0" cellpadding="4" border="0"> | |
| 54 | <tr class="page_font"> | |
| 55 | <td align="left" width="150" title="Email addresses listed here will be notified of any schema changes to this database."><b>Emails To Notify</b></td> | |
| 56 | <td align="left" width="150" title="These tables are not tracked or monitored in any way or form, this feature is designed around the idea of not wanting to track temporary tables."><b>Ignore Tables</b></td> | |
| 57 | <td align="left" width="150" title="Tables are still tracked in the system but no email alerts are sent out for these tables."><b>Track Tables Quietly</b></td> | |
| 58 | <td align="left" width="150" title="If monitoring of this database is turned on then this option will let you turn on/off the tracking for how many rows of data are in each table and how many records it changed by each time this database is scanned."><b>Track Row Count</b></td> | |
| 59 | <td align="left" width="150" title="Shows if the system is capable of connecting to this database"><b>Connection Status</b></td> | |
| 60 | <td align="left" width="150" title="Shows date/time of the the last connection attempt to the database"><b>Last Connected</b></td> | |
| 61 | <td align="left" width="150"><b> </b></td> | |
| 62 | <td align="left" width="150"><b> </b></td> | |
| 63 | </tr> | |
| 64 | <tr class="page_font"> | |
| 65 | <td align="left"> | |
| 66 | <div style="position:relative;"> | |
| 67 | <div style="position:absolute;float:left;top:-9px;"> | |
| 68 | <textarea name="notify_emails" id="notify_emails" class="text_field edit_autogrow_textfield_style" autocomplete="off" autocorrect="off" autocapitalize="off" onkeyup="auto_grow(this)" style="width:145px;height:20px;" onfocus="this.style.height=scrollHeight+'px';this.style.width='300px';" onBlur="this.style.width='195px';this.style.height='20px'; ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_emails=1¬ify_emails='+encodeURIComponent(this.value)+'', '');success_msg('Emails To Notify Updated!');">$notify_emails</textarea> | |
| 69 | </div> | |
| 70 | </div> | |
| 71 | </td> | |
| 72 | <td align="left"> | |
| 73 | <div style="position:relative;"> | |
| 74 | <div style="position:absolute;float:left;top:-9px;"> | |
| 75 | <textarea name="ignore_tables" id="ignore_tables" class="text_field edit_autogrow_textfield_style" autocomplete="off" autocorrect="off" autocapitalize="off" onkeyup="auto_grow(this)" style="width:145px;height:20px;" onfocus="this.style.height=scrollHeight+'px';this.style.width='300px';" onBlur="this.style.width='195px';this.style.height='20px'; ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_ignore_tables=1&ignore_tables='+encodeURIComponent(this.value)+'', '');success_msg('DB Tables To Ingore Updated!');">$ignore_tables</textarea> | |
| 76 | </div> | |
| 77 | </div> | |
| 78 | </td> | |
| 79 | <td align="left"> | |
| 80 | <div style="position:relative;"> | |
| 81 | <div style="position:absolute;float:left;top:-9px;"> | |
| 82 | <textarea name="track_tables_silently" id="track_tables_silently" class="text_field edit_autogrow_textfield_style" autocomplete="off" autocorrect="off" autocapitalize="off" onkeyup="auto_grow(this)" style="width:145px;height:20px;" onfocus="this.style.height=scrollHeight+'px';this.style.width='300px';" onBlur="this.style.width='195px';this.style.height='20px'; ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_track_tables_silently=1&track_tables_silently='+encodeURIComponent(this.value)+'', '');success_msg('Tables To Track Quietly Updated!');">$track_tables_silently</textarea> | |
| 83 | </div> | |
| 84 | </div> | |
| 85 | </td> | |
| 86 | <td align="left"> | |
| 87 | <select name="track_row_count" class="page_font" style="width:80%;height:15px;background:transparent;border:0px;" onChange="ajax_request('[url:databases]&update_databases=1&database_list_id=$database_list_id&update_track_row_count=1&track_row_count='+encodeURIComponent(this.value)+'', '');success_msg('Track Row Counts Updated!');"> | |
| 88 | <option value="1" [if:$track_row_count eq '1']selected="selected"[/if]>yes</option> | |
| 89 | <option value="0" [if:$track_row_count eq '0']selected="selected"[/if]>no</option> | |
| 90 | </select> | |
| 91 | </td> | |
| 92 | <td align="left" style="color:[if:$connection_status eq '1']#009800[/if][else]#FF0000[/else]">[if:$connection_status eq '1']connection successful[/if][else]connection failed[/else]</td> | |
| 93 | <td align="left">$last_connection</td> | |
| 94 | <td align="left"><input type="button" name="" value="test connection" class="add_button" onClick="ajax_request('[url:databases]&test_connection=1&database_list_id=$database_list_id', '');misc_msg('Connection Tested! Re-load area view_settings');"></td> | |
| 95 | <td align="left"><input type="button" name="" value="delete" class="delete_button" onClick="var confirmed=confirm('Are you sure you want to delete this database?');if(confirmed==true){ajax_request('[url:databases]&delete_database=1&database_list_id=$database_list_id', 'database_monitor_div');success_msg('Database Monitor Deleted!');}else{}"></td> | |
| 96 | </tr> | |
| 97 | </table> | |
| 98 | </div> | |
| 99 | </div> | |
| 100 | </div> | |
| 101 | </div> | |
| 102 | [/loop] | |
| 103 | </div> | |
| 104 | ||
| 105 | </div> | |
| 106 | [/area:database_monitor_div] | |
| 107 | </div> | |
| 108 | [/loop] | |
| 109 | </div> | |
| 110 | ||
| 111 | </div> | |
| 112 | [/area:database_monitor_div] | |
| 113 | </div> | |
| 114 | </div> | |
| 115 | </div> | |
| 116 | </div> | |
| 117 | [/area:view_settings] | |
| 118 | </div> | |
| 119 | [/loop] | |
| 120 | </div> | |
| 121 | ||
| 122 | </div> | |
| 123 | [/area:database_monitor_div] | |
| 124 | </div> |