/[pliva-si]/inc/common.inc
This is repository of my old source code which isn't updated any more. Go to git.rot13.org for current projects!
ViewVC logotype

Diff of /inc/common.inc

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.1.1.1 by ravilov, Mon Jun 25 09:57:25 2001 UTC revision 1.6 by dpavlin, Mon Jul 2 06:55:32 2001 UTC
# Line 4  global $smarty,$dbh; Line 4  global $smarty,$dbh;
4    
5  // fetch menu  // fetch menu
6    
7  $sth = $dbh->prepare("select item,url,file from menu where section='$section' order by num");  if (!isset($m)) {
8            $m=$section;
9    } else {
10            $smarty->assign("m_session","m=$m&");
11            $smarty->assign("m_form_session","<input type=\"hidden\" name=\"m\" value=\"$m\">");
12    }
13    
14    $sth = $dbh->prepare("select item,url,file,w,h from menu where section='$m' and visible order by num");
15  $sth->execute();  $sth->execute();
16  while ($row=$sth->fetchrow_hash()) {  while ($row=$sth->fetchrow_hash()) {
17          $menu[]=$row;          $menu[]=$row;
# Line 14  $smarty->assign("menu",$menu); Line 21  $smarty->assign("menu",$menu);
21    
22  // fetch news  // fetch news
23    
24  $sth = $dbh->prepare("select id,title from news where type<>'e' and type<>'p' and visible order by date desc limit 5");  $sth = $dbh->prepare("select id,title from news where substr(type,1,1)='n' and visible order by date desc limit 5");
25  $sth->execute();  $sth->execute();
26  while ($row=$sth->fetchrow_hash()) {  while ($row=$sth->fetchrow_hash()) {
27          $news[]=$row;          $news[]=$row;
28  }  }
29  $smarty->assign("news",$news);  $smarty->assign("news",$news);
30    
31  $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 substr(type,1,1)='e' and visible order by priority desc,date desc limit 5");
32  $sth->execute();  $sth->execute();
33  while ($row=$sth->fetchrow_hash()) {  while ($row=$sth->fetchrow_hash()) {
34          $events[]=$row;          $events[]=$row;

Legend:
Removed from v.1.1.1.1  
changed lines
  Added in v.1.6

  ViewVC Help
Powered by ViewVC 1.1.26