This script is only meant to run at the command line."); } $no_http_headers = true; include(dirname(__FILE__) . "/../include/global.php"); include_once("../lib/utility.php"); include_once("../lib/template.php"); /* process calling arguments */ $parms = $_SERVER["argv"]; array_shift($parms); $execute = FALSE; foreach($parms as $parameter) { @list($arg, $value) = @explode("=", $parameter); switch ($arg) { case "--execute": $execute = TRUE; break; case "-h": case "-v": case "-V": case "--version": case "--help": display_help(); exit; default: print "ERROR: Invalid Parameter " . $parameter . "\n\n"; display_help(); exit; } } if ($execute) { echo "NOTE: Repairing All Duplicated Templates\n"; } else { echo "NOTE: Performing Check of Templates\n"; } /* repair data templates first */ if ($execute) { echo "NOTE: Repairing Data Templates\n"; } else { echo "NOTE: Performing Check of Data Templates\n"; } $damaged_template_ids = db_fetch_assoc("SELECT DISTINCT data_template_id FROM data_template_rrd WHERE hash='' AND local_data_id=0"); if (sizeof($damaged_template_ids)) { foreach($damaged_template_ids as $id) { $template_name = db_fetch_cell("SELECT name FROM data_template WHERE id=" . $id["data_template_id"]); echo "NOTE: Data Template '$template_name' is Damaged and can be repaired\n"; } $damaged_templates = db_fetch_assoc("SELECT * FROM data_template_rrd WHERE hash='' AND local_data_id=0"); if (sizeof($damaged_templates)) { echo "NOTE: -- Damaged Data Templates Objects Found is '" . sizeof($damaged_templates) . "'\n"; if ($execute) { foreach($damaged_templates as $template) { $hash = get_hash_data_template($template["local_data_template_rrd_id"], "data_template_item"); db_execute("UPDATE data_template_rrd SET hash='$hash' WHERE id=" . $template["id"]); } } } } else { echo "NOTE: No Damaged Data Templates Found\n"; } /* reset the array */ $damaged_templates = array(); /* repair graph templates */ if ($execute) { echo "NOTE: Repairing Graph Templates\n"; } else { echo "NOTE: Performing Check of Graph Templates\n"; } $damaged_template_ids = db_fetch_assoc("SELECT DISTINCT graph_template_id FROM graph_template_input WHERE hash=''"); if (sizeof($damaged_template_ids)) { foreach($damaged_template_ids as $id) { $template_name = db_fetch_cell("SELECT name FROM graph_templates WHERE id=" . $id["graph_template_id"]); echo "NOTE: Graph Template '$template_name' is Damaged and can be repaired\n"; } $damaged_templates = db_fetch_assoc("SELECT * FROM graph_template_input WHERE hash=''"); if (sizeof($damaged_templates)) { echo "NOTE: -- Damaged Graph Templates Objects Found is '" . sizeof($damaged_templates) . "'\n"; if ($execute) { foreach($damaged_templates as $template) { $hash = get_hash_graph_template(0, "graph_template_input"); db_execute("UPDATE graph_template_input SET hash='$hash' WHERE id=" . $template["id"]); } } } } else { echo "NOTE: No Damaged Graph Templates Found\n"; } /* display_help - displays the usage of the function */ function display_help () { print "Cacti Database Template Repair Tool v1.0, Copyright 2004-2009 - The Cacti Group\n\n"; print "usage: repair_templates.php --execute [--help]\n\n"; print "--execute - Perform the repair\n"; print "--help - display this help message\n"; } ?>