<?php

set_include_path(get_include_path() . PATH_SEPARATOR . $_SERVER['DOCUMENT_ROOT'] . "/PHP/Includes");
include("PageSnippets/header.php");
require_once("jupikd_discord_database.php");
require_once("jupikd_discord_api_key.php");

$query = "SELECT * FROM default_command_permissions";
$stmt = $db->prepare($query);

$stmt->execute();
$result = $stmt->get_result();

if($result->num_rows > 0) {

?>

        <div id="main-container">
            <p style="text-align: justify;"></p>
            <div style="text-align: right;">
                </div>
                <br><br>
        <table class='table table-striped table-hover '>
            <tr>
                <th>Name</th>
                <th>Description</th>
                <th>Usage</th>
                <th>Default Permission</th>
                <th>Uses</th>
                <th>Aliases</th>
            </tr>
            <?php while($row = $result->fetch_assoc()) { ?>
            <tr>
                <td><button class="btn btn-primary" type="button" data-toggle="modal" data-target="#commandModal-<?php echo htmlentities($row["name"]); ?>"><?php echo htmlentities($row["name"]); ?></button></td>
                <td><?php echo htmlentities($row["description"]); ?></td>
                <td><?php echo htmlentities($row["command_usage"]); ?></td>
                <td><?php echo htmlentities($row["permission"]); ?></td>
                <td><?php echo htmlentities($row["uses"]); ?></td>
                <td><?php echo htmlentities($row["aliases"]); ?></td>
            </tr>
            <?php } ?>
        </table>
            </div>

            <?php while($row = $result->fetch_assoc()) { ?>
            <div class="modal fade" id="commandModal-<?php echo htmlentities($row["name"]); ?>">
                <div class="modal-dialog" role="document">
                    <div class="modal-content">
                        <div class="modal-header">
                            <h5 class="modal-title"><?php echo htmlentities($row["name"]); ?></h5>
                            <button type="button" class="close" data-dismiss="modal" aria-label="Close">
                                <span aria-hidden="true">&times;</span>
                            </button>
                        </div>
                        <div class="modal-body">
                            <p>
                                Add more shit here
                            </p>
                        </div>
                        <div class="modal-footer">
                            <button type="button" class="btn btn-secondary" data-dismiss="modal">Close</button>
                        </div>
                    </div>
                </div>
            </div>
            <?php } ?>
        </div>

<?php

include("PageSnippets/footer.php");

    }
?>