php

Startseite NF

<?php

function anzeige_ohne_caption($sql){
$result = db_query_range($sql,0,10);
foreach ($result as $record) {
$node=node_load($record->nid);
$node->title = '';
$anzeige = node_view($node, 'full');
$rendered = render($anzeige);
print $rendered;
echo '<hr />';
}
}

function anzeige($sql,$caption=''){
$result = db_query_range($sql,0,10);
if (($result->rowCount()>0) and ($caption<>'')) {
echo '<hr />';
echo '<h2>'.$caption.'</h2>';
echo '<hr />';
}
foreach ($result as $record) {
$node=node_load($record->nid);
$anzeige = node_view($node, 'teaser');
$rendered = render($anzeige);
print $rendered;
}
}

// Das Intro anzeigen
$sql = "SELECT * FROM {node} WHERE nid=1 ORDER BY created ASC";
anzeige_ohne_caption($sql);

// Die oben in Listen Termine anzeigen
$sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND sticky=1 ORDER BY created ASC";
anzeige($sql,'');

// Die heutigen Termine anzeigen
$sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND sticky=0 AND DATE(FROM_UNIXTIME(created))=CURDATE() ORDER BY created DESC";
anzeige($sql,'Heute in Niederfrohna');

//Zukunft anzeigen 28 Tage
$sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND sticky=0 AND DATE(FROM_UNIXTIME(created))>CURDATE() AND FROM_UNIXTIME(created)<DATE_ADD(CURDATE(),INTERVAL 28 DAY)
ORDER BY created ASC";
anzeige($sql,'Demnächst in Niederfrohna');

//Vergangenheit anzeigen
$sql = "SELECT * FROM {node} WHERE type = 'article' AND status = 1 AND nid<>1 AND promote=1 AND DATE(FROM_UNIXTIME(created))<CURDATE() AND sticky<>1 ORDER BY created DESC";
anzeige($sql,'Das war los in Niederfrohna');

?>

Tags: