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: