<?php
    $_id = isset($_GET['i']) ? intval($_GET['i']) : 0;

    $quilts_permissions = mysqli_query_logged("SELECT * FROM quilts_permissions WHERE user_id = '" . $GLOBALS['auth']['id'] . "' AND quilt_id = " . sq($_id));
    if ($quilts_permissions_row = mysqli_fetch_array($quilts_permissions))
    {
         $quilts = mysqli_query_logged("SELECT * FROM quilts WHERE id = '" . $quilts_permissions_row['quilt_id'] . "'");
        if ($quilts_row = mysqli_fetch_array($quilts))
        {
             $tiles = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $quilts_row['id'] . "'");
            $tiles_pending = mysqli_query_logged("SELECT * FROM tiles_pending WHERE quilt_id = '" . $quilts_row['id'] . "'");
            if (!mysqli_num_rows($tiles) && !mysqli_num_rows($tiles_pending))
            {
                 mysqli_query_logged("DELETE FROM quilts WHERE id = '" . $quilts_row['id'] . "'");
                 mysqli_query_logged("DELETE FROM quilts_comments WHERE link_id = '" . $quilts_row['id'] . "'");
                mysqli_query_logged("DELETE FROM quilts_permissions WHERE user_id = '" . $GLOBALS['auth']['id'] . "' AND quilt_id = '" . $quilts_row['id'] . "'");
            }
        }
    }

    header('Location: ./?s=quilts_moderate');
    die;
?>