Changeset 208

Timestamp:

Nov 10, 2006 6:27:36 AM (18 years ago)

Author:

scdev

Message:

Q -fixed sorting bug in ACL.inc.php

Location:

trunk

Files:

• bin/acl.cli.php (modified) (2 diffs)
• lib/ACL.inc.php (modified) (1 diff)

trunk/bin/acl.cli.php

@@ -1 @@
-#!/usr/local/bin/php
+#!/usr/bin/php
 <?php
 /*
@@ -341 +341 @@
         LEFT JOIN aco_tbl ON (acl_tbl.aco_id = aco_tbl.aco_id)
         LEFT JOIN axo_tbl ON (acl_tbl.axo_id = axo_tbl.axo_id)
-        ORDER BY aro_tbl.aro_id ASC, aco_tbl.aco_id ASC, axo_tbl.axo_id ASC
+        ORDER BY aro_tbl.lft ASC, aco_tbl.lft ASC, axo_tbl.lft ASC
     ");
     echo "\n";

trunk/lib/ACL.inc.php

@@ -642 +642 @@
                 AND (aco_tbl.lft <= (SELECT lft FROM aco_tbl WHERE name = '" . $db->escapeString($aco) . "') AND aco_tbl.rgt >= (SELECT rgt FROM aco_tbl WHERE name = '" . $db->escapeString($aco) . "'))
                 AND (axo_tbl.lft <= (SELECT lft FROM axo_tbl WHERE name = '" . $db->escapeString($axo) . "') AND axo_tbl.rgt >= (SELECT rgt FROM axo_tbl WHERE name = '" . $db->escapeString($axo) . "'))
-                ORDER BY aro_tbl.aro_id DESC, aco_tbl.aco_id DESC, axo_tbl.axo_id DESC
+                ORDER BY aro_tbl.lft DESC, aco_tbl.lft DESC, axo_tbl.lft DESC
                 LIMIT 1
             ");