Changeset 223 for dev/common/admin/admin_navmanager.php

Timestamp:

05/10/07 22:55:06 (15 years ago)

Author:

ralle030583

Message:

Bugfix:
- KBSITE was missing in some selects for generating the admin menue ...

Files:

• dev/common/admin/admin_navmanager.php (modified) (4 diffs)

dev/common/admin/admin_navmanager.php

@@ -33 +33 @@
         repairStatLink();
 }
-//Reading global Navigatio      n Bar
+
 $html .= "<div class=block-header2>Navigation for intern pages</div>";
 $qry = new DBQuery();
-$query = "select * from kb3_navigation WHERE intern = 1;";
+$query = "select * from kb3_navigation WHERE intern = 1 AND KBSITE = '".KB_SITE."';";
 $result = $qry->execute($query);
 
@@ -74 +74 @@
 $html .= "<div class=block-header2>Navigation for extern pages</div>";
 $qry = new DBQuery();
-$query = "select * from kb3_navigation WHERE intern = 0;";
+$query = "select * from kb3_navigation WHERE intern = 0 AND KBSITE = '".KB_SITE."';";
 $result = $qry->execute($query);
 
@@ -136 +136 @@
 $html .= "<div class=block-header2>Order of the pages in Top Navigation Bar</div>";
 $qry = new DBQuery();
-$query = "select * from kb3_navigation WHERE nav_type = 'top' ORDER BY posnr;";
+$query = "select * from kb3_navigation WHERE nav_type = 'top' AND KBSITE = '".KB_SITE."' ORDER BY posnr ;";
 $result = $qry->execute($query);
 
@@ -223 +223 @@
         $row = $qry->getRow();
         $posnr = $row['nr']+1;
-        $query = "INSERT INTO kb3_navigation SET descr='$descr', intern=0, nav_type='top',url='$url', target ='$target', posnr=$posnr, page='ALL_PAGES'";
+        $query = "INSERT INTO kb3_navigation SET descr='$descr', intern=0, nav_type='top',url='$url', target ='$target', posnr=$posnr, page='ALL_PAGES', KBSITE = '".KB_SITE."'";
         $qry->execute($query);
 }