Changeset 38 for branches/3/class/translation.php

Timestamp:

Nov 25, 2008, 5:12:10 PM (15 years ago)

Author:

maron

Message:

Struktura databáze

File:

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

branches/3/class/translation.php

@@ -7 +7 @@
   
         // constructor
-        function translation($id, $database, $GetText = true)
+        function translation($id, $database, $Gettext = true)
         { // BEGIN constructor
                 $this->id = $id;
                 $this->database = $database;
                 $this->GetData();
-                if ($GetText and isset($this->data)) $this->GetText();
+                if ($Gettext and isset($this->data)) $this->Gettext();
         } // END constructor
         
         function GetData()
     { // BEGIN function GetData
-      $Query = $this->database->query('SELECT *,(SELECT Id FROM `TextGroup` WHERE
+      $Query = $this->database->query('SELECT *,(SELECT Id FROM `textGroup` WHERE
        `Index` = `cz`.`Index` AND `Group` = `cz`.`Group` AND `Language` = 1)
-        as en_Id FROM TextGroup as cz WHERE Id="'.$this->id.'"');
+        as en_Id FROM textGroup as cz WHERE Id="'.$this->id.'"');
       if($Query->num_rows > 0) {
         $Row = $Query->fetch_array();
@@ -34 +34 @@
     } // END function SetData
         
-        function GetText()
-    { // BEGIN function GetText
-        $Query = $this->database->query("SELECT `Text`,`Translation`.`Name`, `Translation`.`MangosColumn` FROM `Text`
-JOIN `Translation` ON `Translation`.`Id` = `Text`.`GroupItem`
- WHERE `TranslationGroup` = ".$this->id."");
+        function Gettext()
+    { // BEGIN function Gettext
+        $Query = $this->database->query("SELECT `text`,`translation`.`Name`, `translation`.`MangosColumn` FROM `text`
+JOIN `translation` ON `translation`.`Id` = `text`.`GroupItem`
+ WHERE `translationGroup` = ".$this->id."");
         while ($Row = $Query->fetch_array()) {
-                $this->text[$Row['Name']] = $Row['Text'];
+                $this->text[$Row['Name']] = $Row['text'];
         }        
         $this->data['text'] = $this->text;
-    } // END function GetText
+    } // END function Gettext
         
   } // END class translation