<?php require('_mod_security.php'); ?>
<?php
	echo '<h2>Browse By Category (' . $GLOBALS['total_future_events_count'] . ')</h2>';
	echo '<ul>';
	$ar_category_location = [];
	foreach ($GLOBALS['ar_active_categories'] as $cat_row) :
		if ($cat_row->is_location === 1) :
			$ar_category_location[] = $cat_row;
		else :
			echo '<li><a href="events/categories/' . $cat_row->slug . '/">' . $cat_row->name . '</a> (' . $cat_row->event_count . ')</li>';
		endif;
		//top_menu_item('events/categories/' . $cat_row->slug . '/', $cat_row->name,'', true);
	endforeach;
	//echo '<li><a href="submit-event">... or Submit Your Own Event</a></li>';
	echo '</ul>';

	if (count($ar_category_location) > 0) :
		echo '<hr>';
		echo '<h2>Browse By Location</h2>';
		echo '<ul>';
		foreach ($ar_category_location as $cat_row) :
			echo '<li><a href="events/categories/' . $cat_row->slug . '/">' . $cat_row->name . '</a> (' . $cat_row->event_count . ')</li>';
		endforeach;
		echo '</ul>';
	endif;

	$sql = "SELECT COUNT(s.id) AS show_count FROM obw_shows s 
		WHERE s.status = 1
			AND s.end_date > NOW()
	";
	$rows = db_cached_query($sql);
	$obw_show_count = $rows[0]->show_count;
	echo '<hr>';
	echo '<h2>Browse Off-Broadway</h2>';
	echo '<ul>';
	echo '<li><a href="off-broadway/">Shows</a> (' . $obw_show_count . ')</li>';
	echo '</ul>';