Jump to content

[ERROR] unfinished string , ranking quest .


Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.