Hier kann eine Notiz zum Merk-Eintrag hinzugefügt werden (optional)
| Geschlossen | ||
Mo. 19.05.2008
16:32 Uhr
#1
//Ganze Liste
} elseif (isset($data)) {
$i = 1;
foreach($data as $date => $data1) {
$text = '';
foreach($data1 as $info) {
$text .= '<a style="'.$color.';" href="?kalender-v'.$view.'-e'.$info['id'].'">'.$info['title'].'</a>; ';
}
Mo. 26.05.2008
12:48 Uhr
#2
Di. 27.05.2008
09:47 Uhr
#4
Mi. 28.05.2008
19:21 Uhr
#5
$color = '';
if($_POST['max_teilnehmer'] == $_POST['teilnehmer']){
$color .= 'red';
}elseif($_POST['max_teilnehmer'] != $_POST['teilnehmer']){
$color .= 'green';
}
Do. 29.05.2008
16:17 Uhr
#7
Mi. 04.06.2008
13:03 Uhr
#9
<?php
# Kalender Script © by Nickel
# ueberarbeitet von Manuel
defined ('main') or die ( 'no direct access' );
defined ('admin') or die ( 'only admin access' );
# Funktionen
function XAJAX_showCalendar ($m,$j,$f) {
if (empty($m)) { $m = date('n'); }
if (empty($j)) { $j = date('Y'); }
$objResponse = new xajaxResponse();
$content = '<table border="0" cellpadding="1" cellspacing="1" class="border"><tr><td class="Cnorm"><a href="javascript:close'.$f.'();">schliessen</a></td></tr></table>';
$content .= getCalendar($m, $j, 'javascript:void(0);" onclick="set'.$f.'(\'{jahr}-{mon}-{tag}\')', 'javascript:void(0);" onclick="xajax_XAJAX_showCalendar({mon},{jahr},\''.$f.'\')', '');
$objResponse->assign('skalender'.$f, 'style.display', 'block' );
$objResponse->assign('skalender'.$f, 'innerHTML', $content);
# return object
return $objResponse;
}
function checkzyklusins ($x,$i0,$i1,$i2,$z,$sar) {
$ts = mktime(0,0,0,$i1,$i2,$i0);
$wt = date('w',$ts);
if ($z == 'wer' AND ($wt > 0 AND $wt < 6)) {
return (true);
} elseif ($z == 'wek' AND ($wt == 0 OR $wt == 6)) {
return (true);
} elseif ($z == 'woc' AND (($x % 7) == 1)) {
return (true);
} elseif ($z == '14t' AND (($x % 14) == 1)) {
return (true);
} elseif ($z == 'mon' AND ($i2 == $sar[2])) {
return (true);
} elseif ($z == 'jae' AND ($i1 == $sar[1] AND $i2 == $sar[2])) {
return (true);
}
return (false);
}
function zyklusinsert ($sar,$ear,$z,$_POST) {
$x = 1;
$first_id = 0;
for($i0=$sar[0];$i0<=$ear[0];$i0++) {
$sm = 1;
$em = 12;
if ($sar[0] == $i0) { $sm = $sar[1]; }
if ($ear[0] == $i0) { $em = $ear[1]; }
for($i1=$sm;$i1<=$em;$i1++) {
$st = 1;
$et = date('t', mktime (0,0,0,$i1,1,$i0));
if ($sar[0] == $i0 AND $sar[1] == $i1) { $st = $sar[2]; }
if ($ear[0] == $i0 AND $ear[1] == $i1) { $et = $ear[2]; }
for($i2=$st;$i2<=$et;$i2++) {
if (checkzyklusins ($x,$i0,$i1,$i2,$z,$sar)) {
$time = mktime ($_POST['stunde'], $_POST['minute'],0,$i1,$i2,$i0);
db_query("INSERT INTO `prefix_kalender` (time,gid,title,text,recht) VALUES (".$time.",".$first_id.",'".$_POST['title']."','".escape($_POST['txt'],'string')."','".$_POST['recht']."')");
if ($first_id == 0) {
$first_id = db_last_id();
db_query("UPDATE prefix_kalender SET gid = ".$first_id." WHERE id = ".$first_id);
}
}
$x++;
}
}
}
}
# AJAX Start
$xajax = new xajax('http://'.$_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"].'?kalender=0');
$xajax->registerFunction("XAJAX_showCalendar");
$xajax->processRequest();
# DESIGN
$design = new design ( 'Admins Area', 'Admins Area', 2 );
$design->header();
# AJAX ausgabe
echo $xajax->printJavascript();
if (!empty($_REQUEST['um'])) {
$sar = explode('-',$_POST['begind']);
if (!@checkdate ($sar[1], $sar[2], $sar[0])) {
echo 'Das eingegebene Datum ist nicht gültig ';
echo '<a href="javascript:history.back()">zurück</a>';
$design->footer(1);
}
if (!empty($_POST['zende'])) {
$ear = explode('-',$_POST['zende']);
if (!@checkdate ($ear[1], $ear[2], $ear[0])) {
echo 'Das eingegebene Datum für das Zyklusende ist nicht gültig ';
echo '<a href="javascript:history.back()">zurück</a>';
$design->footer(1);
}
}
$z = '';
if (isset($_POST['zyklus'])) {
$z = $_POST['zyklus'];
}
$text = escape($_POST['txt'], 'string');
$time = mktime ($_POST['stunde'], $_POST['minute'],0,$sar[1],$sar[2],$sar[0]);
// Einfuegen
if ($_REQUEST['um'] == 'insert') {
if (!empty($z)) {
zyklusinsert ($sar,$ear,$z,$_POST);
} else {
//Marcels Änderungen start
$color = '';
if($_POST['max_teilnehmer'] == $_POST['teilnehmer']){
$color .= 'red';
}elseif($_POST['max_teilnehmer'] != $_POST['teilnehmer']){
$color .= 'green';
}
//Marcels Änderungen ende
db_query("INSERT INTO `prefix_kalender` (time,title,text,recht,max_teilnehmer,teilnehmer,color) VALUES (".$time.",'".$_POST['title']."','".$text."','".$_POST['recht']."','".$_POST['max_teilnehmer']."','".$_POST['teilnehmer']."','".$color."')");
}
// Aendern
} elseif ($_REQUEST['um'] == 'change') {
if (isset($_POST['gid']) AND $_POST['gid'] == 'yes') {
$gid1 = db_result(db_query("SELECT gid FROM prefix_kalender WHERE id = ".$_POST['EID']),0,0);
}
if (isset($_POST['gid']) AND $_POST['gid'] == 'yes' AND $gid1 > 0) {
db_query("UPDATE `prefix_kalender` SET
title = '".$_POST['title']."',
text = '".$text."',
recht = '".$_POST['recht']."',
max_teilnehmer = '".$_POST['max_teilnehmer']."',
teilnehmer = '".$_POST['teilnehmer']."'
WHERE gid = ".$gid1);
} else {
db_query("UPDATE `prefix_kalender` SET
time = '".$time."',
title = '".$_POST['title']."',
text = '".$text."',
recht = '".$_POST['recht']."',
max_teilnehmer = '".$_POST['max_teilnehmer']."',
teilnehmer = '".$_POST['teilnehmer']."'
WHERE id = ".$_POST['EID']." LIMIT 1");
}
}
}
//Loeschen
if (!empty($_GET['del']) AND $_GET['del'] == intval($_GET['del'])) {
db_query("DELETE FROM `prefix_kalender` WHERE id = ".$_GET['del']." LIMIT 1");
}
if (!empty($_GET['del_gid']) AND $_GET['del_gid'] == intval ($_GET['del_gid'])) {
db_query("DELETE FROM prefix_kalender WHERE gid = ".$_GET['del_gid']);
}
//-----------------------------------------------------------|
if (isset($_GET['edit'])) {
$row = db_fetch_assoc(db_query("SELECT * FROM `prefix_kalender` WHERE id = ".$_GET['edit']));
$Faktion = 'change';
$Fid = $row['id'];
$Ftitle = $row['title'];
$Ftext = unescape($row['text']);
//Marcel start
$max_teilnehmer = $row['max_teilnehmer'];
$teilnehmer = $row['teilnehmer'];
//Marcel ende
$Fbegind = date('Y-n-j',$row['time']);
$Fzende = $Fbegind;
$Fhours = date('G',$row['time']);
$Fmins = date('i',$row['time']);
$Frecht = $row['recht'];
$Fsub = 'Ändern';
} else {
$pubdate = getdate();
$Faktion = 'insert';
$Fid = '';
$Ftitle = '';
$Ftext = '';
//Marcel start
$max_teilnehmer = '';
$teilnehmer = '';
//Marcel ende
$Fbegind = date('Y-n-j');
$Fzende = $Fbegind;
$Fhours = $pubdate['hours'];
$Fmins = $pubdate['minutes'];
$Fgrecht = '';
$Frecht = '';
$Fsub = 'Eintragen';
}
$arm = array (); for($i=0;$i<60;$i++){$arm[$i]=$i;}
$ars = array (); for($i=0;$i<24;$i++){$ars[$i]=$i;}
$tpl = new tpl ( 'kalender.htm', 1 );
$limit = 30; // Limit
$page = ($menu->getA(1) == 'p' ? $menu->getE(1) : 1 );
$MPL = db_make_sites ($page , '' , $limit , "?kalender" , 'kalender' );
$anfang = ($page - 1) * $limit;
$aus = array(
'AKTION' => $Faktion,
'MPL' => $MPL,
'EID' => $Fid,
'TITLE' => $Ftitle,
//Marcels Änderungen start
'MAX_TEILNEHMER'=> $max_teilnehmer,
'TEILNEHMER' => $teilnehmer,
//Marcels Änderungen ende
'TEXT' => $Ftext,
'stunden' => arliste($Fhours,$ars,$tpl,'stunden'),
'minuten' => arliste($Fmins,$arm,$tpl,'minuten'),
'zende' => $Fzende,
'begind' => $Fbegind,
'recht' => dbliste($Frecht,$tpl,'recht',"SELECT id,name FROM prefix_grundrechte ORDER BY id DESC"),
'FSUB' => $Fsub
);
$tpl->set_ar_out($aus,0);
if (!isset($_GET['edit'])) {
$tpl->out(1);
} else {
$tpl->out(2);
}
$tpl->out(3);
unset($aus);
//Liste
$result = db_query('SELECT gid,id,title,time,max_teilnehmer,teilnehmer FROM `prefix_kalender` ORDER BY time DESC LIMIT '.$anfang.','.$limit);
while ($row = db_fetch_assoc($result)) {
$aus = array(
'ID' => $row['id'],
'DATE' => date('d.m.Y',$row['time']),
'TIME' => date('H:i',$row['time']),
'TITLE' => $row['title'],
'MAX_TEILNEHMER' => $row['max_teilnehmer'],
'GID' => $row['gid']
);
$tpl->set_ar_out($aus, 4);
}
$tpl->set_ar_out(array('MPL' => $MPL ), 5);
$design->footer();
?>
Mi. 04.06.2008
13:05 Uhr
#10
<?php
# Kalender Script © by Nickel
defined ('main') or die ( 'no direct access' );
//-----------------------------------------------------------|
$title = $allgAr['title'].' :: Kalender';
$hmenu = 'Kalender';
$design = new design ( $title , $hmenu );
$design->header();
$tpl = new tpl ( 'kalender.htm' );
//-----------------------------------------------------------|
//Daten
$month = date('n');
$year = date('Y');
$gday = 0;
$view = 0;
$eid = 0;
if ($menu->getA(1) == 'v' AND is_numeric($menu->getE(1))) {
$view = $menu->getE(1);
}
if ($menu->getA(2) == 'm' AND is_numeric($menu->getE(2)) AND $menu->getE(2) > 0 AND $menu->getE(2) < 13) {
$month = $menu->getE(2);
}
if ($menu->getA(4) == 'd' AND is_numeric($menu->getE(4)) AND $menu->getE(4) > 0 AND $menu->getE(4) < 32) {
$gday = $menu->getE(4);
}
if ($menu->getA(3) == 'y' AND is_numeric($menu->getE(3)) AND $menu->getE(3) > 2000 AND $menu->getE(3) < date('Y', (time()+pow(8,9)))) {
$year = $menu->getE(3);
}
if ($menu->getA(2) == 'e' AND is_numeric($menu->getE(1))) {
$eid = $menu->getE(2);
}
$arr_month = array('1'=>'Januar','Februar','März','April','Mai','Juni','Juli','August','September','Oktober','November','Dezember');
$arr_day = array('So','Mo','Di','Mi','Do','Fr','Sa');
$days = date('t',mktime(0,0,0,$month,1,$year));
$start_col = date('w',mktime(0,0,0,$month,1,$year))-1;
$rows = ceil($days/7);
$day=1;
$data = array ();
$data_id = array ();
$aus = array();
//Daten aus der MySQL
$where1 = mktime(0 ,0,0,$month,1,$year);
$where2 = mktime(24,0,0,$month,date('t',$where1),$year);
$result = db_query("SELECT *
FROM prefix_kalender
WHERE ((time > ".$where1." AND time < ".$where2.") OR id = ".$eid.")
AND ".$_SESSION['authright']." <= recht
ORDER BY time LIMIT 200");
while ($row = db_fetch_assoc($result)) {
$t_id = $row['id'];
$t_d = date('j', $row['time']);
$t_m = date('n', $row['time']);
$t_y = date('Y', $row['time']);
$color = $row['color'];
$date = mktime(0,0,0,$t_m,$t_d,$t_y);
$data_id[$t_id] = $row;
$data[$date][] = $row;
}
$ueid = 0;
if (substr($eid, 0, 3) == 999) {
$ueid = substr ($eid, 3);
}
$result = db_query("SELECT
name, gebdatum, id
FROM prefix_user
WHERE MONTH(gebdatum) = ".$month."
OR id = ".$ueid."
ORDER BY MONTH(gebdatum), DAYOFMONTH(gebdatum) LIMIT 200");
while ($r = db_fetch_assoc($result)) {
list($y,$m,$d) = explode('-',$r['gebdatum']);
$date = mktime(0,0,0,$m,$d,date('Y'));
$dateA = mktime(0,0,0,$m,$d,$y);
$jetzt = time();
$alter = $jetzt - $dateA;
if ($date > $jetzt) {
$alter = date("Y",$alter) - 1970 +1;
} else {
$alter = date("Y",$alter) - 1970;
}
$row = array(
'title' => $alter.'. Geburtstag von '.$r['name'],
'text' => 'Der '.$alter.'. Geburtstag von [url=http://'.($_SERVER["HTTP_HOST"].$_SERVER["SCRIPT_NAME"]).'?user-details-'.$r['id'].'][b]'.$r['name'].'[/b][/url]',
'time' => $date + 99,
'id' => '999'.$r['id'],
);
$data_id['999'.$r['id']] = $row;
$data[$date][] = $row;
}
if ($view == 0) {
$title_liste = $arr_month[$month].' '.$year;
} elseif ($view == 1 && !empty($gday)) {
$title_liste = 'Nur am '.$gday.' '.$arr_month[$month].' '.$year;
} elseif ($view == 1) {
$title_liste = 'Liste ab '.$arr_month[$month].' '.$year;
}
//Template Ausgabe
$aus['MONTH'] = $arr_month[$month];
$aus['YEAR'] = $year;
$aus['TITLE'] = ($eid) ? $data_id[$eid]['title'] : $title_liste;
$aus['TITLE_ALIGN'] = ($eid) ? '' : ' align="center"';
$tpl->set_ar_out($aus,0);
unset($aus);
//Deatilansicht
if ($eid) {
$aus['DEATIL_DATE'] = date('d.m.Y',$data_id[$eid]['time']);
$aus['DEATIL_TIME'] = date('H:i',$data_id[$eid]['time']);
$aus['DEATIL_TEXT'] = BBcode($data_id[$eid]['text']);
//Marcels Änderungen start
$aus['DETAIL_MAX_TEILNEHMER'] = BBcode($data_id[$eid]['max_teilnehmer']);
$aus['DETAIL_TEILNEHMER'] = BBcode($data_id[$eid]['teilnehmer']);
//Marcels Änderungen ende
$tpl->set_ar_out($aus,2);
unset($aus);
}
//Liste der Tage (Monats-Ansicht)
elseif ($view == 0) {
for($i=0;$i<$days;$i++) {
$date = mktime(0,0,0,$month,$i+1,$year);
$text = '';
if (isset($data[$date])) {
foreach($data[$date] as $info) {
$text .= '<a style="'.$color.';" href="?kalender-v'.$view.'-e'.$info['id'].'">'.$info['title'].'</a>; ';
}
}
$aus['LIST_I'] = $i+1;
$aus['LIST_D'] = $arr_day[date('w',mktime(0,0,0,$month,$i+1,$year))];
$aus['LIST_T'] = $text;
$class = ($i % 2) ? 'Cnorm' : 'Cmite' ;
$aus['LIST_CLASS'] = ($i+1 == date('j') && $month == date('n') && $year == date('Y')) ? 'Cdark' : $class;
$tpl->set_ar_out($aus,1);
unset($aus);
}
}
//Liste der Tage (Listenansicht)
elseif ($view == 1) {
//Nur ein Tag
if (isset($data) && !empty($gday)) {
$date = mktime(0,0,0,$month,$gday,$year);
$i = 1;
if (isset($data[$date])) {
foreach($data[$date] as $info) {
$text = '';
$text .= '<a style="color:'.$color.';" href="?kalender-v'.$view.'-e'.$info['id'].'">'.$info['title'].'</a>; ';
$aus['LIST_I'] = $arr_day[date('w',$date)];
$aus['LIST_D'] = date('H:i',$info['time']);;
$aus['LIST_T'] = $text;
$class = ($i % 2) ? 'Cnorm' : 'Cmite' ;
$aus['LIST_CLASS'] = ($i+1 == date('j') && $month == date('n') && $year == date('Y')) ? 'Cdark' : $class;
$tpl->set_ar_out($aus,1);
unset($aus);
$i++;
}
}
//Ganze Liste
} elseif (isset($data)) {
$i = 1;
foreach($data as $date => $data1) {
$text = '';
foreach($data1 as $info) {
$text .= '<a style="'.$color.';" href="?kalender-v'.$view.'-e'.$info['id'].'">'.$info['title'].'</a>; ';
}
$aus['LIST_I'] = date('d.m.Y',$date);
$aus['LIST_D'] = $arr_day[date('w',$date)];
$aus['LIST_T'] = $text;
$class = ($i % 2) ? 'Cnorm' : 'Cmite' ;
$aus['LIST_CLASS'] = ($i+1 == date('j') && $month == date('n') && $year == date('Y')) ? 'Cdark' : $class;
$tpl->set_ar_out($aus,1);
unset($aus);
$i++;
}
} else {
$aus['LIST_I'] = '-';
$aus['LIST_D'] = '-';
$aus['LIST_T'] = '-';
$aus['LIST_CLASS'] = 'Cnorm';
$tpl->set_ar_out($aus,1);
unset($aus);
}
}
# kalender
$tpl->set('calender', getCalendar($month,$year, 'index.php?kalender-v1-m{mon}-y{jahr}-d{tag}', 'index.php?kalender-v'.$view.'-m{mon}-y{jahr}', $data));
$tpl->out(3);
$design->footer();
?>
Mi. 04.06.2008
16:18 Uhr
#11
Do. 05.06.2008
14:53 Uhr
#12
Do. 05.06.2008
19:16 Uhr
#13
$data_id[$t_id] = $row;
$data[$date][] = $row;
foreach($data[$date] as $info) { dort wird die jeweilige Tabellenzeile (sonst $row) als $info angesprochen.
Do. 05.06.2008
22:37 Uhr
#14
Sa. 14.06.2008
14:41 Uhr
#15
Sa. 14.06.2008
14:49 Uhr
#16
Sa. 14.06.2008
17:04 Uhr
#17
Sa. 14.06.2008
17:55 Uhr
#18
Mo. 16.06.2008
15:21 Uhr
#19
Mo. 16.06.2008
16:29 Uhr
#20
Mo. 16.06.2008
17:02 Uhr
#21
| Geschlossen | ||
 |
Zurück zu Allgemein | |