Hab ich garnicht drann gedacht das die Box da immer noch nicht bei ist.
Also hier mal der code meiner Box , so hatte ich das hier gelöst
externer Link
<center><?php
# Copyright by Manuel Staechele
# Support www.ilch.de
defined ('main') or die ( 'no direct access' );
$m = date('n');
$j = date('Y');
$where1 = mktime(0 ,0,0,$m,1,$j);
$where2 = mktime(24,0,0,$m,date('t',$where1),$j);
$data = array();
$result = db_query('SELECT *
FROM prefix_kalender
WHERE (time > '.$where1.' AND time < '.$where2.')
AND '.$_SESSION['authright'].' <= recht
ORDER BY time LIMIT 50');
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']);
$date = mktime(0,0,0,$t_m,$t_d,$t_y);
$data[$date][] = $row;
}
echo getCalendar2($m, $j, '?kalender-v1-m{mon}-y{jahr}-d{tag}', '?kalender-v0-m{mon}-y{jahr}', $data, 1);
?></center>
<?php
$abf = "SELECT id, title, FROM_UNIXTIME(time,'%d.%m.%Y') as zeit FROM prefix_kalender WHERE time >= UNIX_TIMESTAMP( CURDATE( ) + INTERVAL 1 Day) AND recht >= {$_SESSION['authright']} ORDER BY time LIMIT 3";
$erg = db_query($abf);
if ( @db_num_rows($erg) == 0 ) {
echo '<div id="event">Zur Zeit keine Termine eingetragen</div>';
}
echo '<div id="event">';
while ($row = db_fetch_object($erg)) {
echo '<div class="e_entry"><img src="include/images/icons/event.png" /><div class="e_date">'.$row->zeit.'</div><a class="e_title" href="index.php?kalender-v1-e'.$row->id.'">'.((strlen($row->title)<40) ? $row->title : substr($row->title,0,40).'...').'</a></div>';
}
## echo '</div>';
echo '<div id="more_events">';
echo '<div class="event_entry">';
echo '<ul>';
echo '<li>';
echo '<a href="index.php?kalender-v0">Weitere Events</a>';
echo '</li><li>';
echo '<a href="index.php?kalender1">Event Eintragen</a>';
echo '</li>';
echo '</ul>';
echo '</div></div></div>';
?>
bestimmt nicht die sauberste lösung, aber dafür auch schon älter
Greetz Wizz
Mi. 13.03.2013
12:25 Uhr
#2
Zitat geschrieben von Siggi
