source: client_files/poznámky.txt

$g man : woman; .....           "..gsub(gsub(UnitSex("player"), "^2$", "man"), "^3$", "woman").."

$n ....  "..strlower(UnitName("player")).."
$c ....  "..strlower(UnitClass("player")).."
$r ....  "..strlower(UnitRace("player")).."
$b ....   odřádkování \r\n ,  v hledaném textu nic
odentrování v page_textu změnit na \r\n

Bez mezer:
==========
QuestDescription_1.lua 
----------------------

  RUWOW_QuestDescription_count=1;
  RUWOW_QuestDescription_1={
    ["ajtext"]="překlad",["ajtext"]="překlad"
  };
  if not RUWOW_QuestDescription then RUWOW_QuestDescription=0;end;RUWOW_QuestDescription=RUWOW_QuestDescription+400;



NPCText_1.lua
-------------

RUWOW_NPCText_count=1;
RUWOW_NPCText_1={
[""]="",[""
};
if not RUWOW_NPCText then RUWOW_NPCText=0; end; RUWOW_NPCText=RUWOW_NPCText+999;

BookPage_1.lua
--------------

RUWOW_BookPage_count=1;
RUWOW_BookPage_1={
[""]=""
};if not RUWOW_BookPage then RUWOW_BookPage=0; end; RUWOW_BookPage=RUWOW_BookPage+448;


select:


SELECT quests_cz.entry, quests_cz.details as cz, quests_en.details as en
FROM `quests` as quests_cz JOIN quests as quests_en ON quests_cz.entry = quests_en.entry AND quests_en.Language=0
WHERE quests_cz.Language=1

spíš

"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"

na naplnění databáze dalšími questy 

SELECT * FROM mangos.quest_template as mangos_quests
 WHERE NOT EXISTS (SELECT * FROM quests.quests WHERE quests.quests.entry=mangos_quests.entry)