Changeset 153 for www/temp/transform.php

Timestamp:

Feb 16, 2009, 6:16:00 PM (15 years ago)

Author:

george

Message:

• Přidáno: Zobrazování chyb v SQL povelech. Nastavení v konfigureaci.
• Upraveno: Zpřístupnění stavu financí dle ip i dle přihlášení.

File:

• www/temp/transform.php (modified) (6 diffs)

www/temp/transform.php

@@ -105 +105 @@
   function SubjectOpenTime()
   {
-    $this->Database->query('DELETE FROM Subject WHERE Subject.Id = SubjectOpenTime.Subject');
-    $this->Database->query('TRUNCATE TABLE SubjectOpenTime');
-    $this->Database->query('TRUNCATE TABLE SubjectOpenTimeInterval');
+    //$this->Database->query('DELETE FROM `Subject` WHERE `Subject`.`Id` = (SELECT `Subject` FROM `SubjectOpenTime`)');
+    $this->Database->query('TRUNCATE TABLE `SubjectOpenTime`');
+    $this->Database->query('TRUNCATE TABLE `SubjectOpenTimeInterval`');
     foreach($this->Subjects as $SubjectName => $Subject)
     {
@@ -159 +159 @@
     $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupOthers, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
 
+    $this->Database->insert('PermissionOperation', array('Module' => 'News', 'Operation' => 'Display', 'Item' => 'Item'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupOthers, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
     $DbResult = $this->Database->select('news_category', 'id, permission');
     while($DbRow = $DbResult->fetch_array())
@@ -167 +171 @@
       $OperationIdDisplay = $this->Database->insert_id;
       $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupOthers, 'GroupOrOperation' => $OperationIdDisplay, 'Type' => 'Operation'));
-      if($DbRow['permission'] == 1)
-      {
-        $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupNetworkAdmins, 'GroupOrOoperation' => $OperationIdInsert, 'Type' => 'Operation'));
+      if($DbRow['permission'] == 0)
+      {
+        $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupNetworkAdmins, 'GroupOrOperation' => $OperationIdInsert, 'Type' => 'Operation'));
       } else
       {
@@ -189 +193 @@
 
     $this->Database->insert('PermissionOperation', array('Module' => 'EatingPlace', 'Operation' => 'Edit'));
-    $OperationId = $this->Database->insert_id;
-    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupMembers, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+    //$OperationId = $this->Database->insert_id;
+    //$this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupMembers, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
 
     $this->Database->insert('PermissionOperation', array('Module' => 'Finance', 'Operation' => 'Manage'));
@@ -207 +211 @@
     $OperationId = $this->Database->insert_id;
     $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupNetworkAdmins, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
+
+    $this->Database->insert('PermissionOperation', array('Module' => 'Network', 'Operation' => 'RegistredHostList'));
+    $OperationId = $this->Database->insert_id;
+    $this->Database->insert('PermissionGroupAssignment', array('Group' => $PermissionGroupSubjects, 'GroupOrOperation' => $OperationId, 'Type' => 'Operation'));
 
     // Init User table from users
@@ -212 +220 @@
     while($DbRow = $DbResult->fetch_array())
     {
-      $this->Database->insert('User', array('Id' => $DbRow['id'], 'Name' => $DbRow['nick'], 'FirstName' => $DbRow['first_name'], 'SecondName' => $DbRow['second_name'], 'PhoneNumber' => $DbRow['phone'], 'Password' => substr(sha1(strtoupper($DbRow['nick'])), 0, 7), 'ICQ' => $DbRow['icq'], 'Email' => $DbRow['email'], 'Locked' => 0));
+      $this->Database->insert('User', array('Id' => $DbRow['id'], 'Name' => $DbRow['nick'], 'FirstName' => $DbRow['first_name'], 'SecondName' => $DbRow['second_name'], 'PhoneNumber' => $DbRow['phone'], 'Password' => substr(sha1(strtoupper($DbRow['nick'])), 0, 70), 'ICQ' => $DbRow['icq'], 'Email' => $DbRow['email'], 'Locked' => 0));
       $UserId = $this->Database->insert_id;
       if($DbRow['id'] == 1)