<?php
    function tile_get_sides($id, $x, $y, $center = 0)
    {
        $return = '';
        $quilts = mysqli_query_logged("SELECT * FROM quilts WHERE id = '" . $id . "'");
        if ($quilts_row = mysqli_fetch_array($quilts))
        {
            //DO THE WRAP AROUND
            $x_plus = $x + 1;
            $x_minus = $x - 1;
            $y_plus = $y + 1;
            $y_minus = $y - 1;
            if ($quilts_row['edge_wrap'] == 1 || $quilts_row['edge_wrap'] == 3)
            {
                if ($x_plus > $quilts_row['quilt_width'])
                {
                    $x_plus = 1;
                }
                if ($x_minus < 1)
                {
                    $x_minus = $quilts_row['quilt_width'];
                }
            }
            if ($quilts_row['edge_wrap'] == 2 || $quilts_row['edge_wrap'] == 3)
            {
                if ($y_plus > $quilts_row['quilt_height'])
                {
                    $y_plus = 1;
                }
                if ($y < 1)
                {
                    $y_minus = $quilts_row['quilt_height'];
                }
            }
            //TOP LEFT
            $tiles_new = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $id . "' AND matrix_x = '" . $x_minus . "' AND matrix_y = '" . $y_minus . "' AND visibility >= '0' AND deleted = '0'");
            if ($tiles_new_row = mysqli_fetch_assoc($tiles_new))
            {
                $return .= 'TL';
            }
            //TOP CENTER
            $tiles_new = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $id . "' AND matrix_x = '" . $x . "' AND matrix_y = '" . $y_minus . "' AND visibility >= '0' AND deleted = '0'");
            if ($tiles_new_row = mysqli_fetch_assoc($tiles_new))
            {
                $return .= 'TC';
            }
            //TOP RIGHT
            $tiles_new = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $id . "' AND matrix_x = '" . $x_plus . "' AND matrix_y = '" . $y_minus . "' AND visibility >= '0' AND deleted = '0'");
            if ($tiles_new_row = mysqli_fetch_assoc($tiles_new))
            {
                $return .= 'TR';
            }
            //MIDDLE LEFT
            $tiles_new = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $id . "' AND matrix_x = '" . $x_minus . "' AND matrix_y = '" . $y . "' AND visibility >= '0' AND deleted = '0'");
            if ($tiles_new_row = mysqli_fetch_assoc($tiles_new))
            {
                $return .= 'ML';
            }
            if ($center)
            {
                //MIDDLE CENTER
                $tiles_new = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $id . "' AND matrix_x = '" . $x . "' AND matrix_y = '" . $y . "' AND visibility >= '0' AND deleted = '0'");
                if ($tiles_new_row = mysqli_fetch_assoc($tiles_new))
                {
                    $return .= 'MC';
                }
            }
            //MIDDLE RIGHT
            $tiles_new = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $id . "' AND matrix_x = '" . $x_plus . "' AND matrix_y = '" . $y . "' AND visibility >= '0' AND deleted = '0'");
            if ($tiles_new_row = mysqli_fetch_assoc($tiles_new))
            {
                $return .= 'MR';
            }
            //BOTTOM LEFT
            $tiles_new = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $id . "' AND matrix_x = '" . $x_minus . "' AND matrix_y = '" . $y_plus . "' AND visibility >= '0' AND deleted = '0'");
            if ($tiles_new_row = mysqli_fetch_assoc($tiles_new))
            {
                $return .= 'BL';
            }
            //BOTTOM CENTER
            $tiles_new = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $id . "' AND matrix_x = '" . $x . "' AND matrix_y = '" . $y_plus . "' AND visibility >= '0' AND deleted = '0'");
            if ($tiles_new_row = mysqli_fetch_assoc($tiles_new))
            {
                $return .= 'BC';
            }
            //BOTTOM RIGHT
            $tiles_new = mysqli_query_logged("SELECT * FROM tiles WHERE quilt_id = '" . $id . "' AND matrix_x = '" . $x_plus . "' AND matrix_y = '" . $y_plus . "' AND visibility >= '0' AND deleted = '0'");
            if ($tiles_new_row = mysqli_fetch_assoc($tiles_new))
            {
                $return .= 'BR';
            }
        }
        return $return;
    }
?>