Changeset 61 for trunk/client_files/Generate/define.php

Timestamp:

Feb 4, 2009, 9:51:34 PM (16 years ago)

Author:

george

Message:

• Přidáno: Export překladů do českého WoW Addonu.
• Upraveno: Export souborů se nyní ukládá samostatně do složek dle jmen uživatelů.
• Přidáno: Zobrazování chyb dle konfigurace.

File:

• trunk/client_files/Generate/define.php (modified) (4 diffs)

trunk/client_files/Generate/define.php

@@ -61 +61 @@
      "Footer" => "};if not ".$wow."WOW_BookPage then ".$wow."WOW_BookPage=0; end; ".$wow."WOW_BookPage=".$wow."WOW_BookPage", 
      "sql" => "SELECT DISTINCT entry, (
- SELECT Text FROM page_text as text_cz WHERE text_cz.entry = page_text_distric.entry AND Language = 2 AND complete = 1
- ORDER BY vote DESC LIMIT 1
-) as cz, (
- SELECT Text FROM page_text as text_en WHERE text_en.entry = page_text_distric.entry AND Language = 0 LIMIT 1
-) as en FROM page_text as page_text_distric
+ SELECT Text FROM page as text_cz WHERE text_cz.entry = page_text_distric.entry AND Language = 2 AND complete = 1
+ ORDER BY vote DESC LIMIT 1
+) as cz, (
+ SELECT Text FROM page as text_en WHERE text_en.entry = page_text_distric.entry AND Language = 0 LIMIT 1
+) as en FROM page as page_text_distric
 WHERE $where_sk $limit", 
    );
@@ -73 +73 @@
      for ($j=0;$j<2 ;++$j ) {
             $sql = $sql."SELECT DISTINCT entry, (
- SELECT text".$i."_$j FROM npc_text as text_cz WHERE text_cz.entry = npc_text_distric.entry AND Language = 2 AND complete = 1
- ORDER BY vote DESC LIMIT 1
-) as cz, (
- SELECT text".$i."_$j FROM npc_text as text_en WHERE text_en.entry = npc_text_distric.entry AND Language = 0 LIMIT 1
-) as en FROM npc_text as npc_text_distric
+ SELECT text".$i."_$j FROM npc as text_cz WHERE text_cz.entry = npc_text_distric.entry AND Language = 2 AND complete = 1
+ ORDER BY vote DESC LIMIT 1
+) as cz, (
+ SELECT text".$i."_$j FROM npc as text_en WHERE text_en.entry = npc_text_distric.entry AND Language = 0 LIMIT 1
+) as en FROM npc as npc_text_distric
 WHERE $where $limit   UNION ";
      }
@@ -145 +145 @@
      "Footer" => "};if not ".$wow."WOW_BookPage then ".$wow."WOW_BookPage=0; end; ".$wow."WOW_BookPage=".$wow."WOW_BookPage", 
      "sql" => "SELECT DISTINCT entry, (
- SELECT Text FROM page_text as text_cz WHERE text_cz.entry = page_text_distric.entry AND Language = 1 AND complete = 1
- ORDER BY vote DESC LIMIT 1
-) as cz, (
- SELECT Text FROM page_text as text_en WHERE text_en.entry = page_text_distric.entry AND Language = 0 LIMIT 1
-) as en FROM page_text as page_text_distric
+ SELECT Text FROM page as text_cz WHERE text_cz.entry = page_text_distric.entry AND Language = 1 AND complete = 1
+ ORDER BY vote DESC LIMIT 1
+) as cz, (
+ SELECT Text FROM page as text_en WHERE text_en.entry = page_text_distric.entry AND Language = 0 LIMIT 1
+) as en FROM page as page_text_distric
 WHERE $where $limit", 
    );
@@ -158 +158 @@
      for ($j=0;$j<2 ;++$j ) {
             $sql = $sql."SELECT DISTINCT entry, (
- SELECT text".$i."_$j FROM npc_text as text_cz WHERE text_cz.entry = npc_text_distric.entry AND Language = 1 AND complete = 1
- ORDER BY vote DESC LIMIT 1
-) as cz, (
- SELECT text".$i."_$j FROM npc_text as text_en WHERE text_en.entry = npc_text_distric.entry AND Language = 0 LIMIT 1
-) as en FROM npc_text as npc_text_distric
+ SELECT text".$i."_$j FROM npc as text_cz WHERE text_cz.entry = npc_text_distric.entry AND Language = 1 AND complete = 1
+ ORDER BY vote DESC LIMIT 1
+) as cz, (
+ SELECT text".$i."_$j FROM npc as text_en WHERE text_en.entry = npc_text_distric.entry AND Language = 0 LIMIT 1
+) as en FROM npc as npc_text_distric
 WHERE $where $limit   UNION ";
      }