// ================================================================================================================ 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 ”

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

  • $csi_events_categories_name
  • “;
    }
    else
    {
    echo ”

  • $csi_events_categories_name
  • “;
    }
    }

    $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 ”

  • $csi_events_subcategories_name
  • “;
    }
    else
    {
    echo ”

  • $csi_events_subcategories_name
  • “;
    }
    }
    }
    }

    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

    $csi_events_start_date_d.$csi_events_start_date_m.
    $csi_events_start_date_y
    $csi_events_start_time$csi_events_name”;

    if ($csi_events_notes != “”)
    {
    echo ” [ mehr ]“;
    }

    echo

    $csi_location_name, $csi_location_address, $csi_location_town [ Anfahrtsplaner ]

    “;
    }

    if ($overload == 1)
    {
    echo

    $csi_events_start_date_d.$csi_events_start_date_m.
    $csi_events_start_date_y
    $csi_events_start_time$csi_events_name
    $csi_location_name, $csi_location_address, $csi_location_town [Anfahrtsplaner]
    “;

    if ($csi_events_notes != “”)
    {
    echo “$csi_events_notes”;
    }
    else
    {
    }

    echo

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

    ?>