#!/usr/bin/php5 
<?php
define('IMAGE_FORMAT_PNG',              'PNG');
require_once('/etc/zabbix/zabbix.conf.php');

#import example:
#mysqlbinlog --database=zabbix $i | mysql -h host -u user --password=pass

$DB_SERVER=$DB["SERVER"];
if ($DB_SERVER=="" ) $DB_SERVER="localhost";
$DB_USER=$DB["USER"];
$DB_PASSWORD=$DB["PASSWORD"];
$DB_PORT=$DB["PORT"];
$DB_DATABASE=$DB["DATABASE"];

if ($argc < 2 ) { 
     echo "\nPlease run as sudo and give Instrument name. Exiting\n\n"; 
     exit; 
}
$instname=$argv[1];

$sql="select hostid from hosts where hosts.host='$instname'";
exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD |grep -v hostid |grep -v NULL",$hostid);
if (!count($hostid)) { 
   echo "No instrument with that name.";
   exit;
}

$sql="select itemid,type from items where items.hostid='$hostid[0]' order by itemid";
exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD|grep -v itemid |tr $'\\t' ';' ",$items );
if (!count($items)) { 
   echo "No items found.";
   exit;
}

foreach ($items as $item) {
        $c=explode(";",$item);
        $itemid=$c[0];
        $type=$c[1];
          $sql="DELETE FROM history_uint WHERE itemid = '$itemid'";
          exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD",$result);
          $sql="DELETE FROM history WHERE itemid = '$itemid'";
          exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD",$result);
          $sql="DELETE FROM history_str WHERE itemid = '$itemid'";
          exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD",$result);
          $sql="DELETE FROM history_log WHERE itemid = '$itemid'";
          exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD",$result);
          $sql="DELETE FROM history_text WHERE itemid = '$itemid'";
          exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD",$result);
          $sql="DELETE FROM trends_uint WHERE itemid = '$itemid'";
          exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD",$result);
          $sql="DELETE FROM trends WHERE itemid = '$itemid'";
          exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD",$result);
          $sql="UPDATE items SET lastvalue = 'NULL', lastclock = 'NULL'  WHERE itemid ='$itemid'";
          exec("echo \"$sql\"| mysql -h $DB_SERVER $DB_DATABASE -u $DB_USER -p$DB_PASSWORD",$result);
}
?>