function show_event_cat()
{
global $wpdb;
$order = " ORDER BY title ASC";
$sort["default_style"] = "manage-column column-autor sortable desc";
$sort["sortid_by"] = "title";
$sort["custom_style"] = "manage-column column-title sorted asc";
$sort["1_or_2"] = "2";
if (isset($_POST['page_number'])) {
if (isset($_POST['order_by']) && esc_html($_POST['order_by']) != '') {
$sort["sortid_by"] = esc_sql(esc_html(stripslashes($_POST['order_by'])));
}
if (isset($_POST['asc_or_desc']) && esc_html($_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 (isset($_POST['page_number']) && esc_html($_POST['page_number'])) {
$limit = (esc_sql(esc_html(stripslashes($_POST['page_number']))) - 1) * 20;
} else {
$limit = 0;
}
} else {
$limit = 0;
}
if (isset($_POST['search_cat_by_title'])) {
$search_tag = esc_sql(esc_html(stripslashes($_POST['search_cat_by_title'])));
} else {
$search_tag = "";
}
if ($search_tag) {
$where = ' WHERE title LIKE "%%' . like_escape($search_tag) . '%%"';
} else {
$where = ' ';
}
// Get the total number of records.
$query = "SELECT COUNT(*) FROM " . $wpdb->prefix . "spidercalendar_event_category" . str_replace('%%', '%', $where);
$total = $wpdb->get_var($query);
$pageNav['total'] = $total;
$pageNav['limit'] = $limit / 20 + 1;
$query = $wpdb->prepare("SELECT * FROM " . $wpdb->prefix . "spidercalendar_event_category" . $where . " " . $order . " " . " LIMIT %d,20", $limit);
$rows = $wpdb->get_results($query);
// display function
show_event_category($rows, $pageNav, $sort);
}
case 'save_event_category':
case 'apply_event_category':
save_event_category();
break;
case 'remove_event_category':
remove_event_category();
remove_event_category_events();
break;
case 'publish_event_category':
change_event_category(1);
break;
case 'unpublish_event_category':
change_event_category(0);
break;
case 'event_category':
show_event_category();
JSubMenuHelper::addEntry(JText::_('Calendar'), 'index.php?option=com_spidercalendar&task=calendar');
JSubMenuHelper::addEntry(JText::_('Event Category'), 'index.php?option=com_spidercalendar&task=event_category', true);
JSubMenuHelper::addEntry(JText::_('Themes'), 'index.php?option=com_spidercalendar&task=theme');
JSubMenuHelper::addEntry(JText::_('Plugin Code Generator'), 'index.php?option=com_spidercalendar&task=plugin');
JSubMenuHelper::addEntry(JText::_('Licensing'), 'index.php?option=com_spidercalendar&task=license');
break;
case 'cancel_event_category':
cancel_event_category();
break;
case 'cancel_event_category':
cancel_event_category();
break;
////////////
////////////
default:
