<?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) . " AND permission = 'root'");
    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_pending = mysqli_query_logged("SELECT * FROM tiles_pending WHERE quilt_id = '" . $quilts_row['id'] . "'");
            if (!mysqli_num_rows($tiles_pending))
            {
                $number = $quilts_row['quilt_width'] * $quilts_row['quilt_height'];
                 $tiles = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $quilts_row['id'] . "' AND deleted = '0'");
                if ($number == mysqli_num_rows($tiles))
                {
                     mysqli_query_logged("UPDATE quilts SET finished = '1' WHERE id = '" . $quilts_row['id'] . "'");
                }
            }
        }
    }

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