Changeset 8 for branches/2/translation.php

Timestamp:

May 9, 2008, 10:39:00 AM (17 years ago)

Author:

george

Message:

Přidáno: Oprávnění pro čtení a zápis k rolím a operacím.
Přidáno: Zobrazení matice oprávnění.
Přidáno: Uživatelské menu s proměnným obsahem podle role uživatele.
Upraveno: Rozdělení importu na import z mangosu a import ze staré databáze.

File:

• branches/2/translation.php (modified) (3 diffs)

branches/2/translation.php

@@ -6 +6 @@
   {
     $Result = array();
-    $DbResult = $this->Database->select('TranslationGroup', '*');
+    $DbResult = $this->Database->query('SELECT `TranslationGroup`.*, (SELECT COUNT(*) FROM `TextGroup` WHERE `TextGroup`.`Group` = `TranslationGroup`.`Id`) AS `TextCount` FROM `TranslationGroup`');
     while($DbRow = $DbResult->fetch_array())
     {
@@ -44 +44 @@
   {
     $Result = array();
-    $DbResult = $this->Database->query('SELECT `TextGroup`.*, (SELECT `Text` FROM `Text` WHERE `Text`.`TranslationGroup` = `TextGroup`.`Id` LIMIT 1) as `Text` FROM `TextGroup`  WHERE `TextGroup`.`Group`='.$GroupId.' AND `TextGroup`.`User`='.$UserId.' AND `TextGroup`.`Language`='.$Language.' LIMIT '.($Page * $ItemPerPage).','.$ItemPerPage);
+    $DbResult = $this->Database->query('SELECT `TextGroup`.*, (SELECT `Text` FROM `Text` WHERE `Text`.`TranslationGroup` = `TextGroup`.`Id` LIMIT 1) as `Text`, (SELECT COUNT(`TextGroup2`.`User`) FROM `TextGroup` AS `TextGroup2` WHERE `TextGroup2`.`Id` = `TextGroup`.`Id`) as `TextCount` FROM `TextGroup` WHERE `TextGroup`.`Group`='.$GroupId.' AND `TextGroup`.`User`='.$UserId.' AND `TextGroup`.`Language`='.$Language.' LIMIT '.($Page * $ItemPerPage).','.$ItemPerPage);
     //echo($this->Database->LastQuery);
     if($DbResult->num_rows > 0)
@@ -62 +62 @@
     return($DbRow[0]);
   }
+
+  function GetMultipleText($GroupId, $Index)
+  {
+    $Result = array();
+    $DbResult = $this->Database->query('SELECT `TextGroup`.*, (SELECT `Text` FROM `Text` WHERE `Text`.`TranslationGroup` = `TextGroup`.`Id` LIMIT 1) as `Text` FROM `TextGroup` WHERE `TextGroup`.`Group`='.$GroupId.' AND `TextGroup`.`Index` = '.$Index.' AND `TextGroup`.`Language` != 1');
+    //echo($this->Database->LastQuery);
+    if($DbResult->num_rows > 0)
+    while($DbRow = $DbResult->fetch_array())
+    {
+      $Result[] = $DbRow;
+    }
+    return($Result);
+  }
 }