if (is_array($active_camp_sort)) { array_multisort($active_camp_sort, SORT_DESC, $active_camp_list); } $query = "SELECT camp.*,\r\n\t\t\tuser.mail,\r\n\t\t\tuser.scoutname,\r\n\t\t\tuser.surname,\r\n\t\t\tuser.firstname,\r\n\t\t\tuser_camp.id AS user_camp_id\r\n\t\tFROM\r\n\t\t\tcamp,\r\n\t\t\tuser_camp\r\n\t\t\tLEFT JOIN user ON user.id=user_camp.invitation_id\r\n\t\tWHERE\r\n\t\t\tuser_camp.user_id = '{$_user->id}' AND\r\n\t\t\tuser_camp.camp_id = camp.id AND\r\n\t\t\tuser_camp.active = 0"; $result = mysql_query($query); $request_camp_show = mysql_num_rows($result) > 0; while ($camp_detail = mysql_fetch_assoc($result)) { $subquery = "SELECT \r\n\t\t\t\t\t\tMIN( subcamp.start ) AS start , \r\n\t\t\t\t\t\tMAX( subcamp.start + subcamp.length ) AS end\r\n\t\t\t\t\tFROM \r\n\t\t\t\t\t\tcamp, \r\n\t\t\t\t\t\tsubcamp \r\n\t\t\t\t\tWHERE \r\n\t\t\t\t\t\tsubcamp.camp_id = camp.id AND\r\n\t\t\t\t\t\tcamp.id = {$camp_detail['id']}"; $subresult = mysql_query($subquery); $camp_time = mysql_fetch_assoc($subresult); $c_start = new c_date(); $c_end = new c_date(); $c_start->setDay2000($camp_time['start']); $c_end->setDay2000($camp_time['end']); $camp_detail['start'] = date("d.m.Y", $c_start->getUnix()); $camp_detail['end'] = date("d.m.Y", $c_end->getUnix()); $camp_detail[scout] = $camp_detail[scout]; $camp_detail[name] = $camp_detail[name]; $camp_detail[slogan] = $camp_detail[slogan]; if ($camp_detail[mail] == "") { $camp_detail[from] = "<unbekannt>"; } else { $camp_detail[from] = $camp_detail[scoutname] . " / " . $camp_detail[firstname] . " " . $camp_detail[surname]; } $request_camp_list[] = $camp_detail; } $show_list = $_REQUEST['show_list'] == 1 ? true : false; $_page->html->set('show_list', $show_list); $_page->html->set('active_camp_list', $active_camp_list); $_page->html->set('request_camp_list', $request_camp_list); $_page->html->set('request_camp_show', $request_camp_show);
$camp_info[input] = false; $camp_info[readonly] = true; } else { $_SESSION[camp_id] = ""; header("Location: index.php"); die; } $start = new c_date(); $end = new c_date(); $subcamps = array(); $query = "SELECT * FROM subcamp WHERE camp_id = '{$_camp->id}' ORDER BY start ASC "; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $start->m_days = $row['start']; $end->m_days = $row['start'] + $row['length'] - 1; $subcamps[] = array("start" => gmdate("d.m.Y", $start->getUnix()), "end" => gmdate("d.m.Y", $end->getUnix()), "id" => $row[id]); } // �berpr�fen, ob ein Lager gew�hlt wurde und Lagerdaten einlesen $query = "\tSELECT \r\n \t\t\t\tcamp.*,\r\n \t\t\t\tgroups.name as groups_name,\r\n \t\t\t\tgroups.short_prefix as groups_short_prefix\r\n \t\t\tFROM\r\n \t\t\t\tcamp\r\n \t\t\tLEFT JOIN\r\n \t\t\t\tgroups\r\n \t\t\tON\r\n \t\t\t\tcamp.group_id = groups.id\r\n \t\t\tWHERE\r\n \t\t\t\tcamp.id = '{$_camp->id}'"; $result = mysql_query($query); if (mysql_num_rows($result) == 0) { die("Kein Lager gewählt"); } $camp_data = mysql_fetch_assoc($result); // Lager-Detaildaten herausfiltern $num1 = strpos($camp_data['ca_coor'], "."); $num2 = strpos($camp_data['ca_coor'], "/"); $num3 = strrpos($camp_data['ca_coor'], "."); if ($num1 != "" && $num2 != "" && $num3 != "" && $num1 != $num3) { $camp_data['ca_coor1'] = substr($camp_data['ca_coor'], 0, $num1); $camp_data['ca_coor2'] = substr($camp_data['ca_coor'], $num1 + 1, $num2 - $num1 - 1);
} $dp_header['place'] = array("value" => $event_place, "event_id" => $event_id, "script" => "action_change_place"); $query = "\tSELECT\r\n\t\t\t\t\tevent_instance.starttime,\r\n\t\t\t\t\tevent_instance.length,\r\n\t\t\t\t\tday.day_offset + subcamp.start as startdate,\r\n\t\t\t\t\t(\tSELECT\r\n\t\t\t\t\t\t\tcount(event_instance_down.id)\r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\tevent_instance as event_instance_up,\r\n\t\t\t\t\t\t\tevent_instance as event_instance_down,\r\n\t\t\t\t\t\t\tevent,\r\n\t\t\t\t\t\t\tcategory\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\tevent_instance_up.id = event_instance.id AND\r\n\t\t\t\t\t\t\tevent_instance_up.day_id = event_instance_down.day_id AND\r\n\t\t\t\t\t\t\tevent_instance_down.event_id = event.id AND\r\n\t\t\t\t\t\t\tevent.category_id = category.id AND\r\n\t\t\t\t\t\t\tcategory.form_type > 0 AND\r\n\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\tevent_instance_down.starttime < event_instance_up.starttime OR\r\n\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\tevent_instance_down.starttime = event_instance_up.starttime AND\r\n\t\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\t\tevent_instance_down.dleft < event_instance_up.dleft OR\r\n\t\t\t\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\t\t\t\tevent_instance_down.dleft = event_instance_up.dleft AND\r\n\t\t\t\t\t\t\t\t\t\t\tevent_instance_down.id <= event_instance_up.id\r\n\t\t\t\t\t\t\t)\t)\t)\t)\r\n\t\t\t\t\t) as event_nr,\r\n\t\t\t\t\tday.day_offset + 1 as day_nr\r\n\t\t\t\tFROM\r\n\t\t\t\t\tevent_instance,\r\n\t\t\t\t\tday,\r\n\t\t\t\t\tsubcamp\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tevent_instance.event_id = {$event_id} AND\r\n\t\t\t\t\tevent_instance.day_id = day.id AND\r\n\t\t\t\t\tday.subcamp_id = subcamp.id\r\n\t\t\t\tORDER BY\r\n\t\t\t\t\tstartdate, event_nr"; $query = "\tSELECT\r\n\t\t\t\t\tevent_instance.starttime,\r\n\t\t\t\t\tevent_instance.length,\r\n\t\t\t\t\tday.day_offset + subcamp.start as startdate,\r\n\t\t\t\t\tv_event_nr.event_nr,\r\n\t\t\t\t\tv_event_nr.day_nr\r\n\t\t\t\tFROM\r\n\t\t\t\t\tv_event_nr,\r\n\t\t\t\t\tevent_instance,\r\n\t\t\t\t\tday,\r\n\t\t\t\t\tsubcamp\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tv_event_nr.event_instance_id = event_instance.id AND\r\n\t\t\t\t\tevent_instance.event_id = {$event_id} AND\r\n\t\t\t\t\tevent_instance.day_id = day.id AND\r\n\t\t\t\t\tday.subcamp_id = subcamp.id\r\n\t\t\t\tORDER BY\r\n\t\t\t\t\tstartdate, event_nr"; $result = mysql_query($query); $date = new c_date(); $start = new c_time(); $end = new c_time(); $dp_header['event_instance'] = array(); $row = mysql_fetch_assoc($result); $_page->html->set('event_nr', "(" . $row['day_nr'] . "." . $row['event_nr'] . ")"); do { $date->setDay2000($row['startdate']); $start->setValue($row['starttime']); $end->setValue($row['starttime'] + $row['length']); $dp_header['event_instance'][] = array('event_nr' => "(" . $row['day_nr'] . "." . $row['event_nr'] . ")", 'startdate' => date("d.m.Y", $date->getUnix()), 'starttime' => $start->getString("H:i") . " - " . $end->getString("H:i")); } while ($row = mysql_fetch_assoc($result)); $_page->html->set('dp_header', $dp_header); //echo "dp_header=>"; //print_r( $dp_header ); // HEAD: // ======= $dp_head_show = array(); $query = "\tSELECT\r\n\t\t\t\t\tdropdown.value as form,\r\n\t\t\t\t\t(dropdown.value = category.form_type) as show_form\r\n\t\t\t\tFROM\r\n\t\t\t\t\tevent,\r\n\t\t\t\t\tcategory,\r\n\t\t\t\t\tdropdown\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tevent.id = {$event_id} AND\r\n\t\t\t\t\tevent.category_id = category.id AND\r\n\t\t\t\t\tdropdown.list = 'form'"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $dp_head_show[$row[form]] = $row[show_form]; } $_page->html->set('dp_head_show', $dp_head_show); $query = "\tSELECT\r\n\t\t\t\t\tevent.aim as aim,\r\n\t\t\t\t\tevent.story as story,\r\n\t\t\t\t\tevent.method as method,\r\n\t\t\t\t\tevent.topics as topics,\r\n\t\t\t\t\t'true' as visible\r\n\t\t\t\tFROM\r\n\t\t\t\t\tevent\r\n\t\t\t\tWHERE\r\n\t\t\t\t\tevent.id = {$event_id}"; $result = mysql_query($query);
} else { array_push($dp_header['users'], $row[firstname] . " " . $row[surname]); } } $dp_header['place'] = array("value" => $event_place, "event_id" => $event_id, "script" => "action_change_place"); $query = "\tSELECT\n\t\t\t\t\tevent_instance.starttime,\n\t\t\t\t\tevent_instance.length,\n\t\t\t\t\tday.day_offset + subcamp.start as startdate\n\t\t\t\tFROM\n\t\t\t\t\tevent_instance,\n\t\t\t\t\tday,\n\t\t\t\t\tsubcamp\n\t\t\t\tWHERE\n\t\t\t\t\tevent_instance.event_id = {$event_id} AND\n\t\t\t\t\tevent_instance.day_id = day.id AND\n\t\t\t\t\tday.subcamp_id = subcamp.id"; $result = mysql_query($query); $date = new c_date(); $start = new c_time(); $end = new c_time(); $dp_header['event_instance'] = array(); while ($row = mysql_fetch_assoc($result)) { $date->setDay2000($row['startdate']); $start->setValue($row['starttime']); $end->setValue($row['starttime'] + $row['length']); $dp_header['event_instance'][] = array('startdate' => date("d.m.Y", $date->getUnix()), 'starttime' => $start->getString("H:i") . " - " . $end->getString("H:i")); } $_page->html->set('dp_header', $dp_header); // HEAD: // ======= $dp_head_show = array(); $query = "\tSELECT\n\t\t\t\t\tdropdown.value as form,\n\t\t\t\t\t(dropdown.value = category.form_type) as show_form\n\t\t\t\tFROM\n\t\t\t\t\tevent,\n\t\t\t\t\tcategory,\n\t\t\t\t\tdropdown\n\t\t\t\tWHERE\n\t\t\t\t\tevent.id = {$event_id} AND\n\t\t\t\t\tevent.category_id = category.id AND\n\t\t\t\t\tdropdown.list = 'form'"; $result = mysql_query($query); while ($row = mysql_fetch_assoc($result)) { $dp_head_show[$row[form]] = $row[show_form]; } $_page->html->set('dp_head_show', $dp_head_show); $query = "\tSELECT\n\t\t\t\t\tevent.aim as aim,\n\t\t\t\t\tevent.story as story,\n\t\t\t\t\tevent.method as method,\n\t\t\t\t\t'true' as visible\n\t\t\t\tFROM\n\t\t\t\t\tevent\n\t\t\t\tWHERE\n\t\t\t\t\tevent.id = {$event_id}"; $result = mysql_query($query); $replace = mysql_fetch_assoc($result); $dp_head = array();
$end = $date->getString('d.m.Y'); $date->setDay2000($subcamp['start']); $start = $date->getString('d.m.Y'); $todo_list[$date->getString('Ym')]['name'] = strtr($date->getString("F Y"), $GLOBALS[en_to_de]); $todo_list[$date->getString('Ym')]['todos'][$date->getString('d')][] = array("date" => $start, "camptime" => true, "entry" => false, "today" => false, "short" => $start . " - " . $end); ksort($todo_list[$date->getString("Ym")]['todos']); } // TODAY: // ======== $todo_list[date("Ym")]['name'] = strtr(date("F Y"), $GLOBALS[en_to_de]); $todo_list[date("Ym")]['todos'][date("d")][] = array("date" => strtr(date("D d. M"), $GLOBALS[en_to_de]), "camptime" => false, "entry" => false, "today" => true); ksort($todo_list[date("Ym")]['todos']); $query = "\tSELECT\r\n\t\t\t\t\ttodo.*\r\n\t\t\t\tFROM\r\n\t\t\t\t\ttodo\r\n\t\t\t\tWHERE\r\n\t\t\t\t\ttodo.camp_id = {$_camp->id}\r\n\t\t\t\tORDER BY\r\n\t\t\t\t\ttodo.date"; $result = mysql_query($query); while ($todo = mysql_fetch_assoc($result)) { if ($date->getUnix() < time()) { $date->setDay2000($todo['date']); if ($date->getUnix() > time()) { //$todo_list[date("Ym")]['name'] = strtr( date("F Y"), $GLOBALS[en_to_de] ); //$todo_list[date("Ym")]['todos'][] = array( "date" => strtr( date("D d. M"), $GLOBALS[en_to_de] ), "camptime" => false, "entry" => false, "today" => true ); } } $date->setDay2000($todo['date']); $todo['camptime'] = false; $todo['today'] = false; $todo['entry'] = true; $todo['resp'] = array(); $todo['date'] = strtr($date->getString("D d. M"), $GLOBALS[en_to_de]); $todo['date_value'] = $date->getString("d.m.Y"); $todo['disabled'] = $todo['done'] ? 'disabled' : ''; $subquery = "\tSELECT\r\n\t\t\t\t\t\t\tuser.id,\r\n\t\t\t\t\t\t\tuser.scoutname,\r\n\t\t\t\t\t\t\tuser.firstname,\r\n\t\t\t\t\t\t\tuser.surname,\r\n\t\t\t\t\t\t\tIF( ISNULL( todo_user_camp.todo_id ), 0, 1) as resp\r\n\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\tdropdown,\r\n\t\t\t\t\t\t\tuser,\r\n\t\t\t\t\t\t\tuser_camp\r\n\t\t\t\t\t\tLEFT JOIN\r\n\t\t\t\t\t\t\t(\r\n\t\t\t\t\t\t\t\tSELECT\r\n\t\t\t\t\t\t\t\t\ttodo_user_camp.todo_id,\r\n\t\t\t\t\t\t\t\t\ttodo_user_camp.user_camp_id\r\n\t\t\t\t\t\t\t\tFROM\r\n\t\t\t\t\t\t\t\t\ttodo_user_camp\r\n\t\t\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\t\t\ttodo_user_camp.todo_id = {$todo['id']}\r\n\t\t\t\t\t\t\t) as todo_user_camp\r\n\t\t\t\t\t\tON\r\n\t\t\t\t\t\t\ttodo_user_camp.user_camp_id = user_camp.id\r\n\t\t\t\t\t\tWHERE\r\n\t\t\t\t\t\t\tuser_camp.function_id = dropdown.id AND\r\n\t\t\t\t\t\t\tdropdown.entry != 'Support' AND\r\n\t\t\t\t\t\t\tuser.id = user_camp.user_id AND\r\n\t\t\t\t\t\t\tuser_camp.camp_id = {$_camp->id}";