1: #!/usr/bin/php -q
  2: <?php
  3: require("include.php");
  4: $NATS->Start();
  5: 
  6: $day=60*60*24;
  7: $nowx=time();
  8: 
  9: $ret_alert=$NATS->Cfg->Get("retain,alert",356);
 10: $ret_testrun=$NATS->Cfg->Get("retain.testrun",30);
 11: $ret_records=$NATS->Cfg->Get("retain.record",356);
 12: 
 13: if ($ret_alert>0)
 14: 	{
 15: 	$q="SELECT alertid FROM fnalert WHERE closedx<".($nowx-($day*$ret_alert));
 16: 	$r=$NATS->DB->Query($q);
 17: 	$del_alert=0;
 18: 	$del_aa=0;
 19: 	while ($row=$NATS->DB->Fetch_Array($r))
 20: 		{
 21: 		$alid=$row['alertid'];
 22: 		$q="DELETE FROM fnalertlog WHERE alertid=".$row['alertid'];
 23: 		$NATS->DB->Query($q);
 24: 		$del_aa+=$NATS->DB->Affected_Rows();
 25: 		$q="DELETE FROM fnalert WHERE alertid=".$row['alertid'];
 26: 		$NATS->DB->Query($q);
 27: 		$del_alert++;
 28: 		}
 29: 	echo "Deleted ".$del_alert." Alerts\n";
 30: 	echo "Deleted ".$del_aa." Alert Log Entries\n";
 31: 	}
 32: 
 33: if ($ret_testrun>0)
 34: 	{
 35: 	$q="DELETE FROM fntestrun WHERE startx<".($nowx-($day*$ret_testrun));
 36: 	$NATS->DB->Query($q);
 37: 	$del_testrun=$NATS->DB->Affected_Rows();
 38: 	echo "Deleted ".$del_testrun." Test Runs\n";
 39: 	}
 40: 
 41: if ($ret_records>0)
 42: 	{
 43: 	$q="DELETE FROM fnrecord WHERE recordx<".($nowx-($day*$ret_records));
 44: 	$NATS->DB->Query($q);
 45: 	$del_records=$NATS->DB->Affected_Rows();
 46: 	echo "Deleted ".$del_records." Result Records\n";
 47: 	}
 48: 
 49: $q="DELETE FROM fnsession WHERE updatex<".($nowx-$day); // live unaffected
 50: $NATS->DB->Query($q);
 51: $del_sessions=$NATS->DB->Affected_Rows();
 52: echo "Deleted ".$del_sessions." Stale Sessions\n";
 53: 
 54: $NATS->Stop();
 55: 
 56: ?>
 57: 
 58: