0){ while ($row = db_fetch_assoc($result)){ $array_participants = unserialize($row['participants']); foreach($array_participants as $index => $subarray_participants){ if (($subarray_participants['acctid']==$accountid) && ($subarray_participants['state']=="aboard")){ $difference = $row['date'] - time(); $days = floor($difference / 86400); $hours = floor(($difference - ($days*86400)) / 3600); $minutes = floor(($difference - ($days*86400) - ($hours*3600)) / 60); $str_nextmeeting = "`bNächster Termin`b in ".$days." Tagen ".$hours." Stunden und ".$minutes." Minuten!"; $str_color = "`&"; if ($difference<=345600) $str_color = "`y"; // 4 Tage if ($difference<=259200) $str_color = "`8"; // 3 Tage if ($difference<=172800) $str_color = "`/"; // 2 Tage if ($difference<=86400) $str_color = "`^"; // 1 Tag if ($difference<=43200) $str_color = "`6"; // 12 Stunden if ($difference<=21600) $str_color = "`q"; // 6 Stunden if ($difference<=10800) $str_color = "`d"; // 3 Stunden if ($difference<=7200) $str_color = "`Q"; // 2 Stunden if ($difference<=3600) $str_color = "`D"; // 1 Stunde if ($difference<=0){ $str_nextmeeting = "`bNächster Termin`b: Ein Treffen läuft gerade!"; $str_color = "`$"; //Hat schon angefangen un dauert noch an (max. 2h) } if ($difference<(-7200)){ $str_color = "`("; $str_nextmeeting = "`bNächster Termin`b: Du hast dich zu keinem Treffen angemeldet."; break 1; } break 2; } } } } else { $str_color = "`("; $str_nextmeeting = "`bNächster Termin`b: Es stehen keine Treffen an."; } $str_return = $str_color.$str_nextmeeting."`0"; return $str_return; } if ($_GET['type']=="access"){ if ($_GET['op']==""){ $sql = "SELECT * FROM `meetings` ORDER BY `date` ASC"; $result = db_query($sql); if (db_num_rows($result) > 0) { $str_output .= ""; $int_counter = 0; while ($row = db_fetch_assoc($result)){ $str_output .= ""; $array_participants = unserialize($row['participants']); $bool_signed = false; $bool_old = false; foreach($array_participants as $index => $subarray_participants){ if (($subarray_participants['acctid']==$session['user']['acctid']) && ($subarray_participants['state']=="aboard")){ if (($row['date']+7200-time())<0){ $bool_old = true; } else { $bool_signed = true; } break; } elseif (($row['date']+7200-time())<0){ $bool_old = true; } } $str_output .= ""; $str_output .= ""; $str_output .= ""; $str_output .= ""; $str_output .= ""; addnav("",$str_self."&op=show&id=".$row['meetingid']); } $str_output .= "
NameDatumWer?Priorität (1-9)
".($bool_signed?"`b`2":"").($bool_old?"`(":"").$row['name'].($bool_signed?"`b":"")."`0".($bool_old?"`(":"").date("d.m.Y H:i",$row['date'])." Uhr`0".($bool_old?"`(":"").$row['group']."`0".($bool_old?"`(":"").$row['priority']."`0
"; } else { $str_output .= "Es sind keine Treffen eingetragen!"; } $str_output .= "`n".meeting_countdown($session['user']['acctid']); addnav("Treffen hinzufügen",$str_self."&op=add"); } elseif ($_GET['op']=="add"){ if ($_GET['subop']=="submit"){ $name = $_POST['name']; $datum = mktime($_POST['stunden'],$_POST['minuten'],0,$_POST['monat'],$_POST['tag'],$_POST['jahr']); $gruppe = $_POST['gruppe']; $beschreibung = $_POST['beschreibung']; $prioritaet = $_POST['prioritaet']; $teilnehmer = serialize(array()); $kommentare = serialize(array()); $sql = "INSERT INTO `meetings` (`meetingid` ,`name` ,`date` ,`group` ,`priority` ,`participants` ,`comments` ,`description`) VALUES (NULL , '".$name."', '".$datum."', '".$gruppe."', '".$prioritaet."', '".$teilnehmer."', '".$kommentare."', '".$beschreibung."')"; db_query($sql); $str_output .= "`bTreffen am ".date("d.m.Y",$datum)." eingetragen!`b"; addnav("Weiter",$str_self); } else { $str_output .= ""; $str_output .= ""; $str_output .=""; $str_output .= "
Name des Treffens:
Datum:Am .. um : Uhr
Gruppe:
Beschreibung:
Priorität (1 = höchste, 9 = niedrigste):
`n
`n`^Alle Felder sind auszufüllen!"; addnav("",$str_self."&op=add&subop=submit"); addnav("Zurück zur Liste",$str_self); } } elseif ($_GET['op']=="edit"){ if ($_GET['subop']=="submit"){ $meetingid = $_POST['meetingid']; $name = $_POST['name']; $datum = mktime($_POST['stunden'],$_POST['minuten'],0,$_POST['monat'],$_POST['tag'],$_POST['jahr']); $gruppe = $_POST['gruppe']; $beschreibung = $_POST['beschreibung']; $prioritaet = $_POST['prioritaet']; $sql = "UPDATE `meetings` SET `name` = '".$name."',`date` = '".$datum."',`group` = '".$gruppe."',`priority` = '".$prioritaet."',`description` = '".$beschreibung."' WHERE `meetingid` = '".$meetingid."' LIMIT 1"; db_query($sql); $str_output .= "`bTreffen am ".date("d.m.Y",$datum)." geändert!`b"; clearnav(); addnav("Weiter",$str_self."&op=show&id=".$meetingid); } elseif ($_GET['subop']=="delete"){ $sql = "DELETE FROM `meetings` WHERE `meetingid` = '".$_GET['id']."' LIMIT 1"; db_query($sql); $str_output .= "`bTreffen gelöscht!`b"; clearnav(); addnav("Weiter",$str_self); } else { $sql = "SELECT * FROM `meetings` WHERE `meetingid` = '".$_GET['id']."' LIMIT 1"; $result = db_query($sql); $row = db_fetch_assoc($result); $str_output .= ""; $str_output .= ""; $str_output .=""; $str_output .= "
Name des Treffens:
Datum:Am .. um : Uhr
Gruppe:
Beschreibung:
Priorität (1 = höchste, 9 = niedrigste):
"; addnav("",$str_self."&op=edit&subop=submit"); addnav("Zurück zum Termin",$str_self."&op=show&id=".$row['meetingid']); addnav("Vorsicht"); addnav("`4Termin löschen`0",$str_self."&op=edit&id=".$row['meetingid']."&subop=delete",false,false,false,false,"Willst du diesen Termin wirklich streichen?"); } } elseif ($_GET['op']=="show"){ $sql = "SELECT * FROM `meetings` WHERE `meetingid` = '".$_GET['id']."' LIMIT 1"; $result = db_query($sql); if (db_num_rows($result) > 0) { $row = db_fetch_assoc($result); addnav("Aktualisieren",$str_self."&op=show&id=".$row['meetingid']); addnav("",$str_self."&op=show&id=".$row['meetingid']); $str_output .= "`bGrottentreffen am ".date("d.m.Y, H:i",$row['date'])." Uhr: ".$row['name']."`b [ Bearbeiten ]`n"; addnav("",$str_self."&op=edit&id=".$row['meetingid']); $str_output .= "Priorität: ".$row['priority']."`n`n"; $str_output .= "Beschreibung:`n".$row['description']."`n`n`n"; $array_participants = unserialize($row['participants']); if ($_GET['subop']=="setstate"){ foreach($array_participants as $index => $subarray){ if ($subarray['acctid']==$session['user']['acctid']){ unset($array_participants[$index]); break; } } if (($_GET['state']!="reset") && (strlen($_GET['state'])>0)){ $insert_array=array(); $insert_array['acctid']=$session['user']['acctid']; $insert_array['state']=$_GET['state']; $array_participants[]=$insert_array; } db_query("UPDATE `meetings` SET `participants` = '".addslashes(serialize($array_participants))."' WHERE `meetingid` = '".$row['meetingid']."' LIMIT 1"); } $mystate = "nothing"; $participantsection = "An-/Abmeldungsliste:`n
`2Anwesend`0`4Abwesend`0
"; foreach($array_participants as $subarray){ if ($subarray['state']=="aboard"){ $request = db_fetch_assoc(db_query("SELECT `name` FROM `accounts` WHERE `acctid` = '".$subarray['acctid']."' LIMIT 1")); $participantsection .= $request['name']."`n"; if ($request['name']==$session['user']['name']) $mystate = "aboard"; } } $participantsection .= ""; foreach($array_participants as $subarray){ if ($subarray['state']=="absent"){ $request = db_fetch_assoc(db_query("SELECT `name` FROM `accounts` WHERE `acctid` = '".$subarray['acctid']."' LIMIT 1")); $participantsection .= $request['name']."`n"; if ($request['name']==$session['user']['name']) $mystate = "absent"; } } $participantsection .= "
`n`n"; $str_output .= $participantsection; $array_comments = unserialize($row['comments']); $commentsection = ""; foreach($array_comments as $subarray){ $commentsection .= "`#`b".$subarray['poster'].":`b`3 ".$subarray['content']."`0`n"; } if (($_GET['subop']=="comment") && (strlen($_POST['comment'])>0)){ $array_comments[count($array_comments)]['poster'] = $session['user']['login']; $array_comments[(count($array_comments)-1)]['content'] = stripslashes($_POST['comment']); $serialized_comments = serialize($array_comments); $sql2 = "UPDATE `meetings` SET `comments` = '".addslashes($serialized_comments)."' WHERE `meetingid` = '".$row['meetingid']."' LIMIT 1"; $result2 = db_query($sql2); $commentsection .= "`#`b".$session['user']['login'].":`b`3 ".stripslashes($_POST['comment'])."`0`n"; } $str_output .= "`#`bKommentare:`b`0`n".$commentsection."`n
`n
`n[ Aktualisieren ]
"; addnav("",$str_self."&op=show&id=".$row['meetingid']."&subop=comment"); addnav("Zurück zur Liste",$str_self); addnav("Mein Status"); addnav((($mystate=="aboard")?("`2"):(""))."Ja, ich werde kommen :)`0",$str_self."&op=show&id=".$row['meetingid']."&subop=setstate&state=aboard"); addnav((($mystate=="nothing")?("`^"):(""))."Ich weiß noch nicht!`0",$str_self."&op=show&id=".$row['meetingid']."&subop=setstate&state=reset"); addnav((($mystate=="absent")?("`4"):(""))."Nein, ich habe keine Zeit :(`0",$str_self."&op=show&id=".$row['meetingid']."&subop=setstate&state=absent"); } else { $str_output .= "Treffen nicht gefunden (soeben gelöscht?)"; clearnav(); addnav("Zurück",$str_self); } } } if ($_GET['type']!="access"){ $str_output .= meeting_countdown($session['user']['acctid']); } output($str_output,true); if ($_GET['type']=="access") page_footer(); ?>