i'm facing an error with this quest ,,
( unfinished string )
quest top10players begin
state start begin
when 20355.chat." ÊÑÊíÈ ÇááÇÚÈíä " begin
local query=[[
SELECT player.player.name as m_name, player.player.level as m_level, player.player.exp as m_exp
FROM player.player, account.account
WHERE
player.player.name not like '[%]%' AND
date_sub(now(), interval 1 day) < player.player.last_play AND
player.player.account_id=account.account.id AND
account.account.status='OK'
ORDER BY player.player.level DESC, player.player.exp DESC, player.player.name ASC
LIMIT 10;
]]
function escape_sqli(source)
local replacements = { ['"'] = '\\"', ["'"] = "\\'" }
return source:gsub( "['\"]", replacements )
end
local query=escape_sqli(query)
local res1, res2 = mysql_direct_query(query)
say_title("ÇÚáì "..res1.." áÇÚÈíä.")
for num1, str1 in ipairs(res2) do
say_reward(num1.."\t"..str1.m_name.."\t"..str1.m_level.."\t"..str1.m_exp)
end
end
end
end
help will be apprenticed