function show_theme()
{
global $wpdb;
$order = "";
$where = '';
$sort["sortid_by"] = '';
$order = '';
$sort["custom_style"] = '';
$sort["1_or_2"] = '';
$search_tag = '';
$sort["default_style"] = "manage-column column-autor sortable desc";
if (isset($_POST['page_number'])) {
if ($_POST['asc_or_desc']) {
$sort["sortid_by"] = $wpdb->escape($_POST['order_by']);
if ($_POST['asc_or_desc'] == 1) {
$sort["custom_style"] = "manage-column column-title sorted asc";
$sort["1_or_2"] = "2";
$order = "ORDER BY " . $sort["sortid_by"] . " ASC";
} else {
$sort["custom_style"] = "manage-column column-title sorted desc";
$sort["1_or_2"] = "1";
$order = "ORDER BY " . $sort["sortid_by"] . " DESC";
}
}
if ($_POST['page_number']) {
$limit = ((int) $_POST['page_number'] - 1) * 20;
} else {
$limit = 0;
}
} else {
$limit = 0;
}
if (isset($_POST['search_events_by_title'])) {
$search_tag = esc_html($_POST['search_events_by_title']);
} else {
$search_tag = "";
}
if ($search_tag) {
$where = ' WHERE title LIKE "%' . $search_tag . '%"';
$where .= " AND `id` NOT IN (" . get_option('contact_form_themes', 0) . ")";
} else {
$where = " WHERE `id` NOT IN (" . get_option('contact_form_themes', 0) . ")";
}
if ($order == "") {
$order = "ORDER BY `title` ASC";
}
// get the total number of records
$query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "formmaker_themes" . $where;
$total = $wpdb->get_var($query);
$pageNav['total'] = $total;
$pageNav['limit'] = $limit / 20 + 1;
$query = "SELECT * FROM " . $wpdb->prefix . "formmaker_themes" . $where . " " . $order . " " . " LIMIT " . $limit . ",20";
$rows = $wpdb->get_results($query);
html_show_theme($rows, $pageNav, $sort);
}
function show_theme()
{
global $wpdb;
$sort["default_style"] = "manage-column column-autor sortable desc";
$sort["custom_style"] = 'manage-column column-autor sortable desc';
$sort["1_or_2"] = 1;
$where = '';
$order = '';
$search_tag = '';
$sort["sortid_by"] = 'title';
if (isset($_POST['page_number'])) {
if ($_POST['asc_or_desc']) {
$sort["sortid_by"] = esc_sql(esc_html(stripslashes($_POST['order_by'])));
if ($_POST['asc_or_desc'] == 1) {
$sort["custom_style"] = "manage-column column-title sorted asc";
$sort["1_or_2"] = "2";
$order = "ORDER BY " . $sort["sortid_by"] . " ASC";
} else {
$sort["custom_style"] = "manage-column column-title sorted desc";
$sort["1_or_2"] = "1";
$order = "ORDER BY " . $sort["sortid_by"] . " DESC";
}
}
if ($_POST['page_number']) {
$limit = (esc_sql(esc_html(stripslashes($_POST['page_number']))) - 1) * 20;
} else {
$limit = 0;
}
} else {
$limit = 0;
}
if (isset($_POST['search_events_by_title'])) {
$search_tag = esc_sql(esc_html(stripslashes($_POST['search_events_by_title'])));
} else {
$search_tag = "";
}
if ($search_tag) {
$where = ' WHERE title LIKE "%' . $search_tag . '%"';
}
// get the total number of records
$query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "Spider_Video_Player_theme" . $where;
$total = $wpdb->get_var($query);
$pageNav['total'] = $total;
$pageNav['limit'] = $limit / 20 + 1;
$query = "SELECT * FROM " . $wpdb->prefix . "Spider_Video_Player_theme" . $where . " " . $order . " " . " LIMIT " . $limit . ",20";
$rows = $wpdb->get_results($query);
html_show_theme($rows, $pageNav, $sort);
}
