1 |
<? |
<? |
2 |
|
|
3 |
global $smarty,$dbh; |
global $smarty,$dbh,$visible_is_true; |
4 |
|
|
5 |
|
// just to be on safe side |
6 |
|
if (! isset($visible_is_true)) { |
7 |
|
$visible_is_true="visible is true"; |
8 |
|
} |
9 |
|
|
10 |
// fetch menu |
// fetch menu |
11 |
|
|
12 |
$sth = $dbh->prepare("select item,url,file from menu where section='$section' order by num"); |
$sth = $dbh->prepare("select item,url,file from menu where section='$section' and $visible_is_true order by num"); |
13 |
$sth->execute(); |
$sth->execute(); |
14 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
15 |
$menu[]=$row; |
$menu[]=$row; |
19 |
|
|
20 |
// fetch news |
// fetch news |
21 |
|
|
22 |
$sth = $dbh->prepare("select id,title from news where type<>'e' and visible order by date desc limit 5"); |
$sth = $dbh->prepare("select id,title from news where type<>'e' and type<>'p' and $visible_is_true order by date desc limit 5"); |
23 |
$sth->execute(); |
$sth->execute(); |
24 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
25 |
$news[]=$row; |
$news[]=$row; |
26 |
} |
} |
27 |
$smarty->assign("news",$news); |
$smarty->assign("news",$news); |
28 |
|
|
29 |
$sth = $dbh->prepare("select id,title from news where type='e' and visible order by priority desc,date desc limit 5"); |
$sth = $dbh->prepare("select id,title from news where type='e' and $visible_is_true order by priority desc,date desc limit 5"); |
30 |
$sth->execute(); |
$sth->execute(); |
31 |
while ($row=$sth->fetchrow_hash()) { |
while ($row=$sth->fetchrow_hash()) { |
32 |
$events[]=$row; |
$events[]=$row; |