list($micro,$seconds) = explode(" ", microtime()); $start = $seconds + $micro; db_execute("REPLACE INTO settings (name, value) VALUES ('mt_last_run_time', '$current_time')"); collect_mactrack_data($start, $site_id); log_mactrack_statistics("collect"); } if ($time_till_next_db_maint < 0) { /* take time and log performance data */ list($micro,$seconds) = explode(" ", microtime()); $start = $seconds + $micro; db_execute("REPLACE INTO settings (name, value) VALUES ('mt_last_db_maint_time', '$current_time')"); perform_mactrack_db_maint(); log_mactrack_statistics("maint"); } } } } /* display_help - displays the usage of the function */ function display_help () { $version = mactrack_version(); print "MacTrack Master Poller v" . $version["version"] . ", Copyright 2004-2010 - The Cacti Group\n\n"; print "usage: poller_mactrack.php [-sid=site_id] [-d] [-h] [--help] [-v] [--version]\n\n"; print "-sid=site_id - The mac_track_sites site_id to scan\n"; print "-w | --web - Display output suitable for the web\n"; print "-f | --force - Force the execution of a collection process\n"; print "-d | --debug - Display verbose output during execution\n";
function mactrack_utilities_db_maint() { $begin_rows = db_fetch_cell('SELECT COUNT(*) FROM mac_track_ports'); perform_mactrack_db_maint(); $end_rows = db_fetch_cell('SELECT COUNT(*) FROM mac_track_ports'); html_start_box('Device Tracking Database Results', '100%', '', '3', 'center', ''); ?> <td> The following number of records have been removed from the database: <?php print $begin_rows - $end_rows; ?> </td> <?php html_end_box(); }
function mactrack_utilities_db_maint() { global $colors; $begin_rows = db_fetch_cell("SELECT COUNT(*) FROM mac_track_ports"); perform_mactrack_db_maint(); $end_rows = db_fetch_cell("SELECT COUNT(*) FROM mac_track_ports"); html_start_box("<strong>Device Tracking Database Results</strong>", "100%", $colors["header"], "3", "center", ""); ?> <td> The following number of records have been removed from the database: <?php print $begin_rows-$end_rows;?> </td> <?php html_end_box(); }