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

    include('include/parts/header.php');
    
    $quilts = mysqli_query_logged("SELECT * FROM quilts WHERE id = " . sq($_id));
    if ($quilts_row = mysqli_fetch_assoc($quilts))
    {
        $quilts_permissions = mysqli_query_logged("SELECT * FROM quilts_permissions WHERE user_id = '" . $GLOBALS['auth']['id'] . "' AND quilt_id = " . sq($_id) . " AND permission = 'root'");
        if (!mysqli_num_rows($quilts_permissions))
        {
            header('Location: ./?s=quilts_moderate');
            die;
        }
    }
    else
    {
        header('Location: ./?s=quilts_moderate');
        die;
    }
?>

<div class="header"><a href="?s=quilts_moderate">Moderate Quilts</a> - Modify An Existing Quilt</div>

<div class="content">
<?php
    if (isset($errors))
    {
        echo '<span style="color: red;">' . $errors . '</span>';
        echo '<div style="padding: 10px 0px 0px 0px;"></div>';
    }
?>
<form action="?a=quilt_edit&i=<?php echo $_id ?>" method="post" style="margin: 0px; display: inline;">
<table width="100%" border="0">
<tr><td width="150" style="text-align: right;">Quilt Name:</td><td><input name="name" size="40" value="<?php echo (isset($_name) ? htmlspecialchars(stripslashes($quilts_row['name'])) : htmlspecialchars($quilts_row['name'])) ?>" style="border: solid 2px black; margin: 0px; padding: 3px;"></td></tr>
<tr><td width="150" style="text-align: right;">Quilt Description:</td><td><textarea name="description" style="width: 400px; height: 100px; border: solid 2px black; margin: 0px; padding: 3px;"><?php echo (isset($_description) ? htmlspecialchars(atripslashes($_description)) : htmlspecialchars($quilts_row['description'])) ?></textarea></td></tr>
<tr><td width="150" style="text-align: right;">Hours To Complete:</td><td><input name="timelimit" size="5" value="<?php echo intval($quilts_row['timelimit'] / 60 / 60) ?>" style="border: solid 2px black; margin: 0px; padding: 3px;"> (1 to 72)</td></tr>
<tr><td width="150" style="text-align: right;">Choose Multiple Tiles:</td><td><select name="multiple" style="width: 75px; border: solid 2px black; margin: 0px; padding-top: 1px; padding-bottom: 1px;">
<?php
    for ($i = 1; $i <= 10; $i++)
    {
        echo '<option value="' . $i . '"' . ($quilts_row['multiple'] == $i ? ' selected' : '') . '>' . $i . '</option>' . "\r\n";
    }
