After Publishing your own style of template:
Step 1 : Please Go To Admin Menu->Apperance->Editor
Step 2 : Select your theme in top select box and go to file header.php
Step 3 : Add the following code above/below "</div> <!-- #header >" depends on your theme.
Available Banner Style
»"
* */
function pageList($curpage, $pages) {
//Pagination
$page_list = "";
if ($search != '') {
$self = '?page=' . banner_show;
} else {
$self = '?page=' . banner_show;
}
/* Print the first and previous page links if necessary */
if (($curpage != 1) && ($curpage)) {
$page_list .= " First ";
}
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 .= "Last ";
}
$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
$count = $wpdb->get_var("SELECT count(*) FROM " . $wpdb->prefix . "bannertemp");
$limit = 9;
$start = findStart($limit);
/* 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 */
$rst_show = $wpdb->get_results("SELECT bann_tempid,bann_tempname,bann_tempimg,bann_status FROM " . $wpdb->prefix . "bannerstyles WHERE bann_status='OFF' ORDER BY bann_tempid ASC LIMIT $start,$limit");
foreach ($rst_show as $show) {
?>