Changeset 6 for branches/2/translation.php

Timestamp:

May 8, 2008, 8:48:00 PM (17 years ago)

Author:

george

Message:

Přidáno: Zobrazení prvních textů v seznamu položek ve skupinách.

File:

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

branches/2/translation.php

@@ -41 +41 @@
   }
 
-  function GetTextGroupList($GroupId, $UserId, $Language)
+  function GetTextGroupList($GroupId, $UserId, $Language, $Page, $ItemPerPage)
   {
     $Result = array();
-    $DbResult = $this->Database->select('TextGroup', '*', '`Group`='.$GroupId.' AND `User`='.$UserId.' AND `Language`='.$Language);
+    $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);
     //echo($this->Database->LastQuery);
     if($DbResult->num_rows > 0)
@@ -54 +54 @@
   }
 
+  function GetTextGroupListCount($GroupId, $UserId, $Language)
+  {
+    $Result = array();
+    $DbResult = $this->Database->select('TextGroup', 'COUNT(*)', '`Group`='.$GroupId.' AND `User`='.$UserId.' AND `Language`='.$Language);
+    //echo($this->Database->LastQuery);
+    $DbRow = $DbResult->fetch_array();
+    return($DbRow[0]);
+  }
 }