»" * */ function pageList($curpage, $pages) { //Pagination $page_list = ""; if ($search != '') { $self = '?page=' . slideAlbum; } else { $self = '?page=' . slideAlbum; } /* Print the first and previous page links if necessary */ if (($curpage != 1) && ($curpage)) { $page_list .= " << "; } if (($curpage - 1) > 0) { $page_list .= "< "; } /* Print the numeric page list; make the current page unlinked and bold */ for ($i = 1; $i <= $pages; $i++) { if ($i == $curpage) { $page_list .= "" . $i . ""; } else { $page_list .= "" . $i . ""; } $page_list .= " "; } /* Print the Next and Last page links if necessary */ if (($curpage + 1) <= $pages) { $page_list .= "> "; } if (($curpage != $pages) && ($pages != 0)) { $page_list .= ">> "; } $page_list .= "\n"; return $page_list; } /* * string nextPrev (int curpage, int pages) * Returns "Previous | Next" string for individual pagination (it's a word!) */ function nextPrev($curpage, $pages) { //Pagination $next_prev = ""; if (($curpage - 1) <= 0) { $next_prev .= "Previous"; } else { $next_prev .= "Previous"; } $next_prev .= " | "; if (($curpage + 1) > $pages) { $next_prev .= "Next"; } else { $next_prev .= "Next"; } return $next_prev; } //End of Pagination $folder = dirname(dirname(plugin_basename(__FILE__))); $i=0; $viewSetting = $wpdb->get_row("SELECT * FROM " . $wpdb->prefix . "asgall_settings_menu"); $count_result = mysql_query("SELECT * FROM " . $wpdb->prefix . "asgallalbum WHERE is_delete=0"); //print_r($count_result);exit; $site_url = get_bloginfo('url'); $limit =20; $start = findStart($limit); if ($_REQUEST['pages'] == 'viewAll') { $w = ''; } else if(!isset($_REQUEST['pages'])) { $w= ''; } else { $w = "LIMIT " . $start . "," . $limit; } $count = mysql_num_rows($count_result); /* Find the number of pages based on $count and $limit */ $pages = findPages($count, $limit); /* Now we use the LIMIT clause to grab a range of rows */ $res = $wpdb->get_results("SELECT * ,asgallGallery_name FROM " . $wpdb->prefix . "asgallalbum ," . $wpdb->prefix . "asgallgallery where ". $wpdb->prefix . "asgallgallery.".asgallGallery_id."=". $wpdb->prefix . "asgallalbum." . asgallGallery_id. " and is_delete=0 ORDER BY asgallAlbum_id DESC" ); //echo "
"; print_r($res); echo "";
$album ='';
$uploadDir = wp_upload_dir();
$path = $uploadDir['baseurl'].'/apptha-slider-gallery';
?>
| Image | Album Name | Description | Status | Album Id | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| "; $album .= " | "; if(file_exists($file_image) && $results->asgallAlbum_image != '') { $temp_img = explode('_',$results->asgallAlbum_image); $get_ext = explode('.',$temp_img[1]); $get_albimg = $temp_img[0].'_albumthumb.'.$get_ext[1]; $album .="
| ";
}
else if(!file_exists($file_image)){
$album .="
| ";
}
else
{
$album .="
| ";
}
$album .="
".$results->asgallAlbum_name."
| ";
$album .="".$results->asgallAlbum_description." ";
$album .=" | ";
if($results->asgallAlbum_status == 'ON')
{
$album .= "$results->asgallAlbum_id | "; // $album .="$results->macGallery_name | "; $album .="View Images | "; $album .="Add Images |