<?php
//definice konstant
   $dir_out = 'compile/';
   $version = '1.1';
   $wow = 'CZ';
   $where = "Vote > 3 AND Language = 1 AND complete = 1";
   $where_sk = "Vote > 3 AND Language = 2 AND complete = 1";
   $limit = '';
   
   $ListFile[0] = array(
     "File" => "QuestDescription_1.lua", 
     "Header" => $wow."WOW_QuestDescription_count=1;".$wow."WOW_QuestDescription_1={", 
     "Footer" => "};if not ".$wow."WOW_QuestDescription then ".$wow."WOW_QuestDescription=0;end;".$wow."WOW_QuestDescription=".$wow."WOW_QuestDescription", 
     "sql" => "SELECT DISTINCT entry, (
 SELECT Details FROM quests as text_cz WHERE text_cz.entry = quests_distric.entry AND Language = 2 AND complete = 1
 ORDER BY vote DESC LIMIT 1
) as cz, (
 SELECT Details FROM quests as text_en WHERE text_en.entry = quests_distric.entry AND Language = 0 LIMIT 1
) as en FROM quests as quests_distric
WHERE $where_sk $limit",
   );
   $ListFile[1] = array(
     "File" => "QuestObjective_1.lua", 
     "Header" => $wow."WOW_QuestObjective_count=1;".$wow."WOW_QuestObjective_1={", 
     "Footer" => "};if not ".$wow."WOW_QuestObjective then ".$wow."WOW_QuestObjective=0; end; ".$wow."WOW_QuestObjective=".$wow."WOW_QuestObjective", 
     "sql" => "SELECT DISTINCT entry, (
 SELECT Objectives FROM quests as text_cz WHERE text_cz.entry = quests_distric.entry AND Language = 2 AND complete = 1
 ORDER BY vote DESC LIMIT 1
) as cz, (
 SELECT Objectives FROM quests as text_en WHERE text_en.entry = quests_distric.entry AND Language = 0 LIMIT 1
) as en FROM quests as quests_distric
WHERE $where_sk $limit", 
   );
   $ListFile[2] = array(
     "File" => "QuestReward_1.lua", 
     "Header" => $wow."WOW_QuestReward_count=1;".$wow."WOW_QuestReward_1={", 
     "Footer" => "};if not ".$wow."WOW_QuestReward then ".$wow."WOW_QuestReward=0; end; ".$wow."WOW_QuestReward=".$wow."WOW_QuestReward", 
     "sql" => "SELECT DISTINCT entry, (
 SELECT OfferRewardText FROM quests as text_cz WHERE text_cz.entry = quests_distric.entry AND Language = 2 AND complete = 1
 ORDER BY vote DESC LIMIT 1
) as cz, (
 SELECT OfferRewardText FROM quests as text_en WHERE text_en.entry = quests_distric.entry AND Language = 0 LIMIT 1
) as en FROM quests as quests_distric
WHERE $where_sk $limit", 
   );
   $ListFile[3] = array(
     "File" => "QuestProgress_1.lua", 
     "Header" => $wow."WOW_QuestProgress_count=1;".$wow."WOW_QuestProgress_1={", 
     "Footer" => "};if not ".$wow."WOW_QuestProgress then ".$wow."WOW_QuestProgress=0; end; ".$wow."WOW_QuestProgress=".$wow."WOW_QuestProgress", 
     "sql" => "SELECT DISTINCT entry, (
 SELECT RequestItemsText FROM quests as text_cz WHERE text_cz.entry = quests_distric.entry AND Language = 2 AND complete = 1
 ORDER BY vote DESC LIMIT 1
) as cz, (
 SELECT RequestItemsText FROM quests as text_en WHERE text_en.entry = quests_distric.entry AND Language = 0 LIMIT 1
) as en FROM quests as quests_distric
WHERE $where_sk $limit", 
   );
   $ListFile[4] = array(
     "File" => "BookPage_1.lua", 
     "Header" => $wow."WOW_BookPage_count=1;".$wow."WOW_BookPage_1={",
     "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 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", 
   );
   
   $sql = '';
   for ($i=0;$i<8 ;++$i ) {
     for ($j=0;$j<2 ;++$j ) {
   	    $sql = $sql."SELECT DISTINCT entry, (
 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 ";
     }
   }
  $sql = substr($sql, 0, strlen($sql)-7);
   $ListFile[5] = array(
     "File" => "NPCText_1.lua", 
     "sql" => $sql, 
     "Header" => $wow."WOW_NPCText_count=1;".$wow."WOW_NPCText_1={",
     "Footer" => "};if not ".$wow."WOW_NPCText then ".$wow."WOW_NPCText=0; end; ".$wow."WOW_NPCText=".$wow."WOW_NPCText", 
   );
   
   //české texty ================================================================
   
   
   $ListFile[6] = array(
     "File" => "QuestDescription_2.lua", 
     "Header" => $wow."WOW_QuestDescription_count=2;".$wow."WOW_QuestDescription_2={", 
     "Footer" => "};if not ".$wow."WOW_QuestDescription then ".$wow."WOW_QuestDescription=0;end;".$wow."WOW_QuestDescription=".$wow."WOW_QuestDescription", 
     "sql" => "SELECT DISTINCT entry, (
 SELECT Details FROM quests as text_cz WHERE text_cz.entry = quests_distric.entry AND Language = 1 AND complete = 1
 ORDER BY vote DESC LIMIT 1
) as cz, (
 SELECT Details FROM quests as text_en WHERE text_en.entry = quests_distric.entry AND Language = 0 LIMIT 1
) as en FROM quests as quests_distric
WHERE $where $limit",
   );
   $ListFile[7] = array(
     "File" => "QuestObjective_2.lua", 
     "Header" => $wow."WOW_QuestObjective_count=2;".$wow."WOW_QuestObjective_2={", 
     "Footer" => "};if not ".$wow."WOW_QuestObjective then ".$wow."WOW_QuestObjective=0; end; ".$wow."WOW_QuestObjective=".$wow."WOW_QuestObjective", 
     "sql" => "SELECT DISTINCT entry, (
 SELECT Objectives FROM quests as text_cz WHERE text_cz.entry = quests_distric.entry AND Language = 1 AND complete = 1
 ORDER BY vote DESC LIMIT 1
) as cz, (
 SELECT Objectives FROM quests as text_en WHERE text_en.entry = quests_distric.entry AND Language = 0 LIMIT 1
) as en FROM quests as quests_distric
WHERE $where $limit", 
   );
   $ListFile[8] = array(
     "File" => "QuestReward_2.lua", 
     "Header" => $wow."WOW_QuestReward_count=2;".$wow."WOW_QuestReward_2={", 
     "Footer" => "};if not ".$wow."WOW_QuestReward then ".$wow."WOW_QuestReward=0; end; ".$wow."WOW_QuestReward=".$wow."WOW_QuestReward", 
     "sql" => "SELECT DISTINCT entry, (
 SELECT OfferRewardText FROM quests as text_cz WHERE text_cz.entry = quests_distric.entry AND Language = 1 AND complete = 1
 ORDER BY vote DESC LIMIT 1
) as cz, (
 SELECT OfferRewardText FROM quests as text_en WHERE text_en.entry = quests_distric.entry AND Language = 0 LIMIT 1
) as en FROM quests as quests_distric
WHERE $where $limit", 
   );
   $ListFile[9] = array(
     "File" => "QuestProgress_2.lua", 
     "Header" => $wow."WOW_QuestProgress_count=2;".$wow."WOW_QuestProgress_2={", 
     "Footer" => "};if not ".$wow."WOW_QuestProgress then ".$wow."WOW_QuestProgress=0; end; ".$wow."WOW_QuestProgress=".$wow."WOW_QuestProgress", 
     "sql" => "SELECT DISTINCT entry, (
 SELECT RequestItemsText FROM quests as text_cz WHERE text_cz.entry = quests_distric.entry AND Language = 1 AND complete = 1
 ORDER BY vote DESC LIMIT 1
) as cz, (
 SELECT RequestItemsText FROM quests as text_en WHERE text_en.entry = quests_distric.entry AND Language = 0 LIMIT 1
) as en FROM quests as quests_distric
WHERE $where $limit", 
   );
   $ListFile[10] = array(
     "File" => "BookPage_2.lua", 
     "Header" => $wow."WOW_BookPage_count=2;".$wow."WOW_BookPage_2={",
     "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 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", 
   );


   $sql = '';
   for ($i=0;$i<8 ;++$i ) {
     for ($j=0;$j<2 ;++$j ) {
   	    $sql = $sql."SELECT DISTINCT entry, (
 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 ";
     }
   }
  $sql = substr($sql, 0, strlen($sql)-7);

   $ListFile[11] = array(
     "File" => "NPCText_2.lua", 
     "Header" => $wow."WOW_NPCText_count=2;".$wow."WOW_NPCText_2={",
     "Footer" => "};if not ".$wow."WOW_NPCText then ".$wow."WOW_NPCText=0; end; ".$wow."WOW_NPCText=".$wow."WOW_NPCText", 
     "sql" => $sql, 
   );

  $define_images[0] = array(
     "File" => "quests", 
     "sql" => "quests", 
     "where" => $where, 
  );
  $define_images[1] = array(
     "File" => "npc_text", 
     "sql" => "npc_text", 
     "where" => $where, 
  );
  $define_images[2] = array(
     "File" => "page_text", 
     "sql" => "page_text", 
     "where" => $where, 
  );
  
  $define_images[3] = array(
     "File" => "quests_sk", 
     "sql" => "quests", 
     "where" => $where_sk, 
  );
  $define_images[4] = array(
     "File" => "npc_text_sk", 
     "sql" => "npc_text", 
     "where" => $where_sk, 
  );
  $define_images[5] = array(
     "File" => "page_text_sk", 
     "sql" => "page_text", 
     "where" => $where_sk, 
  );


