14 |
|
|
15 |
// fetch news |
// fetch news |
16 |
|
|
17 |
$sth = $dbh->prepare("select id,title from news where type='n' and visible order by id desc limit 5"); |
$sth = $dbh->prepare("select id,title from news where type<>'e' and visible order by date desc limit 5"); |
18 |
$sth->execute(); |
$sth->execute(); |
19 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
20 |
$news[]=$row; |
$news[]=$row; |
21 |
} |
} |
22 |
$smarty->assign("news",$news); |
$smarty->assign("news",$news); |
23 |
|
|
24 |
|
$sth = $dbh->prepare("select id,title from news where type='e' and visible order by priority desc,date desc limit 5"); |
25 |
|
$sth->execute(); |
26 |
|
while ($row=$sth->fetchrow_hash()) { |
27 |
|
$events[]=$row; |
28 |
|
} |
29 |
|
$smarty->assign("events",$events); |
30 |
|
|
31 |
#include("debug.inc"); |
#include("debug.inc"); |
32 |
|
|
33 |
if ($multi_page) { |
if ($multi_page) { |
52 |
} |
} |
53 |
if ($show) { |
if ($show) { |
54 |
$smarty->assign(array( |
$smarty->assign(array( |
55 |
|
"multi_page_show" => 1, |
56 |
"multi_page"=>$multi_page, |
"multi_page"=>$multi_page, |
57 |
"multi_page_current"=>($current+1), |
"multi_page_current"=>($current+1), |
58 |
"multi_page_max"=>$max, |
"multi_page_max"=>$max, |