Support

July 26, 2012 at 1:40 am

Hello Everyone,

Spent ages looking for a solution to this, which i couldn’t find so i wrote my own short code to accomplish this add the below code to the shortcode.php file located in – /wp-content/plugins/event-espresso/includes
needs a little work to display the categories properly but this will give you a good start

</p>

<pre>
this is the code

/*
 
  Event Categories
  Displays a list of events by category
  [EVENT_ESPRESSO_CATEGORIES cats="1,2,3,4" links="76,79,86,88"]>
 cats = the categorie id you want to show       links = the page that is category is shown on
 */
if (!function_exists('show_categories')) {
    function show_categories($args) {
        global $wpdb;
    
        define("EVENTS_CATEGORY_TABLE", $wpdb->prefix . "events_category_detail");       
        $catsToShow = explode(",", $args['cats']);
        $pageLinks = explode(",", $args['links']);
        $whereCondition = '';
        if($catsToShow){
            foreach($catsToShow as $catKey => $cat){
                if($catKey == 0)
                    $whereCondition .= "WHERE id='".$cat."'";
                else
                    $whereCondition .= "OR id='".$cat."'";
            }
        }
        
        //$html = print_r($catsToShow);
        //Category sql
        $sql .= 'SELECT * FROM <code>&#039;.$wpdb->prefix . &#039;events_category_detail</code> '.$whereCondition;
        
        $categories = $wpdb->get_results($sql);
        if($categories){        
        //$html = print_r($categories); 
            foreach($categories as $fullKey => $category){
                $html  .= ' ';
                $html .= $category->category_name;
                $html .= '< a href='.get_permalink($pageLinks[$fullKey]).'>category_name.'" >View Information</ a>';
                $html .= '';
            }
            return $html;
        }else{
            return 'Something Went wrong, please make sure the shortcode is entered correctly'; 
        }
        
    }
}
add_shortcode('EVENT_ESPRESSO_CATEGORIES', 'show_categories');

</pre>

<p>

• This topic was modified 12 years, 5 months ago by Roddy Boyd.
• This topic was modified 4 years, 9 months ago by Seth Shoultes.