// ================================================================================================================ standard nav

$csi_events_categories_query = mysql_query(“SELECT * FROM wp_events_categories”);

echo ”

“;

while ($csi_events_categories = mysql_fetch_array($csi_events_categories_query))
{
$csi_events_categories_id = $csi_events_categories['id'];
$csi_events_categories_name = $csi_events_categories['name'];
$csi_events_categories_is_sub = $csi_events_categories['is_sub'];

if ($csi_events_categories_is_sub == 0)
{
if ($csi_events_categories_id == 3)
{
echo ”

“;
}
else if ($csi_events_categories_id == 2)
{
echo ”

“;
}
else
{
echo ”

“;
}
}

$csi_events_subcategories_query = mysql_query(“SELECT * FROM wp_events_categories WHERE is_sub = $csi_events_categories_id”);
$csi_events_subcategories_query_res = mysql_num_rows($csi_events_subcategories_query);

if ($csi_events_subcategories_query_res > 0)
{
while ($csi_events_subcategories = mysql_fetch_array($csi_events_subcategories_query))
{
$csi_events_subcategories_id = $csi_events_subcategories['id'];
$csi_events_subcategories_name = $csi_events_subcategories['name'];

if ($csi_events_subcategories_id == 7)
{
echo ”

“;
}
else
{
echo ”

“;
}
}
}
}

echo “”;

echo ”
“;

// ================================================================================================================ check GETs

// case I : ALLE events einer kategorie
if (isset($_GET["cat_id"]) && $_GET["cat_id"] != “” && is_numeric($_GET["cat_id"]))
{
$id = $_GET["cat_id"];

$do = csi_list_events($id, 0);
}

// case II : SPEZIELLES event
if (isset($_GET["e_id"]) && $_GET["e_id"] != “” && is_numeric($_GET["e_id"]))
{
$id = $_GET["e_id"];

$do = csi_list_events($id, 1);
}

// ================================================================================================================ functions

function csi_list_events($id, $overload)
{
// ================================================================================================================ VAR setting

$now = time();
$today = date(“Y-m-d”, $now);
$time = date(“H:i:s”, $now);

if ($overload == 0)
{
$csi_events_query = mysql_query
(”
SELECT event_id, event_name, event_start_time, event_start_date, event_notes, location_id
FROM wp_dbem_events
WHERE category_id = ‘$id’ AND event_start_date >= ‘”.$today.”‘
ORDER BY event_start_date, event_start_time
“);
}

if ($overload == 1)
{
$csi_events_query = mysql_query
(”
SELECT event_id, event_name, event_start_time, event_start_date, event_notes, location_id
FROM wp_dbem_events
WHERE event_id = $id
LIMIT 1
“);
}

$csi_events_query_res = mysql_num_rows($csi_events_query);

if ($csi_events_query_res > 0)
{
while ($csi_events = mysql_fetch_array($csi_events_query))
{
$csi_events_id = $csi_events['event_id'];
$csi_events_name = $csi_events['event_name'];
$csi_events_start_time = substr($csi_events['event_start_time'], 0, -3);
$csi_events_start_date_y = substr($csi_events['event_start_date'], 0, -6);
$csi_events_start_date_m = substr($csi_events['event_start_date'], 5, -3);
$csi_events_start_date_d = substr($csi_events['event_start_date'], -2);
$csi_events_notes = $csi_events['event_notes'];

$csi_location_id = $csi_events['location_id'];

$csi_location_query = mysql_query(“SELECT location_name, location_address, location_town FROM wp_dbem_locations WHERE location_id = $csi_location_id LIMIT 1″);
$csi_location = mysql_fetch_array($csi_location_query);
$csi_location_name = $csi_location['location_name'];
$csi_location_address = $csi_location['location_address'];
$csi_location_town = $csi_location['location_town'];

if ($overload == 0)
{
echo
”

“;
}

if ($overload == 1)
{
echo
”

“;
}
}
}
else
{
echo “Keine Ergebnisse verfügbar!
“;
}
}

?>