?>
</select> Allow user to checkout multiple tiles.
</td></tr>
<tr><td width="150" style="text-align: right;">Side Pixels To Display:</td><td><select name="side_pixels" style="width: 75px; border: solid 2px black; margin: 0px; padding-top: 1px; padding-bottom: 1px;">
<option value="15"<?php echo ($quilts_row['side_pixels'] == 15) ? ' selected' : '' ?>>15</option>
<option value="16"<?php echo ($quilts_row['side_pixels'] == 16) ? ' selected' : '' ?>>16</option>
<option value="20"<?php echo ($quilts_row['side_pixels'] == 20) ? ' selected' : '' ?>>20</option>
<option value="24"<?php echo ($quilts_row['side_pixels'] == 24) ? ' selected' : '' ?>>24</option>
<option value="25"<?php echo ($quilts_row['side_pixels'] == 25) ? ' selected' : '' ?>>25</option>
<option value="30"<?php echo ($quilts_row['side_pixels'] == 30) ? ' selected' : '' ?>>30</option>
<option value="32"<?php echo ($quilts_row['side_pixels'] == 32) ? ' selected' : '' ?>>32</option>
<option value="35"<?php echo ($quilts_row['side_pixels'] == 35) ? ' selected' : '' ?>>35</option>
<option value="40"<?php echo ($quilts_row['side_pixels'] == 40) ? ' selected' : '' ?>>40</option>
<option value="45"<?php echo ($quilts_row['side_pixels'] == 45) ? ' selected' : '' ?>>45</option>
<option value="50"<?php echo ($quilts_row['side_pixels'] == 50) ? ' selected' : '' ?>>50</option>
</select> Pixels user has on the checkout tile to work with.
</td></tr>
<tr><td width="150" style="text-align: right;">Quilt Level:</td><td><select name="level" style="width: 100px; border: solid 2px black; margin: 0px; padding-top: 1px; padding-bottom: 1px;">
<option value="0"<?php echo ($quilts_row['level'] == 0) ? ' selected' : '' ?>>Beginner</option>
<option value="1"<?php echo ($quilts_row['level'] == 1) ? ' selected' : '' ?>>Intermediate</option>    
<option value="2"<?php echo ($quilts_row['level'] == 2) ? ' selected' : '' ?>>Advanced</option>    
</select>
</td></tr>
<tr><td width="150" style="text-align: right;">Photographs Allowed:</td><td><select name="photographs_allowed" style="width: 100px; border: solid 2px black; margin: 0px; padding-top: 1px; padding-bottom: 1px;">
<option value="0"<?php echo ($quilts_row['photographs_allowed'] == 0) ? ' selected' : '' ?>>No</option>
<option value="1"<?php echo ($quilts_row['photographs_allowed'] == 1) ? ' selected' : '' ?>>Yes</option>    
</select>
</td></tr>
<tr><td width="150" style="text-align: right;">Tiles Visible:</td><td><select name="show_all" style="width: 300px; border: solid 2px black; margin: 0px; padding-top: 1px; padding-bottom: 1px;">
<option value="0"<?php echo ($quilts_row['show_all'] == 0) ? ' selected' : '' ?>>When Neighbours Are Finished</option>
<option value="1"<?php echo ($quilts_row['show_all'] == 1) ? ' selected' : '' ?>>Instantly</option>    
<option value="2"<?php echo ($quilts_row['show_all'] == 2) ? ' selected' : '' ?>>When Whole Quilt Is Complete</option>    
</select>
</td></tr>
<tr><td width="150" style="text-align: right;">Can Work On Tiles:</td><td><select name="work_on_all" style="width: 300px; border: solid 2px black; margin: 0px; padding-top: 1px; padding-bottom: 1px;">
<option value="0"<?php echo ($quilts_row['work_on_all'] == 0) ? ' selected' : '' ?>>Not Next To Your Own</option>
<option value="1"<?php echo ( $quilts_row['work_on_all'] == 1) ? ' selected' : '' ?>>Even Ones Next To Your Own</option>    
</select>
</td></tr>
<tr><td width="150" style="text-align: right;">Checkout Tile:</td><td><select name="start_anywhere" style="width: 300px; border: solid 2px black; margin: 0px; padding-top: 1px; padding-bottom: 1px;">
<option value="0"<?php echo ($quilts_row['start_anywhere'] == 0) ? ' selected' : '' ?>>Only Next To An Existing Tile</option>
<option value="1"<?php echo ($quilts_row['start_anywhere'] == 1) ? ' selected' : '' ?>>Anywhere Thats Available</option>    
</select>
</td></tr>
<tr><td width="150" style="text-align: right;">Moderated:</td><td><select name="moderated" style="width: 100px; border: solid 2px black; margin: 0px; padding-top: 1px; padding-bottom: 1px;">
<option value="0"<?php echo ($quilts_row['moderated'] == 0) ? ' selected' : '' ?>>No</option>
<option value="1"<?php echo ($quilts_row['moderated'] == 1) ? ' selected' : '' ?>>Yes</option>    
</select>
</td></tr>
<tr><td width="150" style="text-align: right;"></td><td><input type="submit" value="Edit Quilt Properties" style="border: solid 1px green; background: black; color: green;"></td></tr>
</table>
</form>
</div>

