<?php
$databasehost = ""; $databasename = ""; $databaseusername =""; $databasepassword = "";

$foundAny = 0;

$con = @mysql_connect($databasehost,$databaseusername,$databasepassword) or die(mysql_error()); @mysql_select_db($databasename) or die(mysql_error());

$result = mysql_query("select ticketid from swtickets where departmentid = 0");
echo "Starting cleanup Process<br />";
while($row = mysql_fetch_array($result))
  {
$foundAny = 1;
$delete = mysql_query("delete from swticketpostlocks where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketpostlocks Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketlocks where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketlocks Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketlinkchains where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketlinkchains Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketfollowups where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketfollowups Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketdrafts where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketdrafts Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swattachments where ticketid = " . $row['ticketid']);
//echo "Deleting: swattachments Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swescalationpaths where ticketid = " . $row['ticketid']);
//echo "Deleting: swescalationpaths Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketnotes where linktypeid = " . $row['ticketid']);
//echo "Deleting: swticketnotes Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketauditlogs where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketauditlogs Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketlinkedtables where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketlinkedtables Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketlinks where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketlinks Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketmergelog where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketmergelog Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketmessageids where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketmessageids Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketnotes where linktypeid = " . $row['ticketid']);
//echo "Deleting: swticketnotes Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketposts where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketposts Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketrecipients where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketrecipients Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swticketwatchers where ticketid = " . $row['ticketid']);
//echo "Deleting: swticketwatchers Result:" . print_r ($delete). "<br />";
$delete = mysql_query("delete from swcustomfieldvalues where typeid = " . $row['ticketid']);
//echo "Deleting: swcustomfieldvalues Result:" . print_r ($delete). "<br />";
$result2 = mysql_query("select tickettimetrackid from swtickettimetracks where ticketid = " . $row['ticketid']);
while($row2 = mysql_fetch_array($result2))
  {

$delete = mysql_query("delete from swtickettimetracknotes where tickettimetrackid = " . $row2['tickettimetrackid']);
//echo "Deleting: swtickettimetracknotes Result:" . print_r ($delete). "<br />";

  }

$delete = mysql_query("delete from swtickettimetracks where ticketid = " . $row['ticketid']);
//echo "Deleting: swtickettimetracks Result:" . print_r ($delete). "<br />";

$delete = mysql_query("delete from swtickets where ticketid = " . $row['ticketid']);
echo "Deleting: swtickets -" .$row['ticketid'] ." Result:" . print_r ($delete). "<br />";
  }



@mysql_close($con);
 if ($foundAny == 0)
  {
echo "No tickets where found within that date range";
  }
  else{

echo "Ticket Cleanup Complete.";
  }
?>