• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Lua Latest TFS-LuaSQL MySQL Bugged?

bncplix

www.MythiaRPG.com
Joined
Mar 30, 2008
Messages
41
Reaction score
0
Well, Luasql-mysql works fine in npcs, such as the banker. But when using it in talk actions (such as deathlist) it bugs, it gets a error saying:
Code:
[04/04/2008  17:32:35] data/talkactions/scripts/deathlist.lua:11: LuaSQL: Error executing query. MySQL: 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 'Brandon Test''' at line 1

And line 11 is:
Code:
local cur = assert(con:execute("SELECT `name`, `id` FROM `players` WHERE `name` = '" .. escapeString(param) .. "';"))

But the banker npc uses basically the same line and it does not get the error

Can anybody help me?
 
trunk is only for testing (at the moment), if you want a stable server use tags/0.2.
 
Back
Top