<div class="header">Moderators</div>

<div class="content">
<form action="?a=quilt_moderator_add&i=<?php echo $_id ?>" method="post" style="margin: 0px; display: inline;">
<table width="100%" border="0">
<tr>
<td width="150" style="text-align: right;">Moderator:</td>
<td><input name="name" style="border: solid 2px black; margin: 0px; padding: 3px;"></td>
</tr>
<tr>
<td width="150" style="text-align: right;"></td>
<td><input type="submit" value="Add Moderator" style="border: solid 1px green; background: black; color: green;"></td>
</tr>
</table>
</form>
<?php
    $quilts_permissions = mysqli_query_logged("SELECT * FROM quilts_permissions INNER JOIN members ON quilts_permissions.user_id = members.id WHERE quilts_permissions.quilt_id = " . sq($_id) . " ORDER BY quilts_permissions.permission DESC, members.username");
    if (mysqli_num_rows($quilts_permissions))
    {
        echo '<div style="padding: 5px 0px 0px 0px;"></div>';
        echo '<div class="patch_fill">';
        while ($quilts_permissions_row = mysqli_fetch_array($quilts_permissions))
        {
            echo $quilts_permissions_row['permission'] == 'root' ? '[ <span class="error">Remove</span> ] ' : '[ <a href="?a=quilt_moderator_remove&i=' . $_id . '&u=' . $quilts_permissions_row['username'] . '">Remove</a> ] ';
            echo $quilts_permissions_row['permission'] == 'root' ? '[ <span style="color: green;">ROOT</span> ] [ MODERATOR ] ' : ' [ ROOT ] [ <span style="color: green;">MODERATOR</span> ] ';
            echo '<a href="?s=profile&u=' . $quilts_permissions_row['username'] . '">' . $quilts_permissions_row['username'] . '</a><br />';
        }
        echo '</div>';
    }
?>
</div>

<div class="header">Members Allowed (Not Working Yet)</div>

<div class="content">
<form action="?a=quilt_invites_add&i=<?php echo $_id ?>" method="post" style="margin: 0px; display: inline;">
<table width="100%" border="0">
<tr>
<td width="150" style="text-align: right;">Username:</td>
<td><input name="name" style="border: solid 2px black; margin: 0px; padding: 3px;"></td>
</tr>
<tr>
<td width="150" style="text-align: right;"></td>
<td><input type="submit" value="Add User" style="border: solid 1px green; background: black; color: green;"></td>
</tr>
</table>
</form>
<div style="padding: 5px 0px 0px 0px;"></div>
<div class="patch_fill">
<?php
    $quilts_invites = mysqli_query_logged("SELECT * FROM quilts_invites INNER JOIN members ON quilts_invites.user_id = members.id WHERE quilts_invites.quilt_id = " . sq($_id) . " ORDER BY members.username");
    if (mysqli_num_rows($quilts_invites))
    {
        while ($quilts_invites_row = mysqli_fetch_array($quilts_invites))
        {
            echo '[ <a href="?a=quilt_invites_remove&i=' . $_id . '&u=' . $quilts_invites_row['username'] . '">Remove</a> ] ';
            echo $quilts_invites_row['active'] ? '[ <span style="color: green;">Active</span> ] [ Pending ] ' : ' [ Active ] [ <span style="color: green;">Pending</span> ] [ <a href="?a=quilt_invites_remove&i=' . $_id . '&u=' . $quilts_invites_row['username'] . '">Accept User</a> ]';
            echo '<a href="?s=profile&u=' . $quilts_invites_row['username'] . '">' . $quilts_invites_row['username'] . '</a><br />';
        }
    }
    else
    {
        echo 'All members are allowed to work on this quilt.';
    }
?>
</div>
</div>

<?php
    include('include/parts/footer.php');
?>