AND images.images_active = "1"
AND images.images_deleted = "0"
) AS "images"
FROM galleries
WHERE galleries_active = "1"
AND galleries_deleted = "0"
' . $order_by . ' ';
$result = mysqli_query($db, $query);
$gallery_count = 1;
while ($gallery = mysqli_fetch_array($result)) {
$first_image = getFirstImage($gallery['galleries_id']);
echo '
<div class="panel panel-default">
<div class="panel-heading"><span style="font-weight: bold;">Gallery #' . $gallery_count . ':</span> ' . $gallery['galleries_title'] . '</div>
<div class="panel-body">
<img src="' . $first_image['images_prefix'] . '/' . $first_image['images_filename'] . '" style="width: 80px; float: left; margin-right: 15px;"/>
Gallery imported at ' . $gallery['galleries_created'] . ', contains ' . countImagesInGallery($gallery['galleries_id']) . ' pictures.<br/>
<a href="index.php?show=gallery&id=' . $gallery['galleries_id'] . '" class="btn btn-sm btn-default">Show Gallery</a>
<a href="' . $gallery['galleries_link'] . '" target="_blank" class="btn btn-sm btn-default">Open Source Page</a>
</div>
</div>
';
$gallery_count++;
}
?>
</div>
</div>
</div>
</div>
</div>
<div class="container">
<div class="row">
<div class="col-xs-12">
<?php
if (isset($_GET['id'])) {
$query = 'SELECT * FROM galleries WHERE galleries_id = "' . $_GET['id'] . '" AND galleries_active = "1" AND galleries_deleted = "0" ';
$result = mysqli_query($db, $query);
$gallery = mysqli_fetch_array($result);
$pictures = countImagesInGallery($gallery['galleries_id']);
$pages = ceil($pictures / 12);
if (!isset($_GET['page'])) {
$_GET['page'] = 1;
}
echo '
<h2>' . $gallery['galleries_title'] . '</h2>
<p>Gallery imported at ' . $gallery['galleries_created'] . ', contains ' . $pictures . ' pictures.</p>
<a href="index.php" class="btn btn-default">Galleries List</a>
';
if ($pages == 1) {
echo '
<nav>
<ul class="pagination">
<li class="disabled"><a href="#" aria-label="Previous"><span aria-hidden="true">«</span></a></li>
<li class="active"><a href="#">1</a></li>
<li class="disabled"><a href="#" aria-label="Next"><span aria-hidden="true">»</span></a></li>
</ul>
</nav>
';
} else {
$page_next = $_GET['page'] + 1;
$page_prev = $_GET['page'] - 1;
