Changeset 416 for trunk/user.php

Timestamp:

Oct 7, 2012, 9:30:38 PM (12 years ago)

Author:

chronos

Message:

• Upraveno: Optimalizace zrychlení načítání skupin práv.

File:

• trunk/user.php (modified) (2 diffs)

trunk/user.php

@@ -35 +35 @@
   var $OnlineStateTimeout = 600; // in seconds
   var $PermissionCache = array();
+  var $PermissionGroupCache = array();
 
   function Check()
@@ -194 +195 @@
   function CheckGroupPermission($GroupId, $OperationId)
   {
-    // Check group-group relation
-    $DbResult = $this->Database->select('PermissionGroupAssignment', '*', '`Group`="'.$GroupId.'" AND `AssignedGroup` IS NOT NULL');
-    while($DbRow = $DbResult->fetch_array())
-    {
-       if($this->CheckGroupPermission($DbRow['AssignedGroup'], $OperationId) == true) return(true);
-    }
+    $PermissionExists = false;
+    // First try to check cache group-group relation
+    if(array_key_exists($GroupId, $this->PermissionGroupCache))
+    {
+      $PermissionExists = true; 
+    } else 
+    {          
+      // If no permission combination exists in cache, do new check of database items            
+      $DbResult = $this->Database->select('PermissionGroupAssignment', '*', '`Group`="'.$GroupId.'" AND `AssignedGroup` IS NOT NULL');      
+      $DbRow = array();
+      while($DbRow[] = $DbResult->fetch_array());      
+      $this->PermissionGroupCache[$GroupId] = $DbRow;
+      $PermissionExists = true; 
+    }
+    if($PermissionExists)
+    {
+      foreach($this->PermissionGroupCache[$GroupId] as $DbRow)
+      {
+        if($DbRow['AssignedGroup'] != '')
+        if($this->CheckGroupPermission($DbRow['AssignedGroup'], $OperationId) == true) return(true);
+      }
+    }
+
 
     // Check group-operation relation