Changeset 222

Timestamp:

05/10/07 22:14:53 (15 years ago)

Author:

ralle030583

Message:

some small modifications cause of now working with KB_SITE

Files:

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

dev/common/admin/admin_navmanager.php

@@ -69 +69 @@
         $class = 'kb-table-row-even';
     }
-        $html .= "<tr class=$class><form action ='?a=admin_navmanager' method='POST'><td colspan = 3><input type='hidden' name='syncStat' value='1'><center><input type='submit' value='Repair Stat Link'></center></td></form></tr>";
+        $html .= "<tr class=$class><form action ='?a=admin_navmanager' method='POST'><td  colspan=2>Statlink must have the name \"Stats\"<br> during repair</td><td><input type='hidden' name='syncStat' value='1'><center><input type='submit' value='Repair Stats'></center></td></form></tr>";
         $html .= "</table>";
 }       
@@ -171 +171 @@
 {
         $qry = new DBQuery();
-        $query = "SELECT posnr FROM kb3_navigation WHERE ID = $id";
+        $query = "SELECT posnr FROM kb3_navigation WHERE ID = $id AND KBSITE = '".KB_SITE."'";
         $qry->execute($query);
         $row = $qry->getRow();
@@ -177 +177 @@
         
         $qry = new DBQuery();
-        $query = "UPDATE kb3_navigation SET posnr = (posnr-1) WHERE nav_type = 'top' AND posnr = $next";
+        $query = "UPDATE kb3_navigation SET posnr = (posnr-1) WHERE nav_type = 'top' AND posnr = $next AND KBSITE = '".KB_SITE."'";
         $qry->execute($query);
         
@@ -187 +187 @@
 {
         $qry = new DBQuery();
-        $query = "SELECT posnr FROM kb3_navigation WHERE ID = $id";
+        $query = "SELECT posnr FROM kb3_navigation WHERE ID = $id AND KBSITE = '".KB_SITE."'";
         $qry->execute($query);
         $row = $qry->getRow();
@@ -193 +193 @@
         
         $qry = new DBQuery();
-        $query = "UPDATE kb3_navigation SET posnr = (posnr+1) WHERE nav_type = 'top' AND posnr = $prev";
-        $qry->execute($query);
-        
-        $qry = new DBQuery();
-        $query = "UPDATE kb3_navigation SET posnr = (posnr-1) WHERE ID = $id    ";
+        $query = "UPDATE kb3_navigation SET posnr = (posnr+1) WHERE nav_type = 'top' AND posnr = $prev AND KBSITE = '".KB_SITE."'";
+        $qry->execute($query);
+        
+        $qry = new DBQuery();
+        $query = "UPDATE kb3_navigation SET posnr = (posnr-1) WHERE ID = $id";
         $qry->execute($query);
 }
@@ -219 +219 @@
 function newPage($descr,$url,$target){
         $qry = new DBQuery();
-        $query = "SELECT max(posnr) as nr FROM kb3_navigation WHERE nav_type='top'";
+        $query = "SELECT max(posnr) as nr FROM kb3_navigation WHERE nav_type='top' AND KBSITE = '".KB_SITE."'";
         $qry->execute($query);
         $row = $qry->getRow();
@@ -241 +241 @@
         }
         $qry = new DBQuery();
-        $query = "UPDATE kb3_navigation SET url ='$statlink' WHERE ID=7";
+        $query = "UPDATE kb3_navigation SET url ='$statlink' WHERE descr='Stats' AND KBSITE = '".KB_SITE."'";
         $qry->execute($query);
 }