$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)