Advertisement
Brandan

Untitled

Jul 30th, 2013
382
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.56 KB | None | 0 0
  1. $update_code = strtotime(date("Y-m-d H:i:s"));
  2.  
  3. # import code is somewhere in here 
  4.  
  5.  
  6. // Remove inactive 911 Calls
  7.     $prunesql      = "SELECT * FROM active_911_calls";
  8.     $pruneresult   = mysql_query( $prunesql );
  9.     while ( $prunerows = mysql_fetch_array( $pruneresult ) ) {
  10.         $upcode = (int)$prunerows[ 'update_num' ];
  11.         if ( $upcode != $update_code ) {
  12.             //SQL( "INSERT INTO archive_911_calls SELECT * FROM active_911_calls WHERE GUID='" . $prunerows[ 'GUID' ] . "'" );
  13.             SQL( "DELETE FROM active_911_calls WHERE GUID='" . $prunerows[ 'GUID' ] . "'");
  14.         }
  15.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement