function show_easy_gallery($atts, $content = null)
{
$order = 'desc';
$pagesql = '';
$limit = '';
$count = 8;
$page = true;
$page_st = true;
$theme = 'fancybox';
$view = 'album';
$album = '';
global $wpdb;
//echo "select * from easy_photos order by $order limit $limit offset $offset";
if (isset($atts['order'])) {
$order = $atts['order'];
}
if (isset($atts['theme'])) {
$theme = trim($atts['theme']);
if ($theme != 'fancybox' && $theme != 'swipebox') {
$theme = 'fancybox';
}
}
if (isset($atts['view'])) {
$view = trim($atts['view']);
if ($view != 'album' && $view != 'image') {
$view = 'album';
}
}
if (isset($atts['album'])) {
$album = trim($atts['album']);
}
if (isset($atts['limit'])) {
$count = trim($atts['limit']);
if ($count < 1) {
$count = 2;
}
}
$order = strtolower($order);
if ($order != 'asc' && $order != 'desc') {
$order = 'desc';
}
if (isset($atts['pagination'])) {
$page_st = trim($atts['pagination']);
if ($page_st != 'true' && $page_st != 'false') {
$page_st = 'true';
}
}
if ($page_st == 'true') {
$page = true;
$sql = " SELECT DISTINCT(a.album_id) FROM easy_album a,easy_photos b WHERE a.album_id=b.album_id AND a.disabled=0 AND b.disabled=0";
if ($album != '') {
$sql = $sql . " and a.album_id = {$album}";
}
if ($view == 'image') {
$sql = "select * from easy_photos where album_id not in(select album_id from easy_album b where b.disabled=1) and disabled=0";
if ($album != '') {
$sql = $sql . " and album_id = {$album}";
}
}
$rows = $wpdb->get_results($sql);
$items = count($rows);
if ($items > 0) {
$p = new pagination();
$p->items($items);
$p->limit($count);
// Limit entries per page
if ($album != '') {
$p->target(get_permalink() . '?album=' . $album);
} else {
$p->target(get_permalink());
}
//$p->urlFriendly();
if (isset($p->paging)) {
$p->currentPage($_GET[$p->paging]);
}
// Gets and validates the current page
$p->calculate();
// Calculates what to show
$p->parameterName('paging');
$p->nextLabel('');
//removing next text
$p->prevLabel('');
//removing previous text
$p->nextIcon('►');
//Changing the next icon
$p->prevIcon('◄');
//Changing the previous icon
$p->adjacents(1);
//No. of page away from the current page
if (!isset($_GET['paging'])) {
$p->page = 1;
} else {
$p->page = $_GET['paging'];
}
//Query for limit paging
$limit = "LIMIT " . ($p->page - 1) * $p->limit . ", " . $p->limit;
} else {
echo "No Images";
}
} else {
$page = false;
}
?>
<div class="easy-gallery-base">
<div class="easy-gallery-content">
<?php
$sql = "";
$tmp_sql = " SELECT DISTINCT(a.album_id) FROM easy_album a,easy_photos b WHERE a.album_id=b.album_id AND a.disabled=0 AND b.disabled=0 ";
if ($album != '') {
$tmp_sql = $tmp_sql . " and a.album_id = {$album}";
}
$tmp_sql = $tmp_sql . " order by album_id {$order} {$limit}";
$rows_tmp = $wpdb->get_results($tmp_sql);
$data = array();
foreach ($rows_tmp as $obj_temp) {
array_push($data, $obj_temp->album_id);
}
$album_list = implode(',', $data);
if ($view == 'image') {
$sql = "select * from easy_photos where album_id not in(select album_id from easy_album b where b.disabled=1) and disabled=0 ";
if ($album != '') {
$sql = $sql . " and album_id = {$album}";
}
$sql = $sql . " order by id {$order} {$limit}";
} else {
$sql = "select a.*,b.album_cover,b.name from easy_photos a,easy_album b where a.album_id = b.album_id and b.disabled=0 and a.disabled=0 and b.album_id in({$album_list}) order by b.album_id {$order}";
}
$rows = $wpdb->get_results($sql);
$aid = "";
$i = 1;
$img_count = count($rows);
if ($view == 'album') {
foreach ($rows as $obj) {
if ($obj->album_id != $aid && $aid != "") {
echo '</div>';
$i = 1;
}
if ($i == 1) {
?>
<div class="album_thumb has-album-name">
<?php
}
if ($i == 1) {
?>
<a href="<?php
echo $obj->image_path;
?>
" class="<?php
echo $theme;
?>
" rel="<?php
echo $obj->album_id;
?>
" title="<?php
echo $obj->description;
?>
">
<img title="<?php
echo $obj->name;
?>
" src="<?php
echo $obj->album_cover;
?>
" />
</a>
<div class="album-name"><?php
if (strlen($obj->name) > 30) {
echo substr($obj->name, 0, 30) . '..';
} else {
echo $obj->name;
}
?>
</div>
<?php
} else {
?>
<a href="<?php
echo $obj->image_path;
?>
" class="<?php
echo $theme;
?>
" rel="<?php
echo $obj->album_id;
?>
" title="<?php
echo $obj->description;
?>
">
</a>
<?php
}
$i++;
if ($img_count == 1) {
$i = 1;
?>
</div>
<?php
}
//else if($obj->album_id!=$aid && $aid!="" and )
//{
//echo $obj->album_id;
// $i=1;
?>
<?php
//}
$aid = $obj->album_id;
?>
<?php
}
if ($img_count > 0) {
echo '</div>';
}
} else {
if ($view == 'image') {
foreach ($rows as $obj) {
?>
<div class="album_thumb">
<p><a class="fancybox" data-fancybox-group="thumb" href="<?php
echo $obj->image_path;
?>
">
<img src="<?php
echo $obj->thumb_path;
?>
" /></a>
</p>
</div>
<?php
}
}
}
?>
<br style="clear:both;" />
</div>
<div>
<?php
if ($page && $items > 0) {
echo $p->show();
}
// Echo out the list of paging.
?>
</div>
</div>
<?php
}
$p->limit(12);
// Limit entries per page
$p->target(get_permalink() . 'admin.php?page=easy-gallery-home');
//$p->urlFriendly();
if (isset($p->paging)) {
$p->currentPage($_GET[$p->paging]);
}
// Gets and validates the current page
$p->calculate();
// Calculates what to show
$p->parameterName('paging');
$p->nextLabel('');
//removing next text
$p->prevLabel('');
//removing previous text
$p->nextIcon('►');
//Changing the next icon
$p->prevIcon('◄');
//Changing the previous icon
$p->adjacents(1);
//No. of page away from the current page
if (!isset($_GET['paging'])) {
$p->page = 1;
} else {
$p->page = $_GET['paging'];
}
//Query for limit paging
$limit = "LIMIT " . ($p->page - 1) * $p->limit . ", " . $p->limit;
}
?>
<div class="easy_album_list">