$var_g = array(
array('good sir','my lady'),
array('lord','lady'),
array(' lad ',' lass'),
array('brother','sister'),
array('his','her'),
array('he','she'),
array('him','her'),
array('sir','madam'),
array(' men ',' women'),
array(' brotha','sista'),
array('buddy','lady'),
array(' sir ',' madam'),
array(' boy','girl'),
array(' brothers','sisters'),
array('boy','girl'),
array(' man','woman'),
array(' brother','sister'),
array(' men','women'),
array(' sir','miss'),
array(' fella','lady'),
array(' his','her'),
array('himself','herself'),
array('father','mother'),
array(' succubus','infernal'),
array('lad','lass'),
array(' guy','girl'),
array(' brother ',' sister'),
array('priest','priestess'),
array('laddy','lassy'),
array('brothers','sisters'),
array('man','lady'),
array(' him ',' her'),
array(' lad','missy'),
array(' boy ',' girl'),
array(' him','her'),
array('king','queen'),
array(' man ',' woman'),
array('dad','mon'),
array(' mr. ',' ms.'),
array(' fellow ',' sister'),
array(' lord','lady'),
array('mister','missy'),
array('her','him'),
array(' he','she'),
array(' female','male'),
array(' his ',' her'),
array('kráľa','kráľovnej'),
array(' bratře ',' sestro'),
array('pomáhal','pomáhala'),
array('přiložil','přiložila'),
array('mohl','mohla'),
array('našel','našla'),
array('zabil','zabila'),
array('ukázal','ukázala'),
array('vedl','vedla'),
array('přinesl','přinesla'),
array('získal','získala'),
array('ochotný','ochotná'),
array('byl jsi','byla jsi'),
array('dokázal','dokázala'),
array('nasbíral','nasbírala'),
array('udělal','udělala'),
array('počul','počula'),
array('hotový','hotová'),
array('chlapče','dievča'),
array('išiel','išla'),
array('našiel','našla'),
array('urobil','urobila'),
array('postaral','postarala'),
array(' pane ',' madam'),
array(' boyo ',' girly'),
array(' son ',' daughter'),
array(' mister ',' miss'),
array(' jackson ',' princess'),
array(' mister','miss'),
array('waiter','waitress'),
array('laddie ',' lassie'),
array('lad ',' lass'),
array('boyo ',' girlie'),
array('boy ',' girl'),
array(' mon ',' sis'),
array(' master','mistress'),
array('he\'s ',' she\'s'),
array(' guy ',' lady'),
array(' sonny','missy'),
array(' hero ',' heroine'),
array('pal','sugar'),
array(' mladíku ',' děvče'),
array(' mladíku','děvče'),
array('kamaráde','miláčku'),
array('mal','mala'),
array(' bratr ',' sestra'),
);


?>