Code:
local gpoints = db.getResult("SELECT `event_points` FROM 'accounts' WHERE `name` = '" .. getAccountByName(getCreatureName(cid)) .. "' LIMIT 1;")
if(msgcontains(msg, 'points')) then
npcHandler:say("Points: " .. gpoints .. ".", cid)
end
Code:
mysql_real_query(): SELECT `event_points` FROM 'accounts' WHERE `name` = 'fioletowy' LIMIT 1; - MYSQL ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''accounts' WHERE `name` = 'fioletowy' LIMIT 1' at line 1 (1064)
This code is used by npc as you can see. Any ideas how to fix it?
It's mysql 5.5.43, TFS 0.4.