Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?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 date(from_unixtime(dateline)) < '2016-01-01'");
- 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.";
- }
- ?>
Add Comment
Please, Sign In to add comment