|
include("nav.php");
?>
|
|
Home > Site-News
|
| Bitte wählen |
| Jahr: |
$sqlstring="select year(date) as jahr, count(id) as anz from changelog group by year(date)";
if(!($rc = @ mysql_query($sqlstring)))
showerror();
while($row = mysql_fetch_array($rc, MYSQL_BOTH)):
if($jahr==$row['jahr']){
?>
| >< |
} else {
?>
|
}
endwhile;
?>
|
|
| Monat: |
$sqlstring="select month(date) as monat, count(id) as anz from changelog where year(date)=$jahr group by month(date)";
if(!($rc = @ mysql_query($sqlstring)))
showerror();
$row = mysql_fetch_array($rc, MYSQL_BOTH);
for($i=1;$i<13;$i++){
if($row['monat']==$i){
if($i==$monat){
?>
| >< |
} else {
?>
|
}
$row = mysql_fetch_array($rc, MYSQL_BOTH);
} else {
if($i==$monat){
?>
[] |
} else {
?>
|
}
}
}
?>
|
|
|
switch($action):
case 'ov':
$toptext='Übersicht '.$monate[$monat].' '.$jahr;
$sqlstring="select l.*, date_format(l.date,'%d.%m.%Y') as date2,c.short as cat, c.page from changelog as l, sys_categories as c where l.catid=c.id and $monat=month(date) and $jahr=year(date) order by date desc";
if(!($result = @ mysql_query($sqlstring)))
showerror();
break;
case 'sb':
$toptext='Künster beginnend mit "'.$id.'"';
$sqlstring="select date_format(cds.added,'%d.%m.%Y') as date2, date_format(cds.releasedate,'%d.%m.%Y') as date3, cds.*, m.short as media from cds, sys_media as m where left(cds.gruppe,1)='$id' and cds.mediaid=m.id and active=1 order by gruppe, releasedate desc";
if(!($result = @ mysql_query($sqlstring)))
showerror();
break;
case 'sv':
$toptext='Veröffentlichungen im '.$monate[$monat].' '.$jahr;
$sqlstring="select date_format(cds.added,'%d.%m.%Y') as date2, date_format(cds.releasedate,'%d.%m.%Y') as date3, cds.*, m.short as media from cds, sys_media as m where cds.mediaid=m.id and month(releasedate)=$monat and year(releasedate)=$jahr and active=1 order by releasedate asc, gruppe";
//print($sqlstring);
if(!($result = @ mysql_query($sqlstring)))
showerror();
break;
case'rv':
$sqlstring="select date_format(cds.added,'%d.%m.%Y') as date2, date_format(cds.releasedate,'%d.%m.%Y') as rel_date, cds.*, m.short as media from cds, sys_media as m where cds.mediaid=m.id and cds.id=$id and active=1";
//print($sqlstring);
if(!($result = @ mysql_query($sqlstring)))
showerror();
$row = mysql_fetch_array($result, MYSQL_BOTH);
$toptext=$row['gruppe'].' - '.$row['titel'];
if(mysql_num_rows($result)==0){
$toptext="Fehler!";
}
break;
endswitch;
switch($action):
case 'view':
$sqlstring="select l.*, date_format(l.date,'%d.%m.%Y') as date2,c.short as cat, c.page from changelog as l, sys_categories as c where l.catid=c.id and l.id=$id";
if(!($result = @ mysql_query($sqlstring)))
showerror();
$row = mysql_fetch_array($result, MYSQL_BOTH);
?>
break;
case 'ov':
?>
| Übersicht: |
$sqlstring="select l.*, date_format(l.date,'%d.%m.%Y') as date2,c.short as cat, c.page from changelog as l, sys_categories as c where l.catid=c.id and $monat=month(date) and $jahr=year(date) order by date desc";
if(!($result = @ mysql_query($sqlstring)))
showerror();
?>
while($row = mysql_fetch_array($result, MYSQL_BOTH)):
?>
|
|
|
if(strlen($row['description'])>100){
?>
...weiter
}
?>
|
|
endwhile;
?>
|
break;
default:
?>
| Diesen Monat neu: |
$sqlstring="select l.*, date_format(l.date,'%d.%m.%Y') as date2,c.short as cat, c.page from changelog as l, sys_categories as c where l.catid=c.id and month(now())=month(date) and year(date)=year(now()) order by date desc";
if(!($result = @ mysql_query($sqlstring)))
showerror();
?>
while($row = mysql_fetch_array($result, MYSQL_BOTH)):
?>
|
|
|
if(strlen($row['description'])>100){
?>
... mehr
}
?>
|
|
endwhile;
?>
|
endswitch;
?>
|
| Latest Updates |
/*
$sqlstring="select date_format(now(),'%Y-%m-%d') as tag1, date_format(DATE_ADD(now(), INTERVAL 1 day),'%Y-%m-%d') as tag2, date_format(DATE_ADD(now(), INTERVAL 2 day),'%Y-%m-%d') as tag3, date_format(DATE_ADD(now(), INTERVAL 3 day),'%Y-%m-%d') as tag4, date_format(DATE_ADD(now(), INTERVAL 4 day),'%Y-%m-%d') as tag5,date_format(now(),'%d.%m.%Y') as t1, date_format(DATE_ADD(now(), INTERVAL 1 day),'%d.%m.%Y') as t2, date_format(DATE_ADD(now(), INTERVAL 2 day),'%d.%m.%Y') as t3, date_format(DATE_ADD(now(), INTERVAL 3 day),'%d.%m.%Y') as t4, date_format(DATE_ADD(now(), INTERVAL 4 day),'%d.%m.%Y') as t5, weekday(now()) as wd";
$dblink = mysql_connect($hostname, $username, $password) or die("Keine Verbindung zum Rechner!");
if(!(mysql_select_db($databasename) or die("Datenbankzugriff fehlgeschlagen")))
showerror();
if(!($result = @ mysql_query($sqlstring)))
showerror();
$row = mysql_fetch_array($result, MYSQL_BOTH);
$wd = $row['wd'];
$now = array(0=>$row['tag1'],$row['tag2'],$row['tag3'],$row['tag4'],$row['tag5']);
$tage = array(0=>$row['t1'],$row['t2'],$row['t3'],$row['t4'],$row['t5']);
$von=$row['date'];
$bis=$row['bis'];
*/
$sqlstring="select l.*, date_format(l.date,'%d.%m.%Y') as date2,c.short as cat, c.page from changelog as l, sys_categories as c where l.catid=c.id order by date desc limit 0,6";
if(!($result = @ mysql_query($sqlstring)))
showerror();
;
//print(' '.$now[1].' '.$now[2].' '.$row['date']);
while($row = mysql_fetch_array($result, MYSQL_BOTH)):
?>
|
endwhile;
?>
 |
| Zur Übersicht |
|
|
|