delete_abandoned_vehicles.php

<?php

    echo "================================\nDatabase Cleanup Started:\n================================\n";

        // Database Connection Setup
    // -------------------------------------------------------
    $dbhost = '127.0.0.1';
    $dbname = 'exile';
    $dbuser = 'user';
    $dbpass = 'password';
    // -------------------------------------------------------
    $db_local = mysqli_connect($dbhost, $dbuser, $dbpass, $dbname);

    $filePath = 'C:\\xampp\\htdocs\\logs\\';

    if (!file_exists($filePath))
    {
        mkdir($filePath, 0777, true);
    }

    // -------------------------------------------------------

    $time = date('Y-m-d G:i:s');
    $msg = "\n\n";
    $msg .= "======================================================\n";
    $msg .= "Delete abandoned vehicles: $time\n";
    $msg .= "======================================================\n";


    // delete Vehicles not used in 48 hours and not parked in a territory
    $sql = "SELECT * FROM vehicle WHERE last_updated_at < NOW() - INTERVAL 48 HOUR AND last_updated_at <> '0000-00-00 00:00:00'";
    $result = mysqli_query($db_local, $sql);
    $vehicleCount = 0;
    while($row = mysqli_fetch_object($result))
    {
        $VehicleID = $row->id;
        $VehicleClass = $row->class;
        $VehicleX = $row->position_x;
        $VehicleY = $row->position_y;
        $VehicleOwnerUID = $row->account_uid;
        $IsLocked = -1;
        $VehicleLastUpdated = $row->last_updated_at;


        // Create array of territories
        $territoryArray = [];

        $sql3 = "SELECT position_x, position_y, name FROM territory ORDER BY name";
        $result3 = mysqli_query($db_local, $sql3);
        while($row3 = mysqli_fetch_object($result3))
        {
            $position_x = $row3->position_x;
            $position_y = $row3->position_y;
            $territoryName = $row3->name;
            array_push($territoryArray,$position_x.','.$position_y.',100,'.$territoryName);
        }

        $InTerritoryRange = 0;

        foreach ($territoryArray as $coords)
        {
            $territoryCoords = explode(",", $coords);
            $territoryX = $territoryCoords[0];
            $territoryY = $territoryCoords[1];
            $territoryRadius = $territoryCoords[2];
            $territoryName = $territoryCoords[3];

            if ((($VehicleX-$territoryX)**2 + ($VehicleY-$territoryY)**2 <= $territoryRadius**2))     // inside territory
            {
                $InTerritoryRange = 1;
            }
        }
        if($InTerritoryRange == 0) // not in range of a territory
        {
            $vehicleCount = $vehicleCount + 1;
            $sql2 = "SELECT name FROM account WHERE uid = '$VehicleOwnerUID'";
            $result2 = mysqli_query($db_local, $sql2);
            $row2 = mysqli_fetch_object($result2);
            $OwnerName = $row2->name;

            $sql2 = "DELETE FROM vehicle WHERE id = '$VehicleID'";
            $result2 = mysqli_query($db_local, $sql2);
            $IsLocked = 0;
            $msg .=  "$VehicleClass ($VehicleID) abandoned by $OwnerName ($VehicleOwnerUID) at $VehicleLastUpdated has been deleted\n";
        }
    }
    $msg .= "\n=========================================\n$vehicleCount vehicles deleted\n=========================================";

    echo $msg;
    LogChanges($msg,$filePath.'Abandoned.log');
    exit();

    function LogChanges($text,$filename)
    {
      // open log file

      //echo '<hr>'.$filename.'<hr>';
      $fh = fopen($filename, "a") or die("Could not open log file.");
      fwrite($fh, "$text") or die("Could not write file!");
      fclose($fh);
    }
?>